$2,479,000
$120K PRICE DROP

404 Shamrock Dr Campbell, CA 95008

Estimated payment $14,484/month

Total Views 4,124
4 Beds
3 Baths
1,784 Sq Ft
$1,390 Price per Sq Ft

Highlights

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

About This Home

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.

Listing Agent

Jennifer Friess

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

Compass

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1947

Home Design

  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 1,784 Sq Ft Home
  • 1-Story Property
  • Gas Fireplace
  • Living Room with Fireplace
  • 2 Fireplaces
  • Dining Area
  • Eat-In Kitchen

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

Additional Features

  • Zoning described as R1-8
  • 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: 1784
  • 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
  • Living Sq Ft: 1784
  • Stories: 1
  • Laundry: Inside, Washer / Dryer
  • Flooring: Carpet, Laminate, Stone, Wood
  • 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
  • Pool: Yes

Garage/Parking

  • Garage Parking Features: Parking Area

Utilities

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

Lot Info

  • 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

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

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

Date Event Price List to Sale Price per Sq Ft
04/16/2026 04/16/26 Price Changed $2,479,000 -4.6% $1,390 / Sq Ft
03/06/2026 03/06/26 For Sale $2,599,000 -- $1,457 / Sq Ft
Source: MLSListings

Purchase History

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

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.