Title Page Background
DEBUG FN args: Array ( [0] => 2165 [1] => [2] => [3] => agent ) BEFORE: Site: 2165 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2165 Igate: njhud LocID: 2165 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2165 AND i.igate IN ('okhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2165 [1] => [2] => [3] => lender ) BEFORE: Site: 2165 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2165 Igate: njhud LocID: 2165 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2165 AND i.igate IN ('okhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2165 [1] => [2] => [3] => other ) BEFORE: Site: 2165 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2165 Igate: njhud LocID: 2165 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2165 AND i.igate IN ('okhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

47447 Mead Road
Heavener, OK 74937

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $545,000
Beds: 4
Baths:
Status: Active
SqFt: 2948 Square Feet
Agency: United Country-Mixon Realty & Auctions

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 20 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: Country Home - Shop - Land - National Forest Location: This property is located in a very private and secluded country setting about 2.5 miles East of the small community of Hodgen, Oklahoma. The property is nestled in a beautiful valley setting at the base of Walker Mountain with property frontage to the 1.5 million acre Ouachita National Forest which offer great hunting opportunities for whitetail deer, eastern wild turkey, black bear and wild hogs as well as an impressive network of hiking, horseback riding and ATV trails. The new property owners will enjoy the very best of country living and yet still be close to the modern conveniences that are offered in the nearby towns. The surrounding area offers many recreational activities for the outdoorsman. The property is a short drive from the Wister Lake State Park, Cedar Lake, Broken Bow Lake, Kerr Lake, Lake Eufaula and Lake Sardis. Nearby towns include Poteau, Talihina and Hochatown, Oklahoma. The property is about a 4-hour drive from Dallas, Texas. Services to Property: Rural Electricity, Rural Water, Conventional Septic System and Propane Country Home: This well-maintained home sits on 20 acres m/l and was built in 1992 and features 4 Bedrooms and 2 1/2 baths, large covered porches, updated kitchen with beautiful granite counter tops, farmhouse sink, oak cabinets and amazing wood vinyl flooring throughout, large walk in closets, safe room, and gas log fireplace. The property also includes a 1500 ft2 3 car garage, covered parking for two additional cars, and a large swimming pool. This home could be purchased as a two-family dwelling, multigenerational or extended family house with a shared kitchen. Kitchen: The updated kitchen (30 feet x 25 feet) is very spacious. This kitchen has numerous beautiful custom oak cabinets, amazing granite counter tops with lots of counter space, and a large island complete with a hood. There is also a double farmhouse sink with oil rub bronze faucets. The appliances are stainless steel and include: cook top, oven, dishwasher, and refrigerator. The kitchen is also equipped with a large pantry with numerous built in shelves and display cabinets for Knick knacks. The kitchen has a large eating bar that easily seats 4 with plenty of room to spare for meal prep. In addition, this home features the perfect size dining area for more seating. This area is spacious enough for a table with chairs and additional furnishings. The kitchen is also spacious enough for a sitting area with furnishings. Family Room: The large family room (19 feet x 24 feet) features the gas log fireplace, new vinyl distressed barn room flooring, there is a beautiful brick accent wall with 3 brick stairs leading into the kitchen. The rooms proximity to the kitchen and pool room is perfect for entertaining guest. Master Bedroom #1: (10 feet x 12 feet) Plenty of space for a king-size bed. There is an accent wall with barn wood and an exit to the deck. The floors are covered in like new high traffic carpet. The Master Bath (7 feet x 10) and (7 feet x 11) is designed perfectly for a master bath and has a separate area that can be utilized as a guest bathroom. The room is equipped with a very large single vanity and closet space with built-in shelves, hanging area and drawers. The vanity has laminate countertop, oil rub bronze faucets and the floors are covered in vinyl. There is a shower. Bedroom #2: (13 feet x 9 feet), Laundry Room (12 feet x 5 feet). Level II Living Room (17 feet x 15 feet). Bedroom #3: (12 feet x 20 feet) Bedroom #4: (11 feet x 9 feet) Bathroom #2: (6 feet x 11 feet) This home also features a utility/mud room (22 feet x 8 feet). Safe Room: There is a large safe room. Air-conditioned insulated shop with bathroom: 30-foot-wide x 50-foot-long metal shop building complete with concrete flooring, electrical wiring, and lighting. Land: There are approximately 20 acres of land that will convey with this transaction. Pond
MlsNumber: --


Listing Provided By: United Country-Mixon Realty & Auctions, original listing
Phone: (918) 839-4717
Office Phone: (918) 839-4717
Agent Name: Bob Bowman
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => le-flore [3] => OK [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: le-flore State: OK Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: le-flore State: OK Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2165 AND i.igate IN ('okhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'okhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Cody Ramsey and Kennedi Brimfield
Cody Ramsey and Kennedi Brimfield
ASCIIShockley-Cooper Realty & Auctions
Call Today!: (918) 649-7361

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App