SELECT C.*, GP.PhotoID, MP.ServerID, MP.FolderID FROM Classifieds C LEFT JOIN GalleryPhoto GP ON GP.GalleryID = C.GUID LEFT JOIN MemberPhotos MP ON MP.PhotoID = GP.PhotoID WHERE ClassifiedsCategoryID = 1 AND (C.Status IS NULL OR C.Status IN ('N','C')) AND DateChanged >= '12/23/2012' AND (GP.PhotoID IS NULL OR GP.PhotoOrder = 1) ORDER BY DateAdded Desc Logan Martin Lake Classifieds Category
Lakes Online » U.S. Lakes » Alabama Lakes » Logan Martin Lake      Login  |  Home
Advertisement Innovative Window Films - North Alabama


Advertise With Us
Logan Martin Lake Classifieds Category
FREE AD POSTING !!!
Classifieds Home
Post An Ad
Change/Delete Ad
Boats
Cabin Cruisers (6)
Canoes & Kayaks (0)
Fishing Boats (5)
House Boats (7)
Outboard Motors (4)
Pedal Boats (2)
 Personal Watercraft (9)
Pontoon Boats (18)
Sail Boats (3)
Ski Boats (18)
Sport Boats (8)
Trailers (3)
Quick Links
Logan Martin Lake News
Logan Martin Lake Photos
Logan Martin Lake Videos
About Us
Contact Us
Site Map
Search Site
Advertise With Us
   
www.LoganMartin.info
THE LOGAN MARTIN LAKE WEBSITE

Copyright 2013, Lakes Online
Privacy    |    Legal