Warning: preg_match(): Compilation failed: unmatched parentheses at offset 15 in ~/includes/library/lib_route.inc.php on line 75
Our team of agents are ready to help you reach your real estate goals by making your needs our number one priority.
Fatal error: 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 '-10,10' at line 1 select c.*,o.zip_code,o.website,o.address,o.scode,o.tags,o.specialty,o.vanity_number,s.customer_category,s.subscription_type,s.phone_verification_status,s.email_verification_status,oa.* from `thisisagent`.`lc_customers` c JOIN tia_org_company_address oa ON c.id=oa.customer_id LEFT JOIN tia_customer_orders o ON c.id=o.customer_id LEFT JOIN customer_subscriptions s ON c.id=s.customer_id where c.customer_type='agent' and c.status='1' and s.is_test_user=0 and (c.sub_domain_id='1' || o.profile_in_other_sites='yes' || o.vanity_number='18447472436') AND (c.firstname LIKE '%r hess/////////////%' OR c.lastname LIKE '%r hess/////////////%') GROUP BY c.id ORDER BY SUM(LENGTH(s.subscription_type)) desc, c.id desc limit -10,10 in ~/includes/library/lib_database.inc.php on line 349