You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' -2.000000)) < 250) 
               GROUP BY `street_number`' at line 1SELECT  
               MIN(`suite_no`) AS min_suite, 
               MAX(`suite_no`) AS max_suite, 
               COUNT(*) AS count,  
               street_number, 
               street_name,
               COUNT(DISTINCT(suite_no)) AS suites,
               GROUP_CONCAT(listingid) as mls_sources,
               GROUP_CONCAT(subarea) as subarea,
               GROUP_CONCAT(city) as city,
               GROUP_CONCAT(street_dir) as street_dir,
               GROUP_CONCAT(street_name) as street_name,
               GROUP_CONCAT(complex) as complex,
               GROUP_CONCAT(street_type) as street_type,       
               GROUP_CONCAT(postalcode) as postalcode,
               GROUP_CONCAT(area) as area,
               GROUP_CONCAT(yearbuilt) as yearbuilt,
               GROUP_CONCAT(construction) as construction,
               GROUP_CONCAT(bylaw_restrictions SEPARATOR '|') as bylaw_restrictions,
               GROUP_CONCAT(amenity SEPARATOR '|') as amenity,
               GROUP_CONCAT(maint_fees_inc SEPARATOR '|') as maint_fees_inc,
               GROUP_CONCAT(units_in_development) as units_in_development,
               GROUP_CONCAT(units_in_strata) as units_in_strata,
               GROUP_CONCAT(levels) as levels,
               GROUP_CONCAT(`lat`) as lat,
               GROUP_CONCAT(`lng`) as lng,
               GROUP_CONCAT(internal_building_id) as internal_building_id
               FROM pixilink_mlsr.mlsr_listings_master
               WHERE strata_no = 'LMS4590'
               AND class = 2 and suite_no <> ''
               and city = 'VANCOUVER'
               and area = 'VANCOUVER EAST'
               and (postalarea = 'V5N' OR st_distance_sphere(GeomFromText(CONCAT('POINT (', lng, ' ', lat, ')')), point(, -2.000000)) < 250) 
               GROUP BY `street_number`