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

16881 E 4220 Road
Claremore, OK 74017
Kathy Geyer with OklaHomes Realty, Inc., original listing - (918) 341-2800

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,325,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2325 Square Feet
Agency: OklaHomes Realty, Inc.
Agency Phone: (918) 341-2800

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 43 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1948
Notes: Stunning Equestrian Ranch on 44 Acres<br /> <br /> Discover a true haven for horse lovers and families alike with this exceptional 44-acre +/- equestrian ranch. This beautifully appointed 2,325 sq. ft. home offers 3 bedrooms, 3 bathrooms, and a perfect blend of comfort and southern charm. The living room has a brand new Hearthstone energy-efficient catalytic wood-burning stove and is enveloped in stunning wood floors and ceilings. A circular staircase climbs to the loft which could be an office, playroom, or hobby space. The kitchen has beautiful granite counters and a breakfast bar for gathering. The formal dining has large windows with ideal views of the property. A comfortable primary suite features two large walk-in closets. When chores are done, picture yourself in the rocker with a sweet tea on the lovely front porch, watching the Oklahoma sunset. Outbuildings include barns and shops: 40x60 red iron building with 4 large high quality MD foaling stalls, wash rack with a hot water tank, vet area, and complete living quarters. 36x60 barn with new roof, 8 stalls, tack room, wash rack/vet area, and a new hot water tank. 30x40 hay barn with new doors. 30x36 barn currently has 4 large stalls. 50x60 barn with 12' covered overhangs on each side. This building has its own water and electric meters, lights are all controlled by timers, and the indoor pen currently has 2 stalls and rooms for 20 more. Perimeter of the property is fenced and cross-fenced. All pastures have water and shelter. The property is in an ideal location, 5 miles from the Will Rogers Turnpike (I-44); less than 10 miles from the town of Claremore; less than 7 miles from the Cherokee Casino & Will Rogers Downs horse racing track; 6 miles from the Claremore Regional Airport; less than 40 miles from Tulsa. Must see this beautiful , comfortable, detailed property, meticulously maintained just for you and your family!
MlsNumber: --
ListingId: 2441152


Listing Provided By: OklaHomes Realty, Inc., original listing
Phone: (918) 698-2644
Office Phone: (918) 341-2800
Agent Name: Kathy Geyer
Disclaimer: Copyright © 2024 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.


Local Real Estate Expert

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 = 2191 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;
Carolyn Blecha-McClary
ASCIISolid Rock Realtors
Call Today!: (918) 639-8875

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App