SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SE15 5AA' order by fulladdress
SE15 5AA - 1,233,000
- Freehold Semi-detached house
SE15 5AA - 1,560,000
- Freehold End terrace house
SE15 5AA - 1,354,000
- Freehold Semi-detached house
SE15 5AA - 1,307,000
- Freehold End terrace house
SE15 5AA - 1,496,000
- Freehold Semi-detached house
SE15 5AA - 1,907,000
- Freehold Mid terrace house
SE15 5AA - 1,582,000
- Freehold End terrace house
SE15 5AA - 1,204,000
- Freehold Semi-detached property
SE15 5AA - 1,477,000
- Freehold End terrace house
SE15 5AA - 890,000
- Freehold End terrace house
SE15 5AA - 856,000
- Freehold Semi-detached house
SE15 5AA - 611,000
- Leasehold Purpose built flat
SE15 5AA - 681,000
- Leasehold Purpose built flat
SE15 5AA - 524,000
- Leasehold Flat/Maisonette
SE15 5AA - 1,533,000
- Freehold End terrace house
SE15 5AA - 980,000
- Freehold Semi-detached property
SE15 5AA - 1,483,000
- Freehold Mid terrace house
SE15 5AA - 363,000
- Leasehold Flat/Maisonette
SE15 5AA - 578,000
- Leasehold Flat/Maisonette
SE15 5AA - 346,000
- Leasehold Flat/Maisonette
SE15 5AA - 364,000
- Leasehold Flat/Maisonette
SE15 5AA - 318,000
- Leasehold Flat/Maisonette
SE15 5AA - 345,000
- Leasehold Flat/Maisonette
SE15 5AA - 346,000
- Leasehold Flat/Maisonette
SE15 5AA - 336,000
- Leasehold Flat/Maisonette
SE15 5AA - 339,000
- Leasehold Converted flat
SE15 5AA - 618,000
- Leasehold Purpose built flat
SE15 5AA - 634,000
- Leasehold Purpose built flat
SE15 5AA - 361,000
- Leasehold Flat/Maisonette
SE15 5AA - 605,000
- Leasehold Flat/Maisonette
SE15 5AA - 349,000
- Leasehold Flat/Maisonette
SE15 5AA - 365,000
- Leasehold Flat/Maisonette
SE15 5AA - 360,000
- Leasehold Flat/Maisonette
SE15 5AA - 343,000
- Leasehold Flat/Maisonette
SE15 5AA - 347,000
- Leasehold Purpose built flat
SE15 5AA - 341,000
- Leasehold Flat/Maisonette
SE15 5AA - 499,000
- Leasehold Flat/Maisonette
SE15 5AA - 726,000
- Leasehold Purpose built flat
SE15 5AA - 724,000
- Leasehold Flat/Maisonette
SE15 5AA - 341,000
- Leasehold Purpose built flat
SE15 5AA - 651,000
- Leasehold Flat/Maisonette
SE15 5AA - 583,000
- Leasehold Flat/Maisonette
SE15 5AA - 340,000
- Freehold Converted flat
SE15 5AA - 352,000
- Leasehold Flat/Maisonette
SE15 5AA - 316,000
- Leasehold Flat/Maisonette
SE15 5AA - 333,000
- Leasehold Flat/Maisonette
SE15 5AA - 614,000
- Leasehold Purpose built flat
SE15 5AA - 615,000
- Leasehold Purpose built flat
