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

19425 Se 125th Street
Mcloud, OK 74851

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $399,900
Beds: 2
Baths: 2
Status: Pending
SqFt: --
Agency: RE/MAX At Home

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 5 acre(s)
Property Type: Residential
Year Built: 2023
Notes: 50k PRICE REDUCTION! Stunning New Modern Farmhouse on 5 acres with a beautiful, serene atmosphere! Enjoy the Oklahoma sunrises & sunsets on the wraparound covered porch overlooking a pond w/ island for fishing, an open concrete patio w/ firepit & large mature Oak trees. Inside this ADA compliant home, you will find Custom hand sanded cabinets, solid oak barn doors, oak shutters, solid oak trim, all made from Oak trees on this property. The light & bright kitchen offers stainless steel stove & dishwasher, including vent hood, stainless steel farmhouse sink, white custom cabinets, stained open shelving, a large island w/ trash drawer, pull out cutting board, & plenty of seating & a large pantry. A huge primary suite, w/ more remarkable views, includes a walk-in closet, built-in dressers for 2, walk-in shower w/ seat & rain faucets, modern freestanding soaker tub, double sinks & LED mirrors w/ anti-fog feature. This is a unique opportunity to own a brand-new home w/ exceptional features. Just a few of the amenities you will find are, 2 full RV hookups, 2 septic's, 2 water wells, 2 electric meters, a commercial water heater, stained concrete flooring, safe room, laundry drawer in utility room, 330 cubic yards of concrete & open entertaining areas, energy efficient-Green HVAC air handler flex 5-ton heat pump, approx. 28K. This would make a great family home or VRBO, you would call Paradise! Very well insulated home R30 walls and R40 insulation in the ceilings.
MlsNumber: 1094954


Listing Provided By: RE/MAX At Home, original listing
Name: RE/MAX At Home
Phone: (405) 708-6691
Office Name: RE/MAX at Home
Office Phone: (405) 708-6691
Agent Name: Mary Walker
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