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 (343844,547161,550394,561004,567389,628804,641041,751857,751873,751988,757160,757278,765613,768346,772232,781931,783958,784035,788714,789427,792415,618728,623546,767107,617377,629615,605001,750372,750509,764955,786492,803840,593656,599530,627420,628680,642164,552082,784249,283242,615081,619083,622507,804438,561691,774339,557045,566428,793768,564312,616632,592418,594568,598906,609733,616465,618054,622018,626560,628107,792207,342959,772666,773086,339049,762457,759522,616522,771801,585828,632429,587071,568079,773419,782770,772813,554529,791905,343255,769949,623694,617683,280638,587946,590331,604989,618403,630095,807090,338713,784445,568496,620268,639206,541821,595543,598272,599211,612876,626086,631196,632494,641160,755663,758502,796760,800061,621864,805125,560687,616569,593840,587737,563312,567249,759833,555031,756336,768032,754267,609105,624538,799666,278751,284914,604584,553410,791644,333763,642669,562918,620455,760354,780729,335736,802002,600321,340193,551089,568416,545978,611001,614993,752331,793687,629225,772792,781011,637153,764290,783869,772657,332262,335461,601336,611289,614515,592095,636881,615220,789121,632823,634347,753361,762012,550366,565585,565926,612625,771269,797083,760336,782102,785317,605818,752760,561924,347468,756839,785447,777255,282022,633707,641907,775653,780482,808854,564793,754830,773944,774282,551247,568525,791638,799089,792440,621825,762874,772210,597226,767627,562248,636962,341077,341700,343569,563991,604254,754835,782729,602782,629011,610389,613856,617821,633539,602813,627274,634861,770533,789677,552947,567668,593264,550443,551955,552420,559987,567526,587794,588940,604960,617773,628786,754728,766324,774463,785772,786335,787100,784697,542368,769785,570203,612780,339524,342375,766383,778756,598932,794789,338385,547589,547778,586054,770186,784000,784508,559750,561163,628732,752918,765071,776045,777934,781591,792241,793366,547222,559859,585656,340358,620570,542719,552453,553193,564281,569286,594301,602912,608009,608022,616907,625428,628530,632732,635574,760040,769626,769834,780701,786145,787987,788764,792685,342573,566928,608088,622822,776293,626183,640310,607198,551654,557577,559462,563970,751999,758598,759931,766119,766272,772820,777297,781711,561903,751431,773834,801296,586235,339534,334568,545331,617488,635492,544774,786189,585107,590742,623320,637107,541494,567982,600529,632336,633033,763910,790946,585783,620686,610316,621666,794283,337481,340136,561813,599668,779757,546465,563061,609334,750397,750583,766616,780020,782581,788374,589679,568206,757416,602919,806885,588534,590592,593300,598710,609788,611135,615046,624649,593384,541597,552645,562988,625385,630942,622564,563013,612676,611414,802407,593486,619609,809001,611437,598545,617571,640291,795206,803155,621418,628345,616146,798875,638224,625948,563570,544902,784689,635126,634372,622037,587043,621728,629109,597294,640146,607588,629927,587621,605391,606053,793234,333333,334201,341618,567065,764333,603471,615928,618077,329556,608567,280998,594805,332888,277552,619911,343959,597573,599350,632282,591506,607364,611981,614234,642590,285543,284745,285135,588615,600793,605774,609631,618543,639436,642052,279748,280356,612081,590771,766322,803598,808301,329309,330415,342210,790930,586111,567878,593051,641643,607418,614702,334355,617002,763202,802529,640255,612595,639273,609804,330857,330348,801386,766406,641500,588377) 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 (478)

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

For Sale
Active

3190 Sheridan Ave, Miami Beach...

$ 2,400,000
This elegant home is waiting to be restored to its splendor ...
5 4 3,384 Sqftdetails
QuiqNest Properties

1330 West Ave # 514, Miami Bea...

$ 709,900
Come view this beautiful corner unit in The Waverly at South ...
2 2 1,262 Sqftdetails
QuiqNest Properties

400 S Pointe Dr # 2104, Miami ...

$ 3,200,000
Spectacular 3-bed/3-bath high floor SE corner residence at S ...
3 3 1,802 Sqftdetails
QuiqNest Properties
For Sale
Active

2201 Collins Ave # 811, Miami ...

$ 2,800,000
Step into luxury with this remarkable residence at W South B ...
2 3 1,121 Sqftdetails
QuiqNest Properties
For Sale
Active

3 Island Ave # 04D, Miami Beac...

$ 1,190,000
Indulge in waterfront living with breathtaking Biscayne Bay ...
2 2 1,401 Sqftdetails
QuiqNest Properties
For Sale
Active

2301 Collins Ave # 1619, Miami...

$ 1,749,000
Discover luxurious living in this oceanfront junior 2-bed, 2 ...
2 2 900 Sqftdetails
QuiqNest Properties

1455 Ocean Dr # 1609, Miami Be...

$ 4,995,000
Panoramic views of Miami Beach and Atlantic Ocean are the ce ...
3 5 2,250 Sqftdetails
QuiqNest Properties
For Sale
Active

100 Lincoln Rd # 1648, Miami B...

$ 1,600,000
2 bedrooms 2 baths, TOP FLOOR, CORNER Unit in Desirable Ocea ...
2 2 1,190 Sqftdetails
QuiqNest Properties

400 S Pointe Dr # 501, Miami B...

$ 1,395,000
Rarely available “01” line. Lowest priced, Split two Bedroom ...
2 2 1,165 Sqftdetails
QuiqNest Properties
For Sale
Active

520 West Ave # 603, Miami Beac...

$ 750,000
Enjoy a spectacular wide bay view of the Miami Skyline in th ...
1 1 776 Sqftdetails
QuiqNest Properties
For Sale
Active

4391 COLLINS AVE # 1415, Miami...

$ 918,000
Beautiful Jr Suite w/ocean & pool views at The Fontaineb ...
1 521 Sqftdetails
QuiqNest Properties
For Sale
Active

300 Collins Ave # 3D, Miami Be...

$ 2,700,000
This fully furnished 2 Bed, 2.5 bath SE corner unit is at 30 ...
2 3 1,402 Sqftdetails
QuiqNest Properties

1250 Lincoln Rd # 301, Miami B...

$ 725,000
This is an outstanding opportunity to own a condo in the  ...
2 2 960 Sqftdetails
QuiqNest Properties
For Sale
Active

4401 Collins Ave, Miami Beach ...

$ 2,500,000
Custom designed by famous interior designer Ted Fine, this b ...
2 3 1,528 Sqftdetails
QuiqNest Properties

2901 Indian Creek Dr # B, Miam...

$ 2,515,000
Twenty-Nine Indian Creek positioned in Miami Beach’s famed F ...
2 3 1,750 Sqftdetails
QuiqNest Properties
For Sale
Active

2301 Collins Ave # 319, Miami ...

$ 895,000
Large 1 beddroom condo 900Sqft, and a half bathrooms, with w ...
1 2 900 Sqftdetails
QuiqNest Properties
For Sale
Active

102 24th St # 1113, Miami Beac...

$ 2,600,000
Do not miss the opportunity of owning this Spectacular unit ...
1 2 893 Sqftdetails
QuiqNest Properties
For Sale
Active

2484 Prairie Ave, Miami Beach ...

$ 4,995,000
Large classic Mediterranean home overlooking the Bayshore Pa ...
5 7 4,910 Sqftdetails
QuiqNest Properties
For Sale
Active

540 West Ave # 2211, Miami Bea...

$ 1,850,000
This corner 2bed/2bath unit has spectacular Biscayne Bay and ...
2 2 1,256 Sqftdetails
QuiqNest Properties
For Sale
Active

2424 Prairie Ave, Miami Beach ...

$ 3,150,000
Beautifully restored and updated classic Mediterranean home ...
4 4 3,657 Sqftdetails
QuiqNest Properties
For Sale
Active

2301 Collins Ave # 318, Miami ...

$ 1,485,000
Welcome to Roney Palace in Miami Beach! Experience luxury li ...
2 2 840 Sqftdetails
QuiqNest Properties
For Sale
Active

520 West Ave # 1601, Miami Bea...

$ 2,650,000
RARE ON THE MARKET – Step into a realm of luxury with ...
2 3 1,992 Sqftdetails
QuiqNest Properties

1900 Sunset Harbour Dr # 2111,...

$ 1,090,000
Amazing opportunity to own in this beautifully renovated 21s ...
2 2 1,270 Sqftdetails
QuiqNest Properties

9 Island Ave # 1502, Miami Bea...

$ 995,000
You’ll savor the mesmerizing direct bay and Miami skyline vi ...
2 2 1,154 Sqftdetails
QuiqNest Properties
For Sale
Active

1437 Collins Ave # 327, Miami ...

$ 350,000
AIR BnB ready opportunity on the vibrant streets of Ocean Dr ...
2 500 Sqftdetails
QuiqNest Properties

1331 Lincoln Rd # 502, Miami B...

$ 375,000
Location Location Location on this remodeled 2 bedroom unit ...
2 2 820 Sqftdetails
QuiqNest Properties
For Sale
Active

2899 Collins Ave # H, Miami Be...

$ 695,000
2-stories, 2-bedroom, 2-bathroom penthouse. Marble floors in ...
2 2 1,102 Sqftdetails
QuiqNest Properties
For Sale
Active

3710 Collins Ave # 200, Miami ...

$ 339,000
Location, Location!! can rent on AIRBNB! Beautiful FURNISHED ...
1 370 Sqftdetails
QuiqNest Properties
For Sale
Active

1100 West Ave # 819, Miami Bea...

$ 335,000
This is your chance to own a resort residence at the Luxurio ...
1 502 Sqftdetails
QuiqNest Properties
For Sale
Active

1045 10th St # 907, Miami Beac...

$ 365,000
Top Floor Corner Residence with wide open sunset views over ...
1 1 800 Sqftdetails
QuiqNest Properties
Listings
Map View

Compare Listings