$598,000

588 Overstone Ave Madera, CA 93636

Estimated payment $4,054/month

Total Views 2,689
5 Beds
2.5 Baths
2,611 Sq Ft
$229 Price per Sq Ft

Highlights

  • Fitness Center
  • In Ground Pool
  • Main Floor Bedroom
  • Ranchos Middle School Rated A-
  • Clubhouse
  • Great Room

About This Home

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!

Listing Agent

Robert Mitchell

LPT Realty, Inc Brokerage Phone: 559-250-3442 License #01338677 Listed on: 03/17/2026

LPT Realty, Inc

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2023

Lot Details

  • 5,227 Sq Ft Lot
  • Wood Fence
  • Landscaped
  • Lawn
  • Back and Front Yard

HOA Fees

  • $207 Monthly HOA Fees

Parking

  • 2 Car Attached Garage
  • Parking Available
  • Garage Door Opener
  • Driveway

Home Design

  • Entry on the 1st floor
  • Slab Foundation
  • Tile Roof
  • Stucco

Interior Spaces

  • 2,611 Sq Ft Home
  • 2-Story Property
  • Ceiling Fan
  • Zero Clearance Fireplace
  • Shutters
  • Sliding Doors
  • Family Room with Fireplace
  • Great Room
  • Family or Dining Combination
  • Vinyl Flooring
  • Neighborhood Views
  • Laundry Room

Kitchen

  • Breakfast Bar
  • Walk-In Pantry
  • Gas Oven
  • Gas Range
  • Microwave
  • Dishwasher
  • Kitchen Island

Bedrooms and Bathrooms

  • 5 Bedrooms | 1 Main Level Bedroom
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub with Shower
  • Walk-in Shower

Pool

  • In Ground Pool
  • Spa

Additional Features

  • Covered Patio or Porch
  • Central Heating and Cooling System

Listing and Financial Details

  • Tax Lot 187
  • Tax Tract Number 273
  • Assessor Parcel Number 081200031
  • Seller Considering Concessions

Community Details

Overview

  • Front Yard Maintenance
  • Foothills

Amenities

  • Clubhouse

Recreation

  • Tennis Courts
  • Community Playground
  • Fitness Center
  • Community Pool
  • Community Spa
  • Park
  • Bike Trail

Home Details

Home Type

Single Family

Year Built

Built in 2023

Lot Details

5,227 Sq Ft Lot

HOA Fees

$207 per month

Parking

2

Listing Details

  • Structure Type: House
  • Assessments: Yes
  • Property Attached: No
  • Subdivision Name Other: Tesoro Viejo
  • View: Yes
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 081200031
  • Year Built: 2023
  • AgentOnly_SellerConsiderConcessionYN: Yes
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 2611.00 Square Feet
  • Interior Amenities: Ceiling Fan(s), Pantry
  • Stories: 2
  • Common Walls: No Common Walls
  • Flooring: Vinyl
  • Appliances: Yes
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Door Features: Sliding Doors
  • Eating Area: Breakfast Counter / Bar, In Family Room
  • Entry Level: 1
  • Fireplace Features: Zero Clearance, Family Room
  • Levels: Two
  • Main Level Bathrooms: 1
  • Main Level Bedrooms: 1
  • Price Per Square Foot: 229.03
  • Room Type: Primary Bedroom, Laundry, Kitchen, Great Room, Main Floor Bedroom, Primary Bathroom
  • Spa Features: Community
  • Window Features: Shutters
  • Bathroom Features: Shower In Tub, Double Sinks In Bath(s), Double Sinks In Primary Bath, Shower
  • Room Kitchen Features: Kitchen Island, Walk-In Pantry

Exterior Features

  • Patio: Yes
  • Foundation: Slab
  • View: Neighborhood
  • Fence: Yes
  • Fencing: Wood
  • Patio And Porch Features: Covered, Front Porch, Concrete
  • Pool Features: In Ground, Community
  • Pool Private: No
  • Roof: Tile
  • Spa: Yes
  • Construction Materials: Stucco

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 2.00
  • Parking: Yes
  • Parking Features: Garage, Driveway, Garage Door Opener
  • Total Parking Spaces: 2.00

Utilities

  • Heating: Yes
  • Laundry: Yes
  • Appliances: Microwave, Gas Range, Gas Oven, Dishwasher
  • Heating Type: Central
  • Laundry Features: Inside
  • Sewer: Public Sewer
  • Water Source: Public
  • Cooling: Central Air
  • Cooling: Yes

Condo/Co-op/Association

  • Association: Yes
  • Amenities: Gym/Ex Room, Maintenance Front Yard, Playground, Tennis Court(s), Pool, Clubhouse, Spa/Hot Tub
  • Association Fee: 207.00
  • Association Fee Frequency: Monthly
  • Association Name: Unknown
  • Phone: Unknown
  • Senior Community: No
  • Community Features: Biking, Foothills, Sidewalks, Park
  • Association Management: Unknown

Schools

  • Elementary School Other: Hillside
  • High School Other: Minarets
  • Middle Or Junior School Other: Hillside

Lot Info

  • Additional Parcels: No
  • Land Lease: No
  • Lot Features: Landscaped, Front Yard, Back Yard, Lawn
  • Lot Size Sq Ft: 5227.00
  • Lot Size Acres: 0.1200

Multi Family

  • Lease Considered: No
  • Lot Size Area: 5227.0000 Square Feet
  • Number Of Units Total: 1

Tax Info

  • Tax Lot: 187
  • Tax Tract Number: 273

Map

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $7,857 $591,420 $98,838 $492,582
2023 $7,857 $123,420 $123,420 --
2022 $2,343 $121,000 $121,000 $0
2021 $1,351 $14,505 $14,505 $0
2020 $782 $14,357 $14,357 $0
2019 $773 $14,076 $14,076 $0
2018 $671 $13,800 $13,800 $0
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
03/17/2026 03/17/26 For Sale $598,000 -- $229 / Sq Ft
Source: California Regional Multiple Listing Service (CRMLS)

Purchase History

Date Type Sale Price Title Company
Deed -- First American Title
Grant Deed $559,000 First American Title
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $398,651 New Conventional
Source: Public Records

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: FR26058360

California Regional Multiple Listing Service (CRMLS)

APN: 081-200-031

Your Personal Tour Guide

Ask me questions while you tour the home.