SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW1X 7BA' order by fulladdress
SW1X 7BA - 3,586,000
- Leasehold Mid terrace house
SW1X 7BA - 3,997,000
- Freehold Mid terrace house
SW1X 7BA - 2,755,000
- Leasehold Mid terrace house
SW1X 7BA - 4,304,000
- Freehold Mid terrace house
SW1X 7BA - 3,313,000
- Freehold Mid terrace house
SW1X 7BA - 4,133,000
- Leasehold Terrace property
SW1X 7BA - 2,832,000
- Leasehold Terrace property
SW1X 7BA - 2,777,000
- Share of freehold Flat/Maisonette
SW1X 7BA - 4,498,000
- Freehold Mid terrace house
SW1X 7BA - 3,792,000
- Leasehold Terrace property
SW1X 7BA - 5,071,000
- Leasehold Mid terrace house
SW1X 7BA - 3,806,000
- Leasehold Mid terrace property
SW1X 7BA - 2,585,000
- Leasehold Flat/Maisonette
SW1X 7BA - 4,065,000
- Freehold Mid terrace house
SW1X 7BA - 4,854,000
- Freehold Terrace property
SW1X 7BA - 4,229,000
- Freehold Mid terrace house
