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 (551221,553135,579135,574379,583322,295564,546679,548720,554675,573244,792786,299870,576181,576238,577995,579077,580116,580902,581019,581990,582240,582288,582352,583868,584002,584284,754771,796420,804262,808131,547757,561836,576766,751703,758948,761392,765295,774992,785827,790426,792673,582188,753796,755906,787787,298367,298726,578710,581399,582263,582807,769897,776973,778772,766629,750908,777347,579967,572249,765300,783200,551348,784880,297081,297200,297260,572498,575712,577156,578496,580913,581042,581172,581200,581789,582030,582613,584421,797584,805798,806585,809096,798308,580793,582928,780751,775829,787210,297987,570762,576570,576794,577553,578346,578836,580329,580405,580460,581359,581802,582558,583474,583490,757630,771069,801674,804982,805415,299713,545016,574719,576290,577447,578323,583945,754994,776792,778494,790334,583265,548881,557950,574816,576416,582611,584223,761583,771058,781821,789330,575127,576317,578489,793122,575316,575444,576816,579403,579495,583126,583375,583750,753515,787525,792918,808335,578083,792736,296056,296191,296342,578949,581861,584356,762586,794103,292744,294181,293145,291686,292265,292669,294196,572093,572204,572724,572955,573690,751605,774453,296541,577618,579356,580487,756794,763725,796121,773786,792325,545140,559224,566407,751211,759027,761882,766352,774554,785070,785905,296724,786437,560909,581435,765943,785325,803393,555935,566728,774641,544353,550257,574973,575368,579694,582098,582492,582853,583730,753107,756068,773283,776244,782646,800929,541347,566382,775075,786880,802707,803175,806388,578477,578624,806613,291759,291863,291981,293031,293888,294084,294308,295883,295933,571649,571847,571968,573259,574089,754579,762396,763578,782201,793989,794833,794935,795509,795937,806337,770921,772462,766512,788344,545656,761346,775689,783484,788642,541832,543313,543579,543934,548487,555654,556569,557815,568238,750429,756743,769258,772627,772841,778209,778531,782352,789497,789658,790803,793446,294115,572031,572525,765556,767368,782280,788166,805089,575801,576683,785109,808612,292364,292926,293622,572471,573184,573791,573897,753139,807961,760918,769801,781689,580940,297274,577719,758793,799973,570069,764857,296572,576740,576866,577879,578203,582054,583715,754817,763649,767233,807707,803722,578580,579104,579248,772356,797174,803496,577798,580368,553516,292454,293392,295189,768399,772340,575236,752146,762576,780350,298058,397969,573649,574446,575422,575486,576743,578679,579017,579733,581612,583209,809499,554606,571721,571923,572318,573482,573506,573546,793046,806529,574669,767529,576659,580304,582479,765449,801242,296873,550860,582743,776562,575952,548960,580962,581546,808199,578239,581662,559804,577520,769616,562829,563638,575346,577085,752119,765166,770754,781447,783219,792106,792881,397911,772757,794013,794963,797777,798081,800998,802904,804850,809347,295602,295858,573971,760862,770804,787719,801132,768612,775734,795921,297099,575079,581719,575542,580239,580554,581250,581518,582984,769031,760712,757970,292600,571902,572010,573627,574184,761572,766282,295779,573669,752438,542472,770036,790200,807026,294889,294881,754294,783308,787998,765024,768144,770583,294370,294447,775414,577895,580665,572803,751473,581823,548524,549041,577315,578022,808675,781041,796522,799591,576041,576918,759248,763052,764151,770741,772498,777372,783186,788421,795813,798208,805597,575664,768476,299844,565292,577959,581777,774981,785637,295502,581696,583795,775158,792483,298886,578688,579213,579232,582639,583806,584180,584340,759901,760954,767692,774068,779959,787750,788296,573462,292179,293071,294143,295132,295585,572339,572407,572791,572822,573290,573322,574214,574236,768092,779278,791411,796507,296000,566072,573675,574012,758399,768299,787142,790111,805964,574629,579605,751644,752016,779436,297130,297961,297997,298559,578166,578860,775508,802842,753946,771761,784939,801338,804275,804466,805724,805768,758658,758725,782222,783527,786932,787320,795767,796166,799698,801812,802561,802928,804220,804908,804944,805443,806096,806263,807185,807935,808037,808047,808750,279022,294419,294545,572503,573878,794192,802947,295388,338628,554587,766522,768546,772776,574613,580398,795885,344708,551044,583430,751768,764425,788367,756724,284525,285198,299014,579568,796282,807766,576542,557561,568011,754370,786621,751183,283709,280045,297364,576584,577697,579788,582826,583683,806316,582124,583398,290066,291059,288907,766992,793077,795081,795282,805564,297902,582704,801468,808778,291088,775358,801217,289927,289366,758609,803240,285852,290336,290852,289864,291394,778827,342717,290095,758489,545362,801170,802053,560332,281845,282379,797119,807062,806918,799937,750618,756890,796947,798009,799827,289602,344295,541666,553154,562533,571099,756352,766972,781806,790218,791971,560198,786777,545553,551678,565270,771635,771012,772944,784412,789567,806154,289756,541368,550647,552274,565575,753405,755692,757711,761291,762268,771369,775499,780994,781225,781255,781784,789455,791279,790722,340284,552223,559244,559790,562501,750719,755876,759492,763777,765933,768240,779905,781666,788991,548377,771289,771783,783414,754027,756302,761020,541143,543740,547138,547701,548689,552119,556362,561277,566444,570367,753025,754333,755051,757363,758192,760243,764036,772063,774077,774104,774701,777583,780326,780945,782381,758971,771553,771127,397843,551709,755098,756507,756767,761957,770359,772550,776838,789107,791140,794634,798503,804533,807827,753445,783570,542895,783745,768575,802161,290565,789641,799558,557866,751529,755648,757649,775554,776430,777791,621071,282655,765150,771174,777161,559546,564600,796077,284072,789614,804297,290300,784919,755553,780135,795706,798712,784598,800960) 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 (804)

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

For Sale
Active

1000 Brickell Plz, Miami FL 33...

$ 3,500,000
Brickell Flatiron is an ultra luxury condo development locat ...
3 4 2,342 Sqftdetails
QuiqNest Properties
For Sale
Active

398 NE 5 # 3617, Miami FL 3313...

$ 1,396,756
Spacious 2 Bedrooms + Den / 3 Baths. Discover a collection o ...
2 3 1,149 Sqftdetails
QuiqNest Properties
For Sale
Active

68 SE 6th St # 2010, Miami FL ...

$ 1,035,000
Stylish and roomy 2 Bed/2Bath condo at the sought-after Reac ...
2 2 1,193 Sqftdetails
QuiqNest Properties
For Sale
Active

1100 Biscayne Blvd # 5703, Mia...

$ 1,100,000
Views that wil leave you breathless from this 57th floor bea ...
2 3 1,498 Sqftdetails
QuiqNest Properties

851 NE 1st Ave # 3907, Miami F...

$ 1,795,000
Luxurious, stunning, fully furnished large 3/2 plus den apar ...
QuiqNest Properties
For Sale
Active

1155 Brickell Bay Dr, Miami FL...

$ 824,900
Breathtaking 2BR/2BA Corner Unit Penthouse at The Mark on Br ...
2 2 1,200 Sqftdetails
QuiqNest Properties
For Sale
Active

701 Brickell Key Blvd # 06, Mi...

$ 1,690,000
EXQUISITE LOW-PENTHOUSE APARTMENT! Amazing views for and fiv ...
3 4 2,163 Sqftdetails
QuiqNest Properties
For Sale
Active

495 Brickell Ave # 1710, Miami...

$ 900,000
STUNNING WATERFRONT 2 BEDROOM 2 BATH UNIT IN THE HEART OF BR ...
2 2 1,327 Sqftdetails
QuiqNest Properties
For Sale
Active

848 Brickell Key Dr # 2506, Mi...

$ 2,675,000
Located at Three Tequesta on Brickell Key Island, you will f ...
3 4 2,293 Sqftdetails
QuiqNest Properties
For Sale
Active

200 Biscayne Boulevard Way # 5...

$ 1,300,000
Amazing Penthouse at EPIC! Large 2 bedroom and 2.5 baths fea ...
2 3 1,646 Sqftdetails
QuiqNest Properties
For Sale
Active

851 NE 1st Ave # 1208, Miami F...

$ 1,099,000
ENJOY PARAMOUNT WORLDCENTER WITH THE BEST AMENITIES IN MIAMI ...
2 3 1,491 Sqftdetails
QuiqNest Properties
For Sale
Active

851 NE 1st Ave # 3002, Miami F...

$ 749,000
GREAT FOR INVESTORS!!!****Beautiful apartment with incredibl ...
1 2 937 Sqftdetails
QuiqNest Properties
For Sale
Active

55 SW 9th St # 3506, Miami FL ...

$ 950,000
Beautiful unit with floor to ceiling windows all through out ...
2 2 1,053 Sqftdetails
QuiqNest Properties
For Sale
Active

851 NE 1st Ave # 3806, Miami F...

$ 897,500
This stunning apartment has 1 bedroom + den and 2 bathrooms ...
1 2 1,173 Sqftdetails
QuiqNest Properties
For Sale
Active

488 NE 18th St # 2009, Miami F...

$ 980,000
Gorgeous water view 2 bedroom 3 Full Bathroom + Den unit at ...
2 3 1,257 Sqftdetails
QuiqNest Properties
For Sale
Active

900 Biscayne Blvd, Miami FL 33...

$ 3,490,000
IMPECCABLY DESIGNED AMBIENT-STYLE PENTHOUSE WITH PANORAMIC U ...
3 4 3,793 Sqftdetails
QuiqNest Properties
For Sale
Active

950 Brickell Bay Dr # 4610, Mi...

$ 1,180,000
Elevated Living: Contemporary 2Br/2.5Ba, two parking spaces. ...
2 3 1,278 Sqftdetails
QuiqNest Properties
For Sale
Active

851 NE 1st Ave # 3800, Miami F...

$ 790,000
One bedroom, 2 full bath + den corner unit in Paramount Worl ...
1 2 1,018 Sqftdetails
QuiqNest Properties
For Sale
Active

1444 Biscayne Blvd # 4803, Mia...

$ 3,175,900
Located in the heart of the arts and cultural district, one ...
3 4 2,443 Sqftdetails
QuiqNest Properties
For Sale
Active

770 Claughton Island Dr # 1503...

$ 705,000
Fully renovated, with brand new wood floors, all brand new d ...
2 2 968 Sqftdetails
QuiqNest Properties
For Sale
Active

234 SW 22nd Rd, Miami FL 33129...

$ 1,200,000
Price is for the lot, project and permits. NOT built Propert ...
QuiqNest Properties

801 Brickell Key Blvd # 1201, ...

$ 895,000
Striking 2bed/2bath corner condo with breathtaking views of ...
2 2 1,280 Sqftdetails
QuiqNest Properties
For Sale
Active

68 SE 6th St # 3711, Miami FL ...

$ 3,200,000
Tower Suite on the 37th floor at Reach, Brickell City Center ...
3 5 2,526 Sqftdetails
QuiqNest Properties
For Sale
Active

999 SW 1st Ave # 1605, Miami F...

$ 725,000
The perfect Location! Situated in the heart of Brickell, thi ...
2 2 1,274 Sqftdetails
QuiqNest Properties
For Sale
Active

50 Biscayne Blvd # 2510, Miami...

$ 2,895,000
LIVE IN THE VERY HEART OF DOWNTOWN MIAMI WITH ALL IT MAY OFF ...
4 4 3,059 Sqftdetails
QuiqNest Properties
For Sale
Active

801 S Miami Ave # 1401, Miami ...

$ 1,550,000
“Designer-Ready” Corner Unit in Pristine Conditi ...
3 4 1,613 Sqftdetails
QuiqNest Properties
For Sale
Active

1451 Brickell Ave # 2404, Miam...

$ 975,000
Echo Brickell is the most exclusive architectural Icon. Full ...
1 2 792 Sqftdetails
QuiqNest Properties
For Sale
Active

851 NE 1st AVE # 2106, Miami F...

$ 860,000
Welcome to this luxurious 1 bedroom, 2 bath + Den apartment ...
1 2 1,173 Sqftdetails
QuiqNest Properties
For Sale
Active

2101 Brickell Ave # 1401, Miam...

$ 850,000
Great investment opportunity! Stunning 2/2 corner unit with ...
2 2 1,367 Sqftdetails
QuiqNest Properties
For Sale
Active

851 NE 1st Ave # 2702, Miami F...

$ 744,000
Miami chic furnished 1 + den + 1 parking spaces at Paramount ...
1 2 937 Sqftdetails
QuiqNest Properties
Listings
Map View

Compare Listings