Photos
About
Details
Open Houses
Interior Features
Listed by
Payment calculator
Exterior Features
Lot details
Neighborhood
Price history
Taxes
Agent viewpoints
Similar homes for sale
Recently sold homes
Request more info
FAQ
Map View
Virtual Tour
38 Lemon Ct Hillsborough, CA, 94010
$9,200,000 Home for sale 6 beds 6 full + 2 half baths 7,821 sqft
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.
Read more
Property details
7,821 sqft interior area
Property type
Home
Interior area
7,821 sqft
View
Bay, City Lights
Land area
32,761 sqft (0.75 acres)
Price per sqft
$1,176/sqft
Days on Verhouse
32
Address
38 Lemon Ct, Hillsborough, CA, 94010
City of California
Hillsborough
County
San Mateo
nr.of parking places
3
Style
Mediterranean
Stories
2
Year Built
1992
District
Listing
Stories
Two Story
Virtual Tour
Open Houses
No upcoming open houses
Interior Features
3 parking places, Wood floors
Beds
6
Baths
6 full + 2 half
Floors
Wood
Stories
Two Story
Parking
3
Garage & Parking
Attached, Off Street, Guest
# of fireplaces
5
Fireplaces
Family Room, Living Room, Other
Heathing & Cooling
Forced Air, Zoned
Kitchen features
Breakfast Bar, Dishwasher, Double Oven, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Microwave, Pantry
Other rooms
Family Room, Formal Dining Room, Breakfast Bar, Eat-in Kitchen, Pantry
Appliances
Dishwasher, Double Oven, Disposal, Gas Range, Microwave
Basement
Crawl Space
Listed by
Celina Ni, Intero Real Estate Services
Name
Celina Ni
License number
01955022
Brokerage company
Intero Real Estate Services
MLS #
ML81959381
Payment calculator
Calculate your monthly payments
Mortgage
$28,247
Taxes
$0
HOA dues
$0
Mortgage
$1,840,000 / 20%
2.28%
30 years
Your amount
$28,247 / month
Exterior Features
—
Yard
Back Yard
Lot details
TMK #028473040
Parcel nr.
028473040
94010 info
Essentials nearby
Neighborhood stats
Walkability
Coffee shops
—
no data
Bus stop
—
no data
Supermarket
—
no data
Costco
—
no data
Hospital
—
no data
Park
—
no data
Beach
—
no data
Elementary school
—
no data
Middle school
—
no data
High school
—
no data
Local airport
—
no data
People living in 94010
47%
Families with children
National average: 39%
31%
Non family households
126,960
Population
$178,580
Average Income
Age & gender
Median age 41 years
More info
Commute types
74% commute by car
More info
Education level
33% have bachelor education
More info
Number of employees
7% work in management
More info
Vehicles available
36% have 2 vehicle
More info
Vehicles by gender
36% have 2 vehicle
More info
Housing market insights for
$2.77m
Neighborhood average
sales price*
sales price*
$2.54m
Neighborhood median
sales price*
sales price*
194
Number
of sales*
of sales*
Housing type
57% are single detacheds
More info
Rooms
27% of the houses have 4 or 5 rooms
More info
Bedrooms
46% have 2 or 3 bedrooms
More info
Owners vs Renters
58% are owners
More info
7.5 / 20
Below Average
►
15-20
Most Walkable
10-15
Above Average
5-10
Below Average
1-5
Least Walkable
Walkability according to the National Walkability Index
Price history
New Listing Mar 29, 2024
| Date | Event | Price | $/sqft | Source |
|---|---|---|---|---|
| Mar 29, 2024 | New Listing | $9,200,000 -7.82% | 1176.32 | MLS #ML81959381 |
| Nov 6, 2023 | Unavailable | $9,980,000 | 0 | MLS #ML81929424 |
| Oct 2, 2023 | Temporarily Withdrawn | $9,980,000 | 1276.05 | MLS #ML81929424 |
| May 24, 2023 | Price Decrease | $9,980,000 -8.34% | 1276.05 | MLS #ML81929424 |
| May 24, 2023 | New Listing | $10,888,000 | 1392.15 | MLS #ML81929424 |
| Apr 26, 2023 | Unavailable | $10,888,000 | 0 | MLS #ML81911654 |
| Oct 28, 2022 | New Listing | $10,888,000 +36.3% | 1392.15 | MLS #ML81911654 |
| Sep 30, 2016 | Sold | $7,988,000 | 1021.35 | Public Record |
| Aug 28, 2016 | Under contract | $7,988,000 | 1021.35 | MLS #ML81596480 |
| Jul 21, 2016 | New Listing | $7,988,000 | 1021.35 | MLS #ML81596480 |
Taxes of 38 Lemon Ct, Hillsborough, CA, 94010
R100 zoning / MLS #ML81959381
Zoning
R100
Agent viewpoints of 38 Lemon Ct, Hillsborough, CA, 94010
No reviews yet
Stunning views
Open floorplan
Needs Work
Street noise
We do not have an Agent Viewpoint for this listing yet.
As soon as we do, we post it here.
As soon as we do, we post it here.
Similar homes for sale
Similar homes nearby 38 Lemon Ct for sale
Recently sold homes
Request more info
By pressing SEND, you agree that Verhouse and real estate professionals may call/text you about your inquiry, which may involve use of automated means and prerecorded/artificial voices. You don’t need to consent as a condition of buying any property, goods or services. Message/data rates may apply. You also agree to our Terms of Use. Verhouse does not endorse any real estate professionals.
Frequently Asked Questions about 38 Lemon Ct
What is 38 Lemon Ct?
38 Lemon Ct, Hillsborough, CA, 94010 is a single family home located in the city of Hillsborough, California with zipcode 94010. This single family home has 6 bedrooms & 6 full bathrooms + & 2 half bathrooms with an interior area of 7,821 sqft.
Which year was this home built?
This home was build in 1992.
What is the full address of this Home?
38 Lemon Ct, Hillsborough, CA, 94010.
Are grocery stores nearby?
The closest grocery stores are Broadway Farmer's Market, 1.69 miles away and Lunardi's, 1.95 miles away.
What is the neighborhood like?
The 94010 zip area has a population of 126,960, and 47% of the families have children. The median age is 41.5 years and 74% commute by car. The most popular housing type is "single detached" and 58% is owner.
Based on information from the bridgeMLS as of 04-29-2024. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.
Listing last updated on: Apr 21, 2024
Verhouse Last checked 3 minutes ago
The closest grocery stores are Broadway Farmer's Market, 1.69 miles away and Lunardi's, 1.95 miles away.
The 94010 zip area has a population of 126,960, and 47% of the families have children. The median age is 41.5 years and 74% commute by car. The most popular housing type is "single detached" and 58% is owner.
*Neighborhood & street median sales price are calculated over sold properties over the last 6 months.
