588 Overstone Avenue, Madera, CA 93636

$560,000
5
BD
3
BA
2,611
SqFt

Show Photos

Verify your account to unlock exclusive photos, mortgage tools, and more.

Sold Price
$560,000
List Price
$568,000
Closing Date
Jul 02, 2026
Status
CLOSED
MLS#
FR26058360
Year Built
2023
Bedrooms
5
Bathrooms
3
Living Sq. Ft
2,611
Lot Size
5,227
Acres
0.12
Lot Location
Back Yard, Front Yard, Lawn, Landscaped
Days on Market
79
Property Type
Single Family Residential
Property Sub Type
Single Family Residence
Stories
Two Levels

Property 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!

Additional Information

HOA
207
Frequency
Monthly
Association Amenities
Clubhouse, Fitness Center, Maintenance Front Yard, Playground, Pool, Spa/Hot Tub, Tennis Court(s)
Appliances
Dishwasher, Gas Oven, Gas Range, Microwave
Pool Description
Community, In Ground, Association
Fireplace Description
Family Room, Zero Clearance
Heat
Central
Cooling
Yes
Cooling Description
Central Air
View
Neighborhood
Exterior Construction
Stucco
Patio
Concrete, Covered, Front Porch
Roof
Tile
Garage Spaces Total
2
Sewer
Public Sewer
Water
Public
School District
Chawanakee Unified
Interior Features
Breakfast Bar, Ceiling Fan(s), Pantry, Bedroom on Main Level
Attached Structure
Detached
Number Of Units Total
1

Listing courtesy of Listing Agent: Robert Mitchell (robert@robertmitchellgroup.com) from Listing Office: LPT Realty, Inc.

Listing sold by Ivette Chavez from NONMEMBER MRML

Mortgage Calculator

Amount of Loan
Annual Interest Rate
%
Term of Loan
Years

Does not include any taxes or fees.
Please consult a financial professional.
Calculator source: Real Geeks

Based on information from California Regional Multiple Listing Service, Inc. as of . This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.