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

15965 Cimarron Trail
Mcloud, OK 74851

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $330,000
Beds: 4
Baths: 3
Status: Pending
SqFt: --
Agency: 405 Home Store LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2024
Notes: *SELLER IS OFFERING $5,000 INCENTIVE MONEY TO BE USED FOR UPGRADES, CLOSING CLOSTS OR RATE BUY DOWN. * Welcome to your dream home in the heart of the new Falcon Point Addition in McLoud! This 4-bedroom, 3-bath stunner, crafted by an award-winning builder, is a true masterpiece that marries style and functionality. Step into a spacious 1922 square feet of pure comfort, where every corner tells a story of thoughtful design. The home boasts a generous 4-car garage featuring a drive through and workshop area, ensuring ample space for your vehicles and storage needs. Nestled on an expansive .70-acre MOL, the outdoor possibilities are endless – a canvas for your imagination! Whether it's hosting neighborhood BBQs or enjoying starlit nights, this property is your personal sanctuary. The Falcon Point Addition is a burgeoning community, and you'll be at the heart of it all. Revel in the convenience of nearby amenities while still savoring the peace and quiet of suburban living. This home isn't just a place; it's a lifestyle. Picture lazy Sunday afternoons on your porch, watching the world go by. With a layout that effortlessly balances openness and privacy, it's perfect for entertaining friends or cozy family nights in. Seize the opportunity to own a piece of Falcon Point's finest. Your new chapter begins here – where comfort, style, and community converge. Don't miss out on this rare gem! Call now to schedule your showing and make this house your home.
MlsNumber: 1088518


Listing Provided By: 405 Home Store LLC, original listing
Name: 405 Home Store LLC
Phone: (405) 627-5236
Office Name: 405 Home Store
Office Phone: (405) 627-5236
Agent Name: Nichole Noel
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