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
$199,900312 Christy RdEighty Four PA 15330View Listing
$195,0006072 State Route 88Finleyville PA 15332View Listing
$150,0004050 4024 Castor Ln Lot 15Finleyville PA 15332View Listing
$95,0004051 Castor Ln Lot 13Finleyville PA 15332View Listing
$75,000159 Vance RdBurgettstown PA 15312View Listing
$56,900124 Dyers Stone DrEighty Four PA 15330View Listing
$44,900234 Patterson RdFinleyville PA 15332View 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-18-2024 1:18:33 pm.