Welcome to the highly desired Harlan Ranch Community! This beautiful Wathen Castanos built home has it all with 4 bedrooms, 3 bathrooms and 2495 square feet filled with stunning features throughout. As you enter, you will encounter pristine laminate flooring with sprawling high ceilings and a vast amount of can lighting. This home provides everything a family desires with an open concept with a large great room with large windows overlooking a backyard paradise. The gourmet kitchen comes fully equipped with granite countertops, a sizable center island, built- in appliances, plenty of storage cabinets, walk-in pantry and large eating area. The downstairs includes a bedroom and full bathroom for seclusion and guests. The upstairs presents an oversized den area, well designed laundry room with a tile countertop and storage cabinets. The large primary bedroom provides seclusion and comfort with a double vanity, soaking tub, walk-in shower and a walk- in closet. There are two other spacious bedrooms located upstairs. The backyard gives you everything you ever wanted with a sparkling pool, hot tub spa, side space to store your boat, garden area to grow your favorite fruits and vegetables and breathtaking views of the sierras. The garage is situated with a unique 3 car tandem space with a work bench and storage cabinets. This home is located close to freeways, restaurants and shopping. Dont miss this opportunity to own such a spe home in one of the most sought after neighborhoods in the Valley. Call today for more information!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2014
Region
Urban
# of Stories
Two
Price Per Square Foot
$257
Price Per Acre
$4,740,741
Days On Market
0
Cumulative Days On Market
172
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Security System, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Shepherd/Highland
Directions
Use google maps
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Tub, Oval Tub
Extra Rooms
Great Room, Loft, Game Room
Flooring
Laminate, Tile
Exterior
Stucco, Brick
Pool
Yes
Pool
Yes
Pool Type
In Ground
Spa
Yes
Spa Type
Above Ground
Patio Features
Covered, Concrete
Yard
Sprinklers Front, Sprinklers Back, Fruit/Nut Trees, Garden Area, Drip System
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 608000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 672000 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) >= 2245 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2745 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` = 1701943 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` = 1689212 OR `props-main`.`id` = 1696270 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1698845 OR `props-main`.`id` = 1695858 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 1686178 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1685450 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1702511 OR `props-main`.`id` = 1690316)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno641807' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-13' 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
$624,000
4
3
2,378
0.12
4102 Richmond Ave
Clovis, CA 93619
Courtesy of Matthew Rommereim, The Apex Broker, Inc - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 19 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.
