SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BD17 7LJ' order by fulladdress
BD17 7LJ - 260,000
- Freehold Semi-detached bungalow
BD17 7LJ - 391,000
- Freehold Detached bungalow
BD17 7LJ - 280,000
- Freehold Semi-detached property
BD17 7LJ - 365,000
- Freehold Detached property
BD17 7LJ - 413,000
- Freehold Detached bungalow
BD17 7LJ - 334,000
- Freehold Semi-detached property
BD17 7LJ - 323,000
- Freehold Semi-detached bungalow
BD17 7LJ - 393,000
- Freehold Detached bungalow
BD17 7LJ - 398,000
- Freehold Detached bungalow
BD17 7LJ - 242,000
- Freehold Semi-detached bungalow
BD17 7LJ - 407,000
- Freehold Bungalow property
BD17 7LJ - 320,000
- Freehold Bungalow property
BD17 7LJ - 800,000
- Freehold Detached property
BD17 7LJ - 681,000
- Freehold Detached house
BD17 7LJ - 744,000
- Freehold Detached property
BD17 7LJ - 355,000
- Freehold Detached bungalow
BD17 7LJ - 709,000
- Freehold Detached property
BD17 7LJ - 843,000
- Freehold Detached house
BD17 7LJ - 714,000
- Freehold Detached house
BD17 7LJ - 707,000
- Freehold Detached house
BD17 7LJ - 673,000
- Freehold Detached house
BD17 7LJ - 668,000
- Freehold Detached house
BD17 7LJ - 697,000
- Freehold Detached house
BD17 7LJ - 360,000
- Freehold Detached bungalow
BD17 7LJ - 649,000
- Freehold Detached property
BD17 7LJ - 600,000
- Freehold Detached house
BD17 7LJ - 552,000
- Freehold Detached house
BD17 7LJ - 423,000
- Freehold Detached bungalow
BD17 7LJ - 319,000
- Freehold Detached bungalow