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 = 2168 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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 = 2168 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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 = 2168 AND i.igate IN ('usahud','okhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'okhud', 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;

16069 Tabler Road
Marietta, OK 73448
Jason McElroy with The Leonard Team Realty LLC, original listing - (405) 479-8883

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $600,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: The Leonard Team Realty LLC
Agency Phone: (405) 479-8883

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Welcome to your own slice of paradise! This exquisite 10-acre property is ready to fulfill all your dreams. With a convenient location just minutes away from the renowned Winstar Casino, 30 minutes from the breathtaking Lake Murray, and another 30 minutes from the pristine Lake Texoma, you'll have endless opportunities for entertainment and relaxation. This remarkable land is fully fenced and mostly cleared, ensuring that you can envision your dream home with ease. The utilities are conveniently located at the road, making the building process a breeze. Whether you have a grand residential vision or a commercial endeavor in mind, this property offers unrestricted potential to bring your dreams to life. Bring your subdividing dreams to life with this property. Access is made easy with less than 5 minutes to I-35, and Highway 77 access is just seconds away. A world of convenience awaits you! Picture yourself waking up to the picturesque views surrounding your custom-built oasis, complete with rural water and electric services right at your fingertips. Families will be delighted to discover that this property falls within the highly sought-after Thackerville school district, guaranteeing access to quality education for your little ones. Immerse yourself in the tranquility of the countryside while still being in close proximity to all the essential amenities. Don't miss this fantastic opportunity to own a piece of heaven on earth. Act now and seize the chance to fulfill your wildest aspirations. This property's unbeatable location, versatile use options, and enticing features make it an irresistible gem in today's real estate market. Your dreams are waiting to become a reality – grab this opportunity and start building the life you've always imagined. Schedule a viewing today and prepare to be captivated by the endless possibilities that await you on this remarkable property.
MlsNumber: --
ListingId: 1124864


Listing Provided By: The Leonard Team Realty LLC, original listing
Phone: (405) 479-8883
Office Phone: (405) 479-8883
Agent Name: Jason McElroy
Disclaimer: Copyright © 2024 MLSOK, Inc. 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