Presenting a splendid 3 bedroom, 2 bathroom residence in Harlan Ranch in exquisite condition. Thoughtfully designed and lovingly maintained, this home's pleasing sight lines, warm and bright interior, and natural flow make for easy living in this vibrant lifestyle community. Built in 2010, this Clovis North area home was recently revamped with new exterior and interior paint, an updated kitchen (stainless double oven, gas stove, stainless appliances), plantation shutters, hardwood flooring, new carpet, new ceiling fans, and expanded concrete around the grounds. Laundry room has a sink, plenty of storage, and countertop space. The back patio area is perfect for barbecue parties with a built-in grill and fridge. Three car garage with shop area and storage racks. No neighbors to rear of property. Leased solar with zero trup-up =$145.00/mo energy bills.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2010
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$303
Price Per Acre
$2,677,949
Days On London
0
Cumulative Days On London
0
County
Fresno
Reports Available
Roof, Pest, Prelim Title Report
Special Features
Water Softener, Water Filter
REO / Bank Owned
No
Cross Street Address
Shepherd and Locan
Directions
From Shepherd turn right onto Leonard, then left onto Rector then left onto Trenton then left onto Langley , road curves home will be on the left.
Unit Description
Ground Floor
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed
Kitchen
F/S Range/Oven, Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar
Primary Bedroom Level
Lower
Bath Features
Tub/Shower, Shower
Flooring
Carpet, Laminate, Tile
Exterior
Stucco, Wood
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
No
Patio Features
Covered, Uncovered, Concrete
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 511100 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 564900 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1528 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2028 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` = 1740193 OR `props-main`.`id` = 1740181 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1744504 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1745339 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1739362 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1742689 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1735948 OR `props-main`.`id` = 1742850 OR `props-main`.`id` = 1721608 OR `props-main`.`id` = 1744141 OR `props-main`.`id` = 1743096 OR `props-main`.`id` = 1739639 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1731275 OR `props-main`.`id` = 1726680 OR `props-main`.`id` = 1721325 OR `props-main`.`id` = 1728171 OR `props-main`.`id` = 1739534 OR `props-main`.`id` = 1738449 OR `props-main`.`id` = 1724586 OR `props-main`.`id` = 1725116 OR `props-main`.`id` = 1729321 OR `props-main`.`id` = 1729341 OR `props-main`.`id` = 1745941 OR `props-main`.`id` = 1730588 OR `props-main`.`id` = 1744840 OR `props-main`.`id` = 1737095 OR `props-main`.`id` = 1732245 OR `props-main`.`id` = 1721973 OR `props-main`.`id` = 1736454 OR `props-main`.`id` = 1736478)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651360' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-04' 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 4 hours ago Fresno MLS last checked for updates 41 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.
