Query
Template: /bookingEngine/model/bookingObject.cfc:1999
Execution Time: 13 ms
Record Count: 1
Cached: No
Datasource: pointesouthvacationrentals
Lazy: No
SQL:
SELECT prp.propertyID,
prp.pmsPropertyID,
prp.roomtypeID,
prp.name,
rst.slug,
IF(prp.roomtypeID IS NULL,prp.seoPropertyName,rtp.slug) AS seoPropertyName,
prp.address,
prp.city,
prp.state,
prp.zip,
prp.defaultPhoto AS defaultPhoto,
prp.longDescription,
prp.bedrooms,
prp.bathrooms,
prp.bathroomsHalf,
prp.sleeps,
prp.petsAllowed,
prp.checkintime,
prp.checkouttime,
prp.latitude,
prp.longitude,
prp.currency,
lcs.locationName,
cty.communityName,
tps.typeName,
vws.viewName,
( SELECT ape.extraValue
FROM axis_property_extras ape
WHERE ape.propertyID = prp.propertyID
AND ape.extraName = 'propertyMetaDescription' ) AS pmsMetaDescription,
( SELECT ape.extraValue
FROM axis_property_extras ape
WHERE ape.propertyID = prp.propertyID
AND ape.extraName = 'longDescFormatted' ) AS longDescFormatted,
( SELECT ape.extraValue
FROM axis_property_extras ape
WHERE ape.propertyID = prp.propertyID
AND ape.extraName = 'amenitiesDescFormatted' ) AS amenitiesDescFormatted,
( SELECT ape.extraValue
FROM axis_property_extras ape
WHERE ape.propertyID = prp.propertyID
AND ape.extraName = 'pms_nodes_community_notices' ) AS communityNotice,
( SELECT ape.extraValue
FROM axis_property_extras ape
WHERE ape.propertyID = prp.propertyID
AND ape.extraName = 'VirtualTourUrlInternal' ) AS VirtualTourUrlInternal,
( SELECT ape.extraValue
FROM axis_property_extras ape
WHERE ape.propertyID = prp.propertyID
AND ape.extraName = 'HighlightReelUrlInteral' ) AS HighlightReelUrlInteral,
bnr.bannerName,
bnr.bannerDescription,
exr.headline,
exr.metaTitle,
exr.metaDescription,
exr.metaDescription as propertyMetaDescription,
(SELECT thumbnail
FROM axis_photos
WHERE propertyID = prp.propertyID
LIMIT 1
) AS thumbnail,
(SELECT min(rate)
FROM axis_rates
WHERE rateType = 'weekly'
AND deleteRate = 0
AND propertyID = prp.propertyID
AND startDate >= '2026-01-01'')') AS weeklyRateMin,
(SELECT max(rate)
FROM axis_rates
WHERE rateType = 'weekly'
AND deleteRate = 0
AND propertyID = prp.propertyID
AND startDate >= '2026-01-01'')') AS weeklyRateMax,
(SELECT min(rate)
FROM axis_rates
WHERE rateType = 'daily'
AND deleteRate = 0
AND propertyID = prp.propertyID
AND startDate >= '2026-01-01'')') AS dailyRateMin,
(SELECT max(rate)
FROM axis_rates
WHERE rateType = 'daily'
AND deleteRate = 0
AND propertyID = prp.propertyID
AND startDate >= '2026-01-01'')') AS dailyRateMax,
(SELECT avg(rating) FROM (SELECT rating, propertyID FROM cms_reviews WHERE approved = 1 UNION ALL SELECT rating, propertyID FROM axis_reviews WHERE approved = 1) rtg WHERE propertyID = prp.propertyID) AS avgRating,
(SELECT count(rating) FROM (SELECT rating, propertyID FROM cms_reviews WHERE approved = 1 UNION ALL SELECT rating, propertyID FROM axis_reviews WHERE approved = 1) rtg WHERE propertyID = prp.propertyID) AS cntRating,
(
SELECT count(userTrackingCookie)
FROM be_prop_view_stats
WHERE propertyID = prp.propertyID
AND createdAt >= {ts '2026-09-01 13:22:58'}
) AS propertyViews,
prp.sitePMSid
FROM axis_properties prp
LEFT JOIN axis_locations lcs ON prp.locationID = lcs.locationID
LEFT JOIN axis_communities cty ON prp.communityID = cty.communityID
LEFT JOIN axis_types tps ON prp.typeID = tps.typeID
LEFT JOIN axis_views vws ON prp.viewID = vws.viewID
LEFT JOIN cms_roomtypes rtp ON rtp.roomTypeID = prp.roomtypeID
LEFT JOIN cms_resorts rst ON rtp.resortID = rst.resortID
LEFT JOIN cms_banners bnr ON prp.propertyID = bnr.propertyID
LEFT JOIN cms_property_extras exr ON prp.propertyID = exr.propertyID
WHERE
prp.seoPropertyName = 'riviera-dunes-102'
|
| 1 | 436 | 326 | | Riviera Dunes 102 | | riviera-dunes-102 | 16685 Perdido Key Drive | Perdido Key | FL | 32507 | https://track-pm.s3.amazonaws.com/perdidokey/image/cba2c5a6-3150-44db-bed7-4c4d56f2890f | Riviera Dunes 102 offers the ultimate Gulf Coast escape, boasting a spectacular beachfront location on Perdido Key with breathtaking Gulf views that set the stage for an unforgettable vacation. This expansive three-bedroom, three-bathroom property comfortably sleeps up to ten guests, making it an ideal choice for families, friends, or multiple couples seeking a beach getaway. Spanning 1,686 square feet of thoughtfully designed living space, this oceanfront residence combines comfort with elegance, featuring premium amenities and modern conveniences throughout.<br><br>The master bedroom showcases a sumptuous king bed, providing the perfect retreat for a restful night's sleep with stunning water views. The second bedroom features two queen beds, offering flexibility and comfort for additional guests, while the third bedroom with two twin beds is perfect for children or those preferring separate sleeping arrangements. The living area includes a queen-sized sleeper sofa, ensuring plenty of accommodation options for larger parties. With three full bathrooms featuring modern fixtures, walk-in showers, and jetted tubs.<br><br>The full kitchen is equipped with high-end appliances including a dishwasher, stove, oven, microwave, refrigerator, and toaster oven, complete with cookware, dishes, utensils, and a Keurig coffee maker for morning convenience. A dining room provides the perfect setting for family meals or entertaining, while the expansive living room features smart televisions with cable and satellite service, creating an ideal space to unwind. Wireless internet keeps you connected, and the in-unit washer and dryer ensure convenience during extended stays. Air conditioning and heating maintain comfortable temperatures year-round, while linens and bath towels are provided for your arrival.<br><br>Located on the pristine shores of Perdido Key, guests can access a beautiful public beach right outside their door, where activities range from swimming and sunbathing to beachcombing and paddleboarding. The community amenities include a heated swimming pool and hot tub perfect for relaxation, while boating enthusiasts appreciate easy access to nearby marinas with slip availability and jet ski rentals. Deep-sea fishing, sound and bay fishing, and surf fishing opportunities abound in these Gulf waters, and parasailing adventures can be arranged for the thrill-seekers. The area is perfect for birding enthusiasts exploring the natural ecosystems of the Gulf Coast.<br><br>Just minutes away, guests will find exceptional dining experiences at local favorites like the award-winning restaurants scattered throughout the area, as well as The Wharf located nearby in Pensacola, offering shopping, dining, and entertainment options. The Pensacola Zoo provides family-friendly entertainment with exotic animals and interactive exhibits, while Gulf State Park offers over twenty-five miles of pristine beaches and nature trails for outdoor exploration. For golf enthusiasts, several championship golf courses in the region provide challenging rounds with beautiful coastal views. Water park adventures, outlet shopping opportunities, and various water sports activities round out the exceptional recreational opportunities available in this vibrant coastal community.<br><br>Free parking is conveniently available, and elevator access within the building ensures easy movement between floors. Whether seeking an action-packed beach vacation or a serene coastal retreat, Riviera Dunes 102 provides the perfect sanctuary to create lasting memories. Book your oceanfront paradise today and experience the ultimate Florida Gulf Coast lifestyle with all the amenities and coastal beauty you've been dreaming of. | 3 | 3 | 0 | 8 | 0 | 16:00 | 10:00 | 30.28431767 | -87.5017203 | USD | Perdido Key | | Condo | Water View | Book Riviera Dunes 102, a Gulf-front Perdido Key vacation rental with 3 bedrooms, balcony views, pool, hot tub, and room for 10. | <p>Riviera Dunes 102 offers the ultimate Gulf Coast escape, boasting a spectacular beachfront location on Perdido Key with breathtaking Gulf views that set the stage for an unforgettable vacation. This expansive three-bedroom, three-bathroom property comfortably sleeps up to ten guests, making it an ideal choice for families, friends, or multiple couples seeking a beach getaway. Spanning 1,686 square feet of thoughtfully designed living space, this oceanfront residence combines comfort with elegance, featuring premium amenities and modern conveniences throughout.</p>
<p>The master bedroom showcases a sumptuous king bed, providing the perfect retreat for a restful night's sleep with stunning water views. The second bedroom features two queen beds, offering flexibility and comfort for additional guests, while the third bedroom with two twin beds is perfect for children or those preferring separate sleeping arrangements. The living area includes a queen-sized sleeper sofa, ensuring plenty of accommodation options for larger parties. With three full bathrooms featuring modern fixtures, walk-in showers, and jetted tubs.</p>
<p>The full kitchen is equipped with high-end appliances including a dishwasher, stove, oven, microwave, refrigerator, and toaster oven, complete with cookware, dishes, utensils, and a Keurig coffee maker for morning convenience. A dining room provides the perfect setting for family meals or entertaining, while the expansive living room features smart televisions with cable and satellite service, creating an ideal space to unwind. Wireless internet keeps you connected, and the in-unit washer and dryer ensure convenience during extended stays. Air conditioning and heating maintain comfortable temperatures year-round, while linens and bath towels are provided for your arrival. </p>
<p>Located on the pristine shores of Perdido Key, guests can access a beautiful public beach right outside their door, where activities range from swimming and sunbathing to beachcombing and paddleboarding. The community amenities include a heated swimming pool and hot tub perfect for relaxation, while boating enthusiasts appreciate easy access to nearby marinas with slip availability and jet ski rentals. Deep-sea fishing, sound and bay fishing, and surf fishing opportunities abound in these Gulf waters, and parasailing adventures can be arranged for the thrill-seekers. The area is perfect for birding enthusiasts exploring the natural ecosystems of the Gulf Coast.</p>
<p>Just minutes away, guests will find exceptional dining experiences at local favorites like the award-winning restaurants scattered throughout the area, as well as The Wharf located nearby in Pensacola, offering shopping, dining, and entertainment options. The Pensacola Zoo provides family-friendly entertainment with exotic animals and interactive exhibits, while Gulf State Park offers over twenty-five miles of pristine beaches and nature trails for outdoor exploration. For golf enthusiasts, several championship golf courses in the region provide challenging rounds with beautiful coastal views. Water park adventures, outlet shopping opportunities, and various water sports activities round out the exceptional recreational opportunities available in this vibrant coastal community.</p>
<p>Free parking is conveniently available, and elevator access within the building ensures easy movement between floors. Whether seeking an action-packed beach vacation or a serene coastal retreat, Riviera Dunes 102 provides the perfect sanctuary to create lasting memories. Book your oceanfront paradise today and experience the ultimate Florida Gulf Coast lifestyle with all the amenities and coastal beauty you've been dreaming of.</p> | | | | https://youtube.com/shorts/Ji55UleMw3I?feature=share | | | | | | | https://img.trackhs.com/768x576/https://track-pm.s3.amazonaws.com/perdidokey/image/cba2c5a6-3150-44db-bed7-4c4d56f2890f | | | 131 | 594 | | 0 | 2 | 2220 |
