NOT LISTED FOR SALE

1738 Celeste Dr San Mateo, CA 94402

Hayward Park Neighborhood

Estimated Value: $1,901,000 - $2,149,000

4 Beds
2 Baths
1,540 Sq Ft
$1,344/Sq Ft Est. Value

Sale Details

Date Sold: October 1, 2014

Last sale price $1,138,000 $739 Per Sq Ft

Est. 82% increase in value since last sale

Current estimated payment $13,464 / mo

15 Days on Market

Highlights

  • Primary Bedroom Suite
  • Eichler Home
  • Neighborhood Views
  • Borel Middle School Rated A-
  • Wood Burning Stove
  • 1-minute walk to Concar Park

About This Home

As of October 2014

Impeccable details throughout this spacious & completely remodeled 4 bedrm, Family Rm, 2 bathrm Open floor plan Eichler, Fireplace in Lvgrm. Gourmet Kitchen, Granite counters, Top-Brand appliances, Chiseled Italian Marble Floors, recessed lighting, New carpets, paint, Dual Pane windows, abundance of natural light from skylights & 4 sliding glass doors leading to serene & private patio & backyard.

Last Agent to Sell the Property

Berta Tovar

Marshall Realty License #00614088 Listed on: 08/14/2014

Last Buyer's Agent

Vincent Joutain

Reliance Realty Group License #01917725

Reliance Realty Group

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 Details

Home Type

  • Single Family

Year Built

  • Built in 1956

Lot Details

  • Fenced
  • Level Lot
  • Front Yard Sprinklers
  • Sprinklers on Timer
  • Zoning described as R1006

Parking

  • 2 Car Garage

Home Design

  • Eichler Home
  • Slab Foundation

Interior Spaces

  • 1,540 Sq Ft Home
  • 1-Story Property
  • Skylights
  • Wood Burning Stove
  • Double Pane Windows
  • Separate Family Room
  • Living Room with Fireplace
  • Combination Dining and Living Room
  • Neighborhood Views

Kitchen

  • Self-Cleaning Oven
  • Microwave
  • Dishwasher
  • Disposal

Flooring

  • Wall to Wall Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bedroom Suite
  • 2 Full Bathrooms

Outdoor Features

  • Patio

Utilities

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

Listing and Financial Details

  • Assessor Parcel Number 035-263-070

Home Details

Home Type

Single Family

Year Built

Built in 1956

Lot Details

5,445 Sq Ft Lot

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Style: Eichler
  • Sale Price Per Sq Ft: 738.96
  • Listing Class: Residential
  • Structure Sq Ft: 1540
  • Incorporated: Yes
  • Map Book Page: 749
  • Map Side Coordinate: 3
  • Map Top Coordinate: B
  • Thomas Bros Page: 749
  • Thomas Brothers: B3
  • Year Built: 1956
  • Zoning Description: R1006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Living Room, Wood Stove, Yes
  • Dining Room: Dining Area in Living Room, No Informal Dining Room
  • Kitchen: Dishwasher, Garbage Disposal, Refrigerator, Oven Range, Microwave, Ovens - 2+, Oven - Self Cleaning
  • Living Sq Ft: 1540
  • Stories: 1
  • Bedrooms: Primary Suite / Retreat
  • Laundry: In Laundry Room
  • Flooring: Tile, Carpet - Wall to Wall
  • Maximum Bathrooms: 2
  • Minimum Bathrooms: 2
  • Full Bathrooms: 2
  • Total Bedrooms: 4

Exterior Features

  • Foundation: Concrete Slab
  • Pool Description: Pool - No
  • View: Local/Neighborhood
  • Yard/Grounds: Patio(s), Sprinkler(s) - Front, Sprinklers - Auto, Fenced
  • Exterior: Wood

Garage/Parking

  • Garage Spaces: 2

Utilities

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

Association/Amenities

  • Amenities Miscellaneous: Double Pane Windows(s)

Lot Info

  • Lot Description: Grade - Level
  • Parcel Number: 035-263-070
  • List Price per Sq Ft: 635.71
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 5400.00
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Max Search: 5400.00
  • Lot Size Area Min Search: 5400.00
  • Maximum Lot Size: 5400.00
  • Map Book: Thomas Bros

Green Features

  • Energy Features: Double Pane Windows, Skylight

Multi Family

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

MLS Schools

  • High School District Text: San Mateo Union High

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Agents Specializing in Hayward Park, CA

  • Michael Hall Real Estate Agent - Compass

    Michael Hall

    Compass

    (650) 414-4726

    28 Total Sales

    1 in Hayward Park

    $1,603,000 Price

    Michael Hall
     Section Image
  • Dan Hunnicutt Real Estate Agent - eXp Realty of Northern California, Inc.

    Dan Hunnicutt

    eXp Realty of Northern California, Inc.

    (650) 562-8757

    21 Total Sales

    1 in Hayward Park

    $2,700,000 Price

    Dan Hunnicutt
     Section Image
  • Emma Elfving Real Estate Agent - Compass

    Emma Elfving

    Compass

    (650) 525-2423

    90 Total Sales

    2 in Hayward Park

    $1.7M - $1.9M Price Range

    Emma Elfving
     Section Image
  • Kathleen Sparer Real Estate Agent - Compass

    Kathleen Sparer

    Compass

    (650) 562-8667

    25 Total Sales

    3 in Hayward Park

    $1.8M - $2.2M Price Range

    Kathleen Sparer
     Section Image
  • Claire Haggarty Real Estate Agent - N B T Realty Service

    Claire Haggarty

    N B T Realty Service

    (650) 977-2596

    15 Total Sales

    1 in Hayward Park

    $1,280,000 Price

    Claire Haggarty
     Section Image
  • Cheryl Bower Real Estate Agent - Compass

    Cheryl Bower

    Compass

    (650) 540-3901

    60 Total Sales

    1 in Hayward Park

    $1,350,000 Price

    Cheryl Bower
     Section Image
See All Agents

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
10/01/2014 10/01/14 Sold $1,138,000 +16.2% $739 / Sq Ft
08/29/2014 08/29/14 Pending -- -- --
08/14/2014 08/14/14 For Sale $979,000 -- $636 / Sq Ft
Source: MLSListings

Agents Affiliated with this Home

  • B

    Seller's Agent in 2014

    Berta Tovar

    Marshall Realty

    Section Image

  • V

    Buyer's Agent in 2014

    Vincent Joutain

    Reliance Realty Group

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81429610

MLSListings

APN: 035-263-070

California San Mateo County San Mateo 94402 Hayward Park

1738 Celeste Dr, San Mateo, CA

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 © 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
Your Personal Tour Guide

Ask me questions while you tour the home.