SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SS9 2BF' order by fulladdress
SS9 2BF - 446,000
- Leasehold Flat/Maisonette
SS9 2BF - 845,000
- Leasehold Flat/Maisonette
SS9 2BF - 722,000
- Leasehold Flat/Maisonette
SS9 2BF - 581,000
- Leasehold Flat/Maisonette
SS9 2BF - 707,000
- Leasehold Flat/Maisonette
SS9 2BF - 854,000
- Leasehold Flat/Maisonette
SS9 2BF - 684,000
- Leasehold Flat/Maisonette
SS9 2BF - 604,000
- Leasehold Flat/Maisonette
SS9 2BF - 734,000
- Leasehold Purpose built flat
SS9 2BF - 726,000
- Leasehold Flat/Maisonette
SS9 2BF - 565,000
- Leasehold Purpose built flat
SS9 2BF - 837,000
- Leasehold Flat/Maisonette
SS9 2BF - 813,000
- Leasehold Flat/Maisonette
SS9 2BF - 631,000
- Leasehold Flat/Maisonette
SS9 2BF - 719,000
- Leasehold Flat/Maisonette
SS9 2BF - 1,120,000
- Leasehold Flat/Maisonette
SS9 2BF - 808,000
- Leasehold Flat/Maisonette
SS9 2BF - 601,000
- Leasehold Flat/Maisonette
SS9 2BF - 1,439,000
- Leasehold Flat/Maisonette
SS9 2BF - 832,000
- Leasehold Flat/Maisonette
SS9 2BF - 680,000
- Leasehold Flat/Maisonette
SS9 2BF - 1,583,000
- Leasehold Flat/Maisonette
SS9 2BF - 758,000
- Leasehold Flat/Maisonette
SS9 2BF - 750,000
- Leasehold Flat/Maisonette
SS9 2BF - 610,000
- Leasehold Flat/Maisonette
SS9 2BF - 746,000
- Leasehold Flat/Maisonette
SS9 2BF - 759,000
- Leasehold Purpose built flat
SS9 2BF - 829,000
- Leasehold Flat/Maisonette