SELECT DISTINCT listState
FROM tblListing WHERE brokerUsername='#bname#'
ORDER BY listState ASC;
SELECT DISTINCT listCity
FROM tblListing WHERE brokerUsername='#bname#'
ORDER BY listCity ASC;
SELECT DISTINCT listZip
FROM tblListing WHERE brokerUsername='#bname#'
ORDER BY listZip ASC;
SELECT DISTINCT (listPrice) AS minPrice
FROM tblListing
WHERE brokerUsername = '#bname#'
ORDER BY listPrice ASC;
SELECT DISTINCT (listPrice) AS maxPrice
FROM tblListing
WHERE brokerUsername = '#bname#'
ORDER BY listPrice DESC;
West Virginia Realtor - Real Estate Plus - <cfoutput>#baddress#</cfoutput>
