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

366280 E 5600 Road
Terlton, OK 74081
Judy Ogden with Platinum Realty, LLC., original listing - (888) 220-0988

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 4
Baths: Full: 2
Status: Active
SqFt: 3453 Square Feet
Agency: Platinum Realty, LLC.
Agency Phone: (888) 220-0988

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: This gorgeous 3,453 sq ft home sits on 5 acres, has 4 bedrooms, 2 baths, detached 3 car/shop, 2 living areas and a theater room. The home has beautiful wood floors and crown molding throughout. 3 bedrooms, including massive master en-suite, all w/ walk-in closets, are located downstairs. The master suite has a whirlpool tub with separate shower and double sinks. The theater room & 4th bedroom are located upstairs. 4th bedroom would also make a great office. The theater room is plumbed for a sink & has a space for a refrigerator. The kitchen has granite counter tops with beautiful cabinetry, and a walk-in pantry. The home has a wood burning fireplace with a pellet stove installed in front so you can choose which you prefer. Enjoy a large covered back deck off of the dining area. The home has 3 HVAC units, 2 septic systems on the property, 2 separate electric meters & 2 internet connections. Added since 2023: 25 X 35 1 bedroom guest house w/full kitchen & bath, & separate fenced yard. All appliances remain in the guest house including the refrigerator, stack unit washer & dryer. 3 car detached/30 X 50 Shop with 3 EOHD. 10 x 20 above ground storm shelter has 8" thick walls, electric & heat/air. Currently being used as an office, gym & game room, the 20 X 30 building has spray foam insulation w/attached dock, on the pond. There are so many possibilities for business or entertaining. The 13-15’ deep pond w/waterfall is stocked with bass, catfish & blue gill perch. Well house w/well dug to the aquifer was used to fill the pond. Basketball court/Pickleball court. Electric gate. Shed. Property could be multi-family property or an income producing opportunity. Home is less than 5 miles to Lake Keystone and approximately 30 min to Tulsa with easy access to Hwy 412 & Hwy 51.
MlsNumber: --
ListingId: 2506427


Listing Provided By: Platinum Realty, LLC., original listing
Phone: (918) 630-0702
Office Phone: (888) 220-0988
Agent Name: Judy Ogden
Disclaimer: Copyright © 2025 MLS Technology, 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