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 = 2158 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 2158 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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 = 2158 AND i.igate IN ('usahud','mohud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mohud', 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;

19743 E County Road 179
Olustee, OK 73560
Jordan Medlock with Chamberlain Realty LLC, original listing - (405) 300-0543

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 4
Baths: Full: 4, ½: 1
Status: Active
SqFt: 5219 Square Feet
Agency: Chamberlain Realty LLC
Agency Phone: (405) 300-0543

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 480 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2017
Notes: Custom Country Home on 480 ACRES with Waterfront Views. This 4 bedroom 4.5 bathroom house has 2 living spaces, 3 fireplaces, 3 car garage, and a fitness room. As you enter the home you will notice the custom wood-look tile and the custom cabinetry in the office space. From the vaulted pine wood ceilings, wall of windows, custom chandelier, and refurbished wood wall this living room has it all! The kitchen boasts a large gas oven, warming drawer, granite countertops, 2 sinks, hidden coffee bar, copper fixtures and backsplash, pull out tv cabinet, walk in pantry, and an eat in island. The master is greatly sized with its own electric fireplace, exterior access, 2 large closets-1 which is an 8x8ft safe room, walk-thru-shower, whirlpool tub, separate sinks and toilets, and heated towel racks. Down the hall you will find the first bedroom which has a custom sit-in window bench, its own bathroom and walk in closet. The next bedroom is also greatly sized with its own full bathroom and walk in closet. You will then find the second living space and second kitchen with a walk in pantry. This area also has its own private patio and garage access. The 4th bedroom is located off of the secondary kitchen and also has a large closet and bathroom. The back porch has a built-in kitchen, an outdoor wood burning fireplace, and brand new fencing. Near the house is the 6 acre fishing pond that has been stocked with largemouth bass that are 6-8lbs. Across from the pond is a one room cabin that is fully furnished with a kitchen and bathroom.  Next is the 60x60ft barn with electricity/water and lean to on both sides. The 480 acres are set up for cattle which 175 of those have been drilled in wheat, and have 5 strand barbed wire fencing and metal posts throughout. There are many interior fences for rotational grazing, a cow barn, working pens, and a chute. There are 4 ponds total on property. The largest being the waterfowl roosting pond that is 18 acres and can be seen from the back porch!
MlsNumber: --
ListingId: 1147354


Listing Provided By: Chamberlain Realty LLC, original listing
Phone: (405) 300-0543
Office Phone: (405) 300-0543
Agent Name: Jordan Medlock
Disclaimer: Copyright © 2024 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