translateTranslate

24 WARREN RD, SAN MATEO, CA 94401

favoriteSave
Save 24 WARREN RD, SAN MATEO, CA 94401
directionsDirection
Get Driving Direction to 24 WARREN RD, SAN MATEO, CA 94401
printPrint
Print 24 WARREN RD, SAN MATEO, CA 94401

$5,988,000

Mortgage Calculator
  • 4 Beds
  • 6.0 Baths
  • 5421 Sqft
  • Single Family
  • Active
  • MLS# ML81707148

Property Details for 24 Warren Rd

Brand new, 4 bed/5.5 bath custom built home in sought-after San Mateo Park. A masterpiece, designed by respected local Architect Jerry Winges and built by Loerke-Cresci, the home's layout offers a friendly and inviting atmosphere well suited for entertaining, with the functionality for everyday living. From the hand-scraped walnut floors, to the intricately designed lighting inlay within the vaulted ceilings, no detail was overlooked. The 4,337 sq ft main residence sits on a 15,760 sq ft lot and includes a 1,084 sq ft guest house, 250 square foot maid's quarters and 2 car garage as well as a relaxing and elegant outdoor entertaining space with pool and spa. From surround sound both inside and out, to temperature control and security which can be controlled remotely via mobile device, the main residence boasts every upgrade and smart-home feature imaginable. The property is located on a quiet tree-lined street, but simultaneously offers walkability to exciting downtown Burlingame.

Listing courtesy of: Alain Pinel Realtors

INTERESTED IN THIS PROPERTY

PROPERTY DETAILS

  • Property Type: Single Family
  • List Price: $5,988,000
  • Sqft: 5,421
  • Acres: 0
  • Beds: 4
  • Baths: 6.0
  • City: San Mateo
  • State: CA
  • Zip: 94401
  • Area: : San Mateo Park / El Cerrito Park
  • Acres: : 0.362
  • Additional Listing Info: : Not Applicable / Not Disclosed
  • Age: : 0
  • Year Built: : 2018
  • Garage Space: : 2
  • Amenities: : Open Beam Ceiling,Walk-in Closet,Vaulted Ceiling,Video/Audio System,Bay Window,Floor Drain,High Ceiling,Security Gate,Skylight(s)
  • Number of Stories: : 2
  • Zoning: : R10010
  • Building Type: : Detached
  • Communications: : Cable TV,Networked,Audio/Video Prewired,Fiber Ready,Intercom
  • Cooling: : Central Forced Air,Multi-Zone,Ceiling Fan
  • Dining Room: : Formal Dining Room
  • Energy Features: : Low Flow Toilet,Solar Power On Grid,Skylight(s),Tankless Water Heater,Thermostat Controller,Double Pane Windows
  • Family Room: : Kitchen/Family Room Combo
  • Fencing: : Gate,Fenced,Complete Perimeter
  • Fireplaces: : Family Room,Gas Burning,Living Room,Master Bedroom
  • Fireplaces Min: : 3
  • Flooring: : Marble,Tile,Hardwood
  • Foundation: : Quake Bracing,Concrete Perimeter and Slab,Crawl Space
  • Garage Max: : 2
  • Garage Min: : 2
  • Garage Parking Features: : Detached
  • Heating: : Heating - 2+ Zones,Radiant,Solar and Gas,Central Forced Air
  • Kitchen: : Ice Maker,Dishwasher,Cooktop - Gas,Freezer,Hood Over Range,Island,Microwave,Pantry,Refrigerator (s),Oven Range - Built-In, Gas
  • Laundry: : Washer/Dryer
  • Maximum Lot Size: : 15760.00
  • Minimum Lot Size: : 15760.00
  • Parcel Number: : 032-061-040
  • Pool: : Fenced
  • Roof: : Composition
  • Style: : Arts & Crafts
  • Water: : Public
  • Branded Virtual Tour: 
  • Additional Remarks: 

LISTING HISTORY

  • Previous Price: 
  • Price Change: 
  • Price Change Date: 
  • Previous Status: 
  • Status Change Date: 

Mortgage Information


Results

Monthly insurance: 
$0.00
Monthly taxes: 
$0.00
Monthly payment: 
$0.00
Total monthly payment: 
$0.00

AREA OVERVIEW


radio_button_unchecked
location_on

The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than Legacy Real Estate & Associates are marked with the MLSListings IDX icon and detailed information about them includes the names of the listing brokers and listing agents.

Copyright 2018 MLSListings Inc. All rights reserved.

Based on information from MLSListings MLS as of 08/15/2018 All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information.

Notice to any user of this website

Legacy Real Estate & Associates provides a school and school district attendance boundary search feature. However, we do not verify or guarantee attendance availability. Legacy Real Estate & Associates advises anyone using the school and school district attendance boundaries search feature to contact the preferred school and school district directly for verification and attendance availability.

keyboard_arrow_up