Skip main navigation
Off market
  • $823,900

    604 Sycamore Ave, Modesto, CA 95354

    3beds
    3baths
    2,097sqft
    1 House on Lot
    Built in 1993
    5,732 Square Feet Lot
    $823,900 Zestimate®
    $393/sqft
    $2,782 Estimated rent

    Home value

    $823,900

    $783,000 - $873,000

    $2,782/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $2,782/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

    $2,782/mo

    Rent Zestimate®

    Refinance and save

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

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

    Dive in to your pool in your very own Stunning Tuscan Villa. Step under arched entranceways into a home where the vaulted ceilings and tiled floors showcase the traditional styles of the neighborhood. Enjoy your coffee or a cocktail out on the terrace before sunbathing by the pool. Every day can be a vacation for the new owners of this gorgeous home featuring traditional architecture with modern amenities. Stainless Steel professional wolf, thermador and Jenn Air appliances, limestone master bathroom suite, accent lighting inside and out, wired sound throughout, plantation shutters, new A/C, custom skylights and custom video surveillance. Totaling over 200k in remodeling. 2020-08-03

    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: 3
    • Bathrooms: 3
    Heating
    • Forced air
    Cooling
    • Central
    Appliances
    • Included: Dishwasher, Garbage disposal, Refrigerator
    • Laundry: Other-Rmks
    Features
    • Dining Room, Living Room, Master Suite, Separate Family Room
    • Flooring: Tile, Carpet
    • Has fireplace: Yes
    • Fireplace features: Other-Rmks
    Interior area
    • Total interior livable area: 2,097 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    Features
    • Exterior features: Stucco, Wood
    • Pool features: Gunite, Private
    Lot
    • Size: 5,732 sqft
    • Features: Shape Regular, Sidewalk/Curb/Gutter, Other-Rmks
    Details
    • Parcel number: 113012049000
    • Zoning: SFR

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Other-Rmks
    • Property subtype: 1 House on Lot
    Materials
    • wood frame
    Condition
    • Year built: 1993

    Utilities & green energy

    • Sewer: Other-Rmks
    • Water: Public District
    • Utilities for property: All Public
    Green energy
    • Energy efficient items: Dual Pane Full

    Community & neighborhood

    Location
    • Region: Modesto

    Other

    Other facts
    • Flooring: Carpet, Tile
    • Appliances: Dishwasher, Disposal, Wine Refrigerator
    • FireplaceYN: true
    • GarageYN: true
    • AttachedGarageYN: true
    • HeatingYN: true
    • CoolingYN: true
    • StructureType: Detached
    • FireplacesTotal: 2
    • Zoning: SFR
    • ConstructionMaterials: Stucco, Wood
    • PoolPrivateYN: True
    • ParkingFeatures: Attached, Garage Door Opener, Alley Access, Garage Faces Side
    • CoveredSpaces: 2
    • PoolFeatures: Gunite, Private
    • Cooling: Central Air
    • Heating: Central
    • InteriorFeatures: Dining Room, Living Room, Master Suite, Separate Family Room
    • RoomMasterBedroomFeatures: Walk-In Closet(s), Closet Walk-In 2+
    • RoomMasterBathroomFeatures: Double Vanity, Shower Stall(s)
    • RoadResponsibility: Public Maintained Road
    • BedroomsPossible: 0.00
    • LotFeatures: Shape Regular, Sidewalk/Curb/Gutter, Other-Rmks
    • Sewer: Other-Rmks
    • RoomBathroomFeatures: Tub w/Shower Over
    • RoomDiningRoomFeatures: Dining Bar, Formal Area
    • WaterSource: Public District
    • LivingAreaSource: Assessor/Auto-Fill
    • ArchitecturalStyle: Other-Rmks
    • Utilities: All Public
    • MlsStatus: Pending Sale
    • PropertySubType: 1 House on Lot
    • GreenEnergyEfficient: Dual Pane Full
    • Roof: Other-Rmks
    • LaundryFeatures: Other-Rmks
    • FireplaceFeatures: Other-Rmks
    • FoundationDetails: Other-Rmks

    Price history

    DateEventPrice
    9/4/2020Sold$749,000$357/sqft
    Source: MetroList Services of CA #20042233 Report a problem
    8/3/2020Pending sale$749,000$357/sqft
    Source: Modesto - Carpenter Office #20042233 Report a problem
    7/23/2020Listed for sale$749,000+25.9%$357/sqft
    Source: PMZ Real Estate #20042233 Report a problem
    1/31/2007Sold$595,000+1.7%$284/sqft
    Source: MetroList Services of CA #60120339 Report a problem
    10/13/2004Sold$585,000+74.6%$279/sqft
    Source: MetroList Services of CA #40060340 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2025$9,481 +4.7%$810,739 +2%
    2024$9,056 +1.5%$794,843 +2%
    2023$8,923 +2.5%$779,259 +2%

    Find assessor info on the county website

    Neighborhood: 95354

    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
    $823,900
    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
    $823,900