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!
For sale
$598,000
588 Overstone Ave, Madera, CA 93636
5beds
3baths
2,611sqft
Est.:
Residential, Single Family Residence
Built in 2023
5,227.2 Square Feet Lot
$595,200 Zestimate®
$229/sqft
$207/mo HOA
What's special
Citrus treesMature landscapingBeautifully upgraded spanish-style residenceLarge islandOpen-concept layoutSpacious secondary bedroomsCustom tile backsplash
- 42 days |
- 919 |
- 35 |
Zillow last checked: 7 hours ago
Listing updated: April 09, 2026 at 11:01am
Listed by:
Robert Aaron Mitchell DRE #01338677 559-250-3442,
LPT Realty, Inc
Source: Fresno MLS,MLS#: 644463Originating MLS: Fresno MLS
Tour with a local agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 3
Primary bedroom
- Area: 0
- Dimensions: 0 x 0
Bedroom 1
- Area: 0
- Dimensions: 0 x 0
Bedroom 2
- Area: 0
- Dimensions: 0 x 0
Bedroom 3
- Area: 0
- Dimensions: 0 x 0
Bedroom 4
- Area: 0
- Dimensions: 0 x 0
Bathroom
- Features: Tub/Shower, Shower
Dining room
- Area: 0
- Dimensions: 0 x 0
Family room
- Area: 0
- Dimensions: 0 x 0
Kitchen
- Features: Eat-in Kitchen, Breakfast Bar, Pantry
- Area: 0
- Dimensions: 0 x 0
Living room
- Area: 0
- Dimensions: 0 x 0
Basement
- Area: 0
Heating
- Has Heating (Unspecified Type)
Cooling
- Central Air
Appliances
- Included: F/S Range/Oven, Dishwasher, Microwave
- Laundry: Inside, Utility Room
Features
- Isolated Bedroom, Loft
- Flooring: Carpet, Laminate, Tile
- Windows: Double Pane Windows
- Number of fireplaces: 1
- Fireplace features: Zero Clearance
Interior area
- Total structure area: 2,611
- Total interior livable area: 2,611 sqft
Property
Parking
- Total spaces: 2
- Parking features: Garage - Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Patio & porch: Covered
- Has private pool: Yes
- Pool features: Community, In Ground
- Has spa: Yes
- Spa features: Community
- Fencing: Fenced
Lot
- Size: 5,227.2 Square Feet
- Features: Urban, Mature Landscape
Details
- Parcel number: 081200031000
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Residential, Single Family Residence
Materials
- Stucco
- Foundation: Concrete
- Roof: Tile
Condition
- Year built: 2023
Utilities & green energy
- Electric: On
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities
Green energy
- Energy generation: Solar
Community & HOA
HOA
- Has HOA: Yes
- Amenities included: Pool, Spa/Hot Tub, Clubhouse, Fitness Center, Green Area, Tennis Court(s), Lake/Pond, Playground, Maintenance Grounds
- HOA fee: $207 monthly
Location
- Region: Madera
Financial & listing details
- Price per square foot: $229/sqft
- Tax assessed value: $591,420
- Annual tax amount: $8,176
- Date on market: 2/27/2026
- Cumulative days on market: 43 days
- Listing agreement: Exclusive Right To Sell
Estimated market value
$595,200
$565,000 - $625,000
$3,179/mo
Price history
Price history
| Date | Event | Price |
|---|---|---|
| 2/27/2026 | Listed for sale | $598,000+7%$229/sqft |
Source: Fresno MLS #644463 Report a problem | ||
| 1/20/2024 | Listing removed | -- |
Source: Fresno MLS #593899 Report a problem | ||
| 6/21/2023 | Sold | $559,000-2.5%$214/sqft |
Source: Public Record Report a problem | ||
| 5/7/2023 | Pending sale | $573,195$220/sqft |
Source: Fresno MLS #593899 Report a problem | ||
| 5/3/2023 | Listed for sale | $573,195+5.4%$220/sqft |
Source: Fresno MLS #593899 Report a problem | ||
| 2/1/2023 | Listing removed | -- |
Source: Fresno MLS #585086 Report a problem | ||
| 1/11/2023 | Listed for sale | $543,960+3.7%$208/sqft |
Source: Fresno MLS #589268 Report a problem | ||
| 1/2/2023 | Listing removed | $524,500$201/sqft |
Source: Fresno MLS #585086 Report a problem | ||
| 11/6/2022 | Price change | $524,500-1.9%$201/sqft |
Source: Fresno MLS #585086 Report a problem | ||
| 10/17/2022 | Price change | $534,500-1.8%$205/sqft |
Source: Fresno MLS #585086 Report a problem | ||
| 9/21/2022 | Listed for sale | $544,500$209/sqft |
Source: Fresno MLS #585086 Report a problem | ||
Public tax history
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $8,176 +4.1% | $591,420 +3.8% |
| 2024 | $7,857 +161.4% | $569,824 +361.7% |
| 2023 | $3,006 +28.3% | $123,420 +2% |
| 2022 | $2,343 +73.4% | $121,000 +734.2% |
| 2021 | $1,351 +72.7% | $14,505 +1% |
| 2020 | $782 +1.3% | $14,357 +2% |
| 2019 | $773 +15.2% | $14,076 +2% |
| 2018 | $671 | $13,800 |
Find assessor info on the county website
Monthly payment
Est. payment
$3,684/mo
Principal & interest
$2919
Property taxes
$558
HOA Fees
$207
More affordability tools
Climate risks
Neighborhood: 93636
Nearby schools
GreatSchools rating
- 7/10Hillside ElementaryGrades: K-8Distance: 0.4 mi
- 6/10Minarets High SchoolGrades: 9-12Distance: 10.9 mi
- 7/10Minarets Charter HighGrades: 9-12Distance: 10.8 mi
Schools provided by the listing agent
- Elementary: Hillside
- Middle: Hillside
- High: Minarets
Source: Fresno MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
Local experts in 93636
- California
- Madera County
- Madera
- 93636
- 588 Overstone Ave





