Seller's Agent in 2026
Jennifer Friess
Compass
(408) 368-9700
50 Total Sales
404 Shamrock Dr Campbell, CA 95008
Campbell Area
4
Beds
3
Baths
2,344
Sq Ft
10,498
Sq Ft Lot
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
As of June 2026Incredible 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!
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
Ownership 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
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 6, 2026
Closed on
May 27, 2026
Sold by
Bought by
Seller's Agent
Jennifer Friess
Compass
Buyer's Agent
Jessica Cheng
EXP Realty of California, Inc
List Price
$2,599,000
Sold Price
$2,256,000
Premium/Discount to List
-$343,000
-13.2%
Views
47
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.31%
Original Mortgage
$1,156,000
Interest Rate
0.0538%
Mortgage Type
New Conventional
Purchase Details
Closed on
Dec 10, 2020
Sold by
Bought by
Purchase Details
Closed on
Oct 11, 2013
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$711,000
Interest Rate
0.0453%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jan 5, 2004
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$42,000
Interest Rate
0.0561%
Mortgage Type
Credit Line Revolving
Purchase Details
Closed on
May 9, 2003
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0571%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Nov 26, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0628%
Purchase Details
Closed on
Sep 13, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$99,900
Interest Rate
0.0612%
Mortgage Type
Credit Line Revolving
Purchase Details
Closed on
Sep 12, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0616%
Purchase Details
Closed on
May 17, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0694%
Purchase Details
Closed on
May 15, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0694%
Purchase Details
Closed on
Jan 29, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0715%
Purchase Details
Closed on
Jan 28, 2002
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,000
Interest Rate
0.0715%
Purchase Details
Closed on
Aug 28, 2001
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,900
Interest Rate
0.0721%
Purchase Details
Closed on
Aug 16, 2001
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,900
Interest Rate
0.0721%
Purchase Details
Closed on
Jun 22, 2001
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$478,900
Interest Rate
0.0721%
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
Average Home Value in this Area
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 |
|---|---|---|---|
| Grant Deed | $2,256,000 | Cornerstone Title Company | |
| Trustee Deed | -- | Brown Barrie | |
| 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 | -- | Old Republic Title Company | |
| Interfamily Deed Transfer | -- | -- | |
| 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 |
|---|---|---|---|
| Open | $1,156,000 | New Conventional | |
| Closed | $711,000 | New Conventional | |
| Previous Owner | $265,000 | Unknown | |
| Previous Owner | $145,000 | Unknown | |
| Previous Owner | $42,000 | Credit Line Revolving | |
| Previous Owner | $84,000 | Credit Line Revolving | |
| Previous Owner | $633,000 | Purchase Money Mortgage | |
| Previous Owner | $478,000 | Purchase Money Mortgage | |
| Previous Owner | $478,000 | Unknown | |
| Previous Owner | $478,000 | No Value Available | |
| Previous Owner | $99,900 | Credit Line Revolving | |
| 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 | |
| Previous Owner | $480,000 | Unknown | |
| Previous Owner | $157,000 | Credit Line Revolving | |
| Previous Owner | $43,000 | Credit Line Revolving | |
| Previous Owner | $251,250 | Unknown | |
| Previous Owner | $25,000 | Stand Alone Second |
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 |
|---|---|---|---|---|
| 06/12/2026 06/12/26 | Sold | $2,256,000 | -1.9% | $962 / 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
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,322 | $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
Agents Affiliated with this Home
-
Jennifer Friess
-
Jessica Cheng
Buyer's Agent in 2026
Jessica Cheng
EXP Realty of California, Inc
(925) 997-4665
15 Total Sales
Map
Source: MLSListings
MLS Number: ML82037467
APN: 414-04-034
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.
Nearby Homes
- 1235 Shamrock Dr
- 1133 Erin Way
- 1341 Parsons Ave
- 1270 Hoffman Ln
- 2865 S Bascom Ave Unit 909
- 1131 Shamrock Dr
- 2211 Fazeli Ct
- 2857 S Bascom Ave Unit 101
- 3449 Wine Cask Way
- 182 Redding Rd
- 3454 Wine Cask Way Unit 80
- 3367 Calico Ave
- 44 Redding Rd
- 2261 Central Park Dr
- 3595 S Bascom Ave Unit 27
- 125 Timber Cove Dr Unit 125
- 780 Union Ave
- 2393 Stratford Dr
- 64 Timber Cove Dr
- 72 Palomar Real Unit 72
Your Personal Tour Guide
Ask me questions while you tour the home.