SELECT `o`.*, `p`.*, `c`.* FROM `options` AS `o`, `plans` AS `p`, `communities` AS `c` WHERE `o`.`options_status` != "0" AND (`p`.`plans_id` = `o`.`options_plans_id` AND `p`.`plans_status` != "0") AND (`c`.`communities_id` = `o`.`options_communities_id` AND `c`.`communities_status` != "0")
HOME FINDER
Select a location, community or price.