Try this code

select house_no from YourTable

where house_no between '4-12-1000' and'4-12-1500'

AND ISNUMERIC(SUBSTRING(house_NO,6,4))=1

and CONVERT(INT,SUBSTRING(house_NO,6,4)) BETWEEN 1000 AND 1500

Regards

IgorMi