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

3735 Peaceable Rd
Mcalester, OK 74501
Tim Diehl with Southeastern Oklahoma Realty, original listing - (918) 424-3264

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,149,000
Beds: 5
Baths: Full: 4, ½: 1
Status: Active
SqFt: 4671 Square Feet
Agency: Southeastern Oklahoma Realty
Agency Phone: (918) 424-3264

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 24 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2006
Notes: This wonderful custom home sits on 25 beautifully manicured acres where deer and other wildlife frequent the open pastures. The mediterranean style residence boasts 5 bedrooms and 4.5 bathrooms and offers privacy while also having breathtaking views from every window. As you enter the residence the living area is bathed in natural light, every corner emits an aura of elegance, striking the perfect balance between warmth and contemporary. Custom amenities such as 12ft ceilings, crown molding, hardwood flooring, as well as high-end lighting create a grandeur of excellence. The master suite is a haven of relaxation with a large aquatic tub and duel walk in closets. All bedrooms are conveniently located downstairs, leaving an upstairs theater/ game room perfect for watching movies or playing a game of pool. The commercial grade kitchen rounds out this magnificent home and features such as; J Rambo cabinets, Viking appliances, huge island, breakfast nook and impressive pantry. Land: This property is approx. 80% open and can be bailed yearly for hay production. This highly productive pasture would also be ideal for running a few cattle or horses. There is one pond and two creeks that meander through the property providing year around water for livestock and the native wildlife population. There is several spots of standing hardwood timber that would be ideal for a stand and feeder. Game: Whitetail deer and Eastern Wild Turkey are plentiful on the property. Pittsburg County is the #1 county in the state for total deer harvest and also boasts several typical and non-typical Boone and Crocket deer. Barns: Property has 2 barns one is 1,200 square feet with (2) 600 square feet lean to's attached to each side for equipment storage. The other is an 800 square ft barn that was previously used for show animals and is equipped with power and water.
MlsNumber: --
ListingId: 11320439


Listing Provided By: Southeastern Oklahoma Realty, original listing
Phone: (918) 424-3264
Office Phone: (918) 424-3264
Agent Name: Tim Diehl
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App