SELECT * FROM tblListing WHERE brokerUsername = '#bname#' AND listStatus <> 3 AND listResType = 'Commercial Industrial' SELECT COUNT(listID) AS homeCount FROM tblListing WHERE brokerUsername = '#bname#' AND listStatus <> 3 AND listResType = 'Commercial Industrial' West Virginia Realtor - Real Estate Plus - <cfoutput>#baddress#</cfoutput>

COMMERCIAL LISTINGS
[#hcount#]
No Commercial Listings Found
 
#listImage#
 #listStreet1# #listStreet2#
#listFloorNum#   #listUnitNum#
 #listCity#, #listState#   #listZip#
 #listName#
#listDesc#
#DollarFormat(listPrice)#
Type: #listResType#
Beds: #listBedNum#
Baths: #listBathNum#
Rooms: #listTotRooms#
MLS ##: #listMLS#
  more info...
 
 


Home Page