Listing Agent: Cary Griffith, Century 21 Sierra Realtors Listing Co-Agent: Jackie Griffith, Century 21 Sierra Realtors
Cute Barndominium Style Home loaded with Curb Appeal! Scenic Views! Excellent Location for Valley Commuters. This Basic Beauty has over 2,000 sq. ft. with 3 bedrooms & 2 full bathrooms. Spacious Open Floor Plan is simple but sweet. 2 primary bedrooms; one upstairs & one downstairs. The large, open upstairs room is suitable for gaming or crafting & has lots of built in storage. The shady backyard area features a built in sink with tile counters, & a covered porch with concrete floor, perfect for outdoor entertaining. The upper pad has a 400 sq. ft. garage/ workshop with roll up door & a concrete floor. This developed area also has two 2,500 gallon water storage tanks, privacy from the home & water/ septic hookups for RV or travel trailer.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2009
Year Built Source
Assessor
Special Listing Conditions
Standard
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Price Per Square Foot
$180
Days On Market
85
Cumulative Days On Market
85
County Or Parish
Mariposa
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
No
Heating Y/N
Yes
Directions
From Mariposa: Hwy 140 towards Merced. Left on Yaqui Gulch Rd. Property is on the right.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 356250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 393750 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) >= 1830 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2330 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` = 1694345 OR `props-main`.`id` = 1696733 OR `props-main`.`id` = 1676737 OR `props-main`.`id` = 1686612 OR `props-main`.`id` = 1663409 OR `props-main`.`id` = 1683619 OR `props-main`.`id` = 1695109)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMP25218513' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-16' 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
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.
