query
CACHED: false
EXECUTIONTIME: 6
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 = 204
ORDER BY propertyID
RESULTSET:
[Record # 1]
BATH: 0
BED: 0
HAS01: 1
HAS02: 1
HAS03: 0
HAS04: 0
HAS05: 0
HAS06: 1
HAS07: 0
HAS08: 0
HAS09: 0
HAS10: 1
HAS11: 1
HAS12: 1
HAS13: 0
HAS14: 0
HAS15: 1
HAS16: 1
HAS17: 1
HAS18: 0
HAS19: 0
HAS20: 1
HAS21: 1
HAS22: 1
HAS23: 1
HAS24: 0
HAS25: 0
HAS26: 0
HAS27: 0
HAS28: 0
HAS29: 0
HAS30: [empty string]
ISARCHIVED: 0
PRICEPERWEEK: 4000
PRICEPERWEEKSTUDENT: 0
PRIORITY: [empty string]
PROPERTYCITY: Fort Lauderdale
PROPERTYDESC:
Welcome to our modern, newly renovated short-term rental triplex, where luxury meets comfort. The Tropics consists of three separate units, offering added privacy while keeping all guests conveniently under one roof. With a total capacity to sleep 10–11 guests across the units, everyone can enjoy their own space while still being close together.
This rental property is perfectly situated just three blocks away from SE 17th Street and Whole Foods in Southeast Fort Lauderdale. With its prime location, you'll have easy access to shopping, dining, and entertainment options, ensuring a truly memorable stay in FLL.
The two larger units are identical in layout, while the third unit features a one-bedroom layout with an additional den space. With accommodation for up to 11 guests, our contemporary oasis offers a blend of sophistication and convenience.
In total, there are 8 twin beds, 1 Queen Bed and a Futon. All twin beds are easily convertible into King-size beds for added flexibility and comfort.
Unit One = 2 Bedrooms/1 bathroom
A fully equipped kitchen featuring Quartz countertops and comes complete with all essential cookware and flatware.
Comfortable leather sofa, chair and flat screen TV which seamless lead into the modern kitchen with dining for 6.
Each bedroom has 2 twin beds, (which can be converted into a King), large dresser, and fully fitted closets
Flat screen TVS in every bedroom
Long mirrors and laundry hampers are provided
Enjoy the spa-like luxury with its glass-enclosed shower and contemporary fixtures.
Unit Two = 2 Bedrooms/1 bathroom
A fully equipped kitchen featuring Quartz countertops and comes complete with all essential cookware and flatware.
Comfortable leather sofa, chair and flat screen TV which seamless lead into the modern kitchen with dining for 6.
Each bedroom has 2 twin beds, (which can be converted into a King), large dresser, and fully fitted closets
Flat screen TVS in every bedroom
Long mirrors and laundry hampers are provided
Enjoy the spa-like luxury with its glass-enclosed shower and contemporary fixtures.
Unit Three =1 bedroom/1 bathroom with separate study/den with futon
A fully equipped kitchen featuring Quartz countertops and comes complete with all essential cookware and flatware.
Comfortable sofa and large flat screen TV in the living room.
Queen Bed, with a flat screen TV and walk-in closet.
Enjoy the spa-like luxury with its glass-enclosed shower and contemporary fixtures.
A long mirror and laundry hamper is provided
Contact-less self check-in and check-out using a keypad with a unique guest electronic door code.
Central A/C
BBQ onsite.
Complimentary parking
Providing complimentary laundry facilities with two washing machines and two dryers available for use
Rates listed on our website are our starting rates/seasonal rates, which may or may not be the rate we can offer for your stay.
Approved as a City of Fort Lauderdale Vacation Rental Property
This rental is equipped with a Noise Monitoring Device required per the City of Fort Lauderdale Vacation Rental Licensing. Ordinance No. C-16-25 Read More - City of Fort Lauderdale Noise Ordinance Link
PROPERTYID: 204
PROPERTYLAT: 26.10429200
PROPERTYLOCATIONNAME: Near SE 17th Street
PROPERTYLOCATIONREF: 3
PROPERTYLONG: -80.13342200
PROPERTYNAME: The Tropics
PROPERTYSEOURL: https://www.smartmovecrew.com/crew-housing/the-tropics-fort-lauderdale-near-se-17th-street-204
PROPERTYSTATE: FL
PROPERTYSTATUSNAME: Short Term Rental
PROPERTYSTATUSREF: 1
PROPERTYTYPENAME: Private Houses
PROPERTYTYPEREF: 6
PROPERTYZIP: 33316
RANDOMSEED: 732508
STREETADDRESS: 901 SE 14TH COURT
WEBSITECODE: 05-5030
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
