KAAJAL SHAHANI
Kaajalshahani Realtor
kaajalshahani@gmail.com
Phone: 510.304.6754
Phone:
43225 Mission Blvd., Fremont, CA 94539
Fax:

MLS# 41111513 – 37230 2nd St, Fremont, CA 94536

$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
Price: $2,199,888
Beds: 6
Baths: 3 full, 2 half
Living Area SqFt: 2,440
Status: Active
Property Type: Single Family Residence
Lot Size Acres: 0.17
Lot Size SqFt: 7,409
Year Built: 1915
Neighborhood: Niles
Days on Website: 42

Courtesy of Nadine Camara, REALTY EXPERTS 510-673-4299

Property Description

Motivated seller! Price reduced $100k! 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!

$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont
$2,199,888 - 6Br/5Ba -  for Sale in Niles, Fremont

Open House

Property Details and Features

  • Appliances & Equipment
  • Appliances: “Dishwasher”, “Double Oven”, “Gas Range”, “Plumbed For Ice Maker”, “Microwave”, “Free-Standing Range”, “Refrigerator”, “Gas Water Heater”
  • Bathrooms
  • 3 full bathrooms
  • 3 total bathrooms
  • Bedrooms
  • 6 bedrooms
  • Building
  • Construction Materials: “Stucco”, “Wood Siding”
  • Living Area: 2440
  • Year Built: 1915
  • Level – Street: “Other”
  • Cooling
  • Cooling: “Central Air”, “Other”
  • Cooling Included
  • Floors
  • Flooring: “Tile”, “Other”, “Engineered Wood”
  • Garage
  • 3 garage spaces
  • Garage Included
  • Heating
  • Heating: “Other”, “Central”
  • Heating Included
  • Laundry
  • Features: “Hookups Only”, “Other”
  • Location
  • Subdivision Name: Niles
  • Lot
  • Lot Features: “Level”, “Landscaped”
  • Lot Size Acres: 0.17
  • Lot Size Area: 7409
  • Lot Size Square Feet: 7409
  • Parcel Number: 50725016
  • Parking
  • Parking Features: “Detached”
  • Pool
  • Pool Features: “None”
  • Property
  • Property Condition: “Existing”
  • Property Sub Type: Single Family Residence
  • Roof
  • Roof: “Composition Shingles”, “Other”
  • Schools
  • High School District: Fremont (510) 657-2350
  • Elementary School District: Fremont (510) 657-2350
  • Utilities
  • Electric: “No Solar”
  • Water Source: “Public”
  • Windows
  • Window Features: “Skylight(s)”, “Window Coverings”
  • Listing
  • Sale/rent: For Sale
  • $902 per square foot

Property Map

$2,199,888 – 37230 2nd St, Fremont, CA 94536

Street View

Market Trends for 94536, Fremont, CA

Nearby Schools

Similar Properties Nearby

Print Options

Select the items on the page that you would like to print. This "Print Options" block will not be printed.

Main Photo Main Details Property Description Property Features
Additional Photos Addtl Photos Size Location Map Schools

MLS LogoBay East © 2025 . CCAR © 2025 . bridgeMLS © 2025 . Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at October 25, 2025 12:08PM.

Listing Information © 2025 Bay East, CCAR, bridgeMLS. All Rights Reserved.