Home | San Mateo County | San Mateo | 94401 | 333 N Claremont St
MLS: SF423741180 | Status: Sold | Price: $1,225,000
Beds/Baths: 8 / 4
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 8 | 4 | 2,666 | 9,900 | 1907 |
Welcome to this charming property with a 2nd living unit downstairs located in a highly desirable location in the Bay Area Peninsula! This property has a lot of potential as an investment property for the right buyer who is looking for an opportunity to add value and build equity to this property. The living spaces are spacious and offer plenty of room for comfortable living. The kitchens and bathrooms are outdated and in need of some updates, but with a little bit of work and vision, they could be transformed into beautiful and functional spaces. The property offers a lot of potential for rental income, with each unit offering plenty of space for tenants. The large lot size (almost 1/4 acre) also provides the opportunity to add additional units, potentially increasing rental income even further. The location and potential make it an excellent investment opportunity. Located in a highly desirable area, this property is just minutes away from schools, shopping, dining, and entertainment options. In addition, the property is only a 2 minute drive or 10 minute walk from CalTrain, and a 10 minute drive from SFO. If you're looking for an investment property that has potential for rental income and a great location, this property is worth considering.
| Field | Value |
|---|---|
| MLS # | SF423741180 |
| MLS Source | San Francisco Association of Realtors® MLS |
| Feature | Details |
|---|---|
| Bathrooms | Other |
| Appliances | Other |
| Dining Room | Dining Area in Family Room, Dining Area in Living Room, Other |
| Family Room | Other |
| Laundry | Hookup - Gas Dryer, In Basement, Other |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Pool | Pool - No |
| Style | Craftsman, Custom |
| Feature | Details |
|---|---|
| Garage/Parking | Detached, Facing Front, Guest / Visitor Parking, Other, Parking - Independent, RV Access, RV Possible, Side By Side, Storage - Boat, Garage: 0 Car(s) |
| Sewer | Public Sewer |
| Water | Other, Public |
Hector Garcia
Blvd. Real Estate
License #: 02126914
Phone: (209) 391-1994
| # Buildings | # Leased Units | # Total Units |
|---|---|---|
| 0 | – | – |
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| San Mateo High School | public | 9-12 | 0.21 mi | 9 |
| San Mateo Adult | public | UG | 0.30 mi | N/A |
| North Shoreview Montessori Elementary School | public | K-8 | 0.68 mi | 9 |
| Washington Elementary School | public | K-5 | 0.79 mi | 6 |
| San Mateo Park Elementary School | public | K-5 | 0.80 mi | 2 |
| South Hillsborough School | public | K-5 | 0.93 mi | 8 |
| Burlingame High School | public | 9-12 | 1.14 mi | 10 |
| Sunnybrae Elementary School | public | K-5 | 1.20 mi | 1 |
| Baywood Elementary School | public | K-5 | 1.51 mi | 6 |
| LEAD Elementary | public | K-5 | 1.56 mi | 2 |
| McKinley Elementary School | public | K-5 | 1.57 mi | 7 |
| Aragon High School | public | 9-12 | 1.63 mi | 10 |
| Borel Middle School | public | 6-8 | 1.68 mi | 8 |
| North Hillsborough School | public | K-5 | 1.90 mi | 9 |
| Bayside Academy | public | K-8 | 1.94 mi | 6 |
| Crocker Middle School | public | 6-8 | 1.95 mi | 8 |
| Parkside Montessori | public | PK,KG,1,2,3,4,5,6,7,8 | 1.97 mi | 9 |
| College Park Elementary School | public | K-5 | 2.20 mi | 8 |
| Roosevelt Elementary School | public | K-5 | 2.22 mi | 5 |
| BSD Preschool | public | UG | 2.26 mi | N/A |
©2026 San Francisco Association of Realtors® MLS. All rights reserved. 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. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from San Francisco Association of Realtors® MLS.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of September 30, 2023. For the most current information, please contact Hector Garcia, (209) 391-1994.