$mls	=	"121536"
$listing	=	array()
$openhouse	=	array()
$images	=	array(0 => array, 1 => array, 2 => array, 3 => array, 4 => array, 5 => array)

        $listing = $this->Residential->findAllBymls($mls);


        $openhouse = $this->Openhouse->findAllBymls($mls);


                $images = $this->Image->findAllBymls($mls);


        $agent = $this->AgentList->find('agent_id = '.$listing[0]['Residential']['agent']." and office_id = ".$listing[0]['Residential']['office']);


        $office = $this->OfficeList->findAllByoffice_id($listing[0]['Residential']['office']);

ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 146
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

$sql	=	"SELECT `Agent`.`agent_id`, `Agent`.`first`, `Agent`.`last`, `Agent`.`address`, `Agent`.`address1`, `Agent`.`city`, `Agent`.`state`, `Agent`.`zip`, `Agent`.`phone`, `Agent`.`mobile`, `Agent`.`fax`, `Agent`.`email`, `Agent`.`web_address`, `Agent`.`office_id` FROM `agent_list` AS `Agent`   WHERE agent_id =  and office_id =    LIMIT 1"
$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 'and office_id =    LIMIT 1' at line 1"

        if (($this->debug || $error) && Configure::read() > 0) {


            e("<p style = \"text-align:left\"><b>Query:</b> {$sql} ");


            if ($error) {


                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);


            } else {

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 463
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 289
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 331
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 593
Model::findAll() - CORE/cake/libs/model/model.php, line 1451
Model::find() - CORE/cake/libs/model/model.php, line 1378
ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 146
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

$mls	=	"121536"
$listing	=	array()
$openhouse	=	array()
$images	=	array(0 => array, 1 => array, 2 => array, 3 => array, 4 => array, 5 => array)
$agent	=	false

        $openhouse = $this->Openhouse->findAllBymls($mls);


                $images = $this->Image->findAllBymls($mls);


        $agent = $this->AgentList->find('agent_id = '.$listing[0]['Residential']['agent']." and office_id = ".$listing[0]['Residential']['office']);


        $office = $this->OfficeList->findAllByoffice_id($listing[0]['Residential']['office']);


        

ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 147
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

$mls	=	"121536"
$listing	=	array()
$openhouse	=	array()
$images	=	array(0 => array, 1 => array, 2 => array, 3 => array, 4 => array, 5 => array)
$agent	=	false
$office	=	array()

        $office = $this->OfficeList->findAllByoffice_id($listing[0]['Residential']['office']);


        


        #pr ($openhouse);


        $this->pageTitle = " :: ".$listing[0]['Residential']['number']." ".$listing[0]['Residential']['address']." ".$listing[0]['Residential']['city'];


        $this->set('openhouse',$openhouse);

ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 150
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83