Skip to content
tade k realty logo black
Listings
Home > Listings > CA > Madera > 588 Overstone Avenue, Madera, CA 93636
active

588 Overstone Avenue, Madera, CA 93636

$598,000
$229 per ft²
5 Bed
3 Bath
2,611 Sq Ft
0.12 Acres
Listing Office: LPT Realty, Inc
Image 1 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 2 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 3 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 4 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 5 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 6 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 7 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 8 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 9 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 10 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 11 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 12 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 13 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 14 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 15 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 16 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 17 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 18 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 19 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 20 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 21 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 22 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 23 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 24 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 25 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 26 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 27 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 28 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 29 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 30 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 31 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 32 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 33 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 34 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 35 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 36 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 37 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 38 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 39 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 40 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 41 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 42 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 43 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 44 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 45 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 46 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 47 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 48 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 49 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 50 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 51 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 52 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 53 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 54 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 55 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 56 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 57 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 58 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
Image 59 of property listing at 588 Overstone Avenue, Madera, CA 93636California Regional MLS
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!

Listing Agent: Robert Mitchell

License Number: 01338677

Offered by: LPT Realty, Inc

Office Phone: 877-366-2213

MLS: #FR26058360

California Regional MLS

Date Added: 03/17/2026 12:00:00 am

Last Update: 03/18/2026 05:40:52 pm

Days on Market: 2

Interior

  • General: Breakfast Bar,Ceiling Fan(s),Pantry,Bedroom on Main Level
  • Appliances: Dishwasher,Gas Oven,Gas Range,Microwave
  • Laundry: Inside
  • Flooring: Vinyl
  • A/C: true, Central Air
  • Heating: true, Central
  • Fireplace: Family Room,Zero Clearance, Fireplace

Exterior

  • General: Community
  • Other Structures: Front Porch, Concrete, Covered
  • Pool: Community,In Ground,Association
  • Parking: Driveway,Garage,Garage Door Opener, Parking spaces: 2

Construction

  • Roofing: Tile
  • Windows: Shutters
  • General: Stucco, 2, Slab

Location

  • HOA Amenities: Clubhouse,Fitness Center,Maintenance Front Yard,Playground,Pool,Spa/Hot Tub,Tennis Court(s), 207.0, Monthly
  • Originating MLS: CRMLS_CRM
  • School District: Chawanakee Unified
  • County: Madera

Lot

  • Zoning: 081200031
  • View: Neighborhood, View
  • Fencing: Wood

Utilities

  • Water: Public
  • Sewer: Public Sewer

Financial

  • Source: CRMLS_CRM

Property

  • Year Built: 2023
  • Type: Single Family Home
  • Parcel #: 081200031

Schools

  • District: Chawanakee Unified

powered by

01/20/2024Off Market
05/07/2023Pending
05/07/2023Backup
05/03/2023Active
05/03/2023$573,195@ 220 per ft²Listed

Listing Broker

Tade Keshishyan
1 @
License #: 02190628
Email: [email protected]
Phone: 8183592303
Location: CA

Property For Sale

All Listings in Madera
Single Family Homes in Madera
Condos in Madera
Townhouses in Madera
Multi-Family in Madera

Homes in Madera by Price Range

Homes Under $100k in Madera
Homes Under $200k in Madera
Homes Under $300k in Madera
Homes Under $400k in Madera
Homes Under $500k in Madera
Homes Over $500k in Madera

Homes in Madera by Bedrooms

1 Bedroom Homes in Madera
2 Bedroom Homes in Madera
3 Bedroom Homes in Madera
4 Bedroom Homes in Madera
5 Bedroom Homes in Madera
5+ Bedroom Homes in Madera

Last Updated: 03/18/2026 05:40:52 pm

Offered by: Robert Mitchell, 01338677, 877-366-2213 @ LPT Realty, Inc

MLS: #FR26058360

Source: California Regional MLS

<IMG SRC='https://d37ukvrrv3in12.cloudfront.net/mls/logos/IDX_580_large.png' ALT='IDX'> Based on information from California Regional Multiple Listing Service, Inc. and /or other sources. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. The data contained herein is copyrighted by CRMLS and is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited.<BR><BR>The information being provided by California Regional Multiple Listing Service, Inc. (“CRMLS”) 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. Any information relating to a property referenced on this web site comes from CRMLS. Properties may or may not be listed by the office/agent presenting the information. Real estate listings held by brokerage firms other than this broker are marked with the Internet Data Exchange logo and detailed information about them includes the names of the listing brokers and listing agents. MLS search engine provided by <A HREF='http://www.realtywatchsolutions.com/' TARGET='_blank'>RealtyWatch Solutions</A>. This data is updated every 2 hours. Some properties appearing for sale on this display may subsequently have sold and may no longer be available. Data displayed may be a portion of, and not a complete set of all listings published in the MLS.

View Listing
Home > Listings > CA > Madera > 588 Overstone Avenue, Madera, CA 93636

588 Overstone Avenue, Madera, CA 93636 is a 5 Bed, 3 Bath, 2,611 Sq Ft, 0.12 Acres, Single Family Home built in 2023.

This property is currently available and was listed by California Regional MLS on 03/17/2026 12:00:00 am. The MLS # for the property is MLS #FR26058360.

Powered by CT IDX Pro+ & RealtyWatch Solutions.
  • Buyer Services
  • Seller Services
  • Property Management
  • Free Home Valuation
  • Free Consultation
  • Calculators
  • About Tade Keshishyan
  • Buyer Services
  • Seller Services
  • Property Management
  • Free Home Valuation
  • Free Consultation
  • Calculators
  • About Tade Keshishyan
  • Instagram
  • Facebook
  • LinkedIn
  • Contact
  • Instagram
  • Facebook
  • LinkedIn
  • Contact
Stay Ahead in Real Estate
This field is for validation purposes and should be left unchanged.

Tade Keshishyan

DRE #02190628

(818) 859-2303

silver spoon properties logo white
© 2026 Tade K Realty
Tade Keshishyan Real Estate
  • Buy a Home
    Close
    • Buyer Services
    • First-Time Homebuyer Guide
    • Mortgage Calculator
  • Sell Your Home
    Close
    • Seller Services
    • Guide to Selling Your Home
    • Free Home Valuation
    • Free Consultation
  • Property Management
  • Calculators
    Close
    • Mortgage Calculator
    • Home Affordability Calculator
    • FHA Loan Calculator
    • VA Mortgage Calculator
    • View All Calculators
  • About Tade Keshishyan
  • Contact