Fully remodeled and move-in ready, this 4 bedroom, 3 bathroom home offers 2,719 sqft of living space on 2 acres with incredible views of the surrounding mountains and table tops. The property makes a strong first impression with a block wall entrance with two iron gated access points and a huge wrap-around driveway with an automatic gate. Inside, the home features a bright open floorplan with a massive great room that flows right into the kitchen. The kitchen has been completely updated with new soft-close cabinets, quartz countertops, subway tile backsplash, a large farm sink, upgraded stainless appliances, and plenty of storage. Everything has been updated throughout the home including new flooring, new windows, and a variety of custom touches like accent walls and floating vanities that give the home a clean, modern feel. The layout works well for a variety of living situations with two primary suites located upstairs and two guest bedrooms downstairs. Outside, the 2-acre lot gives you space and flexibility. The detached 2-car garage and large open areas make this property a great setup for a future shop, ADU, or additional improvements. Located just outside the city, you get the peace and privacy of country living while still being close to town. Call today to schedule a private showing.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1950
Region
Foothill
# of Stories
Two
Price Per Square Foot
$226
Price Per Acre
$307,475
Days On London
61
Cumulative Days On London
61
County
Fresno
REO / Bank Owned
No
Cross Street Address
Auberry Rd/ Quail Hollow
Directions
Starting at Copper & Auberry- travel north on Auberry, property will be south side of the street on the corner of Auberry and Quail Hollow. Use GPS for further directions.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Both
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Pantry
Primary Bedroom Level
Upper
Bath Features
Shower
Flooring
Carpet, Laminate
# of Fireplaces
1
Exterior
Wood
Pool
No
Pool
No
Spa
No
Patio Features
Covered
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Existing RV Parking, Auto Opener, Circular Driveway
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 584202.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 645697.5 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) >= 2469 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2969 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` = 1719165 OR `props-main`.`id` = 1718667 OR `props-main`.`id` = 1688544 OR `props-main`.`id` = 1703741 OR `props-main`.`id` = 1696683 OR `props-main`.`id` = 1696974 OR `props-main`.`id` = 1723684 OR `props-main`.`id` = 1696975 OR `props-main`.`id` = 1703358 OR `props-main`.`id` = 1713593 OR `props-main`.`id` = 1736633 OR `props-main`.`id` = 1689072 OR `props-main`.`id` = 1721410 OR `props-main`.`id` = 1723247 OR `props-main`.`id` = 1727445 OR `props-main`.`id` = 1727457 OR `props-main`.`id` = 305534)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644818' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-15' 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 6 days 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.
