See other homes in:
Primary listing photo
Listing photo 2
Listing photo 3
Listing photo 4
Listing photo 5

404 Shamrock Dr, Campbell, CA, 95008

4beds
3baths
2,344sqft
$2,479,000
$1,058price/sqft
$16,024/moest. monthly cost
$640,960/yrincome needed

About This Home

Incredible value! Includes a spacious main house (1,784 sq ft) + detached ADU (560 sq ft) = 2,344 total sqft. You must see this magical property! A charming ranch-style home nestled on a generous 10,500 sq ft lot in beautiful and sought-after Campbell. The main home boasts 3 spacious bedrooms and 2 well appointed bathrooms. Upon entering, you'll be captivated by the open floorplan that seamlessly blends living and dining areas, providing an ideal setting for both relaxation and entertaining. The kitchen is a chef's dream, with modern amenities that inspire culinary creativity. Terracotta floors flow throughout the living areas, adding warmth and elegance to the home. The oasis-like backyard is perfect for California living with a sparkling pool, mature trees, office/workout shed & attractive landscaping. The result is a private sanctuary for outdoor enjoyment that will delight you AND your guests! The stylish 1-bedroom ADU and attached storage shed is fully permitted and was recently built to include an open living room, kitchen and dining area plus a spacious bed & bath with washer and dryer. The attached storage is fantastic! Located just minutes from downtown Campbell, Pruneyard shopping center, and major freeway access. Fantastic Cambrian schools and Branham High!

Getting Around

63
WalkingSomewhat Walkable
38
TransitSome Transit
87
BikeVery Bikeable

Schools

8/10
Farnham Charter SchoolGrades K-50.6 mi
9/10
9/10
Branham High SchoolGrades 9-122.6 mi

Construction

Condition

  • Year built: 1947

Materials

  • Foundation: Concrete Perimeter and Slab
  • Roof: Composition

Type & Style

  • Home type: SingleFamily
  • Property subType: Single Family Residence,Residential

Interior

Appliances

  • Appliances included: Gas Cooktop,Dishwasher,Disposal,Microwave,Built In Oven,Refrigerator,Washer/Dryer
  • Laundry features: Inside

Bathroom

  • Features: DoubleSinks, PrimaryTubwJets, ShowerandTub, StallShower, Tile

Bedrooms & Bathrooms

  • Bedrooms: 4
  • Bathrooms: 3
  • Full bathrooms: 3

Dining Room

  • Features: DiningArea, EatinKitchen

Family Room

  • Features: NoFamilyRoom

Features

  • Flooring: Carpet,Laminate,Stone,Wood
  • Number of fireplaces: 2
  • Fireplace features: Gas,Living Room,Primary Bedroom

Heating & Cooling

  • Heating features: Central Forced Air
  • Cooling features: Central Air

Interior Area

  • Total structure area: 2,344
  • Total interior livable area: 2,344 sqft

Kitchen

  • Features: Island

Property

Details

  • Parcel number: 41404034
  • Zoning: R1-8
  • Special condition: Standard

Features

  • Stories: 1
  • Pool features: In Ground
  • Exterior features: Back Yard,Barbecue,Fenced,Storage Shed Structure
  • Spa features: Other
  • Fencing: Wood

Lot

  • Lot size: 10,500 sqft
  • Features: Level

Parking

  • Total spaces: 5
  • Parking features: Parking Area

Climate Risk is Financial Risk

Every home has a financial story beyond the listing price. Below, you’ll see the climate risks that could affect this property — and in Bills & Affordability, how those risks may influence repairs, insurance, utilities, and long-term value.

Biggest Threats for This Home

  • Earthquake
    EarthquakeRelatively High
  • Inland Flooding
    Inland FloodingRelatively High
  • Heat Wave
    Heat WaveModerate

How This Home’s Risks Compare

Earthquake
Inland Flooding
Heat Wave

FEMA Declared Disasters in Santa Clara County and California

Earthquake
Flood
Mud Landslide
Severe Ice Storm
Severe Storm
Snowstorm
Straight Line Winds
Tropical Storm
Winter Storm

Understanding the Costs

Financial advisors generally recommend spending no more than 30% of your gross household income on housing costs. In practice, many households stretch to 35% or beyond — especially in high-cost markets.

Estimated Costs Today

MonthlyAnnual
Mortgage $12,535$150,420
Home Insurance *$174$2,088
Property Taxes $2,813$33,756
Electricity $502$6,031
Total$16,024$192,288
*Does not include cost of any FAIR Plan premiums

Income You'd Need if You Spent...

35% on housing$549,394/yr
40% on housing$480,720/yr
45% on housing$427,306/yr

California FAIR Plan Programs

California FAIR Plan Association

Covered
WildfireWildfire
Visit Website →
Current Policies
Residential: 417,310Commercial: 13,990
Total Premiums$1.42B
Total Exposure$429.84B

How Costs Could Change Over Time

Climate risk is quickly impacting all of the major home ownership costs. Adjust the growth rates and percentage of income spent on housing below to see how your housing costs could change over the next 10 years — and what income you'd need to keep up.

Insurance Growth Rate5-year average: 7.1%
7.1%
0%30.0%
Electricity Growth Rate10-year average: 4.3%
4.3%
0%15.0%
Property Taxes Growth Rate2-year average: 1.0%
1.0%
0%15.0%
Income Spent on Housing
30%
30%45%

Comparing Against the Market

Price Per Sq Ft

$1,058This listing

vs Other Active Listings

Avg $/sqft

ZIP 95008$834
Santa Clara County$789

vs Homes Sold Last Month

Median $/sqft

ZIP 95008$1,264
Santa Clara County$1,052

Current Market Trends

Median Price Per Square Foot

The median price per square foot of homes sold in this area each month. Compare this to this listing's price per square foot to gauge whether the home is priced in line with recent sales.

Historicals for This Listing

Zestimate History ($/sqft)

Price History

DateEventPrice
2026-05-11Price change$2,299,999
2026-04-16Price change$2,479,000
2026-03-07Listed for sale$2,599,000
2013-10-24Sold$889,000
2013-10-02Pending sale$889,000
2013-09-21Listed for sale$889,000

For Sale by Agent

AgentJennifer Friess
BrokerageCompass

Similar Homes