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 = 39
ORDER BY propertyID
RESULTSET:
[Record # 1]
BATH: 2
BED: 3
HAS01: 1
HAS02: 1
HAS03: 1
HAS04: 0
HAS05: 1
HAS06: 1
HAS07: 1
HAS08: 0
HAS09: 1
HAS10: 1
HAS11: 0
HAS12: 1
HAS13: 0
HAS14: 0
HAS15: 1
HAS16: 1
HAS17: 1
HAS18: 1
HAS19: 0
HAS20: 1
HAS21: 1
HAS22: 1
HAS23: 0
HAS24: 1
HAS25: 0
HAS26: 0
HAS27: 0
HAS28: 1
HAS29: 0
HAS30: [empty string]
ISARCHIVED: 0
PRICEPERWEEK: 2000
PRICEPERWEEKSTUDENT: 0
PRIORITY: 57
PROPERTYCITY: Fort Lauderdale
PROPERTYDESC: Miami Place is a centrally located 3-bedroom rental that appeals to Crew, Maritime Students and Vacationers. This short-term rental is only 3 blocks from SE 17th Street and 2.5 miles to the Beach.
- 6 Twins
- Private Pool
- BBQ
- Flat Screen TVs in each Bedroom
Easily convert the twin beds into a King Bed
- 0.7 miles to Maritime Professional Training (MPT)
- 0.3 miles to SE 17th Street
- 2.5 miles to Blue Water
- 2.1 miles to Lauderdale Marine Center (LMC)
The kitchen is open plan and overlooks the dining area and the bright living room. Leather sofas with a large Flat Screen TV in the living room lead through to the 3 bedrooms all with wooden flooring and flat screen TVs.
The Master bedroom has its own bathroom and sliding glass doors that lead onto the garden. The remaining two bedrooms share a bathroom.
There is a lovely covered patio and BBQ with a fenced in backyard. All guests can enjoy the outdoor area and have fun in the sun and enjoy the pool while in Fort Lauderdale.
Covered car port and laundry facilities.
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, Certificate #1500275
PROPERTYID: 39
PROPERTYLAT: 26.10380900
PROPERTYLOCATIONNAME: Near SE 17th Street
PROPERTYLOCATIONREF: 3
PROPERTYLONG: -80.13359100
PROPERTYNAME: After Dune Delight
PROPERTYSEOURL: https://www.smartmovecrew.com/crew-housing/after-dune-delight-fort-lauderdale-near-se-17th-street-39
PROPERTYSTATE: FL
PROPERTYSTATUSNAME: Short Term Rental
PROPERTYSTATUSREF: 1
PROPERTYTYPENAME: Private Houses
PROPERTYTYPEREF: 6
PROPERTYZIP: 33316-2928
RANDOMSEED: 252257
STREETADDRESS: 814 SE 14TH COURT
WEBSITECODE: 03-3010
query
CACHED: false
EXECUTIONTIME: 0
SQL: SELECT *
FROM allFeatures
WHERE featureID > 0
ORDER BY featureName asc
RESULTSET:
[Record # 1]
Distance: 1.82773172468
DistanceKM: 2.941441773796511
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.82773172468
DistanceKM: 2.941441773796511
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.48649827396
DistanceKM: 4.001621132214787
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.55701337654
DistanceKM: 0.8964239074008836
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.742853812407
DistanceKM: 1.1955043544590813
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.68507833113
DistanceKM: 7.539883961420753
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.8841356173
DistanceKM: 4.641554814345582
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.95774675902
DistanceKM: 4.760020169161247
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.22997748352
DistanceKM: 1.9794519633280767
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.23875641614
DistanceKM: 3.602920250750748
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.62288812026
DistanceKM: 4.221118767459228
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.08256404789
DistanceKM: 3.3515536248312925
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.674570651679
DistanceKM: 1.0856135325730818
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.41954751314
DistanceKM: 3.8938745947967277
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.20581866005
DistanceKM: 0.331232202364867
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.1147249505
DistanceKM: 1.7939714518376702
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.426832660178
DistanceKM: 0.6869188733308624
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.180992523364
DistanceKM: 0.2912785075506198
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.284803435594
DistanceKM: 0.458345561038848
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.81693094705
DistanceKM: 2.924059650325447
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 # 21]
Distance: 1.86960501524
DistanceKM: 3.0088301352263414
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 # 22]
Distance: 0.247007062056
DistanceKM: 0.39751834524920304
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 # 23]
Distance: 0.426297437311
DistanceKM: 0.6860575177620848
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