Sign up to get new listings emailed daily! JOIN SIGN IN
Tamsin Enos, DRE#02152651, REALTOR®
(805) 234-1337
Refine Search

588 Overstone Avenue, Madera, CA 93636

$598,000
  • 588 Overstone Avenue, Madera, CA 93636 Main Photo

59 Total Photos [Click to View All]

Active
BEDS5 BATHS2 full 1 partial SQUARE FEET2,611 MLS#FR26058360
STATUSActive PROPERTY TYPEResidential - Single Family SCHOOLChawanakee Unified

Listing Courtesy of: LPT Realty, Inc
Agency Phone: 877-366-2213
Associate Name: Robert Mitchell
IDX logo


Listing Shown by: Farrell Smyth, Inc.
Associate Name: Tamsin Enos, DRE#02152651, REALTOR®


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

588 Overstone Avenue | MLS# FR26058360

This single family home located at 588 Overstone Avenue, Madera, CA 93636 is currently listed for sale with an asking price of $598,000. This property was built in 2023 and has 5 bedrooms and 2 full and 1 partial baths with 2611 sq. ft. Overstone Avenue is located within the Chawanakee Unified school district. Search Madera real estate on tamsinenos.farrellsmyth.com today.

Property Features

Property Type: Residential - Single Family
Cooling: Central Air
Garage: 2 car attached
Heating: Central
Lot Size: 0.12 Acres
Roof Type: Tile
Stories: 2.0
Year Built: 2023

Amenities

Breakfast Bar
Ceiling Fan(s)
Pantry
Bedroom on Main Level

Feature Descriptions

Appliances: Dishwasher, Gas Oven, Gas Range, Microwave
Association Amenities: Clubhouse, Fitness Center, Maintenance Front Yard, Playground, Pool, Spa/Hot Tub, Tennis Court(s)
Community Features: Biking, Foothills, Park, Sidewalks, Pool
Days on Site: 20
Door Features: Sliding Doors
Exterior: Stucco
Fencing: Wood
Fireplace: Family Room, Zero Clearance
Flooring: Vinyl
HOA Fee: 207/ Monthly
Laundry: Inside
Lot: Back Yard, Front Yard, Lawn, Landscaped
Parcel#: 081200031
Parking: Driveway, Garage, Garage Door Opener
Parking Notes: Driveway, Garage, Garage Door Opener
Patio/Porch: Concrete, Covered, Front Porch
Pool: Community, In Ground, Association
Sewer: Public Sewer
Spa: Yes
Spa: Community
Special View Info: Neighborhood
Swimming Pool: Yes
Units: 1
Water: Public
Window: Shutters

Local Schools

School District: Chawanakee Unified

Listed By / Shown By

Listed By

Agency Name: LPT Realty, Inc
Agency Phone: 877-366-2213
Agent Name: Robert Mitchell

agent picture

Shown By

Agent Name: Tamsin Enos, DRE#02152651, REALTOR®
Agent Phone: (805) 234-1337
Agency Title: Farrell Smyth, Inc.

IDX logo

Estimate Your Payment

Estimated Payment

$ 1,505.31 per month $1,330.89 Principal & Interest $0.00 Property Tax (data not provided by mls) $174.42 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)
Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 04/07/2026. The listing information on this page last changed on 04/07/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Tue 04/07/2026 12:26:43 AM EST) or CRMLS (last updated Tue 04/07/2026 12:14:51 AM EST). Real estate listings held by brokerage firms other than Farrell Smyth, Inc. may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.
Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel