37807 Freesia CourtFREMONT, California, 94536

$2,198,000 $/Month

MLS #52205172 Active

6 Beds4 Baths3,400 SQ. Feet 0.16 Acres2000 Year Built

**FEATURED home - Mercury News, EastBay Times, Silicon Valley!!**(more than $500k in upgrades) in Fremont's Coveted Riverwalk Community right next to Quarry lakes and walking trails, close to AWARD winning PARKMONT elementary! **Rarely available, LARGEST** floorplan with 3400 sft, (ONE BEDROOM AND FULL BATH at street level) HIGH-END designer touches all through - resort like backyard - pond with cascading waterfall, water fountain, **FULL size outdoor kitchen**, HUGE palm trees in front and back yards - entertainers dream!! Generous use of MARBLE, TRAVERTINE, PORCELANOSA tile, CUSTOM kitchen with large **WATERFALL** island w/ oversized cabinetry, BOSCH stainless steel appliances, water softener, A/C, coffered ceiling in Master, SPA like MASTER BATH!! **HIGH ceilings in entry , living, and dining with dramatic windows, plantation shutters and so much more!! **Media room / sixth bedroom can be THIRD CAR Garage! Close to the NEW FACEBOOK campus, Google shuttle stops, 880, 84 and schools!!

Open House Information

  • DateAugust 24th, 2019
  • Begin Time1:30pm
  • End Time4:30pm
  • DescriptionDon't miss this luxury home!
  • DateAugust 25th, 2019
  • Begin Time1:30pm
  • End Time4:30pm
  • DescriptionDon't miss this luxury home!

Essential Information

  • MLS® #52205172
  • Price$2,198,000
  • Bedrooms6
  • Bathrooms4.50
  • Full Baths4
  • Half Baths1
  • Square Footage3,400
  • Acres0.16
  • Year Built2000
  • TypeResidential
  • Sub-TypeDetached
  • StyleSpanish
  • StatusActive


  • HeatingForced Air 1 Zone
  • FireplaceYes
  • # of Fireplaces2
  • FireplacesFamily Room, Living Room

Additional Information

  • Date ListedAugust 10th, 2019
  • ZoningR1
  • HOA Fees85/

Community Information

  • Address37807 Freesia Court
  • AreaAll Other Counties/States
  • CityFremont Real Estate
  • CountyAlameda
  • StateCalifornia
  • Zip Code


  • RoofTile
  • FoundationSlab

Listing Details

  • Listing OfficeMlslistingsx


  • Parking Spaces2
  • ParkingAttached Garage, Off Street Parking
  • # of Garages2
  • GaragesAttached Garage, Off Street Parking
  • ViewHills

School Information

  • DistrictFremont (510) 657-2350

Property Location

Get directions to this property:

Properties for Sale Similar to 37807 Freesia Court, FREMONT, California

Photo of Listing #40877218 Remove
6 Beds | 4½ Baths|3,400 SQ. Feet
  • 37807 Freesia Ct
  • $2,198,000
Photo of Listing #40873956 Remove
5 Beds | 3 Baths|3,124 SQ. Feet
  • 288 Tiffany Terrace
  • $1,795,000

FREMONT, California

Community Real Estate Details for FREMONT

Explore FREMONT, California

Located on the southeast side of the San Francisco Bay is Fremont California, a heterogeneous city of distinct neighborhoods. Formed in 1956, when five small towns incorporated, Fremont eventually became the fourth most populous city in the Bay Area and the fifth largest city in California. The five original communities, now called districts, have retained their unique personalities, helping to keep Fremont a diverse and interesting place to live.

FREMONT Real Estate Statistics

  • Total Listings: 368
  • Average price: $1,246,228
  • Highest Price: $11,800,000
  • Lowest Price: $140,000

Bay East ©2019. CCAR ©2019. BridgeMLS ©2019. Information deemed reliable but not guaranteed.
This information is being provided by the Bay East MLS or the CCAR MLS or the EBRDI MLS. The listings presented here may or may not be listed by the Broker/Agent operating this website.