Real Estate Services

1606 1187 Sunset Drive,

SOLD
1 Bed
1 Bath




Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/lib/php/pixilink/classes/Listing.php on line 91
Sort aborted: Server shutdown in progressselect houses.*, typesofhouses.type, typesofhouses.commercial, IF(agent_id > 0, 1, 0) as 'agent1' from pixilink_360.houses left join pixilink_360.typesofhouses on (typesofhouses.house_type = houses.type) where mls = '' and (agent_id = 3823 or agent_id2 = 3823 or is_pixilink = 'y') and is_deleted <> 1 order by agent1 desc, house_id desc