Skip main navigation
Off market
  • $795,700

    604 Sycamore Ave, Modesto, CA 95354

    3beds
    3baths
    2,097sqft
    1 House on Lot
    Built in 1993
    5,732 Square Feet Lot
    $795,700 Zestimate®
    $379/sqft
    $3,203 Estimated rent

    Home value

    $795,700

    $748,000 - $843,000

    $3,203/mo

    Zestimate® history
    Loading...

    Owner options

    List your home for rent

    $3,203/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

    $3,203/mo

    Rent Zestimate®

    Refinance and save

    $4,902/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

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

    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 pre-qualified for a loan
    At Zillow Home Loans, we can pre-qualify you in as little as 5 minutes with no impact to your credit score.

    An equal housing lender. NMLS #10287.

    Sell for more on Zillow
    Get a free Zillow Showcase℠ listing and you could sell for .
    $795,700
    2% more+ $15,914
    With Zillow Showcase(estimated)
    $811,614