Courtesy of Tracy de Jong, Realty Concepts, Ltd. - Clovis - [email protected]
Two courtyards, single-story comfort, and the Harlan Ranch lifestyle! Welcome to 3911 Heritage Avenue, nestled in the charming Kingston neighborhood of Harlan Ranch. This inviting home offers 2 bedrooms plus a versatile open bonus room that can easily serve as a 3rd bedroom, formal dining area, home office, playroom, exercise space, or additional living area. It also includes two full baths. And to make your move even easier, the refrigerator, washer, dryer, flat-screen TV, and mounting hardware are also included. Enjoy the best of indoor-outdoor living with two separate courtyards! Sip your morning coffee in the welcoming front courtyard, then unwind or entertain in the private rear courtyard, complete with an included BBQ and bistro set. Spend less time on yardwork (front landscaping is covered by the HOA) and more time enjoying everything this wonderful community offers. Harlan Ranch is known for its beautiful tree-lined walking paths, neighborhood parks, community pool, clubhouse, and activities that bring neighbors together throughout the year. Whether you're looking for easy-care living, flexible spaces, or a neighborhood with a true sense of community, this home offers a lifestyle that's easy to love. Come experience Harlan Ranch living!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2009
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$331
Price Per Acre
$5,734,559
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Dutch & Heritage
Directions
From Shepherd and 168, head west on Shepherd, left on Highland, right on Harlan Ranch Blvd, left on Dutch, left on Heritage.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
F/S Range/Oven, Gas Appliances, Dishwasher, Microwave, Refrigerator
Pool, Club House, Green Area, Playground, Landscape Maint
HOA Dues
170.00
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) >= 370452.5 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 409447.5 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 927 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1427 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` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1790415 OR `props-main`.`id` = 1773163 OR `props-main`.`id` = 1786771 OR `props-main`.`id` = 1771476 OR `props-main`.`id` = 1758747 OR `props-main`.`id` = 1771036 OR `props-main`.`id` = 1750648 OR `props-main`.`id` = 1750780 OR `props-main`.`id` = 1779985 OR `props-main`.`id` = 1782443 OR `props-main`.`id` = 1783531 OR `props-main`.`id` = 1752922 OR `props-main`.`id` = 1784023 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1773783 OR `props-main`.`id` = 1784051 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1779953 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1758862 OR `props-main`.`id` = 1772093 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1791608 OR `props-main`.`id` = 1769169 OR `props-main`.`id` = 1788100 OR `props-main`.`id` = 1790038 OR `props-main`.`id` = 1788687 OR `props-main`.`id` = 1785420 OR `props-main`.`id` = 1784045 OR `props-main`.`id` = 1784046 OR `props-main`.`id` = 1777077 OR `props-main`.`id` = 1775562 OR `props-main`.`id` = 1791481 OR `props-main`.`id` = 1779688 OR `props-main`.`id` = 1774921 OR `props-main`.`id` = 1780195 OR `props-main`.`id` = 1732245 OR `props-main`.`id` = 1776403 OR `props-main`.`id` = 1777838 OR `props-main`.`id` = 1777834)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656434' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-15' 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
Last modified 2 hours ago Fresno MLS last checked for updates 33 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.