Rivalryteam.com Search Results

$1,199,000

Welcome to 122 N Claremont St, a well-maintained San Mateo duplex offering an excellent opportunity for investors, multi-generational living, or an owner-occupant looking to offset housing costs with rental income. The property features two well-proportioned units, three carports, and additional side parking. The front unit offers approximately 1,515 sq. ft. of living space with 3 bedrooms and 2 bathrooms, along with a dedicated laundry room. The generous floor plan provides plenty of room for comfortable everyday living, entertaining, and working from home. The rear unit offers approximately 792 sq. ft., featuring 2 bedrooms and 1 bathroom with a convenient laundry closet. Its separate layout provides flexibility for rental use, extended family, guests, or additional income potential. Both units have been recently refreshed with new interior paint, new flooring, updated fixtures, and other improvements, creating a clean and move-in-ready presentation. The property also offers three carports plus an additional side parking, a valuable amenity in San Mateo. Ideally situated near local shopping, dining, parks, schools, transportation, and major Peninsula commute routes, 122 N Claremont St combines functional living spaces with the versatility. Don't miss this opportunity!

5 Beds ⋅ 3 Baths ⋅ ML82060982 MLS

Welcome to 122 N Claremont St, a well-maintained San Mateo duplex offering an excellent opportunity for investors, multi-generational living, or an owner-occupant looking to offset housing costs with rental income. The property features two well-proportioned units, three carports, and additional side parking. The front unit offers approximately 1,515 sq. ft. of living space with 3 bedrooms and 2 bathrooms, along with a dedicated laundry room. The generous floor plan provides plenty of room for comfortable everyday living, entertaining, and working from home. The rear unit offers approximately 792 sq. ft., featuring 2 bedrooms and 1 bathroom with a convenient laundry closet. Its separate layout provides flexibility for rental use, extended family, guests, or additional income potential. Both units have been recently refreshed with new interior paint, new flooring, updated fixtures, and other improvements, creating a clean and move-in-ready presentation. The property also offers three carports plus an additional side parking, a valuable amenity in San Mateo. Ideally situated near local shopping, dining, parks, schools, transportation, and major Peninsula commute routes, 122 N Claremont St combines functional living spaces with the versatility. Don't miss this opportunity!

122 N Claremont ST, San Mateo

Listing courtesy of Disen Cai RE Group, 650-622-2156 from KW Advisors
(If provided) CoList: from

$2,750,000

A grand Laurelwood residence with impressive scale and presence, this 5-bedroom, 4-bath home offers approx. 2,610 sq.ft. on a 13,000+ sq.ft. lot with a pool and generous outdoor space. Soaring ceilings and a sweeping circular staircase introduce spacious formal and informal living areas. The updated kitchen features a Bertazzoni five-burner range, custom cabinetry, pantry and wine refrigerator, opening with the breakfast area and family room directly to the backyard. An expansive patio and covered pavilion create inviting spaces to dine, gather and relax poolside. The main level includes a flexible fifth bedroom and full bath, ideal for guests or an office. Upstairs, the primary suite with en-suite bath is joined by three additional bedrooms and a spacious dual-vanity bath. Modern upgrades include Tesla solar with Powerwall, EV charging, central A/C, tankless water heater, updated pool equipment, and a recently completed sewer lateral and cleanout. An attached 3-car garage plus pad parking provides ample parking and storage. Convenient to shopping, parks, trails and Highways 92, 101 and 280.

5 Beds ⋅ 4 Baths ⋅ ML82060807 MLS

A grand Laurelwood residence with impressive scale and presence, this 5-bedroom, 4-bath home offers approx. 2,610 sq.ft. on a 13,000+ sq.ft. lot with a pool and generous outdoor space. Soaring ceilings and a sweeping circular staircase introduce spacious formal and informal living areas. The updated kitchen features a Bertazzoni five-burner range, custom cabinetry, pantry and wine refrigerator, opening with the breakfast area and family room directly to the backyard. An expansive patio and covered pavilion create inviting spaces to dine, gather and relax poolside. The main level includes a flexible fifth bedroom and full bath, ideal for guests or an office. Upstairs, the primary suite with en-suite bath is joined by three additional bedrooms and a spacious dual-vanity bath. Modern upgrades include Tesla solar with Powerwall, EV charging, central A/C, tankless water heater, updated pool equipment, and a recently completed sewer lateral and cleanout. An attached 3-car garage plus pad parking provides ample parking and storage. Convenient to shopping, parks, trails and Highways 92, 101 and 280.

1478 Cherrywood DR, San Mateo

Listing courtesy of Marcus Lee, 415-999-2022 from Compass
(If provided) CoList: from

$4,198,000

Along the tree-lined streets of coveted San Mateo Park, this beautifully remodeled 1925 Tudor-style home blends timeless character with sophisticated designer touches throughout. From the welcoming foyer, stunning hardwood floors lead into the grand living room, where natural light pours through a large-paned window, illuminating the soaring barrel ceiling and elegant Venetian plaster fireplace. The formal dining room showcases original architectural details, while the fully custom chefs kitchen features designer finishes and custom appliances. Beyond the living room is a separate (is cozy better?) family room, a few steps lead to the spacious primary suite, complete with a dedicated office and luxurious ensuite bath. Two additional generously sized bedrooms, a smaller guest bedroom and a designer full bathroom are located upstairs. A short staircase leads to a versatile bonus room ideal for an au pair suite, home gym, or office. A detached two-car garage provides additional storage, while the new gray paver driveway and yard create an inviting setting for outdoor entertaining. San Mateo Park offers a wonderful sense of community, picturesque tree-lined avenues, and an exceptional location proximate to downtown Burlingame , restaurants, and amenities.

5 Beds ⋅ 3 Baths ⋅ ML82060112 MLS

Along the tree-lined streets of coveted San Mateo Park, this beautifully remodeled 1925 Tudor-style home blends timeless character with sophisticated designer touches throughout. From the welcoming foyer, stunning hardwood floors lead into the grand living room, where natural light pours through a large-paned window, illuminating the soaring barrel ceiling and elegant Venetian plaster fireplace. The formal dining room showcases original architectural details, while the fully custom chefs kitchen features designer finishes and custom appliances. Beyond the living room is a separate (is cozy better?) family room, a few steps lead to the spacious primary suite, complete with a dedicated office and luxurious ensuite bath. Two additional generously sized bedrooms, a smaller guest bedroom and a designer full bathroom are located upstairs. A short staircase leads to a versatile bonus room ideal for an au pair suite, home gym, or office. A detached two-car garage provides additional storage, while the new gray paver driveway and yard create an inviting setting for outdoor entertaining. San Mateo Park offers a wonderful sense of community, picturesque tree-lined avenues, and an exceptional location proximate to downtown Burlingame , restaurants, and amenities.

769 Crescent AVE, San Mateo

Listing courtesy of David Cauchi, 415-203-5726 from Compass
(If provided) CoList: Antoinette Galindo from Compass

$2,995,000

Newly Built 2021 Home w/ ADU in Prime San Mateo! This fully permitted property offers 4,085 sqft total living space 2,919 sqft in the main home plus a 1,166 sqft ADU. The main home features 10-foot ceilings, custom 8-foot doors, recessed lighting, and 10-foot built-in bookcase. The living room offers a cozy fireplace & bay window that bring in natural light. The chefs kitchen is a showstopper, complete with a skylight, a 9-foot island with built-in sink, wine cooler, and premium Miele & Thermador appliances. The primary suite includes a custom walk-in closet and connects to a junior suite, perfect for flexible living. Bathrooms offer radiant heated floors and spa-like finishes. Additional highlights include dual-zone HVAC, fire sprinklers, and a solid concrete foundation w/ reinforced beams. The backyard is a low-maintenance retreat with mature fruit trees. The ADU offers stylish & luxury living with Miele-equipped kitchen, a sleek waterfall island w/ built-in microwave, a custom wine cellar with glass doors and LED lighting, soaring 11-foot ceilings, a private master suite, a half bath, & approximately 800 sqft of expansive storage. Conveniently located near top-rated Aragon High School, parks, shopping, dining, and with easy access to SM Downtown, Hwy 101, 92, Caltrain & SFO.

5 Beds ⋅ 7 Baths ⋅ ML82055548 MLS

Newly Built 2021 Home w/ ADU in Prime San Mateo! This fully permitted property offers 4,085 sqft total living space 2,919 sqft in the main home plus a 1,166 sqft ADU. The main home features 10-foot ceilings, custom 8-foot doors, recessed lighting, and 10-foot built-in bookcase. The living room offers a cozy fireplace & bay window that bring in natural light. The chefs kitchen is a showstopper, complete with a skylight, a 9-foot island with built-in sink, wine cooler, and premium Miele & Thermador appliances. The primary suite includes a custom walk-in closet and connects to a junior suite, perfect for flexible living. Bathrooms offer radiant heated floors and spa-like finishes. Additional highlights include dual-zone HVAC, fire sprinklers, and a solid concrete foundation w/ reinforced beams. The backyard is a low-maintenance retreat with mature fruit trees. The ADU offers stylish & luxury living with Miele-equipped kitchen, a sleek waterfall island w/ built-in microwave, a custom wine cellar with glass doors and LED lighting, soaring 11-foot ceilings, a private master suite, a half bath, & approximately 800 sqft of expansive storage. Conveniently located near top-rated Aragon High School, parks, shopping, dining, and with easy access to SM Downtown, Hwy 101, 92, Caltrain & SFO.

1305 Maple ST, San Mateo

Listing courtesy of Anders Fung, 415-260-5841 from Sequoia Commercial Group
(If provided) CoList: from

$2,150,000

Discover a rare opportunity in San Mateo's sought-after Los Prados neighborhood. This beautifully maintained duplex offers approximately 2,638 square feet of living space on an expansive 8,482 square-foot lot, combining versatility, privacy, and exceptional indoor-outdoor living. Ideal for an owner-occupant, multigenerational household, or investor, the property offers comfort and long-term potential. The two residences include a spacious 3-bedroom, 2-bath main home and a separate 2-bedroom, 1-bath unit. Both have been thoughtfully updated with well-appointed kitchens, hardwood and tile flooring, skylights, generous storage, heating and cooling, and private laundry. Separate utility meters add flexibility. Private, fully fenced rear yards feature mature landscaping, citrus trees, lush lawn, drought-tolerant plantings, patios, and inviting walkways. A covered pergola creates an ideal setting for outdoor dining and entertaining, while a garden shed/home office offers flexible space for work, hobbies, or storage. Conveniently located near neighborhood shopping, Hillsdale, the Bay Trail, and major Peninsula commute routes, the property provides easy access to Highways 101 and 92, San Carlos Airport, and SFO. You do not want to miss this beauty!

5 Beds ⋅ 3 Baths ⋅ ML82057701 MLS

Discover a rare opportunity in San Mateo's sought-after Los Prados neighborhood. This beautifully maintained duplex offers approximately 2,638 square feet of living space on an expansive 8,482 square-foot lot, combining versatility, privacy, and exceptional indoor-outdoor living. Ideal for an owner-occupant, multigenerational household, or investor, the property offers comfort and long-term potential. The two residences include a spacious 3-bedroom, 2-bath main home and a separate 2-bedroom, 1-bath unit. Both have been thoughtfully updated with well-appointed kitchens, hardwood and tile flooring, skylights, generous storage, heating and cooling, and private laundry. Separate utility meters add flexibility. Private, fully fenced rear yards feature mature landscaping, citrus trees, lush lawn, drought-tolerant plantings, patios, and inviting walkways. A covered pergola creates an ideal setting for outdoor dining and entertaining, while a garden shed/home office offers flexible space for work, hobbies, or storage. Conveniently located near neighborhood shopping, Hillsdale, the Bay Trail, and major Peninsula commute routes, the property provides easy access to Highways 101 and 92, San Carlos Airport, and SFO. You do not want to miss this beauty!

3342-3344 Los Prados ST, San Mateo

Listing courtesy of Disen Cai RE Group, 650-622-2156 from KW Advisors
(If provided) CoList: from

$5,295,000

Brand New Luxury Residence in the highly sought-after Bel Aire Heights community of San Mateo. This exceptional home tryly has it all, nearly 4000 sq ft of thoughtfully designed living space featuring 5 bedrooms and 4.5 bathrooms, including two luxurious primary suites, one on each level, ideal for multi generational living or ultimate flexibility. The open-floor concept floor plan is light filled and expansive, seamlessly blending modern design with everyday functionality. A Chef's Dream kitchen showcases top of the line Thermador stainless steel appliances, including a built in espresso machine and wine refrigerator, perfect for both daily living and entertaining. Elegant finishes throughout, highlighted by a gas fireplace and walls of windows that capture stunning mountain and water views from most rooms. Set on approximately 9000 sq ft lot, the home also offers a spacious 3 car garage with multiple EV charging outlets. Located in one of San Mateo's premier new developments, Bel Aire Heights offers a rare opportunity to own a brand new, luxury home in a truly special setting.

5 Beds ⋅ 5 Baths ⋅ ML82040647 MLS

Brand New Luxury Residence in the highly sought-after Bel Aire Heights community of San Mateo. This exceptional home tryly has it all, nearly 4000 sq ft of thoughtfully designed living space featuring 5 bedrooms and 4.5 bathrooms, including two luxurious primary suites, one on each level, ideal for multi generational living or ultimate flexibility. The open-floor concept floor plan is light filled and expansive, seamlessly blending modern design with everyday functionality. A Chef's Dream kitchen showcases top of the line Thermador stainless steel appliances, including a built in espresso machine and wine refrigerator, perfect for both daily living and entertaining. Elegant finishes throughout, highlighted by a gas fireplace and walls of windows that capture stunning mountain and water views from most rooms. Set on approximately 9000 sq ft lot, the home also offers a spacious 3 car garage with multiple EV charging outlets. Located in one of San Mateo's premier new developments, Bel Aire Heights offers a rare opportunity to own a brand new, luxury home in a truly special setting.

18 Bel Aire LN, San Mateo

Listing courtesy of The Laugesen Team, 650-465-5742 from KW Advisors
(If provided) CoList: from

$5,695,000

Offered in one of San Mateo"s most exclusive enclaves a rare jewel in the prestigious, Bel Aire Heights, a 19-home luxury community of San Mateo Hills. Perched high above the city with unobstructed views of the Pulgas Water Temple and the majestic western hills, this grand, sexy, and luxurious residence is a true showstopper. With over 3,500 square feet of meticulously curated living space, this 5-bedroom, 5.5-bath estate blends timeless elegance with modern sophistication. Every inch of this home is thoughtfully designed with high-end, designer finishes from rich hardwood floors and custom millwork to a chefs kitchen outfitted with top-tier appliances and sleek stone surfaces. Soaring ceilings and expansive picture windows flood the home with natural light and frame the stunning views, creating a seamless indoor-outdoor experience. Retreat to your private sanctuary, where peace, privacy, and beauty surround you. Whether entertaining in style or savoring quiet moments, 118 Rosewood Lane is a very special place to call home.

5 Beds ⋅ 6 Baths ⋅ ML82015578 MLS ⋅ Bel Aire Heights BLDG.

Offered in one of San Mateo"s most exclusive enclaves a rare jewel in the prestigious, Bel Aire Heights, a 19-home luxury community of San Mateo Hills. Perched high above the city with unobstructed views of the Pulgas Water Temple and the majestic western hills, this grand, sexy, and luxurious residence is a true showstopper. With over 3,500 square feet of meticulously curated living space, this 5-bedroom, 5.5-bath estate blends timeless elegance with modern sophistication. Every inch of this home is thoughtfully designed with high-end, designer finishes from rich hardwood floors and custom millwork to a chefs kitchen outfitted with top-tier appliances and sleek stone surfaces. Soaring ceilings and expansive picture windows flood the home with natural light and frame the stunning views, creating a seamless indoor-outdoor experience. Retreat to your private sanctuary, where peace, privacy, and beauty surround you. Whether entertaining in style or savoring quiet moments, 118 Rosewood Lane is a very special place to call home.

118 Rosewood Lane, San Mateo

Listing courtesy of The Laugesen Team, 650-465-5742 from KW Advisors
(If provided) CoList: from

Jim Matzen

Hauslley Silva