SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "PA" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 14
Blah
$275,0001718B Upper RdShamokin PA 17872View Listing
$219,900Woodland Dr Lot 3ADanville PA 17821View Listing
$179,000Woodland Dr Lot 1ADanville PA 17821View Listing
$162,450St # ROUTE61Mount Carmel PA 17851View Listing
$159,900Homestead Ct Lot 17Danville PA 17821View Listing
$159,000Warren Rd Rd Lot 2Milton PA 17847View Listing
$159,000Warren Rd Rd Lot 3Milton PA 17847View Listing
$159,000Warrens Rd Lot 3Milton PA 17847View Listing
$159,000Welsh Rd Lot 16Danville PA 17821View Listing
$159,000Warrens Rd Lot 2Milton PA 17847View Listing
$155,000Terre Ln Lot 38Danville PA 17821View Listing
$149,900Circle View DrElysburg PA 17824View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-17-2024 3:33:49 pm.