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=\'72\'\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
1998 Wellcraft 23 Wakaround Cuddy Cabin
Like new 1998 Wellcraft cuddy cabin walkaround with less than 50 hours estimated. Boat has hard top and enclosure with rocket launchers, raw water washdown,Water fuel seperator,fuel capacity is 100 gallons, 20 gallon bait well, fresh water on board, Vacuflush head with septic tank and overboard dump, onboard stove, never used, sink with pressure on demand pump, fishwell pump outs, windshield wiper. This boat has a 200 HP evenrude engine Also equipted with a LMS 350a GPS and deph finder combo, Trailer is alum. with hub washdowns and surge brakes. Trailer will acommadate a much larger boat. Working status does not allow enough time to use. This is a great buy at 25600.00. Call my office and ask for Ken at 704-279-5736 or my cell phone anytime at 704-791-8183. Other pictures available upon request. Please send your email address.
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