query
CACHED: false
EXECUTIONTIME: 19
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 = 167
ORDER BY propertyID
RESULTSET:
[Record # 1]
BATH: 1
BED: 1
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: 1
HAS17: 1
HAS18: 0
HAS19: 0
HAS20: 1
HAS21: 1
HAS22: 1
HAS23: 0
HAS24: 1
HAS25: 0
HAS26: 0
HAS27: 0
HAS28: 0
HAS29: 0
HAS30: [empty string]
ISARCHIVED: 0
PRICEPERWEEK: 850
PRICEPERWEEKSTUDENT: 0
PRIORITY: 23
PROPERTYCITY: FORT LAUDERDALE
PROPERTYDESC: Two Palms is the perfect space for anyone visiting Fort Lauderdale, be it for school, work or pleasure. It is 1 block from SE 17th Street and East of US1.
This location makes it a dream for anyone who doesnt have a car and needs to be close to shops and restaurants and maritime schools.
This one bedroom/one bathroom is spacious and bright with a full kitchen and desk/study set-up for those attending classes.
- 1 Bedroom
- 1 Bathroom
- 1 Street/Block over SE 17th Street
- 1.7 Miles to Lauderdale Marine Center
- 0.3 Miles to Maritime Professional Training
- 0.3 Miles to Professional Yacht Training
The bedroom has a Full Size Bed and ensuite bathroom. There is a shower/tub setup
The living room is bright and open with a flat screen TV and dining space for 4.
A long mirror, hairdryer and laundry hamper are provided.
There are shared coin operated laundry facilities in this complex
The complex holds 4 other units with 5 unassigned parking spaces.
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.
13% tax sales and tourist tax will be added to all rental amounts.
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: 167
PROPERTYLAT: 26.09920780
PROPERTYLOCATIONNAME: Near SE 17th Street
PROPERTYLOCATIONREF: 3
PROPERTYLONG: -80.13821490
PROPERTYNAME: Two Palms
PROPERTYSEOURL: https://www.smartmovecrew.com/crew-housing/two-palms-fort-lauderdale-near-se-17th-street-167
PROPERTYSTATE: FL
PROPERTYSTATUSNAME: Short Term Rental
PROPERTYSTATUSREF: 1
PROPERTYTYPENAME: 1-Bedroom Apartments
PROPERTYTYPEREF: 3
PROPERTYZIP: 33316
RANDOMSEED: 877291
STREETADDRESS: 409 SE 18TH STREET
WEBSITECODE: 01-1068
query
CACHED: false
EXECUTIONTIME: 0
SQL: SELECT *
FROM allFeatures
WHERE featureID > 0
ORDER BY featureName asc
RESULTSET:
[Record # 1]
Distance: 2.21897397857
DistanceKM: 3.5710835826718434
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: 2.21897397857
DistanceKM: 3.5710835826718434
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.67139824527
DistanceKM: 4.299188052042822
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.364429702464
DistanceKM: 0.5864912973634138
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.972075529905
DistanceKM: 1.5644000332973127
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.95332554452
DistanceKM: 7.971584931817817
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.59036400333
DistanceKM: 4.168776405119102
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.6496019145
DistanceKM: 4.26411034508143
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.41658639067
DistanceKM: 2.2797691419608577
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: 1.89545870429
DistanceKM: 3.0504375111620687
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: 3.04130893835
DistanceKM: 4.894500126844188
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: 1.74919173758
DistanceKM: 2.815044230956997
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.256118626366
DistanceKM: 0.41218195015585846
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.04069333368
DistanceKM: 3.2841694096245715
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.258189186801
DistanceKM: 0.41551418588632133
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.405893844
DistanceKM: 2.2625611989029597
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.476742022514
DistanceKM: 0.7672400065126808
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.497589788788
DistanceKM: 0.8007911506880798
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.1754727426
DistanceKM: 0.282395303575884
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.51776181831
DistanceKM: 2.442594804679015
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: 2.20396592006
DistanceKM: 3.54693051378936
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: 2.27646292229
DistanceKM: 3.6636028393581883
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.402256321764
DistanceKM: 0.6473671888676757
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.0440119747151
DistanceKM: 0.07083023138799904
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