Skip main navigation
Off market
  • $2,759,600

    37804 Freesia Ct, Fremont, CA 94536

    5beds
    3,400sqft
    SingleFamily
    Built in 2001
    5,998 Square Feet Lot
    $2,759,600 Zestimate®
    $812/sqft
    $5,951 Estimated rent

    Home value

    $2,759,600

    $2.59M - $2.93M

    $5,951/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,951/mo

    Rent Zestimate®

    Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.

    Learn more

    $5,951/mo

    Rent Zestimate®

    Refinance and save

    $17,830/mo

    Est. payment

    Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.

    See today's rates

    $17,830/mo

    Est. payment

    Explore your selling options

    Work with a Zillow partner agent

    Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.

    Get started

    List with your own agent

    Get your home in front of millions of buyers by listing it on Zillow.

    Learn how to do it

    Sell it yourself

    Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).

    List your home

    What's special

    Welcome to this exquisite luxury home in the highly coveted Riverwalk community built by Pacific Union Homes * Recently upgraded by $200,000, this fabulous floorplan boasts 5 bedrooms + oversized den (optional 6th bed), 4.5 baths & 3,400 sq ft of living space * Welcomed by a bright & open floor plan with rich laminated hardwood floors, high soaring ceilings & ambient light * A gourmet kitchen with center island offers quality shaker cabinets, pull out drawers, stainless steel appliances & quartz counters * Elegant master with spa-styled en-suite includes walk-in closet, soaking tub & rainfall shower * Ultra private backyard retreat has raised planters, flagstone patio & mature foliage (including heavily productive orange, plum & apple trees) is great for enjoying the outdoors * Upgrades include plantation shutters, Porcelanosa tile, Restoration Hardware lighting, media center by Valet Cabinets & finished garage with 240V car charging * Excellent location adjacent Alameda Creek trail!

    This property is off market, which means it's not currently listed for sale or rent on Zillow. This may be different from what's available on other websites or public sources.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 5
    • Full bathrooms: 4
    • 1/2 bathrooms: 1
    Heating
    • Forced air, Gas
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Range / Oven
    • Laundry: In Laundry Room
    Features
    • Flooring: Tile, Carpet, Laminate
    • Number of fireplaces: 1
    Interior area
    • Total interior livable area: 3,400 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stucco
    • Has view: Yes
    • View description: Territorial
    Lot
    • Size: 5,998 sqft
    Details
    • Parcel number: 50152947

    Construction

    Type & style
    • Home type: SingleFamily
    Materials
    • wood frame
    • Roof: Tile
    Condition
    • Year built: 2001

    Community & neighborhood

    Location
    • Region: Fremont

    HOA & financial

    HOA
    • Has HOA: Yes
    • HOA fee: $90 monthly

    Other

    Other facts
    • Class: RESIDENTIAL
    • BATH-MASTER INCLUDES: Stall Shower, Tub, Updated Baths
    • BATH NON-MSTR INCLUDE: Shower Over Tub
    • CONSTRUCTION STATUS: Existing
    • EXTERIOR: Stucco, Dual Pane Windows
    • GARAGE/PARKING: Attached Garage, Int Access From Garage
    • KITCHEN FEATURES: Dishwasher, Garbage Disposal, Range/Oven Free Standing, Breakfast Nook, Gas Range/Cooktop, Pantry, Updated Kitchen, Breakfast Bar, Island, Counter - Stone
    • LAUNDRY: In Laundry Room
    • LEVEL - STREET: 1 Bath, Main Entry, 2 Bedrooms, No Steps to Entry
    • LOT DESCRIPTION: Level
    • ROOF: Tile
    • ROOM - ADDITIONAL: Dining Area, Family Room, Den
    • STYLE: Contemporary
    • WATER/SEWER: Sewer System - Public, Water - Public
    • YARD DESCRIPTION: Patio, Back Yard, Sprinklers Automatic, Fenced, Front Yard
    • Garage (Y/N): Yes
    • Stories: Two Story
    • EQUIPMENT ADDITIONAL: Garage Door Opener, Water Heater Gas, Window Coverings
    • HOA Fees Freq: Monthly
    • HOA: Yes
    • COOLING: Central 2 Or 2+ Zones A/C
    • HEATING: Forced Air 2 Zns or More, Gas
    • FLOORING: Laminate, Tile, Carpet
    • HOA AMENITIES: Greenbelt
    • City: FREMONT
    • Source: Measured
    • FIREPLACES: 1
    • List Date: 2020-06-24

    Price history

    DateEventPrice
    8/3/2020Sold$2,220,000+1%$653/sqft
    Source: Bay East AOR #40909718 Report a problem
    7/3/2020Pending sale$2,198,000$646/sqft
    Source: Everhome #40909718 Report a problem
    6/24/2020Listed for sale$2,198,000+131.4%$646/sqft
    Source: Everhome #40909718 Report a problem
    8/30/2011Sold$950,000-30.6%$279/sqft
    Source: Bay East AOR #40500575 Report a problem
    5/11/2007Sold$1,369,000+16%$403/sqft
    Source: Bay East AOR #40257136 Report a problem
    5/10/2005Sold$1,180,000+41.8%$347/sqft
    Source: Bay East AOR #40073757 Report a problem
    9/26/2000Sold$832,000$245/sqft
    Source: Public Record Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $2,379,158 +2%
    2024$27,163 +2.6%$2,332,517 +2%
    2023$26,476 +1.1%$2,286,798 +2%
    2022$26,192 +2.6%$2,241,960 +2%
    2021$25,534 +92.1%$2,198,000 +101.5%
    2020$13,290 +1.2%$1,091,045 +2%
    2019$13,137 +4.6%$1,069,661 +2%
    2018$12,562 $1,048,694 +2%
    2017$12,562 +1.7%$1,028,137 +2%
    2016$12,356 +3%$1,007,977 +1.5%
    2015$11,997 $992,844 +2%
    2014$11,997 $973,397 +0.5%
    2013-- $969,000 +2%
    2012-- $950,000 +4.9%
    2011-- $906,000 -1.5%
    2010-- $920,000 -16.4%
    2009-- $1,100,000 -15.4%
    2008-- $1,300,000 +5.9%
    2007-- $1,227,671 +2%
    2006-- $1,203,600 +33.9%
    2005-- $899,184 +2%
    2004-- $881,558 +1.9%
    2003-- $865,405 +4%
    2002-- $831,800
    2001$8,824 $831,800

    Find assessor info on the county website

    Neighborhood: Parkmont

    Nearby schools

    GreatSchools rating
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,759,600
    Get a cash offer in 3 minutes
    Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
    Estimated market value
    $2,759,600