Listings / Waterfront Development
$0 - WANTED- CAMPGROUND / TRAILER PARK
Land O' Lakes Area - We have a serious buyer looking to purchase an existing camp ground,trailer park or vacant land on water for a possible trailer park. Please email or call to discuss.
Features
Click an image to enlarge.
 
6 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `listings`21211
2DESCRIBE `listing_types`220
3DESCRIBE `images`331
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` = 'Active' ORDER BY `Listing`.`price` DESC 110
6SELECT `Image`.`id`, `Image`.`caption`, `Image`.`data` FROM `images` AS `Image` JOIN `images_listings` ON (`images_listings`.`listing_id` = 400 AND `images_listings`.`image_id` = `Image`.`id`) WHERE 1 = 1 ORDER BY image_id ASC 110