Courtesy of Irma Soltero-Sparks, Century 21 Select Real Estate - [email protected]
Enjoy Auberry living in this modern open floorplan home. Minutes from Ride and Share stop at Auberry Road. Featuring three bedrooms, 1.75 bath, kitchen features; free standing stove, refrigerator, built in microwave, granite countertops, backsplash and a center island with seating. Plenty of natural light filters through all the windows that are adorned with plantation shutters. The living room has a wood burning stove and a door that leads out to a covered patio and the outdoors. The primary bedroom is downstairs and the bathroom is also where the convenient laundry room is located. The other two bedrooms are also located downstairs, with a full bath in the hall way. The loft upstairs can be used as a fourth bedroom as it does have plenty of closet space. The unique feature of the loft is the balcony with an incredible view. There is plenty of shade to enjoy outdoor living on this 6.49 acre property. The property has two sheds, three containers, covered patio, covered workshop and covered parking area. The The water well is also enclosed in a separate shed. Home was built in 2000 and has been very well kept by the original owners.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2000
Region
Foothill
# of Stories
Two
Price Per Square Foot
$243
Price Per Acre
$74,730
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Water Softener, Water Filter
REO / Bank Owned
No
Cross Street Address
Auberry Road
Directions
Fwy 41 North to Friant Rd Turn East Copper Turn N/Auberry Turn right Auberry at ride and share to Gold Nugget Lane.
Unit Description
Second Floor
Style
Ranch
Heating & Cooling
Central Heating, Central Cooling
Laundry
Inside, In Closet, On Lower Level
Roofing
Metal
Foundation
Concrete
Detached Structures
Shop, Shed, Other/See Remarks
Kitchen
F/S Range/Oven, Disposal, Dishwasher, Microwave, Breakfast Bar, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 460750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 509250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1742 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2242 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` = 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` = 1744350 OR `props-main`.`id` = 1744824 OR `props-main`.`id` = 1727445 OR `props-main`.`id` = 1727457 OR `props-main`.`id` = 305534 OR `props-main`.`id` = 1739477 OR `props-main`.`id` = 1745420 OR `props-main`.`id` = 1732123 OR `props-main`.`id` = 1725255 OR `props-main`.`id` = 1726810 OR `props-main`.`id` = 1745806 OR `props-main`.`id` = 1742150 OR `props-main`.`id` = 1727540 OR `props-main`.`id` = 1727557 OR `props-main`.`id` = 1739011 OR `props-main`.`id` = 1728054 OR `props-main`.`id` = 1721653 OR `props-main`.`id` = 1744042 OR `props-main`.`id` = 1744028 OR `props-main`.`id` = 1745045 OR `props-main`.`id` = 1745035)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651351' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-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 3 hours ago Fresno MLS last checked for updates 1 hour 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.
