Finegroupre.com Search Results

3 listings

Refine Search

Sort by

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

Listed by Disen Cai RE Group, 650-622-2156 from KW Advisors
(If provided) CoList: from

Prime development opportunity in a highly desirable El Camino Real location! This property features a front home with 2 bedrooms and 2 full bathrooms, a spacious dining area, and a breakfast nook that opens to the kitchen. Recent updates include new carpeting and partial interior paint. The rear structure offers excellent income potential and is divided into two separate living spaces: one unit features 1 bedroom, 1 full bathroom, and a full kitchen, while the other is a studio with its own bathroom. The flexible layout provides the opportunity to generate additional rental income or accommodate extended family. Situated on an extra-large R-4 zoned lot, this property offers multiple development possibilities (buyer to verify with the appropriate authorities). Conveniently located just minutes from Downtown Burlingame, Downtown San Mateo, Caltrain, shopping, dining, and Highway 101, this is an exceptional opportunity for investors, developers, or owner-users seeking future potential in a prime Peninsula location.

3 Beds ⋅ 4 Baths ⋅ ML82056723 MLS

Prime development opportunity in a highly desirable El Camino Real location! This property features a front home with 2 bedrooms and 2 full bathrooms, a spacious dining area, and a breakfast nook that opens to the kitchen. Recent updates include new carpeting and partial interior paint. The rear structure offers excellent income potential and is divided into two separate living spaces: one unit features 1 bedroom, 1 full bathroom, and a full kitchen, while the other is a studio with its own bathroom. The flexible layout provides the opportunity to generate additional rental income or accommodate extended family. Situated on an extra-large R-4 zoned lot, this property offers multiple development possibilities (buyer to verify with the appropriate authorities). Conveniently located just minutes from Downtown Burlingame, Downtown San Mateo, Caltrain, shopping, dining, and Highway 101, this is an exceptional opportunity for investors, developers, or owner-users seeking future potential in a prime Peninsula location.

664 N El Camino Real, San Mateo

Listed by Perry Chiu, 415-364-8288 from Pathmark Realty Corporation
(If provided) CoList: from

Wow, $300,000 price reduction and substantial tax savings if approved for Mills Act! Own a piece of History in this Classic 1907 Queen Anne Victorian with large open living room, kitchen/dining, separate front office, sun room and secluded yard on oversized 9,000 sqft lot. Previously owned by A.P. Giannini, founder of Bank of Italy/BofA. Traditional bench seat entry welcomes guests to this grand estate waiting for your remodel and upgrades. Kitchen features built-in oven, dishwasher, gas range with custom hood and large walk-in pantry. Separate laundry room, hardwood floors, rear patio. Detached two car garage with original carriage house would be ideal for an ADU. Newer shingled roof and new sewer lateral. Easy access to downtown shops, parks & transportation. Property may qualify for the Mills Act.

4 Beds ⋅ 3 Baths ⋅ ML82034015 MLS

Wow, $300,000 price reduction and substantial tax savings if approved for Mills Act! Own a piece of History in this Classic 1907 Queen Anne Victorian with large open living room, kitchen/dining, separate front office, sun room and secluded yard on oversized 9,000 sqft lot. Previously owned by A.P. Giannini, founder of Bank of Italy/BofA. Traditional bench seat entry welcomes guests to this grand estate waiting for your remodel and upgrades. Kitchen features built-in oven, dishwasher, gas range with custom hood and large walk-in pantry. Separate laundry room, hardwood floors, rear patio. Detached two car garage with original carriage house would be ideal for an ADU. Newer shingled roof and new sewer lateral. Easy access to downtown shops, parks & transportation. Property may qualify for the Mills Act.

137 Elm ST, San Mateo

Listed by Michael Verdone, 650-208-0669 from Economic Concepts
(If provided) CoList: from

The 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 Fine Group Real Estate 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