A beautiful NW Clovis home in a great location! This 2366 sqft home offers 4 bed, 3 bath, including a desirable downstairs bedroom and full bath. The open-concept layout showcases high ceilings and natural lighting. The kitchen is a true centerpiece, featuring quartz countertops, stainless steel appliances, a gas range, a large center island with breakfast bar, and a generous pantry. Upstairs, a spacious loft provides versatile living options, while the private primary suite offers a relaxing retreat with dual vanities, a soaking tub, and a walk-in closet. The upstairs laundry room adds everyday convenience. Step outside to the landscaped backyard with a covered patio, perfect for outdoor dining. Additional highlights include wood-style tile flooring, owned solar, and energy-efficient features through out.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2022
Region
Urban
# of Stories
Two
Price Per Square Foot
$270
Price Per Acre
$6,819,637
Days On London
59
Cumulative Days On London
219
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, High Tech Cable
REO / Bank Owned
No
Cross Street Address
E Shepherd / N Locan
Directions
From E. Shepherd Ave and N. Locan Ave, head south on N. Locan Ave. Make a right (west) turn onto Trenton Ave. Turn right (north) onto N Greenfield Ave. Follow curve around to Vermont Ave and arrive at location on the right.
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, On Upper Level, Electric Hook Up
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Electric Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry, Refrigerator
Dining Room Features
Family Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Oval Tub
Extra Rooms
Loft
Flooring
Carpet, Laminate, Tile
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Patio Features
Covered
Yard
Sprinklers Back, Sprinklers Auto, Fenced, Drip System
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 670950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2116 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2616 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` = 1714983 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1708131 OR `props-main`.`id` = 1718676 OR `props-main`.`id` = 1714009 OR `props-main`.`id` = 1704367 OR `props-main`.`id` = 1715597 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1717159 OR `props-main`.`id` = 1719854 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1716972 OR `props-main`.`id` = 1718254 OR `props-main`.`id` = 1712495 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1713847 OR `props-main`.`id` = 1716845 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1716751 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` = 1716508 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1705677 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1716627 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` = 1701870 OR `props-main`.`id` = 1719684 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1717439 OR `props-main`.`id` = 1712677 OR `props-main`.`id` = 1708087 OR `props-main`.`id` = 1703958 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1719778 OR `props-main`.`id` = 1719773 OR `props-main`.`id` = 1719777 OR `props-main`.`id` = 1719779 OR `props-main`.`id` = 1719786 OR `props-main`.`id` = 1719769 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1719770 OR `props-main`.`id` = 1719785 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1719767 OR `props-main`.`id` = 1719784 OR `props-main`.`id` = 1719787 OR `props-main`.`id` = 1719768 OR `props-main`.`id` = 1719793 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1719791 OR `props-main`.`id` = 1719792 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1719790 OR `props-main`.`id` = 1719783 OR `props-main`.`id` = 1719780 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1719782 OR `props-main`.`id` = 1719788 OR `props-main`.`id` = 1719789 OR `props-main`.`id` = 1719771 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1719772 OR `props-main`.`id` = 1720316 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno643432' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-06' 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
$609,000
4
3
2,298
0.16
1742 N Broadbent Ln
Clovis, CA 93619
Courtesy of Jo-Linda Garud, VHP Brokers - [email protected] Last modified 3 weeks ago Fresno MLS last checked for updates 1 minute 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.
