37230 2nd St St, Fremont, CA 94536 (MLS # 41111513)
|
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 HOMES on one lot. Each home has its own address, PG&E meter, garage & laundry. 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!
DAYS ON MARKET | 2 | LAST UPDATED | 9/13/2025 |
---|---|---|---|
TRACT | NILES | YEAR BUILT | 1915 |
GARAGE SPACES | 3.0 | COUNTY | Alameda |
STATUS | Active | PROPERTY TYPE(S) | Single Family |
ADDITIONAL DETAILS | |
AIR | Central Air |
---|---|
AIR CONDITIONING | Yes |
APPLIANCES | Gas Water Heater |
CONSTRUCTION | Brick Veneer, Stucco, Wood Siding |
GARAGE | Attached Garage, Yes |
HEAT | See Remarks |
INTERIOR | Eat-in Kitchen |
LOT | 7410 sq ft |
LOT DESCRIPTION | Front Yard, Sprinklers In Front |
PARKING | Attached, Garage |
POOL DESCRIPTION | None |
SEWER | Public Sewer |
STORIES | 1 |
STYLE | Bungalow |
SUBDIVISION | NILES |
TOTAL MONTHLY PAYMENT
SATELLITE VIEW |
/ | |
The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing. All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional.
Based on information from California Regional Multiple Listing Service, Inc. as of 9/14/25 12:09 PM PDT and /or other sources. 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
This IDX solution is (c) Diverse Solutions 2025.