SELECT
			u1.*,u2.meta
		
			FROM 
				rets_hicar_retscloud.residential u1 
			LEFT JOIN 
				rets_hicar_retscloud.rets_mls_titles u2 ON u1.field_MST_MLS_NUMBER=u2.mls 
				
		 WHERE   u1.field_off_Number = '556' AND 
		  ( field_Property_Status LIKE 'Active' AND Class NOT LIKE '%Off Market%' ) 
		  ORDER BY  u1.field_List_Price desc