v2-SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
					 WHERE 1=1  AND wp_posts.ID IN (571039,773648,792141,773356,339565,543909,557798,559640,562528,564288,590401,613358,613600,621801,625404,751511,758840,761996,770629,773877,775994,778035,792934,590140,768712,772866,552488,560923,589607,590559,624754,638040,751148,752935,782331,789398,284345,282971,283378,587705,589168,597061,628320,630267,638575,588739,590613,545057,571174,592052,598860,608432,616249,797861,637251,278614,561577,792889,641118,598609,617095,635185,639170,643035,797283,553012,756380,775799,780121,788046,793647,765624,284167,603438,803820,542851,570595,759361,759578,772000,775421,769293,776724,281721,275339,280856,283864,635199,276451,280768,282303,285961,633246,636541,544342,547363,565464,631957,786812,605684,551436,585571,609312,771562,784401,567053,616123,782559,612496,549108,569665,600406,751917,774143,596110,584478,629389,630678,342072,560069,754660,778478,632037,608599,620365,752602,801485,799929,760830,633058,592985,608403,610891,620192,624371,643199,606734,631810,342625,603262,614359,773740,806973,627746,284595,609708,625310,776213,347202,570011,630715,769934,777735,770944,626700,637576,797672,542054,543687,566365,569813,757345,784823,788753,592337,624886,618339,279353,589972,599363,601717,602758,623214,632569,636345,802086,589095,615849,626936,633574,341721,569370,770436,779572,585350,593173,602853,608813,638091,641099,589409,637321,608246,613489,805076,632940,595448,798166,631793,762299,595772,600450,607066,610601,613767,614683,621312,625513,798924,802656,601020,605855,611103,779968,546396,806486,586116,596867,763941,795982,281541,766831,278971,608655,802362,767422,586404,592742,635156,600003,788309,554241,568026,630897,756438,771308,542553,613565,766126,778590,766871,641738,543185,558348,760145,769179,770897,618509,560037,629063,797331,754889,617949,342459,603511,620017,630128,630161,757019,793476,545184,559494,767982,786578,550340,570770,756984,766502,767253,777980,787163,776186,777277,778580,784522,793600,625350,591534,591890,616239,757879,767059,768114,780075,788000,543105,585637,590203,590427,593418,593441,598031,600363,604707,614855,615418,622709,630991,634704,770825,778963,784578,787690,790399,590652,614181,619891,630251,635228,636193,589542,542093,585933,623763,806063,795622,798971,595495,612013,613375,616969,637737,639008,641059,750865,772722,776543,784865,792272,591061,601441,609366,611259,629588,634144,638277,795290,800286,620064,598770,611623,615275,627173,808181,754473,759853,767144,784802,568782,608191,584621,599120,602286,615883,621491,643068,794810,758074,770283,630501,591691,607337,612930,642126,607100,760604,564617,598359,599734,802750,791241,621028,592945,628294,590108,617970,636310,809484,591228,592959,594475,597853,599195,601369,604132,628626,628976,639085,795578,802200,792170,597607,608129,623556,640680,795122,809366,604866,628057,795863,614127,781552,620960,627010,348346,566683,571336,759817,767312,773841,548346,560101,597149,753827,764221,777834,778515,781494,788878,630736,585518,591600,593615,622049,626640,636842,638779,618672,786660,558752,772487,781958,793782,630805,807304,625144,635253,635850,641370,750644,757494,787920,793139,342805,626460,632363,795119,547800,551821,555717,558503,595666,611792,630363,751032,772515,604046,781507,609051,566457,610435,610964,624436,635659,636108,805827,752239,602105,561678,593121,595570,586501,608066,616211,620089,544565,611554,751783,585396,608846,640237,587274,804582,556090,752077,756699,764494,615335,542066,548259,633325,781914,782195,617997,641187,802897,547286,552563,589257,600123,609244,613460,624237,640218,753602,757326,763827,765769,774473,550215,631085,773102,783164,558882,790026,587400,764470,766148,564852,590087,616296,629777,630338,631746,759443,761062,800809,280033,759401,776799,609980,622761,633887,639750,773979,589239,615005,802878,280075,607055,799510,621346,759103,769909,779240,758324,769697,781765,338957,542761,543702,548993,550936,554730,562951,765971,773196,795660,641974,617701,753766,348908,547372,634028,759202,785297,789543,797955,630392,808563,632592,787870,338693,544494,570953,772749,782991,586902,621753,622398,624085,545871,567547,752419,763639,771748,782156,545855,753967,769971,609869,634398,641336,806934,566275,638328,758271,759311,761408,786692,341849,567888,753053,780818,342567,549277,551567,560471,758477,761311,763428,787664,605314,626839,641940,547843,543801,553615,556634,563433,565094,758907,779413,785353,596576,613528,615476,620861,630068,633338,763143,759964,348874,550752,630615,776879,587192,591300,604298,619188,619983,622462,627776,637934,541859,552144,554937,555252,556696,556929,557732,564482,592844,598398,642309,756568,757983,758256,762480,763688,764525,765129,765836,771682,776137,781166,789203,793023,557915,557965,560612,569789,640726,753530,761141,763072,769053,775046,780883,782908,341123,587250,341030,541241,558194,559277,565963,567012,594178,773673,783093,793722,550056,553460,556294,557340,561527,563329,569738,614024,754446,755792,769321,774393,780376,788199,278831,589792,602590,606302,633292,590933,764755,765391,789033,809317,588171,599442,794692,566025,756710,607815,614892,586660,591706,592435,596350,616375,627621,628245,629428,764685,768809,778925,784161,804750,541472,772124,548495,548924,560512,563172,569688,570733,779314,340025,545076,754112,769115,542694,544977,553290,556134,563550,565894,566832,634662,759547,771458,772182,772714,793348,557444,569398,606175,765328,555099,559062,752776,760547,778870,787572,787884,790531,602632,546574,549437,551379,556672,562878,768056,786822,341664,555396,584736,586988,623256,627920,628176,631358,636040,643178,804339,337758,338253,339687,346286,544429,549829,551497,558369,560206,564358,568951,589847,754123,762162,770127,785337,785663,790596,791039,791954,548421,564230,571263,755513,757910,768784,771904,777700,789705,762524,771941,551869,591009,599619,602669,605972,614049,619462,626405,630571,631541,642255,797468,562968,758853,764002,779110,785541,541401,562010,761442,774724,630970,545525,550663,563514,566657,569071,766428,767724,769379,775967,777414,780549,791894,553934,775253,776495,784709,767901,337810,553997,567583,569305,628421,750313,768368,773986,783253,632772,801146,544161,566202,592664,600155,759628,777012,341117,568223,799030,548392,550278,781872,771719,342273,755409,784365,591076,764927,784486,565605,751388,788849,562072,772134,799392,776773,763516,782207,590727,774224,587316,588491,595063,596023,598258,609520,609923,610416,612113,618131,630536,635343,636637,759267,759675,767895,768859,788501,634938,622095,630430,805914,585317,596178,597804,599751,603841,604784,622415,624487,642025,752877) AND ( 
  wp_term_relationships.term_taxonomy_id IN (36)
) AND ( 
  wp_postmeta.meta_key = 'prop_featured'
) AND wp_posts.post_type = 'estate_property' AND ((wp_posts.post_status = 'publish'))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_postmeta.meta_value DESC, wp_posts.ID DESC
					 LIMIT 0, 30
click to enable zoom
loading...
We didn't find any results
open map
View Roadmap Satellite Hybrid Terrain My Location Fullscreen Prev Next

We found 6cc 0 results.

Properties (936)

Login to save search and you will receive an email notification when new properties matching your search will be published.

For Sale
Active

3330 NE 190th St # 618, Aventu...

$ 840,000
Beautiful apartment with amazing views, excellent location, ...
3 3 1,720 Sqftdetails
QuiqNest Properties

300 Sunny Isles Blvd # 705, Su...

$ 1,190,000
Outstanding apartment professionally decorated by the renown ...
2 3 1,541 Sqftdetails
QuiqNest Properties

20191 SE Country Club Dr # 271...

$ 749,900
Great size split plan 2/2 with amazing views. Really bright ...
2 2 1,622 Sqftdetails
QuiqNest Properties
For Sale
Active

2759 NE 184th Way, Aventura FL...

$ 795,000
This beautiful and spacious 3 beds & 2.5 baths plus Den ...
3 3 1,797 Sqftdetails
QuiqNest Properties
For Sale
Active

3250 NE 188th St # 504, Aventu...

$ 2,100,000
Welcome to Echo Aventura unit 504! Amenities-rich condominiu ...
4 5 2,275 Sqftdetails
QuiqNest Properties

400 Sunny Isles Blvd # 1421, S...

$ 1,195,000
Beautiful unit in on the Sunny Isles’s best buildings
2 3 1,579 Sqftdetails
QuiqNest Properties

301 174th St # 303, Sunny Isle...

$ 1,160,000
One in a lifetime opportunity to own this beautifully renova ...
5 3 2,400 Sqftdetails
QuiqNest Properties

15901 Collins Ave # 1601, Sunn...

$ 2,975,000
Stunning, Pristine Furnished beach residence…Relax, ex ...
3 4 2,768 Sqftdetails
QuiqNest Properties
For Sale
Active

4000 ISLAND BL # 2701, Aventur...

$ 1,175,000
SPECTACULAR VIEWS FROM THIS DUPLEX HIGH IN THE SKY! LARGE, B ...
3 5 2,470 Sqftdetails
QuiqNest Properties
For Sale
Active

3370 Hidden Bay Dr # 1702, Ave...

$ 925,000
Fantastic unit with two bedrooms, and 2.5 baths. Located in ...
2 3 1,610 Sqftdetails
QuiqNest Properties
For Sale
Active

21050 Point Pl # 306, Aventura...

$ 749,000
Amazing & modern 2/2 in the heart of Aventura in state o ...
2 3 2,000 Sqftdetails
QuiqNest Properties

16500 Collins Ave # 2554, Sunn...

$ 1,350,000
Don’t miss this opportunity to call this Oceania Island cond ...
2 2 1,786 Sqftdetails
QuiqNest Properties

310 191st Ter, Sunny Isles Bea...

$ 1,599,000
A TOTALLY REMODELED SINGLE HOUSE IN A GREAT NEIGHBORHOOD, SU ...
2 2 1,394 Sqftdetails
QuiqNest Properties
For Sale
Active

20281 E Country Club Dr # 2302...

$ 1,095,000
The rarely available 02 line is now up for grabs. This sough ...
2 2 1,800 Sqftdetails
QuiqNest Properties
For Sale
Active

16425 Collins Ave # 418, Sunny...

$ 899,900
Great Investor’s Opportunity, Send your Offer!! Very s ...
2 2 1,760 Sqftdetails
QuiqNest Properties

17301 Biscayne Blvd # 1206, No...

$ 1,489,900
Largest 3 bedrooms 3 bathrooms and powder room in MARINA PAL ...
3 4 2,158 Sqftdetails
QuiqNest Properties

17475 Collins Ave # 2802, Sunn...

$ 4,500,000
Luxurious unit at Chateau Residencies with breathtaking view ...
3 5 3,049 Sqftdetails
QuiqNest Properties

245 Atlantic Ave, Sunny Isles ...

$ 4,150,000
Rarely available boater’s dream in Sunny Isles Beach. ...
3 2 2,036 Sqftdetails
QuiqNest Properties
For Sale
Active

307 Atlantic Ave, Sunny Isles ...

$ 4,990,000
Discover your waterfront paradise in Atlantic Isles! This ex ...
4 3 1,975 Sqftdetails
QuiqNest Properties

200 Sunny Isles Blvd # 1003, S...

$ 849,900
Best priced unit in all of St. Tropez; Stunning 3 Bedroom, 2 ...
3 2 1,461 Sqftdetails
QuiqNest Properties

16901 Collins Ave # 3303, Sunn...

$ 3,999,800
Spectacular Jade Signature Condo. Beautiful unit with 3 bedr ...
3 5 2,511 Sqftdetails
QuiqNest Properties
For Sale
Active

6000 Island Blvd # 2406, Avent...

$ 3,590,000
Beautiful 4 bedroom, 3.5 bath residence in luxurious Bella M ...
4 4 3,222 Sqftdetails
QuiqNest Properties

330 Sunny Isles Blvd # 503, Su...

$ 1,500,000
Spectacular Lanai Residence with a private Jacuzzi. This uni ...
2 3 1,524 Sqftdetails
QuiqNest Properties

18975 Collins Ave # 1004, Sunn...

$ 2,650,000
Immaculate unit at Armani Casa, designed by Cesar Pelli and ...
2 3 1,540 Sqftdetails
QuiqNest Properties

18683 Collins Ave # 2008, Sunn...

$ 1,160,000
Discover luxury oceanfront living at MARENAS BEACH RESORT in ...
2 3 1,497 Sqftdetails
QuiqNest Properties
For Sale
Active

3802 NE 207th St # 2304, Avent...

$ 975,000
BEAUTIFUL UNPARALLEL INTRACOASTAL AND OCEAN VIEWS AMAZING FL ...
2 3 2,240 Sqftdetails
QuiqNest Properties
For Sale
Active

2950 NE 188th St # 143, Aventu...

$ 850,000
BEAUTIFUL TOWNHOME WITH TWO BEDROOMS + DEN, THREE FULL BATHS ...
2 3 1,663 Sqftdetails
QuiqNest Properties

16699 Collins Ave # 2601, Sunn...

$ 1,175,000
Tons of natural light with spectacular ocean views from ever ...
2 3 1,623 Sqftdetails
QuiqNest Properties

322 189th St, Sunny Isles Beac...

$ 1,600,000
Ultimate opportunity to transform a vision into reality on t ...
4 3 2,250 Sqftdetails
QuiqNest Properties

3362 NE 166th St, North Miami ...

$ 3,150,000
THIS CHARMING HOUSE ON PRIVATE STREET HAS IT ALL**DON’ ...
5 3 2,800 Sqftdetails
QuiqNest Properties
Listings
Map View

Compare Listings