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

20288-2 State Highway 63
Hodgen, OK 74939
Natasha Butler with Shockley-Cooper Realty & Auctions, original listing - (918) 564-2299

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $249,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 936 Square Feet
Agency: Shockley-Cooper Realty & Auctions
Agency Phone: (918) 564-2299

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: Mountain Retreat with Custom NEW BUILD Home – 2.6 Acres in Big Cedar, OK<br /> Escape to nature with this 2.6-acre property in Big Cedar, OK, featuring a custom new build home with a 4-6 month build time. Bordering the Ouachita National Forest, this property offers direct access to hiking, hunting, fishing, and ATV trails. With mature pines, a private pond, and stunning mountain views, it’s the perfect retreat for privacy, adventure, and relaxation.<br /> <br /> The 936 sq. ft. home boasts an open-concept living and dining area with 9-ft ceilings, hand-textured walls, and a ceiling fan. The galley-style kitchen features granite countertops, shaker-style soft-close cabinets, and stainless steel appliances, including an electric range, microwave, refrigerator, and garbage disposal. The primary suite offers 8-ft ceilings, a walk-in closet, and a private bath with a steel tub, tiled walls, and a granite vanity, while the second bath mirrors the master. Luxury Vinyl Plank (LVP) flooring runs throughout for a modern, durable finish.<br /> <br /> Designed for comfort and efficiency, the home includes a 3-ton electric HVAC system, a 40-gallon water heater, and a utility room for a full-size washer and dryer. Covered front and rear porches with 6x6 cedar posts provide a perfect space to relax, while board and batten siding and an impact-resistant architectural shingle roof ensure lasting durability.<br /> <br /> This secluded yet accessible property is ideal as a vacation home, investment, or full-time residence. Enjoy modern comfort in Oklahoma’s scenic wilderness and start building your dream retreat today.
MlsNumber: --
ListingId: 1079342


Listing Provided By: Shockley-Cooper Realty & Auctions, original listing
Phone: (918) 564-2299
Office Phone: (918) 564-2299
Agent Name: Natasha Butler
Disclaimer: Copyright © 2025 Western River Valley Board of REALTORS®. 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