SELECT *
FROM tblListing
WHERE brokerUsername = '#bname#' AND listStatus <> 3 AND (listResType = 'Single Family Detatched' OR listResType = 'Single Family Attached' OR listResType = 'Multi-Unit Income')
SELECT COUNT(listID) AS homeCount
FROM tblListing
WHERE brokerUsername = '#bname#' AND listStatus <> 3 AND (listResType = 'Single Family Detatched' OR listResType = 'Single Family Attached' OR listResType = 'Multi-Unit Income')
West Virginia Realtor - Real Estate Plus - #baddress#