SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='BS4 5AA' order by fulladdress
BS4 5AA - 529,000
- Freehold Semi-detached house
BS4 5AA - 461,000
- Freehold Mid terrace house
BS4 5AA - 469,000
- Freehold Semi-detached house
BS4 5AA - 261,000
- Freehold Flat/Maisonette
BS4 5AA - 470,000
- Freehold End terrace house
BS4 5AA - 512,000
- Freehold Semi-detached house
BS4 5AA - 522,000
- Freehold Semi-detached house
BS4 5AA - 477,000
- Freehold Semi-detached house
BS4 5AA - 500,000
- Freehold Semi-detached house
BS4 5AA - 504,000
- Freehold Semi-detached house
BS4 5AA - 531,000
- Freehold Semi-detached house
BS4 5AA - 517,000
- Freehold Semi-detached house
BS4 5AA - 535,000
- Freehold Semi-detached house
BS4 5AA - 471,000
- Freehold End terrace house
BS4 5AA - 246,000
- Freehold Converted flat
BS4 5AA - 547,000
- Freehold Semi-detached house
BS4 5AA - 469,000
- Freehold End terrace house
BS4 5AA - 528,000
- Freehold Mid terrace house
BS4 5AA - 538,000
- Freehold End terrace house
BS4 5AA - 211,000
- Freehold Flat/Maisonette
BS4 5AA - 478,000
- Freehold Mid terrace house
BS4 5AA - 238,000
- Leasehold Converted flat
BS4 5AA - 223,000
- Leasehold Converted flat
BS4 5AA - 246,000
- Leasehold Converted flat
BS4 5AA - 241,000
- Leasehold Converted flat
