Build HierarchyQUERY[SELECT DISTINCT c.*, h.name as h_name FROM cms_module_listings c INNER JOIN cms_module_listings_prodtohier ph ON ph.listing_id = c.id INNER JOIN cms_module_listings_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' and (c.listing_date < now() or c.listing_date is null) AND upper(h.long_name) LIKE upper(?) ORDER BY listing_date desc]
| AD #9002 | Bakery (Business) | Tantallon, Nova Scotia | 425,000 |
|
| Bakery for sale. Option to purchase/rent separately.
Great little business waiting for you to enjoy. Located on the busiest tourist route in Nova Scotia and established for 20 yrs. Steady local clientele as well as a thriving tourist stop.
Perfect for a mom and pop operation!
3,000 sq/ft. 2 story building on a beautiful 1.7 acre ocean... [ read more] |
| [Top] |
Debug:
Build HierarchyQUERY[SELECT DISTINCT c.*, h.name as h_name FROM cms_module_listings c INNER JOIN cms_module_listings_prodtohier ph ON ph.listing_id = c.id INNER JOIN cms_module_listings_hierarchy h ON ph.hierarchy_id = h.id WHERE c.status = 'published' and (c.listing_date < now() or c.listing_date is null) AND upper(h.long_name) LIKE upper(?) ORDER BY listing_date desc]
