Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/crmls/MP25032864/3729-Ben-Hur-Rd/Mariposa/https://www.londonproperties.com/images/props/crmls/full/MP25032864.jpgLondon Properties Mariposa Real Estate | 3729 Ben Hur Rd
Listing Agent: Brett Baumann, Mariposa Homes and Land Co.
A ''GOLDEN OPPORTUNITY'' to own your own Sierra Foothill Ranch in Mariposa County, CA! This 1,888+/- acre Private Ranch is located just 45 minutes from Yosemite National Park and is being sold as one Ranch BUT if the new owner would like to sell off any of the parcels individually, this will be acceptable to do so. The Family has gone to great lengths to create or subdivide the ranch into multiple parcels to allow the owner to sell off individual parcels, as shown on the attached Parcel Maps showing the respective parcels. There are 8 legal parcels which 7 of the parcels are zoned AEZ (Agricultural Exclusive Zone) 5 of which are in the LCA- Williamson Act allowing for reduced property tax rate as long as you maintain the property as income producing agricultural uses (cattle grazing or similar). There is a 1642 SF Western Home located on one of the parcels which is a 3BR/2BA home and overlooks a large part of the property with excellent views. The ranch spans from Ben Hur Road to White Rock Road which allows for good access from both roads. Other features of this expansive ranch are: Mariposa Creek runs through part of the ranch, other seasonal creeks run through the property, there is a pond or lake on the property, open meadows, considerable Oaks and other varieties of trees across the ranch and much more! The ranch elevation ranges from 1500' to 2500' elevation which is ''above the fog and below the snow'' most of the time! This would be considered a ''Hunters Paradise'' as wildlife has roamed here freely for years! This property will not last long so give us a call today for a discreet showing. Buyers will need to provide proof of funds before viewing.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2748350 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 3037650 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) >= 1392 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1892 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` = 1674461 OR `props-main`.`id` = 1674462 OR `props-main`.`id` = 1685058 OR `props-main`.`id` = 1685540 OR `props-main`.`id` = 1663865 OR `props-main`.`id` = 1683035 OR `props-main`.`id` = 1684760 OR `props-main`.`id` = 1695877 OR `props-main`.`id` = 1693736)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMP25032864' 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.
