CA > San Mateo
San Mateo, CA 94403,254 41st AVE
San Mateo, CA 94403,254 41st AVE,Video Tour
San Mateo, CA 94403,254 41st AVE
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
Mon
28
Jul
Tue
29
Jul
Wed
30
Jul
Sharad Gupta

Sharad Gupta

+1(408) 401-1003
Listed by Nicholas Delis • Compass
$2,998,000
Est. payment /mo
4 Beds
4 Baths
3,580 SqFt
Save Virtual Tour

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Home

Listing Status Active

Purchase Type For Sale

Square Footage 3,580 sqft

Price per Sqft $837

MLS Listing ID ML82015959

Bedrooms 4

Full Baths 4

Year Built 1957

Lot Size 6,135 Sqft

Property Sub-Type Single Family Home

Property Description

Commanding arguably the most extraordinary unobstructed bay views in all of San Mateo, this magnificent 4BR/4BA residence has been impeccably renovated to deliver a 3,580± SF immersive living experience where floor-to-ceiling vistas meet architectural sophistication. Plank and beam ceilings, oak floors, and refined moldings complement double-pane windows, skylights, and recessed lighting, illuminating integrated living spaces that flow onto a sprawling deck. Blending the warmth of natural wood with the elegance of stone, the chefs kitchen features granite countertops, custom cabinetry, premium appliances, a wine fridge, and a striking breakfast bar. Offering peaceful separation from the homes gathering areas, the main level also hosts a serene primary suite, a second bedroom, and a hall bath. Downstairs, a bedroom with a dedicated office provides the flexibility to create a luxurious secondary suite. A fourth bedroom, bonus room, and hall bath complete this floor. With its own full bath, washer/dryer, and seamless access to the newly completed backyard oasis, the lower level allows exceptional versatility, ideal for guest quarters, a family room, or a playroom. Additional highlights include solar panels, AC, and expansive storage. Unmatched, unrivaled, and unforgettable!

Location

State CA

County San Mateo

Area Westwood Knolls Etc.

Zoning R10006

Rooms

Family Room Separate Family Room

Other Rooms Office Area, Recreation Room, Wine Cellar / Storage

Dining Room Dining Area

Kitchen Countertop - Granite, Dishwasher, Cooktop - Gas, Garbage Disposal, Microwave, Pantry, Exhaust Fan, Oven Range - Electric, Wine Refrigerator, Refrigerator

Interior

Heating Forced Air

Cooling Central AC

Laundry Washer / Dryer

Exterior

Exterior Feature Back Yard, Fenced, BBQ Area, Deck

Parking Features Attached Garage

Garage Spaces 2.0

Utilities Available Public Utilities

View Bay, Bridge , City Lights, Hills, Mountains

Roof Type Composition

Building

Foundation Concrete Perimeter

Sewer Sewer - Public

Water Public

Others

Tax ID 042-222-300

Horse Property No

Special Listing Condition Not Applicable

Virtual Tour https://my.matterport.com/show/?m=oT1De2826Co

Read Less Info
MLSListings Inc. (MLSListings)
© 2025 MLSListings Inc. All rights reserved.

GET MORE INFORMATION

agent
Sharad Gupta

Broker | License ID: 02213637

+1(408) 401-1003

5201 Great America Pkwy, Santa Clara, CA, 95054, USA

Name
Phone*
Message
I agree by electronic signature to the Electronic Disclosure Consent; to receive recurring marketing communication from or on behalf of Sharad Gupta, including auto-dialed calls, texts, and artificial/prerecorded voice messages (consent not required to make a purchase; data rates may apply; reply “STOP” to opt-out of texts or ‘HELP” for help); and to the Terms of Service and Privacy Policy of this website. I understand that I can call to obtain direct assistance.
QUICK SEARCH
There are 23 quick searches