Listing provided courtesy of Intero Real Estate Services - MLS# ML81959381MLS Provider

38 Lemon CTHillsborough, CA 94010

Single Family · 6 Beds · 6 Full Baths · 2 Partial Baths · 7,821 Sq. ft. | 0.75 Acres

$9,200,000 Active

Overview

Time on Site:
16 days
Visits:
136

Magnificent Mediterranean Estate with 6 bedrooms, 6 bathrooms, plus an additional two half bathrooms/Soaring ceilings with custom skylights provide an abundance of natural lighting over the dramatic entry that features grand columns and graceful staircases with custom ironwork and a cascading water wall feature/Spacious Primary bedroom with high coffered ceiling, bold crown molding, fireplace, a separate walk-in closets and spacious main bathroom that features a large shower with dual heads and a separate tub/Sizable office/study with cozy fireplace and built-in bookshelves that are blessed with an abundance of natural lighting from multiple sides/The resort-style backyards is perfect for entertaining and relaxing. Dramatic views of San Francisco Bay and beyond can be enjoyed from the spacious terraces and patio that surround the huge refreshing pool and jacuzzi. Other feathers include a sports court, water fountains, fireplace, and fire pit. A spacious gated driveway and 3-car garage.

Open Houses
  • PublicSun. Apr 141:00PM - 4:00PM
View Map

Facts & Features

  • Type Single Family
  • Sq. ft. 7,821
  • Price/Sq.ft. $1,176
  • Lot 0.75 Acres

General

Association/HOA
  • Association: 0
Green Features
  • Green Energy Efficient: Skylight,Double Pane Windows
Building Information
  • Year Built: 1992
Location/Region
  • County Or Parish: San Mateo
  • MLS Area Major: Skyfarm
General Information
  • Parcel Number: 028-473-040
  • Property Sub Type: Detached
  • Property Type: Residential
  • Zoning: R10000

Interior

Parking Information
  • Garage Spaces: 3
Beds/Baths
  • Bathrooms Full: 6
  • Bathrooms Half: 2
  • Bedrooms Total: 6
General Information
  • Cooling: Central AC,Multi-Zone
  • Fireplace Features: Family Room,Living Room,Primary Bedroom,Other
  • Fireplace: 1
  • Flooring: Marble,Carpet,Wood
  • Foundation Details: Concrete Perimeter,Crawl Space
  • Heating: Forced Air,Heating - 2+ Zones
  • Laundry Features: Gas Hookup,In Utility Room,Inside
  • Living Area: 7821
  • Security Features: Security Alarm
  • Stories Total: 2

Exterior

Parking Information
  • Parking Features: Attached Garage,Electric Car Hookup,Electric Gate,Gate / Door Opener,Guest / Visitor Parking,Off-Street Parking
Lot Information
  • Lot Features: Views,Grade - Sloped Down ,Grade - Varies
  • Lot Size Acres: 0.7521
  • Water Source: Public,Individual Water Meter
Waterfront/View
  • View: Bay,Bridge ,City Lights
Building Exterior/Construction
  • Architectural Style: Mediterranean
  • Construction Materials: Wood Frame,Stucco
  • Roof: Tile
General Information
  • Fencing: Fenced Back,Fenced Front,Gate
  • Horse: No
  • Pool Features: Pool - Heated,Pool - In Ground,Pool - Lap,Pool - Cover,Spa / Hot Tub,Spa - In Ground,Cabana / Dressing Room
  • Pool Private: 1
  • Sewer: Sewer - Public,Sewer Connected
  • Utilities: Individual Electric Meters,Individual Gas Meters,Public Utilities

Neighborhood

Community

94010 (Hillsborough) Demographics
42
Median Age
3,560
Population Density (per sq. mile)
76%
College Educated
$158,316
Estimated Median Income
9,777
Estimated Total Home Owners
6,122
Estimated Total Renters
61% / 39%
Estimated Owner / Renter Divide
3
Estimated Average Household Size
Community data courtesy of LiveBy, Inc.

Schools

Elementary Schools
5
Public
Franklin Elementary
  • Grades: KG - 5
  • Enrollment: 456
5
Public
Hoover Elementary
  • Grades: KG - 5
  • Enrollment: 237
5
Public
Lincoln Elementary
  • Grades: KG - 5
  • Enrollment: 441
4
Public
McKinley Elementary
  • Grades: KG - 5
  • Enrollment: 563
5
Public
North Hillsborough
  • Grades: KG - 5
  • Enrollment: 295
5
Public
Roosevelt Elementary
  • Grades: KG - 5
  • Enrollment: 343
5
Public
South Hillsborough
  • Grades: KG - 5
  • Enrollment: 216
4
Public
Washington Elementary
  • Grades: KG - 5
  • Enrollment: 375
5
Public
West Hillsborough
  • Grades: KG - 5
  • Enrollment: 348
Middle Schools
5
Public
Burlingame Intermediate
  • Grades: 6 - 8 /
  • Enrollment: 1,113
5
Public
Crocker Middle
  • Grades: 6 - 8 /
  • Enrollment: 430
High Schools
5
Public
Burlingame High
  • Grades: 9 - 12 /
  • Enrollment: 1,528
School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

Monthly Cost

$
$ %
%
$
$
* Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information.

Market Data

Based on the last 30 days in this zip code

$5,838,879
Median Sales Price
$1,343
Median Price per Square Foot
0
Properties Sold
29
New on Market
57
Average Days on Market
61
Properties for Sale
Calculations provided by Reliance Network

History

Date Event Value Agent
3/29/2024Source: bridgeMLS Added to Database
March 29, 2024
Celina Ni
Listing Agent
3/29/2024Source: CRMLS Added to Database
March 29, 2024
Celina Ni
Listing Agent
3/29/2024Source: MLSListings Added to Database
March 29, 2024
Celina Ni
Listing Agent