SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SK23 7GA' order by fulladdress
SK23 7GA - 655,000
- Freehold Detached house
SK23 7GA - 657,000
- Freehold Detached property
SK23 7GA - 640,000
- Freehold Detached house
SK23 7GA - 650,000
- Freehold Detached house
SK23 7GA - 783,000
- Freehold Detached house
SK23 7GA - 718,000
- Freehold Detached house
SK23 7GA - 606,000
- Freehold Detached house
SK23 7GA - 615,000
- Freehold Detached house
SK23 7GA - 620,000
- Freehold Detached house
SK23 7GA - 627,000
- Freehold Detached house
SK23 7GA - 717,000
- Freehold Detached house
SK23 7GA - 766,000
- Freehold Detached house
SK23 7GA - 644,000
- Freehold Detached property
SK23 7GA - 760,000
- Freehold Detached property
SK23 7GA - 628,000
- Freehold Detached house
SK23 7GA - 747,000
- Freehold Detached property
SK23 7GA - 774,000
- Freehold Detached property
SK23 7GA - 813,000
- Freehold Detached house
SK23 7GA - 805,000
- Freehold Detached house
SK23 7GA - 779,000
- Freehold Detached house
SK23 7GA - 641,000
- Freehold Detached house
SK23 7GA - 809,000
- Freehold Detached house
SK23 7GA - 733,000
- Freehold Detached house
SK23 7GA - 708,000
- Freehold Detached house
SK23 7GA - 707,000
- Freehold Detached property
SK23 7GA - 848,000
- Freehold Detached house
SK23 7GA - 685,000
- Freehold Detached house
SK23 7GA - 654,000
- Freehold Detached house
SK23 7GA - 768,000
- Freehold Detached property