588 Overstone Ave

Madera, CA 93636

$598,000
Price
5
Beds
3
Baths
2,611 Sq. Ft.
$229 / Sq. Ft.
2,611
Sq. Ft.
$229
per Sq. Ft.
Get preapproved with Rocket Mortgage1
a front view of a house with yard
a front view of a house with yard
a view of a white house with large windows and a small yard
a view of white house with a yard
a view of entryway with livingroom and furniture
a living room with furniture a fireplace and a flat screen tv
a living room with furniture a flat screen tv and a fireplace
a living room with furniture and a large window
a view of a dining room with furniture window and wooden floor
a view of a dining room with furniture and wooden floor
a view of mirror
a kitchen with a table and chairs in it
a kitchen with a sink a counter top space and living room view
a kitchen with a sink a counter top space and stainless steel appliances
a living room with furniture and a ceiling fan
a living room with furniture and a window
a bedroom with a bed and a window
a bedroom with a bed and window
a bathroom with a double vanity sink toilet mirror and shower
a bedroom with a bed and a couch
a bathroom with a sink double vanity and a mirror
a bathroom with a granite countertop sink a mirror and a bathtub
a view of an house with backyard porch and garden
front view of a house with a yard
a view of a porch with furniture
a view of a parking space
a view of a white house with large windows and a yard
a view of a white house with large windows and a table
a view of entryway with outdoor area
an aerial view of a building with ocean view
an aerial view of a ocean
an aerial view of residential houses with outdoor space
an aerial view of a house with a ocean view
a view of a city
a view of a terrace with wooden floor
an aerial view of a city with lots of residential buildings and ocean view in back
a view of a city with an ocean view
a picture of a bench in front of building
a picture of a bench in front of building

Description

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...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!
  1. Listed by Robert A Mitchell • DRE #01338677 • LPT Realty, Inc

Property Details for 588 Overstone Avenue

Garage Type
Attached
Cross Street Address
Overstone / Orchard Hills
LISTING UPDATED: 03/20/2026 12:45 PM

Property Details for 588 Overstone Avenue

StatusActive
MLS #644463
Days on Market32
Taxes-
HOA Fees$207 / month
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family Residence
Year Built2023
Lot Size0.12 AC / 5,227 SF
CountyMadera
Get preapproved with Rocket Mortgage1

Location

Listing Courtesy of LPT Realty, Inc
Add your commute

Building Information for 588 Overstone Avenue

Stories-Year Built2023Building Size-Lot Size0.12 AC / 5,227 SF

Payment Calculator

Get preapproved with Rocket Mortgage1

$3,790 per month

30 year fixed, 6.11% Interest

Principal and Interest

$2,902

Property Taxes

$681

HOA Dues

$207

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 588 Overstone Avenue

Summary
Location and General Information
  • Region: Urban
  • Directions: Use GPS or from Hwy 41 and Tesoro Viejo Blvd go East on Tesoro Viejo Blvd, Continue onto Treasure Hills Dr., North on Hillside Rd, East on Overstone Ave. to address.
  • Census Tract: .00
School Information
  • Schools Comment: BTV ALL Schools!
  • School Name 1: Minarets
  • School Name 2: Hillside
  • School Name 3: Hillside
  • School Type 1: High School
  • School Type 2: Junior High School
  • School Type 3: Grade School
Parking
  • Carport Spaces: 0
Taxes and HOA Information
  • Association: Fresno MLS
Lot Information
  • Square Footage Source: Tax Records
  • APN: 081200031000
  • Lot Size Source: (Tax Records)
  • Multiple Listing Service: Fresno Multiple Listing System
Property
Property and Assessments
  • REO/Bank Owned: No
  • FIPS Code: 39
  • Age: 0
  • Energy Efficiency: Dual Pane Windows
  • Property Disclaimer: Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
  • # of Stories: Two
Utilities
  • Pool: Yes
  • Gas & Electric: Public Utilities
  • Sewer/Water: Public Water, Public Sewer
  • Special Features: Isolated Bedroom
  • Well Depth: 0.0
  • Well HP: 0.0
  • Water Level: 0
Interior and Exterior Features
Exterior Features
  • Exterior: Stucco
  • Foundation: Concrete
  • Roofing: Tile
  • Yard: Fenced, Mature Landscape
  • Patio Features: Covered
  • Pool Features: Community Pool
  • Pool Type: In Ground
  • Association/Park Amenities: Pool, Spa, Club House, Exercise Room, Green Area, Tennis, Lake/Pond, Playground, Landscape Maint
  • Spa Type: Community Spa
  • Spa: Yes
Interior Features
  • Extra Rooms: Loft
  • Bath Features: Tub/Shower, Shower
  • Flooring: Carpet, Laminate, Tile
  • # of Fireplaces: 1
  • Fireplace Type: Zero Clearance
  • Heating & Cooling: Central Heat & Cool
  • Kitchen: F/S Range/Oven, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
  • Laundry: Inside, Utility Room
Rental
Rental Information
  • Lease Type: Net

Property History for 588 Overstone Avenue

DateEvent & SourcePriceAppreciation
Mar 17, 2026

Listed (Active)

CRMLS #FR26058360

$598,000—
Mar 17, 2026

Listed (Active)

CLAW #FR26058360MR

$598,000—
Mar 17, 2026

Listed (Active)

SDMLS #FR26058360

$598,000—
Feb 17, 2026

Listed (Active)

FRESNOMLS #644463

$598,000—
Jan 19, 2024

Withdrawn

FRESNOMLS #593899

—
Jun 15, 2023

Sold (Public Record)

Public Record #1513457160

$559,000—
May 7, 2023

Pending

FRESNOMLS #593899

—
May 3, 2023

Listed (Active)

FRESNOMLS #593899

$573,195—
Jan 11, 2023

Temporarily Off Market

FRESNOMLS #589268

—
Jan 11, 2023

Listed (Active)

FRESNOMLS #589268

$543,960—
Sep 21, 2022

Temporarily Off Market

FRESNOMLS #585086

$524,500—
Sep 21, 2022

Price Change

FRESNOMLS #585086

$544,500—
Sep 21, 2022

Price Change

FRESNOMLS #585086

$534,500—
Sep 21, 2022

Listed (Active)

FRESNOMLS #585086

$524,500—
DateEvent & SourcePrice
03/17/2026

Listed (Active)

CRMLS #FR26058360

$598,000
03/17/2026

Listed (Active)

CLAW #FR26058360MR

$598,000
03/17/2026

Listed (Active)

SDMLS #FR26058360

$598,000
02/17/2026

Listed (Active)

FRESNOMLS #644463

$598,000
01/19/2024

Withdrawn

FRESNOMLS #593899

—
06/15/2023

Sold (Public Record)

Public Record #1513457160

$559,000
05/07/2023

Pending

FRESNOMLS #593899

—
05/03/2023

Listed (Active)

FRESNOMLS #593899

$573,195
01/11/2023

Temporarily Off Market

FRESNOMLS #589268

—
01/11/2023

Listed (Active)

FRESNOMLS #589268

$543,960
09/21/2022

Temporarily Off Market

FRESNOMLS #585086

$524,500
09/21/2022

Price Change

FRESNOMLS #585086

$544,500
09/21/2022

Price Change

FRESNOMLS #585086

$534,500
09/21/2022

Listed (Active)

FRESNOMLS #585086

$524,500

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 588 Overstone Avenue

Taxable ValueLand$98,838Additions$492,582Total$591,420
Tax Record2025$8,176 ($681 / month)
Home Facts
Beds4Total Finished SqFt2,611 SqFtAbove Grade Finished SqFt2,611 SqFtStories2Lot Size5,227 SqFtStyleSingle Family ResidenceYear Built2023CountyMADERAAPN081-200-031-000

Schools near 588 Overstone Avenue

This home is within Chawanakee Unified School District.
Rating
School
Type
Grades
Distance
Spring Valley Elementary School
Public - K to 8
Minarets High School
Public - 9 to 12
Hillside Elementary
Public - K to 8
Minarets Charter High
Charter - 9 to 12
Rating
School
Distance
Spring Valley Elementary School
PublicK to 8

Minarets High School
Public9 to 12

Hillside Elementary
PublicK to 8

Minarets Charter High
Charter9 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

Explore Nearby Homes

More information about 588 Overstone Avenue, Madera, CA 93636

588 Overstone Avenue is a single family home for sale in Madera, CA 93636. This property was listed for sale on February 17, 2026 by LPT Realty, Inc, it's currently listed at $598,000. It has been on the market for a total of 32 days and was last sold on June 15, 2023. This listing's school district is Chawanakee Unified School District. Nearby schools include Spring Valley Elementary School, Minarets High School and Hillside Elementary. 588 Overstone Avenue is a 5-bed, 3-bath, 2,611 sqft single family home built in 2023.

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of LPT Realty, Inc

Based on information from one of the following Multiple Listing Services: CRMLS, CLAW, I-Tech, ROWMLS, GPSMLS, SDMLS, VCRDS/PFAR, Idyllwild Association of Realtors, Ojai Valley Board of REALTORS and/or AVMLS. Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by CRMLS, CLAW, I-Tech, ROWMLS, GPSMLS, SDMLS, VCRDS/PFAR, Idyllwild Association of Realtors, Ojai Valley Board of REALTORS and/or AVMLS is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.