$2,299,999
PENDING $299K PRICE DROP

404 Shamrock Dr Campbell, CA 95008

Estimated payment $13,752/month

Total Views 7,009
4 Beds
3 Baths
2,344 Sq Ft
$981 Price per Sq Ft

Highlights

  • In Ground Pool
  • Fireplace in Primary Bedroom
  • Outdoor Kitchen
  • Branham High School Rated A
  • Wood Flooring
  • Jetted Tub in Primary Bathroom

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!

Listing Agent

Jennifer Friess

Compass License #01916722 Listed on: 03/06/2026

Compass

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1947

Lot Details

  • Wood Fence
  • Level Lot
  • Sprinklers on Timer
  • Back Yard
  • Zero Lot Line
  • Zoning described as R1-8

Parking

  • 5 Parking Spaces

Home Design

  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,344 Sq Ft Home
  • 1-Story Property
  • Gas Fireplace
  • Living Room with Fireplace
  • 2 Fireplaces
  • Dining Area
  • Den
  • Storage Room

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Laminate
  • Stone

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • 3 Full Bathrooms
  • Dual Sinks
  • Jetted Tub in Primary Bathroom
  • Bathtub with Shower
  • Bathtub Includes Tile Surround
  • Walk-in Shower

Laundry

  • Laundry in unit
  • Washer and Dryer

Pool

  • In Ground Pool
  • In Ground Spa

Outdoor Features

  • Outdoor Kitchen
  • Shed
  • Barbecue Area

Utilities

  • Forced Air Heating and Cooling System

Listing and Financial Details

  • Assessor Parcel Number 414-04-034

Home Details

Home Type

Single Family

Year Built

Built in 1947

Lot Details

10,498 Sq Ft Lot

Listing Details

  • Subclass: Single Family Home
  • Listing Class: Residential
  • Structure Sq Ft: 2344
  • Year Built: 1947
  • Zoning Description: R1-8
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: No Family Room
  • Fireplace: Gas Burning, Living Room, Primary Bedroom
  • Dining Room: Dining Area, Eat in Kitchen
  • Kitchen: Cooktop - Gas, Countertop - Quartz, Dishwasher, Garbage Disposal, Island, Microwave, Oven - Built-In, Refrigerator
  • Living Sq Ft: 2344
  • Stories: 1
  • Laundry: Inside, Washer / Dryer
  • Flooring: Carpet, Laminate, Stone, Wood
  • Additional Rooms: Den / Study / Office, Storage
  • Fireplaces Min: 2
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Bathroom: Double Sinks, Primary - Tub with Jets, Shower and Tub, Stall Shower, Tile
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Pool Description: Pool - In Ground, Spa - In Ground
  • Roof: Composition
  • Yard/Grounds: Back Yard, BBQ Area, Fenced, Outdoor Kitchen, Sprinklers - Auto, Storage Shed / Structure
  • Pool: Yes
  • Fencing: Wood

Garage/Parking

  • Parking Spaces: 5
  • Garage Parking Features: Parking Area

Utilities

  • Cooling System: Central AC
  • Heating System: Central Forced Air
  • Sewer/Septic System: Sewer - Public

Schools

  • High School: 237

Lot Info

  • Lot Description: Grade - Level, Zero Lot Line
  • Parcel Number: 414-04-034
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 10500.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 10500.00

Multi Family

  • Utilities: Public Utilities
  • Second Unit Description: Office Shed

MLS Schools

  • High School District Text: Campbell Union High
  • High School Text: Branham High
  • Middle School Text: Price Charter Middle

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $16,096 $1,205,400 $817,033 $388,367
2024 $16,096 $1,181,765 $801,013 $380,752
2023 $16,070 $1,158,594 $785,307 $373,287
2022 $15,813 $1,135,877 $769,909 $365,968
2021 $15,607 $1,113,606 $754,813 $358,793
2020 $14,823 $1,102,189 $747,074 $355,115
2019 $12,991 $976,657 $732,426 $244,231
2018 $12,597 $957,508 $718,065 $239,443
2017 $12,356 $938,735 $703,986 $234,749
2016 $11,745 $920,330 $690,183 $230,147
2015 $11,575 $906,506 $679,816 $226,690
2014 $11,284 $888,750 $666,500 $222,250
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
05/21/2026 05/21/26 Pending -- -- --
05/11/2026 05/11/26 Price Changed $2,299,999 -7.2% $981 / Sq Ft
04/16/2026 04/16/26 Price Changed $2,479,000 -4.6% $1,058 / Sq Ft
03/06/2026 03/06/26 For Sale $2,599,000 -- $1,109 / Sq Ft
Source: MLSListings

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Trustee Deed -- Brown Barrie
Interfamily Deed Transfer -- None Available
Grant Deed $889,000 Orange Coast Title Company O
Interfamily Deed Transfer -- North American Title Company
Interfamily Deed Transfer -- North American Title Company
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- --
Interfamily Deed Transfer -- Old Republic Title Company
Interfamily Deed Transfer -- --
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Loan Amount Loan Type
Previous Owner $711,000 New Conventional
Previous Owner $633,000 Purchase Money Mortgage
Previous Owner $478,000 Purchase Money Mortgage
Previous Owner $478,000 No Value Available
Previous Owner $478,000 No Value Available
Previous Owner $478,000 No Value Available
Previous Owner $478,000 No Value Available
Previous Owner $478,900 No Value Available
Source: Public Records

Source: MLSListings

MLS Number: ML82037467

MLSListings

APN: 414-04-034

Your Personal Tour Guide

Ask me questions while you tour the home.