SELECT classified_id, classified_startdate, classified_enddate, classifieds_cat_desc, classified_fullname, classified_address, classified_city, classified_state, classified_country, user_id, classified_url, classified_display, classified_subject, classified_content, classified_photo, classified_email, classified_phone, classified_photoext FROM classifieds_t, classifieds_cat_t WHERE 1=1 AND classified_category = #category# AND classified_photo = '1' AND classifieds_t.classified_category = classifieds_cat_t.classifieds_cat_id AND classified_enddate >= '#DateFormat(Now(),"yyyy-mm-dd")#' ORDER BY classified_id DESC

Viewing Classifieds
** #qGetAds.classifieds_cat_desc# **

Add A Classified | View The Classifieds
Manage My Classifieds | Manage My Alerts

There are #qGetAds.RecordCount# classifieds in this category with photos.

(Displaying #SR# to #ER#)

Headline: #classified_subject#

#classified_id#

#ParagraphFormat(classified_content)#

click for fullsize image

click for fullsize image

colspan=2>

Listed By:
#classified_fullname#

F150online Registered User

#classified_city#, #Ucase(classified_state)# #classified_country#

#classified_phone#

Click Here To Reply By Email

View all classifieds from this user

Posted on:	#DateFormat(classified_startdate,'m/d/yyy')#
Expires On:	#DateFormat(classified_enddate,'m/d/yyy')#

Headline: #classified_subject#

#classified_id#

#ParagraphFormat(classified_content)#

click for fullsize image

click for fullsize image

colspan=2>

Listed By:
#classified_fullname#

F150online Registered User

#classified_city#, #Ucase(classified_state)# #classified_country#

#classified_phone#

Click Here To Reply By Email

View all classifieds from this user

Posted on:	#DateFormat(classified_startdate,'m/d/yyy')#
Expires On:	#DateFormat(classified_enddate,'m/d/yyy')#

Sorry, there are no classifieds in this category.