/zoekresultaat/poi/Het+Gooi/0/-/?c=SELECT l.listing_id as lst_id, l.*, ( 6371 * acos( cos( radians( 52.272778 ) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians( 5.242222 ) ) + sin( radians( 52.272778 ) ) * sin( radians( latitude ) ) ) ) AS distance FROM listings as l HAVING distance < 8.0 AND l.listing_state = ''##