Back to Saved Search
Listing 8 out of 200
Open House Saturday Aug 24, 1:30pm–4:30pm
$2,198,000 For Sale

37807 Freesia Court
Fremont, CA 94536

6 beds, 4 full, 1 partial baths | Single Family Home
3,400 sq ft; lot: 6865 sq ft lot - MLS# ML81764095 Courtesy of MLSListingsX, Sirisha Sinha
Property Photo


**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 Houses

  • Saturday Aug 24, 1:30pm–4:30pm
  • Sunday Aug 25, 1:30pm–4:30pm


  • Property Type: Single Family Home
  • Sub Type: Detached
  • Listing Status: Active
  • County/Area: Alameda County
  • Zip Code: 94536
  • Year Built: 2000
  • Age: 19
  • High School: Fremont (510) 657-2350
  • Sq.Ft.: 3,400 sq ft
  • Style: Spanish
  • Bedrooms: 6
  • Full Baths: 4
  • Half Baths: 1
  • Garage: 2-Car
  • Fireplace: Family Room, Living Room, 2
  • Lot Size: 6865 sq ft lot
  • Baths: 5
  • Open House: 08-24-2019 1:30 PM - 4:30 PM
  • View: Hills
  • Zoning: R1
  • Bath-Master Includes: Stall Shower
  • Elementary School Distric: Fremont (510) 657-2350
  • Equipment Additional: Water Softener System
  • Flooring: Hardwood Floors, Laminate, Stone (Marble, Slate Etc., Tile, Carpet
  • Foundation: Slab
  • Garage/Parking: Attached Garage, Off Street Parking
  • HOA: Yes
  • HOA Amenities: Playground
  • HOA Fee: 85
  • Heating: Forced Air 1 Zone
  • Kitchen Features: 220 Volt Outlet, Dishwasher, Garbage Disposal, Gas Range/Cooktop, Island, Microwave, Pantry, Trash Compactor
  • Lot Sq Ft Apx: 6865
  • Roof: Tile
  • Room - Additional: Formal Dining Room
  • Units In Complex: 112
  • Water/Sewer: Sewer System - Public, Water - Public
Courtesy of MLSListingsX, Sirisha Sinha


Register Now
Already registered? Login

Sign in to take advantage of all this site has to offer. Save your favorite listings and searches – also receive email updates when listings you like come on the market for free!
*Contact Information is NOT Shared*

Stephen Lin

Stephen Lin
RE/MAX Accord
Fremont, CA 94539

Contact Me

Quick Search

view all



No Min.

No Max.

Stephen Lin | 510-574-6640 | Contact Me
39644 Mission Blvd - Fremont, CA 94539
Copyright © 2017, All Rights Reserved

house realtor mls

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu