Sold on Jul 2, 2026 for $560,000

588 Overstone Ave, Madera, CA 93636

Get pre-approved

5 bd · 3.0 ba · 2,611 sqft · $218/sqft · 0.12 acres

Residential · Single Family Residence · Built 2023

Description

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!

Agent & source

Listed by
Robert Mitchell
Brokerage
LPT Realty, Inc
DRE
#01338677
Bought with
Ivette Chavez
Phone
559-250-3442
MLS # FR26058360 Source CRMLS

Property details

Rooms & Layout

Levels
Two
Bedrooms
5
Bathrooms
3.0 (2 full, 1 half)
Kitchen
Kitchen Island, Walk-In Pantry
Bathroom Features
  • Shower in Tub
  • Double sinks in bath(s)
  • Double Sinks in Primary Bath
  • Shower
Laundry
Inside

Property Features

View
Neighborhood
Lot features
  • Landscaped
  • Front Yard
  • Back Yard
  • Lawn
Pool
In Ground, Community
Community
  • Biking
  • Foothills
  • Sidewalks
  • Park
Spa
Community

HOA

This home has an HOA.

Building & Construction

Construction Materials
Stucco
Roof
Tile
Foundation
Slab

Exterior & Parking

Parking
2-car garage, Garage, Driveway, Garage Door Opener
Patio & Porch
Covered, Front Porch, Concrete
Fencing
Wood
Common Walls
No Common Walls

Interior & Comfort

Heating
Central
Cooling
Central Air
Flooring
Vinyl
Fireplace
Zero Clearance, Family Room
Interior Features
Ceiling Fan(s), Pantry
Windows
Shutters
Doors
Sliding Doors

Appliances & Equipment

  • Microwave
  • Gas Range
  • Gas Oven
  • Dishwasher

Utilities

Water Source
Public
Sewer
Public Sewer

Nearby

Active Pending Closed Rental
Elementary
Hillside
Middle
Hillside
High
Minarets

List for Free.
Sell for More.

Award winning service with personal support

  • Personal agent
  • Local MLS listing
  • Award winning service

The multiple listing data appearing on this website, or contained in reports produced therefrom, is owned and copyrighted by California Regional Multiple Listing Service, Inc. ("CRMLS") and is protected by all applicable copyright laws. Information provided is for viewer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties the viewer may be interested in purchasing.

All listing data, including but not limited to square footage and lot size is believed to be accurate, but the listing Agent, listing Broker and CRMLS and its affiliates do not warrant or guarantee such accuracy. The viewer should independently verify the listed data prior to making any decisions based on such information by personal inspection and/or contacting a real estate professional.

Based on information from California Regional Multiple Listing Service, Inc. as of 2026-10-17 13:44:45 PST. The listing broker's offer of compensation is made only to participants of the MLS where the listing is filed.

List With Properkey