$VAR1 = { 'max_pic_ul' => '6', 'FORM' => { 'boat_id' => '33637', 'return' => 'class_search.pl?boat_type=kayak' }, 'statement' => 'SELECT boat.categ,boat.categ3,boat.boat_id,boat.manufacturer,boat.description,boat.feet,boat.inches,boat.year,boat.model,boat.state_loc,boat.country_loc,boat.boat_type,boat.material,boat.seller_telephone,boat.seller_email,boat.price,boat.trailer_year,boat.trailer_model,boat.trailer_make, SUBSTRing( MIN( CONCAT( RPAD(pic.pic_id,6,\' \'),pic.web_loc)),7) as show_image, boat.categ,boat.city_loc,boat.engine_info,boat.deck_info,boat.electronic_info,boat.date_entered,boat.date_modified,broker.broker_name,boat.broker_id,boat.price_type, boat.old_price, boat.blow_out_price, boat.beam, boat.draft, boat.displacement, boat.boat_number, boat.reg_number, boat.engine_serial_number, boat.hull_id_number, boat.draft_inches, boat.trailer_year, boat.trailer_model, boat.trailer_make, boat.boat_ref FROM classf_boats as boat, classf_brokers as broker, classf_pics as pic WHERE boat.boat_id = \'33637\' AND (boat.broker_id = \'63\')AND (boat.broker_id = broker.broker_id) AND (boat.boat_id = pic.boat_id) AND boat.cloak = 0 GROUP BY boat.boat_id ORDER BY date_modified desc', 'captcha' => '', 'boat' => { 'trailer_make' => '', 'show_image0' => 'http://www.theboatcenter.biz/boatsforsale/images/100_0527 (2)-23643.JPG', 'inches' => 6, 'draft_inches' => 0, 'trailer_year' => 'Yellow', 'draft' => '', 'reg_number' => '', 'show_image5' => 'http://www.theboatcenter.biz/boatsforsale/images/100_0528-12720.JPG', 'feet' => 12, 'show_image2' => 'http://www.theboatcenter.biz/boatsforsale/images/100_0520 (2)-82356.JPG', 'boat_ref' => '', 'trailer_model' => '', 'seller_email' => 'goodboating@theboatcenter.biz', 'seller_telephone' => '203-245-7242', 'blow_out_price' => 0, 'manufacturer' => 'Walden', 'engine_serial_number' => '39', 'show_image4' => 'http://www.theboatcenter.biz/boatsforsale/images/100_0525-89738.JPG', 'date_out' => 'February 03 2022', 'broker_name' => 'The Boat Center', 'boat_type' => 'Kayak', 'categ' => 'other', 'old_price' => 0, 'price_type' => 0, 'city_loc' => 'Madison', 'broker_id' => 63, 'date_entered' => '20170823110447', 'engine_info' => '', 'material' => 'Fiberglass', 'date_modified' => '20220203123951', 'boat_number' => '', 'show_image3' => 'http://www.theboatcenter.biz/boatsforsale/images/100_0521 (2)-11910.JPG', 'description' => 'The Walden Vista Kayak is considered a light touring kayak. At 39 lbs., it is the lightest model in its class. Due to its unique design is has all the performance of an equivalent kayak of 14\' in length, yet it is only 12\'6 it makes for easy handling. Only 8 in Stock.', 'show_image' => 'http://www.theboatcenter.biz/boatsforsale/images/100_0527 (2)-23643.JPG', 'show_image1' => 'http://www.theboatcenter.biz/boatsforsale/images/walden1-91026.bmp', 'categ3' => '', 'boat_id' => 33637, 'state_loc' => 'CT', 'model' => 'Vista', 'country_loc' => 'USA', 'deck_info' => '', 'beam' => '24', 'displacement' => '', 'electronic_info' => '', 'price' => '399', 'hull_id_number' => 'Kayak', 'year' => 2 }, 'reldir' => undef, 'crypt' => undef, 'encdata' => undef, 'commify' => sub { "DUMMY" } }; Madison CT - New and Pre owned Used Boat Sales - Bayliner, Trophy, Northcoast and Pro-Line | Boat Service & Engine Repairs | Parts & Ship's Store | Madison, Killingworth, Branford, New Haven, Old Saybrook, Connecticut.
 

Email a Friend || Print This
2   Walden Vista

Email: goodboating@theboatcenter.biz
Phone: 203-245-7242
Location: CT USA

Description: The Walden Vista Kayak is considered a light touring kayak. At 39 lbs., it is the lightest model in its class. Due to its unique design is has all the performance of an equivalent kayak of 14' in length, yet it is only 12'6 it makes for easy handling. Only 8 in Stock.

Discount Sale Price: $399







Enter your comments/questions in the space provided below:
*Name
*E-Mail
State/Location
Telephone
Fax (if any)