888-QuiqNest
Utility Bills
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 (886508) 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
Solar Ready Homes
Solar Homes
For Sale

Home Type
Bedroom

Home Type
Bedroom

Home Type
Bedroom
We found 6cc 0 results.
Default

Properties (1)

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

38
,
Solar Ready Homes
Active

208 Jefferson Ave # 106, Miami...

$ 1,450,000
Green Energy Incentives!
Welcome to Beach Colony, an intimate collection of 16 boutiq ...
3 3 1,520 Sqftdetails
QuiqNest Properties
Listings
Map View

Compare Listings