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

22709 S Farmer Road
Fort Gibson, OK 74434
Scott W. Pace with Porches and Pastures, original listing - (918) 923-3727

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $595,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3500 Square Feet
Agency: Porches and Pastures
Agency Phone: (918) 923-3727

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: FANTASTIC 40 AC. PROPERTY. ABUNDANT WILDLIFE. PRIVATE AND SECLUDED WITH GREAT VIEWS AND LOCATED ON A DEAD END ROAD WITH GATED ENTRANCE. HUNT FROM YOUR BACK YARD. 3500 SQ.FT. 3 BEDROOM AND 2.5 BATHROOMS. HANDICAP ACCESSIBLE THROUGHOUT THE HOUSE. BEAUTIFUL LARGE KITCHEN WITH WHITE CABINETS, ISLAND BAR, 2 LARGE PANTRIES AND ALL APPLIANCED INCLUDED. LARGE FAMILY ROOM. DINING ROOM. GAME ROOM. CRAFT ROOM WITH CRAFT TABLE. FOOD STORAGE. DEN WITH BUILT IN CABINETS. XL MUD ROOM WITH WASHER AND DRYER. WOOD BURNING STOVE. AMAZING NEW MASTER SUITE WITH HUGE WALK IN CLOSETS, FIREPLACE, DOUBLE SINKS, SEPARATE SHOWER AND TUB. BUILT IN WALL SAFE. 24' X 24' DETACHED 2 CAR GARAGE WITH COVERED 2 CAR CARPORT. RV PARKING AND HOOK UP. NEWER 50' X 30' INSULATED SHOP WITH CEMENT FLOORS. GUN RANGE. NEWER STORM SHELTER.NEW GENERAC GENERATOR. WELL WITH NEW STAINLESS STEEL PUMP AND WIRING. COMMERCIAL FILTRATION WITH REVERSE OSMOSIS. 12' DOOR TO ATTACHED GARAGE. WITH TONS OF STORAGE AND WORK BENCH.OUTDOOR SHOWER. PLAYHOUSE WITH SWINGS. GREEN HOUSE. COVERED DECK. CENTRAL AIR & FORCED AIR HEATING. PROPANE TANK. BEAUTIFUL YARD WITH GARDEN AREA. A MUST SEE PROPERTY.
MlsNumber: --
ListingId: 2438817


Listing Provided By: Porches and Pastures, original listing
Phone: (801) 360-2500
Office Phone: (918) 923-3727
Agent Name: Scott W. Pace
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App