Skip main navigation
Sold for $7,500,000
Street View
  • Tax assessed value
    $7,500,000

    38 Lemon Ct, Hillsborough, CA 94010

    6beds
    7,821sqft
    SingleFamily
    Built in 1992
    0.75 Acres Lot
    $8,153,100 Zestimate®
    $959/sqft
    $9,022 Estimated rent

    Home value

    $8,153,100

    $7.34M - $9.13M

    $9,022/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $9,022/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $9,022/mo

    Rent Zestimate®

    Refinance and save

    $46,838/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $46,838/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Breathtaking, unparalleled panoramic Bay views. This 6 bedroom, 6 full + 2 half bath Mediterranean estate is truly one-of-a-kind. With 7,821 square feet of living space this renovated, custom home boasts quality finishes and meticulous attention to detail throughout. An abundance of natural light with endless amenities, private and visually stunning. All nestled on a very private cul-de-sac. Grand entry with over 30 foot ceilings, marble finishes, custom skylight, indoor waterfall, grand columns and custom iron work. Walls of picture windows, multiple bedroom suites with balconies, grand master with large shower/bathtub and fireplace. Formal living and dining rooms, office, multiple fireplaces, custom bar, stunning chef’s kitchen Sub-Zero, Thermador and Bosch appliances, with adjoining family room, all with panoramic Bay views. The grounds offer .75 acres of resort-style lounge areas, with dramatic Bay views and opening to a natural preserve. Terraces and patios, huge pool with Jacuzzi, sports court, water fountains, fireplace and fire pit; outdoor kitchen, indoor/outdoor sound system perfect for entertaining and relaxing! Manicured landscaping, mature palm trees and large gated driveway and 3 car garage! Distinguished Hillsborough schools! Close to Downtown San Mateo and Burlingame, close to all major freeways and mass transit, BART and Caltrain, SFO Airport, easy access to San Francisco and Silicon Valley tech centers!

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 8
    • Full bathrooms: 6
    • 1/2 bathrooms: 2
    Heating
    • Other
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Dryer, Freezer, Garbage disposal, Microwave, Range / Oven, Refrigerator, Washer
    Features
    • Flooring: Tile, Carpet, Hardwood
    • Basement: Finished
    • Has fireplace: Yes
    Interior area
    • Total interior livable area: 7,821 sqft

    Property

    Parking
    • Total spaces: 3
    • Parking features: Carport, Garage - Attached
    Features
    • Has spa: Yes
    • Has view: Yes
    • View description: Park, Water, City, Mountain
    • Has water view: Yes
    • Water view: Water
    Lot
    • Size: 0.75 Acres
    Details
    • Parcel number: 028473040

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • Roof: Tile
    Condition
    • Year built: 1992

    Community & neighborhood

    Location
    • Region: Hillsborough

    Price history

    DateEventPrice
    10/30/2024Sold$7,500,000-24.8%$959/sqft
    Source: Public Record Report a problem
    5/31/2023Listing removed--
    Source: MLSListings Inc #ML81929424 Report a problem
    5/24/2023Listed for sale$9,980,000-8.3%$1,276/sqft
    Source: MLSListings Inc #ML81929424 Report a problem
    4/26/2023Listing removed--
    Source: MLSListings Inc #ML81911654 Report a problem
    10/28/2022Listed for sale$10,888,000+36.3%$1,392/sqft
    Source: MLSListings Inc #ML81911654 Report a problem
    9/30/2016Sold$7,988,000+1.1%$1,021/sqft
    Source: Public Record Report a problem
    1/21/2013Listing removed$7,900,000$1,010/sqft
    Source: Quest Real Estate Report a problem
    12/16/2012Listed for sale$7,900,000$1,010/sqft
    Source: Quest Real Estate Report a problem
    9/22/2012Listing removed$7,900,000$1,010/sqft
    Source: Quest Real Estate #81200499 Report a problem
    8/20/2011Listed for sale$7,900,000+68.8%$1,010/sqft
    Source: Quest Real Estate #81136231 Report a problem
    8/6/2010Listing removed$4,680,000$598/sqft
    Source: Green Banker Report a problem
    8/5/2010Listed for sale$4,680,000+21.6%$598/sqft
    Source: Green Banker Report a problem
    6/22/2010Sold$3,850,000$492/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$89,951 -11.2%$7,500,000 -12.1%
    2024$101,318 -3.9%$8,533,000 -3.8%
    2023$105,463 +4.8%$8,871,000 +2.6%
    2022$100,588 +23.8%$8,650,000 +25.4%
    2021$81,248 +2.8%$6,900,000 -18.6%
    2020$79,020 -17.5%$8,476,928 +2%
    2019$95,814 +2.9%$8,310,715 +2%
    2018$93,081 +1.4%$8,147,760 +2%
    2017$91,792 +83.8%$7,988,000 +90.3%
    2016$49,938 +4%$4,198,076 +1.5%
    2015$48,010 $4,135,018 +2%
    2014$48,010 $4,054,020 +0.5%
    2013-- $4,035,698 +2%
    2012-- $3,956,568
    2011-- $3,956,568 +2.8%
    2010-- $3,850,000 +112.4%
    2009-- $1,812,301 +2%
    2008-- $1,776,767 +2%
    2007-- $1,741,929 +2%
    2006-- $1,707,775
    2005-- $1,707,775 +4%
    2004-- $1,641,462 +1.9%
    2003-- $1,611,378 +2%
    2002-- $1,579,784 +2%
    2001-- $1,548,808 +2%
    2000-- $1,518,440

    Find assessor info on the county website

    Neighborhood: 94010

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: North Hillsborough
    • Middle: Crocker Middle School
    • District: Hillsborough

    Source: The MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $8,153,100
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $8,153,100