Professional Landlord Software Developed With You In Mind.

SELECT * FROM `property` WHERE `on_homepage` = '1' AND `num_images` > '0' AND `archived` = '0' AND `active` = '1' ORDER BY RAND() ASC LIMIT 1

SELECT *, `property`.`active` AS `active`, `property`.`propertyID` AS `propertyID`, `property`.`sale_or_rent` AS `sale_or_rent`, `pd_s`.`price_desc` AS `price_sale_desc`, `pd_r`.`price_desc` AS `price_rent_desc`, `property`.`date_added` AS `date_added`, `staff_added`.`first_name` AS `staff_added_first_name`, `staff_added`.`last_name` AS `staff_added_last_name`, `property`.`property_number` AS `property_number`, `property`.`street_name` AS `street_name`, `property`.`town_city` AS `town_city`, `counties`.`countyID` AS `countyID`, `counties`.`county` AS `county`, `property`.`postcode_pt1` AS `postcode_pt1`, `property`.`postcode_pt2` AS `postcode_pt2`, `property`.`country_code` AS `country_code`, `property`.`address_uuid` AS `address_uuid`, `vd`.`vendorID` AS `owner_vendorID`, `vd`.`first_name` AS `owner_first_name`, `vd`.`last_name` AS `owner_last_name`, `vd`.`phone` AS `owner_phone`, `vd`.`mobile` AS `owner_mobile`, `property_types`.`type` AS `type`, `property`.`lat` AS `lat`, `property`.`long` AS `long`, `property`.`added_methodID` AS `added_methodID`, `property`.`agentID` AS `agentID`, `property`.`agentID_added_by` AS `agentID_added_by`, `property`.`staffID_added_by` AS `staffID_added_by`, `property`.`typeID` AS `propertyTypeID`, `agent_marketing_details`.`agentID` AS `agent_marketing_agentID`, `agent_marketing_details`.`logo` AS `agent_marketing_logo`, `agent_marketing_details`.`company_name` AS `agent_marketing_company_name`, `agent_marketing_details`.`property_number` AS `agent_marketing_property_number`, `agent_marketing_details`.`street_name` AS `agent_marketing_street_name`, `agent_marketing_details`.`town_city` AS `agent_marketing_town_city`, `ca2`.`county` AS `agent_marketing_county`, `agent_marketing_details`.`postcode_pt1` AS `agent_marketing_postcode_pt1`, `agent_marketing_details`.`postcode_pt2` AS `agent_marketing_postcode_pt2`, `agent_marketing_details`.`phone` AS `agent_marketing_phone`, `agent_marketing_details`.`mobile` AS `agent_marketing_mobile`, `agent_marketing_staff`.`staffID` AS `agent_marketing_staffID`, `agent_marketing_staff`.`email` AS `agent_marketing_staff_email`, `agent_marketing_staff`.`first_name` AS `agent_marketing_staff_first_name`, `agent_marketing_staff`.`last_name` AS `agent_marketing_staff_last_name`, `agent_marketing_staff`.`phone` AS `agent_marketing_staff_phone` FROM `property` INNER JOIN `property_details` ON `property_details`.`propertyID` = `property`.`propertyID` INNER JOIN `counties` ON `counties`.`countyID` = `property`.`county` LEFT JOIN `property_types` ON `property_types`.`typeID` = `property`.`typeID` LEFT JOIN `property_price_descs` AS `pd_s` ON `pd_s`.`priceID` = `property`.`price_sale_descID` LEFT JOIN `property_price_descs` AS `pd_r` ON `pd_r`.`priceID` = `property`.`price_rent_descID` LEFT JOIN `agents_staff` AS `staff_added` ON `staff_added`.`staffID` = `property`.`staffID_added_by` LEFT JOIN `vendors_to_properties` AS `v2p` ON `v2p`.`propertyID` = `property`.`propertyID` LEFT JOIN `vendors_details` AS `vd` ON `vd`.`vendorID` = `v2p`.`vendorID` LEFT JOIN `property_tenures` ON `property_tenures`.`tenureID` = `property`.`tenureID` LEFT JOIN `agents` AS `agent_marketing` ON `agent_marketing`.`agentID` = `property`.`agentID` LEFT JOIN `agents_details` AS `agent_marketing_details` ON `agent_marketing_details`.`agentID` = `agent_marketing`.`agentID` LEFT JOIN `counties` AS `ca2` ON `ca2`.`countyID` = `agent_marketing_details`.`county` LEFT JOIN `agents_staff` AS `agent_marketing_staff` ON `agent_marketing_staff`.`staffID` = `property`.`staffID` WHERE `property`.`propertyID` = '2674' LIMIT 1