Property Types

Featured Listings

DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS category FROM jos_ezrealty as a LEFT JOIN jos_ezrealty_catg AS cc ON cc.id =' at line 1 SQL=SELECT cc.name, a.* AS category FROM jos_ezrealty as a LEFT JOIN jos_ezrealty_catg AS cc ON cc.id = a.cid WHERE a.featured = 1 AND a.published=1 AND cc.published=1 AND cc.access <= 0 ORDER BY RAND() LIMIT 10

New EZ Realty Listings

For Sale - North Miami, Florida $104,999 ( Unsold/Available )

	2 2	WATERFRONT GEM IN N MIAMI Greatly reduced now at bargain basement price for beautifully kept 2 bedroom, 2 bath condo. Secure building, brand new hurricane shutters, Now fully furnished but can be sold empty. Good investment, shortage of good rentable units. Pool, exercise room
		Add to Favorites List