Beautiful home on private 4.6 acres with nice views of the foothills. This home is perfect for entertaining or large family gatherings. The high vaulted ceilings and open floor plan five a warm and inviting feeling. The kitchen features marble counter tops, gas appliances and a large pantry. The primary suite has his and hers walk in closets and the bathroom features a oversized spa tub. There is a 20 x 20 metal shop to store all your toys that don't fit in the huge 3 car garage.In Law Quarters is approx. 1,000 sq ft of living space. The suite has separate living and bedroom areas. The living room has a fireplace that leads to the kitchen and dining area and off that is a fenced in patio are to relax on.The In Law Quarters can be used for family or as an Air BnB. The current owners were renting out and made easily $2000-$4000 a month,Schedule your showing today don't miss out on this beautiful home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1996
Region
Foothill
# of Stories
Single Story
Price Per Square Foot
$205
Price Per Acre
$143,617
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Dunlap Rd
Directions
180 East through Squaw Valley to Dunlap Rd, go right. Approx 12 miles to the town of Marimonte, at the post office turn left onto Brookside Rd. Home approx 1.2 miles on the right
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Eating Area, Breakfast Bar, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 641250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 708750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3.25' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3046 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3546 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` = 1706764 OR `props-main`.`id` = 1690926 OR `props-main`.`id` = 1731375 OR `props-main`.`id` = 1690937 OR `props-main`.`id` = 1690944 OR `props-main`.`id` = 1734624 OR `props-main`.`id` = 1687588 OR `props-main`.`id` = 1719906 OR `props-main`.`id` = 1666003 OR `props-main`.`id` = 1687627 OR `props-main`.`id` = 1714545 OR `props-main`.`id` = 1719924 OR `props-main`.`id` = 1666087 OR `props-main`.`id` = 1706858 OR `props-main`.`id` = 1716975 OR `props-main`.`id` = 1716899 OR `props-main`.`id` = 1731524 OR `props-main`.`id` = 1716984)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650039' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-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();
0
Last modified 1 hour ago Fresno MLS last checked for updates 40 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.
