Features & Amenities

Interior

  • Total Bedrooms

    5

  • Bathrooms

    4

  • 1/2 Bathrooms

    1

  • Cooling YN

    YES

  • Cooling

    Central Air

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Forced Air

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    2

  • Parking

    Attached

  • Pool

    No

  • View

    Bay, Canyon, Hills

Area & Lot

  • Lot Size(acres)

    0.5333

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

Price

  • Sales Price

    $5,249,000

  • Sq. Footage

    3, 460

  • Price/SqFt

    $1,517

HOA

  • Association

    NO

School District

  • Elementary School

    Other

  • Middle School

    Other

  • High School

    N/A

Property Features

  • Stories

    2

  • Water Source

    Public

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

San Mateo

Elementary School

Other

Middle School

Other

High School

Listing Courtesy of Judy Citron , Compass

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent LinaMirza

FOUNDER

LinaMirza

Call Lina today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Completely transformed with a sophisticated modern aesthetic, this Hillsborough home showcases sweeping and spectacular Bay and San Francisco skyline views. High end down to the studs remodel in 2013 with no expense spared. Located in the coveted Lakeview neighborhood on just over one-half acre, features a striking two-story facade and generous outdoor spaces designed for entertaining around a sparkling pool, elevated spa, fire pit, and view decks. Inside, a dramatic double-height foyer highlights a sculptural staircase with glass panels and a wine display wall. Soaring ceilings and a two-story wall of windows frame the views in the open living and dining area with elevated gas fireplace and statement chandelier. The chefs kitchen offers lacquered cabinetry, quartz-wrapped island with glass counter seating, premium appliances, walk-in pantry, and adjoining casual dining area with banquette and family room that opens to the deck. Five bedrooms including one on the main level ideal for an office, plus a luxurious upstairs primary suite with fireplace, balcony, sitting area and spa-inspired bath. Smart home automation, air conditioning, and epoxy-finished large garage add modern convenience. Excellent Hillsborough schools with easy access to Highway 280 and downtown Burlingame.

1340 View Haven Road

Message successfully sent.

What would you like to know?

Related Properties

THE RULES OF REAL ESTATE ATTRACTION: LOCATION, LIVABILITY, MOVE RIGHT IN! The great lifestyles always seem to have a universal appeal and purity of function. Here, in the heart of Lower North Hillsborough estate country, we find a smooth single-story design, totally renovated, ready to purvey the universal luxury of the Peninsula. How rare art thou? Let me count the ways...this single-story design is surely scarce at any price point: no stairs to worry about, all remodeled condition, and a 5-bedroom, 4.5 bath floorplan opening out to flat private garden. These picturesque environs, dappled by vintage oaks & timeless mansions, are within a 30 minute stroll of downtown Burlingame Avenue. | Dramatic Lobby of 12 ft +\- ceilings | Living and Dining Rooms are elegant statements with 10 ft. 4 inch ceilings & bay windows | Grand size open rooms treated with hardwood floors, crisp white moldings, designer palette | Large updated chef's kitchen open with bistro nook | Huge Family Room Opens to Flat Yard | Separate Bedroom Suite ideal for Office or In-Law|Au Pair with private entry | Immense Master Suite with 2 walk-in closets & marble bathroom + soothing green garden view | Immaculate condition and perfect Floorplan | Walk to Burlingame Ave | Top Schools | #1 Neighborhood amongst mansions
#ML82022735

Hillsborough

515 N San Raymundo Road

5 Beds

4 Baths

3,570 Sq.Ft.

$5,850,000

MLS#: ML82022735

For the very first time in its storied history, this 1936 family estate is being offered to the public. This classic English Tudor is a landmark in its own right, a home that gracefully bridges Hillsborough's past and present. Set on nearly an acre of level land with views of the Bay and San Francisco skyline, the residence embodies timeless elegance. Its centerpiece is a remarkable floating spiral staircase anchored only at the bottom and top. With a large open kitchen connecting to the family room, plus 5 bedrooms and 5 full bathrooms (2 half baths), the estate is ready and waiting for its next owner (some photos are virtually staged)! There is a bedroom, library and full bathroom on the main level. The primary bedroom and 3 add'l bedrooms are upstairs. Outdoors, the gardens carry the signature of renowned landscape architect Thomas Church, whose designs shaped much of California's most beautiful private estates with broad lawns, graceful plantings and private spaces. Built by the Wisnoms, one of the founding families of San Mateo, The National Bank of San Mateo and cousins of Wisnoms Hardware family. This offering represents a rare opportunity: to own a piece of Hillsborough history and to become the next steward of a home designed with both legacy and livability at its core.
#ML82022191

Hillsborough

923 Hayne Road

5 Beds

5 Baths

5,050 Sq.Ft.

$5,995,000

MLS#: ML82022191

Situated on a commanding half-acre lot, this inviting home offers over 4,400 sq. ft. of casual elegance in a picturesque setting. A dramatic foyer leads to the elegant living room with a grand fireplace, wall of windows, and access to a huge rear deck. The gracious dining room features oversized windows that frame amazing views of the outdoors. Nearby, the large family room with a fireplace, floor-to-ceiling windows, and rear deck access, is ideal for gatherings or just soaking in the stunning scenery. The adjacent chefs kitchen with island, incredible stone counters, and a sun-filled breakfast room, is perfect for everyday culinary enjoyment. An office with custom desks & cabinets, large laundry/mud room, 2 half baths, plus a luxurious primary retreat with fireplace, private deck, and a spa-inspired marble bath complete the main level of this exceptional home. The lower level includes 3 sizable bedrooms with en-suite baths, and a temperature-controlled wine room. The expansive backyard is a private oasis with a pool, mature trees, and plenty of space for outdoor enjoyment. Located near top-rated schools, parks, and local amenities, this property blends timeless sophistication with everyday comfort, offering a rare opportunity to experience the best of North Hillsborough living.
#ML82020477

Hillsborough

1162 Barroilhet Drive

4 Beds

4 Baths

4,430 Sq.Ft.

$6,295,000

MLS#: ML82020477

Beautifully reimagined single-level home in coveted Lower Hillsborough. This 4-bedroom, 3.5-bath residence offers a thoughtfully updated living space with a seamless blend of modern design and timeless comfort.  Inside, you'll find all-new flooring, custom cabinetry, and a chefs kitchen featuring Miele appliances including an induction cooktop and built-in espresso machine. The home is filled with natural light through all-new windows and sliding doors, complemented by new can lighting throughout.  Additional highlights include a refreshed fireplace, a stylish wet bar, and a brand-new garage door. The exterior has been upgraded with a new metal roof, freshly landscaped grounds, and new concrete patio space, perfect for entertaining or relaxing in the private backyard (large enough to add a pool and ADU).  Located on a private street minutes from top-rated schools, parks, and downtown conveniences, this turnkey property is ready for its next chapter.
#ML82019668

Hillsborough

340 Arden Road

4 Beds

3 Baths

3,040 Sq.Ft.

$5,998,000

MLS#: ML82019668

Nestled in Hillsborough's prestigious Ryan Tract, this exceptional residence blends privacy, convenience, & charm. Just minutes from Downtown Burlingame & Broadway, it offers easy access to Highway 101 and top-rated schools. A welcoming front porch leads into a bright & airy interior w/ hardwood floors, recessed LED lighting, and expansive windows. The elegant dining room features a bow window & connects to the updated eat-in kitchen w/ granite countertops, a glass tile backsplash, high-end appliances, & a breakfast nook. The living room centers around a striking fireplace flanked by French doors & a picture window. A refined study offers built-in shelving, a fireplace, a wet bar, & backyard access. The primary suite includes custom built-ins, fireplace, French doors to a private deck, & a spa-like bath with a jetted tub, a walk-in shower w/ a functioning steam bath unit, & a walk-in closet. Upstairs, a versatile art studio opens to a private balcony. 2 additional en-suite bedrooms & a powder room complete the home. The beautifully landscaped backyard features a large patio w/ a fireplace, a lush garden, & an expansive lawn. A paver motor court & discreet garage enhance curb appeal. 680 Fairway Circle is a rare opportunity in one of Hillsborough's most sought-after neighborhoods.
#ML81999682

Hillsborough

680 Fairway Circle

3 Beds

3 Baths

3,540 Sq.Ft.

$5,650,000

MLS#: ML81999682

 - property

Send a message

Message successfully sent.

Your message

Reason for contacting?

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

Already have an account ? Login here