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 - <cfoutput>#baddress#</cfoutput>

RESIDENTIAL LISTINGS
[#hcount#]
No Residential 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