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

406 Three Nations Drive
Eufaula, OK 74432

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $990,000
Beds: 4
Baths: 5
Status: Pending
SqFt: --
Agency: Metro First Realty LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: --
Notes: Stunning lake views from this gorgeous new construction home in the desirable Three Nations Estates WITH BOAT SLIP INCLUDED. Three nations is a gated community filled with beautiful estates offering some of the clearest water and best fishing on Lake Eufaula at a hard to beat location within a 13 minute drive to town of Eufaula, 7 min to #9 marina, 10 minutes to Carlton Landing and easily accessible to everything by water. This home is an entertainers dream and features an impressive 30' cathedral living and 572 sq ft cathedral upper terrace that overlooks the lake and offers a wood burning fireplace with rock exterior. Private backyard with wooded/mountain like view. Downstairs you will find owners suite offering a soaker tub, walk-in shower, and private slider doors to backyard. There are 2 additional bedrooms downstairs both offering private en-suites and closets. A formal dining, stunning butlers pantry, mudroom, powder bath, under the stairs dog/reading nook, 2 car garage, and a chefs kitchen featuring a 48” gas range, 5' built in fridge/freezer, quartz countertops & backsplash, under cabinetry lighting, 9’ kitchen island seating 7+, coffee station and more. Upstairs you will find a recreational room with vaulted ceilings, granite bar seating, ice maker, beverage cooler, and custom cabinetry with lake views! A bunk room that sleeps 12, bathroom, a large loft area with built-ins, and two outdoor patios. Sprinkler system, spray foam insulation, fiber-glass windows, 10' patio sliders iRobot docking station and drying rack are just a few of the “extras” in the home. Estimated mid/late April completion. Included slip is 10X27. Approx. 1548 sqft of outdoor living space. Great internet already available but fiber optic coming soon! You truly have to see this one in person to appreciate.
MlsNumber: 1100057


Listing Provided By: Metro First Realty LLC, original listing
Name: Metro First Realty LLC
Phone: (405) 242-4004
Office Name: Metro First Realty
Office Phone: (405) 242-4004
Agent Name: Santana Dennis
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