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

218 Stewart Road
Stigler, OK 74462
Elizabeth Phelan with Lake Homes Realty, LLC, original listing - (866) 525-3466

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,100,000
Beds: 10
Baths: Full: 9
Status: Active
SqFt: 5698 Square Feet
Agency: Lake Homes Realty, LLC
Agency Phone: (866) 525-3466

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2021
Notes: CALICO HEIGHTS is the ultimate getaway on Eufaula Lake!! <br /> <br /> This property features 9 modern cabins set up for short term rentals. Each unit is fully furnished with an abundance of windows capturing sunlight and full view of Eufaula Lake. While guest relax and enjoy the privacy and peacefulness Calico Heights offers, they can experience amazing sunsets from their patio. There is a hiking trail for guest to enjoy all that nature has to offer here at Calico Heights. Each cabin is modern, high end, and sleek in every detail. Whether guests are seeking a romantic retreat or a fun-filled escape, this property offers the perfect setting for unforgettable memories. <br /> <br /> Calico Heights has a proven track record for consistent renters as well as return guest, offering an incredible income potential for investors looking to expand their portfolio. LOCATION is key in every investment, this property is in a prime location just a few miles from # Nine Marina, and 10 mins from downtown Eufaula. <br /> <br /> The possibilities to expand this already income producing property are endless. There is a 2400 sqft. shop waiting for you to bring your ideas to life and develop other areas of hosting even more guests.<br /> <br /> Calico Heights is truly a one-of a kind property with so much attention to detail in the planning and building of each cabin, as well as the overall layout of the property. This gated property is a must-see!! Call today to schedule your private showing!!!
MlsNumber: --
ListingId: 2434758


Listing Provided By: Lake Homes Realty, LLC, original listing
Phone: (580) 579-0895
Office Phone: (866) 525-3466
Agent Name: Elizabeth Phelan
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