Title Page Background
DEBUG FN args: Array ( [0] => 2188 [1] => [2] => [3] => agent ) BEFORE: Site: 2188 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2188 Igate: njhud LocID: 2188 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2188 [1] => [2] => [3] => lender ) BEFORE: Site: 2188 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2188 Igate: njhud LocID: 2188 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2188 [1] => [2] => [3] => other ) BEFORE: Site: 2188 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2188 Igate: njhud LocID: 2188 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 ('alhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

104867 S Pimlico Pass
Mcloud, OK 74851

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $349,900
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: 405 Home Store

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: Builder is currently offering $5000 incentive money for buyer to use towards closing cost, upgrades, or to buy down your rate!! <br /> Get ready to embark on a new adventure in the secluded Preakness Trails addition in McLoud! Nestled amidst 2 acres of picturesque countryside, this soon-to-be-completed home is your ticket to the ultimate blend of tranquility and excitement.<br /> <br /> With 4 bedrooms and 3 bathrooms spread across 1877 square feet of modern living space, there's plenty of room for you and your loved ones to spread out and make unforgettable memories.<br /> <br /> As you explore the thoughtful layout, you'll find delightful surprises at every turn. The owner's suite boasts a charming bay window, perfect for basking in the warm sunlight with your favorite book or simply enjoying the scenic views.<br /> <br /> And let's not forget the secondary suite, complete with its own private bath—ideal for guests or family.<br /> <br /> But the real adventure begins outside! Picture yourself tinkering away in the 3-car garage with a convenient drive-through workshop area, where you can indulge your passion for DIY projects or simply tinker with your toys.<br /> <br /> Looking to expand your horizons even further? Ask us about adding a 30x40 shop to your property for $22,500! Complete with a concrete slab, moisture barrier insulation, overhead door, and side door, this space is perfect for storing your outdoor gear, pursuing your hobbies, or turning into the ultimate DIY escape! <br /> <br /> Experience the best of both worlds with country living just a stone's throw away from city conveniences. Don't miss your chance to make this dream home yours—contact us today to learn more and start planning your next great adventure! Estimated completion summer of 2024. Estimated completion is beginning of July.
MlsNumber: --


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