Thank you for visiting today. If this is your first visit, take your time and look around. I have plenty of information and resources available to you. If you are a return visitor, thank you. I would love to hear from you and tell you how I can serve all your real estate needs.

Bedrooms
Baths
Min Price
Max Price
Back to Saved Search
Listing 4 out of 51
$2,198,000 For Sale

37807 Freesia Ct
Fremont, CA 94536

6 beds, 4 full, 1 partial baths | Single Family Home
3,400 sq ft; lot: 6970 sq ft lot - MLS# 40877218 Courtesy of Skye Real Estate, Sirisha Sinha
Property Photo
1/39

Description

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

Features

  • Property Type: Single Family Home
  • Sub Type: Detached
  • Listing Status: Active
  • County/Area: Alameda County
  • Zip Code: 94536
  • Year Built: 2000
  • Age: 19
  • Subdivision/Neighborhood: Riverwalk
  • High School: Fremont (510) 657-2350
  • Sq.Ft.: 3,400 sq ft
  • Style: Spanish
  • Stories: Two Story
  • Total Rooms: 14
  • Bedrooms: 6
  • Full Baths: 4
  • Half Baths: 1
  • Garage: 2-Car
  • Fireplace: Family Room, Living Room, 2
  • Lot Size: 6970 sq ft lot
  • Baths: 5
  • View: Hills
  • Bath Non-Mstr Include: Solid Surface, Sunken Tub, Updated Baths
  • Bath-Master Includes: Solid Surface, Stall Shower, Sunken Tub, Tub With Jets, Updated Baths
  • Construction Status: Existing
  • Cooling: Central 2 Or 2+ Zones A/C, Whole House Fan
  • Elementary School Distric: Fremont Union
  • Equipment Additional: Dryer, Garage Door Opener, Mirrored Closet Door(S), Washer, Water Heater Gas, Water Softener System, Window Coverings
  • Exterior: Dual Pane Windows, Stucco
  • Flooring: Hardwood Floors, Stone (Marble, Slate Etc., Tile, Carpet
  • Foundation: Slab
  • Garage/Parking: Attached Garage
  • HOA: Yes
  • HOA Amenities: Greenbelt
  • HOA Fee: 85
  • HOA Fees Freq: Monthly
  • HOA Fees Include: Management Fee, Reserves, Other
  • HOA Name: Common Interest Management
  • Heating: Forced Air 2 Zns Or More
  • Kitchen Features: 220 Volt Outlet, Counter - Solid Surface, Counter - Stone, Dishwasher, Eat In Kitchen, Garbage Disposal, Gas Range/Cooktop, Island, Microwave, Pantry, Refrigerator, Trash Compactor, Updated Kitchen
  • Laundry: 220 Volt Outlet, Dryer, In Laundry Room, Washer
  • Level - Street: 1 Bedroom, 1.5 Baths, Main Entry
  • Level - Upper: 4 Bedrooms, 3 Baths, Master Bedrm Suite - 1, Laundry Facility
  • Lot Description: Regular
  • Lot Sq Ft Apx: 6865
  • Pets: Allowed - Yes
  • Roof: Tile
  • Room - Additional: Dining Area, Kitchen/Family Combo, Media
  • Water/Sewer: Sewer System - Public, Water - Public
  • Yard Description: Back Yard, Fenced, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic, Sprinklers Back, Sprinklers Front
Courtesy of Skye Real Estate, Sirisha Sinha

Thank you for visiting today. If this is your first visit, take your time and look around. I have plenty of information and resources available to you. If you are a return visitor, thank you. I would love to hear from you and tell you how I can serve all your real estate needs.

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu