404 Shamrock Drive, Campbell, California 95008, Campbell, 95008 - 4 bed, 3 bath
Loading property details...
Campbell, California 95008
This Renovated Ranch-Style Residence is a High-Potential Investment Opportunity, listed at $2,479,000—positioned well below the $2,509,340 Fair Market Value by 1%. This valuation gap provides $30,340 in Instant Equity. Boasting a Mint Condition Rating, the property features a remodeled chef’s kitchen, sparkling pool, and a 560 sq ft income-generating ADU on an expansive 10,500 sq ft lot. Located near Downtown Campbell and served by top-rated schools like Branham High, this home balances luxury with financial upside. It is an ideal acquisition for Owner-Occupants or Savvy Investors.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 404 Shamrock Drive Subject | $2,479,000* List Price | 4 | 3 | 1,784 | $1,407 | - |
A 956 Norin Court Sold | $2,625,000 | 4 | 3 | 2,157 | $1,217 | 0.3 mi |
B 1185 Normandy Drive Active | $2,748,000 List Price | 4 | 4 | 2,490 | $1,104 | 0.1 mi |
* Subject property listed price vs sold prices of comps.
Property is new construction or fully renovated.
Although originally built in 1947, the property has undergone significant recent renovations, including a newly remodeled chef's kitchen with high-end stainless steel appliances and the addition of a modern 560 sq ft ADU. The presence of solar panels, updated track lighting, skylights, and pristine terracotta flooring indicates well-maintained systems and a move-in ready, mint-condition interior.
The property has a large lot size, which is more than 4 times of its living area. lot size in square feet = 10500, living area = 1784.
The property includes a fully-equipped, 560 sq ft one-bedroom ADU with its own kitchen and laundry, providing excellent potential for rental income or multi-generational living.
Situated on a generous 10,500 sq ft lot, the backyard features a sparkling pool, mature landscaping, and a separate office shed, offering a rare level of privacy and utility for the area.
Living area discrepancy between mls listing and other public or private record. mls listing living area = 1784, other record living area = 1659. Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 4, other record bedroom count = 3.
Originally built in 1947, the property may have underlying aged systems or structural elements that require more maintenance compared to newer constructions in the neighborhood.
A recent price reduction from the original list price suggests the property is currently navigating a price discovery phase, which may lead to concerns regarding its initial valuation.
Welcome to 404 Shamrock Drive, a charming ranch-style home nestled on a generous 10,500 sq ft lot in the vibrant community of Campbell. This delightful property boasts three spacious bedrooms and two well appointed bathrooms within its 1,784 square feet of living space. Upon entering, you'll be captivated by the open great room that seamlessly blends living and dining areas, providing an ideal setting for both relaxation and entertaining. The newly remodeled kitchen is a chef's dream, featuring modern amenities that inspire culinary creativity. Beautiful terracotta floors flow throughout the main living areas, adding warmth and elegance to the home. The office space offers a quiet retreat for work or study, while the oasis-like backyard beckons with a sparkling pool, mature trees, Office Shed & stunning landscaping, creating a private sanctuary for outdoor enjoyment.The property also includes a gorgeous one-bedroom, 560 sq foot ADU, perfect for hosting guests or generating income through Airbnb. The ADU includes an open living room, kitchen and dining area plus a spacious bedroom & bathroom with washer and dryer. Located just minutes from downtown Campbell, Pruneyard shopping center, and major freeway access, this residence offers both tranquility and convenience.
No exterior & parking available.
Grades K-5 • 1.3 mi
Grades 9-12 • 2.1 mi
Grades 9-12 • 2.5 mi
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 4.0 | 4.0 | 50% |
| Baths | 3.0 | 2.5 | 50% |
| Square foot | 1,784 | 1,763 | 53% |
| Lot Size | 10,500 | 7,751 | 82% |
| Price | $2.48M | $2.18M | 62% |
| Price per sq ft | $1.4K | $1.2K | 74% |
| Built year | 1947 | 1961 | 18% |
| HOA | $0 | $0 | 50% |
| Days on market | 47 | 147 | 9% |
Apr 18, 2026
$2,479,000
$2,599,000
-5% Price Drop
Initial Listing
Mar 6, 2026
$2,599,000
Initial Listing
Oct 24, 2013
$889,000
Public Record