Located in the prestigious gated community known as Sumner Hill, (only minutes from River Park) this fabulous, 4br, 3ba home on 2.49 ac, has been exceptionally maintained. Peaceful views from almost every window and the breathtaking San Joaquin River just minutes away via the private Sumner Hill river access gate. Expansive covered patios. Enter this grand estate via the motor court at the end of the long, tree lined driveway. This magnificent, custom built, estate boasts formal dining, a great room with soaring ceilings marble floors; the remodeled kitchen has granite counters, all new custom cabinetry stainless steel appliances; four bedrooms and three baths on main floor. Upstairs you'll find the large spacious flex room (could be home fitness, nursery, home office, game room). This luxury estate features 3280 sq ft of living space. This home is all about the peaceful, serene setting plus it comes with the bonus of miles and miles of walking and biking trails nearby. Walk to the river from your home for fishing, a family picnic, kayaking, canoeing or simply enjoy the fantastic views and surrounding nature. You won't find another home quite like this. Large three car garage, plus enough driveway parking for 20 cars or more! Your dream home awaits!
Single-familyProperty Type
2006Year Built
2.49 acresLot Size
$381Est. Price/Sq.Ft.
3 car garageParking
Listed by Ana Sherwood•DRE #DRE #01894032• Realty Concepts, Ltd. - Fresno
Bought with Sarah Hedrick•DRE #DRE #01371742• Realty Concepts, Ltd. - Fresno
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
3
Baths
3.5
Stories
2
Lot width
—
Lot depth
—
Lot size
2.49 Acres
Year renovated
2006
Sq. Ft.
3,280
Year built
2006
Style
Single Family Residential
County
Madera County
APN
051702010000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 10, 2026.
RRS
Residential, Rural, Single Family District
The purpose of the RRS zones is to provide for single dwelling units on large lots with some accessory agricultural uses. It is intended that this zone be applied to areas that are rural in character, where the retention of low density residential development is desired. Each of the RRS zones is intended to establish development criteria.
Cooling: 13+ SEER A/C, Central Heat & Cool, Central Air
Interior Features
Interior Features: Isolated Bedroom, Central Vacuum, Great Room, Family Room, Game Room
Appliances: Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave
Flooring: Laminate, Other
Window Features: Double Pane Windows
Laundry Features: Inside, Utility Room
Fireplace Information
Has Fireplace
Fireplaces Total: 2
Fireplace Features: Gas
Exterior
Exterior Features
Levels: Two
Roof: Tile
Construction Materials: Stucco
Foundation Details: Wood Subfloor
Patio And Porch Features: Covered, Concrete
Pool Information
Spa Features: Bath
Living Area
Living Area Source: Public Records
Lot Information
Lot Features: Urban, Cul-De-Sac, Pasture, Sprinklers In Front, Sprinklers In Rear, Sprinklers Auto, Mature Landscape
Property Information
Property Sub Type: Single Family Residence
Location
Unit Information
Common Walls: No One Below
HOA Information
Has Association
Association Amenities: Gated
Association Fee: $1,700
Association Fee Frequency: Annually
School Information
Elementary School: Webster
Middle Or Junior School: Ranchos
High School: Liberty
High School District: Golden Valley
Location Information
Directions: Head north on Hwy 41 from Ave 12, east on Town Center Blvd, right on Rio Mesa, left on Enchanted Hill, right on Creekside, right on Killarney through private gate, 1.5 miles to Rose of Trallee, house is at the end of the cul de sac on the left
County Or Parish: Madera
Utility Information
Sewer: Septic Tank
Utilities: Public Utilities, Propane, High Tech Cable
Public facts
Beds: 3
Baths: 3.5
Sq. Ft.: 3,280
Stories: 2.0
Lot Size: 2.49 acres
Style: Single Family Residential
Year Built: 2006
Year Renovated: 2006
County: Madera County
APN: 051702010000
Home facts updated by county records on Jul 10, 2026
Around this home
Schools
Webster Elementary School
Public K-6 • Assigned • 7.6mi
8/10
Ranchos Middle School
Public 7-8 • Assigned • 8.5mi
7/10
Liberty High School
Public 9-12 • Assigned • 8.3mi
7/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
8/10 Fire Factor
38% chance of being in a wildfire in next 30 years
8/10 Heat Factor
7 days above 108° expected this year, 17 days in 30 years
1/10 Wind Factor
Minimal risk of severe winds over next 30 years
10/10 Air Factor
53 unhealthy days expected this year, 57 days in 30 years
Provided by First Street
Historical weather
Madera, CA • 93636
Average low and high temperatures (°F)
60
39
65
43
72
47
74
48
85
54
94
60
96
60
98
63
93
61
81
52
64
46
56
44
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 13.5 hours in
June and 4.2 hours in December, placing it above the
U.S. average for solar exposure.
13.5 hrs
4.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$1.19M – $1.44M
Reach more buyers when you sell with Redfin. Save up to $12,493 in fees.3 minutes to get started.