Welcome to your dream home in a charming, gated neighborhood near Clovis and Shepherd! This delightful 2-bedroom, 2 bath abode with dedicated office space offers the perfect blend of comfort and style. The community boast delightful picnic areas with state-of-the-art barbecues perfect for family gatherings and weekend cookouts. Step inside to discover a freshly renovated kitchen that will ignite your culinary creativity. Featuring modern appliances and elegant finishes, it seamlessly flows into a cozy living space with newly installed laminate flooring that enhances the home's charm and warmth. The primary bedroom suite features an en-suite bathroom for your convenience, while the second bedroom is perfect for guests plus a home office. Step outside to enjoy the serenity of your private low-maintenance and backyard, perfect for morning coffee or evening relaxation. Scenic walking trails are nearby, outdoor enthusiasts will love the accessibility to nature. Don't miss out on this incredible opportunity to make this beautiful home your own! Schedule a showing today!
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
PUD
Year Built
2007
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$355
Price Per Acre
$5,347,938
Days On Market
0
Cumulative Days On Market
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Clovis / Shephard
Directions
Take 168 to Herndon. Go East. Left on Clovis Avenue. Right on Prescott. Left on Tureaud, continue to Larue and turn right. Left on Joliet. Right on Beauregard. Road curves and property will be on your right.
Special Disclosure
Agent/Owner Related
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Refrigerator
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 394250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 435750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 918 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1418 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` = 1694317 OR `props-main`.`id` = 1636126 OR `props-main`.`id` = 1702105 OR `props-main`.`id` = 1681156 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1698182 OR `props-main`.`id` = 1698178 OR `props-main`.`id` = 1696725 OR `props-main`.`id` = 1701373 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1685455 OR `props-main`.`id` = 1701557 OR `props-main`.`id` = 1701984 OR `props-main`.`id` = 1694367 OR `props-main`.`id` = 1701151 OR `props-main`.`id` = 1701596 OR `props-main`.`id` = 1701489 OR `props-main`.`id` = 1701915 OR `props-main`.`id` = 1701109 OR `props-main`.`id` = 1691387 OR `props-main`.`id` = 1691413 OR `props-main`.`id` = 1701346 OR `props-main`.`id` = 1695805 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1685947 OR `props-main`.`id` = 1698826 OR `props-main`.`id` = 1696570 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1702110 OR `props-main`.`id` = 1696276 OR `props-main`.`id` = 1695631 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1697704 OR `props-main`.`id` = 1701508 OR `props-main`.`id` = 1701459 OR `props-main`.`id` = 1701437 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1701433 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1701435 OR `props-main`.`id` = 1701535 OR `props-main`.`id` = 1701460 OR `props-main`.`id` = 1701461 OR `props-main`.`id` = 1701536 OR `props-main`.`id` = 1701539 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1701439 OR `props-main`.`id` = 1701440 OR `props-main`.`id` = 1701438 OR `props-main`.`id` = 1693614 OR `props-main`.`id` = 1685068 OR `props-main`.`id` = 1701534 OR `props-main`.`id` = 1697889 OR `props-main`.`id` = 1685980 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1695503 OR `props-main`.`id` = 1701631 OR `props-main`.`id` = 1701432 OR `props-main`.`id` = 1697082 OR `props-main`.`id` = 1701633 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1696246 OR `props-main`.`id` = 1697320 OR `props-main`.`id` = 1698912 OR `props-main`.`id` = 1679265 OR `props-main`.`id` = 1696286 OR `props-main`.`id` = 1698439 OR `props-main`.`id` = 1695575 OR `props-main`.`id` = 1701884 OR `props-main`.`id` = 1701883 OR `props-main`.`id` = 1701889 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1701874 OR `props-main`.`id` = 1701892 OR `props-main`.`id` = 1701882 OR `props-main`.`id` = 1701873 OR `props-main`.`id` = 1701901 OR `props-main`.`id` = 1701897 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1701891 OR `props-main`.`id` = 1701890 OR `props-main`.`id` = 1701896 OR `props-main`.`id` = 1701871 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1701894 OR `props-main`.`id` = 1701895 OR `props-main`.`id` = 1701881 OR `props-main`.`id` = 1701880 OR `props-main`.`id` = 1701875 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1702020 OR `props-main`.`id` = 1697347 OR `props-main`.`id` = 1699235 OR `props-main`.`id` = 1700153 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1677889)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641649' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-10' 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();
6
Similar Properties
$409,990
3
2.5
1,227
0.06
2029 N Wagon Ln
Clovis, CA 93619
$399,000
3
3
1,337
0.18
1418 chennault Ave
Clovis, CA 93611
$394,990
3
2.5
1,227
0.05
1525 Redbrick Ln
Clovis, CA 93619
$394,990
3
2.5
1,227
0.05
1532 Redbrick Ln
Clovis, CA 93619
Courtesy of Anna Verburg, Universal Lending & Realty Inc. - [email protected] Last modified 2 days ago Fresno MLS last checked for updates 36 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.
