Refine Search
Sort by
628 Alhambra RD, San Mateo
$3,812,500
4 Beds ⋅ 3 Baths ⋅ ML81954368 MLS
Tucked away in one of San Mateo's premier enclaves, this sprawling French Provincial estate boasts refined elegance and tremendous proximity to top schools as well as downtown San Mateo. Grand rooms are ideally situated, making for effortless flow through the home, beginning with a romantic formal Living Room with gas fireplace. The separate Family Room offers another fireplace, as well as built-in cabinetry, wet bar, and direct access to the rear yard. A Formal Dining Room touts vaulted ceilings and bar area with window-box seating. An expansive Kitchen offers counter and cabinet space galore, dual sinks, a double wall oven, Bosch range, Sub Zero Fridge as well as a built-in under cabinet beverage fridge, separate breakfast area, and direct yard access. An adjacent Butler Pantry provides additional storage, laundry facilities and a 1/2 Bath as well as a walk in pantry. The private areas of the home consist of 4BRs and 2 full BAs. The oversized primary suite contains a large en-suite bath and direct access to the rear yard via sliding doors. The park like parcel accommodates an extraordinary 3 car garage, (plus additional storage shed) and abundant outdoor areas, which offer endless opportunities for entertaining and play.

628 Alhambra RD, San Mateo

Listed by Jeff Harber, 650-740-2418 from Compass
(If provided) CoList: from

Sold listing courtesy of The Sharp Group from KWPEN

3807 Kingridge DR, San Mateo
$2,630,000
3 Beds ⋅ 3 Baths ⋅ ML81954241 MLS
VIEWS! VIEWS! VIEWS! Wake up to panoramic views from the Bay to Mt Diablo. Tastefully updated single level family home in desirable San Mateo hills. Quiet neighborhood of well-spaced single-family homes, within easy walking/biking distance to local elementary, middle and high schools. Walk to Laurelwood Park with extensive walking and hiking trails. Less than 10 min from Hillsdale Shopping Center or Laurelwood Shopping Center. This lovely 3 bedroom, 2.5 bath home sits on a landscaped and fenced half-acre with expansive patio seating areas, large lawn and abundant fruit and ornamental trees. Features hardwood floors, extensive solid cherry cabinetry and molding, cozy gas fireplace, chefs kitchen with high-end appliances, private en suite main bedroom and large family room. A separate library could also be a formal dining room. Huge amount of enclosed storage under the house.

3807 Kingridge DR, San Mateo

Listed by Philip Watson, 650-274-5187 from Christie's International Real Estate Sereno
(If provided) CoList: from

Sold listing courtesy of Marc Tantoco from CBR

3804 Alameda De Las Pulgas, San Mateo
$2,450,000
4 Beds ⋅ 3 Baths ⋅ ML81953887 MLS
Indulge in the luxury of your own private sanctuary nestled in desirable San Mateo. This exquisite home offers a seamless blend of indoor and outdoor living, with stunning tropical vistas to enhance every moment. Boasting 4 bedrooms and 3 bathrooms, each corner radiates character and light, creating an inviting atmosphere perfect for entertaining. The kitchen, adorned with top-of-the-line appliances, a wine fridge, farmhouse sink, and elegant countertops, sets the stage for culinary adventures. Upstairs, four spacious bedrooms await, alongside airy living and dining areas, while the primary bedroom dazzles with dual walk-in closets. Descend to the lower level where a family room and full kitchen effortlessly transition to your backyard haven, where palm trees sway to the rhythm of relaxation. The pool is an entertainer's dream, this home promises unforgettable gatherings both indoors and out, all within minutes of San Mateo's finest attractions, dining, and recreational delights. Don't let this opportunity slip away, make this oasis your own today!

3804 Alameda De Las Pulgas, San Mateo

Listed by Sophia Waldman, 650-219-8435 from Sotheby's Intl Rlty
(If provided) CoList: from

Sold listing courtesy of Huan Fang from SUEN

167 Crystal Springs RD, San Mateo
$1,972,000
4 Beds ⋅ ML81953888 MLS
An opportunity to own a rarely available and timeless duplex located in the coveted Baywood neighborhood of San Mateo. Each duplex features generous two-bedroom, two-bathroom units. A brick-lined walkway leads you to the nicely updated interior of unit 167. The formal living space is sizable yet welcoming, brightened by natural light from charming corner windows and updated light fixtures. Pass through the dining nook to reach the galley kitchen, which features updated hardware and countertops before continuing onward to a dreamy backyard. With a paver-lined patio, this space serves as an enchanting backdrop for entertaining or relaxing. Dedicated laundry space adds further convenience to this flowing floor plan. Upstairs, plush carpeting extends through the primary suite and guest bedroom, accompanying stylishly updated bathrooms. Enjoy the impeccable neighborhood location, just moments from downtown San Mateo's bustling downtown amenities, and easy access to US-101 and CA-82, SFO, and CalTrain. Live in one and rent the other, rent both, or enjoy it as a multigenerational living arrangement!

167 Crystal Springs RD, San Mateo

Listed by Caroline K. Huo Group, 650-627-3769 from KW Advisors
(If provided) CoList: from

Sold listing courtesy of Greg Bryant from REMAX

50 Mounds RD 702, San Mateo
$1,415,000
2 Beds ⋅ 2 Baths ⋅ ML81953725 MLS
Discover your dream home in the prestigious Top of the Mounds community with this exceptional, over 2,000 square feet single-level condo, featuring recently updated kitchen counters and cabinets, and modernized bathroom countertops and fixtures. Enjoy breathtaking San Mateo and bay views through floor-to-ceiling windows, complemented by a spacious balcony for perfect indoor/outdoor living. This luxurious unit includes an in-unit laundry, forced-air heating & cooling, a 1-car garage, plus an additional deeded parking space. Exclusive amenities include 24-hour security, a gym, saunas, a pool with spa, and guest suites. Conveniently located near downtown San Mateo and Burlingame Avenue.

50 Mounds RD 702, San Mateo

Listed by The Laugesen Team, 650-465-5742 from KW Advisors
(If provided) CoList: from

Sold listing courtesy of RECIP from RCIP

24 Mounds RD B, San Mateo
$2,550,000
3 Beds ⋅ 2 Baths ⋅ ML81953663 MLS ⋅ 24 Mounds BLDG.
WELCOME TO THE MOUNDS BOUTIQUE...GRAND BAY-VIEW CONDOMINIUMS...a rare and intimately scaled complex of just 5 distinguished residences. When you think of this prestigious address, surely the iconic views are at the top of your mind, but also the perfect geography mid-way between Downtown San Mateo and Burlingame. Just around the corner from Hillsborough, 24 Mounds is a masterfully constructed building designed to emulate the grandeur and flow of single-family residences: huge rooms, plenty of entertaining capacity, soaring unobstructed City and Bay vistas, plus indoor/outdoor dynamics of a fabulous dining terrace! Crisp updated condition including light maple hardwood floors, white marble baths, full inside laundry room, 2-Car deeded underground gated secure parking. Dramatic interior possibilities for fine art display for the connoisseur within! You can have it all

24 Mounds RD B, San Mateo

Listed by Geoffrey Nelson, 650-455-3735 from Coldwell Banker Realty
(If provided) CoList: from

Sold listing courtesy of Nick Corcoleotes from CBR

973 Palm AVE, San Mateo
$2,475,000
6 Beds ⋅ ML81953622 MLS
Escape the ordinary & experience the best of both worlds in this stunning duplex!Forget cramped apartments & lack of privacy w/ a combined 3,300 sq.ft. 6 bedrooms & 5 full bathrooms.This spacious haven feels like single-family living w/ convenience & affordability w/ a second unit.Located in a prime location on a beautiful tree lined street right on the outskirts of historic Hayward Park & soak up the California sunshine w/ a short walk to Downtown San Mateo or Central Park.As you approach the private main entrance,youll be surrounded by beautiful greenery & a secluded patio.Immerse yourself inside w/ top-of-the-line Viking appliances,hardwood floors,freshly painted walls,recently installed carpets & new padding.The upstairs unit offers a more intimate setting w/ a full kitchen,balcony,2 beds & 2 baths, creating a cozier experience.Easy commuting to freeways and just minutes away from Downtown San Mateo,Coyote Point Recreation Area,Central Park,Hillsdale shopping center & Hayward Caltrain.Embrace the space in this luxurious duplex that feels like a dream home w/ an ADU.Bonus Features: -2 separate addresses -Main unit is approximately 2,100 sq.ft. -2nd unit is approximately 1,200 sq.ft. -3 car garage (2 for main unit) -Solar panels -Long driveway -Each unit has own laundry

973 Palm AVE, San Mateo

Listed by Thao Dang & Brian Ng, 408-972-1367 from Block Change Real Estate
(If provided) CoList: from

Sold listing courtesy of Lilian (Yan Li) Cai from BLCH

1250 Parrott DR, San Mateo
$2,950,000
4 Beds ⋅ 3 Baths ⋅ ML81953378 MLS
If you're looking for a well-maintained property to customize with your style, 1250 Parrott Drive is your canvas. Nestled in the scenic hills near Tobin Clark Estate, this spacious 4 bed/3 bath+office home has it all: location, views, an open floor plan, a full basement, and private front and back yards. Solid construction paired with the natural light from picturesque windows and skylights offers a great framework. The massive primary suite - combined with an equally massive bathroom, dressing room, private office, and deck access - is ready to be transformed into your personal haven. 3 additional bedrooms on the other wing complete the living quarters. The large, usable backyard is primed for an outdoor oasis for relaxation and entertainment. Whether hosting gatherings or enjoying al fresco dining, this space extends the living area into the beautiful Californian outdoors. Meanwhile, the downstairs basement can be left as a workshop space or refreshed to become a bonus den. The residence is strategically located, close to highly rated schools: Crystal Springs Uplands, Aragon High, and The Odyssey School; shopping hubs: Crystal Spring Village, Laurelwood and CSM Farmers Market; Highways: 92, 280 and 101.

1250 Parrott DR, San Mateo

Listed by Lin Storer, 650-291-1862 from Compass
(If provided) CoList: from Compass

Sold listing courtesy of Gillian Kilroy from APR

310 W 25th AVE, San Mateo
$2,986,000
3 Beds ⋅ 3 Baths ⋅ ML81953338 MLS
The Essence of Beresford Manor! Charm explodes in this captivating open concept, split-level home. Three large bedrooms, three bath residence plus family room, in law suite and/or office. Wonderful curb appeal and well situated with meandering walkway, brick porch, colorful landscape, distinctive shutters and two car attached garage. Formal entry, central hall, crown mouldings, recessed lighting, designer lighting and hardware, rich hardwood, wrought iron and a majestic display of period details. Refined living room enhanced with a central fireplace and large windows. Formal dining room with glass double doors leading directly to the private redwood deck. Open kitchen, updated to perfection with fashionable walls of tile, farmhouse windows, striking counters, shaker cabinets, all new stainless steel appliances and views overlooking the expansive 7500 SF backyard. New and remodeled bathrooms including primary suite. A rare central San Mateo location with a minimum of traffic, ideal for both comfort and safety, emphasizing the ease of ingress and egress. Walk to Farmers Market, award winning schools, Beresford Park/Recreation Center, North Block and Hillsdale's shopping, 25th Ave dining and entertainment. Easy access public transportation and Highway 92. A must see!

310 W 25th AVE, San Mateo

Listed by Mike Bohnert, 650-504-2378 from Coldwell Banker Realty
(If provided) CoList: from

Sold listing courtesy of Alexandra Sung from COMPS

621 Caribbean WAY, San Mateo
$3,000,000
3 Beds ⋅ 3 Baths ⋅ ML81952909 MLS
Total sf. approx. *2,859. Double doors open to airy foyer and a well-designed floor plan. Bedrooms and living areas are located on either side of family room. Foyer opens to a semi-formal dining room and kitchen where guests enjoy chatting with the chef or sitting at an island counter. Kitchen Island doubles as a breakfast bar for two, or more formal first meal of the day at breakfast nook with built-in window seating. Remodeled kitchen features white Quartz countertops, marble mosaic backsplash, and stainless steel appliances Two large bedrooms on one side of central family room, plus guest bath and a full bathroom with vanity and tile floor. Family room has wetbar, soaring beam ceiling with wall of glass and sliding doors out to deck for al fresco dining. Ascend modern glass and metal staircase to guest loft. Main bedroom has a free-standing tub, large walk-in shower with herringbone tile walls, porcelain tile floor, double vanity, walk-in closet with barn door. Impressive living room has tiled fireplace and bench seating area, fireplace, high ceiling with wood beam. Separate studio/office has approx. 288 sq.ft. with running water, vanity, floor heater, beamed ceiling and track lighting. Buyers to confirm guest loft and studio sq ft.

621 Caribbean WAY, San Mateo

Listed by Mary Murphy, 650-773-4999 from Compass
(If provided) CoList: from

Sold listing courtesy of Shaun Walter from CBR

3100 Mena DR, San Mateo
$2,175,000
4 Beds ⋅ 4 Baths ⋅ ML81953016 MLS
Luxury meets convenience with this captivating Meadow Walk Townhome. Boasting a premier corner lot placement and mere steps away from vibrant cafes and restaurants. This Meadow Walk gem is not just beautiful, it's thoughtfully designed. Spanning three levels, this haven offers an abundance of natural light, space, perfect for working remotely, unwinding, or entertaining loved ones. The designer-curated finishes and color palette seamlessly flow throughout, creating a light and airy atmosphere. With four spacious bedrooms and three and a half bathrooms, this residence ranks among the largest and most extraordinary in Bay Meadows. The gourmet kitchen features a massive island, top-of-the-line GE Monogram appliances, a gas stove with six burners, and wine refrigerator. This home embraces modern convenience with side-by-side two-car garage equipped with an EV charger. Smart home features like Nest and A/C, along with surround sound, custom window treatments, and designer lighting, elevate the living experience. Beyond its intrinsic charm, this residence boasts an unbeatable location. Situated just minutes from Hillsdale Mall, Caltrain, Whole Foods, Roblox HQ, Bay Meadows Community parks, Blue Bottle cafe, and an array of restaurants, convenience and fun is at your doorstep.

3100 Mena DR, San Mateo

Listed by Sternsmith Group, 650-678-3847 from Compass
(If provided) CoList: from

Sold listing courtesy of Jennifer Tollenaar from RDFIN

469 W 25th AVE, San Mateo
$3,795,000
4 Beds ⋅ 4 Baths ⋅ ML81952730 MLS
New construction built by Thomas James Homes in the quaint Beresford Manor neighborhood within walking distance to shops, restaurants, and schools. This Traditional-style home is centrally located in the Peninsula with easy commute options to San Francisco or the Silicon Valley, and is in the excellent Hillsdale High School District. The 4-bedroom, 3.5-bathroom home includes an office, dining area and great room centrally located off the foyer. The gourmet kitchen is an entertainers dream with a large eat-at island, and walk-in pantry. The ADU features a kitchenette, en suite bathroom and its own private entrance to the backyard and is ideal for multigenerational living, guest suite or work from home set-up. Ascend the stairs to a versatile loft, 2 secondary bedrooms, a full bathroom, and laundry room with sink and storage. Indulge in the luxuries of the grand suite's walk-in closet and spa-inspired bath, which includes dual vanities, a free-standing soaking tub, and a walk-in shower."

469 W 25th AVE, San Mateo

Listed by Daniel Buckley Chavez, 650-576-5708 from Coldwell Banker Realty
(If provided) CoList: from

Sold listing courtesy of Daniel Buckley Chavez from CBR

68 Darcy AVE, San Mateo
$1,980,000
4 Beds ⋅ 2 Baths ⋅ ML81952496 MLS
Nestled in a friendly neighborhood, this 4b2b single family home is a blend of modern luxury & efficiency, offering a beautiful & comfortable living experience. An attractive exterior w/ cedar siding & landscaped charm lead you into a chic, open floor plan. Meticulously updated, the contemporary kitchen boasts sleek custom cabinets, energy star stainless steel appliances. The dining room flows naturally into a spacious family room, which opens to a delightful flat backyard. Spacious primary suite features sliding barn doors, closet organizers, and a contemporary bathroom. Three large guest bedrooms, an updated second bath, and a spacious laundry room complete the living spaces. Enjoy the eco-friendly amenities such as solar panels, tankless water heater & upgraded electrical system. Updates include new doors & windows, wood floors, stylish fireplace, new light fixtures, etc. Located within walking distance to Hillsdale Mall, shops & restaurants on El Camino, hospital, grocery stores. Easy access to 101 makes commuting a breeze. Welcome home!

68 Darcy AVE, San Mateo

Listed by Wen Guo RE Group, 650-817-5000 from KW Advisors
(If provided) CoList: from

Sold listing courtesy of Jennifer Zhang from KWPEN

4 Whitecliff CT, San Mateo
$2,450,000
5 Beds ⋅ 4 Baths ⋅ ML81952484 MLS
Welcome to 4 Whitecliff Court. The search for your dream home ends here. Every home you've toured, every Pinterest board you've dreamt about has led to this moment. As you pull up to this idyllic court, nestled in the sweeping San Mateo Hills, this home takes center stage. A palatial two-story home, three-car garage, with kitchen island seating for nine and butler pantry to boot. A master bathroom like you've never imagined. You've awakened in the dream. Perfectly curated lighting leads you through each moment of the house. Stop and take in every future memory you and and your family will experience here: Thanksgiving sharing stories across the kitchen, holidays in the formal living room, seeing birthday candles blown out under the dining room lights, throwing a football with dad in the backyard, and sunrise meditations on the master balcony. Welcome to your next chapter.

4 Whitecliff CT, San Mateo

Listed by Tara Briggs, 650-933-6775 from Jibbco Investment Group
(If provided) CoList: from

Sold listing courtesy of Antonietta Llanza from 34147

401 Westmoreland AVE, San Mateo
$3,400,000
3 Beds ⋅ 3 Baths ⋅ ML81951259 MLS
Stunning remodel to studs makes for a chic home with indoor/outdoor living & entertaining in the heart of San Mateo Park, a highly sought-after hamlet walking distance of Burlingame Ave. Exposed original 1944 beam is the heart of the living room & matching wood mantle reclaimed from a Marin farm complemented with hand-painted Tabarka tiles wrapping the gas fireplace. Multiple French doors flood natural light. Fire up your gas Viking range & serve up memories in the spacious eat-in kitchen with large French doors opening to your private Provence-style clay-tile deck surrounded by landscaped grounds awaiting spring blooms. Smart Primary Bedroom with custom-built walk-in closet & barn door storage. Designer bathroom with radiant floor heating, dual sinks, large stall shower & huge soaking tub with designer fixtures & hand-painted tiles. Plank hardwood floors throughout, new HVAC, plumbing, tankless & electric. High-end finishings throughout with crown molding, baseboards, recessed lighting, ceiling speakers, exterior speakers, dual-pane windows, solid core doors & endless attention to detail. Huge corner lot with potential to expand your lifestyle or an ADU. More outdoor entertaining options with sod, turf & natural stone. Great neighborhood quick walk to shops, coffee & dining.

401 Westmoreland AVE, San Mateo

Listed by Mike Herkenrath, 408-499-4440 from Pavicich Realty
(If provided) CoList: from

Sold listing courtesy of Shaun Walter from CBR

339 Parrott DR, San Mateo
$3,555,000
4 Beds ⋅ 4 Baths ⋅ ML81951644 MLS
Stunning Baywood San Mateo home features a spacious open floor plan, with 4-bedrooms plus office, and 4-bathrooms perfect for modern living. This recently remodeled home boasts raised ceilings and a large open kitchen with Bosch and Thermador appliances. The flat yard features a spacious green lawn, and covered patio. A large 2 car garage includes an EV charger, an extra storage room, and owned solar system are additional highlights. Perfectly located, just a short walk to Downtown San Mateo, with top-rated parks, restaurants, and boutique shops. Commuting is easy, with a 5 minute drive to freeway access (101 and 92). Within walking distance to top-rated schools such as Baywood Elementary, Borel Middle, and Aragon High School. Don't miss your chance to call this exquisite property home!

339 Parrott DR, San Mateo

Listed by Phil Chen, 415-271-1920 from Christie's International Real Estate Sereno
(If provided) CoList: from

Sold listing courtesy of Evangelia Sogotis from KWPEN

1401 Cedarwood DR, San Mateo
$2,538,000
5 Beds ⋅ ML81951779 MLS
Compass Commercial is pleased to announce the exclusive listing of possibly the most luxurious duplex in all of The City of San Mateo. -- Constructed in 1975 and located on a massive 10,000 square foot corner lot directly across the street from Laurelwood Park; this luxury duplex is comprised of one (1) 3-Bedroom/2-Bathroom unit at 1,900 square feet of livable space, and one (1) 2-Bedroom/2-Bathoom unit at 1,480 square feet of livable space, along with a private 445 square foot two-car garage for each unit. Both units have been recently remodeled. The tenants pay ALL utilities directly, including water, trash removal, gas and electric. The sewer lateral line has passed its clearance test. Both units are on month-to-month tenancy, and both have private backyards. The property is located in the Laurelwood Park Neighborhood, and is a short-walk away from Laurelwood Shopping Center, two miles from Hillsdale Shopping Center, with easy access to Highway 92, and Interstate 280.

1401 Cedarwood DR, San Mateo

Listed by Nathan Gustavson, 415-786-9410 from Compass
(If provided) CoList: Cameron Foster from Compass

Sold listing courtesy of Cecilia Kwan from GAXX

10 Woodcreek CT, San Mateo
$2,875,000
4 Beds ⋅ 2 Baths ⋅ ML81950818 MLS
This Exquisite Eichler home is nestled onto the corner lot of a quiet Cul-de-sac & embraced by magnificent oak trees in the coveted San Mateo Highlands. Exceptional elegance & chic, contemporary charm meet at the intersection of modern & mid-century of this stunning home. A fenced-in front yard yields freedom from the outside world & unveils a private entrance into a special kind of serenity called: Home. A brightness bursts from every angle, setting the tone, & making an impactful first impression of this stunning space. Clean lines of new cabinetry draw the eye to the decadence of the chefs kitchen, fully equipped with high-end appliances, a large quartz island, & significant storage space. The main living area hosts an impressive openness between the living room, dining room & kitchen. Sliding patio doors lead out to the wood-like backyard where mature tree canopies provide seclusion & promising total tranquility & synchronicity with the beauty of the great outdoors. Four blissful bedrooms beckon for creating a space of ones own. An attached two-car garage with epoxy-coated floors that fits your needs. Each thoughtful element of this customized, turn-key home glitters with a fresh flair and offers sought-after simplistic elegance, timeless character and upscale taste.

10 Woodcreek CT, San Mateo

Listed by Kaitlyn Sebastian, 650-455-5051 from Coldwell Banker Realty
(If provided) CoList: Gianna Archini from Coldwell Banker Realty

Sold listing courtesy of Sternsmith Group from APR

847 Parrott DR, San Mateo
$3,000,000
4 Beds ⋅ 4 Baths ⋅ ML81951178 MLS
Welcome to Your Luxury Home in the Highly Desirable Baywood Knolls Neighborhood Near Hillsborough! This one-of-a-kind move-in ready residence underwent a complete transformation with a remodel and expansion from studs up with an expanded foundation and brand new second-floor addition in 1987, Every detail was meticulously chosen to create a harmonious blend of beauty, functionality, and adaptable living. As you enter, you'll be captivated by the amazing open and airy layout seamlessly connecting the living, dining, family, and kitchen areas. The ground floor showcases a roomy primary suite with a private bathroom and a generously sized bedroom. Upstairs, there's a luxurious primary bedroom and a versatile office/bedroom. Outside, the private space is an entertainer's dream, boasting a beautifully landscaped yard, pebblestone walkways, a glistening pool, and a cozy fire pit. Enjoy the many upgrades, a brand-new roof, tankless water heaters, an Atrium, multiple wood-burning fireplaces, stained glass windows with plantation shutters, hardwood floors, crown molding, a wet bar, and skylights. Fantastic location, just minutes to excellent schools, San Mateo Downtown, local cuisine, shopping, 92, 280, San Francisco, SFO, and Silicon Valley. Make your dream a reality and schedule a tour!

847 Parrott DR, San Mateo

Listed by Mita Kapadia, 650-454-6594 from RE/MAX Star Properties
(If provided) CoList: from

Sold listing courtesy of Bijan Amini from QUES

827 S Humboldt ST, San Mateo
$2,000,000
3 Beds ⋅ 2 Baths ⋅ ML81950800 MLS
A vibrant corner lot treasure in the heart of San Mateo's lively Sunnybrae neighborhood. This home is more than a dwelling; it's a portal to a life filled with location perks, ease, and endless possibilities. Step into this enchanting 3-bed, 2-bath abode and be greeted by a warm, dine-in kitchen, perfect for leisurely breakfasts or casual dining. The elegant formal dining room is an ideal backdrop for sophisticated dinner parties or memorable family feasts. Easy to make yourself right at home in this living room. You'll love the way the large window brings in the great outdoors right to your comfy couch. Oh, and there's a snug fireplace too, making everything feel extra warm and cozy. Comes with a versatile Accessory Dwelling Unit (ADU), offering a plethora of opportunities. Whether you envision it as a trendy home office, a profitable rental space, or a fashionable guest suite. Adjacent to the garage, the lower ground floor features a hidden spa and a flexible open space that can be creatively converted to suit a multitude of enjoyable purposes. The added benefit of RV parking makes it even more appealing, especially for those with a passion for travel. If you're looking for a place that's more than a home, but a launchpad for fun, and relaxation, you've hit the jackpot!

827 S Humboldt ST, San Mateo

Listed by Christopher Eckert, 650-627-3799 from KW Advisors
(If provided) CoList: from

Sold listing courtesy of Steven Lui from SLRV

3253 Los Prados ST, San Mateo
$2,205,000
3 Beds ⋅ 3 Baths ⋅ ML81950755 MLS
Discover a rare opportunity to own a remarkable waterfront property featuring 3 bedrooms, 3 full bathrooms, and an expansive lot. Imagine waking up to stunning morning sunrises and being mesmerized by the evening sunsets over the wide water. This property is not just a house; it's the canvas for creating lifelong memories. Launch your boat directly from your backyard and embark on endless aquatic adventures. Explore the serene waters and embrace the boating lifestyle. The spacious backyard offers limitless potential. Host BBQ gatherings, create a garden oasis, or let your imagination run wild. Additionally, a backyard building can serve as your private office, yoga studio, or meditation room. The large sunroom seamlessly connects the indoor and outdoor living spaces, making it perfect for hosting social events with panoramic water views. The upstairs master bedroom provides a tranquil escape with peaceful water views, offering a serene and comfortable space to unwind. Dont miss this unique opportunity to own a waterfront property that promises a lifestyle of adventure, relaxation, and endless possibilities. Make it yours today and begin your journey of waterfront living.

3253 Los Prados ST, San Mateo

Listed by Mary Bee, 650-343-9999 from Remax Capital
(If provided) CoList: from

Sold listing courtesy of Donald Kung from RECAP

511 Maple ST, San Mateo
$1,942,000
2 Beds ⋅ 3 Baths ⋅ ML81950652 MLS
The bright formal entry of this exceptional single-family home opens to an inviting living space with charming marble fireplace. Adjacent to the living room, the elegant formal dining room which leads to the delightful, eat-in kitchen and lovely private garden. Stairs to the upper-level lead to a wonderful family room with another fabulous outdoor terrace and two generous bedrooms, one en-suite, and another full bathroom. The epitome of sophisticated living, 511 Maple Street provides easy access to all that downtown San Mateo has to offer including fantastic dining options, beautiful Central Park, and versatile public transportation.

511 Maple ST, San Mateo

Listed by Greg Damelio, 650-245-8700 from Christie's International Real Estate Sereno
(If provided) CoList: from

Sold listing courtesy of Heather Damelio from SGP

board logoThe data relating to real estate for sale on this display comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than Real Estate Company are marked with the Internet Data Exchange and detailed information about them includes the names of the listing brokers and listing agents.
Based on information from MLSListings MLS as of . 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.


Copyright 2026 MLSListings Inc. All rights reserved

How much is your home worth?

Get instant property value now!