Here's a rare opportunity to purchase this great family home in an excellent neighborhood. This home boasts 4 bedrooms, 2 bathrooms and is truly move in ready. Upon entry you have a welcoming great room boasting soaring ceilings, stone fireplace and plenty of windows. The well appointed kitchen showcases granite counters, SS appliances, plenty of cabinetry and a pantry. Off the kitchen there's a dining area, perfect for entertaining. Out back you have a nice covered patio, outdoor BBQ bar, perfect for friends and family to gather. There's a nice grass area which completes the backyard. All of this and a large 3 car garage with a drive through bay leading into the backyard. Conveniently located by award winning Buchan Educational Complex, shopping and plenty of restaurants. Make your appointment today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$283
Price Per Acre
$3,231,818
Days On London
4
Cumulative Days On London
4
County
Fresno
REO / Bank Owned
No
Cross Street Address
Clovis
Directions
From Teague and Clovis make a left on Teague, left on Dewitt, right on Warwick, right on Perry to Moody, property is on the left
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 671895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2011 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2511 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` = 1687404 OR `props-main`.`id` = 1710135 OR `props-main`.`id` = 1704516 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1694317 OR `props-main`.`id` = 1697265 OR `props-main`.`id` = 1706636 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1702842 OR `props-main`.`id` = 1702857 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1710071 OR `props-main`.`id` = 1709945 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 1706699 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704908 OR `props-main`.`id` = 1701984 OR `props-main`.`id` = 1702905 OR `props-main`.`id` = 1703308 OR `props-main`.`id` = 1694367 OR `props-main`.`id` = 1710201 OR `props-main`.`id` = 1701109 OR `props-main`.`id` = 1710075 OR `props-main`.`id` = 1708179 OR `props-main`.`id` = 1708180 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1705438 OR `props-main`.`id` = 1706785 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1708283 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1704483 OR `props-main`.`id` = 1711173 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1706078 OR `props-main`.`id` = 1704909 OR `props-main`.`id` = 1705575 OR `props-main`.`id` = 1711225 OR `props-main`.`id` = 1701537 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1708302 OR `props-main`.`id` = 1708303 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1711092 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1708304 OR `props-main`.`id` = 1702212 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` = 1703671 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1696246 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1706921 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1709291 OR `props-main`.`id` = 1708322 OR `props-main`.`id` = 1709697 OR `props-main`.`id` = 1698439 OR `props-main`.`id` = 1705158 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160 OR `props-main`.`id` = 1695575 OR `props-main`.`id` = 1701895 OR `props-main`.`id` = 1701896 OR `props-main`.`id` = 1709645 OR `props-main`.`id` = 1709662 OR `props-main`.`id` = 1701884 OR `props-main`.`id` = 1709663 OR `props-main`.`id` = 1709664 OR `props-main`.`id` = 1701892 OR `props-main`.`id` = 1709644 OR `props-main`.`id` = 1705219 OR `props-main`.`id` = 1709643 OR `props-main`.`id` = 1709665 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1709661 OR `props-main`.`id` = 1709648 OR `props-main`.`id` = 1709649 OR `props-main`.`id` = 1701882 OR `props-main`.`id` = 1709660 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1709646 OR `props-main`.`id` = 1709642 OR `props-main`.`id` = 1702838 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1701894 OR `props-main`.`id` = 1709647 OR `props-main`.`id` = 1701881 OR `props-main`.`id` = 1701880 OR `props-main`.`id` = 1706045 OR `props-main`.`id` = 1703921 OR `props-main`.`id` = 1708512 OR `props-main`.`id` = 1709953 OR `props-main`.`id` = 1685082 OR `props-main`.`id` = 1704217 OR `props-main`.`id` = 1677702 OR `props-main`.`id` = 1704440)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643812' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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();
5
Similar Properties
$664,900
5
2.75
2,418
0.22
2991 E Cromwell Ave
Fresno, CA 93720
$639,000
4
2
2,191
0.17
2319 Prescott Ave
Clovis, CA 93619
$620,050
4
3
2,162
0.14
2466 N Harken Way
Clovis, CA 93619
$617,380
4
3
2,162
0.14
872 Eclipse Ln
Clovis, CA 93619
Courtesy of Robin Sparks, Better Homes & Garden Real Estate GoldLeaf - [email protected] Last modified 6 days ago Fresno MLS last checked for updates 11 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.
