SELECT *,'officeportal' FROM (select * from redbcalgary.rets_property_listing WHERE PublicRemarks LIKE '%rockwood%' AND ListPrice >'0' AND IBGTable<>'cal' AND IBGShowOnPortals='Y' ORDER BY ListPrice DESC LIMIT 0,12) a UNION ALL select *,'op' FROM (SELECT * FROM redbcalgary.excl_property_listing WHERE PublicRemarks LIKE '%rockwood%' AND ListPrice >'0' AND IBGTable<>'cal' AND IBGShowOnPortals='Y' ORDER BY ListPrice DESC LIMIT 0,12) b Real Estate Listings: Homes For Sale

Showing 0 Results