The site is temporarily down for Maintenance, we apologize for any inconvenience. SELECT listID, listImage FROM tblListing WHERE listImage <> 'none' AND brokerUsername = '#bname#' AND listStatus <> 3 AND listFeatured = 1 SELECT COUNT(listID) AS fCount FROM tblListing WHERE listImage <> 'none' AND brokerUsername = '#bname#' AND listStatus <> 3 AND listFeatured = 1 SELECT DISTINCT (listPrice) AS minPrice FROM tblListing WHERE brokerUsername = '#bname#' ORDER BY listPrice ASC LIMIT 15; SELECT DISTINCT (listPrice) AS maxPrice FROM tblListing WHERE brokerUsername = '#bname#' ORDER BY listPrice DESC LIMIT 15; SELECT listMLS FROM tblListing WHERE brokerUsername = '#bname#' AND listMLS <> '' ORDER BY listMLS ASC; West Virginia Realtor - Real Estate Plus - <cfoutput>#baddress#</cfoutput> ">

search
residential
commercial
land
links
contact
agents
Realestate Plus Realestate Plus
Realestate Plus
Featured Homes  
 Price
low 
 
high 
 
 MLS#
 
 
Home Page