NOT LISTED FOR SALE

418 Esther Ave Campbell, CA 95008

Downtown Campbell Neighborhood

Estimated Value: $2,837,000 - $3,771,000

5 Beds
4.5 Baths
3,250 Sq Ft
$1,064/Sq Ft Est. Value

Last Sold August 30, 2021

Last sale price $2,750,000 $846 Per Sq Ft

Est. 26% increase in value since last sale

Current estimated payment $21,756/month

22 Days on Market

Highlights

  • Primary Bedroom Suite
  • Vaulted Ceiling
  • Main Floor Primary Bedroom
  • Del Mar High School Rated A-
  • Soaking Tub in Primary Bathroom
  • Wine Refrigerator

About This Home

As of August 2021

Move in and enjoy this gorgeous 5 bedroom Mediterranean-style custom home built in 2019 near Downtown Campbell. Spacious 8,250 SF lot. Grand entry. High ceilings throughout. Soaring ceiling with skylights in the living and formal dining areas. Stunning large open chef's kitchen with quartzite countertops, island, stainless steel appliances & Thermador 6-burner gas range. Bright, open & modern kitchen-dining-family room layout. Gleaming wide-plank engineered hardwood floors. Fully equipped with smart tech features including Nest thermostats and cameras. Four Master suites including 3 downstairs Master suites. Three Master suites have large walk-in closets. Spacious bedrooms. High coffered ceilings, recessed lighting & crown molding. Pella sliding glass doors. Beautiful low maintenance yard including large patio for entertaining. Attached 2 car garage. Nestled within short walking distance of Downtown Campbell. Convenient commute location with easy access to freeways & expressways. Wow.

Last Agent to Sell the Property

David Lillo

DPL Real Estate License #01803836 Listed on: 07/06/2021

Last Buyer's Agent

Michelle Eldridge

Redfin License #01147340

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $35,344

Year Built

  • 2019

Lot Details

  • 8,250 Sq Ft Lot
  • Fenced
  • Grass Covered Lot
  • Back Yard

Parking

  • 2 Car Garage

Home Design

  • Shingle Roof
  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 3,250 Sq Ft Home
  • Vaulted Ceiling
  • Ceiling Fan
  • Skylights
  • Double Pane Windows
  • Living Room with Fireplace
  • Family or Dining Combination

Kitchen

  • Open to Family Room
  • Double Oven
  • Gas Oven
  • Gas Cooktop
  • Range Hood
  • Microwave
  • Dishwasher
  • Wine Refrigerator
  • Kitchen Island
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bedroom on Main
  • Primary Bedroom Suite
  • Walk-In Closet
  • Remodeled Bathroom
  • Bathroom on Main Level
  • Soaking Tub in Primary Bathroom
  • Bathtub Includes Tile Surround
  • Walk-in Shower

Laundry

  • Washer and Dryer
  • Laundry Tub

Outdoor Features

  • Balcony
  • Barbecue Area

Utilities

  • Forced Air Heating and Cooling System

Home Details

Home Type

Single Family

Est. Annual Taxes

$35,344

Year Built

2019

Lot Details

0

Parking

2

Listing Details

  • Zoning: R-1-6
  • Subclass: Single Family Home
  • Age: 2
  • Listing Class: Residential
  • Structure Sq Ft: 3250
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2019

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Living Room
  • Dining Room: Dining Area In Family Room
  • Kitchen: Cooktop - Gas, Countertop - Other, Dishwasher, Garbage Disposal, Hood Over Range, Island, Microwave, Oven - Double, Oven Range - Gas, Pantry, Refrigerator, Wine Refrigerator
  • Fireplace: Yes
  • Living Sq Ft: 3250
  • Bedrooms: Ground Floor Bedroom, Primary Bedroom On Ground Floor, Primary Suite / Retreate - 2+, More Than One Bedroom On Ground Floor
  • Laundry: Tub / Sink, Washer / Dryer
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 5
  • Minimum Numberof Bedrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Bathroom: Full On Ground Floor, Half On Ground Floor, Primary - Stall Shower(s), Primary - Sunken Tub, Oversized Tub, Tile, Updated Bath

Exterior Features

  • Foundation: Concrete Perimeter
  • Roof: Composition, Shingle
  • Yard/Grounds: Back Yard, Balcony / Patio, Bbq Area, Fenced, Low Maintenance

Garage/Parking

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

Utilities

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

Association/Amenities

  • Amenities Miscellaneous: Skylight, Vaulted Ceiling, Walk-In Closet

Schools

  • School District: Campbell Union High

Lot Info

  • Lot Acres: 0.1894
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 8250.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 8250.00

Green Features

  • Energy Features: Double Pane Windows, Skylight

Multi Family

  • Utilities: Public Utilities

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 6, 2021
Closed on
Aug 17, 2021
Sold by
Habibi Maryam
Bought by
Tan Godfrey and Nyane Lynn Wei
Seller's Agent
David Lillo
DPL Real Estate
Buyer's Agent
Michelle Eldridge
Redfin
List Price
$2,698,000
Sold Price
$2,750,000
Premium/Discount to List
$52,000
1.93%
Current Estimated Value
$3,459,073

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$709,073
Avg. Annual Appreciation
5.89%
Original Mortgage
$200,000
Outstanding Balance
$182,381
Interest Rate
2.8%
Mortgage Type
Credit Line Revolving
Estimated Equity
$3,276,692

Purchase Details

Closed on
Feb 19, 2015
Sold by
Tran Terry and Tran Xuan Nhut
Bought by
Habibi Maryam
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
Tan Godfrey $2,750,000 Lawyers Title Company
Habibi Maryam $745,000 Fidelity National Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Tan Godfrey $200,000
Open Tan Godfrey $2,000,000
Previous Owner Habibi Maryam $400,000
Previous Owner Habibi Maryam $500,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/30/2021 08/30/21 Sold $2,750,000 +1.9% $846 / Sq Ft
07/29/2021 07/29/21 Pending -- -- --
07/13/2021 07/13/21 For Sale $2,698,000 0.0% $830 / Sq Ft
07/11/2021 07/11/21 Pending -- -- --
07/06/2021 07/06/21 For Sale $2,698,000 +262.1% $830 / Sq Ft
07/19/2016 07/19/16 Sold $745,000 +1.4% --
06/30/2016 06/30/16 Pending -- -- --
06/22/2016 06/22/16 For Sale $735,000 -- --
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,344 $2,918,322 $2,122,416 $795,906
2024 $35,344 $2,861,100 $2,080,800 $780,300
2023 $34,836 $2,805,000 $2,040,000 $765,000
2022 $34,532 $2,750,000 $2,000,000 $750,000
2021 $19,938 $1,550,381 $798,789 $751,592
2020 $19,426 $1,534,485 $790,599 $743,886
2019 $19,162 $1,504,398 $775,098 $729,300
2018 $18,531 $1,474,900 $759,900 $715,000
2017 $9,326 $745,000 $745,000 $0
2016 $5,760 $462,774 $462,774 $0
2015 $5,684 $455,823 $455,823 $0
2014 $5,475 $446,895 $446,895 $0
Source: Public Records

Agents Affiliated with this Home

  • David Lillo

    Seller's Agent in 2021

    David Lillo

    DPL Real Estate

    (408) 621-5649

    17 in this area

    540 Total Sales

    David Lillo
    Section Image

  • M

    Buyer's Agent in 2021

    Michelle Eldridge

    Redfin

    Section Image

  • M

    Seller's Agent in 2016

    Martin Quintana

    EstateMind Realty

    Section Image

  • O

    Buyer's Agent in 2016

    Omied Bagheri

    Compass

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81851989

MLSListings

APN: 279-37-096

California Santa Clara County Campbell 95008 Downtown Campbell

418 Esther Ave, Campbell, CA

This home is located at 418 Esther Ave, Campbell, CA 95008 since 06 July 2021 and is currently estimated at $3,459,073, approximately $1,064 per square foot. This property was built in 2019. 418 Esther Ave is a home located in Santa Clara County with nearby schools including Rosemary Elementary School, Del Mar High School, and Campbell School of Innovation.

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