<!--SELECT re2_listings.ID,re2_listings.sysid,re2_listings.mls,re2_listings.unit,re2_listings.bedrooms,re2_listings.price,re2_listings.sqft,re2_listings.last_price FROM re2_listings WHERE status in ('Active','Active With Contract') AND ((street_number = '2805' AND street_name LIKE '185th St%' AND compass_point = 'NORTHEAST') OR (street_number = '2757' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18414' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2804' AND street_name LIKE '184 Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18424' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2733' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2755' AND street_name LIKE '184th Way%' AND compass_point = 'NORTHEAST') OR (street_number = '18415' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2751' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18422' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2759' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '2706' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18413' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2729' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2800' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '2743' AND street_name LIKE '184th Way%' AND compass_point = 'NORTHEAST') OR (street_number = '18410' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2708' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18428' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2753' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18418' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2727' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2710' AND street_name LIKE '184 Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '2757' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST')  AND zipcode = '33180' ) ORDER BY price ASC--><div class="property_table"><!--SELECT re2_listings.ID,re2_listings.sysid,re2_listings.mls,re2_listings.unit,re2_listings.bedrooms,re2_listings.price,re2_listings.sqft,re2_listings.last_price FROM re2_listings WHERE status = 'Pending Sale' AND ((street_number = '2805' AND street_name LIKE '185th St%' AND compass_point = 'NORTHEAST') OR (street_number = '2757' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18414' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2804' AND street_name LIKE '184 Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18424' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2733' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2755' AND street_name LIKE '184th Way%' AND compass_point = 'NORTHEAST') OR (street_number = '18415' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2751' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18422' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2759' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '2706' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18413' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2729' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2800' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '2743' AND street_name LIKE '184th Way%' AND compass_point = 'NORTHEAST') OR (street_number = '18410' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2708' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18428' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2753' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18418' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2727' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2710' AND street_name LIKE '184 Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '2757' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST')  AND zipcode = '33180' ) ORDER BY price ASC--><div class="property_table"><!--SELECT rnt_listings.ID,rnt_listings.sysid,rnt_listings.mls,rnt_listings.unit,rnt_listings.bedrooms,rnt_listings.price,rnt_listings.sqft,rnt_listings.last_price,rnt_listings.rent_period FROM rnt_listings WHERE status in ('Active','Active With Contract') AND ((street_number = '2805' AND street_name LIKE '185th St%' AND compass_point = 'NORTHEAST') OR (street_number = '2757' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18414' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2804' AND street_name LIKE '184 Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18424' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2733' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2755' AND street_name LIKE '184th Way%' AND compass_point = 'NORTHEAST') OR (street_number = '18415' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2751' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18422' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2759' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '2706' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18413' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2729' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2800' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '2743' AND street_name LIKE '184th Way%' AND compass_point = 'NORTHEAST') OR (street_number = '18410' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2708' AND street_name LIKE '184th Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '18428' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2753' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST') OR (street_number = '18418' AND street_name LIKE '27th Ct%' AND compass_point = 'NORTHEAST') OR (street_number = '2727' AND street_name LIKE '184th Ln%' AND compass_point = 'NORTHEAST') OR (street_number = '2710' AND street_name LIKE '184 Ter%' AND compass_point = 'NORTHEAST') OR (street_number = '2757' AND street_name LIKE '184 Wy%' AND compass_point = 'NORTHEAST')  AND zipcode = '33180' ) ORDER BY price ASC--><div class="property_table">{"id":186454,"date":"2014-10-15T05:34:30","date_gmt":"2014-10-15T05:34:30","guid":{"rendered":"https:\/\/miamiresidential.com\/?p=186454"},"modified":"2023-03-22T17:13:25","modified_gmt":"2023-03-22T17:13:25","slug":"terzetto-villas","status":"publish","type":"post","link":"https:\/\/miamiresidential.com\/es\/terzettovillas\/","title":{"rendered":"Terzetto Villas"},"content":{"rendered":"<p><\/div><\/div><\/div><div class=\"property_table\"><h2 id=\"RecentlySold\">Vendidos<\/h2><table>\n\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>Unidad<\/td>\n\t\t\t\t\t\t\t\t<td>Precio<\/td>\n\t\t\t\t\t\t\t\t<td>SF<\/td>\n\t\t\t\t\t\t\t\t<td>$\/SF<\/td>\n\t\t\t\t\t\t\t\t<td>Fecha de Venta<\/td>\n\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t<\/thead><tbody><tr>\n\t\t\t\t\t\t\t<td><\/td>\n\t\t\t\t\t\t\t<td>$710,000<\/td>\n\t\t\t\t\t\t\t<td>1745 SF<\/td>\n\t\t\t\t\t\t\t<td>$407<\/td>\n\t\t\t\t\t\t\t<td>01\/31\/2025<\/td>\n\t\t\t\t\t\t  <\/tr><tr>\n\t\t\t\t\t\t\t<td>118<\/td>\n\t\t\t\t\t\t\t<td>$679,000<\/td>\n\t\t\t\t\t\t\t<td>1729 SF<\/td>\n\t\t\t\t\t\t\t<td>$393<\/td>\n\t\t\t\t\t\t\t<td>04\/20\/2023<\/td>\n\t\t\t\t\t\t  <\/tr><\/tbody><\/table><h2 id=\"RecentlySold\">Alquilado<\/h2><table>\n\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t<td>Unidad<\/td>\n\t\t\t\t\t\t\t\t<td>Precio<\/td>\n\t\t\t\t\t\t\t\t<td>SF<\/td>\n\t\t\t\t\t\t\t\t<td>$\/SF<\/td>\n\t\t\t\t\t\t\t\t<td>Fecha de Alquiler<\/td>\n\t\t\t\t\t\t\t<\/tr>\n\t\t\t\t\t\t\t<\/thead><tbody><tr>\n\t\t\t\t\t\t\t<td>2729<\/td>\n\t\t\t\t\t\t\t<td>$38,009<\/td>\n\t\t\t\t\t\t\t<td>1745 SF<\/td>\n\t\t\t\t\t\t\t<td>$22<\/td>\n\t\t\t\t\t\t\t<td>06\/01\/2026<\/td>\n\t\t\t\t\t\t  <\/tr><tr>\n\t\t\t\t\t\t\t<td>18413<\/td>\n\t\t\t\t\t\t\t<td>$5,000<\/td>\n\t\t\t\t\t\t\t<td>1785 SF<\/td>\n\t\t\t\t\t\t\t<td>$3<\/td>\n\t\t\t\t\t\t\t<td>08\/01\/2025<\/td>\n\t\t\t\t\t\t  <\/tr><tr>\n\t\t\t\t\t\t\t<td>2729<\/td>\n\t\t\t\t\t\t\t<td>$3,800<\/td>\n\t\t\t\t\t\t\t<td>1745 SF<\/td>\n\t\t\t\t\t\t\t<td>$2<\/td>\n\t\t\t\t\t\t\t<td>12\/01\/2024<\/td>\n\t\t\t\t\t\t  <\/tr><\/tbody><\/table><\/div><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/share.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Pinterest\",\"Linkedin\",\"Email\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"big\";var hupso_image_folder_url = \"\";var hupso_url_t=\"\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div><button class=\"simplefavorite-button\" data-postid=\"186454\" data-siteid=\"2\" data-groupid=\"1\" data-favoritecount=\"0\" style=\"\">Favorite <i class=\"sf-icon-star-empty\"><\/i><\/button>","protected":false},"excerpt":{"rendered":"<p>Favorite<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[47],"tags":[],"class_list":["post-186454","post","type-post","status-publish","format-standard","hentry","category-aventura"],"_links":{"self":[{"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/posts\/186454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/comments?post=186454"}],"version-history":[{"count":1,"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/posts\/186454\/revisions"}],"predecessor-version":[{"id":267560,"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/posts\/186454\/revisions\/267560"}],"wp:attachment":[{"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/media?parent=186454"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/categories?post=186454"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/miamiresidential.com\/es\/wp-json\/wp\/v2\/tags?post=186454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}