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;

13501 E 243rd Street S
Porum, OK 74455
Sandra Flaaskog with Chinowth & Cohen, original listing - (918) 392-0900

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $571,800
Beds: 1
Baths: Full: 2
Status: Active
SqFt: 1375 Square Feet
Agency: Chinowth & Cohen
Agency Phone: (918) 392-0900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 130 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1965
Notes: Discover the perfect balance of modern luxury and rustic charm in this fully remodeled rock farmhouse on 130 m/l pristine acres. This extraordinary 1-bedroom home with a loft has been transformed from a 4-bedroom residence into an elegant retreat, featuring an open-concept design with 14-foot ceilings in the living room and breathtaking river views from the dining room, living room, bedroom, and 20-foot deck surrounded by large trees for plenty of shade to keep cool all summer. The state-of-the-art kitchen is a chef's dream, equipped with a six-burner commercial-style propane range, a microwave that doubles as a broiler and convection oven, a 55-<br /> inch stainless steel sink with dual gold commercial-style faucets, black granite countertops, and a 10-foot island with bar seating for six. This space is perfect for both everyday meals and grand entertaining. Having great water pressure makes cleaning and showering wonderfully exhilarating. And the central vacuum within wall dust pans is a time saver. A new 3 car garage and a barn with a storage area and a storm cellar. A great hide-a-way,<br /> retirement home, Airbnb, hunting lodge or weekend retreat with high-speed fiber optic Wi-Fi, all in a <br /> peaceful setting. Must see to appreciate the efficient contemporary modern rock house.
MlsNumber: --
ListingId: 2437859


Listing Provided By: Chinowth & Cohen, original listing
Phone: (918) 707-1970
Office Phone: (918) 392-0900
Agent Name: Sandra Flaaskog
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