Guarantee RV - Toy Hauler

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` = 'THT' OR `type` = 'TH5'   ORDER BY list_price DESC ;

Viewing Toy Hauler - 3 Found

2012 Gulf Stream Enduramax Th5 3912 | $77,990

Stock # 1201GS	Model: 3912
Designation: New	Year: 2012
Availability: In Stock	Type: Toy Hauler Fifth Wheel
Manufacturer: Gulf Stream	Slides: 3
Brand: Enduramax th5	Int. Color: Saddle

View Details Request Info

2012 Crossroads Rv Elevation TF3310 | $64,990

Stock # 12115CR	Model: TF3310
Designation: New	Year: 2012
Availability: In Stock	Type: Toy Hauler Fifth Wheel
Manufacturer: Crossroads Rv	Slides: 4
Brand: Elevation	Int. Color: Malibu
Monthly Payment: $607

View Details Request Info

2007 Timberland Rpm Toyhauler FBSFG26 | $19,990

Stock # 11147U	Model: FBSFG26
Designation: Pre-Owned	Year: 2007
Availability: In Stock	Type: Toy Hauler
Manufacturer: Timberland	Slides: 1
Brand: Rpm Toyhauler
Monthly Payment: $230

View Details Request Info