NOT LISTED FOR SALE

404 Shamrock Dr Campbell, CA 95008

Estimated Value: $1,888,000 - $2,155,000

3 Beds
2 Baths
1,784 Sq Ft
$1,133/Sq Ft Est. Value

Last Sold October 24, 2013

Last sale price $889,000 $498 Per Sq Ft

Est. 127% increase in value since last sale

Current estimated payment $12,061/month

11 Days on Market

Highlights

  • In Ground Pool
  • Primary Bedroom Suite
  • Vaulted Ceiling
  • Branham High School Rated A
  • Fireplace in Primary Bedroom
  • Hydromassage or Jetted Bathtub

About This Home

As of October 2013

This amazing remodeled home offers surprises at every turn and features the very finest finishes. With a gorgeous golden granite & stainless gourmet kitchen, spa-like master retreat w/ fireplace, sparkling Pebble Tec pool and backyard oasis, you won't want to miss this special place! An 884 sq ft, 3-car garage with bar, TV access, pit & lift is the icing on the cake. All that's missing is you!

Last Agent to Sell the Property

Marcie Paul

Intero Real Estate Services License #01387514 Listed on: 09/19/2013

Intero Real Estate Services

Last Buyer's Agent

Darin Pugh

Coldwell Banker Realty License #01922659

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $16,096

Year Built

  • Built in 1947

Lot Details

  • Zoning described as R1-8

Home Design

  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 1,784 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Skylights
  • Gas Log Fireplace
  • Double Pane Windows
  • Window Treatments
  • Bay Window
  • Garden Windows
  • Living Room with Fireplace
  • Formal Dining Room
  • Den
  • Neighborhood Views

Kitchen

  • Breakfast Bar
  • Built-In Oven
  • Cooktop
  • Dishwasher
  • Disposal

Flooring

  • Wall to Wall Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bedroom Suite
  • 2 Full Bathrooms
  • Hydromassage or Jetted Bathtub
  • Bathtub with Shower
  • Walk-in Shower

Laundry

  • Dryer
  • Washer

Parking

  • Detached Garage
  • Garage Door Opener

Pool

  • In Ground Pool
  • Gas Heated Pool
  • Outdoor Pool
  • Spa
  • Pool Sweep

Utilities

  • Forced Air Heating and Cooling System
  • Sewer Within 50 Feet
  • Cable TV Available

Listing and Financial Details

  • Assessor Parcel Number 414-04-034

Home Details

Home Type

Single Family

Est. Annual Taxes

$16,096

Year Built

Built in 1947

Lot Details

0

Listing Details

  • Subclass: Single Family Home
  • Age: 66
  • Sale Price Per Sq Ft: 498.32
  • Listing Class: Residential
  • Structure Sq Ft: 1784
  • Incorporated: Yes
  • Map Book Page: 873
  • Map Side Coordinate: 1
  • Map Top Coordinate: E
  • Thomas Bros Page: 873
  • Thomas Brothers: E1
  • Year Built: 1947
  • Zoning Description: R1-8
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: No Family Room, No Separate Family Room
  • Fireplace: Living Room, Primary Bedroom, Gas Log, Yes
  • Dining Room: Formal Dining Room, Breakfast Bar
  • Kitchen: Dishwasher, Cooktop, Garbage Disposal, Refrigerator, Ovens - 2+, Oven - Built-In, Hookups - Gas
  • Living Sq Ft: 1784
  • Stories: 1
  • Bedrooms: Primary Suite / Retreat
  • Laundry: In Laundry Room, Dryer, Washer
  • Flooring: Tile, Carpet - Wall to Wall
  • Additional Rooms: Den / Study / Office
  • Maximum Bathrooms: 2
  • Maximum Numberof Bedrooms: 3
  • Minimum Bathrooms: 2
  • Minimum Numberof Bedrooms: 3
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Bathroom: Shower over Tub - 1, Tubs - 2+, Stall Shower, Tub in Primary Bedroom, Tub with Jets

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Pool Description: Spa / Hot Tub, In Ground Concrete, Pool - Sweep, Heated - Gas, Pool - Yes
  • Roof: Composition
  • View: Local/Neighborhood
  • Pool: Yes
  • Exterior: Wood

Garage/Parking

  • Garage Min: 3
  • Garage Parking Features: Detached Garage, Gate / Door Opener

Utilities

  • Cooling System: Central AC
  • Heating System: Forced Air
  • Sewer/Septic System: Sewer in Street, Sewer Connected

Association/Amenities

  • Amenities Miscellaneous: Window Covering(s), Double Pane Windows(s), Garden Window, Vaulted Ceiling, Bay Window

Schools

  • School District: Campbell Union High
  • Elementary School: Farnham Charter
  • Middle School: Price Charter Middle
  • High School: Branham High
  • High School: 237
  • Elementary School: 44
  • Middle School: 46

Lot Info

  • Parcel Number: 414-04-034
  • List Price per Sq Ft: 498.32
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 10500.00
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Max Search: 10500.00
  • Lot Size Area Min Search: 10500.00
  • Maximum Lot Size: 10500.00
  • Map Book: Thomas Bros

Green Features

  • Energy Features: Double Pane Windows, Skylight, Ceiling Fan(s)

Multi Family

  • Maximum Building Height: 1
  • Minimum Building Height: 1

MLS Schools

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

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Dec 10, 2020
Sold by
Brown Barrie and Brown Bonnie
Bought by
Barrie And Bonnie Brown Revocable Trust and Brown
Current Estimated Value
$2,021,988

Purchase Details

Closed on
Nov 27, 2020
Sold by
Brown Barrie and Brown Bonnie
Bought by
Brown Barrie and Brown Bonnie

Purchase Details

Listed on
Sep 19, 2013
Closed on
Oct 11, 2013
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Brown Barrie and Brown Bonnie
Seller's Agent
Marcie Paul
Intero Real Estate Services
Buyer's Agent
Darin Pugh
Coldwell Banker Realty
List Price
$889,000
Sold Price
$889,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.09%
Original Mortgage
$711,000
Interest Rate
4.53%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 5, 2004
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$633,000
Interest Rate
5.25%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
May 9, 2003
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
5.71%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Nov 26, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
6.28%

Purchase Details

Closed on
Sep 13, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
6.16%

Purchase Details

Closed on
Sep 12, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
6.16%

Purchase Details

Closed on
May 17, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
6.94%

Purchase Details

Closed on
May 15, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
6.94%

Purchase Details

Closed on
Jan 29, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
7.15%

Purchase Details

Closed on
Jan 28, 2002
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
7.15%

Purchase Details

Closed on
Aug 28, 2001
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
7.21%

Purchase Details

Closed on
Aug 16, 2001
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
7.21%

Purchase Details

Closed on
Jun 22, 2001
Sold by
Baker Kevin M and Baker Cathryn L
Bought by
Baker Kevin M and Baker Cathryn L

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
7.21%
Source: Public Records

Range of Values:

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

Purchase History

Date Buyer Sale Price Title Company
Barrie And Bonnie Brown Revocable Trust -- Brown Barrie
Brown Barrie -- None Available
Brown Barrie $889,000 Orange Coast Title Company O
Baker Kevin M -- North American Title Company
Baker Kevin M -- North American Title Company
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- --
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- --
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- --
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- --
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- --
Baker Kevin M -- Old Republic Title Company
Baker Kevin M -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Brown Barrie $711,000
Previous Owner Baker Kevin M $633,000
Previous Owner Baker Kevin M $478,000
Previous Owner Baker Kevin M $478,000
Previous Owner Baker Kevin M $478,000
Previous Owner Baker Kevin M $478,000
Previous Owner Baker Kevin M $478,000
Previous Owner Baker Kevin M $478,900
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
10/24/2013 10/24/13 Sold $889,000 0.0% $498 / Sq Ft
09/30/2013 09/30/13 Pending -- -- --
09/19/2013 09/19/13 For Sale $889,000 -- $498 / Sq Ft
Source: MLSListings

Tax History Compared to Growth

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

Agents Affiliated with this Home

  • Marcie Paul

    Seller's Agent in 2013

    Marcie Paul

    Intero Real Estate Services

    (408) 718-7730

    15 Total Sales

    Marcie Paul
    Section Image

  • D

    Buyer's Agent in 2013

    Darin Pugh

    Coldwell Banker Realty

See All Agents

Map

Source: MLSListings

MLS Number: ML81334927

MLSListings

APN: 414-04-034

California Santa Clara County Campbell 95008

404 Shamrock Dr, Campbell, CA

This home is located at 404 Shamrock Dr, Campbell, CA 95008 since 19 September 2013 and is currently estimated at $2,021,988, approximately $1,133 per square foot. This property was built in 1947. 404 Shamrock Dr is a home located in Santa Clara County with nearby schools including Branham High School, Farnham Elementary School, and Fammatre Elementary School.

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.

MLSListings Property Information © 2025 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