Please stand by!
USDAProperties.com is almost done...

 

 

 

$9,200,000
Agent Details  share icon     map icon  QR
38 Lemon Ct
Hillsborough, CA 94010
6 bed 8 bath 7,821 SqFt ($1176/SqFt)
0.75 acre lot. Built 1992
Listed 2024-03-29, Taxes $100,587
Ⓧ USDA Ineligible
due to price & location

near Hillsborough

Latest Value Estimates: $10,358,871 from Quantarium on 2024-04-03. $9,523,000 from Collateral Analytics on 2024-03-14. $8,865,300 from CoreLogic on 2024-03-04. Forecast Estimate Value:$10,573,309 in 2025-04-01 by Quantarium. $9,799,756 in 2025-02-01 by Collateral Analytics.

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 big 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 entertining 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.


Presented by Celina Ni at
INTERO REAL ESTATE SERVICES.


Property MLS #ML81959381 from MLSListings

Bedrooms: 6
Bedroom 1 Description: Primary Suite / Retreat, Walk-in Closet, More than One Primary Bedroom, More than One Bedroom on Ground Floor

Total Bathrooms: 6 / 2
Full Bathrooms: 6
1/2 Bathrooms: 2

Walk-in Closet
Wet Bar
Built-in Vacuum
High Ceiling
Skylight
Flooring: Marble, Carpet, Wood

Walk-in Closet
Wet Bar
Built-in Vacuum
High Ceiling
Skylight
Laundry Features: Gas Hookup, In Utility Room, Inside

Countertop - Granite
Ice Maker
Dishwasher
Island with Sink
Cooktop - Gas
Garbage Disposal
Hookups - Gas
Hood Over Range
Microwave
Oven - Double
Pantry
Exhaust Fan
Refrigerator
Dining Room Description: Breakfast Bar, Formal Dining Room, Eat in Kitchen

Cooling Features: Central AC, Multi-Zone Cooling
Fireplace Features: Fireplace in Family Room, Fireplace in Living Room, Primary Bedroom
Heating Features: Forced Air Heating, Heating - 2+ Zones

Extra Room-1 Description: Bonus / Hobby Room, Den / Study / Office, Loft, Formal Entry, Laundry Room
Family Room Description: Separate Family Room

Pool Features: Pool - Heated, Pool - In Ground, Pool - Lap, Pool - Cover, Spa / Hot Tub, Spa - In Ground, Cabana / Dressing Room

Fencing: Fenced Back, Fenced Front, Gate
Yard: Back Yard, Outdoor Fireplace, Fire Pit, Balcony / Patio, BBQ Area, Sprinklers - Auto, Tennis Court

Lot Description: Views, Grade - Sloped Down , Grade - Varies Lot
Lot Size Acres: 0.7521
Lot Size Source: Assessor
Lot Size Square Feet: 32760

Garage Spaces: 3
Parking Features: Attached Garage, Electric Car Hookup, Electric Gate, Gate / Door Opener, Guest / Visitor Parking, Off-Street Parking

View: Bay, Bridge , City Lights
Energy Information: Skylight, Double Pane Windows
Security Features: Security Alarm

Walk-in Closet
Wet Bar
Built-in Vacuum
High Ceiling
Skylight

Association: No
Calculated Total Monthly Association Fees: 0

High School: Burlingame High
High School District: San Mateo Union High
Middle School: Crocker Middle

Crocker Middle School is a public middle school located approximately 1.1 miles away.
directions icon Map directions

West Hillsborough School is a public elementary school located approximately 1.5 miles away.
directions icon Map directions

Burlingame High School is a public high school located approximately 2.3 miles away.
directions icon Map directions

The Nueva School is a private elementary, middle and high school located approximately 0.3 miles away.
directions icon Map directions

Source Listing Status: Active
County: San Mateo
Cross Street: Privet Drive
Source Property Type: Residential
Area: Skyfarm
Source Neighborhood: Skyfarm
Parcel Number: 028-473-040
Postal City: Hillsborough
Zoning: R10000
Property Subtype: Single Family Home
Source System Name: C2C

YearAssessments
Building + Land
Total
Tax
2022$3,668,776 + $4,981,224
$8,650,000
$100,587
2021$2,926,538 + $3,973,462
$6,900,000
$81,248
2020$3,595,372 + $4,881,556
$8,476,928
$79,020
2019$3,524,875 + $4,785,840
$8,310,715
$95,814
2018$3,455,760 + $4,692,000
$8,147,760
$93,080
2017$3,388,000 + $4,600,000
$7,988,000
$91,792
2016$2,099,038 + $2,099,038
$4,198,076
$49,938
2015$2,067,509 + $2,067,509
$4,135,018
$49,252
2014$2,027,010 + $2,027,010
$4,054,020
$48,009
2013$2,017,849 + $2,017,849
$4,035,698
$47,245
2012$1,978,284 + $1,978,284
$3,956,568
$46,337
2011$1,939,495 + $1,939,495
$3,878,990
$45,129
2010$1,234,003 + $574,002
$1,808,005
$22,303
2009$1,236,935 + $575,366
$1,812,301
$22,227
2008$1,212,682 + $564,085
$1,776,767
$21,729
2007$1,188,904 + $553,025
$1,741,929
$21,042

Listing removed 2024-03-29
$9,980,000
MLSListings
Listing removed 2024-03-29
$10,888,000
MLSListings
Listed 2024-03-29
$9,200,000
MLSListings
Sold 2016-09-30
$7,988,000
SanFrancisco
Listed 2016-07-21
$7,988,000
SanFrancisco
Listed 2016-07-21
$7,988,000
MLSListings
Listing removed 2012-09-21
$7,900,000
MLSListings
Relisted 2012-07-26
$7,900,000
MLSListings
Listing removed 2012-07-21
$7,900,000
MLSListings
Listed 2012-01-06
$7,900,000
MLSListings
Listing removed 2011-10-25
$7,900,000
MLSListings
Listed 2011-08-18
$7,900,000
MLSListings
Sold 2010-06-22
$3,850,000
Public Record
Listing removed 2010-05-18
$4,680,000
MLSListings
Listed 2009-08-16
$4,680,000
MLSListings
Sold 1981-10-30
$340,000
Public Record
Sold 1980-06-01
$270,000
Public Record
Sold 1980-01-01
$250,000
Public Record

Total Square Feet Living: 7821
Year Built: 1992
Construction Materials: Wood Frame, Stucco
Foundation Details: Concrete Perimeter, Crawl Space
Property Age: 32
Roof: Tile
Levels or Stories: 2
Structure Type: Detached
House Style: Mediterranean
Total Area Sqft: 7821
Year Built Source: Assessor

Amenities Misc.: Walk-in Closet , Wet Bar , Built-in Vacuum, High Ceiling , Skylight

Sewer: Sewer - Public, Sewer Connected
Individual Electric Meters
Individual Gas Meters
Public Utilities
Water Source: Public, Individual Water Meter
Click Thumbnail Images To View Full Size
unknownunknownhouse_viewhouse_viewunknown
road_viewgarageunknownunknownunknown
unknownunknownbathroombedroomliving_room
bathroomunknownbathroombathroomunknown
bathroomunknownunknownunknownbedroom
living_roomliving_roomliving_roomliving_roombedroom
bedroombedroomunknownunknownunknown
unknownbathroombathroombathroomunknown
bathroomdining_roomdining_roomdining_roomdining_room
kitchenunknownkitchenkitchenkitchen
kitchenkitchenkitchenkitchenkitchen
unknownunknownporchunknownporch
poolporchporchporchpool
porchhouse_viewpoolpoolpool
unknownunknownporchporchunknown
unknownhouse_viewpoolunknownhouse_view
unknownfarm_landunknownunknownunknown
unknownunknown

The property loan eligibility may be subject to additional requirements beyond geographical location including but not limited to the condition of the property. Speak with a real estate professional to find out more about the eligibility of a specific property.