Guarantee RV - Tent Trailer

SELECT 
                stock_item.id,
                stock_item.cms_headline,
                stock_item.year,
                stock_item.d,
                stock_item.sc,
                stock_item.type,
                stock_item.manufacturer,
                stock_item.brand_name,
                stock_item.model,
                stock_item.mileage,
                stock_item.list_price,
                stock_item.slides,
                stock_item.monthly,
                stock_item.int_clr,
                stock_item.option_description,
                stock_item_image.large_image,
                stock_item_image.small_image,
                stock_item_image.thumbnail_image,
                stock_item_details.description,
                stock_item_details.floor_plan
            FROM stock_item
            LEFT JOIN stock_item_image ON stock_item.cms_headline = stock_item_image.stock_item
            LEFT JOIN stock_item_details ON stock_item.cms_headline = stock_item_details.cms_headline
             WHERE `type` = 'FD'  ORDER BY list_price DESC ;

Viewing Tent Trailer - 4 Found

2009 Starcraft 2407 | $8,900

Stock # 1139U	Model: 2407
Designation: Pre-Owned	Year: 2009
Availability: In Stock	Type: Tent Trailer
Manufacturer: Starcraft	Slides: 1
Brand: Starcraft
Monthly Payment: $139

View Details Request Info

2007 Forest River Rockwood 2514G | $7,900

Stock # 11140U	Model: 2514G
Designation: Pre-Owned	Year: 2007
Availability: In Stock	Type: Tent Trailer
Manufacturer: Forest River	Slides: 1
Brand: Rockwood
Monthly Payment: $197

View Details Request Info

2008 Forest River Palomino Pony P-280 | $6,400

Stock # 1212U	Model: P-280
Designation: Pre-Owned	Year: 2008
Availability: On Order	Type: Tent Trailer
Manufacturer: Forest River
Brand: Palomino Pony

View Details Request Info

2003 Flagstaff FST20FD | $5,900

Stock # 1210U	Model: FST20FD
Designation: Pre-Owned	Year: 2003
Availability: Deal Pending	Type: Tent Trailer
Manufacturer: Flagstaff
Brand: Flagstaff

View Details Request Info