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

449918 E 953 Road
Vian, OK 74962
Angela Thornton with Tenkiller Lake and Land, original listing - (918) 773-4070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $765,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3020 Square Feet
Agency: Tenkiller Lake and Land
Agency Phone: (918) 773-4070

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: Discover the epitome of serene lake living at 449918 E 953 Rd, Vian, OK 74962. Nestled on the scenic Ridge Route Road and boasting enchanting winter lake views, this captivating property is available for the first time EVER and eagerly awaits its new owner!<br /> <br /> Step inside this beautifully appointed 3,020 square-foot home where modern luxury meets comfort. The house features three generously sized bedrooms and two well-appointed full bathrooms plus a half bath. Experience ultimate relaxation in the master suite, complete with a private bathroom that includes a luxurious walk-in shower and jacuzzi tub, perfect for unwinding after a long day.<br /> <br /> The heart of this home is the trophy room, or second living room, which invites warmth with its wood-burning fireplace and vaulted ceilings, creating an ideal setting for entertaining or quiet evenings at home. The impeccably designed interior boasts granite countertops throughout, complemented by elegant bamboo flooring, ensuring both style and durability.<br /> <br /> Upgraded for the discerning buyer, the home includes a whole house water purifier, a newer roof, new smart board siding, and Anderson windows and doors, blending functionality with sophistication. The gourmet outdoor kitchen and separate screened-in patio promise unforgettable gatherings with friends and family, making the most of the picturesque surroundings.<br /> <br /> Nestled in a meticulously gated and fenced setting, this property offers privacy and exclusivity. Its prime location is just a golf cart drive away from Pine Cove Marina, Clearwater Cafe, Blackgum Landing and the local swim beach, offering endless recreational opportunities. Conveniently accessible from I40, this home combines the tranquility of lakeside living with easy access to local amenities.<br /> <br /> Don’t miss the chance to make this exquisite property your new home. A sanctuary of peace, elegance, and convenience awaits.
MlsNumber: --
ListingId: 2435302


Listing Provided By: Tenkiller Lake and Land, original listing
Phone: (918) 315-2486
Office Phone: (918) 773-4070
Agent Name: Angela Thornton
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