Tr?id=455543034486470&ev=pageview&noscript=1

24 Warren RD San Mateo, CA 94401San Mateo County

  • 4 beds
  • 5.5 baths
  • 5,421 sqft
  • 15,760 sqft lot
  • $1,032 per sqft
  • 2018 build
  • on site

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. Schedule a Private Showing

Listing courtesy of MLSLISTINGS / Josh Felder / Alain Pinel Realtors

MLS# 81707148 — Report a problem

This home is listed in more than one place. See it here.

Open House Schedule

  1. Green clock
    Sunday, September 30th
    1pm-4pm
View more open houses in San Mateo, CA

Property details for 24 Warren RD

Last refreshed 7 minutes ago

The Building

Year Built:
2018
Structure SqFt:
5421
Foundation:
Concrete Perimeter and Slab, Crawl Space, Quake Bracing
No Of Stories:
2
Roofing:
Composition
Subclass:
Single Family Home
Style:
Arts and Crafts
Type:
Detached

Interior

Family Room:
Kitchen / Family Room Combo
Kitchen:
Cooktop - Gas, Dishwasher, Freezer, Hood Over Range, Ice Maker, Island, Microwave, Oven Range - Built-In, Gas, Pantry, Refrigerator
Dining Room:
Formal Dining Room
Flooring:
Hardwood, Marble, Tile
Additional Rooms:
Basement - Finished, Formal Entry, Media / Home Theater, Separate Living Unit, Wine Cellar / Storage
Amenities Misc.:
Bay Window, Floor Drain, High Ceiling, Open Beam Ceiling, Security Gate, Skylight, Vaulted Ceiling, Video / Audio System, Walk-in Closet
Description Secondary Living Space:
Guest House,Other
Living SqFt:
5421

Room Dimensions

Secondary Living Space Sq Ft:
1,082 Sqft

Financial & Terms

Additional Listing Info:
Not Applicable

Location

Cross Street:
Hurlingham Avenue

The Property

Yard/Grounds:
Back Yard, Balcony / Patio, Courtyard, Deck, Fenced, Sprinklers - Auto, Sprinklers - Lawn
Pool:
Pool - Fenced, Spa - Gas
Parcel Number:
032-061-040
Fencing:
Complete Perimeter, Fenced, Gate
Horse Property:
No

Listing Agent

Sign up to see info
No listing contact info available

Taxes

Property ID
81707148

Beds

Ground Floor Bedroom, Master Suite / Retreat, Walk-in Closet
Total:
4

Baths

Full Baths:
5
Half Baths:
1
Bathroom Features:
Double Sinks, Full on Ground Floor, Marble, Master - Oversized Tub, Master - Stall Shower(s), Skylight, Stall Shower, Stone

The Listing

Automated Valuations Allowed:
1
Structure SqFt Source:
Other
Construction Status
Completed-Never Occupied
Virtual Tour

Heating & Cooling

Cooling Methods:
Ceiling Fan, Central AC, Multi-Zone
Heating Methods:
Central Forced Air, Heating - 2+ Zones, Radiant, Solar and Gas
Fireplaces:
Family Room, Gas Burning, Living Room, Master Bedroom

Utilities

Water Sources:
Public
Sewer/Septic System:
Sewer - Public
Utilities:
Individual Electric Meters, Individual Gas Meters, Solar Panels - Owned
Laundry:
Washer / Dryer
Energy Features:
Double Pane Windows, Low Flow Toilet, Skylight, Solar Power On Grid, Tankless Water Heater, Thermostat Controller

The Community

Security Features:
Fire Alarm, Fire System - Sprinkler, Video / Audio System

Parking

Description and Access:
Detached Garage
Garage Spaces:
2

Extra Units

Second Residence Sq Ft::
250 Sqft

Never miss new listings

Never miss new listings

Be the first to know about new listings between $3,000,000–the sky in this neighborhood

Estately will never spam you or sell your details. You can unsubscribe whenever you’d like.

Monthly cost estimate

24 Warren RD Asking price
$5,598,000
Mortgage
Principal & interest
Assumes 20% down, 30 yr.
fixed, good credit

$21,639

Taxes N/A
Insurance $1,539
Utilities $232 See report
Total $23,410/mo.
This is an estimate

You could potentially make $3,821/mo. by renting this entire home on Airbnb.

Provided by Everbooked Access full report

What it's like to live at 24 Warren RD

Your commute

WalkScore®

Provided by WalkScore® Inc.

85

Very Walkable

Soundscore™

Provided by HowLoud

74

Moderate

Loud Moderate Quiet

Internet Speed

Provided by BroadbandNow®

250 Mbps

About internet speed

XFINITY from Comcast

View a full report

Sale history for 24 Warren RD

DateEventPrice% ChangeSource
Sep 14, 2018Price Changed$5,598,000-6.5%MLSLISTINGS
May 25, 2018Listed / Active$5,988,000MLSLISTINGS

Schools near 24 Warren RD

3

San Mateo Park Elementary School

Public K-5

8

San Mateo High School

Public 9-12

6

Borel Middle School

Public 6-8

3

San Mateo Park Elementary School

Public K-5

N/A

St Catherine Of Siena School

Private K-8

N/A

San Mateo Park Math And Science Magnet

Public K-K

N/A

Russell Bede School

Private 1-6

7

Washington Elementary School

Public K-5

N/A

Stanbridge Academy

Private K-12

N/A

Kinder Academy Montessori

Private K-K

6

Borel Middle School

Public 6-8

N/A

St Catherine Of Siena School

Private K-8

N/A

Russell Bede School

Private 1-6

N/A

Stanbridge Academy

Private K-12

8

San Mateo High School

Public 9-12

N/A

Stanbridge Academy

Private K-12

10

Burlingame High School

Public 9-12

N/A

St Catherine Of Siena School

Private K-8

N/A

Russell Bede School

Private 1-6

N/A

Stanbridge Academy

Private K-12

N/A

Kinder Academy Montessori

Private K-K

* GreatSchools scores are based on a scale from 1 to 10, where 10 is above average.

The school service areas are not definitive and should only be used as guidance. GreatSchools Ratings provided by www.greatschools.org

Tour this home with Estately
Go see 24 Warren RD
Or Call Toll Free 1-800-241-3327
We guarantee that we'll never spam you.

The details on 24 Warren RD: This house located in North Central San Mateo, San Mateo, CA 94401 is currently for sale for $5,598,000. 24 Warren RD is a 5,421 square foot house with 4 beds and 5.5 baths that has been on Estately for 122 days. 24 Warren RD is in the North Central San Mateo neighborhood of San Mateo and has a WalkScore® of 85, making it very walkable. This house is in the attendance area of San Mateo Park Elementary School, San Mateo High School, and Borel Middle School.

Listing courtesy of Josh Felder and Alain Pinel Realtors

Listing Courtesy of: MLSLISTINGS, data current as of 17:00 on Sep 24.

Property Information © 2018 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Copyright © 2018 Estately, Inc. Data displayed here has not been verified by Estately.