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 = 2287 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2287 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 = 2287 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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;

704 N Liberty Street
Shamokin, PA 17872
John Rainville with BrokersRealty.com, original listing - (717) 554-7430

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $750,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: BrokersRealty.com
Agency Phone: (717) 554-7430

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1900
Notes: Former Bader's Fine Furniture <br /> Former Bader's Fine Furniture Buildings - Store Building and 2 separate brick and concrete block warehouse buildings.<br /> <br /> Store Building Breakdown on sq ft.:<br /> <br /> 1st floor 6,230.<br /> <br /> 2nd floor 6,270.<br /> <br /> 3rd floor 3,399.<br /> <br /> 4th floor 3,399<br /> <br /> Total GBA 19,298<br /> <br /> Yard Buildings:<br /> <br /> Warehouse 1 6,026.<br /> <br /> Warehouse 2 4,590. 2,500 lb freight elevator with access to all levels of the building.<br /> <br /> .70 acre lot<br /> <br /> Permitted Uses:<br /> <br /> Apartment Building, Auto Related, Cross Dock/Truck Terminal, Funeral Home, Hotel/Motel, Manufacturing, Medical, Other/General Retail, Professional, Religious Facility, Restaurant/Bar, School, Supermarket/Grocery Store, Warehouse Buyer’s check zoning for specific details<br /> <br /> Tax parcel numbers 016-01-008-145, 016-01-008-146, 016-01-008-146A, 016-01-008-146B, 016-01-008-144, 016-01-008-207, 016-01-008-175, 016-01-008-175A
MlsNumber: --
ListingId: PANU2001598


Listing Provided By: BrokersRealty.com, original listing
Phone: (717) 554-7430
Office Phone: (717) 554-7430
Agent Name: John Rainville
Disclaimer: Copyright © 2024 Bright MLS. 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