NOT LISTED FOR SALE

400 Queens Ct Campbell, CA 95008

Downtown Campbell Neighborhood

Estimated Value: $2,631,000 - $2,928,175

4 Beds
3 Baths
2,097 Sq Ft
$1,331/Sq Ft Est. Value

Last Sold March 01, 2022

Last sale price $2,800,000 $1,335 Per Sq Ft

Current estimated payment $17,592/month

8 Days on Market

Highlights

  • Private Pool
  • Primary Bedroom Suite
  • Bonus Room
  • Westmont High School Rated A
  • Main Floor Primary Bedroom
  • Granite Countertops

About This Home

As of March 2022

Spacious and inviting, this lovely Campbell house sits proudly on a quiet cul-de-sac, convenient to downtown Campbells quaint shops and fabulous dining. Enjoy resort style living and entertaining in the rear yard with recently remodeled in-ground pool, spacious paver sun deck, beautiful garden lush lawn area. Fresh interior and exterior paint, new roof and wonderful floorplan will not disappoint! The spacious floor plan has a generous great room and dining room that flows into the kitchen with handsome painted cabinetry, granite counters with breakfast nook. A bonus room provides additional entertainment space. Enjoy a downstairs primary suite with spacious bath overlooking front landscape. Three guest bedrooms are located upstairs. Ample off-street parking is available on the paver driveway with additional large side yard for storage. A convenient commute location, a short stroll to downtown Campbell's quaint shops and fabulous dining and top Campbell Schools!

Last Agent to Sell the Property

Amy McCafferty

Golden Gate Sotheby's International Realty License #00967324 Listed on: 01/31/2022

Golden Gate Sotheby's International Realty

Last Buyer's Agent

Manjit Bhatia

Coldwell Banker Realty License #01399514

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Year Built

  • 1964

Lot Details

  • 9,975 Sq Ft Lot
  • Fenced
  • Back Yard

Parking

  • 2 Car Attached Garage

Home Design

  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,097 Sq Ft Home
  • 2-Story Property
  • Fireplace With Gas Starter
  • Living Room with Fireplace
  • Combination Dining and Living Room
  • Bonus Room
  • Laundry in Garage

Kitchen

  • Eat-In Kitchen
  • Built-In Oven
  • Range Hood
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Laminate
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom on Main
  • Primary Bedroom Suite
  • Remodeled Bathroom
  • Bathroom on Main Level
  • 3 Full Bathrooms
  • Granite Bathroom Countertops
  • Bathtub with Shower
  • Bathtub Includes Tile Surround
  • Walk-in Shower

Outdoor Features

  • Private Pool
  • Balcony
  • Fire Pit

Utilities

  • Forced Air Heating and Cooling System

Home Details

Home Type

Single Family

Year Built

1964

Lot Details

0

Parking

2

Listing Details

  • Zoning: R-1-6
  • Subclass: Single Family Home
  • Style: Ranch
  • Listing Class: Residential
  • Structure Sq Ft: 2097
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1964

Interior Features

  • Family Room: No Family Room
  • Fireplace: Gas Starter, Living Room
  • Dining Room: Dining Area, Dining Area In Living Room, Eat In Kitchen
  • Kitchen: Countertop - Granite, Dishwasher, Garbage Disposal, Hood Over Range, Oven - Built-In
  • Fireplace: Yes
  • Living Sq Ft: 2097
  • Stories: 2
  • Bedrooms: Ground Floor Bedroom, Primary Bedroom On Ground Floor, Primary Suite / Retreat
  • Laundry: In Garage
  • Flooring: Laminate, Tile
  • Additional Rooms: Bonus / Hobby Room
  • Fireplaces Min: 1
  • Full Bathrooms: 3
  • Total Bedrooms: 4
  • Bathroom: Full On Ground Floor, Granite, Primary - Stall Shower(s), Shower Over Tub - 1, Stall Shower - 2+, Tile, Updated Bath

Exterior Features

  • Foundation: Concrete Perimeter
  • Pool Description: Yes
  • Roof: Composition
  • Yard/Grounds: Back Yard, Balcony / Patio, Fenced, Fire Pit
  • Pool: Pool - Fenced, Pool - In Ground

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage

Utilities

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

Schools

  • High School: 242

Lot Info

  • Lot Acres: 0.2290
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 9977.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 9977.00

Multi Family

  • Utilities: Public Utilities

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jan 31, 2022
Closed on
Feb 17, 2022
Sold by
Sharp and Jennifer
Bought by
Chamarty Family Revocable Trust
Seller's Agent
Amy McCafferty
Golden Gate Sotheby's International Realty
Buyer's Agent
Manjit Bhatia
Coldwell Banker Realty
List Price
$1,925,000
Sold Price
$2,800,000
Premium/Discount to List
$875,000
45.45%
Current Estimated Value
$2,790,794

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$9,206
Avg. Annual Appreciation
-0.09%
Original Mortgage
$2,000,000
Outstanding Balance
$1,857,152
Interest Rate
3.55%
Mortgage Type
New Conventional
Estimated Equity
$933,642

Purchase Details

Closed on
Apr 12, 2007
Sold by
Ter Zakhariants Andrey and Ter Zakhariants Tatiana
Bought by
Sharp Brett and Sharp Jennifer

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 7, 2000
Sold by
Bridenne Philippe and Bridenne Rolande
Bought by
Ter Zakhariants Andrey and Ter Zakhariants Tatiana

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$472,000
Interest Rate
7.87%

Purchase Details

Closed on
Dec 10, 1997
Sold by
Bridenne Philippe and Bridenne Rolande
Bought by
Bridenne Philippe and Bridenne Rolande

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$233,000
Interest Rate
7.25%

Purchase Details

Closed on
Mar 11, 1994
Sold by
Harper Boyd E and Harper Marcia L
Bought by
Bridenne Philippe and Bridenne Rolande

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$240,000
Interest Rate
3.5%
Source: Public Records

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

Purchase History

Date Buyer Sale Price Title Company
Chamarty Family Revocable Trust $2,800,000 Fidelity National Title
Sharp Brett $975,000 Alliance Title Company
Ter Zakhariants Andrey $590,000 First American Title Co
Bridenne Philippe -- Fidelity National Title Co
Bridenne Philippe $300,000 First American Title Guarant
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Chamarty Family Revocable Trust $2,000,000
Previous Owner Sharp Brett $780,000
Previous Owner Ter Zakhariants Andrey $472,000
Previous Owner Bridenne Philippe $233,000
Previous Owner Bridenne Philippe $240,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/01/2022 03/01/22 Sold $2,800,000 +45.5% $1,335 / Sq Ft
02/08/2022 02/08/22 Pending -- -- --
01/31/2022 01/31/22 For Sale $1,925,000 -- $918 / 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 $35,990 $2,971,382 $2,122,416 $848,966
2024 $35,990 $2,913,120 $2,080,800 $832,320
2023 $35,473 $2,856,000 $2,040,000 $816,000
2022 $16,038 $1,230,941 $923,146 $307,795
2021 $15,751 $1,206,806 $905,046 $301,760
2020 $15,345 $1,194,432 $895,766 $298,666
2019 $15,131 $1,171,012 $878,202 $292,810
2018 $14,661 $1,148,052 $860,983 $287,069
2017 $14,456 $1,125,542 $844,101 $281,441
2016 $13,595 $1,103,473 $827,550 $275,923
2015 $13,374 $1,086,899 $815,120 $271,779
2014 $11,661 $955,000 $716,200 $238,800
Source: Public Records

Agents Affiliated with this Home

  • Amy McCafferty

    Seller's Agent in 2022

    Amy McCafferty

    Golden Gate Sotheby's International Realty

    (408) 387-3227

    4 in this area

    182 Total Sales

    Amy McCafferty
    Section Image
  • Manjit Bhatia

    Buyer's Agent in 2022

    Manjit Bhatia

    Coldwell Banker Realty

    (408) 644-9100

    2 in this area

    44 Total Sales

    Manjit Bhatia
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81874810

MLSListings

APN: 305-18-033

California Santa Clara County Campbell 95008 Downtown Campbell

400 Queens Ct, Campbell, CA

Not Listed for Sale

Detached

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