Dario Stoka Real Estate

Search Results

• Home
• Featured Properties
• Find Property
• Listing Services
• About Dario
• Contact
• Tell A Friend

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] 0242040141020 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 0 Miami Beach Y22391 THE FLORIDIAN DADE [empty string] [empty string] [empty string] [empty string] C05,C13,D09,E05,J02,J07,M01,M05,M17,T28,U01,U03,U16,W28,X10,X11,X12 12025 [empty string] [empty string] 0 [empty string] 11/06/2008 25.776290937999715 [empty string] THE FLORIDIAN CONDO UNIT 2104 [empty string] [empty string] [empty string] -80.14216101257972 [empty string] 0 [empty string] [empty string] 0673687 Torres,Ryna [empty string] 42 M1256875 ONES05 One Stop Realty ONE STOP IS ALL YOU NEED 3055940900 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] GREAT UNIT AT GREAT PRICE .... 0 0 380000 380000 [empty string] [empty string] [empty string] [empty string] [empty string] 4 [empty string] [empty string] A [empty string] WEST AV 650 [empty string] [empty string] 9764 2006 1024015 1137598 [empty string] [empty string] [empty string] [empty string] 42 2104 [empty string] 1997 33139 [empty string] 2 [empty string] 023214001708 [empty string] 2 0 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1904 Miami Beach Y22391 THE BATH CLUB DADE [empty string] [empty string] [empty string] [empty string] C23,D09,E05,G02,M01,M05,M17,N02,N11,N13,N21,O14,Q08,T01,T11,T12,T28,U01,W28,W30,X09,X12,Y07 12025 [empty string] [empty string] 1164 [empty string] 10/22/2008 25.841665085000958 [empty string] THE BATH CLUB UNIT 1708 INT IN COMMON ELEMENTS [empty string] [empty string] [empty string] -80.12134415886337 [empty string] 0 [empty string] [empty string] 0577279 Defortuna,Monica [empty string] 32 M1258730 FINR02 Fortune International Realty 3058562600 FL "miamimls [empty string] X 11/25/2008" 5 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/90/M1258730.jpg FL M CONDO [empty string] [empty string] 0 0 923000 923000 [empty string] [empty string] [empty string] [empty string] [empty string] 14 [empty string] [empty string] A [empty string] COLLINS AVE 5959 [empty string] THE BATH CLUB 0 2007 213971 1051124 [empty string] [empty string] [empty string] [empty string] 32 1708 [empty string] 2005 33140 [empty string] 3 [empty string] 02-42-03-265-1020 [empty string] 2 1 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1425 Miami Beach Y22391 Murano Grande DADE [empty string] [empty string] [empty string] [empty string] A08,E05,J04,M01,M05,N02,N11,N13,N19,T01,T12,T28,U01,W28,X07,X10,X11,X12,Y07 12025 [empty string] [empty string] 881 [empty string] 10/09/2008 25.773210957432966 [empty string] MURANO GRANDE AT PORTOFINO CONDOUNIT 1404 UNDIV 0.25790% INT COMMON ELEMENTS OFF [empty string] [empty string] [empty string] -80.14021137321181 [empty string] 0 [empty string] [empty string] 3074829 Sereny,Bryan [empty string] 42 M1264240 ZLBR01 Zilbert Realty Group Inc. 3057260100 FL "miamimls [empty string] X 11/18/2008" 12 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/20/M1264240.jpg FL M CONDO [empty string] Without a doubt, 1404 is the most sought after 2-bed at Murano Grande. Enjoy DIRECT UNOBSTRUCTED BAY VIEWS. 0 0 1188000 1188000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A [empty string] ALTON RD 400 [empty string] Murano Grande 20094 2007 1021823 1217816 [empty string] [empty string] [empty string] [empty string] 42 1404 http://www.visualtour.com/shownp.asp?sk=13&t=1673021 2003 33139 [empty string] 4 [empty string] 02-32-34-153-1750 [empty string] 1 0 [empty string] 1 [empty string] [empty string] [empty string] [empty string] 1 [empty string] 821 Miami Beach Y22391 Setai DADE [empty string] [empty string] [empty string] [empty string] A08,D09,E05,G02,M01,M05,M17,N02,N11,N21,N29,O07,O14,O16,Q08,T01,T28,U01,U03,U13,U16,W16,W28,X07,X09,X12,X22 12025 [empty string] [empty string] 1486 [empty string] 11/11/2008 25.79542317118776 [empty string] SETAI RESORT & RESIDENCES CONDOUNIT 1805 UNDIV 2.306591% INT IN COMMON ELEMENTS OFF [empty string] [empty string] [empty string] -80.12828482071725 [empty string] 0 [empty string] [empty string] 0668799 Koslowski,Casey [empty string] 32 M1256119 MAJS01 Majestic Properties Lincoln Rd 3053987888 FL "miamimls [empty string] X 08/07/2008" 12 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/57/M1256119.jpg FL M CONDO [empty string] Rarely available 05 line in South Beach's sensational Setai! 0 0 1285000 1285000 [empty string] [empty string] [empty string] [empty string] [empty string] 34 [empty string] [empty string] A [empty string] 20 ST 101 [empty string] Setai 12316 2005 1017244 1180118 [empty string] [empty string] [empty string] [empty string] 32 1805 [empty string] 2004 33139 [empty string] 5 [empty string] 02-42-10-013-1860 [empty string] 2 1 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 2040 Miami Beach Y22391 PORTOFINO TOWERS DADE [empty string] [empty string] [empty string] [empty string] C23,E05,G02,M17,N02,N11,N13,T01,T28,U01,U03,U16,W28,X07,X08,X10,X11,X12,Y07 12025 [empty string] [empty string] 1472 [empty string] 12/04/2008 25.76814091860774 [empty string] PORTOFINO TOWER CONDOUNIT 1506 UNDIV 0.408% INT IN COMMON ELEMENTS OFF [empty string] [empty string] [empty string] -80.13377218184341 [empty string] 0 [empty string] [empty string] 03001837 Franco,Jack [empty string] 42 M1219840 SOPO01 South Pointe Drive Rlty 3056959898 FL "miamimls [empty string] X 10/13/2008" 5 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/20/M1219840.jpg FL M CONDO [empty string] TENANT OCCUPIED CAN SHOW 2X A MONTH ONLY 0 0 1395000 1395000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A S POINTE DR 300 [empty string] [empty string] 19858 2000 1009047 1135470 [empty string] [empty string] [empty string] [empty string] 42 1506 [empty string] 1996 33139 [empty string] 6 [empty string] 31-22-11-071-1700 [empty string] 3 0 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 2214 Sunny Isles Beach 000016 ACQUALINA DADE [empty string] [empty string] [empty string] [empty string] A08,C24,D09,E05,G02,J04,M01,M05,M17,N02,N03,N10,N13,N19,N21,O07,Q08,T02,U01,U03,U18,U24,W26,W28,X07,X09,X12 12025 [empty string] [empty string] 1997 [empty string] [empty string] 25.942072303888263 [empty string] ACQUALINA OCEAN RESIDENCES &RESORT CONDO UNIT 3705 UNDIV 0.3262 % INT [empty string] [empty string] [empty string] -80.12107349440272 [empty string] 0 [empty string] [empty string] 3158131 Joel Matus (305)409-0000 22 D1235573 RRRR01 Riviera Real Estate Corp. 3059377878 FL "miamimls [empty string] X 12/03/2007" 11 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/19/D1235573.jpg FL M CONDO [empty string] AT THE MOST EXTRAORDINARY BUILDING EVER BUILT IN S. FLA: ACQUALINA. EUROPEAN SPA ESPA,3 RESTAURANTS(IL MULINO, AARIA & LA COSTA GRILL), 3 POOLS W/ 0 0 1498000 1498000 [empty string] [empty string] [empty string] [empty string] [empty string] 11 [empty string] [empty string] A [empty string] COLLINS AV 17875 [empty string] ACQUALINA 0 2006 1012976 [empty string] [empty string] [empty string] [empty string] [empty string] 22 3705 [empty string] 2006 33160 [empty string] 7 [empty string] 02-42-03-262-0320 [empty string] 2 1 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1591 Miami Beach Y22391 CONTINUUM ON SOUTH BEACH DADE [empty string] [empty string] [empty string] [empty string] A08,C20,C24,D09,G02,J04,J09,L03,M01,M05,N02,N03,N11,N13,N19,N21,O12,O14,O16,Q01,Q07,T01,T11,T16,U01,U03,U16,W09,W16,W28,W30,X07,X08,X09,X12 12025 [empty string] [empty string] 1800 [empty string] [empty string] 25.76834365768857 [empty string] CONTINUUM ON SOUTH BEACH CONDOTHE SOUTH TOWER UNIT 2201 UNDIV 0.241691% INT [empty string] [empty string] [empty string] -80.13195014201074 [empty string] 0 [empty string] [empty string] 3092986 Bagnasco,Valeria [empty string] 42 D1280155 LPGI01 La Playa Properties Group Inc 3056720773 FL "miamimls [empty string] X 07/21/2008" 16 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/65/D1280155.jpg FL M CONDO [empty string] [empty string] 0 0 1550000 1550000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A S POINTE DR 100 [empty string] [empty string] 20097 2007 1005701 1235963 [empty string] [empty string] [empty string] [empty string] 42 2201 [empty string] 2002 33139 [empty string] 8 [empty string] 02-42-03-262-2203 [empty string] 2 1 [empty string] 2 [empty string] [empty string] [empty string] [empty string] 2 [empty string] 1922 Miami Beach Y22391 Continuum North Tower DADE [empty string] [empty string] [empty string] [empty string] A08,C05,D09,E05,M01,M05,N02,N11,N13,N19,N21,O17,T01,T12,T17,T28,U01,U13,W28,W30,X07,X08,X12 12025 [empty string] [empty string] 1552 [empty string] 12/15/2008 [empty string] [empty string] CONTINUUM ON SOUTH BEACH THE NORTH TOWER UNIT 2203 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] 3040123 Zilbert,Mark [empty string] 42 M1243584 ZLBR01 Zilbert Realty Group Inc. 3057260100 FL "miamimls [empty string] X 06/23/2008" 8 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/52/M1243584.jpg FL M CONDO [empty string] Spacious 2-bedroom corner unit at South Beach's Continuum II. 10-foot ceilings and private elevator foyer. Dramatic water views. Easy to show! 0 0 1599000 1599000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A S Pointe Drive 50 [empty string] Continuum North 0 2007 1021823 1188184 [empty string] [empty string] [empty string] [empty string] 42 2203 http://www.visualtour.com/shownp.asp?SK=13&T=1573381 2008 33139 [empty string] 9 [empty string] 02-42-03-265-0420 [empty string] 5 1 [empty string] 5 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 3979 Miami Beach Y22391 MURANO GRANDE DADE [empty string] [empty string] [empty string] [empty string] C23,E05,G02,M17,N02,N11,N13,N19,T01,T28,U01,U03,U16,W28,X07,X08,X10,X11,X12,Y07 12025 [empty string] [empty string] 2366 [empty string] 09/22/2008 25.773210957432966 [empty string] MURANO GRANDE AT PORTOFINO CONDOUNIT 3401 UNDIV 0.72013% INT COMMON ELEMENTS OFF [empty string] [empty string] [empty string] -80.14021137321181 [empty string] 0 [empty string] [empty string] 0431257 Lennon,John [empty string] 42 M1096490 SOPO01 South Pointe Drive Rlty 3056959898 FL "miamimls [empty string] X 10/30/2006" 8 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/70/M1096490.jpg FL M CONDO [empty string] NONE 0 0 3495000 3495000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A [empty string] ALTON RD 400 [empty string] [empty string] 40048 2000 1009047 1137539 [empty string] [empty string] [empty string] [empty string] 42 3401 [empty string] 2003 33139 [empty string] 10 [empty string] 02-32-34-153-1020 [empty string] 4 0 [empty string] 4 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 2880 Miami Beach Y22391 The Setai DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,J02,J04,J09,M01,M05,N11,N19,O16,T02,T28,U01,U03,W28,X07,X09,X12,Y07 12025 [empty string] [empty string] 4364 [empty string] 12/14/2008 25.79542317118776 [empty string] SETAI RESORT & RESIDENCES CONDOUNIT 2501 UNDIV 3.167783% INT IN COMMON ELEMENTS OFF [empty string] [empty string] [empty string] -80.12828482071725 [empty string] 0 [empty string] [empty string] 3130268 Hamersley,Tracie [empty string] 32 M1257569 MAJS01 Majestic Properties Lincoln Rd 3053987888 FL "miamimls [empty string] X 08/14/2008" 15 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/07/M1257569.jpg FL M CONDO [empty string] Reduced from $4.995M! Rarely available 4BD / 4 BA, 2,900 SQ FT corner residence w/ spectacular 270 degrees of the ocean. 0 0 3595000 3595000 [empty string] [empty string] [empty string] [empty string] [empty string] 34 [empty string] [empty string] A [empty string] 20 ST 101 [empty string] [empty string] 27840 2007 1017244 1272437 [empty string] [empty string] [empty string] [empty string] 32 2501/2 [empty string] 2004 33139 [empty string]
CACHED	false
EXECUTIONTIME	578
SQL	select * from newMLS where ( newMLS.MLS_LISTING_ID <> '' ) and newMLS.MLS_Type = '"miamimls' and newMLS.MLS_LISTING_ID in ('M1261282','D1235573','M1258730','M1259891','M1251108','D1280155','M1236803','M1243584','D1280401','D1268289','M1256875','M1198868','D1190486','M1259543','M1257940','M1261457','M1179244','M1221681','M1248164','M1264240','M1096490','M1219840','M1241021','M1217327','M1153486','M1257569','M1256119','M1175036','M1235165','M1230076','M1191607') order by SALE_PRICE_int

www.dariostoka.com