588 Overstone Ave
Madera, CA 93636
- 5 Beds
- 3 Baths
- 2,611 sqft
5 Beds
3 Baths
2,611 sqft
Local Information
© Google
-- mins to
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!
Home Highlights
Parking
2 Car Garage
Outdoor
Pool
A/C
Heating & Cooling
HOA
$207/Monthly
Price/Sqft
$229
Listed
70 days ago
Home Details for 588 Overstone Ave
|
|---|
Interior Details Number of Rooms: 11Types of Rooms: Master Bedroom, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bathroom, Dining Room, Family Room, Kitchen, Living Room, Basement |
Beds & Baths Number of Bedrooms: 5Number of Bathrooms: 3 |
Dimensions and Layout Living Area: 2611 Square Feet |
Appliances & Utilities Utilities: Public UtilitiesAppliances: F/S Range/Oven, Dishwasher, MicrowaveDishwasherLaundry: Inside,Utility RoomMicrowave |
Heating & Cooling Heating: Has Heating Unspecified TypeHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Has Heating Unspecified Type |
Fireplace & Spa Number of Fireplaces: 1Fireplace: Zero ClearanceSpa: CommunityHas a FireplaceHas a Spa |
Gas & Electric Electric: On |
Windows, Doors, Floors & Walls Window: Double Pane WindowsFlooring: Carpet, Laminate, Tile |
Levels, Entrance, & Accessibility Stories: 2Levels: TwoFloors: Carpet, Laminate, Tile |
|
|---|
Exterior Home Features Roof: TilePatio / Porch: CoveredFencing: FencedFoundation: ConcreteHas a Private Pool |
Parking & Garage Number of Garage Spaces: 2Number of Covered Spaces: 2GarageHas an Attached GarageParking Spaces: 2Parking: Garage Attached |
Pool Pool: Community, In GroundPool |
Frontage Not on Waterfront |
Water & Sewer Sewer: Public Sewer |
|
|---|
Cumulative Days on Market: 70Days on Market: 70 |
|
|---|
Year Built Year Built: 2023 |
Property Type / Style Property Type: ResidentialProperty Subtype: Residential, Single Family Residence |
Building Construction Materials: Stucco |
Property Information Parcel Number: 081200031000 |
|
|---|
Price List Price: $598,000Price Per Sqft: $229 |
|
|---|
MLS Status: Active |
|
|---|
Direction & Address City: Madera |
School Information Elementary School: HillsideJr High / Middle School: HillsideHigh School: MinaretsHigh School District: Chawanakee |
|
|---|
Listing Agent Listing ID: 644463 |
|
|---|
Building Area Building Area: 2611 Square Feet |
|
|---|
Not Senior Community |
|
|---|
Association for this Listing: Fresno MLSHas an HOAHOA Fee: $207/Monthly |
|
|---|
Lot Area: 5227.2 sqft |
|
|---|
Disclaimer: Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended. |
|
|---|
Listing Agreement Type: Exclusive Right To Sell |
|
|---|
Mls Number: 644463 |
|
|---|
HOA Amenities: Pool,Spa/Hot Tub,Clubhouse,Fitness Center,Green Area,Tennis Court(s),Lake/Pond,Playground,Maintenance Grounds |
Last check for updates: about 1 hour ago
Listing courtesy of Robert Aaron Mitchell DRE #01338677, (559) 250-3442
LPT Realty, Inc
Originating MLS: Fresno MLS
Source: Fresno MLS, MLS#644463
Price History for 588 Overstone Ave
| Date | Price | Event | Source |
|---|---|---|---|
| 02/27/2026 | $598,000 | Listed For Sale | Fresno MLS #644463 |
| 01/20/2024 | ListingRemoved | Fresno MLS #593899 | |
| 06/21/2023 | $559,000 | Sold | N/A |
| 05/07/2023 | $573,195 | Pending | Fresno MLS #593899 |
| 05/03/2023 | $573,195 | Listed For Sale | Fresno MLS #593899 |
| 02/01/2023 | ListingRemoved | Fresno MLS #585086 | |
| 01/11/2023 | $543,960 | Listed For Sale | Fresno MLS #589268 |
| 01/02/2023 | $524,500 | ListingRemoved | Fresno MLS #585086 |
| 11/06/2022 | $524,500 | PriceChange | Fresno MLS #585086 |
| 10/17/2022 | $534,500 | PriceChange | Fresno MLS #585086 |
| 09/21/2022 | $544,500 | Listed For Sale | Fresno MLS #585086 |
Similar Homes You May Like
New Listings near 588 Overstone Ave
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $8,176 |
| Assessment | $591,420 |
Home facts updated by county records
Comparable Sales for 588 Overstone Ave
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.04 | Single-Family Home | $540,000 | 10/07/25 | 5 | 3 | 2,597 | |
0.05 | Single-Family Home | $535,000 | 07/08/25 | 4 | 2 | 2,101 | |
0.03 | Single-Family Home | $535,000 | 05/09/25 | 3 | 2 | 2,014 | |
0.09 | Single-Family Home | $448,829 | 06/13/25 | 3 | 3 | 1,780 | |
0.16 | Single-Family Home | $500,079 | 05/14/25 | 4 | 2 | 2,101 | |
0.32 | Single-Family Home | $650,000 | 08/05/25 | 4 | 3 | 2,658 | |
0.39 | Single-Family Home | $580,000 | 02/27/26 | 4 | 3 | 2,600 | |
0.14 | Single-Family Home | $475,000 | 02/23/26 | 3 | 3 | 1,871 | |
0.17 | Single-Family Home | $470,000 | 08/07/25 | 3 | 3 | 2,052 | |
0.30 | Single-Family Home | $530,000 | 05/01/26 | 4 | 2 | 2,126 |
Assigned Schools
These are the assigned schools for 588 Overstone Ave.
What Locals Say about Madera
At least 389 Trulia users voted on each feature.
86 % Say yards are well-kept
80 % Say car is needed
79 % Say parking is easy
72 % Say there's holiday spirit
71 % Say it's dog friendly
69 % Say there are sidewalks
67 % Say kids play outside
60 % Say it's quiet
60 % Say they plan to stay for at least 5 years
54 % Say people would walk alone at night
52 % Say streets are well-lit
49 % Say neighbors are friendly
49 % Say it's walkable to grocery stores
39 % Say it's walkable to restaurants
29 % Say there's wildlife
25 % Say there are community events
Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Robert Aaron Mitchell, LPT Realty, Inc
Agent Phone: (559) 250-3442
588 Overstone Ave, Madera, CA 93636 is a 5 bedroom, 3 bathroom, 2,611 sqft single-family home built in 2023. This property is currently available for sale and was listed by Fresno MLS on Feb 27, 2026. The MLS # for this home is MLS# 644463.

