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] 02-42-10-000-0120 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 0 Miami Beach Y22391 Apoggee Condominium DADE [empty string] [empty string] [empty string] [empty string] C13,C23,C24,D09,E05,G04,I13,L03,M01,M05,N01,N11,N13,N19,N21,O10,O17,T02,T23,T28,U01,U03,U16,U18,W28,X07,X10,X11,X12,X18,Y07 12025 [empty string] [empty string] 2966 [empty string] 12/01/2008 25.768072297918394 [empty string] APOGEE CONDOMINIUM [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0431257 Lennon,John [empty string] 42 M1281355 SOPO01 South Pointe Drive Rlty 3056959898 FL "miamimls [empty string] X 12/01/2008" 8 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/65/M1281355.jpg FL M CONDO [empty string] A one of a kind Apogee most exclusive building in South Beach only 67 exclusive homes in the sky. 0 0 3750000 3750000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A [empty string] South Pointe Drive 800 [empty string] [empty string] 0 2008 1009047 1137539 [empty string] [empty string] [empty string] [empty string] 42 602 [empty string] 2008 33139 [empty string] 2 [empty string] 02-42-10-017-0010 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 3103 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,L03,L04,M01,M05,M17,N02,N11,N13,N19,O17,T02,T12,T28,U01,U03,U18,U24,W30,X10,X11,X12,Y07 12025 [empty string] [empty string] 2966 [empty string] 06/10/2008 25.768072297918394 [empty string] APOGEEPB 164-008 T-22128 TRACT A LOT SIZE 0.721 AC FAU [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 31392 [empty string] [empty string] 0667445 Campins,Katrina [empty string] 42 M1225194 CAMC01 Campins Company LLC 3055312277 FL "miamimls [empty string] X 10/14/2008" 16 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/82/M1225194.jpg FL M CONDO [empty string] JOIN THE PRIVILEGED FEW - OWN A RESIDENCE AT PRESTIGIOUS APOGEE! 0 0 3990000 3990000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A S POINTE 800 [empty string] APOGEE 12666 2008 1019592 1155122 [empty string] [empty string] [empty string] [empty string] 42 902 [empty string] 2008 33139 [empty string] 3 [empty string] 02-42-10-000-1502 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 0 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] C13,C23,D09,E05,G02,I13,M01,M05,N01,N10,N11,N13,N19,O14,O17,T02,T16,T23,T28,U01,U03,U16,U18,U24,W28,W30,X07,X12,Y07 12025 [empty string] [empty string] 2966 [empty string] 12/04/2008 25.768072297918394 [empty string] THAT PART OF N132FT SMITHCOTTAGES TR B PER DB 3459-470 & 472 LOT SIZE 52800 SQ FT OR 2 [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 52800 [empty string] [empty string] 0431257 Lennon,John [empty string] 42 M1246616 SOPO01 South Pointe Drive Rlty 3056959898 FL "miamimls [empty string] X 06/29/2008" 10 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/48/M1246616.jpg FL M CONDO [empty string] . 0 0 4200000 4200000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A S POINTE DR 800 [empty string] [empty string] 48168 2008 1009047 1137539 [empty string] [empty string] [empty string] [empty string] 42 1502 [empty string] 2008 33139 [empty string] 4 [empty string] 0000000000011503 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 3103 Miami Beach Y22391 APOGEE SOUTH BEACH DADE [empty string] [empty string] [empty string] [empty string] C02,D09,E05,I13,L03,M01,M05,M17,N01,N02,N11,N13,N19,N21,O17,Q01,Q08,T02,T11,T12,T16,T28,U01,U03,U16,U18,W28,W30,X07,X10,X11,X12,X18,Y07 12025 [empty string] [empty string] 2966 [empty string] 11/12/2008 [empty string] [empty string] APOGEE SOUTH BEACH [empty string] [empty string] [empty string] [empty string] [empty string] 4133 [empty string] [empty string] 3139146 Guadalpi,Valerie [empty string] 42 M1258909 CTGR01 City Realty Group Int'l, LLC 3056046000 FL "miamimls [empty string] X 08/20/2008" 13 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/27/M1258909.jpg FL M CONDO [empty string] AMAZING APOGEE - MIAMI'S FINEST FULL SERVICE BOUTIQUE BUILDING IN SOUTH BEACH ONLY 67 EXCLUSIVE UNITS !!! THE ABSOLUTE LUXURY OF THE GLASS TERRACED 0 0 4300000 4300000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A S POINTE DR. 800 [empty string] APOGEE 0 2007 1025446 1284836 67 [empty string] [empty string] [empty string] 42 1503 [empty string] 2008 33139 [empty string] 5 [empty string] 02-42-10-339-0360 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 3103 Miami Beach Y22391 Apogee Condominium DADE [empty string] [empty string] [empty string] [empty string] C13,D09,E05,G02,I13,J04,M01,M05,N01,N03,N11,N13,N19,N21,O17,T02,T28,U01,U03,U16,U18,U24,W28,X10,X11,X12,X18,Y07 12025 [empty string] [empty string] 2966 [empty string] 12/15/2008 25.768072297918394 [empty string] APOGEE CONDOMINIUM [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0431257 Lennon,John [empty string] 42 M1284612 SOPO01 South Pointe Drive Rlty 3056959898 FL "miamimls [empty string] X 12/15/2008" 10 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/36/M1284612.jpg FL M CONDO [empty string] Apogee - Miami Beach's finest full service boutique building only 67 exclusive units!!!! Turn Key ready to move in. A must see. 0 0 4395000 4395000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A [empty string] South Pointe Drive 800 [empty string] [empty string] 0 2008 1009047 1137539 [empty string] [empty string] [empty string] [empty string] 42 803 [empty string] 2008 33139 [empty string] 6 [empty string] [empty string] [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 3100 Miami Beach Y22391 Apogee DADE [empty string] [empty string] [empty string] [empty string] C05,E05,G02,J04,J09,M01,M05,N11,N19,T02,T12,T19,T28,U13,U18,X07,X10,X11,X12,Y07 12025 [empty string] [empty string] 2965 [empty string] 11/07/2008 25.768072297918394 [empty string] APOGEE CONDO UNIT 1202 UNDIV 1.23276% INT IN COMMON ELEMENTS OFF REC 26133-2394 COC 26236-0866 02 2008 1 [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0551544 Hertzberg,Jill [empty string] 42 M1275444 CBRE68 Coldwell Banker Res. R.E. 3056726300 FL "miamimls [empty string] X 12/10/2008" 4 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/32/M1275444.jpg FL M CO-OP [empty string] Chic, sophisticated, Gorgeous Views of Fisher Island, Ocean, South Beach. Flow-thru apartment. Best building. 0 0 4675000 4675000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A S Pointe DR 800 [empty string] [empty string] 0 2008 2015969 1045938 [empty string] [empty string] [empty string] [empty string] 42 1202 [empty string] 2007 33139 [empty string] 7 [empty string] 02-42-00-000-1902 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 3100 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] A08,D09,M01,M05,M17,N11,Q01,Q08,T02,T11,T12,T28,U18,W09,W45,X07,X10,X11,X12,Y07 12025 [empty string] [empty string] 0 [empty string] [empty string] 25.768072297918394 [empty string] APOGEE [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0698062 Fernandez-Pascual,Alex [empty string] 42 M1235613 RCRS03 Related Cervera Rlty Services 3056958722 FL "miamimls [empty string] X 05/14/2008" 14 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/39/M1235613.jpg FL M CONDO [empty string] THE ULTIMATE IN LUXURY LIVING. 0 0 5299000 5299000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A S POINTE 800 [empty string] [empty string] 0 2008 2012038 1156540 [empty string] [empty string] [empty string] [empty string] 42 1902 [empty string] 2008 33139 [empty string] 8 [empty string] 0242100000120 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 3 [empty string] 3100 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,I13,M17,N03,N11,N13,N19,N21,O14,T02,T11,T16,T28,U01,U18,W06,W18,W28,W30,X07,X08,X10,X11,X12,Y07 12025 [empty string] [empty string] 2966 [empty string] 07/23/2008 25.768072297918394 [empty string] .. [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0639913 Puig,Dora [empty string] 42 M1243499 PWRE01 Puig Werner Real Estate Svcs. 3056132118 FL "miamimls [empty string] X 06/23/2008" 36 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/97/M1243499.jpg FL M CONDO [empty string] . 0 0 5750000 5750000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A S Pointe Dr. 800 [empty string] [empty string] 0 2008 1027699 1116276 [empty string] [empty string] [empty string] [empty string] 42 2002 http://www.circlepix.com/home2/68T8C9 2008 33139 [empty string] 9 [empty string] 02-42-03-339-0010 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 4100 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,M01,M05,M17,N11,N13,N19,Q01,Q08,T02,T04,T11,T12,T28,U01,U16,W06,W28,X07,X10,X11,X12,X35,Y07 12025 [empty string] [empty string] 3966 [empty string] 11/12/2008 [empty string] [empty string] APOGEE CONDO UNIT [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] 0631662 Cervera Quarra,Exilda-Sildy [empty string] 42 M1277635 RCRS04 Related Cervera Rlty Services 3056040565 FL "miamimls [empty string] [empty string] " 0 [empty string] FL M CONDO [empty string] THE MOST SOUGHT AFTER LINE AT APOGEE, 4100sqft. OF LIVING AREA AND 2400sqft. SPECTACULAR CORNER UNIT. 0 0 5900000 5900000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A S POINTE 800 [empty string] THE RELATE GROUP 0 2008 2013064 1124041 67 [empty string] [empty string] [empty string] 42 501 http://www.realtourvision.com/rst.new.php?opt=5&utl=BU-2964-G98UP2-01 2007 33139 [empty string] 10 [empty string] 0242033390490 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 4154 Miami Beach Y22391 Apogee Condo DADE [empty string] [empty string] [empty string] [empty string] A08,E05,G02,M01,M05,N02,N11,N13,N19,T02,T12,T28,U01,W06,W28,W30,X07,X10,X11,X12 12025 [empty string] [empty string] 3944 [empty string] 12/11/2008 25.768072297918394 [empty string] APOGEE CONDO UNIT 504 [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 3074829 Sereny,Bryan [empty string] 42 M1283816 ZLBR01 Zilbert Realty Group Inc. 3057260100 FL "miamimls [empty string] X 12/12/2008" 8 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/48/M1283816.jpg FL M CONDO [empty string] Apogee South Beach, Southeast Florida's most exclusive condominium with 67 residences. #504, a 4154 sq ft 4 bed condo with views in 3 directions. 0 0 6234000 6234000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A S Pointe Drive 800 [empty string] Apogee Condo 0 2008 1021823 1217816 [empty string] [empty string] [empty string] [empty string] 42 504 http://www.visualtour.com/shownp.asp?sk=13&t=1753554 2008 33139 [empty string] 11 [empty string] 02-42-03-000-0604 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 4154 Miami Beach Y22391 APOGEE CONDO DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G04,I13,L07,L08,M01,M05,M17,N01,N02,N03,N11,N13,N19,N21,O10,O16,O22,Q01,T02,T12,T16,T19,T28,U01,U03,U16,U18,U24,W01,W09,W10,W28,W30,W45,X07,X08,X10,X11,X12,X18,Y07 12025 [empty string] [empty string] 3997 [empty string] 09/10/2008 25.768072297918394 [empty string] APOGEE CONDO UNIT 604 [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0416207 Batchelor,Nancy 3058678146 42 D1253482 EWM 03 Esslinger-Wooten-Maxwell, Inc. 3059602400 FL "miamimls [empty string] X 09/18/2008" 40 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/46/D1253482.jpg FL M CONDO [empty string] Rare opportunity For the ultimate life style. Best line with ocean, city & 280 degree unobstructed views! Unit is 4154 sq ft as per Developer. 0 0 6750000 6750000 [empty string] [empty string] [empty string] [empty string] [empty string] 3 [empty string] [empty string] A S POINTE DR 800 [empty string] APOGEE CONDO 0 2008 2020128 1120701 [empty string] [empty string] [empty string] [empty string] 42 604 http://homesite.obeo.com/Viewer/Unbranded.aspx?tourid=496246 2008 33139 [empty string] 12 [empty string] 02-42-10-000-1104 [empty string] 5 [empty string] [empty string] 5 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 4154 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] C13,D09,G02,I13,L04,M17,N01,N03,N11,N13,N19,N21,O14,O17,T02,T11,T12,T19,T23,T28,U01,U03,U13,U18,U24,W06,W18,W28,W30,X07,X08,X10,X11,X12,X18,Y07 12025 [empty string] [empty string] 3944 [empty string] 10/13/2008 25.768072297918394 [empty string] THAT PART OF N132FT SMITHCOTTAGES TR B PER DB 3459-470 & 472 LOT SIZE 52800 SQ FT OR 2 [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0631667 Chasens,Penni [empty string] 42 M1221143 CERN01 Cervera Real Estate, Inc. 3053743434 FL "miamimls [empty string] X 03/18/2008" 16 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/29/M1221143.jpg FL M CONDO [empty string] [empty string] 0 0 6800000 6800000 [empty string] [empty string] [empty string] [empty string] [empty string] 10 [empty string] [empty string] A S POINTE DR 800 [empty string] APOGEE 0 2008 228158 1105616 [empty string] [empty string] [empty string] [empty string] 42 1104 [empty string] 2008 33139 [empty string] 13 [empty string] 02-42-00-000-2001 [empty string] 3 1 [empty string] 3 [empty string] [empty string] [empty string] [empty string] 4 [empty string] 4154 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,I13,M17,N03,N11,N13,N19,N21,O14,T02,T11,T16,T28,U01,U16,U18,W06,W18,W28,W30,X07,X08,X10,X11,X12,Y07 12025 [empty string] [empty string] 3944 [empty string] 07/23/2008 25.768072297918394 [empty string] * [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 52800 [empty string] [empty string] 0639913 Puig,Dora [empty string] 42 M1243478 PWRE01 Puig Werner Real Estate Svcs. 3056132118 FL "miamimls [empty string] X 06/23/2008" 39 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/34/M1243478.jpg FL M CONDO [empty string] . 0 0 7750000 7750000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A S Pointe Dr 800 [empty string] [empty string] 0 2008 1027699 1116276 [empty string] [empty string] [empty string] [empty string] 42 2001 http://www.circlepix.com/home2/68RLJM 2008 33139 [empty string] 14 [empty string] 02-42-03-339-0650 [empty string] 7 1 [empty string] 7 [empty string] [empty string] [empty string] [empty string] 6 [empty string] 6853 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] C13,C24,D09,E05,G02,J04,M01,M05,N01,N13,N19,N21,O07,O08,O14,O22,T02,T12,T16,T19,T28,U01,U03,U16,U18,W16,W34,X07,X10,X11,X12,X35,Y07 12025 [empty string] [empty string] 6232 [empty string] 11/25/2008 25.768072297918394 [empty string] UNIT 2201 APOGEE, A CONDOMINIUM, ACCORDING TO THE DECLARATION THEREOF RECORDED IN OFFICIAL RECORDS BOOK 26133, PAGE 2394, OF PUBLIC RECORDS. [empty string] [empty string] [empty string] -80.13609434849624 [empty string] [empty string] [empty string] [empty string] 0197819 Percal,Esther [empty string] 42 M1250760 EWM 04 Esslinger-Wooten-Maxwell, Inc 3056721300 FL "miamimls [empty string] X 07/18/2008" 5 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/80/M1250760.jpg FL M CONDO [empty string] Penthouse A commands the top 2 floors of Apogee & is completed with 360-degree rooftop palazzo & private pool with a summer kitchen. 0 0 22000000 22000000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A S POINTE DRIVE 800 [empty string] [empty string] 0 2008 2006829 1029483 [empty string] [empty string] [empty string] [empty string] 42 PHA http://homesite.obeo.com/Viewer/Unbranded.aspx?tourid=489584 2008 33139 [empty string] 15 [empty string] 09 [empty string] 6 2 [empty string] 6 [empty string] [empty string] [empty string] [empty string] 7 [empty string] 7254 Miami Beach Y22391 APOGEE DADE [empty string] [empty string] [empty string] [empty string] D09,E05,G02,M17,N11,N13,N19,N21,O14,T03,T11,T16,T28,U01,U16,U18,W06,W30,X09,X10,X11,X12,X18,Y07 12025 [empty string] [empty string] 6910 [empty string] 07/23/2008 25.768072297918394 [empty string] N/A [empty string] [empty string] [empty string] -80.13609434849624 [empty string] 0 [empty string] [empty string] 0639913 Puig,Dora [empty string] 42 M1249451 PWRE01 Puig Werner Real Estate Svcs. 3056132118 FL "miamimls [empty string] X 11/18/2008" 25 http://extimages2.living.net/ImagesHomeProd6/FL/idx/photos/miamimls/53/M1249451.jpg FL M CONDO [empty string] .. 0 0 17750000 17750000 [empty string] [empty string] [empty string] [empty string] [empty string] 0 [empty string] [empty string] A S Pointe Dr 800 [empty string] [empty string] 0 2008 1027699 1116276 [empty string] [empty string] [empty string] [empty string] 42 2001/2 [empty string] 2008 33139 [empty string]
CACHED	true
EXECUTIONTIME	0
SQL	select * from newMLS where ( newMLS.MLS_LISTING_ID <> '' AND newMLS.STREET_NAME LIKE '%pointe%' AND newMLS.STREET_NUMBER = '800' AND newMLS.MLS_AREA = '42' ) and newMLS.MLS_Type = '"miamimls' AND newMLS.PROPERTY_TYPE_CODE <> 'R' order by bedrooms asc,SALE_PRICE_int asc

www.dariostoka.com