Welcome to your dream home in the heart of Clovisa stunning single-story residence featuring 2,310 sq. ft. of beautifully updated living space! With 3 spacious bedrooms, 2.5 bathrooms, two separate living rooms, lovely formal dining room, and a sunlit breakfast nook, this home is perfect for all who love to entertain and relax in style. The chef's kitchen features a Viking 6-burner stovetop, stainless steel appliances, and a walk-in pantryideal for culinary adventureswhile Brazilian cherry engineered hardwood floors add warmth and elegance throughout. Retreat to the isolated primary suite with its luxurious ensuite bath or step outside to your backyard oasis complete with a sparkling pool with water feature, pergola, and covered patio for year-round enjoyment. Located just steps from playgrounds, schools, shopping, restaurants, and freeway accessdon't miss your chance to own this impeccably maintained gem where pride of ownership truly shines!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1992
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$275
Price Per Acre
$2,881,125
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
S/Nees W/Fowler
Directions
From Nees and Fowler, travel South on Fowler, Right on Crowell, Right on Shirley, Left on Decatur. Home will be on the left.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 603250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 666750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2060 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2560 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` = 167463 OR `props-main`.`id` = 1694830 OR `props-main`.`id` = 189650 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1704102 OR `props-main`.`id` = 1701254 OR `props-main`.`id` = 1692098 OR `props-main`.`id` = 1692107 OR `props-main`.`id` = 1706150 OR `props-main`.`id` = 1709666 OR `props-main`.`id` = 104849 OR `props-main`.`id` = 1704416 OR `props-main`.`id` = 1681580 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1693905 OR `props-main`.`id` = 656567 OR `props-main`.`id` = 1703999 OR `props-main`.`id` = 1704069 OR `props-main`.`id` = 1687404 OR `props-main`.`id` = 1710135 OR `props-main`.`id` = 1699034 OR `props-main`.`id` = 1708117 OR `props-main`.`id` = 1683853 OR `props-main`.`id` = 1704516 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1694317 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` = 1704367 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1710071 OR `props-main`.`id` = 1709945 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704908 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1704918 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1708179 OR `props-main`.`id` = 1708180 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1708283 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1690107 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1711173 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 1709961 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 168075 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` = 1711349 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` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1706921 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1708322 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)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644116' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-25' 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();
1
Similar Properties
$649,000
4
3
2,366
0.09
2944 Vermont Ave
Clovis, CA 93619
Courtesy of Darla Togo, Diamond Realtors - [email protected] Last modified 5 days ago Fresno MLS last checked for updates 24 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.
