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

5721 County Road 3470
Ada, OK 74820
Cindy Johnson with Johnson Realty, LLC, original listing - (580) 272-7820

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,000
Beds: 2
Baths: Full: 2
Status: Active
SqFt: 1500 Square Feet
Agency: Johnson Realty, LLC
Agency Phone: (580) 272-7820

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 185 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2011
Notes: 185 Acre Cattle or Horse Ranch with a nice 2-story, 2 bedroom, 2 bath metal home, complete with 2-car attached oversized garage with work area and 2-car attached carport. As you walk into the home from ground level, you will enter the downstairs living area. This level also has one nice sized bedroom and bathroom. Upstairs, you will find an open floor plan with spacious amenities for the kitchen (being remodeled), dining area and main living room. The oversized primary bedroom is a nice surprise. It is large enough to have a sitting area to enjoy the beautiful sunsets and includes a nice newly remodeled bathroom. The primary bedroom is large enough to make a 2nd bedroom out of it. From your balcony you can watch over your livestock or watch the deer and turkey as they strut through. Property has good perimeter fencing and is cross fenced and each pasture has its own pond. There are a nice set of working pens and the head gate will remain with the property. Property has a nice 50 x 70 hay and equipment barn plus a 48 x 20 concrete floored horse barn, with thick oak walls and a chicken coop. The property is approximately 80-85% cleared, with plenty of woods to hunt and get your trophy buck. The 2-man deer stand will stay. This multi-purpose property checks all of the boxes with its vast land. You can ride your horses, 4-wheelers or ATV, hunt, fish, run your livestock and just have the best life!! There are 6 ponds and 2 are stocked. The property offers a private setting with a 1/2 mile well maintained rock drive way leading up to the house and barns which is situated on a hill top. In addition, there is an adorable 38 x 16 second home on the north side of the property. Open floor plan with 1 bed., 1 bath, & utility room. Great for older parents, adult children or rent it out for additional income. The main home has paved road frontage.
MlsNumber: --
ListingId: 11330940


Listing Provided By: Johnson Realty, LLC, original listing
Phone: (580) 759-3700
Office Phone: (580) 272-7820
Agent Name: Cindy Johnson
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