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

51399 104th Street
Stratford, OK 74872
Cindy Johnson with Johnson Realty, LLC, original listing - (580) 272-7820

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,500
Beds: 3
Baths: Full: 3
Status: Active
SqFt: --
Agency: Johnson Realty, LLC
Agency Phone: (580) 272-7820

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Garage: Garage
Property Type: Residential-Mobile Home
Year Built: 2000
Notes: CAR ENTHUSIASTS, BUILDERS, HOBBYIST & MORE, THIS PLACE CHECKS THE BOXES with it's Shop Buildings and Beautiful 15.02 Acre treed setting with a Spectacular 3 bedroom, 3 bath home. The home has approx. 2,828 SF with a spacious kitchen and an abundance of counter space & cabinets. There is also a built-in desk, pantry and China Hutch. For your eating enjoyment, there is an eat-in bar, breakfast nook and a separate dining room providing lots of seating for eating! This home has amazing storage and closet space throughout. The oversized Living Room is great for entertaining with it's beautiful fireplace or you can just snuggle up on those chilly nights. In addition, there is a smaller living area, which also has a kitchenette. The large primary bedroom has a full ensuite bathroom with two vanities and storage cabinet. The home features a large theatre room/workout room with a closet and shelving for games, entertaining & electronics. This flex room can easily be converted into additional bedrooms, if needed. Enjoy sitting on your covered front porch or your covered back deck overlooking the pond. Speaking of the Work Shops, there are 4 really nice concrete floored metal shop buildings measuring approximately 20 x 30; 20 x 40; 20 x 40; 42 x 55; and an older 2,436 SF (dirt floor) shed-type building (mostly enclosed), which was used to store electrical materials. The shop buildings were built for collector cars, race cars, motorcycles and other hobbies. They all have multiple overhead doors. One building has a kitchen w/lots of cabinets, counterspace & a bathroom, which could be used as living quarters. The 42 x 55 shop has 6" re-enforced concrete for all the cars that it held. Bolts are remaining from previous lift. There are metal pegboards for hanging tools or bins and it also plumbed for a utility sink. There is a 2-car & a 3-car detached carport. This is a great place to entertain, gather, grow your family and make magical memories. Call today!
MlsNumber: --
ListingId: 11344082


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