Courtesy of Billy Lovewell, eXp Realty of California, Inc. - [email protected]
This well-maintained 3-bed, 1.75-bath manufactured home sits on just over an acre of flat, usable land, offering a perfect blend of comfort and tranquility. Equipped with reasonable solar energy and all-electric appliances, this home is both eco-friendly and cost-effective.This home is surrounded by mature oak trees and fertile soil, you'll enjoy the beauty of nature right at your doorstep. The convenient bus stop and mailbox are located at the front of the property, while the home itself is set back from the road, creating a serene and private atmosphere.Step inside to discover an inviting open floor plan with vaulted ceilings that enhance the spacious feel. The cozy wood fireplace is perfect for gathering with loved ones, while ceiling fans and recessed lighting create an inviting ambiance throughout. The large primary bedroom serves as a true retreat, complete with a generous soaking tub and an expansive walk-in closet. With plenty of storage options, including a spacious 2-car garage, large mudroom and a small storage room off the kitchen, you'll have all the space you need to stay organized.Location is key, and this home is just minutes away from grocery store, church, gym, banking, pharmacy & hardware store. A short drive further up the road leads to forest access, casinos and multiple lakes, including beautiful Shaver Lake just 13 miles away, offering endless recreational opportunities. Plus, major shopping in Clovis/Fresno is only a scenic 45-minute drive away.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$197
Price Per Acre
$270,339
Days On London
0
Cumulative Days On London
569
County
Fresno
REO / Bank Owned
No
Cross Street Address
Frazier Road
Directions
HWY-180, right on Academy Ave, right on CA-168/Tollhouse Rd, right to stay on CA-168, take 1st exit at roundabout, left on Auberry, left on Frazier, left on Medford.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 303050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 334950 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) >= 1370 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1870 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` = 1727445 OR `props-main`.`id` = 1727457 OR `props-main`.`id` = 305534 OR `props-main`.`id` = 1739477 OR `props-main`.`id` = 1742150 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` = 1705377)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651188' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-29' 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();
1
Similar Properties
$325,000
4
2
1,432
2.30
31913 Auberry Road
Auberry, CA 93602
Last modified 3 hours ago Fresno MLS last checked for updates 51 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.
