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

801 Ne Ave C
Idabel, OK 74745
Melissa Kergosien with BB Real Estate, original listing - (580) 494-6046

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $678,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 5519 Square Feet
Agency: BB Real Estate
Agency Phone: (580) 494-6046

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 16 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1973
Notes: Discover a hidden gem at 801 NE Ave C in Idabel, Oklahoma—a one-of-a-kind, semi-remodeled mid-century masterpiece that blends artistic flair with modern comforts. This stunning home beckons with walls of windows that flood the interior with natural light and frame breathtaking views of its sprawling nearly 17-acre estate. Nestled at the end of a quiet road, this retreat offers unmatched privacy, complete with a 3-acre naturally stocked pond—perfect for fishing, relaxing, or simply soaking in the serenity of country living, all while being just moments from Idabel’s conveniences.<br /> <br /> Step inside to find 3 spacious bedrooms, 3.5 baths, and an array of luxurious features: a rejuvenating sauna, a dedicated workout room, a vast basement, and an expansive living room primed for gatherings. The chef’s dream kitchen, complete with included appliances, is a culinary haven, while the laundry room and attached 2-stall garage add everyday ease. Modern upgrades abound—new AC units, spray foam insulation, a fresh roof over the living room, updated plumbing, electrical, garage door with opener, and dual water heaters ensure comfort and efficiency. A state-of-the-art automation system ties it all together, with built-in speakers, security, and LED lighting throughout. <br /> <br /> The living room, with its unfinished hardwood oak floors, awaits your personal touch to bring it to life, while three fireplaces with gas hookups promise cozy evenings ahead. Outside, the property shines with a detached playhouse, a massive 40x30 shed, and a 30x40 concrete pad with an electric pole—ideal for future projects or hobbies. This is more than a home; it’s a canvas of opportunity, blending significant updates with just enough room for your vision to make it truly yours. A rare find that demands a visit—schedule your tour today and see the potential unfold! Listed at appraised value.
MlsNumber: --
ListingId: 1159592


Listing Provided By: BB Real Estate, original listing
Phone: (580) 494-6046
Office Phone: (580) 494-6046
Agent Name: Melissa Kergosien
Disclaimer: Copyright © 2025 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