• $2,198,000
  • 6 bd,
  • 4 full ba,
  • 1 half ba,
  • 3,400 sqft
  • 0.16 lot
  • Est payment $11799.34/mo

37807 Freesia Ct, FREMONT, CA 94536

250039751 37.5661506652832 -121.989639282227 123 /listing/250039751-150081279/37807-freesia-ct-fremont-ca-94536 False 0 2198000.0000 3400 100 6 5 40881386 False

Property & Neighborhood Info

Courtesy Of Sirisha Sinha, SKYE Real Estate

Single Family in FREMONT

**FEATURED home - Mercury News, EastBay Times, ETC!!**(more than $500k in upgrades) in the 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, TESLA campus, Google shuttle stops, 880, 84 and schools!!

Courtesy Of Sirisha Sinha, SKYE Real Estate
  1. 6 Beds
  2. 4 Full Bath
  3. 1 Half Bath
  4. 3,400 Sq. Ft.
  5. 0.16 Lot

Main Features

  • Listing Status: Off Market
  • Year Built: 2000
  • Garage: 2.0
  • Floors: 2
  • Rooms: 14
  • Full Bath: 4
  • Half Bath: 1
  • School District: Fremont Union
  • School District3: Fremont (510) 657-2350
  • County: ALAMEDA
  • Fees: $85.00
  • Subdivision: Riverwalk
  • MLS Number:40881386

Additional Features

  • Amenities:
    • Greenbelt
  • Bathroom Description:
    • Solid Surface
    • Sunken Tub
    • Updated Baths
  • Board:
    • Bay East
  • Construction:
    • Dual Pane Windows
    • Stucco
  • Construction Status:
    • Existing
  • Cooling:
    • Central 2 Or 2+ Zones A/C
    • Whole House Fan
  • Documents:
    • Budget
    • Bylaws
    • CC&R'S
    • Financial Statement
    • Other HOA Docs
    • Reserve Study
    • Rules and Regulations
  • Dues Frequency:
    • Monthly
  • Equipment:
    • Dryer
    • Garage Door Opener
    • Mirrored Closet Door(s)
    • Washer
    • Water Heater Gas
    • Water Softener System
    • Window Coverings
  • Fee Includes:
    • Management Fee
    • Other
    • Reserves
  • Fireplace(s):
    • 2
    • Family Room
    • Living Room
  • Flooring:
    • Carpet
    • Hardwood Floors
    • Slate etc.
    • Stone (Marble
    • Tile
  • Foundation:
    • Slab
  • Garage:
    • Yes
  • Garage/Parking:
    • Attached Garage
  • Handicap Features:
    • None
  • Heating:
    • Forced Air 2 Zns or More
  • HOA:
    • Yes
  • Kitchen Description:
    • 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
  • Lot Description:
    • Regular
  • Master Bath:
    • Solid Surface
    • Stall Shower
    • Sunken Tub
    • Tub with Jets
    • Updated Baths
  • Pets:
    • Allowed - Yes
  • Pool:
    • No
    • None
  • Roof:
    • Tile
  • Rooms:
    • Dining Area
    • Kitchen/Family Combo
    • Media
  • Special Information:
    • None
  • Style:
    • Spanish
  • Terms:
    • Cash
    • Conventional
  • View:
    • Hills
  • Water/Sewer:
    • Sewer System - Public
    • Water - Public
  • Yard:
    • Back Yard
    • Fenced
    • Front Yard
    • Garden/Play
    • Side Yard
    • Sprinklers Automatic
    • Sprinklers Back
    • Sprinklers Front
  • Listing Agent License Number:
    • 01342758
  • mls desc:
    • Bay East
  • MLSSystem ID:
    • Bay East
  • Sale Or Rent:
    • For Sale
  • Tax ID:
    • 501-529-42
  • Total Acres:
    • 0.16
Neighborhood info courtesy of Homes.com © 2019

What's My Mortgage?

$38,769.95*
*Estimated monthly payment is a starting point to help assist you with your home search. To find out more about mortgage pre-qualification, click here.
37.5661506652832 -121.989639282227

37807 Freesia Ct FREMONT, CA 94536

250039751 37.5661506652832 -121.989639282227 123 /listing/250039751-150081279/37807-freesia-ct-fremont-ca-94536 False 0 2198000.0000 3400 100 6 5 40881386 False
  • $2,198,000
  • 6 bd
  • 4 full ba
  • 1 half ba
  • 3,400 sqft
  • 0.16 lot
  • Est payment $11799.34/mo