SELECT * FROM Brokers WHERE BrokerID LIKE '#firm#' SELECT * FROM Residential WHERE ('All Towns' IN (#PreserveSingleQuotes(Towns)# ) OR Township IN (#PreserveSingleQuotes(Towns)#)) AND Price BETWEEN #MinPrice# AND #MaxPrice# AND BR BETWEEN #MinBR# AND #MaxBR# AND Acres BETWEEN #MinAcres# AND #MaxAcres# AND SqFt BETWEEN #MinSqFt# AND #MaxSqFt# AND Res_Typ <> 'Condo' ORDER BY Price desc SELECT * FROM Residential WHERE ('All Towns' IN (#PreserveSingleQuotes(Towns)# ) OR Township IN (#PreserveSingleQuotes(Towns)#)) AND Price BETWEEN #MinPrice# AND #MaxPrice# AND BR BETWEEN #MinBR# AND #MaxBR# AND SqFt BETWEEN #MinSqFt# AND #MaxSqFt# AND Res_Typ = 'Condo' ORDER BY Price desc SELECT * FROM MultiFam WHERE ('All Towns' IN (#PreserveSingleQuotes(Towns)# ) OR Township IN (#PreserveSingleQuotes(Towns)#)) AND Price BETWEEN #MinPrice# AND #MaxPrice# AND SqFt BETWEEN #MinSqFt# AND #MaxSqFt# ORDER BY Price desc SELECT * FROM Land WHERE ('All Towns' IN (#PreserveSingleQuotes(Towns)# ) OR Township IN (#PreserveSingleQuotes(Towns)#)) AND Price BETWEEN #MinPrice# AND #MaxPrice# AND Acres BETWEEN #MinAcres# AND #MaxAcres# ORDER BY Price desc SELECT * FROM Com WHERE ('All Towns' IN (#PreserveSingleQuotes(Towns)# ) OR Township IN (#PreserveSingleQuotes(Towns)#)) AND Price BETWEEN #MinPrice# AND #MaxPrice# AND SqFt BETWEEN #MinSqFt# AND #MaxSqFt# ORDER BY Price desc Vermont <cfoutput>#Pclass# For Sale in #Towns# VT</cfoutput>

Search Results - #Pclass# For Sale in #Towns# VT

The following #Pclass# Properties are arranged by price in descending order:

Records #StartRow_PropDetails# to #EndRow_PropDetails# of #PropDetails.RecordCount#
SELECT ('All Towns' IN (#PreserveSingleQuotes(Towns)# ) OR Township IN (#PreserveSingleQuotes(Towns)#)) FROM Residential

Currently there are no properties in #PreserveSingleQuotes(Towns)# Vermont meeting your criteria. Please Click Here to search again .