SELECT pro.lon, pro.lat,pro.meta_title, pro.viewType, pro.meta_description, pro.meta_keywords, pro.type_id, pro.project_area, pro.launch_date, pro.country_id,pro.new_amenities,pro.location_map, pro.payment_plan, pro.highlights, pro.property_usp,pro.site_plane,pro.locationmap_image,pro.markup_text,
                            ptype.type as propertyType,pctype.type_category as propertyTypeCategory, city.id as cityId, city.city as cityName,
                            dev.id as developerId, dev.name as developer,dev.description,dev.logo as developerLogo, 
                            pro.possession_date,pro.new_overview,pro.property_name, pro.property_name_display,tsr_unit_type.type as unit ,pro.id as ProjectId,
                            pro.booking_status,pro.bedrooms,loc.location,pro.project_status_id,tsr_project_status.name as ProjectStatus, loc.id as locationId, subloc.cluster as sublocation, subloc.id as sublocationId, 
                            MIN(CAST( prices.size AS SIGNED )) AS minSize,MAX(CAST( prices.size AS SIGNED )) AS maxSize, 
                            CAST(prices.TYPE AS SIGNED ) AS setType, MIN(CAST( REPLACE( prices.amount, ',', '' ) AS SIGNED ) ) AS minPrice, 
                            MAX( CAST( REPLACE( prices.amount, ',', '' ) AS SIGNED ) ) AS maxPrice, MIN( prices.amount ) AS minStaticAmount,
                            MAX( prices.amount ) AS maxStaticAmount, pro.rating,proExtn.propertyId as prorityProId,proExtn.project_usp,proExtn.airportDistancePriroty,
                            proExtn.railwayStationPriroty,proExtn.metroStationDistancePriroty,proExtn.busStopDistancePriroty,
                            proExtn.highwaydistancePriroty,proExtn.schoolCollegeDistancePriroty,proExtn.hospitalDistancePriroty,
                            proExtn.mallDistancePriroty,proExtn.bankAtmDistancePriroty,proExtn.restaurantsDistancePriroty,

                            pro.airport_distance,pro.railway_station_distance,pro.metro_station_distance,
                            pro.busstop_distance,pro.highwaydistance,pro.schoolCollege_distance,pro.hospital_distance,
                            pro.mall_distance,pro.bankAtm_distance,pro.restaurants_distance,
                            pro.airportDistanceUnit,pro.railwayStationDistanceUnit,pro.metroStationDistanceUnit,pro.busStopDistanceUnit,
                            pro.highwaydistanceUnit,pro.schoolCollegeDistanceUnit,pro.hospitalDistanceUnit,pro.mallDistanceUnit,pro.bankAtmDistanceUnit,
                            pro.restaurantsDistanceUnit,
                            proExtn.*
                            FROM tsr_properties  as pro INNER JOIN tsr_types as ptype ON pro.type_id=ptype.id 
                            LEFT JOIN tsr_properties_extn as proExtn ON pro.id=proExtn.propertyId
                            left join tsr_project_status on pro.project_status_id  = tsr_project_status.id
                            inner join tsr_unit_type on pro.unit_type = tsr_unit_type.id
                            INNER JOIN tsr_types_categories as pctype ON pro.cat_id=pctype.id INNER JOIN tsr_locations loc ON pro.loc_id=loc.id 
                            INNER JOIN tsr_cluster subloc ON pro.cluster_id=subloc.id INNER JOIN tsr_cities as city ON pro.cty_id=city.id 
                            INNER JOIN tsr_developers dev ON pro.devlpr_id=dev.id and dev.status=1 and loc.status=1 and loc.status=1 and pro.status=1 
                            LEFT OUTER JOIN tsr_prices prices ON pro.id=prices.propty_id   and prices.amount!='On Request' WHERE pro.is_show_type!=2 and pro.is_show_type!=2 and pro.id=1497 GROUP BY pro.idDDD