FBpixel

Get More Info

Print A Flyer

Get A Home Loan

Share

588 Overstone Ave

Madera, CA 93636

Copy Link Get Directions

$598,000

5 bd
  |  
3 ba
  |  
2,611 sq ft
  |  
0.12 acre

588 Overstone Ave

Madera, CA 93636

Get Directions
Listed On: 02/27/2026
Status: Active
Listing Number: 644463 (Fresno MLS)

Schedule a Tour

Contact Info


Presented By:

London Properties, Ltd.
London Properties, Ltd. 559.661.6100 Email Agent
Property Description
OPEN HOUSE: Sat + Sun 1-4pm 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 master-planned communities
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2023
Region
Urban
# of Stories
Two
Price Per Square Foot
$229
Price Per Acre
$4,983,333
Days On London
0
Cumulative Days On London
0
County
Madera
Special Features
Isolated Bedroom
REO / Bank Owned
No
Cross Street Address
Overstone / Orchard Hills
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.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower
Extra Rooms
Loft
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Fireplace Type
Zero Clearance
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
Community Spa
Patio Features
Covered
Yard
Fenced, Mature Landscape
Gas & Electric
Public Utilities
Sewer / Water
Public Water, Public Sewer
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Owned
Garage Type
Attached
Garage Spaces
2
APN
081 200 031 000
Association / Park Amenities
Pool, Spa, Club House, Exercise Room, Green Area, Tennis, Lake/Pond, Playground, Landscape Maint
HOA Dues
207.00
Frequency
Monthly
School District
Chawanakee
School Type 1
High School
School Name 1
Minarets
School Type 2
Junior High School
School Name 2
Hillside
School Type 3
Grade School
School Name 3
Hillside

Courtesy of Robert Mitchell, LPT Realty, Inc - [email protected]
Last modified 1 hour ago
Fresno MLS last checked for updates 2 minutes ago

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Copyright © 2026  London Properties, Ltd. All rights reserved.