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

23630 E 818 Road
Welling, OK 74471

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2241
Agency: Century 21 Wright Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2022
Notes: Escape to the serene beauty of the countryside with this stunning custom-built 2022, 2-story farmhouse-style 2241 SF (per AP) home. This home offers the epitome of country living with no restrictions and the freedom to build the shop of your dreams!<br /> <br /> Thoughtfully designed with impeccable attention to detail. With 3 bedrooms, 3 full baths, and 2 spacious living areas, there's ample room for relaxation and entertainment.<br /> <br /> Chef's dream kitchen complete with farmhouse-style sink, Butler's pantry with a convenient coffee bar, a 5-burner gas range, and a large kitchen island perfect for gatherings. The juxtaposition of black matte hardware against white cabinets and high-gloss finish granite countertops creates an ambiance of timeless elegance.<br /> <br /> Retreat to the primary suite and indulge in spa-like luxury with a freestanding soaking tub, sleek floor faucet, walk-in shower with herringbone subway tile, and a double vanity with designer granite countertops.<br /> <br /> Large laundry room featuring a designer dog shower, ensuring that even your furry friends are pampered in style. An ensuite bedroom on the main floor offers privacy and versatility.<br /> <br /> Discover the magic of hidden spaces with a Harry Potter-inspired nook under the stairs, providing a cozy retreat for children or pets to enjoy endless adventures.<br /> <br /> Designed for easy maintenance and durability, sealed concrete floors on the main level and luxury vinyl plank flooring upstairs offer both style and practicality, perfect for the rigors of country living.<br /> <br /> Soak in the tranquility of the countryside from the wrap-around porch or store your outdoor essentials in the oversized storage shed. New well & septic system ensure peace of mind.<br /> <br /> On 1 acre park-like setting, this home offers endless possibilities for outdoor enjoyment. Experience country living, from dirt roads to quirky neighbors, at its finest in this custom-built farmhouse retreat, where every detail has been thoughtfully curated to elevate your lifestyle.
MlsNumber: 2413594


Listing Provided By: Century 21 Wright Real Estate, original listing
Name: Century 21 Wright Real Estate
Phone: (918) 708-1256
Office Name: C21/Wright Real Estate
Office Phone: (918) 708-1256
Agent Name: Edna Kimble
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