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;

428532 E 1150 Road
Porum, OK 74455
Pam Barton-Stober with Providence Realty East, original listing - (405) 833-5005

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $827,327
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 2287 Square Feet
Agency: Providence Realty East
Agency Phone: (405) 833-5005

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2004
Notes: THIS IS THE ONE YOU HAVE BEEN WAITING FOR!! 3 BED, 2 BATH, 2 CAR GARAGE WITH PRIVATE 2 SLIP DOCK, 1-BOAT LIFT & 40x50x14 SHOP!! THIS LAKE FRONT PROPERTY IS LOCATED IN THE POPULAR "PORUM LANDING" AREA! SANDY BEACHES located all cross the shoreline from this property! To top it off this is a NON-HOA LOCATION! Home is tucked away in the small addition of Island View Estates 2 with plenty of room for your own personal touches or even add additional storgae buildings and there is plenty of space for all your guests parking! Large windows allow natural lighting and magnificnet views to the Lake from the kithen and living room! Large open rear deck great for entertaing family and friends! Deck also has a electrical box already installed and is ready for your own hot tub for those cool nights to relax out doors! Deck has recently been coated, new gravel has been spread for the circle driveway and property is move-in ready! The 40x50x14 insulated shop concrete slab, electricity and enough space for all your toys including a large garage door for easy access. This property is across from a well known hangout spot called "The Cut" which is a short boat trip away! Located in a prime location for fishing, boating and all your Lake recreatonal needs. This custom built home is filled with several personal touches including custom wood work throughout home & a oversized custom walk-in shower! DON'T MISS THIS ONE & CALL TODAY TO SETUP A SHOWING TIME TO VIEW THIS HOME!!<br /> REF REALTOR REMARKS FOR ADDITONAL DETAILS.
MlsNumber: --
ListingId: 1136565


Listing Provided By: Providence Realty East, original listing
Phone: (405) 833-5005
Office Phone: (405) 833-5005
Agent Name: Pam Barton-Stober
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