Beautiful Wathan Mansionette located in Dry Creek Estates. Pristine home and neighborhood located in one of the most sought after neighborhoods in Clovis. This home was a previous model home with all the amenities you could ever ask for. These homes don't come up very often. Amazing open floor plan with the kitchen over looking the living room. This home offers a 3 bedroom 3 bath with a huge office that could be used as a bedroom. They have also added a room on the other side of the house that is used for a music room. The private bedroom and bathroom with the added music room would be a great place for an in law setup. There is also a private door that leads into the music room from the garage, Owned Solar, Custom security gates and front door. If you like to cook, this is a chef's dream kitchen with added custom cabinets. Also instant hot and purified water with a gas stove. Quartzsite counter tops. Window seat in the nook with storage. Ceiling fans through out the house.New flooring, bidet's in 2 bathrooms, and too much to mention, This home has it all.Outside Tuff Shed. This neighborhood is so peaceful and quiet. Relax in the back yard with no neighbors behind you. Added cement to the west side of the house leading to the Tuff Shed. Bring your pickiest buyers, you wont be disappointed.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2012
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$292
Price Per Acre
$3,284,763
Days On London
1
Cumulative Days On London
1
County
Fresno
Special Features
Isolated Bedroom, Security System, Security Gate
REO / Bank Owned
No
Cross Street Address
Temperance
Directions
Located East of Temperance and North of Nees
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
Primary Bedroom Level
Lower
Bath Features
Tub/Shower, Shower, Tub, Oval Tub
Extra Rooms
Office, Converted Garage
Flooring
Carpet, Laminate, Tile
# of Fireplaces
1
Exterior
Stucco, Stone
Pool
No
Pool
No
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 749550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 828450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2450 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2950 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` = 1704102 OR `props-main`.`id` = 1706150 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1713209 OR `props-main`.`id` = 1713219 OR `props-main`.`id` = 1715779 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1703999 OR `props-main`.`id` = 1713875 OR `props-main`.`id` = 1714983 OR `props-main`.`id` = 1683853 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1714009 OR `props-main`.`id` = 1706636 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1704367 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1709945 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 1716159 OR `props-main`.`id` = 1712495 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1713847 OR `props-main`.`id` = 1712763 OR `props-main`.`id` = 1704918 OR `props-main`.`id` = 1689212 OR `props-main`.`id` = 1713154 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1715990 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1707196 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1704072 OR `props-main`.`id` = 1705677 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1715709 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1710011 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 1708087 OR `props-main`.`id` = 1708281 OR `props-main`.`id` = 1703958 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1708303 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1708304 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708310 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1708300 OR `props-main`.`id` = 1708301 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1708308 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1715853 OR `props-main`.`id` = 1715851 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645332' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-14' 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 Dena Byers, Byers and Sellers Realty - denabyers70@gmail.com Last modified 11 hours ago Fresno MLS last checked for updates 28 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.
