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;

263 Eagles Nest Path
Stigler, OK 74462
Karen Weldin with Eufaula Lakeshore Realty, LLC, original listing - (888) 788-5945

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $689,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: 2786 Square Feet
Agency: Eufaula Lakeshore Realty, LLC
Agency Phone: (888) 788-5945

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: WATERFRONT HOME NESTLED IN A WOODED SETTING INCLUDING A BOAT SLIP! This home is located in the popular gated community of Three Nations in the Longtown area of Lake Eufaula  The home has the cottage look and feel and boasts a beautiful full front porch for you to sit and enjoy the wildlife. Step inside and be awed by the charm of tall vaulted wood ceilings, board-and-batten walls, an amazing stone fireplace, and beautiful wood floors.  The living space is an open floor plan with living, dining, and kitchen space.  The kitchen features granite countertops, a window view to the outdoors over the sink, a built-in bench for a cozy eating space, and a built-in hutch.  An under-counter icemaker makes entertaining easier and is located underneath a custom stainless steel-topped island.  The home features five bedrooms.  Walk upstairs to the loft area and discover an amazing suite.  There is a sitting area, a full bathroom, and a large bedroom.  There are two bedrooms and a full bath located on the main floor.  Then, walk downstairs to the finished walkout basement and you will find another two bedrooms, two bathrooms, a living area, a wet bar, and a laundry room.  There is plenty of space for family and guests!  As a bonus,  enjoy the outdoor kitchen and beautiful wooded landscape as you walk out the doors of the walkout basement!  The home also has a small garage which is a great place to store your golf cart or ATV and lake toys!  You will also be impressed with the construction of this home.  It was built with insulated concrete walls which are 16" wide and has 60 five-foot piers underneath supporting it!  Let me also mention that this home comes furnished!  So, pack your bags and your toothbrush and start enjoying Lake Eufaula, OK!  If you want more space and more than one boat slip, there are also extra lots and 2 more boat slips.  Call me today to look at this great package!
MlsNumber: --
ListingId: 2435412


Listing Provided By: Eufaula Lakeshore Realty, LLC, original listing
Phone: (888) 788-5945
Office Phone: (888) 788-5945
Agent Name: Karen Weldin
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