 |
 |
          
 |
| 82 listings found |
1 | 2 | 3 | 4 | 5 >>
|
| page 1 of 5 |
|
 |
 |
Accommodation prices fall within the ranges provided. Actual room rates vary and are not guaranteed based on publication on this site. Call property for most current prices.
 |
 |
 |
 |
 |
 |
|
| |
Key Colony Beach |
|
 |  |
 |
 |
 |
 |
 |
 |
 |
 |
| |
The Continental Inn
305-289-0101
|
 |
|
 |
|
42 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
Key West
|
|
 |  |
 |
 |
 |
 |
 |
 |
 |
 |
| |
1800 Atlantic Condominiums
305-294-8877
Website
|
|
|
 |
|
56 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
AA Accommodation Center
305-296-7707
Website
|
 |
 |
 |
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
All Florida Keys Property Management, Inc.
305-294-8877
Website
|
|
|
 |
|
50 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Avalon Bed & Breakfast
305-294-8233
Website
|
|
 |
|
|
10 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Casa Marina Resort & Beach Club
305-296-3535
Website
|
 |
 |
 |
|
311 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Curry Mansion Inn
305-294-5349
Website
|
|
 |
 |
|
28 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Cypress House and Guest Suites
305-294-6969
Website
|
|
|
 |
|
22 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Duval Gardens
305-292-3379
Website
|
|
 |
|
|
6 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Ocean Breeze Inn
305-296-2829
Website
|
|
|
 |
|
15 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Travelodge & Suites Bayside Key West
305-296-7593
Website
|
|
|
 |
|
64 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
The Westin Key West Resort & Marina
305-294-4000
Website
|
|
|
 |
|
178 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Alexander's Guesthouse
305-294-9919
|
|
|
|
|
17 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Almond Tree Inn
305-296-5415
|
|
 |
 |
|
22 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Ambrosia House
305-296-9838
|
|
 |
 |
|
20 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
At Home in Key West, Inc.
305-296-7975
|
 |
|
 |
|
135 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Atlantic Shores Resort
305-296-2491
|
|
 |
 |
|
72 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| |
Banana Bay Resort - Key West
305-296-6925
|
 |
 |
 |
|
48 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| 82 listings found |
1 | 2 | 3 | 4 | 5 >>
|
| page 1 of 5 |
|
 |
SELECT DISTINCT
dbo.Tbl_List.List_vCity, dbo.Tbl_List.List_pCity, dbo.Tbl_List.List_pAddress, dbo.Tbl_List.List_pState, dbo.Tbl_List.List_pZip,
dbo.Tbl_List.List_pName,
dbo.Tbl_Fact.F_Image_File, dbo.Tbl_Fact.F_Image_File2,
dbo.Tbl_Fact.List_ID,
dbo.Tbl_Fact.Class_ID,
dbo.Tbl_List.List_Pre_pName,
dbo.Tbl_List.List_Phone1,
dbo.Tbl_List.List_Phone2,
dbo.Tbl_List.List_Phone1_Ext,
dbo.Tbl_List.List_Phone1_Note,
dbo.Tbl_List.List_Fax,
dbo.Tbl_List.List_Url,
dbo.Tbl_List.List_Email,
dbo.Tbl_List.List_TollFree_FL,
dbo.Tbl_List.List_TollFree_US,
dbo.Tbl_List.List_TollFree_Canada,
dbo.Tbl_List.List_TollFree_World,
dbo.Tbl_List.List_Longitude,
dbo.Tbl_List.List_Latitude,
dbo.Tbl_Fact.F_SDescription AS Short_Description,
dbo.Tbl_List.Directions,
dbo.Tbl_List.Location,
dbo.Tbl_List.List_vState,
[47] AS Col1, [278] AS Col2, [346] AS Col3, [157] AS Col4, [255] AS Col5,
dbo.Tbl_Fact.Sort_Order, dbo.Tbl_Fact.Pub_Area, dbo.Tbl_List.Res_Url,
dbo.Tbl_Client_PubArea_LU.Sort_Order AS Pub_Sort
FROM
dbo.Tbl_Fact
INNER JOIN dbo.Tbl_List ON dbo.Tbl_Fact.List_ID = dbo.Tbl_List.List_ID
INNER JOIN dbo.Tbl_Flat250 ON dbo.Tbl_Fact.List_ID = dbo.Tbl_Flat250.List_ID
INNER JOIN dbo.Tbl_Flat500 ON dbo.Tbl_Fact.List_ID = dbo.Tbl_Flat500.List_ID
INNER JOIN dbo.Tbl_Flat750 ON dbo.Tbl_Fact.List_ID = dbo.Tbl_Flat750.List_ID
LEFT OUTER JOIN dbo.Tbl_Rate ON dbo.Tbl_Fact.List_ID = Tbl_Rate.List_ID
LEFT OUTER JOIN dbo.Tbl_Client_PubArea_LU ON dbo.Tbl_Fact.Client_ID = dbo.Tbl_Client_PubArea_LU.Client_ID AND dbo.Tbl_Fact.Pub_Area = dbo.Tbl_Client_PubArea_LU.Pub_Area
WHERE
(dbo.Tbl_Fact.Client_ID = 'iky') AND (dbo.Tbl_Fact.Active_Class = 1)
AND (dbo.Tbl_Fact.Class_ID = 1)
ORDER BY
dbo.Tbl_Fact.Sort_Order, dbo.Tbl_List.List_pName
|
 |
 |