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
Dennis Carey

Dennis Carey


Phone(Work): 719-585-8738  Ext:
Phone(Cell): 1-800-748-1649
Fax: 719-546-1243
Email: dc@aculink.net
Web Address:
Office: 511 west 29th st. ste a pueblo,co 511 w 29th st ste.a
  • Property: property management & leasing
  • Years Experience: 9
  • Degree(s): BA bus. mgmt/marketing
  • Commitment to customers: to maximize our investors return on their investments
  • My hobbies: golf and skiing
  • Additional information: we offer full service property management and leasing

Listings:

Residential

Commercial

Land

Multi Family

10 queries took 92 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `profiles`23237
2DESCRIBE `residential`535312
3DESCRIBE `commercial`34348
4DESCRIBE `land`28287
5DESCRIBE `multi_family`11211220
6SELECT `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` = 76 LIMIT 1112
7SELECT * FROM `residential` as `Residential` WHERE office in (12,19,117) AND agent IN (556, 0) ORDER BY `price` ASC0018
8SELECT * FROM `commercial` as `Commercial` WHERE office in (12,19,117) AND agent IN (556, 0) ORDER BY `price` ASC003
9SELECT * FROM `land` as `Land` WHERE office in (12,19,117) AND agent IN (556, 0) ORDER BY `price` ASC0011
10SELECT * FROM `multi_family` as `Multifamily` WHERE office in (12,19,117) AND agent IN (556, 0) ORDER BY `price` ASC004