25 Longview Court

Hillsborough , CA 94010

MLS#: ML81980363

$6,950,000

Status: Closed
Listing number: ML81980363
Listing provided by: Coldwell Banker Realty
Listing agent phone: None
Last update: 11 months ago
On site: 1 year, 1 month ago
Browse Properties
Main image without alt text

Property

Beds

5

Full Baths

4

1/2 Baths

1

Year Built

2000

Sq.Footage

4,990

Regally situated on a .59-acre lot with breathtaking Bay views, this stunning +/-5,000 sq. ft. residence offers 5 bedrooms and 4.5 baths, blending luxury and warmth in a seamless, sun-drenched floor plan. Highlights include an impressive living room with floor-to-ceiling windows that frame the incredible views and French doors that open to the exceptional rear grounds, a large formal dining room, chefs kitchen/family room ensemble with island and breakfast nook, and French doors that access a vast terrace and the amazing grounds. 3 bright bedrooms with 2 bathrooms plus 2 powder rooms complete one wing of the main level. Upstairs features a sizable primary bedroom retreat with wall-to-wall windows that capture spectacular views, built-in cabinets, fireplace, 2 walk-in closets, spa-like marble bath, and a laundry closet. The substantial 5th bedroom wing includes a great room, full bath, rear patio access, lower-level gym/office, and large wine room--the perfect place for guests or recreation. Outside, the majestic grounds offer elegant & lush landscaping, meandering pathways, incredible vistas, large patios, outdoor kitchen, firepit, sweeping level lawns, fountain, rose garden, and a putting green. Completing this showcase home is an attached 3-car garage and a large laundry room.

Features & Amenities

Interior

  • Total Bedrooms

    5

  • Bathrooms

    4

  • 1/2 Bathrooms

    1

  • Cooling YN

    YES

  • Cooling

    N/A

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Central

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    3

  • Construction Materials

    Stone

  • Parking

    Attached, Gated, Off Street

  • Pool

    No

  • View

    Bay, Bridge(s), City Lights

Area & Lot

  • Lot Size(acres)

    0.5878

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

Price

  • Sales Price

    $6,950,000

  • Sq. Footage

    4, 990

  • Price/SqFt

    $1,392

HOA

  • Association

    No

School District

  • Elementary School

    N/A

  • Middle School

    N/A

  • High School

    N/A

Property Features

  • Stories

    2

  • Sewer

    Public Sewer

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


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

Middle School

High School

Listing Courtesy of Jim Arbeed , Coldwell Banker Realty

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.

(818) 321-0175

Lina@theosrealty.com


* 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.
Regally situated on a .59-acre lot with breathtaking Bay views, this stunning +/-5,000 sq. ft. residence offers 5 bedrooms and 4.5 baths, blending luxury and warmth in a seamless, sun-drenched floor plan. Highlights include an impressive living room with floor-to-ceiling windows that frame the incredible views and French doors that open to the exceptional rear grounds, a large formal dining room, chefs kitchen/family room ensemble with island and breakfast nook, and French doors that access a vast terrace and the amazing grounds. 3 bright bedrooms with 2 bathrooms plus 2 powder rooms complete one wing of the main level. Upstairs features a sizable primary bedroom retreat with wall-to-wall windows that capture spectacular views, built-in cabinets, fireplace, 2 walk-in closets, spa-like marble bath, and a laundry closet. The substantial 5th bedroom wing includes a great room, full bath, rear patio access, lower-level gym/office, and large wine room--the perfect place for guests or recreation. Outside, the majestic grounds offer elegant & lush landscaping, meandering pathways, incredible vistas, large patios, outdoor kitchen, firepit, sweeping level lawns, fountain, rose garden, and a putting green. Completing this showcase home is an attached 3-car garage and a large laundry room.

25 Longview Court

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

Related Properties

LOWER SOUTH CHALET: ARCHITECTURAL SIGNIFICANCE MEETS FAMILY WARMTH! Homes are simply not built with this high style anymore! A rarity to the market, this is an architecturally significant statement equally at home as a fine art gallery or warm and cozy family retreat. Sophistication cascades throughout truly ENORMOUS room sizes, while never compromising daily function and inviting indoor/outdoor character. In the heart of Lower South Hillsborough, we celebrate one of the San Francisco Peninsula's top luxury enclaves, a neighborhood ranking within the Top 10 on median sales price in the United States, decade after decade. Around the corner from $18,000,000 estates, less than a mile from Crystal Springs Uplands, just 1.4 mile from North Elementary, 1.7 mile to downtown Burlingame Ave Apple Store. The romance of the Chalet is the theme: rustic charm with contemporary features. Sequestered within noble trees, imbued with spirit of a special-occasion getaway, & arresting in design flair, this is your conversation piece. | 5 beds, 4.5 baths | Expanded & Updated by acclaimed architect John A. Matthews, AIA | Huge Master Suite | Side Party Terrace | Separate Pool Area | Mill Valley-style woodsy vibes w/easy ADU potential | 4-car attached garage + motor court for basketball & yard access
#ML82026911

Hillsborough

300 Glendale Road

5 Beds

4 Baths

4,150 Sq.Ft.

$5,788,000

MLS#: ML82026911

A rare opportunity. Located in the coveted lower-Hillsborough Ryan Tract Neighbourhood. 1735 Crockett Lane is an ideal home for entertaining! The home is located on a quiet cul-de-sac. The common area includes a family room, breakfast nook, formal dining room, and formal living room area. This one story 4-bedroom 3 bath home is expansive and private. Plenty of storage space. Located on a private lot with a generally flat backyard on a desirable cul-de-sac street. High ranked school district. North School, Crocker Middle School, and Burlingame High School. Located near Downtown Burlingame with plenty of stores and restaurants. There are an additional bedroom and bathroom located on the opposite side of the common area. Over the years this has been used as a bedroom or office, but it is ideal for a possible au-pair suite or in law suite. Possibility to expand home to 4500 SqFt and add an additional dwelling unit (ADU). Buyer to verify all information prior to close of escrow and removal of all contingencies.
#ML82025145

Hillsborough

1735 Crockett Lane

4 Beds

3 Baths

3,000 Sq.Ft.

$7,200,000

MLS#: ML82025145

This beautifully designed 5-bedroom, 5 full and 2 half-bath home blends timeless sophistication with modern comfort in one of Hillsboroughs most sought-after neighborhoods. A grand two-story foyer welcomes you in, leading to formal living and dining rooms perfect for entertaining. A private guest suite on the main level adds flexibility, while a butlers pantry hallway and separate walk-in pantry provide smart, functional storage. The expansive great room unites the family area, breakfast nook, and chefs kitchen, opening through folding glass doors to a spacious deck with a tranquil fountain and outdoor fireplaceideal for indoor-outdoor living. Downstairs, a media room with wet bar, temperature-controlled wine cellar, full bath, and additional bedroom offer space to relax and unwind. Upstairs, the luxurious primary suite features a sitting area, two walk-in closets, and a sunlit balcony. Two additional en-suite bedrooms and a handsome wood-paneled office complete the home. Premium finishes include motorized Hunter Douglas blinds and outdoor privacy screens and a full Savant Smart Home System for effortless control of lighting, climate, media, and music.
#ML82022917

Hillsborough

625 W Santa Inez Avenue

5 Beds

5 Baths

6,035 Sq.Ft.

$8,180,000

MLS#: ML82022917

Experience the perfect blend of luxury, elegance & California living in this breathtaking Mediterranean estate. This residence offers unparalleled privacy & sweeping views of the San Francisco Bay & surrounding mountains. A long, gated driveway welcomes you setting the stage for the home's elegant interior. Step inside to a dramatic, light-filled foyer featuring a graceful winding staircase that leads into an expansive living room framed by floor-to-ceiling windows showcasing the spectacular views.The gourmet chef's kitchen is comes complete with a large center island, elegant stone countertops, & top-of-the-line Viking stainless steel appliances. A richly wood-paneled library/office & spacious formal living & dining areas add sophistication, while new double-pane windows enhance comfort & energy efficiency throughout the home.Upstairs a primary suite awaits, featuring a spa-inspired bath with a jetted soaking tub, alongside generously sized bedrooms offering comfort & privacy. The impeccably landscaped grounds create a true oasis, featuring a resort-style pool & spa, & private tennis court. Perfect for both relaxation & entertaining, this property offers an unmatched lifestyle in one of California's most coveted settings.
#ML82020606

Hillsborough

75 Eugenia Way

5 Beds

4 Baths

6,780 Sq.Ft.

$7,980,000

MLS#: ML82020606

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

Price reduced
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,999,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

GREAT NEW PRICE! PREMIUM QUALITY THAT COULDN'T BE REPRODUCED AT THIS NUMBER! Casa Serena dazzles with authentic quality and the romance of Riviera retreats, yet delivers its new owner a platform of thoroughly modern livability. The estate you see today was meticulously re-imagined, expanded, and re-built to the highest standards. Spanning 5,600 sq. ft., you are invited to marvel at the "composition within the composition." Top flight luxury designer elements of Venetian plaster walls, vaulted ceilings of 14-15 feet, European tilework, mahogany doors, and made to order light fixtures by Steven Handelman. Wolf, SubZero, Miele. With unabashed inspiration from the great homes of Southern California, where the Spanish Colonial Revival celebrates its indoor/outdoor joie de vivre, this estate lavishes in sun from south and east. More than a house, this is an experience, a lifestyle, a feeling. Like a timeless book or a classic wine, this is an experience to become immersed within. *4 beds, 4 baths, plus incredible lower level apartment of 1500 feet with kitchen, recreation room, gym (or possible 5th bedroom) pro wine cellar, and mud room *World class detail *Resort caliber pool, spa, flat lawn, orchard *Spectacular Primary Suite View Terrace *Huge 3-car * Arch Digest throughout! *
#ML82001980

Hillsborough

25 Searsville Court

4 Beds

4 Baths

5,600 Sq.Ft.

$7,100,000

MLS#: ML82001980

- property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

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