Back to Search
37230 2nd St
For Sale $1,999,880 ($819.62 per Sq Ft)
$1,999,880 ($819.62 per Sq Ft)
- 6 Bedrooms
- 5 Bathrooms
- 2,440 Sq Ft
- 7,409 Sq Ft
Description
THREE HOMES! TRI-PLEX PROPERTY! Nestled in the heart of Fremont’s historical Niles District where the golden era of silent films began! Don't miss your opportunity to own a one-of-a-kind triplex property! THREE complete gut remodeled HOMES on one lot. Each home has its own address, PG&E meter, garage & laundry and shows like brand new! Whether you're looking for investment, multi-generational living, or rental income to offset your mortgage, this property offers flexibility, location & historical charm in equal measure! Each home has been beautifully renovated with the main home gorgeously showcasing Niles antique design! YOU MUST SEE to appreciate: photos do not capture the quality craftsmanship and stunning design! Located just steps away from Niles Elementary School and the bustling "Main Street" with weekly Farmer's Market, restaurants, antique shops & ongoing festivities. Enjoy breathtaking views as you stroll the Niles Community Park with tennis courts, playground, paved pathways, and breathtaking Fall colors - just a few minutes walk away! Act fast! THREE stunning homes priced for the cost of two with perfect location in downtown Niles District. Bring your extended family! This won’t last!
Amenities
Garage
Pool
Garden
Security System
Internet
Telephone
Heating
Fireplace
Balcony & Patio
TV / Cable
Laundry
Hardwood Floors
Spa
Air Conditioning
Solar Power
Floor Plan
Great Views
Natural Light
Quiet
Water View
Elevator
Guest Unit(s)
Furnished
220 Volt
Property Details
| List Price | $1,999,880 |
| Property Type | Single Family Homes |
| Usable Sqft | 2,440 |
| Number of Stories | 0 stories |
| Parking Spots | 3 spots |
| Year Built | 1915 |
| Last Sold | Unknown |
| Sold Price | Unknown |
| APN # | 50725016 |
| MLS # | 41111513 |
| Property ID | 322173457 |
| Lot Sqft | 7,409 |
| Zoning | Unknown |
| Days on Market | 115 |
| Original List Price | $2,299,888 |
| Applicances | Gas Water Heater% |
| Date Updated | January 06, 2026 |
| Date Created | September 13, 2025 |
Listing Provided By
Nadine Camara an agent of . Lic #00924223
© 2026 CRMLS. All rights reserved. Some listings on this website are from CRMLS as of January 06, 2026 The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Contact Agent
Schedule Appointment
Showing Agent
Loading agent...
- 30 mins
- America/Phoenix
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Robert Crawford
REAL ESTATE AGENT