SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='B75 5TJ' order by fulladdress
B75 5TJ - 658,000
- Freehold Detached house
B75 5TJ - 776,000
- Freehold Detached house
B75 5TJ - 578,000
- Freehold Detached house
B75 5TJ - 402,000
- Semi-detached house
B75 5TJ - 374,000
- Semi-detached house
B75 5TJ - 553,000
- Freehold Detached house
B75 5TJ - 715,000
- Freehold Detached house
B75 5TJ - 746,000
- Freehold Detached house
B75 5TJ - 733,000
- Freehold Detached house
B75 5TJ - 564,000
- Freehold Detached house
B75 5TJ - 729,000
- Freehold Detached house
B75 5TJ - 563,000
- Freehold Detached house
B75 5TJ - 611,000
- Freehold Detached house
B75 5TJ - 629,000
- Freehold Detached property
B75 5TJ - 579,000
- Freehold Detached house
B75 5TJ - 356,000
- Freehold Semi-detached house
B75 5TJ - 302,000
- Freehold Semi-detached house
B75 5TJ - 311,000
- Freehold Mid terrace house
B75 5TJ - 378,000
- Freehold End terrace house
B75 5TJ - 560,000
- Freehold Detached house
B75 5TJ - 711,000
- Freehold Detached house
B75 5TJ - 600,000
- Freehold Detached house
B75 5TJ - 599,000
- Freehold Detached house
B75 5TJ - 655,000
- Freehold Detached house
B75 5TJ - 596,000
- Freehold Detached house
B75 5TJ - 408,000
- Semi-detached house
B75 5TJ - 635,000
- Freehold Detached house
B75 5TJ - 323,000
- Semi-detached house
B75 5TJ - 597,000
- Freehold Detached house
B75 5TJ - 608,000
- Freehold Detached house
B75 5TJ - 567,000
- Freehold Detached house
B75 5TJ - 610,000
- Freehold Detached house
B75 5TJ - 621,000
- Freehold Detached house
B75 5TJ - 613,000
- Freehold Detached house
B75 5TJ - 603,000
- Freehold Detached house
B75 5TJ - 713,000
- Freehold Detached house
B75 5TJ - 583,000
- Freehold Detached house
B75 5TJ - 720,000
- Freehold Detached house
B75 5TJ - 678,000
- Freehold Detached house
B75 5TJ - 603,000
- Freehold Detached house
B75 5TJ - 733,000
- Freehold Detached house
B75 5TJ - 599,000
- Freehold Detached house
B75 5TJ - 734,000
- Freehold Detached house