Select QCA.*, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Amenities)), ''), QCA.Amenities) as Amenities, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Directions)), ''), QCA.Directions) as Directions, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Description)), ''), QCA.Description) as Description, ISNULL(NULLIF(LTRIM(RTRIM(Overrides.Special)), ''), QCA.Special) as Special from qrycustomersall QCA LEFT JOIN (SELECT CO.* FROM CustomerOverrides CO WITH(NOLOCK) INNER JOIN ControlModule CM WITH(NOLOCK) ON CO.ControlId = CM.Control_Id WHERE (CM.ModuleId = 94)) Overrides ON (15 = Overrides.ControlId AND QCA.CustomerId = Overrides.CustomerId) where QCA.customerid = 42599 and ( QCA.control_id = 15 ) and QCA.show = 1
Beautiful nature Reserve just 10kms out of Esperance.
Ideal for a picnic, great walks including a board walk on the Lake, bird watching and many wildflowers in season.
Directions: From Esperance, follow the South Coast Highway until you see the signs to Telegraph Road. Monjingup Lake Nature Reserve spreads on both sides of that road, first entrance on the left hand side, second entrance further on the right hand side of Telegraph Road.