query
CACHED: false
EXECUTIONTIME: 0
SQL: SELECT
property.propertyLat,
property.propertyLong,
property.propertyID,
property.propertyTypeREF,
property.propertyStatusREF,
property.propertyLocationREF,
property.pricePerWeek,
property.pricePerWeekStudent,
property.priority,
property.propertySEOURL,
property.bed,
property.bath,
property.has01,
property.has02,
property.has03,
property.has04,
property.has05,
property.has06,
property.has07,
property.has08,
property.has09,
property.has10,
property.has11,
property.has12,
property.has13,
property.has14,
property.has15,
property.has16,
property.has17,
property.has18,
property.has19,
property.has20,
property.has21,
property.has22,
property.has23,
property.has24,
property.has25,
property.has26,
property.has27,
property.has28,
property.has29,
property.has30,
property.propertyZip,
property.propertyCity,
property.propertyName,
property.streetAddress,
property.websiteCode,
property.propertyState,
property.propertyDesc,
property.isArchived,
propertyType.propertyTypeName,
propertyLocation.propertyLocationName,
propertyStatus.propertyStatusName,
property.randomSeed
FROM
property
LEFT JOIN propertyType ON property.propertyTypeREF = propertyType.propertyTypeID
LEFT JOIN propertyStatus ON property.propertyStatusREF = propertyStatus.propertyStatusID
LEFT JOIN propertyLocation ON property.propertyLocationREF = propertyLocation.propertyLocationID
WHERE propertyID = 198
ORDER BY propertyID
RESULTSET:
[Record # 1]
BATH: 1
BED: 2
HAS01: 1
HAS02: 1
HAS03: 0
HAS04: 0
HAS05: 0
HAS06: 1
HAS07: 0
HAS08: 0
HAS09: 0
HAS10: 1
HAS11: 0
HAS12: 1
HAS13: 0
HAS14: 0
HAS15: 1
HAS16: 0
HAS17: 1
HAS18: 0
HAS19: 0
HAS20: 0
HAS21: 1
HAS22: 1
HAS23: 0
HAS24: 0
HAS25: 0
HAS26: 0
HAS27: 0
HAS28: 0
HAS29: 0
HAS30: [empty string]
ISARCHIVED: 0
PRICEPERWEEK: 295
PRICEPERWEEKSTUDENT: 285
PRIORITY: [empty string]
PROPERTYCITY: FORT LAUDERDALE
PROPERTYDESC: TICK TOCK - A newly renovated Professional Crew Housing.
Renting by the bed is the ONLY option
A 2 bedroom/1 bathroom professional crew house only 3 blocks from SE 17th Street and 0.3 Miles to Professional Yacht Training (PYT) in Fort Lauderdale.
- 0.3 Miles to SE 17th Street
- 2.1 Miles to Lauderdale Marine Center (LMC)
- 0.3 Miles to Professional Yacht Training (PYT)
Crew Housing is only for members of the yachting/marine industry.
SHARED/BED = you will have 1 roommate.
PRIVATE Room/Single Room = single room to yourself
This crew house is part of a triplex. There is 1 other crew house in this complex.
Centrally Located to SE 17th Street, PYT and all Crew Agencies
All 2 Bedroom/1 Bathrooms
2 People Per Room
No Bunk Beds
Co-Ed House & Rooms
Fully equipped kitchens (all cookware, flatware, and dinnerware)
Flat Screen TV in the Living room
Flat Screen TVs in each bedroom
Electronic door locks on each bedroom
Coin operated Washer and Dryer onsite
Free Wi-Fi
Outdoor area with BBQ
5 unassigned parking spaces.
Long mirrors and laundry hampers are provided throughout the house.
Approved as a City of Fort Lauderdale Vacation Rental, Certificate #1600497
This Short-Term Fully Furnished Rental is available for rent Weekly. Please contact us for availability. *Prices are Seasonal and Vary* Student Discounts Available.
PROPERTYID: 198
PROPERTYLAT: 26.10429200
PROPERTYLOCATIONNAME: Near SE 17th Street
PROPERTYLOCATIONREF: 3
PROPERTYLONG: -80.13342200
PROPERTYNAME: Tick Tock Crew House
PROPERTYSEOURL: https://www.smartmovecrew.com/crew-housing/tick-tock-crew-house-fort-lauderdale-near-se-17th-street-198
PROPERTYSTATE: FL
PROPERTYSTATUSNAME: Short Term Rental
PROPERTYSTATUSREF: 1
PROPERTYTYPENAME: Shared Crew - Pro
PROPERTYTYPEREF: 13
PROPERTYZIP: 33316
RANDOMSEED: 610113
STREETADDRESS: 901 SE 14TH COURT
WEBSITECODE: CH-2068
query
CACHED: false
EXECUTIONTIME: 0
SQL: SELECT *
FROM allFeatures
WHERE featureID > 0
ORDER BY featureName asc
RESULTSET:
[Record # 1]
Distance: 1.80607573894
DistanceKM: 2.9065899297056994
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 20
FEATURELAT: 26.11335700
FEATURELONG: -80.10615300
FEATURENAME: Bahia Mar Marina
FEATURESTATE: Florida
FEATUREZIP: 33316
RANDOMSEED: 556804
STREETADDRESS: 801 Seabreeze Blvd
[Record # 2]
Distance: 1.80607573894
DistanceKM: 2.9065899297056994
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 15
FEATURELAT: 26.11335700
FEATURELONG: -80.10615300
FEATURENAME: Beach
FEATURESTATE: Florida
FEATUREZIP: 33316
RANDOMSEED: 281030
STREETADDRESS: 801 Sea Breeze Bld
[Record # 3]
Distance: 2.46151681564
DistanceKM: 3.961417472082078
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 9
FEATURELAT: 26.13590400
FEATURELONG: -80.15162300
FEATURENAME: Bluewater
FEATURESTATE: FL
FEATUREZIP: 33311
RANDOMSEED: 598817
STREETADDRESS: 750 W Sunrise Blvd
[Record # 4]
Distance: 0.572436602118
DistanceKM: 0.9212451212525821
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 5
FEATURELAT: 26.10281600
FEATURELONG: -80.14249000
FEATURENAME: Broward Hospital
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 205496
STREETADDRESS: 1600 S Andrews
[Record # 5]
Distance: 0.746986080543
DistanceKM: 1.2021545788610715
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 6
FEATURELAT: 26.09963300
FEATURELONG: -80.12257300
FEATURENAME: Convention Center
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 991024
STREETADDRESS: 1950 Eisenhower Blvd
[Record # 6]
Distance: 4.65437942284
DistanceKM: 7.490478980353325
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 26
FEATURELAT: 26.17024700
FEATURELONG: -80.14827100
FEATURENAME: Cosmix Makeup Artistry
FEATURESTATE: FL
FEATUREZIP: 33309
RANDOMSEED: 648530
STREETADDRESS: 3440 N Andrews Ave
[Record # 7]
Distance: 2.91728226222
DistanceKM: 4.694899035881135
FEATURECITY: Dania Beach
FEATUREDESC: [empty string]
FEATUREID: 8
FEATURELAT: 26.06212700
FEATURELONG: -80.13238200
FEATURENAME: Dania Cut Marina
FEATURESTATE: FL
FEATUREZIP: 33004
RANDOMSEED: 352010
STREETADDRESS: 760 N.E. 7th Avenue
[Record # 8]
Distance: 2.99134836068
DistanceKM: 4.814096570776751
FEATURECITY: Dania Beach
FEATUREDESC: [empty string]
FEATUREID: 7
FEATURELAT: 26.06105500
FEATURELONG: -80.13441100
FEATURENAME: Derecktors
FEATURESTATE: FL
FEATUREZIP: 33004
RANDOMSEED: 415358
STREETADDRESS: 775 Taylor Lane
[Record # 9]
Distance: 1.20695435076
DistanceKM: 1.9423999148520985
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 18
FEATURELAT: 26.11907700
FEATURELONG: -80.14374200
FEATURENAME: Downtown Ft Lauderdale/Riverwalk
FEATURESTATE: Florida
FEATUREZIP: 33301
RANDOMSEED: 464907
STREETADDRESS: 305 S Andrews Avenue
[Record # 10]
Distance: 2.2733748665
DistanceKM: 3.6586331076531105
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 13
FEATURELAT: 26.07181500
FEATURELONG: -80.13903800
FEATURENAME: Ft Lauderdale Airport
FEATURESTATE: Florida
FEATUREZIP: 33315
RANDOMSEED: 162763
STREETADDRESS: 100 Terminal Drive
[Record # 11]
Distance: 2.58852829971
DistanceKM: 4.165822133855292
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 19
FEATURELAT: 26.13712900
FEATURELONG: -80.11343100
FEATURENAME: Galleria Mall
FEATURESTATE: FLORIDA
FEATUREZIP: 33304
RANDOMSEED: 944459
STREETADDRESS: 2414 E Sunrise Blvd,
[Record # 12]
Distance: 2.10044675222
DistanceKM: 3.3803329762177348
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 11
FEATURELAT: 26.09710900
FEATURELONG: -80.16627700
FEATURENAME: LMC
FEATURESTATE: FL
FEATUREZIP: 33315
RANDOMSEED: 949886
STREETADDRESS: 2001 SW 20th Street
[Record # 13]
Distance: 0.70442878361
DistanceKM: 1.1336654186149175
FEATURECITY: Fort Lauderdake
FEATUREDESC: [empty string]
FEATUREID: 10
FEATURELAT: 26.09750300
FEATURELONG: -80.14187500
FEATURENAME: MPT
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 368851
STREETADDRESS: 1915 S Andrews Avenue
[Record # 14]
Distance: 2.44218140883
DistanceKM: 3.930300228486472
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 4
FEATURELAT: 26.09041500
FEATURELONG: -80.16957300
FEATURENAME: Marina Mile
FEATURESTATE: FL
FEATUREZIP: 33312
RANDOMSEED: 115524
STREETADDRESS: 2698 SW 23rd Avenue
[Record # 15]
Distance: 0.240835919693
DistanceKM: 0.3875868789987326
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 25
FEATURELAT: 26.10095930
FEATURELONG: -80.13454440
FEATURENAME: PYT
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 286206
STREETADDRESS: 1635 Miami Road
[Record # 16]
Distance: 1.10886666706
DistanceKM: 1.7845434819663404
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 22
FEATURELAT: 26.10186500
FEATURELONG: -80.11577600
FEATURENAME: Pier 66
FEATURESTATE: Florida
FEATUREZIP: 33316-2928
RANDOMSEED: 388410
STREETADDRESS: 2301 SE 17th Street
[Record # 17]
Distance: 0.453032009866
DistanceKM: 0.7290825347577484
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 12
FEATURELAT: 26.09824700
FEATURELONG: -80.13061500
FEATURENAME: Publix
FEATURESTATE: Florida
FEATUREZIP: 33316-2928
RANDOMSEED: 364089
STREETADDRESS: 1940 Cordova Road
[Record # 18]
Distance: 0.191973257801
DistanceKM: 0.3089502427094613
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 21
FEATURELAT: 26.10248000
FEATURELONG: -80.13108100
FEATURENAME: QuarterDeck Restaurant
FEATURESTATE: Florida
FEATUREZIP: 33316-2928
RANDOMSEED: 703368
STREETADDRESS: 1541 Cordova Rd
[Record # 19]
Distance: 0.319511778133
DistanceKM: 0.5142030850205622
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 16
FEATURELAT: 26.10009400
FEATURELONG: -80.13556800
FEATURENAME: SE 17th Street Causeway
FEATURESTATE: Florida
FEATUREZIP: 33316-2928
RANDOMSEED: 825627
STREETADDRESS: 716 SE 17th St
[Record # 20]
Distance: 1.91559833817
DistanceKM: 3.0828490295505078
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 30
FEATURELAT: 26.09340950
FEATURELONG: -80.16177960
FEATURENAME: Savvy Marine
FEATURESTATE: FL
FEATUREZIP: 33315
RANDOMSEED: 996399
STREETADDRESS: 1885 W State Rd 84 Suite 102
[Record # 21]
Distance: 1.79600515677
DistanceKM: 2.8903829389962317
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 27
FEATURELAT: 26.11265900
FEATURELONG: -80.10604900
FEATURENAME: Sea Experience
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 321155
STREETADDRESS: 801 Seabreeze Blvd
[Record # 22]
Distance: 1.84499183386
DistanceKM: 2.969219157904252
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 23
FEATURELAT: 26.11632700
FEATURELONG: -80.10691300
FEATURENAME: Swimming Hall of Fame
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 283168
STREETADDRESS: One Hall of Fame Drive
[Record # 23]
Distance: 0.273921808653
DistanceKM: 0.440833323537619
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 14
FEATURELAT: 26.10056900
FEATURELONG: -80.13191900
FEATURENAME: Waxys Irish Pub
FEATURESTATE: Florida
FEATUREZIP: 33316-2928
RANDOMSEED: 485787
STREETADDRESS: 1095 SE 17th Street
[Record # 24]
Distance: 0.456812904239
DistanceKM: 0.7351672793079923
FEATURECITY: Fort Lauderdale
FEATUREDESC: [empty string]
FEATUREID: 29
FEATURELAT: 26.09968170
FEATURELONG: -80.13868770
FEATURENAME: Whole Foods on 17th
FEATURESTATE: FL
FEATUREZIP: 33316
RANDOMSEED: 842671
STREETADDRESS: 501 SE 17th St
