| Struct | | CART_ITEMS | Query
Execution Time: 0 ms
Record Count: 0
Cached: No
Lazy: No
| | tbl_id |
| | EVENT_BOOKINGS | Query
Execution Time: 0 ms
Record Count: 0
Cached: No
Lazy: No
| | tbl_id |
| | EVENT_TICKETS | Query
Execution Time: 0 ms
Record Count: 0
Cached: No
Lazy: No
| | tbl_id |
| | RENTAL_BOOKINGS | Query
Template: /services/rentals.cfc:144
Execution Time: 18.2 ms
Record Count: 2
Cached: No
Datasource: wsm_dev
Lazy: No
SQL:
DECLARE @date AS date = '2026-06-22'
SELECT a.room_name, a.room_title, a.room_uid, a.room_desc, a.room_short_desc, a.room_number, a.length,a.hp,
a.max_people, a.allow_pets, a.featured_amenity_list,
isnull(a.rate_master,0) as rate_master, 'xxxxx' as label, '' as original_rate,
isnull(a.cleaning_fee,0) as cleaning_fee, isnull(a.trip_insurance,0) as trip_insurance,
r.rate, @date as start_date, dateadd(d,1,@date) as end_date, '' as start_time,
(SELECT min(rate) FROM rental_rate_detail WHERE room_uid=r.room_uid AND dte = @date) as rate_min,
(SELECT max(rate) FROM rental_rate_detail WHERE room_uid=r.room_uid AND dte = @date) as rate_max
FROM Rooms a
left outer join Rental_Rate_Detail r ON a.room_uid=r.room_uid and dte = @date and r.itemno='PONTOONRENTAL11'
WHERE a.comp_id = 10 AND a.web_label = 'boat' AND a.active = 1 ORDER BY room_name ASC
| | room_name | room_title | room_uid | room_desc | room_short_desc | room_number | length | hp | max_people | allow_pets | featured_amenity_list | rate_master | label | original_rate | cleaning_fee | trip_insurance | rate | start_date | end_date | start_time | rate_min | rate_max | action | discount_amt | new_amount | from_Date | to_Date | room_rate | rental_bookings_id | properties_id | | 1 | Blue Trifecta Tri-toon Boat | Trifecta Tri-toon Boat | 801 | Introducing this all-new, value-minded pontoon to our Trifecta line-up. The LE is built with the top quality construction techniques and materials you'll find in our other higher-end series. By offering limited options, colors, and floorplans this easy to order boat keeps prices attainable. Our reinforced splash fins, stainless steel mid-back reclining helm chairs, and our one of a kind v-lite performance deck makes the Trifecta LE not so "entry-level" compared to others.
Features may include:
(4) Speakers w/ Protective Inside Covers
27 Gallon, Direct Fill, Fuel Tank in Motor Pod w/ Fuel / Water Separator
3/4" One Piece V-Lite Performance Deck
Bimini Top Trailering Brackets
Bow Reinforcement Bumper & Continuous Extruded Aluminum Riser Brackets
Clarion Radio
Deutsch Waterproof Electrical Wiring Harness
Exterior "D" Rail Design
LED Navigation Lights
Radius Deck w/ Integrated Deck Trim and Vinyl Rub Rail
Raised Logos
Reinforced Splash Fins
Stainless Steel Cleats and Rail Braces
Stainless Steel Rimmed Cupholder - One in helm
Steel Framed Mid Back Reclining Helm Chair w/ Arms & Headrest
Stern Platform w/ SS Telescoping Ladder
Stern Stainless Steel Corners
Surlast 10' Color Matched Bimini Top w/ Push Pin Quick Release
Surlast Color Matched Playpen Cover (Factory Installed)
Tachometer, Voltmeter, Fuel Gauge, Trim Gauge, 12 Volt Receptacle
Transducer Bracket on Starboard Tube
Vinyl Wrapped Furniture Bases | | 901 | 24 | 140 | 13 | 0 | | 0 | xxxxx | | 0 | 0 | 750 | {ts '2026-06-22 00:00:00'} | {ts '2026-06-23 00:00:00'} | | 250 | 750 | | | | {ts '2026-06-22 00:00:00'} | {ts '2026-06-23 00:00:00'} | 750 | | | | 2 | Red Trifecta Tri-toon Boat | Trifecta Tri-toon Boat | 802 | Introducing this all-new, value-minded pontoon to our Trifecta line-up. The LE is built with the top quality construction techniques and materials you'll find in our other higher-end series. By offering limited options, colors, and floorplans this easy to order boat keeps prices attainable. Our reinforced splash fins, stainless steel mid-back reclining helm chairs, and our one of a kind v-lite performance deck makes the Trifecta LE not so "entry-level" compared to others.
Features may include:
(4) Speakers w/ Protective Inside Covers
27 Gallon, Direct Fill, Fuel Tank in Motor Pod w/ Fuel / Water Separator
3/4" One Piece V-Lite Performance Deck
Bimini Top Trailering Brackets
Bow Reinforcement Bumper & Continuous Extruded Aluminum Riser Brackets
Clarion Radio
Deutsch Waterproof Electrical Wiring Harness
Exterior "D" Rail Design
LED Navigation Lights
Radius Deck w/ Integrated Deck Trim and Vinyl Rub Rail
Raised Logos
Reinforced Splash Fins
Stainless Steel Cleats and Rail Braces
Stainless Steel Rimmed Cupholder - One in helm
Steel Framed Mid Back Reclining Helm Chair w/ Arms & Headrest
Stern Platform w/ SS Telescoping Ladder
Stern Stainless Steel Corners
Surlast 10' Color Matched Bimini Top w/ Push Pin Quick Release
Surlast Color Matched Playpen Cover (Factory Installed)
Tachometer, Voltmeter, Fuel Gauge, Trim Gauge, 12 Volt Receptacle
Transducer Bracket on Starboard Tube
Vinyl Wrapped Furniture Bases | | 902 | 24 | 140 | 12 | 0 | | 0 | xxxxx | | 0 | 0 | 750 | {ts '2026-06-22 00:00:00'} | {ts '2026-06-23 00:00:00'} | | 250 | 750 | | | | {ts '2026-06-22 00:00:00'} | {ts '2026-06-23 00:00:00'} | 750 | | |
| | ROOM_BOOKINGS | Query
Execution Time: 0 ms
Record Count: 0
Cached: No
Lazy: No
| | tbl_id |
|
|
