Stuff

 SELECT * , COUNT( photos.name ) AS 'numPics'FROM `properties`INNER JOIN `photos` ON properties.id = photos.property_idWHERE (`city_id` = '25'OR `zipcode` = '0')AND 'numPics' !=0AND `bathrooms` > '0'GROUP BY properties.idLIMIT 0 , 30