View Listings Listing
Unknown column \'p.agent\' in \'on clause\' SQL=SELECT p.*, a.id AS agentid, a.name AS agent, a.user AS user, c.name AS company, c.id AS companyid, t.name AS type, p.type AS typeid \n FROM fm_hp_properties AS p, fm_hp_companies AS c\n LEFT JOIN fm_hp_agents AS a ON p.agent = a.id\n LEFT JOIN fm_hp_prop_types AS t ON p.type = t.id\n LEFT JOIN fm_hp_featured AS f ON f.property = p.id\n WHERE p.published=\'1\' AND p.approved=\'1\' AND t.published=\'1\'\n AND a.company=c.id\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW()) AND p.id=\'57\'\nORDER BY p.name asc\nLIMIT 0, 9999Warning: Invalid argument supplied for foreach() in /home/fsbomari/public_html/components/com_hotproperty/functions.hotproperty.php on line 80
westerly 1985 griffin
New 2004 yanmar diesel 2 cyl, 20 hp...central a/c,holding tank,pressure water 40 gal.,fuel 40 gal,roller furling,7' by 8' bimini with dodger new,new paint all, price $22,000 for quick sale or beast offer. available for day cruse $200 or week cruise $800 in marathon to key west/key largo capt. included
Warning: Invalid argument supplied for foreach() in /home/fsbomari/public_html/components/com_hotproperty/hotproperty.html.php on line 606
Send Inquiry / Make an appointment