SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B60 2TJ' order by fulladdress
B60 2TJ - 291,000
- Freehold Semi-detached house
B60 2TJ - 410,000
- Freehold Detached house
B60 2TJ - 289,000
- Freehold Semi-detached house
B60 2TJ - 546,000
- Freehold Detached house
B60 2TJ - 643,000
- Freehold Detached house
B60 2TJ - 599,000
- Freehold Detached house
B60 2TJ - 433,000
- Freehold Semi-detached house
B60 2TJ - 421,000
- Freehold Semi-detached property
B60 2TJ - 508,000
- Freehold Detached property
B60 2TJ - 423,000
- Freehold Semi-detached house
B60 2TJ - 421,000
- Freehold Semi-detached house
B60 2TJ - 351,000
- Freehold End terrace house
B60 2TJ - 387,000
- Freehold Mid terrace house
B60 2TJ - 392,000
- Freehold End terrace house
B60 2TJ - 402,000
- Freehold Semi-detached house
B60 2TJ - 409,000
- Freehold Semi-detached house
B60 2TJ - 186,000
- Freehold Purpose built flat
B60 2TJ - 348,000
- Freehold End terrace house
B60 2TJ - 270,000
- Freehold Mid terrace house
B60 2TJ - 339,000
- Freehold End terrace house
B60 2TJ - 569,000
- Freehold Detached house
B60 2TJ - 339,000
- Freehold Terrace property
B60 2TJ - 340,000
- Freehold End terrace house
B60 2TJ - 343,000
- Freehold Mid terrace house
B60 2TJ - 355,000
- Freehold Semi-detached house
B60 2TJ - 381,000
- Freehold End terrace house
B60 2TJ - 363,000
- Freehold Mid terrace house
B60 2TJ - 352,000
- Freehold End terrace house
B60 2TJ - 362,000
- Freehold End terrace house
B60 2TJ - 356,000
- Freehold Mid terrace house
B60 2TJ - 356,000
- Freehold End terrace house
B60 2TJ - 553,000
- Freehold Detached house
B60 2TJ - 561,000
- Freehold Detached house
B60 2TJ - 539,000
- Freehold Detached house