SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BL7 9GX' order by fulladdress
BL7 9GX - 573,000
- Leasehold Detached house
BL7 9GX - 162,000
- Leasehold Mid terrace house
BL7 9GX - 156,000
- Leasehold End terrace house
BL7 9GX - 119,000
- Leasehold Flat/Maisonette
BL7 9GX - 118,000
- Leasehold Flat/Maisonette
BL7 9GX - 131,000
- Leasehold Flat/Maisonette
BL7 9GX - 486,000
- Leasehold Detached house
BL7 9GX - 118,000
- Leasehold Flat/Maisonette
BL7 9GX - 117,000
- Leasehold Flat/Maisonette
BL7 9GX - 121,000
- Leasehold Flat/Maisonette
BL7 9GX - 143,000
- Leasehold Purpose built flat
BL7 9GX - 137,000
- Leasehold Purpose built flat
BL7 9GX - 136,000
- Leasehold Flat/Maisonette
BL7 9GX - 145,000
- Leasehold Flat/Maisonette
BL7 9GX - 139,000
- Leasehold Flat/Maisonette
BL7 9GX - 140,000
- Leasehold Purpose built flat
BL7 9GX - 143,000
- Leasehold Purpose built flat
BL7 9GX - 628,000
- Leasehold Detached house
BL7 9GX - 139,000
- Leasehold Purpose built flat
BL7 9GX - 141,000
- Leasehold Flat/Maisonette
BL7 9GX - 135,000
- Leasehold Flat/Maisonette
BL7 9GX - 139,000
- Leasehold Flat/Maisonette
BL7 9GX - 140,000
- Leasehold Flat/Maisonette
BL7 9GX - 122,000
- Leasehold Purpose built flat
BL7 9GX - 249,000
- Leasehold Flat/Maisonette
BL7 9GX - 119,000
- Leasehold Flat/Maisonette
BL7 9GX - 140,000
- Leasehold Flat/Maisonette
BL7 9GX - 139,000
- Leasehold Flat/Maisonette
BL7 9GX - 586,000
- Leasehold Detached house
BL7 9GX - 139,000
- Leasehold Flat/Maisonette
BL7 9GX - 144,000
- Leasehold Flat/Maisonette
BL7 9GX - 152,000
- Leasehold Mid terrace house
BL7 9GX - 161,000
- Leasehold Mid terrace house
BL7 9GX - 159,000
- Leasehold Terrace property
BL7 9GX - 159,000
- Leasehold Mid terrace house
BL7 9GX - 162,000
- Leasehold Mid terrace house
BL7 9GX - 162,000
- Leasehold End terrace house
BL7 9GX - 590,000
- Leasehold Detached house
BL7 9GX - 145,000
- Leasehold Mid terrace house
BL7 9GX - 156,000
- Leasehold End terrace house
BL7 9GX - 169,000
- Leasehold End terrace house
BL7 9GX - 158,000
- Leasehold End terrace house
BL7 9GX - 157,000
- Leasehold Terrace property
BL7 9GX - 157,000
- Leasehold Mid terrace house
BL7 9GX - 161,000
- Leasehold Mid terrace house
BL7 9GX - 161,000
- Leasehold Terrace property
BL7 9GX - 158,000
- Leasehold Terrace property