Listed by Derek Nott of Executive Realty And Financia (559-676-6333)

Listing Sold by Real Brokerage Technologies
ENTERTAINER'S DELIGHT! Excellent Location! Come Experience the Wonderful Ambience surrounding this Gem on a gorgeous 1.48 acre parcel. We start with the amazing garden landscape. The Wife decided to be on the Local Garden Tour and so it began! Two years in a row we won the Top Spot. Words and pictures do no do this justice... You have to come and see this remarkable home. Beginning outdoors we have 5 levels of beautiful Redwood decking featuring a 12' by12' "Diva Den" complete w/mini split, flat screen and cozy seating providing a perfect "women's only" hideaway. The next level is a relaxing 6 person spa under a Gazebo for year round enjoyment, another level provides a great Bar/BBQ area, then another Gazebo near the covered back porch and finally an open air deck off the 12' by 33' Entertainment Room with large picture windows bringing the outdoors in - also w/its own mini-split. The gardens surrounding are highlighted with meandering walkways, wonderful recycling waterfall, Waterlily covered pond, faux grass and all species of beautiful drought tolerant plants (all on auto drip) for low maintenance enjoyment. It addition to beauty is complete functionality. 52 panels of "paid for" solar power, backed by a 24KW propane generator, 500 gal propane tank (just in case), tons of parking, a 2 car garage w/addl storage, a 2 car carport with workshop & covered "Catio" or addl storage, another matching storage shed, and RV parking for a 45' motorhome with 50/30amp hookups. The home is a Warm, Inviting log cabin style masterpiece, featuring a wonderful open greatroom w/glass galore to show off the surrounding outdoor beauty, 3 beds, 2 baths, large dining area, step-saver kitchen, 3 mini splits, a whole house swamp cooler and wonderful propane free-standing heater. You will never want to Leave! Perfectly Located 35 min from South gate of Yosemite, Surrounded by 3 large lakes Bass, Millerton, Hensley, and only 25 minutes from major shopping in Fresno. There is nothing else that can compare!

Listing Tools (detailViewNewGen)

Property Details of 28820 Limestone Circle

Property Details

Interior Features

Exterior Features

Community

Other Details

Map Location

Based on information submitted to CRMLS as of June 19, 2026 8:24 AM UTC . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Seven Gables Real Estate. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.