Instructions: To view address of a building, please put your mouse over on one of the blue squares. To find more information about that building including floorplans, listings, pictures, common areas please click the blue sqaure of the specific building.
SELECT id,name,address,no_of_suites,no_of_levels,streetno,streetname,add_date,age, directory,builtyear,strata_planno,constructiontype,zip,primary_id,cat_id,regionid FROM building WHERE cat_id=1 And regionid=g10 ORDER BY cat_id,name
