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 = 122
ORDER BY propertyID
RESULTSET:
[Record # 1]
BATH: 2
BED: 4
HAS01: 1
HAS02: 1
HAS03: 1
HAS04: 0
HAS05: 0
HAS06: 1
HAS07: 0
HAS08: 0
HAS09: 1
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: 0
HAS24: 1
HAS25: 1
HAS26: 1
HAS27: 0
HAS28: 1
HAS29: 0
HAS30: [empty string]
ISARCHIVED: 0
PRICEPERWEEK: 4000
PRICEPERWEEKSTUDENT: 0
PRIORITY: 2
PROPERTYCITY: FORT LAUDERDALE
PROPERTYDESC: Deja Blue is a popular 4 bedroom/2.5 bathroom short-term rental. It is a free-standing house with a large pool located a few minutes from Lauderdale Marine Center (LMC)
*Ongoing neighborhood roadwork improvement*
- 4 Bedrooms
- 2.5 Bathrooms
- Free-standing house
- Private Pool
- Double Garage
- 0.5 Miles to LMC
- 1.4 Miles to SE 17th Street
This up-market 4 Bedroom/2.5 Bathroom in Ft. Lauderdale is the perfect furnished rental for those on vacation and for Yacht Crew.
No lease is required when staying in a Smart Move house. This property is available for weekly rent and monthly rent.
Located within minutes from Lauderdale Marine Center (LMC) it makes its one of our most convenient short-term rentals for Yacht Crew. Crew are able to go back and forth to the house during the day while the boat is at LMC.
With its’ open concept kitchen, stainless-steel appliances and dishwasher, this kitchen is a dream for anyone who enjoys cooking.
The living room has a extra large sofa so enjoying the flat screen TV after a long day is very enjoyable.
The layout of the house is ideal providing just enough privacy for all guests, whether they are Yacht Crew or Vacationers. It sleeps a total of eight people.
One one side of the house is the master bedroom with a Queen bed, ensuite bathroom with large Jacuzzi tub and very large walk-in closets.
The remaining three bedrooms on the other side of the house.
The three bedrooms are set-up to have 2 twins in each room allowing Maritime Crew or out-of-town guests flexibility during their stay whether it be a week or a month. The shared bathroom has a tub
Long mirrors in each bedroom as well as laundry hampers are provided
Complimentary laundry.
This spacious short-term rental has a large covered patio and BBQ with a large fenced in pool. All guests can enjoy the outdoor area and have fun in the sun while in Fort Lauderdale.
For added convenience there is a double garage. Please inquire about garage access.
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: 122
PROPERTYLAT: 26.09524300
PROPERTYLOCATIONNAME: Near LMC
PROPERTYLOCATIONREF: 24
PROPERTYLONG: -80.15812600
PROPERTYNAME: Deja Blue
PROPERTYSEOURL: https://www.smartmovecrew.com/crew-housing/deja-blue-fort-lauderdale-near-lmc-122
PROPERTYSTATE: FL
PROPERTYSTATUSNAME: Short Term Rental
PROPERTYSTATUSREF: 1
PROPERTYTYPENAME: Private Houses
PROPERTYTYPEREF: 6
PROPERTYZIP: 33315
RANDOMSEED: 876064
STREETADDRESS: 2105 SW 12TH TERRACE
WEBSITECODE: 04-4070
query
CACHED: false
EXECUTIONTIME: 0
SQL: SELECT *
FROM allFeatures
WHERE featureID > 0
ORDER BY featureName asc
RESULTSET:
[Record # 1]
Distance: 3.46290096748
DistanceKM: 5.572985043004263
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: 3.46290096748
DistanceKM: 5.572985043004263
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.84138685623
DistanceKM: 4.572757523205189
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: 1.10351920869
DistanceKM: 1.7759376033131646
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: 2.22926708618
DistanceKM: 3.5876486924729214
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: 5.2240218588
DistanceKM: 8.407227338241192
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.79378252677
DistanceKM: 4.496145971632031
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.7862328282
DistanceKM: 4.483995939735388
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.87513323934
DistanceKM: 3.0177269273994356
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.00806901552
DistanceKM: 3.2316657894369567
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: 4.01247328859
DistanceKM: 6.457433762259431
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: 0.522523377235
DistanceKM: 0.8409177719193749
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: 1.02152450198
DistanceKM: 1.6439802420164933
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: 0.785609293661
DistanceKM: 1.2643124606603937
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: 1.51726470059
DistanceKM: 2.4417947732475107
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: 2.67026044969
DistanceKM: 4.297356952104105
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: 1.72153035882
DistanceKM: 2.7705276676633788
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: 1.75296158512
DistanceKM: 2.8211111973970207
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: 1.44087481129
DistanceKM: 2.3188574688014487
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: 0.259991618367
DistanceKM: 0.4184149111027478
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: 3.45178794327
DistanceKM: 5.555100408622142
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: 3.49940927712
DistanceKM: 5.6317393260403
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: 1.6690899546
DistanceKM: 2.686133227535964
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: 1.2458950787
DistanceKM: 2.005068785955058
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