Skip main navigation
Sold for $560,000
  • $560,000

    588 Overstone Ave, Madera, CA 93636

    5beds
    3baths
    2,611sqft
    Residential, Single Family Residence
    Built in 2023
    5,227 Square Feet Lot
    $561,800 Zestimate®
    $214/sqft
    $3,080 Estimated rent

    Home value

    $561,800

    $506,000 - $629,000

    $3,080/mo

    Zestimate® history
    Loading
    Loading...

    Owner options

    List your home for rent

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

    Rent Zestimate®

    Refinance and save

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

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

    Citrus treesMature landscapingBeautifully upgraded spanish-style residenceLarge islandOpen-concept layoutSpacious secondary bedroomsCustom tile backsplash
    Massive Price Reduction!!Welcome to this beautifully upgraded Spanish-style residence in the highly sought-after Tesoro Viejo community, built in 2023 and offering approximately 2,611 square feet of thoughtfully designed modern living with owned solar, a major value-add providing long-term energy efficiency and cost savings. This 5-bedroom, 3-bath home blends contemporary finishes with timeless architectural character, featuring tall ceilings, dramatic wood beams, and an open-concept layout ideal for both everyday living and entertaining. The inviting great room is anchored by a custom fireplace with Spanish-style detailing, built-in shelving, and accent lighting, creating a warm and sophisticated focal point. The kitchen is designed for both function and style with upgraded cabinetry, custom tile back splash, display glass cabinets, and a large island that seamlessly connects to the dining and living spaces perfect for gatherings and daily living alike. Durable luxury vinyl flooring flows throughout the main areas with plush carpet in the bedroom areas, while upgraded lighting, chandeliers, and ceiling fans enhance the home's modern aesthetic. The large backyard is designed as a private retreat featuring a covered patio, expansive low-maintenance synthetic lawn, added concrete, mature landscaping, citrus trees, and garden areas perfect for relaxing or entertaining year-round. The flexible floor plan includes spacious secondary bedrooms and a versatile large loft ideal for a media room, office, or play space, along with a 2-car garage. Custom touches and thoughtful upgrades are found throughout the home, elevating it well beyond standard new construction and adding both style and functionality at every turn. Ideally located within the community, this home enjoys close proximity to scenic walking trails and convenient pedestrian pathways that lead directly to the recreation center and the heart of Tesoro Viejo, making it easy to enjoy the neighborhood's amenities and lifestyle. Residents benefit from resort-style features including a community pool, spa, tennis courts, clubhouse, parks, and vibrant neighborhood events, all while being conveniently situated with easy access to Fresno, dining, and shopping. This nearly new home offers the rare opportunity to own a highly upgraded, energy-efficient property with designer finishes, custom details, owned solar, and an exceptional location within one of the Central Valley's most desirable communities!

    Zillow last checked:

    Listing updated:

    Listed by:

    Robert Aaron Mitchell DRE #01338677 559-250-3442,

    LPT Realty, Inc

    Bought with:

    Ivette F. Chavez, DRE #02061818

    Miracle Realty

    Source: Fresno MLS,MLS#: 644463Originating MLS: Fresno MLS

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 5
    • Bathrooms: 3
    Primary bedroom
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 1
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 2
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 3
    • Area: 0
    • Dimensions: 0 x 0
    Bedroom 4
    • Area: 0
    • Dimensions: 0 x 0
    Bathroom
    • Features: Tub/Shower, Shower
    Dining room
    • Area: 0
    • Dimensions: 0 x 0
    Family room
    • Area: 0
    • Dimensions: 0 x 0
    Kitchen
    • Features: Eat-in Kitchen, Breakfast Bar, Pantry
    • Area: 0
    • Dimensions: 0 x 0
    Living room
    • Area: 0
    • Dimensions: 0 x 0
    Basement
    • Area: 0
    Heating
    • Has Heating (Unspecified Type)
    Cooling
    • Central Air
    Appliances
    • Included: F/S Range/Oven, Dishwasher, Microwave
    • Laundry: Inside, Utility Room
    Features
    • Isolated Bedroom, Loft
    • Flooring: Carpet, Laminate, Tile
    • Windows: Double Pane Windows
    • Number of fireplaces: 1
    • Fireplace features: Zero Clearance
    Interior area
    • Total structure area: 2,611
    • Total interior livable area: 2,611 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Garage - Attached
    • Attached garage spaces: 2
    Features
    • Levels: Two
    • Stories: 2
    • Patio & porch: Covered
    • Has private pool: Yes
    • Pool features: Community, In Ground
    • Has spa: Yes
    • Spa features: Community
    • Fencing: Fenced
    Lot
    • Size: 5,227 Square Feet
    • Features: Urban, Mature Landscape
    Details
    • Parcel number: 081200031000

    Construction

    Type & style
    • Home type: SingleFamily
    • Property subtype: Residential, Single Family Residence
    Materials
    • Stucco
    • Foundation: Concrete
    • Roof: Tile
    Condition
    • Year built: 2023

    Utilities & green energy

    • Electric: On
    • Sewer: Public Sewer
    • Water: Public
    • Utilities for property: Public Utilities
    Green energy
    • Energy generation: Solar

    Community & HOA

    HOA
    • Has HOA: Yes
    • Amenities included: Pool, Spa/Hot Tub, Clubhouse, Fitness Center, Green Area, Tennis Court(s), Lake/Pond, Playground, Maintenance Grounds
    • HOA fee: $207 monthly
    Location
    • Region: Madera

    Financial & listing details

    • Price per square foot: $214/sqft
    • Tax assessed value: $603,247
    • Date on market: 2/27/2026
    • Cumulative days on market: 98 days
    • Listing agreement: Exclusive Right To Sell

    Price history

    DateEventPrice
    7/2/2026Sold$560,000-1.4%$214/sqft
    Source: Fresno MLS #644463 Report a problem
    6/8/2026Pending sale$568,000$218/sqft
    Source: Fresno MLS #644463 Report a problem
    5/21/2026Price change$568,000-5%$218/sqft
    Source: Fresno MLS #644463 Report a problem
    2/27/2026Listed for sale$598,000+7%$229/sqft
    Source: Fresno MLS #644463 Report a problem
    1/20/2024Listing removed--
    Source: Fresno MLS #593899 Report a problem
    6/21/2023Sold$559,000-2.5%$214/sqft
    Source: Public Record Report a problem
    5/7/2023Pending sale$573,195$220/sqft
    Source: Fresno MLS #593899 Report a problem
    5/3/2023Listed for sale$573,195+5.4%$220/sqft
    Source: Fresno MLS #593899 Report a problem
    2/1/2023Listing removed--
    Source: Fresno MLS #585086 Report a problem
    1/11/2023Listed for sale$543,960+3.7%$208/sqft
    Source: Fresno MLS #589268 Report a problem
    1/2/2023Listing removed$524,500$201/sqft
    Source: Fresno MLS #585086 Report a problem
    11/6/2022Price change$524,500-1.9%$201/sqft
    Source: Fresno MLS #585086 Report a problem
    10/17/2022Price change$534,500-1.8%$205/sqft
    Source: Fresno MLS #585086 Report a problem
    9/21/2022Listed for sale$544,500$209/sqft
    Source: Fresno MLS #585086 Report a problem

    Public tax history

    YearProperty taxesTax assessment
    2026-- $603,247 +2%
    2025$8,176 +4.1%$591,420 +3.8%
    2024$7,857 +161.4%$569,824 +361.7%
    2023$3,006 +28.3%$123,420 +2%
    2022$2,343 +73.4%$121,000 +734.2%
    2021$1,351 +72.7%$14,505 +1%
    2020$782 +1.3%$14,357 +2%
    2019$773 +15.2%$14,076 +2%
    2018$671 $13,800
    Find assessor info on the county website

    Neighborhood: 93636

    Nearby schools

    GreatSchools rating
    Schools provided by the listing agent
    • Elementary: Hillside
    • Middle: Hillside
    • High: Minarets

    Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.

    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
    $561,800
    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
    $561,800