38 Lemon Court

Hillsborough, CA 94010

$9,200,000
Price
6
Beds
6
Baths
2
1/2 Baths
7,821 Sq. Ft.
$1,176 / Sq. Ft.
7,821
Sq. Ft.
$1,176
per Sq. Ft.

Description

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...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.
  1. Listed by Celina Ni • DRE #01955022 • Brokerage DRE #01354442 • Intero Real Estate Services • 408-712-6078
  2. Listed by Mark Gissler • DRE #00901229 • Brokerage DRE #01354442 • Intero Real Estate Services

Property Details for 38 Lemon Court

MLS City Name
Hillsborough
Building Type
Detached
Style
Mediterranean
Garage Spaces
3
View
Bay, Bridge, City Lights
Cross Street
Privet Drive

Location

Listing Courtesy of Intero Real Estate Services, Celina Ni, DRE #01955022; Intero Real Estate Services, Mark Gissler, DRE #00901229
Add your commute
LISTING UPDATED: 04/21/2024 12:20 AM

Property Details for 38 Lemon Court

StatusActive
MLS #ML81959381
Days on Compass31
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeSingle-Family Homes / Detached
Year Built1992
Lot Size0.75 AC / 32,760 SF
CountySan Mateo County

Location

Listing Courtesy of Intero Real Estate Services, Celina Ni, DRE #01955022; Intero Real Estate Services, Mark Gissler, DRE #00901229
Add your commute

Virtual Tour

Building Information for 38 Lemon Court

Stories2Year Built1992Building Size-Lot Size0.75 AC / 32,760 SF

Payment Calculator

$58,997 per month

30 year fixed, 7.25% Interest

Principal and Interest

$50,208

Property Taxes

$8,789

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 38 Lemon Court

Features
External Links
Room Information
  • Additional Rooms: Bonus / Hobby Room, Den / Study / Office, Loft, Formal Entry, Laundry Room
  • Bathroom: Double Sinks, Marble, Shower and Tub, Steam Shower, Tile, Tub, Tub with Jets, Updated Bath, Primary - Stall Shower(s)
  • Bedrooms: Primary Suite / Retreat, Walk-in Closet, More than One Primary Bedroom, More than One Bedroom on Ground Floor
  • Dining Room: Breakfast Bar, Formal Dining Room, Eat in Kitchen
  • Family Room: Separate Family Room
  • Kitchen: Countertop - Granite, Ice Maker, Dishwasher, Island with Sink, Cooktop - Gas, Garbage Disposal, Hookups - Gas, Hood Over Range, Microwave, Oven - Double, Pantry, Exhaust Fan, Refrigerator
  • Number of Full Bathrooms: 6
  • Number of Half Bathrooms: 2
Features
  • Amenities: Walk-in Closet, Wet Bar, Built-in Vacuum, High Ceiling, Skylight
  • Energy Features: Skylight, Double Pane Windows
  • Fireplace: Yes
  • Fireplaces: Family Room, Living Room, Primary Bedroom, Other
  • Fireplaces Min: 5
  • Flooring: Marble, Carpet, Wood
  • Laundry: Gas Hookup, In Utility Room, Inside
  • Living SqFt: 7821
  • Pool: Yes
  • Pool Type: Pool - Heated, Pool - In Ground, Pool - Lap, Pool - Cover, Spa / Hot Tub, Spa - In Ground, Cabana / Dressing Room
  • Security Features: Security Alarm
  • Special Features: None
Utilities
  • Cooling: Central AC, Multi-Zone
  • Heating: Forced Air, Heating - 2+ Zones
  • Sewer Septic: Sewer - Public, Sewer Connected
  • Utilities: Individual Electric Meters, Individual Gas Meters, Public Utilities
  • Water: Public, Individual Water Meter
Carport and Parking
  • Carport Min: 0
Garage
  • Garage and Parking: Attached Garage, Electric Car Hookup, Electric Gate, Gate / Door Opener, Guest / Visitor Parking, Off-Street Parking
  • Garage Max: 3
  • Garage Min: 3
Property Details
Homeowners Association
  • HOA Exists: 0
  • HOA Fee: $0
Property Details
  • Exterior: Dual Pane Windows
  • Area Text: Skyfarm
  • Roof: Tile
  • Stories: Two Story
  • Subclass: Single Family Home
  • TIC Agreement: No
  • Year Built Source: Assessor
  • Street Number: 38
  • Street Name: Lemon
  • Street Suffix: Court
  • Area ID: 450
Lot / Property Details
Building Information
  • Number Of Stories: 2
  • Structure SqFt: 7821
  • Structure SqFt Source: Other
  • Age: 32
Development Information
  • Construction Type: Wood Frame, Stucco
  • Zoning Detail: R10000
Location Information
  • City Limits: Yes
  • Incorporated: Yes
  • Parcel Number: 028-473-040
  • County Name: San Mateo
  • City Name: Hillsborough
  • City Postal ID: 23
  • Postal Code: 94010
  • Elementary School District: 925
  • Middle School Text: Crocker Middle
  • High School District Text: San Mateo Union High
  • High School Text: Burlingame High
Lot Information
  • Fencing: Fenced Back, Fenced Front, Gate
  • Foundation: Concrete Perimeter, Crawl Space
  • Horse Property: No
  • Lot Acres: .75
  • Lot Description: Views, Grade - Sloped Down, Grade - Varies
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Minimum Units: Square Feet
  • Lot Size Source: Assessor
  • Yard Grounds: Back Yard, Outdoor Fireplace, Fire Pit, Balcony / Patio, BBQ Area, Sprinklers - Auto, Tennis Court
Mobile / Manufactured Information
Other Information
  • Dual Variable: Yes

Property History for 38 Lemon Court

DateEvent & SourcePriceAppreciation
DateEvent & SourcePrice

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 38 Lemon Court

Taxable ValueLand$5,108,487Additions$3,762,513Total$8,871,000
Tax Record2023$105,463 ($8,789 / month)
Home Facts
Beds6Total Finished SqFt6,500 SqFtAbove Grade Finished SqFt6,420 SqFtFinished Basement SqFt80 SqFtStories2Lot Size32,760 SqFtStyleSingle Family ResidenceYear Built1992ZoningR10000CountySAN MATEOAPN028-473-040

Schools near 38 Lemon Court

This home is within San Mateo Union High School District.
Rating
School
Type
Grades
Distance
Public - K to 5
Public - 6 to 8
Public - 9 to 12
Charter - 9 to 12
Rating
School
Distance
West Hillsborough School
PublicK to 5

Crocker Middle School
Public6 to 8

Burlingame High School
Public9 to 12

Design Tech High
Charter9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Sorry, we can't find any similar homes at this time. Please check back later.

Similar Sold Homes

Sorry, we can't find any similar sold homes at this time. Please check back later.

38 Lemon Court is a single family home for sale in Hillsborough, CA 94010. This property was listed for sale on March 29, 2024 by Intero Real Estate Services, it's currently listed at $9,200,000. It has been on the market for a total of 31 days and was last sold on September 30, 2016. This listing's school districts are San Mateo Union High School District, Hillsborough City Elementary School District. Nearby schools include West Hillsborough School, Crocker Middle School and Burlingame High School. 38 Lemon Court is a 6-bed, 7-bath, 7,821 sqft single family home built in 1992.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Intero Real Estate Services, Celina Ni, DRE #01955022; Intero Real Estate Services, Mark Gissler, DRE #00901229

Based on information from one of the following Multiple Listing Services: San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.