Courtesy of David Aaron, Real Brokerage Technologies - [email protected]
Nestled in Prime Time Madera Ranchos, this brand-new construction home offers the ultimate blend of modern luxury and country space. Located just 15 minutes from River Park Shopping Center and 10 minutes to Madera, and moments from the conveniences of Avenue 12 and Riverstone.It's a perfect 2,375 square feet with 4 bedrooms, 3 bathrooms, and a 3 car garage. The interior showcases high-end finishes, including premium quartz countertops and durable 12mm laminate wood flooring. Set on an expansive 1.32-acre lot, the property provides endless possibilities for a custom pool, backyard entertainment gazebo, workshop or anything your heart desires.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built Exception
New Construction
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$305
Price Per Acre
$549,242
Days On London
134
Cumulative Days On London
134
County
Madera
Leased Equipment
Propane
REO / Bank Owned
No
Cross Street Address
Ave 14 1/2 and Road 35 1/2
Directions
From Avenue 12, go north on Road 35 or Road 36 to Avenue 14 1/2, turn right from Road 35 or left from Road 36. From Avenue 15, go south on Road 35 or Road 35 1/2, turn left from Road 35 or Right from Road 35 1/2.
Special Disclosure
Agent/Owner Related
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Basement
None
Flooring
Other
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Patio Features
Covered
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Well Depth
540.00
Energy Efficiency
Dual Pane Windows
Solar
Yes
Solar Type
Owned
Parking Features
Auto Opener
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
3
Lot Dimensions
140 x 412
APN
035 320 047
Zoning
RRS - Residential, Rural, Single Family
Tract / Builder
Bonadelle Ranchos
School District
Golden Valley
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
Webster
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 688750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 761250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2125 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2625 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` = 1753877 OR `props-main`.`id` = 1781743 OR `props-main`.`id` = 1780532 OR `props-main`.`id` = 1779640 OR `props-main`.`id` = 1780027 OR `props-main`.`id` = 1780028 OR `props-main`.`id` = 1780498 OR `props-main`.`id` = 1780534 OR `props-main`.`id` = 1728972 OR `props-main`.`id` = 1713333 OR `props-main`.`id` = 1780645 OR `props-main`.`id` = 1782040 OR `props-main`.`id` = 1730086 OR `props-main`.`id` = 1755375 OR `props-main`.`id` = 1755501 OR `props-main`.`id` = 1778479 OR `props-main`.`id` = 1770862)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno648682' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-03' 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();
0
Last modified 4 days ago Fresno MLS last checked for updates 25 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.
