MLS Search

Search Results

57 results returned

Search Results


Listing IDMl81791341
CRMLS
Price$5,300,000
Bedrooms4
Total Baths6
Full Baths5
Partial Baths1
SqFt 4,339
Acres 0.360
StatusActive
Spectacular new home in one of Northern Californias most desirable communities. Located in historic San Mateo Park, 88 Warren Road beautifully captures the character of the Park while artistically...
Listing courtesy of Elena Berry, DRE #01753107 from Compass
r0
Listing IDMl81793502
CRMLS
Price$3,900,000
Bedrooms4
Total Baths4
Full Baths2
Partial Baths2
SqFt 3,980
Acres 0.260
StatusActive
As Seen on American Dream TV: Hayward House! Introduced by prolific gardens, this magnificently restored circa 1924 estate begins w/a formal entrance & Palladian windows that are signature &...
Listing courtesy of Alan Canas, DRE #01793936 from Coldwell Banker Realty
r0
Listing IDMl81790733
CRMLS
Price$3,050,000
Bedrooms3
Total Baths4
Full Baths3
Partial Baths1
SqFt 2,893
StatusActive
Unique and rarely available 3BR/3BA Penthouse home in coveted Gramercy on the Park. Formal entry opens to both Dining Room and office/3rd BR suite. Large kitchen, featuring skylights, granite...
Listing courtesy of Susan Herman, DRE #00688139 from Compass
r0
Listing IDMl81771938
CRMLS
Price$2,988,888
SqFt 4,000
StatusActive
Amazing price improvement of over $200K!!! Almost 4% CAP Rate, Unique investment opportunity, consisting of 1 single family home and 2 town homes: 1028 N. Humboldt is new construction built in...
Listing courtesy of Jila Afjei, DRE #01369991 from Better Homes and Gardens Real
r0
Listing IDMl81776631
CRMLS
Price$2,988,888
Bedrooms8
Total Baths7
Full Baths6
Partial Baths1
SqFt 4,000
Acres 0.170
StatusActive
Amazing price improvement!!!!Unique investment opportunity, consisting of 1 single family home and 2 town homes: 1028 N. Humboldt is new construction built in 2019,, is utilized to 2 tenants,...
Listing courtesy of Jila Afjei, DRE #01369991 from Better Homes and Gardens Real
r0
Listing IDMl81789384
CRMLS
Price$2,499,000
SqFt 3,304
StatusActive
Classic, art-deco charm! Located in a well-established neighborhood, this fourplex consists of four classic 1 bedroom, 1 bath units, featuring high ceilings, large rooms, security front door...
Listing courtesy of Ed Gory, DRE #01470796 from Intero Real Estate Services
r0
Listing IDMl81785551
CRMLS
Price$2,420,000
SqFt 2,425
StatusActive
Triplex in popular N. San Mateo location. Consists of detached single-family home with 2 bedrooms and 1 bathroom, 2 car garage. 2nd structure built in 1989 consists of two spacious 1 bedroom/1...
Listing courtesy of Greg Damelio, DRE #01223334 from Compass
r0
Listing IDMl81790270
CRMLS
Price$1,998,000
Bedrooms3
Total Baths3
Full Baths3
SqFt 2,660
Acres 0.220
StatusActive
Modern meets Magnificent! Exquisitely preserved 1906 Craftsman masterpiece w/ amazing grounds on huge lot w/ R4 zoning. Tall ceilings, rich Redwood trim, original light fixtures & true...
Listing courtesy of Miriam Chirko, DRE #01130688 from Coldwell Banker Realty
r0
Listing IDMl81788718
CRMLS
Price$1,899,000
Bedrooms4
Total Baths4
Full Baths4
SqFt 2,183
Acres 0.130
StatusActive
Gorgeous single story expansion and remodel from top to bottom. Classic contemporary combines casual comfort, elegance, and modern luxury. Situated on a large, private corner lot with new...
Listing courtesy of Lisa Morris, DRE #01402358 from Kimberly Welch, Broker
r0
Listing IDMl81779791
CRMLS
Price$1,778,000
Bedrooms2
Total Baths3
Full Baths2
Partial Baths1
SqFt 2,070
StatusActive
Extremely rare park facing corner unit at Gramercy on the Park. Gramercy on the Park is San Mateos most desirable condominium development with a stunning atrium, heated pool, gym, library,...
Listing courtesy of Thomas C. Werbe, DRE #01482688 from MW Properties, Inc.
r0
Listing IDMl81779281
CRMLS
Price$1,749,000
SqFt 2,165
Acres 0.070
StatusActive
Beautifully remodeled 3-bedroom and 2-bath home plus a separate 1-bed, 1-bath in-law suite. One-level main home has an open floor plan with great room for living, formal dining, and kitchen with...
Listing courtesy of Raziel A. Ungar, DRE #01701234 from Compass
r0
Listing IDMl81779306
CRMLS
Price$1,749,000
SqFt 2,165
StatusPending
Beautifully remodeled 3-bedroom and 2-bath home plus a 1-bed, 1-bath in-law suite. One-level main home has an open floor plan with great room for living, formal dining, and kitchen with breakfast...
Listing courtesy of Raziel A. Ungar, DRE #01701234 from Compass
r0
Listing IDMl81790850
CRMLS
Price$1,728,000
SqFt 1,958
StatusActive
Excellent Investment Opportunity in a wonderful & desirable San Mateo neighborhood, in close proximity to downtown San Mateo, the lovely Central Park, CalTrain station, other public transportation...
Listing courtesy of Corina Colby, DRE #00912109 from Coldwell Banker Realty
r0
Listing IDMl81779188
CRMLS
Price$1,725,000
Bedrooms2
Total Baths3
Full Baths2
Partial Baths1
SqFt 2,035
Acres 2.120
StatusActive
Welcome to the prestigious Gramercy On The Park, located in San Mateo across from Central Park. This rarely available corner unit consists of 2,035 square feet and has unobstructed views from...
Listing courtesy of Thomas C. Werbe, DRE #01482688 from MW Properties, Inc.
r0
Listing IDMl81785959
CRMLS
Price$1,365,000
Bedrooms2
Total Baths2
Full Baths2
SqFt 1,786
StatusActive
Gorgeous condominium in the heart of downtown San Mateo at the desired "Gramercy on the Park"! Excellent location between San Francisco and Silicon Valley, this is downtown living at its best!...
Listing courtesy of Mark Johnson, DRE #00667906 from Coldwell Banker Realty
r0
Listing IDMl81790093
CRMLS
Price$1,350,000
Bedrooms3
Total Baths2
Full Baths2
SqFt 1,584
Acres 0.140
StatusPending
Lovely South Shoreview Mid-Century Modern home on quiet street, minutes from downtown San Mateo. An inviting courtyard with rose bushes and beautiful mature trees welcome you with great curb...
Listing courtesy of Boyenga Team, DRE #70010882 from Compass
r0
Listing IDMl81793328
CRMLS
Price$1,300,000
Bedrooms2
Total Baths2
Full Baths2
SqFt 1,704
StatusActive
Beautifully updated Central Park Condo on 2nd floor. 2 Bed (one is master), 2 full baths and two patios with park views. Interior highlights: Dine-in kitchen with park-side dining nook,...
Listing courtesy of Christopher Eckert, DRE #01456626 from KW Peninsula Estates
r0
Listing IDMl81791417
CRMLS
Price$1,295,000
Bedrooms3
Total Baths2
Full Baths2
SqFt 959
Acres 0.090
StatusActive
Welcome to this extensively remodeled home that was taken down to its studs and recently redone. There's a fabulous new ADU unit that's perfect for the extended family or supplement your income. ...
Listing courtesy of Peter Vece, DRE #00472241 from Golden Gate Sotheby's Internat
r0
Listing IDMl81786984
CRMLS
Price$1,288,000
Bedrooms3
Total Baths1
Full Baths1
SqFt 1,490
Acres 0.180
StatusActive under contract
Welcome home! This charming three bedroom and one bathroom San Mateo Home features a popular open floor plan. Stainless steel appliances, granite countertops, maple wood cabinets in the kitchen...
Listing courtesy of Elizabeth Nguyen, DRE #01403644 from Berkshire Hathaway Home Servic
r0
Listing IDMl81783458
CRMLS
Price$1,225,000
Bedrooms2
Total Baths2
Full Baths2
SqFt 1,786
StatusActive
Welcome to the prestigious Gramercy On The Park, located in San Mateo across from Central Park. This condo has two large bedrooms and two bath rooms, a wet bar, laundry in unit, a large enclosed...
Listing courtesy of Marc Romer, DRE #00928979 from RE/MAX Gold
r0
Listing IDMl81789433
CRMLS
Price$1,188,000
Bedrooms3
Total Baths1
Full Baths1
SqFt 1,210
Acres 0.120
StatusPending
Welcome Home~Pride of ownership is seen inside and out! This charming home offers wonderful curb appeal with a lovely corner lot featuring gardens peppered with fruit trees and flowering plants,...
Listing courtesy of Carmen Miranda, DRE #01065975 from Compass
r0
Listing IDMl81790149
CRMLS
Price$1,098,000
Bedrooms2
Total Baths1
Full Baths1
SqFt 820
Acres 0.115
StatusActive
Welcome to this charming, 2 bedroom, 1 bathroom, plus office. As you enter you will be mesmerized by the high ceilings, glamorous fireplace w/ decorative hearth below the built in shelving, &...
Listing courtesy of Debbie Wilhelm, DRE #01044009 from Coldwell Banker Realty
r0
Listing IDMl81786554
CRMLS
Price$1,098,000
Bedrooms3
Total Baths1
Full Baths1
SqFt 1,384
Acres 0.110
StatusPending
Charming starter home in Shoreview! 3BR/1BA features a spacious kitchen w/ample cabinets and counter space, and a brand new stove. The DR and LR areas offer a seamless flow for entertaining....
Listing courtesy of Rica Ruiz, DRE #01353905 from Meraki Real Estate
r0
Listing IDMl81789581
CRMLS
Price$1,098,000
Bedrooms3
Total Baths2
Full Baths2
SqFt 1,470
Acres 0.120
StatusPending
Charming, Very Spacious Home. Perfect starter home, move in ready, with room for more creative design and upgrades. Large enclosed private enclosed patio, courtyard, spacious living room with...
Listing courtesy of Janay Michaud, DRE #01159101 from Heritage Realty
r0
Listing IDMl81788397
CRMLS
Price$1,050,000
Bedrooms2
Total Baths1
Full Baths1
SqFt 990
Acres 0.090
StatusActive under contract
This home will charm you as soon as you see it, the inviting blue front door and well-manicured front yard are just the first touches on this sweet home. The cozy living room features cork...
Listing courtesy of Debbie Wilhelm, DRE #01044009 from Coldwell Banker Realty
r0
© 2020. The multiple listing data appearing on this website is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for the consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the consumer may be interested in purchasing. All data, including but not limited to 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. Last updated Wednesday, May 27th, 2020.

Based on information from CARETS as of Wednesday, May 27th, 2020 08:52:03 PM. The information being provided by CARETS is for the visitor's personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CARETS, CLAW, CRISNet MLS, i-Tech MLS, PSRMLS and/or VCRDS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.

Any property information referenced on this website comes from the Internet Data Exchange (IDX) program of CRISNet MLS and/or CARETS. 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.
Data services provided by IDX Broker
Category:
Tags:
{"page":"listings","idxID":"d025","zipcode":["94401"],"start":"1","per":"25"}
https://www.brettlawyer.com
results.php
https://search.brettlawyer.com
results