Sold Properties / Waterfront Development
5 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `listings`21210
2DESCRIBE `listing_types`220
3DESCRIBE `images`330
4SELECT `ListingType`.`listing_type` FROM `listing_types` AS `ListingType` WHERE `ListingType`.`id`='WaterfrontDev' LIMIT 1110
5SELECT `Listing`.`id`, `Listing`.`price`, `Listing`.`title`, `Listing`.`description`, `Listing`.`coords`, `Listing`.`features_pdf`, `Listing`.`survey_pdf`, `Listing`.`youtube`, `Listing`.`modified` FROM `listings` AS `Listing` LEFT JOIN `listing_types` AS `ListingType` ON (`Listing`.`listing_type_id` = `ListingType`.`id`) WHERE `Listing`.`listing_type_id` = 'WaterfrontDev' AND `Listing`.`listing_status` = 'Sold' ORDER BY `Listing`.`price` DESC 000