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 (886456) 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–Ready Homes Plus™
Clear–Title Solar Homes™

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.

25
,
Solar–Ready Homes™
Active

1233 SW 13th Ave # A, Miami FL...

$ 1,899,000
Green Energy Incentives!
BRAND NEW CONSTRUCTION LUXURY TOWNHOUSE- JUST COMPLETED IN 2 ...
3 3.5 2,247 Sqftdetails
QuiqNest Properties
Listings
Map View

Compare Listings