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 = 2176 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 = 2176 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 = 2176 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;

10034 E 233rd Street S
Porum, OK 74455
Leah Paasch with C21/Shirley Donaldson Inc, original listing - (918) 426-4343

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: --
Baths: --
Status: Active
SqFt: 10036 Square Feet
Agency: C21/Shirley Donaldson Inc
Agency Phone: (918) 426-4343

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 84 acre(s)
Property Type: Commercial Sale-Mixed Use
Year Built: 2005
Notes: This exclusive opportunity won't last long! Beautifully situated on 84 acres, this Cabin Estate offers seclusion, unique luxury, and viable business opportunities! Come see this amazing hidden gem in the Lake Eufaula area! The estate offers an exquisite two- story venue fully equipped for weddings, corporate retreats, reunions, etc! Venue offers 9 bedrooms, each with hand carved wooden furniture, 7 1/2 bathrooms, multiple living areas, and an indoor hot tub. Note the amazing wooden floors throughout, the massive beamed ceiling, four grand fireplaces, and the splendid double staircase! Not to miss is the sumptuous primary suite with custom designed tile and glass bath! Venue also includes an attached three car garage that has been converted into an exceptionally beautiful bar/gathering area! Take a walk via the three covered patios, through the outdoor bar area, and visit the custom in-ground pool and jacuzzi in the back yard! Venue is offered fully furnished, including exceptional custom furniture not found anywhere else! Also on property is a gorgeous three bedroom ranch style home that offers you a refined, cozy living space just down the paved driveway from the venue! The home has beautiful tile and wood floors throughout, granite counter tops, and metal roof. Step outside and admire the fully fenced 84 acres with multiple ponds, ready for the livestock of your choosing! Notice the three large outbuildings that will satisfy all your storage and workshop needs! This kind of opportunity will not be found again! Come see for yourself how your dreams of owning a flourishing business and spectacular, one of a kind estate can come alive right here in Oklahoma!
MlsNumber: --
ListingId: 2404647


Listing Provided By: C21/Shirley Donaldson Inc, original listing
Phone: (803) 747-1326
Office Phone: (918) 426-4343
Agent Name: Leah Paasch
Disclaimer: Copyright © 2024 MLS Technology, 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