Sign In or Sign Up!
PMZ.com Real Estate
close

$4,250,000

Available Now!

400 Warren RD, San Mateo, CA 94402

400 Warren RD, San Mateo, CA 94402

4 beds  |  4 and 1/2 baths   |  3,800 sqft  |  $1,118 per sq. ft.

Photo
Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo Photo

Add to Saved Folder Add to Saved folder

Add to Rejected Folder Add to Rejected folder

Print Flyer Print a flyer

Share this property:

Share this property via email Email to a friend

Monthly Payment Calculator
Year:
Interest Rate*:
Down Payment:
Monthly Payment: Loading...
 

Get Pre-approved

*Calculations for comparison purposes only. Total does not factor property taxes or insurance.

Description

Modern Spanish-style private home in desirable San Mateo Park walkable to Burlingame & San Mateo, Dreamy light illuminates this 4BD, 4.5 Baths on a corner lot. Fantastic floor plan allows for large social gatherings w/ optimal indoor/outdoor flow. Remodeled Kitchen & great room creates cozy space for families to enjoy time cooking, relaxing or dining.Downstairs guest suite w/ private entrance.Three upstairs bedrooms w/ generous closets & en suites. Master w/ massive walk-in closet and spacious spa-like bath and sauna. Three car garage, rambling landscaped grounds, mature trees, gated entry. Walk to Delfina, Lemonade, Barry's Bootcamp, Mollie Stone's or Safeway. Easy access to Caltrain, 101, 280 and El Camino Real.

Details

  • San Mateo County
  • Single Family Home
  • 4 Bedrooms
  • 4 and 1/2 Bathrooms
  • 1 Story
  • Built in 1908
  • 3,800 SqFt
  • 12150 Acres
  • Style: Country English, Mediterranean
  • Foundation: Concrete Perimeter, Raised
  • Roof: Composition, Tile
  • Floor: Hardwood, Tile
  • Heat: Central Forced Air
  • Fireplace(s): Gas Burning, Living Room, Master Bedroom
  • Water: Public
  • Sewer - Public, Sewer Connected
  • Public Utilities
  • Double Pane Windows, Insulation - Unknown
  • High Ceiling , Security Gate, Vaulted Ceiling , Wet Bar
  • Site Description: Grade - Level
  • View: Neighborhood
  • Outdoor Features: Back Yard, BBQ Area, Courtyard, Fenced, Sprinklers - Auto, Sprinklers - Lawn
  • Attached Garage, Electric Gate, On Street, Parking Area

$4,250,000

Available Now! -

MLS ID# ML81736456

Listing Provided by

Photo
Mark Kaprielian
McGuire Real Estate


Hosted by PMZ Real Estate

(877) 565-2010

Get more info or schedule a showing

        

Question or comment

No spam. No pressure.

PMZ Sign
https://www.scenicoaks.com
Old Republic
American Home Shield
 

Recently sold homes nearby

Photo
426 El Arroyo RD
HILLSBOROUGH, CA 94010
5 bed  4 bath  4297 sqft
Sold for $4,700,000
Photo
129 Occidental AVE
BURLINGAME, CA 94010
5 bed  4 bath  3700 sqft
Sold for $3,800,000
Photo
1585 Bellevue AVE
HILLSBOROUGH, CA 94010
5 bed  3 bath  3818 sqft
Sold for $4,100,000
 
 
Photo
Mark Kaprielian
McGuire Real Estate


Hosted by PMZ Real Estate

(877) 565-2010

Get more info or schedule a showing
     

Question or comment

11:0
MLS#: ML81736456
Listing Office: McGuire Real Estate
Listing Agent: Mark Kaprielian
© 2019 MLSListings Inc. All rights reserved..
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 PMZ Real Estate are marked with the Internet Data Exchange icon and detailed information about them includes the names of the listing brokers and listing agents.
Information provided by seller/other sources, not verified by broker.
All interested persons should independently verify accuracy of all information.
eho
Property Views: 11

Our Service Providers

 
  • ScenicOaks Funding
  • PMZ Commercial
  • PMZ Agricultural
  • American Home Shield
  • Old Republic Home Protection
  • Leading Real Estate Companies of the World
  • Valley NHD

We Have 26 Locations to Serve You

 
Ceres Don Pedro Escalon Fremont Gustine Hilmar
Ione Jackson Jamestown Lodi - North Lodi - South Manteca
Merced Los Banos Modesto - Orangeburg Modesto - Carpenter Modesto - Scenic Dr Newman
Oakdale Pleasanton Ripon Sonora Stockton Tracy
Turlock - Fulkerth Turlock - Geer Customer Care