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

MLS# 41131408 – 37955 2nd St, Fremont, CA 94536

$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
Open House
Sat June 20th  12:00pm — 3:00pm
Price: $1,898,000
Beds: 3
Baths: 2
Living Area SqFt: 1,529
Status: Active
Property Type: Single Family Residence
Lot Size Acres: 0.17
Lot Size SqFt: 7,500
Year Built: 1947
Neighborhood: Niles
Days on Website: 64

Courtesy of Brian Rowland, Alliance Bay Realty 510-688-0343

Property Description

The quintessential Niles home! A polished gem that has been updated and expanded from its historic footprint, with a gorgeous garden to match. A total remodel resulted in an added en suite and a cook’s dream kitchen with granite counters, custom baking center, pull-outs, and prep areas for large parties; remodeled bathrooms with a stunning skylit shower; and a huge added bedroom which opens to a generous porch overlooking a garden walk through perennial beds surrounded by apricot, peach, pluot, citrus and birch trees. Fruit ripening on the vines and the fragrance of jasmine, roses and sweet olive graces your meander. Homes with this blend of single-level character and sophistication are rarely available anywhere but especially in Niles, where folks love the community and climate so much they tend to stay. Fully insulated with energy efficient appliances, thermal paned windows, new electric panel, and tankless water heater. Lot has designed space with separate access for ADU, tiny house, mobile home or 5th wheel. Walk a few short blocks to the Saturday Farmer’s market in historic downtown or enjoy the many shops, restaurants, museums and more. A few short blocks will also take you to the Alameda Creek Trail for walking, running, hiking and riding from the Canyon to the Bay where you can enjoy the many parks and lakes along the way. A rare find with seamless integration of modern living and natural surroundings.

$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont
$1,898,000 - 3Br/2Ba -  for Sale in Niles, Fremont

Open House

Property Details and Features

  • Appliances & Equipment
  • Appliances: “Dishwasher”, “Gas Range”, “Microwave”, “Refrigerator”, “Dryer”, “Washer”, “Tankless Water Heater”
  • Bathrooms
  • 2 full bathrooms
  • 2 total bathrooms
  • Bedrooms
  • 3 bedrooms
  • Building
  • Construction Materials: “Wood Siding”
  • Living Area: 1529
  • Year Built: 1947
  • Level – Street: “3 Bedrooms”, “2 Baths”, “Primary Bedrm Suite – 1”, “Primary Bedrm Retreat”, “Main Entry”
  • Cooling
  • Cooling: “Wall/Window Unit(s)”
  • Cooling Included
  • Fireplaces
  • Fireplace Included
  • Floors
  • Flooring: “Hardwood”
  • Garage
  • 1 garage space
  • Garage Included
  • Heating
  • Heating: “Forced Air”
  • Heating Included
  • Laundry
  • Features: “Dryer”, “In Garage”, “Washer”
  • Location
  • Subdivision Name: Niles
  • Lot
  • Lot Features: “Cul-De-Sac”, “Level”, “Premium Lot”, “Back Yard”, “Front Yard”, “Landscaped”, “See Remarks”
  • Lot Size Acres: 0.17
  • Lot Size Area: 7500
  • Lot Size Square Feet: 7500
  • Parcel Number: 5073154
  • Parking
  • Parking Features: “Detached”
  • Pool
  • Pool Features: “None”
  • Property
  • Property Condition: “Existing”
  • Property Sub Type: Single Family Residence
  • Roof
  • Roof: “Composition Shingles”
  • Utilities
  • Electric: “No Solar”
  • Water Source: “Public”
  • Listing
  • Sale/rent: For Sale
  • $1,241 per square foot

Property Map

$1,898,000 – 37955 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 © 2026 . CCAR © 2026 . bridgeMLS © 2026 . 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 June 20, 2026 5:11PM.

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