Have you ever dreamed of living in the country but want to be close to the city? The dream starts here at this beautiful custom home on 5 usable, fenced & cross fenced acres in the lower foothills, complete with a newer OWNED SOLAR system! Relax on the front covered patio while enjoying the views and watching animals you may have on the property. The open floor plan features a large kitchen w/breakfast bar, inviting bay window eating area & expansive living room w/vaulted ceilings, a wood storage area & a newer wood stove. Large bedrooms reside on the far side of the home and storage galore is throughout.The huge primary suite begins with double entry doors & French doors to the backyard and lead to the huge bath with 2 walk-in closets, 3 vanities, jetted tub and separate shower. Not included in the square footage is a bonus room as well. The opposite end of the home features a large laundry room with a sink even more storage. Just off the kitchen is a nice walk-in pantry. The attached 3 car garage is a spacious 864sf with stairs to storage above and 220 power + sub-panel for welder.Walk or drive up to the large pad above the house for storage or future development. Out front boasts a fenced small animal area and at the far end of the property are level pastures.This property has it all and once you see it, you will not want to leave.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1996
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$280
Price Per Acre
$130,000
Days On London
0
Cumulative Days On London
0
County
Fresno
Leased Equipment
Water Softener
Special Features
Security Gate, Built In Cabinets, Central Vac, Water Softener, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Pittman Hill/Stoney Hill
Directions
Hwy 168E, right on Sample.Follow for approx.5 mi, left on Stoney Hill, right on Redhawk. Follow road as it curves to the left. 2nd driveway on left.
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room, Gas Hook Up, Electric Hook Up
Roofing
Composition
Foundation
Concrete
Detached Structures
Other/See Remarks
Kitchen
Built In Range/Oven, Electric Appliances, Dishwasher, Microwave, Eating Area, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 617500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 682500 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) >= 2070 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2570 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` = 1717028 OR `props-main`.`id` = 1714476 OR `props-main`.`id` = 1715225)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645618' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-19' 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 Jeri Kuddes, Realty Concepts - Prather - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 15 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.
