SELECT Id FROM new_searchtable
where town like 'Alton%' and state='NH' and type='R'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Copyright © 2022 New England Real Estate Network, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of NEREN. The information being provided is for consumers´ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated November 26th, 2022 Designed by BSC DATA