- Map View
- Bird's Eye
- Street View
This home is not currently listed for sale or rent on Zillow.
Curb Appeal & Entertaining: One of the most stunning entries in Hillsborough! From the moment you approach, you will be captivated by the regal motorized double gated entry framed by huge marble planters and an immense boundary wall. A pedestrian and a service gate add to the convenience. As the gates gently open you are transported into a private world of luxury. An enormous concrete front yard can accommodate two dozen cars. Beautiful landscaping includes a pink marble fountain and multistory tall trees. Gleaming lighting makes the outdoors suitable for an evening party of hundreds. The front yard, two of the three patios, and four of the seven bedroom suites provide a magnificent view of the San Francisco Bay, San Mateo bridge, Dumbarton bridge, lower Hillsborough, areas of San Mateo and Alameda counties, and mountains.
Sunken large formal living room has beamed cathedral ceiling, marble gas fireplace, bay window, and sliding door to main patio. Dining room with coffered ceiling can seat a dozen guests for a formal dinner. The epicurean kitchen has granite counters and backsplash, double oven, two sinks, an island and two grills. The dinette has an invigorating view of the garden from the large window. The enormous great room/ family room has oak paneling throughout with coffered ceiling, a fabulous wet bar with built in refrigerator, marble gas fireplace, entertainment center, large windows, and a sliding door to the main patio. More than one hundred guests can have a formal sit down dinner while enjoying breathtaking bay views on the beautifully paved main patio. A party of up to 200 can be accommodated in the great room, living room, main patio, dining room, kitchen, and dinette. The bedroom suites can be closed off from the guests during such a party. If the pool area, game court, bedroom suites, and other areas are included, several hundred guests can be accommodated.
The 20 ft by 35 ft heated pool with motorized cover has surrounding concrete areas for a pool party of 50 guests. There are adjoining double showers, double vanities, and facilities. The surrounding landscaping, artwork, and the absence of wind ensure virtually year-round enjoyment. The fenced game court is the perfect place to unwind with friends and family. A large lower level wooden patio and lawn area provide peace and serenity.
Multifamily Multigeneration Living: There are seven large bedroom suites with full baths and walk-in closets. Two suites are on the main floor, two including the master suite are on the upper floor, two on the lower floor, and one in an independent wing of the upper floor. The main floor includes the front yard, an oversized three car garage with enormous storage areas, living room, great room, main patio, kitchen, dinette, laundry room, two bedroom suites and a four person dry sauna. Thus it is possible to live entirely on the main floor without ever using any of the three stairs. The lower level two bedroom suites have pool and garden views and can constitute independent one or two bedroom apartment with a sitting room. A wine cellar and storage areas are also on the lower level. Parts of the lower level can also be used as the pool house. The bedroom suite with a sitting room in the independent wing of the upper floor constitutes the second one bedroom apartment. The upper floor huge master suite has a patio and a convenient sitting area with a cozy marble gas fireplace. The master bath has double hot tub, double vanity, double shower, and double walk in closet. The other bedroom suite on the upper floor also has a sliding door to the patio. The Bay views from both these suites are breathtaking.
- Lot: 1.73 acres
- Single Family
- Built in 1989
- Heating: Other
- Last sold: Dec 2009 for $2,496,000
- Basketball Court
- Cable Ready
- Controlled Access
- Disability Access
- Double Pane/Storm Windows
- Fenced Yard
- Finished basement, 520 sqft
- Flooring: Carpet, Hardwood, Tile, Other
- Gated Entry
- Hot Tub/Spa
- Jetted Tub
- Parking: Garage - Attached, 3 spaces, 860 sqft
- Security System
- Sports Court
- Sprinkler System
- Tennis Court
- Vaulted Ceiling
- View: City, Mountain, Park, Territorial, Water
- Wet Bar
- Immense boundary wall, large front yard, central vacuum, breathtaking Bay views
- Breakfast nook
- Dining room
- Family room
- Laundry room
- Master bath
- Mud room
- Recreation room
- Walk-in closet
- Exterior material: Stucco
- Roof type: Composition
- Room count: 12
- # Stories: 3.0
- Unit count: 1
- Floor size: 6,440 sqft
- Last remodel year: 2012
- Lot depth: 6784
- Lot width: 6784
- Parcel #: 030071210
- Zillow Home ID: 15519320
The Value Range is the high and low estimate market value for which Zillow values a home. The more information, the smaller the range, and the more accurate the Zestimate. See data coverage and accuracy table
Don't agree with your home's Zestimate? Owners can edit their home facts to make the Zestimate more accurate. Plus, you can leave an opinion on your Zestimate value below. Just click "Owner Estimate".
The Rent Range is the high and low estimate for which an apartment or home could rent. The more information we have, the smaller the range, and the more accurate the Rent Zestimate. See data coverage and accuracy table
Popularity on Zillow
Market guideZillow predicts 94010 home values will increase 2.4% next year, compared to a 3.5% increase for Hillsborough as a whole. Among 94010 homes, this home is valued 383.1% more than the midpoint (median) home, and is valued 64.4% more per square foot.
Foreclosures will be a factor impacting home values in the next several years. In 94010, the number of foreclosures waiting to be sold is 2.6% less than in Hillsborough, and 12% higher than the national average. This lower local number could help 94010 home values rise more quickly than other regions in Hillsborough.
Learn more about forecast calculations or 94010 home values.
|3030 Ralston Ave Hillsborough, CA||$10.7M||5||8||6,290|
|26 Orange Ct Hillsborough, CA||$8.6M||4||6||7,110|
|525 Chateau Dr Hillsborough, CA||$6.52M||8||8.5||6,950|
|170 New Place Rd Hillsborough, CA||$7.54M||6||7||6,436|
|20 Orange Ct Hillsborough, CA||$4.63M||5||3.5||4,240|
|700 Jacaranda Cir Hillsborough, CA||$4.29M||6||5.5||4,860|
|3050 Ralston Ave Hillsborough, CA||$4.55M||3||3.5||3,840|
|3000 Ralston Ave Hillsborough, CA||$7.98M||3||5.5||8,165|
|30 Orange Ct Hillsborough, CA||$2.94M||4||3.5||3,020|
|555 Chateau Dr Hillsborough, CA||$3.69M||3||3.5||4,230|
|160 New Place Rd Hillsborough, CA||$4.61M||4||5.5||5,045|
|150 New Place Rd Hillsborough, CA||$13.9M||6||7||11,000|
|150 New Place Rd Hillsborough, CA||$11.4M||6||7||11,000|
|705 Jacaranda Cir Hillsborough, CA||$3.26M||4||3.5||3,100|
|15 Orange Ct Hillsborough, CA||$2.91M||5||3.5||3,160|
|3080 Ralston Ave Hillsborough, CA||$13.8M||9||9.5||13,987|
|40 Orange Ct Hillsborough, CA||$2.9M||4||2.5||3,330|
|25 Orange Ct Hillsborough, CA||$3.93M||5||5||4,700|
|565 Chateau Dr Hillsborough, CA||$5.72M||6||5.5||5,935|
|138 New Place Rd Hillsborough, CA||$4.43M||3||4||3,680|
Nearby Schools in Hillsborough
Burlingame High (assigned)8-121.8 mi
Data by GreatSchools.org
Email successfully sent!Submission failed!
Find out how much house you can afford and get pre-approved for a mortgage in minutes.
- Fast & easy
- Top-notch lenders
- Safe & secure
A Zillow Confirmed Lender will call you.
A Zillow Confirmed Lender will also be calling you back to assist with pre-approval.
Thanks for using Zillow!