Resort-Style Living Awaits You! This Amazing Wilson-Built Home has it All, including the finest curb appeal in Harlan Ranch. The formal living room & dining room welcome you the moment you enter. Luxurious master-suite offers every amenity including a bonus living area with built-in cabinets & display shelves. Welcoming balcony overlooking private backyard and an impressive ensuite bathroom recently updated with rock walls, backlit mirrors + large shower & soaking tub. Spacious kitchen with newer stainless gas appliances, quartz countertops and large island w/bar stools. Open family room w/fireplace and built-in display cabinets. Upstairs game room can easily accommodate pool table, exercise equipment and large furniture. Big windows overlook a Backyard Oasis featuring sparkling pool, waterfall, and sitting area. Amazing garage storage in the 4-car tandem garage with overhead shelving. Plantation shutters & automatic Hunter Douglas blinds throughout. Recent updates include luxury vinyl, plush carpeting, tankless water heaters & both HVAC units. Located in a quiet cul-de-sac, you'll love the peace, beauty and serenity the home offer. Conveniently close to Fwy 168 and just minutes away from everywhere you want to be. Award winning master-planned community & highly acclaimed Clovis Schools. Truly is a Must-See!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2008
Region
Urban
# of Stories
Two
Price Per Square Foot
$279
Price Per Acre
$5,082,943
Days On London
1
Cumulative Days On London
1
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Built In Cabinets, Water Softener, High Tech Cable
REO / Bank Owned
No
Cross Street Address
E. Shepherd
Directions
From Shepherd, travel S. on Leonard Ave. R on Everglade, take first R onto Nicolette and follow around to the left. Home is on the left hand side on corner of cul-de-sac.
Style
Mediterranean
Heating & Cooling
Central Heat & Cool, Central Heating
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1135250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1254750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4027 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4527 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` = 1689035 OR `props-main`.`id` = 1727387 OR `props-main`.`id` = 1728253 OR `props-main`.`id` = 1726451 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1727983 OR `props-main`.`id` = 1722430 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1722623 OR `props-main`.`id` = 1727962 OR `props-main`.`id` = 1722847 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1717197 OR `props-main`.`id` = 1717456 OR `props-main`.`id` = 1717420 OR `props-main`.`id` = 1717431 OR `props-main`.`id` = 1717440 OR `props-main`.`id` = 1715709 OR `props-main`.`id` = 1721608 OR `props-main`.`id` = 1724857 OR `props-main`.`id` = 1726814 OR `props-main`.`id` = 1724751 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1726680 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1721325 OR `props-main`.`id` = 1728171 OR `props-main`.`id` = 1724586 OR `props-main`.`id` = 1725116 OR `props-main`.`id` = 1720820 OR `props-main`.`id` = 1720797 OR `props-main`.`id` = 1720901 OR `props-main`.`id` = 1724652 OR `props-main`.`id` = 1727497 OR `props-main`.`id` = 1726715 OR `props-main`.`id` = 1721973 OR `props-main`.`id` = 1728251)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno649183' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-05-22' 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
Courtesy of Joel Mazmanian, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 8 hours ago Fresno MLS last checked for updates 53 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.
