OWNED SOLAR !! This beautiful home is situated in a cul-de-sac on a premium HUGE lot in Harlan Ranch. Plenty of room for a large family, featuring 5 bedrooms, 4 full bathrooms, large game room, a downstairs office, plus a detached extra storage/hobby room and a 3 car finished garage with epoxy flooring. The kitchen has been updated with white quartz counter tops, large sink and stainless steel appliances. High end hardwood flooring throughout the bottom level of the home for a timeless look. Enjoy your summers entertaining in the generously sized backyard with stamped concrete, large heated pool with water features and a spa. Solar to be paid off at COE. Motivated sellers. Schedule a private showing today before it's gone!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2006
Region
Urban
# of Stories
Two
Price Per Square Foot
$248
Price Per Acre
$2,512,288
Days On London
31
Cumulative Days On London
31
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom
REO / Bank Owned
No
Cross Street Address
DeWolf/Shepherd
Directions
major cross streets Shepherd and Dewolf. Use Google map
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
Dining Room Features
Formal
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Jetted Tub
Extra Rooms
Office, Den/Study, Game Room
Basement
None
# of Fireplaces
1
Exterior
Stucco, Wood
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
Pool, Club House, Green Area, Security Guard, Playground, Landscape Maint
HOA Dues
100.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
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 874000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 966000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3465 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3965 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` = 1704367 OR `props-main`.`id` = 1689035 OR `props-main`.`id` = 1692208 OR `props-main`.`id` = 1704573 OR `props-main`.`id` = 1704162 OR `props-main`.`id` = 1670884 OR `props-main`.`id` = 1707071 OR `props-main`.`id` = 1704918 OR `props-main`.`id` = 1689212 OR `props-main`.`id` = 1696270 OR `props-main`.`id` = 1693924 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1707196 OR `props-main`.`id` = 1710090 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1698845 OR `props-main`.`id` = 1706637 OR `props-main`.`id` = 1704072 OR `props-main`.`id` = 1705677 OR `props-main`.`id` = 1709935 OR `props-main`.`id` = 1701870 OR `props-main`.`id` = 1681726 OR `props-main`.`id` = 1699173 OR `props-main`.`id` = 1710011 OR `props-main`.`id` = 1709961 OR `props-main`.`id` = 1693708 OR `props-main`.`id` = 1708087 OR `props-main`.`id` = 1705929 OR `props-main`.`id` = 1708281 OR `props-main`.`id` = 1703958 OR `props-main`.`id` = 1706078 OR `props-main`.`id` = 1705575)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno642338' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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
Courtesy of Rachelle Jansen, Realty Concepts, Ltd. - Fresno - [email protected] Last modified 8 hours 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.
