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 = 197
ORDER BY propertyID
RESULTSET:
[Record # 1]
BATH: 2
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: 0
HAS16: 1
HAS17: 0
HAS18: 0
HAS19: 0
HAS20: 1
HAS21: 1
HAS22: 1
HAS23: 1
HAS24: 0
HAS25: 1
HAS26: 0
HAS27: 0
HAS28: 0
HAS29: 0
HAS30: [empty string]
ISARCHIVED: 0
PRICEPERWEEK: 595
PRICEPERWEEKSTUDENT: 585
PRIORITY: [empty string]
PROPERTYCITY: FORT LAUDERDALE
PROPERTYDESC: Welcome to our PREMIUM CREW HOUSE - SUITE SPOT
1 Private Room
1 Shared room (2 twin beds)
Sleeps 4 max
Each private room has its own bathroom
Free indoor laundry
1 parking space per guest
Walking distance to LMC
**Strict House Rules**
Quiet Hours 9pm-8am
Guests must leave the crew house by 10pm
No parties
Suite Spot is only minutes from Lauderdale Marine Center (LMC) in Fort Lauderdale.
- 2 Bedroom
- 2 Bathroom
- Private Laundry inside the apartment
- 2.5 Miles to SE 17th Street
- Walking Distance LMC
- 2.5 Miles to MPT
- 2.5 Miles to PYT
The kitchen is open plan with granite counter-tops, a dishwasher, garbage disposal, and overlooks the dining area and the bright living room.
There is a large Flat Screen TV in the living room and bedroom.
Spacious master bedroom with modern ensuite bathroom.
Both bathrooms glassed in shower doors.
Private Indoor Laundry
There is a BBQ and lovely outdoor area. Ample parking
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 #1801899
13% tax sales and tourist tax will be added to all rental amounts
This Short-Term Fully Furnished Rental is available for rent Weekly and Monthly. Please contact us for availability. *Prices are Seasonal and Vary* Student Discounts Available; Monthly Discounted Rates Available.
PROPERTYID: 197
PROPERTYLAT: 26.09439250
PROPERTYLOCATIONNAME: Near LMC
PROPERTYLOCATIONREF: 24
PROPERTYLONG: -80.16595700
PROPERTYNAME: Suite Spot PREMIUM CREW HOUSE
PROPERTYSEOURL: https://www.smartmovecrew.com/crew-housing/suite-spot-premium-crew-house-fort-lauderdale-near-lmc-197
PROPERTYSTATE: FL
PROPERTYSTATUSNAME: Short Term Rental
PROPERTYSTATUSREF: 1
PROPERTYTYPENAME: Shared Crew Houses
PROPERTYTYPEREF: 8
PROPERTYZIP: 33315
RANDOMSEED: 962397
STREETADDRESS: 1786 SW 22ND STREET
WEBSITECODE: CH-1786
query
CACHED: false
EXECUTIONTIME: 0
SQL: SELECT *
FROM allFeatures
WHERE featureID > 0
ORDER BY featureName asc
RESULTSET:
[Record # 1]
Distance: 3.93952588034
DistanceKM: 6.340036580266376
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.93952588034
DistanceKM: 6.340036580266376
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: 3.00621140781
DistanceKM: 4.838016267044945
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.56984632582
DistanceKM: 2.5264164859951586
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.71921568287
DistanceKM: 4.376142567070006
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.36059739508
DistanceKM: 8.627023811798047
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: 3.05487016186
DistanceKM: 4.916324746287772
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: 3.02633944163
DistanceKM: 4.870409116992824
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: 2.19529272379
DistanceKM: 3.532972392104199
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.28816306631
DistanceKM: 3.6824323491353357
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.40240614703
DistanceKM: 7.08496830866126
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.188949713726
DistanceKM: 0.30408433228780085
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.51134303027
DistanceKM: 2.432264792334722
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.355178824052
DistanceKM: 0.5716034886998457
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: 2.00346162355
DistanceKM: 3.2242509292439565
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: 3.15969874921
DistanceKM: 5.085029585053621
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: 2.21153322942
DistanceKM: 3.5591088874347827
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: 2.23747749499
DistanceKM: 3.6008620317872064
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.92846940916
DistanceKM: 3.1035629589375544
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.268260596701
DistanceKM: 0.43172250869478734
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.9298403775
DistanceKM: 6.32444931312585
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.96890484175
DistanceKM: 6.387317318021945
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: 2.15711034867
DistanceKM: 3.4715239685285777
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.73298474761
DistanceKM: 2.7889616737186773
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
