Dario Stoka Real Estate

Search Results

Return to our home page


query
RESULTSET
query
  ACRES APN AVAILABLE_DATE BATHS_FULL BATHS_HALF BATHS_THREE_QUARTER BATHS_TOTAL BED2 BED3 BED4 BED5 BEDROOMS BREAKFAST BUILDING_SQUARE_FOOTAGE CITY CITY_ID COMMUNITY_NAME COUNTY DEN DINING EXTRA FAMILY FEATURE_CODES FIPS_COUNTY_CODE FIREPLACE_NUMBER GREAT HOA_FEES KITCHEN LAST_MLS_UPDATE_DATE LATITUDE LAUNDRY LEGAL LISTING_DATE LISTING_EXPIRATION_DATE LIVING LONGITUDE LOT_DIMENSIONS LOT_SQUARE_FOOTAGE LOT_SQUARE_FOOTAGE_LAND MASTER_BED MLS_AGENT_ID MLS_AGENT_NAME MLS_AGENT_PHONE MLS_AREA MLS_LISTING_ID MLS_OFFICE_ID MLS_OFFICE_NAME MLS_OFFICE_PHONE MLS_STATE_ID MLS_TYPE OWNERS_NAME PHOTO_IND PHOTO_MOST_DATE PHOTO_QUANTITY PHOTO_URL PROPERTY_STATE_ID PROPERTY_TYPE_CODE PROP_TYPE_DESCRIPTION RANGE REMARKS RENT_OFF_SEASON RENT_ON_SEASON SALE_PRICE SALE_PRICE_INT SCHOOL_DISTRICT SCHOOL_ELEMENTARY SCHOOL_HIGH SCHOOL_JUNIOR_HIGH SCHOOL_MIDDLE SECTION SOLD_DATE SOLD_PRICE STATUS_CODE STREET_DIRECTION STREET_NAME STREET_NUMBER STREET_TYPE SUBDIVISION TAXES TAX_YEAR TLN_FIRM_ID TLN_REALTOR_ID TOTAL_BUILDINGS TOTAL_LOTS TOTAL_ROOMS TOTAL_UNITS TOWNSHIP UNIT_NUMBER VIRTUAL_TOUR_URL YEAR_BUILT ZIP_CODE ZIP_PLUS4
1 [empty string] [empty string] [empty string] 1 0 [empty string] 1 [empty string] [empty string] [empty string] [empty string] 1 [empty string] 847 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] C05,C23,D09,E05,G02,J02,M01,M05,M17,N02,N10,N11,N13,N19,T01,T11,T12,T28,U01,U03,U16,W09,W28,Y07 12025 [empty string] [empty string] 0 [empty string] 12/02/2008 25.76566122576139 [empty string] THE PLAZA [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 0594968 Millan,Patricia 3054507118 41 M1281748 RCRS05 Related Cervera Rlty Services 3053733737 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] Beautiful 1/1 in the heart of Brickell 0 0 298000 298000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DRIVE 950 [empty string] THE PLAZA 0 2008 2012653 1074860 [empty string] [empty string] [empty string] [empty string] 0 1900 [empty string] 2008 33131 [empty string]
2 [empty string] 00-00-00-000-3101 [empty string] 1 0 [empty string] 1 [empty string] [empty string] [empty string] [empty string] 1 [empty string] 847 Miami Y22388 THE PLAZA ON BRICKELL DADE [empty string] [empty string] [empty string] [empty string] A08,C02,C05,E05,G02,J02,J07,M01,M05,N02,N11,N13,N19,O14,Q01,Q08,T01,T28,U01,U16,W09,W28,X11,Y07 12025 [empty string] [empty string] 378 [empty string] 09/23/2008 25.76566122576139 [empty string] THE PLAZA ON BRICKELL UNIT 3101 [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 847 [empty string] [empty string] 0563613 Groso PA,M Ludy 3055880705 41 D1276141 QUAD01 Request 3054909976 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] SPECTACULAR ONE BED CORNER UNIT. FLOOR TO CEILING WINDOWS. MAGNIFICENT VIEWS OF MIAMI SKYLINE AND BAY 0 0 329000 329000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DR 950 [empty string] THE PLAZA ON BRICKEL 0 2008 1004489 1047548 [empty string] [empty string] [empty string] [empty string] 0 3101 [empty string] 2008 33131 [empty string]
3 [empty string] XXXXXXXXXXXXXXXX2 [empty string] 1 0 [empty string] 1 [empty string] [empty string] [empty string] [empty string] 1 [empty string] 762 Miami Y22388 The Plaza on Brikell DADE [empty string] [empty string] [empty string] [empty string] C23,D09,G02,J02,J07,L03,M01,M05,M17,N02,N10,N11,N13,Q08,T01,T04,T12,T28,U01,U03,W28,X11,Y07 12025 [empty string] [empty string] 249 [empty string] 06/20/2008 25.764625120510907 [empty string] THE PLAZA ON BRICKELL UNIT 2102 [empty string] [empty string] [empty string] -80.19091395531997 [empty string] 0 [empty string] [empty string] 3021236 Amador,Alejandro [empty string] 41 D1270757 LPGI01 La Playa Properties Group Inc 3056720773 FL "miamimls [empty string] X 12/04/2008" 13 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/71/D1270757.jpg FL M CONDO [empty string] [empty string] 0 0 340000 340000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] Brickell Bay Dr 950 [empty string] The Plaza on Brickel 0 2008 1005701 1200869 [empty string] [empty string] [empty string] [empty string] 0 3102 [empty string] 2008 33131 [empty string]
4 [empty string] 01-41-00-000-0000 [empty string] 1 0 [empty string] 1 [empty string] [empty string] [empty string] [empty string] 1 [empty string] 0 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,J02,J07,M01,M17,N02,N13,N19,O14,T28,U01,W09,X11,X18,Y07 12025 [empty string] [empty string] 0 [empty string] 12/29/2008 25.76566122576139 [empty string] 950 BRICKELL BAY DRIVE [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 0624132 Hutton,Richard 3052812419 41 D1318062 ADVA02 RE/MAX Advance Realty, Inc. 3054447111 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] ENJOY BEAUTIFUL BAY VIEWS IN THE EXQUISITE BRAND NEW 1 BED, 1 BATH LUXURY BUILDING WITH FULL AMENITIES. 0 0 365000 365000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DR 950 [empty string] THE PLAZA ON BRICKEL 0 2007 261870 1096237 [empty string] [empty string] [empty string] [empty string] 41 1903 [empty string] 2008 33131 [empty string]
5 [empty string] PLAZABRICKELL2300 [empty string] 1 0 [empty string] 1 [empty string] [empty string] [empty string] [empty string] 1 [empty string] 847 Miami Y22388 THE PLAZA ON BRICKELL DADE [empty string] [empty string] [empty string] [empty string] A08,C02,C05,E05,G02,J02,J07,M01,M05,N02,N11,N13,N19,O14,Q01,Q08,T01,T28,U01,U16,W09,W28,Y07 12025 [empty string] [empty string] 435 [empty string] 12/01/2008 25.76566122576139 [empty string] THE PLAZA ON BRICKELL UNIT 2300 [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 3079969 Zavulunov,Eduard 3058642787 41 M1248527 RCRS07 Related Cervera Rlty Services 9544568221 FL "miamimls [empty string] X 07/07/2008" 11 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/81/M1248527.jpg FL M CONDO [empty string] SPECTACULAR LARGEST ONE BEDROOM CORNER UNIT. FLOOR TO CEILING WINDOWS ALLOWING A MAGNIFICENT SKYLINE AND BAY VIEWS. 0 0 369000 369000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DR 950 [empty string] THE PLAZA ON BRICKEL 0 2008 2020163 1224392 [empty string] [empty string] [empty string] [empty string] 0 2300 [empty string] 2008 33131 [empty string]
6 [empty string] [empty string] [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1200 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] C05,D09,E05,G02,J02,M01,M05,M17,N02,N10,N11,N13,N19,T01,T11,T12,T28,U01,W28,W45,X11,Y07 12025 [empty string] [empty string] 0 [empty string] 08/13/2008 25.76566122576139 [empty string] THE PLAZA [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 3121418 Fernandez,Maria [empty string] 41 M1253917 RCRS05 Related Cervera Rlty Services 3053733737 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] Beautiful 2/2 in the heart of Brickell 0 0 415900 415900 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DRIVE 950 [empty string] THE PLAZA 0 2008 2012653 1269016 [empty string] [empty string] [empty string] [empty string] 0 2905 [empty string] 2008 33131 [empty string]
7 [empty string] 0102100301053 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1192 Miami Y22388 THE PLAZA ON BRICKELL DADE [empty string] [empty string] [empty string] [empty string] C02,C05,C23,D09,E05,G02,J02,J07,M01,M05,N02,N03,N10,N11,N13,N19,N29,O14,Q08,T01,T11,T12,T28,U01,U16,U24,W18,W26,W28,W30,X10,X11,X12,Y07 12025 [empty string] [empty string] 0 [empty string] 12/15/2008 25.76566122576139 [empty string] THE PLAZA 851 BRICKELL CONDOMINIUM [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 3120335 Torres,Zeneyda [empty string] 41 D1316313 OWLL01 Owner Alliance LLC 9547627067 FL "miamimls [empty string] X 12/16/2008" 4 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/39/D1316313.jpg FL M CONDO [empty string] IN THE HEART OF BRICKELL AREA STUNNING WATER VIEW FROM THIS BRAND NEW CONDO 2/2,STATE OF THE ART, WALK TO THE RESTAURANTS AND MARKETS!!!DON'T MISS IT! 0 0 430000 430000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DR 950 [empty string] [empty string] 0 2008 1030778 1275499 [empty string] [empty string] [empty string] [empty string] 0 2104 [empty string] 2008 33131 [empty string]
8 [empty string] 01-41-00-000-0001 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1192 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] A08,C02,D09,E05,G02,J02,J07,M01,M05,N02,N10,N11,N13,N19,O14,Q01,Q07,Q08,T01,T11,T12,T16,T28,U01,U03,U16,U24,W09,W11,W26,W28,X07,X11,Y07 12025 [empty string] [empty string] 551 [empty string] 09/02/2008 25.76566122576139 [empty string] THE PLAZA UNIT 4101 [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 0656219 Mendez Alfidi,Kathy [empty string] 41 D1289987 CENF01 Century 21 Premier Elite Rlty 3052798814 FL "miamimls [empty string] X 07/24/2008" 13 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/61/D1289987.jpg FL M CONDO [empty string] BEAUTIFUL OCENA BAY & DOWNTOWN VIEWS. NEVER LIVED IN 2/2 CONDO FULL AMENITIES. 0 0 460000 460000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] brickell bay Dr 950 [empty string] THE PLAZA 0 2007 1022623 1132255 [empty string] [empty string] [empty string] [empty string] 41 4104 [empty string] 2007 33131 [empty string]
9 [empty string] 1410004905 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1192 Miami Y22388 THE PLAZA ON BRICKELL DADE [empty string] [empty string] [empty string] [empty string] A08,D09,E05,G02,J02,M01,M05,M17,N02,N11,N13,N19,Q01,Q08,T01,T28,U01,U03,U16,W16,W28,X10,X11,X12,Y07 12025 [empty string] [empty string] 0 [empty string] 11/06/2008 [empty string] [empty string] THE PLAZA OF BRICKELL CONDO UNIT 4905 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] 3069635 Bokstein,Sheila [empty string] 41 M1268946 RRRI01 R3 International Realty, Inc. 7863427000 FL "miamimls [empty string] X 10/09/2008" 16 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/38/M1268946.jpg FL M CONDO [empty string] Y/ GREAT UNIT PANORAMIC VIEWS 0 0 515000 515000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A [empty string] BRICKELL BAY DR. 950 [empty string] [empty string] 9475 2008 1031327 1210574 [empty string] [empty string] [empty string] [empty string] 41 4905 [empty string] 2008 33131 [empty string]
10 [empty string] 01-41-10-000-2206 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 0 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] C02,D09,E05,G02,J02,J07,M01,M05,N02,N10,N11,N13,N19,N21,O14,Q01,Q07,Q08,T01,T11,T12,T16,T28,U01,U03,W09,W11,W26,W28,X07,X11,Y07 12025 [empty string] [empty string] 493 [empty string] 09/26/2008 25.76566122576139 [empty string] THE PLAZA AT BRICKELL CONDO UNIT 2206 [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 3039466 Blasberg,Debbie [empty string] 41 D1298588 EWM 43 Esslinger Wooten Maxwell Inc 3059372003 FL "miamimls [empty string] X 09/12/2008" 21 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/64/D1298588.jpg FL M CONDO [empty string] WONDERFUL OPPORTUNITY TO OWN IN THE HEART OF BRICKELL. SELLER FINANCING AVAILABLE, DON'T WORRY ABOUT A LOAN APPLICATION. ENJOY BEAUTIFUL OCEAN, BAY .. 0 0 550000 550000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A [empty string] BRICKELL BAY DR 950 [empty string] [empty string] 8000 2008 2017811 1187286 [empty string] [empty string] [empty string] [empty string] 41 2206 [empty string] 2008 33131 [empty string]
11 [empty string] 00-41-01-002-5205 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1192 Miami Y22388 THE PLAZA ON BRICKELL DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,J02,J07,L07,M01,M05,M17,N02,N11,N13,N19,Q01,Q08,T11,T16,T28,U01,U03,U13,U16,W09,W16,W28,X07,X35,Y07 12025 [empty string] [empty string] 404 [empty string] 12/01/2008 25.76566122576139 [empty string] THE PLAZA OF BRICKELL CONDO UNIT 5205 [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 0671072 Petruzzelli,Luz 3057755677 41 M1265523 CBRE68 Coldwell Banker Res. R.E. 3056726300 FL "miamimls [empty string] X 09/20/2008" 16 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/69/M1265523.jpg FL M CONDO [empty string] PANORAMIC VIEWS, SKY RESIDENCE 52TH FLOOR 2 BEDS, 2BATHS, FULL SIZE W&D. GREAT AMENITIES & LOCATION. 0 0 552900 552900 [empty string] [empty string] [empty string] [empty string] [empty string] 2 [empty string] [empty string] A [empty string] BRICKELL BAY DR. 950 [empty string] THE PLAZA OF BRICKEL 9475 2008 2015969 1137573 [empty string] [empty string] [empty string] [empty string] 41 5205 [empty string] 2008 33131 [empty string]
12 [empty string] [empty string] [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1185 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] C02,D09,E05,G02,J02,J07,M01,M05,N02,N10,N11,N13,N19,N21,O14,Q01,Q07,Q08,T01,T04,T11,T12,T16,T28,U01,U03,W09,W11,W26,W28,X07,X11,Y07 12025 [empty string] [empty string] 493 [empty string] 10/30/2008 25.76566122576139 [empty string] THE PLAZA 851 BRICKELL CONDO [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 0667813 Turtula,Cristina [empty string] 41 D1287186 EWM 43 Esslinger Wooten Maxwell Inc 3059372003 FL "miamimls [empty string] X 07/18/2008" 16 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/58/D1287186.jpg FL M CONDO [empty string] GREAT OCEAN, BAY & CITY VIEWS, NEW FULL AMENITY BUILDING IN THE HEART OF BRICKELL FINANCIAL DISTRICT. 0 0 555000 555000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A [empty string] BRICKELL BAY DR 950 [empty string] [empty string] 8000 2008 2017811 1139626 [empty string] [empty string] [empty string] [empty string] 41 5106 [empty string] 2008 33131 [empty string]
13 [empty string] [empty string] [empty string] 2 1 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 0 Miami Y22388 THE PLAZA DADE [empty string] [empty string] [empty string] [empty string] C02,D09,E05,G02,H07,J02,M01,M05,N02,N10,N11,N13,N19,O10,O22,Q01,T01,T12,T16,T28,U01,U16,W16,W28,X07,X09,X12,Y07 12025 [empty string] [empty string] 400 [empty string] 12/15/2008 25.76566122576139 [empty string] THE PLAZA CONDO [empty string] [empty string] [empty string] -80.18966161961745 [empty string] 0 [empty string] [empty string] 0613702 Harris,David [empty string] 41 D1311145 CLAB Clasby & Meyer Real Estate 3056668015 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] PENTHOUSE , UNSURPASSED OCEAN VIEW , 2 MASTE BRDS.SPLIT PLAN 0 0 769000 769000 [empty string] [empty string] [empty string] [empty string] [empty string] 20 [empty string] [empty string] A [empty string] BRICKELL BAY DRIVE 950 [empty string] [empty string] 0 2008 259550 1089176 [empty string] [empty string] [empty string] [empty string] 41 5411 [empty string] 2008 33131 [empty string]
CACHED false
EXECUTIONTIME 547
SQL select * from newMLS where ( newMLS.MLS_LISTING_ID <> '' AND newMLS.STREET_NAME LIKE '%Brickell%' AND newMLS.STREET_NUMBER = '950' AND newMLS.MLS_AREA = '41' ) and newMLS.MLS_Type = '"miamimls' AND newMLS.PROPERTY_TYPE_CODE <> 'R' order by bedrooms asc,SALE_PRICE_int asc
www.dariostoka.com