Experience exceptional luxury on Reno Avenue!!This outstanding custom estate, built by Cornerstone Homes, is situated on 2.3 private, fully fenced acres. Built in 2017 and beautifully updated in 2025, this 4,504-square-foot residence offers 5 Bedrooms (all ensuite), a Game Room, Theater room, Study and Formal Bath.This thoughtfully designed floor plan is ideal for both everyday living and entertaining. Designed by MJR Home, the residence showcases quality craftsmanship and attention to detail throughout. The resort-inspired backyard evokes the charm of a Napa Valley venue, featuring mature landscaping, stone trimmed pool and spa, and multiple entertaining areas.Sweeping views from the front yard showcase the Sierra foothills to the north.Additional features include 22 kw owned solar, a 4-car garage, a gated entry, an orchard with more than 30 fruit trees and ample room to add a shop or additional improvements.Side Access to the East with extra drive gate is part of the property.This is a rare opportunity to own an updated custom Home on Reno Avenue.*The owner is formerly of Cornerstone Homes.virtual tourhttps://my.matterport.com/show/?m=xJSyJPshNUY&mls=1
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2017
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$733
Price Per Acre
$1,428,571
Days On London
21
Cumulative Days On London
28
County
Fresno
Leased Equipment
Propane
Special Features
Isolated Bedroom, Security System, Security Gate, Water Softener
REO / Bank Owned
No
Cross Street Address
Reno & Auberry Rd
Directions
Auberry Rd to Reno Ave
Style
Spanish, Mediterranean
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Primary Bedroom Level
Main
# of Fireplaces
1
Exterior
Stucco
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
In Ground
Patio Features
Covered
Gas & Electric
Public Utilities, Propane
Sewer / Water
Septic Tank, Private Well
Water Level
156.00
Well Depth
280.00
Well HP
2.00
G.P.M.
25.00
Energy Efficiency
Dual Pane Windows, 13+ SEER A/C, Tankless Water Heater
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 3135000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 3465000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4254 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4754 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` = 1761023 OR `props-main`.`id` = 1764664 OR `props-main`.`id` = 1752225 OR `props-main`.`id` = 1753037 OR `props-main`.`id` = 1779952 OR `props-main`.`id` = 1713572 OR `props-main`.`id` = 1749676 OR `props-main`.`id` = 1726492 OR `props-main`.`id` = 1735331 OR `props-main`.`id` = 1779970 OR `props-main`.`id` = 1725048 OR `props-main`.`id` = 1765274 OR `props-main`.`id` = 1765315 OR `props-main`.`id` = 1750746 OR `props-main`.`id` = 1761518 OR `props-main`.`id` = 1765371 OR `props-main`.`id` = 1724531 OR `props-main`.`id` = 1747692 OR `props-main`.`id` = 1757547 OR `props-main`.`id` = 1736892 OR `props-main`.`id` = 1728553 OR `props-main`.`id` = 1733417 OR `props-main`.`id` = 1733470 OR `props-main`.`id` = 1779561 OR `props-main`.`id` = 1732392 OR `props-main`.`id` = 1747382 OR `props-main`.`id` = 1747383 OR `props-main`.`id` = 1747380 OR `props-main`.`id` = 1771015 OR `props-main`.`id` = 1665744 OR `props-main`.`id` = 1665747 OR `props-main`.`id` = 1732200 OR `props-main`.`id` = 1766896 OR `props-main`.`id` = 1693768 OR `props-main`.`id` = 1689764 OR `props-main`.`id` = 1771968 OR `props-main`.`id` = 1744307 OR `props-main`.`id` = 1744308 OR `props-main`.`id` = 1744309 OR `props-main`.`id` = 1721548)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654472' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-23' 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 2 weeks ago Fresno MLS last checked for updates 8 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.
