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 (605644,754484,752215,597971,772310,351195,795421,594677,607390,777495,628653,564377,351234,800046,641714,806516,339065,343159,750939,755239,627866,778051,779996,762683,758706,553714,351360,563444,543966,756906,544020,755143,761763,543766,545678,558685,752688,753265,763385,764164,775900,783719,787034,351464,547072,763597,783880,784964,791494,792371,792830,778541,780672,542937,546215,570984,755661,765801,767178,768501,771232,772711,774924,781844,785798,544604,546178,564529,566543,569883,766000,774853,776925,780392,565538,352670,794441,643308,353169,803134,788084,756542,776891,763968,757785,770058,782804,543203,559183,750328,756028,756079,764645,777172,782858,783128,788141,560448,342138,547442,352313,552131,800630,606326,626949,607682,352905,351548,765189,593501,620040,769584,594094,352633) 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

For Sale

For Rent

Radius: 2 miles

Home Type

• Home Type
• Condominium
• Residential
• Single Family Residence
• Townhouse

Bedroom

• Bedroom
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10

$300,000

• $300k
• $500k
• $700k
• $900k
• $1 Million
• $1.5 Million
• $2 Million
• $2.5 Million
• $3.5 Million
• $4.5 Million
• $5.5 Million
• $6.5 Million
• $7.5 Million
• $8.5 Million
• $9.5 Million
• $10 Million
• $15 Million
• $25 Million
• $35 Million
• $45 Million

$50,000,000

• $400k
• $600k
• $800k
• $1 Million
• $1.5 Million
• $2 Million
• $3 Million
• $4 Million
• $5 Million
• $6 Million
• $7 Million
• $8 Million
• $9 Million
• $10 Million
• $20 Million
• $30 Million
• $40 Million
• $50 Million

Radius: 2 miles

Home Type

• Home Type
• Condominium
• Residential
• Single Family Residence
• Townhouse

Bedroom

• Bedroom
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10

Price low

• $2,000
• $4,000
• $6,000
• $8,000
• 10,000
• $12,000
• $14,000
• $16,000
• $18,000
• 20,000
• $25,000
• $35,000
• $45,000

Price max

• $3,000
• $5,000
• $7,000
• $9,000
• 11,000
• $13,000
• $15,000
• $20,000
• $25,000
• $30,000
• $40,000
• $50,000

Please select at least one search option to view results.

We found 6cc 0 results.

Default

• Price High to Low
• Price Low to High
• Newest first
• Oldest first
• Newest Edited
• Oldest Edited
• Bedrooms High to Low
• Bedrooms Low to high
• Bathrooms High to Low
• Bathrooms Low to high
• Default

Properties (114)

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

12

BISC GARDENS SEC H PT 2, Miami

For Sale

Active

13780 N Miami Ave, Miami FL 33...

$ 2,200,000

Green Energy Incentives!

Prospective homeowners, pay attention! Envision this: 2800 s ...

Prospective homeowners, pay attention! Envision this: 2800 sqft of living space, an impres ...

4 4 2,361 Sqftdetails

QuiqNest Properties

20

BISC GARDENS SEC D, Miami

For Sale

Active

250 NE 151st St, Miami FL 3316...

$ 1,100,000

Green Energy Incentives!

For showings please reach out to the listing agent or our of ...

For showings please reach out to the listing agent or our office. If submitting offers ple ...

4 3 4,061 Sqftdetails

QuiqNest Properties

32

REV PLAT OF BRANDON PARK, Miami

For Sale

Active

15020 S Biscayne River Dr, Mia...

$ 777,000

Green Energy Incentives!

Live in the prestigious Biscayne Gardens! Just minutes to th ...

Live in the prestigious Biscayne Gardens! Just minutes to the beaches. Remodeled with stai ...

3 2 1,222 Sqftdetails

QuiqNest Properties

14

BISC GARDENS SEC H PART 1, Miami

For Sale

Active

13835 S Biscayne River Rd, Mia...

$ 1,333,333

Green Energy Incentives!

COME SEE THIS GEM OF A REMODEL BEFORE IT’S GONE !!LOCA ...

COME SEE THIS GEM OF A REMODEL BEFORE IT’S GONE !!LOCATED IN SOUT BISCAYNE RIVER DRI ...

3 3 1,921 Sqftdetails

QuiqNest Properties

87

TUTTLES SUB, Miami

For Sale

Active

11195 W Biscayne Canal Rd, Mia...

$ 1,300,000

Green Energy Incentives!

Great for Short Term Rental or primary residence in Miami. 4 ...

Great for Short Term Rental or primary residence in Miami. 4 bed 3 bathroom waterfront poo ...

4 3 1,748 Sqftdetails

QuiqNest Properties

36

TOWERS QUAYSIDE CT-YARD V, Miami

For Sale

Active

10651 NE Quaybridge Ct, Miami ...

$ 1,450,000

Green Energy Incentives!

Welcome to this stunning corner unit townhouse with huge win ...

Welcome to this stunning corner unit townhouse with huge windows and natural light! With a ...

3 3 4,520 Sqftdetails

QuiqNest Properties

50

TOWERS OF QUAYSIDE, TOWERS OF QUAYSIDE CONDO, Miami

For Sale

Active

2000 TOWERSIDE TE # 703, Miami...

$ 398,000

ENJOY STUNNING VIEWS OF LUSH GARDENS AND TREE TOPS THAT SURR ...

ENJOY STUNNING VIEWS OF LUSH GARDENS AND TREE TOPS THAT SURROUND YOU FROM THIS 2 BEDRM. TH ...

2 2 1,312 Sqftdetails

QuiqNest Properties

43

TOWERS OF QUAYSIDE CONDO, Miami

For Sale

Active

2000 Towerside Ter # 510, Miam...

$ 545,000

As you step into the unit you are immediately greeted by a b ...

As you step into the unit you are immediately greeted by a breathtaking view of the lush g ...

2 2 1,312 Sqftdetails

QuiqNest Properties

39

TOWERS OF QUAYSIDE CONDO, Miami

For Sale

Active

2000 Towerside Ter # 1001, Mia...

$ 598,900

Seller motivated. Turnkey Chic. “Paradise” hidde ...

Seller motivated. Turnkey Chic. “Paradise” hidden in plain sight. Resort style ...

2 2 1,544 Sqftdetails

QuiqNest Properties

24

THE TOWERS OF QUAYSIDE CO, Miami

For Sale

Active

4000 Towerside Ter # 901, Miam...

$ 550,000

CORNER UNIT, GREAT VIEWS

CORNER UNIT, GREAT VIEWS

2 2 1,469 Sqftdetails

QuiqNest Properties

46

SANS SOUCI CONDO, North Miami

For Sale

Active

11930 NE 19th Dr # 3, North Mi...

$ 374,000

Updated 2BR/2BA unit featuring open kitchen, amazing Almost ...

Updated 2BR/2BA unit featuring open kitchen, amazing Almost Brand New Inside, new applianc ...

2 2 1,146 Sqftdetails

QuiqNest Properties

37

JOCKEY CLUB CONDO, JOCKEY CLUB CONDO UNIT II, Miami

For Sale

Active

11111 Biscayne Blvd, Miami FL ...

$ 360,000

Breathtaking views of Biscayne Bay! This fully remodeled res ...

Breathtaking views of Biscayne Bay! This fully remodeled residence boasts over 1,350 SF of ...

2 2 1,353 Sqftdetails

QuiqNest Properties

28

TOWERS OF QUAYSIDE CONDO, Miami

For Sale

Active

1000 Quayside Ter # 1205, Miam...

$ 599,000

The moment you step inside this unit, you’ll be greete ...

The moment you step inside this unit, you’ll be greeted by an air of sophistication ...

2 2 1,520 Sqftdetails

QuiqNest Properties

18

TOWERS OF QUAYSIDE CONDO, Miami

For Sale

Active

2000 Towerside Ter # 1905, Mia...

$ 496,900

NOTE: Investor deal: Tenant in place til 9/30/2024 at $3900/ ...

NOTE: Investor deal: Tenant in place til 9/30/2024 at $3900/month. Rare 19th floor 2/2 spl ...

2 2 1,520 Sqftdetails

QuiqNest Properties

29

Tower 2000, TOWERS OF QUAYSIDE, Miami

For Sale

Active

2000 Towerside Terrace # 1703,...

$ 429,000

NOTE: Investor deal: Tenant in place til 9/30/2024 at $3900/ ...

NOTE: Investor deal: Tenant in place til 9/30/2024 at $3900/month. Turnkey. Hidden in plai ...

2 2 1,312 Sqftdetails

QuiqNest Properties

25

JOCKEY CLUB CONDO, Miami

For Sale

Active

11111 Biscayne Blvd # 6C, Miam...

$ 415,000

Sweeping wide and unobstructed Bay from every room. Elegant ...

Sweeping wide and unobstructed Bay from every room. Elegant unit, exquisitely and professi ...

2 2 1,358 Sqftdetails

QuiqNest Properties

35

THE TOWERS OF QUAYSIDE CO, Miami

For Sale

Active

4000 Towerside Ter # 911, Miam...

$ 550,000

Come and enjoy resort living in this spacious 2br/2ba corner ...

Come and enjoy resort living in this spacious 2br/2ba corner unit with bay and sunset view ...

2 2 1,469 Sqftdetails

QuiqNest Properties

49

THE TOWERS OF QUAYSIDE CO, TOWERS OF QUAYSIDE, Miami

For Sale

Active

4000 Towerside Ter # 1507, Mia...

$ 575,000

Owners have a beautifully renovated unit with a custom white ...

Owners have a beautifully renovated unit with a custom white kitchen and SS Kitchen Aid ap ...

2 2 1,376 Sqftdetails

QuiqNest Properties

31

Keystone Harbor Club Condo, North Miami

For Sale

Active

13155 Ixora Ct # 1005, North M...

$ 340,000

Unit is tenant occupied until June 14, 2024 at $2800/month & ...

Unit is tenant occupied until June 14, 2024 at $2800/month – tenant has option to re ...

2 2 1,096 Sqftdetails

QuiqNest Properties

27

TOWERS OF QUAYSIDE CONDO, Miami

For Sale

Active

1000 Quayside Ter # 505, Miami...

$ 549,000

Discover Miami’s Hidden Gem at The Towers of Quayside. ...

Discover Miami’s Hidden Gem at The Towers of Quayside. Tree level unit that makes yo ...

2 2 1,520 Sqftdetails

QuiqNest Properties

25

SUTTON HOUSE CONDO, North Miami

For Sale

Active

11855 NE 19th Dr # 20, North M...

$ 349,500

This condo is stunning totally renovated with the highest of ...

This condo is stunning totally renovated with the highest of finishes, all new appliances, ...

2 2 1,271 Sqftdetails

QuiqNest Properties

11

CRICKET CLUB CONDO, Miami

For Sale

Active

1800 NE 114th St # 1908, Miami...

$ 475,000

The property is a 2-bedroom apartment with 3 bathrooms. It i ...

The property is a 2-bedroom apartment with 3 bathrooms. It includes a master bedroom with ...

2 3 1,950 Sqftdetails

QuiqNest Properties

18

ALMENDARES, Miami

For Sale

Active

11730 NW 3rd Ave, Miami FL 331...

$ 500,000

Green Energy Incentives!

Please note that this is a strictly cash-only offer, given t ...

Please note that this is a strictly cash-only offer, given the code violation and the need ...

3 2 1,467 Sqftdetails

QuiqNest Properties

25

NORTH SHORE HEIGHTS, North Miami

For Sale

Active

770 NW 126th St, North Miami F...

$ 419,900

Green Energy Incentives!

Completely remodeled 3/1 with nice yard space. New kitchen w ...

Completely remodeled 3/1 with nice yard space. New kitchen with stainless steel appliances ...

3 1 818 Sqftdetails

QuiqNest Properties

19

NICHOLS HEIGHTS ADDN, North Miami

For Sale

Active

265 NW 135th St, North Miami F...

$ 525,000

Green Energy Incentives!

Welcome to 265 NW 135 Street! Nestled in the charming commun ...

Welcome to 265 NW 135 Street! Nestled in the charming community of North Miami, this beaut ...

3 2 1,140 Sqftdetails

QuiqNest Properties

28

MIAMI HIGHLANDS SEC A, Miami

For Sale

Active

315 NE 111th St, Miami FL 3316...

$ 699,999

Green Energy Incentives!

Exceptional location! This extraordinary single-family house ...

Exceptional location! This extraordinary single-family house features 3 beds, 2 baths full ...

4 2 1,368 Sqftdetails

QuiqNest Properties

45

THE TOWERS OF QUAYSIDE CO, Miami

For Sale

Active

4000 Towerside Ter, Miami FL 3...

$ 548,000

Amazing Penthouse in the Sky!!! Unobstructed incredible wate ...

Amazing Penthouse in the Sky!!! Unobstructed incredible water & city views. Extra lar ...

1 2 1,268 Sqftdetails

QuiqNest Properties

27

CRICKET CLUB CONDO, Miami

For Sale

Active

1800 NE 114th St # 411, Miami ...

$ 399,000

Great remodeled 1,950 sq. ft. 2 BR & 3 BA unit at The C ...

Great remodeled 1,950 sq. ft. 2 BR & 3 BA unit at The Cricket Club! This unit has a r ...

2 3 1,950 Sqftdetails

QuiqNest Properties

15

ARCH CREEK ESTS, Miami

For Sale

Active

1543 NE 144th St, Miami FL 331...

$ 575,000

Green Energy Incentives!

This is best opportunity this area is growing more and more ...

This is best opportunity this area is growing more and more is the dream to investors LOT ...

3 2 1,075 Sqftdetails

QuiqNest Properties

66

JOCKEY CLUB CONDO, Miami

For Sale

Active

11111 Biscayne Blvd # 10E, Mia...

$ 415,000

BREATHTAKING BAY, INTRACOASTAL AND CITY VIEWS, THIS 2 MASTER ...

BREATHTAKING BAY, INTRACOASTAL AND CITY VIEWS, THIS 2 MASTER BEDROOMS APARTMENTS HAS LARGE ...

2 2 1,377 Sqftdetails

QuiqNest Properties

• 1
• 2
• 3
• 4