874 Overstone Ave
Madera, CA 93636
- 3 Beds
- 4 Baths
- 3,072 sqft
3 Beds
4 Baths
3,072 sqft
Local Information
-- mins to
Description
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.
Home Highlights
Parking
3 Car Garage
Outdoor
Pool
A/C
Heating & Cooling
HOA
$190/Monthly
Price/Sqft
$252
Listed
1 day ago
Home Details for 874 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: 3Number of Bathrooms: 4 |
Dimensions and Layout Living Area: 3072 Square Feet |
Appliances & Utilities Utilities: Public UtilitiesAppliances: Built In Range/Oven, Gas Appliances, Dishwasher, Microwave, RefrigeratorDishwasherLaundry: Inside,Utility RoomMicrowaveRefrigerator |
Heating & Cooling Heating: Has Heating Unspecified TypeHas CoolingAir Conditioning: Central AirHas HeatingHeating Fuel: Has Heating Unspecified Type |
Fireplace & Spa Number of Fireplaces: 1Fireplace: GasSpa: CommunityHas a FireplaceHas a Spa |
Gas & Electric Electric: On, Photovoltaics Third-Party Owned |
Windows, Doors, Floors & Walls Window: Double Pane Windows, Skylight(s)Flooring: Carpet, Tile |
Levels, Entrance, & Accessibility Stories: 2Levels: TwoFloors: Carpet, Tile |
Security Security: Security System |
|
|---|
Exterior Home Features Roof: TilePatio / Porch: Covered, ConcreteFencing: FencedFoundation: ConcreteHas a Private Pool |
Parking & Garage Number of Garage Spaces: 3Number of Covered Spaces: 3GarageHas an Attached GarageParking Spaces: 3Parking: Garage Attached |
Pool Pool: Fenced, Community, In GroundPool |
Frontage Not on Waterfront |
Water & Sewer Sewer: Public Sewer |
|
|---|
Days on Market: 1 |
|
|---|
Year Built Year Built: 2019 |
Property Type / Style Property Type: ResidentialProperty Subtype: Residential, Single Family Residence |
Building Construction Materials: Stucco, Wood Siding, Stone |
Property Information Parcel Number: 081270022000 |
|
|---|
Price List Price: $775,000Price Per Sqft: $252 |
|
|---|
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: 652075 |
|
|---|
Building Area Building Area: 3072 Square Feet |
|
|---|
Not Senior Community |
|
|---|
Association for this Listing: Fresno MLSHas an HOAHOA Fee: $190/Monthly |
|
|---|
Lot Area: 6098.4 sqft |
|
|---|
Disclaimer: Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended. |
|
|---|
Listing Agreement Type: Exclusive Right To Sell |
|
|---|
Mls Number: 652075 |
|
|---|
HOA Amenities: Pool,Spa/Hot Tub,Clubhouse,Fitness Center,Green Area,Playground,Maintenance Grounds,Other/None |
Last check for updates: about 5 hours ago
Listing courtesy of Danny Grubb DRE #01883554, (559) 970-0338
Real Broker
Originating MLS: Fresno MLS
Source: Fresno MLS, MLS#652075
Also Listed on Fresno MLS.
Market trends in Madera
Last updated June 2026
Avg. sale price
$429K
$18.33KMoM
Sale-to-List Price
100.0%
Price per sq ft
$255
$6MoM
Available listings
295
7MoM
Price History for 874 Overstone Ave
| Date | Price | Event | Source |
|---|---|---|---|
| 07/16/2026 | $775,000 | Listed For Sale | Fresno MLS #652075 |
| 11/26/2019 | $581,000 | Sold | N/A |
Similar Homes You May Like
New Listings near 874 Overstone Ave
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | $8,892 |
| Assessment | $635,294 |
Home facts updated by county records
Comparable Sales for 874 Overstone Ave
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.26 | Single-Family Home | $580,000 | 02/27/26 | 4 | 3 | 2,600 | |
0.23 | Single-Family Home | $795,000 | 08/19/25 | 4 | 4 | 3,495 | |
0.18 | Single-Family Home | $560,000 | 07/02/26 | 5 | 3 | 2,611 | |
0.07 | Single-Family Home | $470,000 | 08/07/25 | 3 | 3 | 2,052 | |
0.23 | Single-Family Home | $540,000 | 10/07/25 | 5 | 3 | 2,597 | |
0.05 | Single-Family Home | $489,000 | 07/25/25 | 3 | 2 | 2,052 | |
0.37 | Single-Family Home | $650,000 | 08/05/25 | 4 | 3 | 2,658 | |
0.38 | Single-Family Home | $620,000 | 10/10/25 | 3 | 3 | 2,121 | |
0.42 | Single-Family Home | $773,000 | 08/08/25 | 4 | 4 | 3,072 | |
0.40 | Single-Family Home | $800,000 | 05/21/26 | 3 | 4 | 3,285 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.Assigned Schools
These are the assigned schools for 874 Overstone Ave.
What Locals Say about Madera
At least 391 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
68 % 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
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Danny Grubb, Real Broker
Agent Phone: (559) 970-0338
874 Overstone Ave, Madera, CA 93636 is a 3 bedroom, 4 bathroom, 3,072 sqft single-family home built in 2019. This property is currently available for sale and was listed by Fresno MLS on Jul 16, 2026. The MLS # for this home is MLS# 652075.

