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

61551 S 4688 Road
Watts, OK 74964
James Sumter II with Keller Williams Preferred, original listing - (918) 496-2252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,900
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4646 Square Feet
Agency: Keller Williams Preferred
Agency Phone: (918) 496-2252

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 10 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1991
Notes: Discover luxury and functionality on this picturesque 10-acre property, just minutes from Siloam Springs & within 15 minutes of the scenic Illinois River. This stunning home is a true haven for those seeking comfort & tranquility.<br /> A private, tree-lined driveway welcomes you home. The thoughtfully designed open floor plan seamlessly connects the living, dining, & kitchen areas, while offering 4 bedrooms and 4.5 bathrooms making it ideal for both entertaining & daily living, . The kitchen is a chef's dream, showcasing a custom hand-crafted Italian stove, epoxy countertops, and hardwood cabinets that will inspire culinary masterpieces. Hardwood floors flow throughout, adding warmth & timeless elegance, while vaulted ceilings create an inviting atmosphere.<br /> The primary bedroom, located on the main floor, offers a luxurious retreat with a spacious layout, a walk-in closet, and a beautifully designed en-suite featuring a state-of-the-art shower. The additional bedrooms are generously sized, providing each with bonus rooms attached. These bedrooms provide versatile spaces for family, guests, or a home office. A cozy wood-burning fireplace in the living area enhances the home’s warmth & charm during cooler months.<br /> The wraparound porch is perfect for quiet moments or hosting gatherings, while the expansive acreage invites gardening, recreation, or peaceful relaxation. The property boasts a 40x30 shop for projects or storage, a chicken coop, and a storage container. Practical upgrades include a 1,000-gallon owned propane tank, fiber optics for internet, a peroxide water well system with a brand-new water filter, new pump and cover for the septic system, new foam insulation installed to the home ensuring efficiency and convenience for everyday living.<br /> This exceptional property offers the rare opportunity to enjoy the serenity of country living without sacrificing modern comfort. Schedule your showing today and make this dream retreat your forever home!
MlsNumber: --
ListingId: 2443238


Listing Provided By: Keller Williams Preferred, original listing
Phone: (918) 805-9315
Office Phone: (918) 496-2252
Agent Name: James Sumter II
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