Skip main navigation
Closed
  • $2,500,000

    504 Merlot Dr, Fremont, CA 94539

    3beds
    2,145sqft
    Single Family Residence
    Built in 1984
    5,998.21 Square Feet Lot
    $2,544,500 Zestimate®
    $1,166/sqft
    $5,293 Estimated rent

    Home value

    $2,544,500

    $2.29M - $2.82M

    $5,293/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

    $5,293/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,293/mo

    Rent Zestimate®

    Refinance and save

    $15,821/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

    $15,821/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

    Ample cabinetryHillside viewsSpacious family roomCharming garden bay windowCrown molding throughoutQuartz countertopsBeautifully decorated foyer
    Welcome to this stunning north-facing home located in the prestigious Scott Creek Terrace neighborhood. Meticulously maintained and offering up to four bedrooms and two full bathrooms, this residence truly reflects pride of ownership. Thoughtful details are found throughout, from elegant chandeliers and wall sconces in every room to the inviting backyard oasis featuring a pool and spa. Upon entry, the beautifully decorated foyer leads into a bright, open living and dining area designed for both comfort and style. The spacious family room features vaulted ceilings with recessed lighting and a brick fireplace accented by a classic wooden mantel, creating a warm and welcoming atmosphere. French doors flood the space with natural light and open to the backyard, showcasing the newly resurfaced pool and spa, a spacious patio with newly installed pavers, and a covered pergola, perfect for entertaining or relaxing year-round. The updated kitchen offers ample cabinetry, quartz countertops, a top-of-the-line gas stove, hardwood floors, and a charming garden bay window. Adjacent to the kitchen is a cozy breakfast nook ideal for casual dining. A spacious guest bedroom or office with built-in cabinetry and a desk provides an ideal work-from-home or guest space. Each generously sized bedroom features spacious closets and comfortable proportions, offering flexibility for families of all sizes. The primary suite is a true retreat, featuring vaulted ceilings, plush carpeting, bedside pendant lighting, a ceiling fan, and French doors that open to serene views of the pool and spa. The upgraded primary bathroom includes dual sinks with cabinetry and an enclosed tub and shower, creating a luxury spa-like experience. Additional highlights include newer interior and exterior paint, crown molding throughout, dual-pane windows, plantation shutters, central heating, ceiling fans, upgraded lighting, an interior laundry room with cabinetry, copper plumbing, a newer tiled roof, and newer furnace system. Centrally located in the Bay Area, this home offers hillside views, top-rated schools, and a convenient commute to Silicon Valley. This is a rare opportunity to own a truly special home. One you won't want to miss!

    Zillow last checked:

    Listing updated:

    Listed by:

    Rubelyn Wells DRE #01860416 209-814-4286,

    Keller Williams Central Valley

    Bought with:

    Redfin

    Source: MetroList Services of CA,MLS#: 226001593Originating MLS: MetroList Services, Inc.

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 3
    • Bathrooms: 2
    • Full bathrooms: 2
    Primary bedroom
    • Features: Closet, Outside Access
    Primary bathroom
    • Features: Double Vanity, Tub w/Shower Over, Quartz, Window
    Dining room
    • Features: Dining/Living Combo
    Kitchen
    • Features: Breakfast Area, Quartz Counter, Stone Counters
    Heating
    • Central, Fireplace(s)
    Cooling
    • Ceiling Fan(s)
    Appliances
    • Included: Free-Standing Refrigerator, Ice Maker, Dishwasher, Microwave, Free-Standing Gas Oven
    • Laundry: Laundry Room, Cabinets, Gas Dryer Hookup, Inside, Inside Room
    Features
    • Flooring: Carpet, Tile, Wood
    • Number of fireplaces: 1
    • Fireplace features: Brick, Living Room, Raised Hearth, Family Room, Stone
    Interior area
    • Total interior livable area: 2,145 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached, Garage Faces Front
    • Attached garage spaces: 2
    Features
    • Stories: 1
    • Has private pool: Yes
    • Pool features: In Ground, Pool Cover, Pool Sweep, Pool/Spa Combo, Fenced
    Lot
    • Size: 5,998 sqft
    • Features: Auto Sprinkler F&R, Low Maintenance
    Details
    • Additional structures: Pergola
    • Parcel number: 519169043
    • Zoning description: R1
    • Special conditions: Standard

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Single Family Residence
    Materials
    • Wood, Wood Siding
    • Foundation: Raised
    • Roof: Tile
    Condition
    • Year built: 1984

    Utilities & green energy

    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Public, Cable Connected

    Community & neighborhood

    Location
    • Region: Fremont

    Price history

    DateEventPrice
    2/9/2026Sold$2,500,000+13.7%$1,166/sqft
    Source: Public Record Report a problem
    1/13/2026Pending sale$2,198,000$1,025/sqft
    Source: MetroList Services of CA #226001593 Report a problem
    1/7/2026Listed for sale$2,198,000$1,025/sqft
    Source: MetroList Services of CA #226001593 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025-- $563,413 +2%
    2024$7,005 +2.9%$552,366 +2%
    2023$6,809 +1.5%$541,537 +2%
    2022$6,709 +2.5%$530,920 +2%
    2021$6,546 +0.3%$520,510 +1%
    2020$6,529 +1.1%$515,173 +2%
    2019$6,455 +4.6%$505,071 +2%
    2018$6,168 $495,170 +2%
    2017$6,168 +1.8%$485,461 +2%
    2016$6,057 +3.3%$475,945 +1.5%
    2015$5,864 $468,798 +2%
    2014$5,864 $459,617 +0.5%
    2013-- $457,541 +2%
    2012-- $448,571 +2%
    2011-- $439,776 +0.8%
    2010-- $436,490 -0.2%
    2009-- $437,530 +2%
    2008-- $428,954 +2%
    2007-- $420,546 +2%
    2006-- $412,301 +2%
    2005-- $404,218 +2%
    2004-- $396,299 +1.9%
    2003-- $389,034 +2%
    2002-- $381,407 +2%
    2001$4,081 $373,929

    Find assessor info on the county website

    Neighborhood: Warm Springs

    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,544,500
    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,544,500