select t1.id,t1.property_title,t1.property_type,t1.property_status,t1.beds,t1.bathrooms,t1.price,t1.area,t1.area_type,t1.address,t1.featured_photo,t1.date_added,t1.description,t1.location,t1.city,t1.state,t1.latitude,t1.longitude,t1.3D_url,t3.username,t3.mobile,t3.image  from nearestate_properties t1 left join nearestate_features t2 on(t1.id=t2.property_id) inner join redial_users t3 on(t1.user_id=t3.id) where t1.status =1  and t1.property_type = 12 group by t1.id order by t1.date_added desc limit 60,10