REGION:00062Cats
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 #7009 | Cedar Log Cabin (Home) | Hammond River, New Brunswick | 120,000 |
|
| Cedar log cabin situated on 22 acres of land along the Hammond River in Kings County (Upham), NB. Amenities: propane stove and lights; large antique cast iron cook stove; 10 foot wide, double liner cobblestone fireplace; pine floors; cedar cabinets; loft sleeps 8; large kitchen and living room opposite fireplace; septic tank.
Approximately 2500... [ read more] |
| [Top] |
| AD #7004 | 185 ft. on water X 700 ft. deep (Land) (Recreational) | provincial route 715 Lakeview Road., Coles Island New Brunswick | 95,000.00 |
|
| Gorgeous waterfront acreage on Washademoak Lake, New Brunswick, Canada. Less than 1 hour from Moncton, Saint John or Fredericton, on provincial route 715 Lakeview Road. Lots are Approx. 185 feet on the water and 700 feet deep,3 - 4 acres. Well treed for privacy, added bonus no bugs. Deep water for boat moorage, Washademoak Lake is part of the... [ read more] |
| [Top] |
Debug:
REGION:00062Cats
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]
