Query: SELECT * FROM `residential` as `Residential` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC

Warning (512): SQL 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 ' ) ORDER BY `price` ASC' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]

Query: SELECT * FROM `commercial` as `Commercial` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC

Query: SELECT * FROM `land` as `Land` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC

Query: SELECT * FROM `multi_family` as `Multifamily` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC

Pueblo RE/MAX ::
Select the first letter of an agent's last name:
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z


Phone(Work):   Ext:
Phone(Cell):
Fax:
Email:
Web Address:
Office: ,
  • Property:
  • Years Experience:
  • Degree(s):
  • Commitment to customers:
  • My hobbies:
  • Additional information:

Listings:

Residential

Warning (2): Invalid argument supplied for foreach() [CORE/app/views/agent/detail.ctp, line 60]

Commercial

Warning (2): Invalid argument supplied for foreach() [CORE/app/views/agent/detail.ctp, line 127]

Land

Warning (2): Invalid argument supplied for foreach() [CORE/app/views/agent/detail.ctp, line 159]

Multi Family

Warning (2): Invalid argument supplied for foreach() [CORE/app/views/agent/detail.ctp, line 191]
6 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `residential`535311
2SELECT `profiles`.`id`, `profiles`.`fname`, `profiles`.`lname`, `profiles`.`home`, `profiles`.`work`, `profiles`.`ext`, `profiles`.`cell`, `profiles`.`fax`, `profiles`.`email`, `profiles`.`webadd`, `profiles`.`office`, `profiles`.`waddress`, `profiles`.`city`, `profiles`.`state`, `profiles`.`property`, `profiles`.`years`, `profiles`.`degree`, `profiles`.`commit`, `profiles`.`hobby`, `profiles`.`addit`, `profiles`.`realname`, `profiles`.`team_id`, `profiles`.`office_id` FROM `profiles` AS `profiles` WHERE `profiles`.`id` = 84 LIMIT 1002
3SELECT * FROM `residential` as `Residential` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC1064: 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 ' ) ORDER BY `price` ASC' at line 11
4SELECT * FROM `commercial` as `Commercial` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC1064: 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 ' ) ORDER BY `price` ASC' at line 11
5SELECT * FROM `land` as `Land` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC1064: 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 ' ) ORDER BY `price` ASC' at line 11
6SELECT * FROM `multi_family` as `Multifamily` WHERE office in (12,19,117) AND agent IN (, ) ORDER BY `price` ASC1064: 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 ' ) ORDER BY `price` ASC' at line 11