Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 242 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 242 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 242 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

25249 Rebekah Rd
Long Barn, CA 95335
Jesse Worsham with PMZ, original listing - (209) 588-2910

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 1528 Square Feet
Agency: PMZ
Agency Phone: (209) 588-2910

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1964
Notes: Your Private Cabin Oasis Awaits! Welcome to your dream cabin nestled in the exclusive gated community of Sierra Park. This rustic haven offers the perfect blend of modern comforts and natural charm, making it an ideal escape for nature enthusiasts and those seeking tranquility. Spacious 4 bedrooms, 2 baths: Embrace the abundance of space for family and guests in this 4-bedroom, 2-bathroom retreat. Each room is thoughtfully designed to provide comfort and coziness, ensuring a restful night's sleep after a day of adventure. Expansive deck with outdoor kitchen: Step outside onto a large deck that boasts picturesque views of the surrounding wilderness. Perfect for entertaining, the outdoor kitchen allows you to host gatherings and BBQs with ease while immersing in the beauty of nature. Warm and inviting living room: As you enter, you'll be greeted by a charming mudroom that opens into a spacious living room featuring a fireplace insert. The cozy ambiance invites you to unwind and create lasting memories with loved ones. Covered patio for entertaining: Enjoy outdoor living year-round with a covered patio area, providing a sheltered space for relaxation and enjoyment, no matter the weather. Versatile basement workshop and storage: Discover the convenience of a basement workshop area, providing ample space for DIY projects or hobbies. Additional storage options ensure that all your belongings are kept tidy and organized. Ample sheds for wood storage and more: With three sheds at your disposal, you'll have plenty of space to store firewood, gardening tools, and outdoor equipment, keeping your cabin clutter-free and well-prepared for all seasons. Long-lasting features: Rest easy knowing the cabin boasts a 50-year newer roof and new double-pane windows throughout, ensuring durability and energy efficiency. Escape the hustle and bustle of city life and retreat to this enchanting cabin in Sierra Park. Immerse yourself in the serenity of nature, explore nearby trails, and savor the freedom of a private gated community. Whether you seek a permanent residence or a vacation getaway, this cabin fulfills your desire for a harmonious blend of comfort and wilderness. Schedule a tour today and experience the magic of this Sierra Park sanctuary firsthand!
MlsNumber: --
ListingId: 20240979


Listing Provided By: PMZ, original listing
Phone: (209) 404-9768
Office Phone: (209) 588-2910
Agent Name: Jesse Worsham
Disclaimer: Copyright © 2024 Tuolumne County Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App