London Properties Madera Real Estate

874 Overstone Ave

Madera, CA 93636

Copy Link Get Directions

Photo Gallery

$775,000

3 bd

3.5 ba

3,072 sq ft

0.14 acre

874 Overstone Ave

Madera, CA 93636

Get Directions

Listed On: 07/16/2026

Status: Active

Listing Number: 652075 (Fresno MLS)

Schedule a Tour

Contact Info

Presented By:

London Properties, Ltd. 559.661.6100 Email Agent

Property Description

Courtesy of Danny Grubb, Real Broker - [email protected]

Discover this stunning, newer 3 bedroom, 3.5 bathroom home offering an impressive 3,072 SqFt of elevated living space in the highly sought after Tesoro Viejo community. Situated on a 6,098 SqFt lot, this property is uniquely positioned with clear, unobstructed views thanks to no homes directly in front, a rare and desirable feature. Inside, enjoy true open concept living with easily maintainable tile plank flooring as you enter. A formal dining room sets the tone for elegant gatherings, while the modern kitchen features a gas stove, pantry, and stainless steel appliances. The living room feels grand and inviting with high ceilings, large windows, and a cozy gas fireplace, creating an elevated and airy atmosphere. The thoughtful floor plan includes all bedrooms downstairs, each spacious and comfortable. The primary suite is a private retreat, complete with a resort style bathroom designed for relaxation. Upstairs, a versatile loft with a bar offers the perfect space for entertainment, work, or leisure. Step outside to a backyard designed for year round enjoyment, featuring a covered patio, low maintenance landscaping, and plenty of room to unwind. Additional upgrades include leased solar, two AC units, and two tankless water heaters for efficiency and comfort. Located just a short walk from Hillside Elementary School and a nearby playground, this home is surrounded by the exceptional amenities Tesoro Viejo is known for including high speed Xfinity internet included in the HOA, the Ranch House, resort style pools and spas, beautiful parks, scenic trails, and weekly farmers markets. Experience the luxury, lifestyle, and community this home offers. Schedule your private showing today.

Property Type

Residential

Property Subtype 1

Single Family Residence

Year Built

2019

Region

Urban

# of Stories

Two

Price Per Square Foot

$252

Price Per Acre

$5,535,714

Days On London

Cumulative Days On London

County

Madera

Leased Equipment

Solar Panels

Special Features

Security System, Built In Cabinets, Skylight, Wet/Dry Bar

REO / Bank Owned

Cross Street Address

Highway 41 & Tesoro Viejo Blvd

Directions

Take 41 north, turn right on Tesoro Viejo Blvd, take 2nd exit in roundabout on Treasure Hills Dr, left on Terrace Rd, right on Overstone Ave, home will be on your right.

Heating & Cooling

Central Heat & Cool

Laundry

Inside, Utility Room

Roofing

Tile

Foundation

Concrete

Kitchen

Built In Range/Oven, Gas Appliances, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry, Refrigerator

Dining Room Features

Formal, Living Room/Area

Primary Bedroom Level

Main

Bath Features

Tub/Shower, Shower, Tub

Extra Rooms

Loft

Flooring

Carpet, Tile

# of Fireplaces

Fireplace Type

Gas Insert

Exterior

Stucco, Wood, Stone

Pool

Yes

Pool

Yes

Pool Type

In Ground

Spa

Yes

Spa Type

Community Spa

Patio Features

Covered, Concrete

Yard

Fenced, Mature Landscape, Drip System

Gas & Electric

Public Utilities

Sewer / Water

Public Water, Public Sewer

Energy Efficiency

Dual Pane Windows, Tankless Water Heater

Solar

Yes

Solar Type

Lease

Are there garage spaces?

Yes

Garage Type

Attached

Garage Spaces

APN

081 270 022 000

Association / Park Amenities

Pool, Spa, Club House, Exercise Room, Green Area, Playground, Landscape Maint, Other/None

HOA Dues

190.00

School District

Chawanakee

School Type 1

High School

School Name 1

Minarets

School Type 2

Junior High School

School Name 2

Hillside

School Type 3

Grade School

School Name 3

Hillside

A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 736250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 813750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2822 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3322 AND ((`props-main`.`PropertyType` = 'Residential' AND ( `props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR `props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR `props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR `props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR `props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR `props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR `props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1733503 OR `props-main`.`id` = 1736482 OR `props-main`.`id` = 1732247 OR `props-main`.`id` = 1733197 OR `props-main`.`id` = 1744686 OR `props-main`.`id` = 1744711 OR `props-main`.`id` = 1716815 OR `props-main`.`id` = 1691781 OR `props-main`.`id` = 1717685 OR `props-main`.`id` = 1702486 OR `props-main`.`id` = 1718634 OR `props-main`.`id` = 1718647 OR `props-main`.`id` = 1708360 OR `props-main`.`id` = 1750021 OR `props-main`.`id` = 1750010 OR `props-main`.`id` = 1729258 OR `props-main`.`id` = 1709724 OR `props-main`.`id` = 1738120 OR `props-main`.`id` = 1744674 OR `props-main`.`id` = 1746486 OR `props-main`.`id` = 1704064 OR `props-main`.`id` = 1721662 OR `props-main`.`id` = 1705808 OR `props-main`.`id` = 1747675 OR `props-main`.`id` = 1704028 OR `props-main`.`id` = 1720751 OR `props-main`.`id` = 1719598 OR `props-main`.`id` = 1744324 OR `props-main`.`id` = 1741633 OR `props-main`.`id` = 1711476 OR `props-main`.`id` = 1745337 OR `props-main`.`id` = 1722288 OR `props-main`.`id` = 1746080 OR `props-main`.`id` = 1727541 OR `props-main`.`id` = 1737523 OR `props-main`.`id` = 1734042 OR `props-main`.`id` = 1741269 OR `props-main`.`id` = 1725593 OR `props-main`.`id` = 1722221 OR `props-main`.`id` = 1738750 OR `props-main`.`id` = 1726279 OR `props-main`.`id` = 1723560 OR `props-main`.`id` = 1717629 OR `props-main`.`id` = 1717645 OR `props-main`.`id` = 1749113 OR `props-main`.`id` = 1746844 OR `props-main`.`id` = 1722102 OR `props-main`.`id` = 1731610 OR `props-main`.`id` = 1715813 OR `props-main`.`id` = 1725445 OR `props-main`.`id` = 1696092 OR `props-main`.`id` = 1750050 OR `props-main`.`id` = 1737137 OR `props-main`.`id` = 1737138 OR `props-main`.`id` = 1749063 OR `props-main`.`id` = 1696084)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652075' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-16' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();

Similar Properties

$799,000

3
3.5
2,886
0.26

1015 Horizon

Madera, CA 93636

$760,000

4
3.5
2,953
0.21

948 Beaver Pond

Madera, CA 93636

$759,990

3
3.5
2,886
0.18

4132 Blackfish Rd

Madera, CA 93636

$749,000

4
4
2,953
0.17

768 Overstone Ave

Madera, CA 93636

Last modified 1 hour ago
Fresno MLS last checked for updates 20 minutes ago

The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

874 Overstone Ave

Madera, CA 93636

Photo Gallery

$775,000

874 Overstone Ave

Madera, CA 93636

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$799,000

$760,000

$759,990

$749,000

Buying

Selling

Moving

Agents

Careers

Contact

About Us

559.436.4071

Get More Info

Print A Flyer

Get A Home Loan

Share

874 Overstone Ave

Madera, CA 93636

Photo Gallery

$775,000

874 Overstone Ave

Madera, CA 93636

Schedule a Tour

Contact Info

Presented By:

Similar Properties

$799,000

$760,000

$759,990

$749,000

Loading...

Saving...

Deleting...

Searching...