Rare opportunity in the prestigious gated community Barclay Square located in Harlan Ranch. Resort style living reimagined with exclusive access to a community clubhouse and scenic parks. This home is only steps away from the award-winning Bud Rank Rank Elementary and just short drive to the Clovis North Educational Complex, make it the ideal home for families. This beautifully designed single story boasts 2653 SQ ft and a 4 bedroom 3-car-garage configuration. Built by Leo Wilson, with quality construction in mind, the kitchen has stainless steel appliances, a gas cooktop, granite countertops, and an oversized island. Gorgeous plantation shutters have been installed throughout the home. High ceilings, recessed lighting, and crown molding make this property an architectural masterpiece. The luxurious owners suite includes a soaking tub with double vanities and dual walk in closets. Step outside to a custom pergola perfect for relaxing in the shade while enjoying the mature sago palms and low maintenance backyard.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2007
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$260
Price Per Acre
$4,382,952
Days On Market
138
Cumulative Days On Market
138
County
Fresno
REO / Bank Owned
No
Cross Street Address
Shepherd
Directions
East on Shepherd, South on N Dewolf, East of Powers, and South on N Sanders. Barclay Gated Community on Right.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave
Pool, Club House, Green Area, Security Guard, Gated Community
HOA Dues
181.00
Frequency
Monthly
School District
Clovis Unified
School Type 1
High School
School Name 1
Clovis North
School Type 2
Junior High School
School Name 2
Granite Ridge
School Type 3
Grade School
School Name 3
Bud Rank
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 654550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 723450 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2403 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2903 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` = 1638338 OR `props-main`.`id` = 1690806 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1701322 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1693773 OR `props-main`.`id` = 1697416 OR `props-main`.`id` = 1692278 OR `props-main`.`id` = 1670884 OR `props-main`.`id` = 1678915 OR `props-main`.`id` = 1689212 OR `props-main`.`id` = 1696270 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1698019 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1698845 OR `props-main`.`id` = 1695858 OR `props-main`.`id` = 1698747 OR `props-main`.`id` = 1686178 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1685450 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1696276 OR `props-main`.`id` = 1690316 OR `props-main`.`id` = 1693708)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno635979' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-07' 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
$669,000
5
2.75
2,863
0.16
1822 N Magnolia
Clovis, CA 93619
Courtesy of Andres Zamora, Real Estate eBroker, Inc. - [email protected] Last modified 4 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.
