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 3BS' order by fulladdress
SE15 3BS - 1,063,000
- Freehold Mid terrace house
SE15 3BS - 1,078,000
- Freehold Mid terrace house
SE15 3BS - 1,077,000
- Freehold Mid terrace house
SE15 3BS - 499,000
- Leasehold Flat/Maisonette
SE15 3BS - 483,000
- Leasehold Flat/Maisonette
SE15 3BS - 504,000
- Leasehold Flat/Maisonette
SE15 3BS - 492,000
- Leasehold Flat/Maisonette
SE15 3BS - 488,000
- Leasehold Converted flat
SE15 3BS - 525,000
- Leasehold Converted flat
SE15 3BS - 1,068,000
- Freehold Mid terrace house
SE15 3BS - 966,000
- Freehold Mid terrace house
SE15 3BS - 529,000
- Leasehold Converted flat
SE15 3BS - 1,072,000
- Freehold End terrace house
SE15 3BS - 500,000
- Leasehold Converted flat
SE15 3BS - 495,000
- Leasehold Converted flat
SE15 3BS - 487,000
- Leasehold Converted flat
SE15 3BS - 530,000
- Leasehold Converted flat
SE15 3BS - 1,042,000
- Freehold End terrace house
SE15 3BS - 1,012,000
- Freehold Mid terrace house
SE15 3BS - 1,033,000
- Freehold Mid terrace house
SE15 3BS - 1,095,000
- Freehold Mid terrace house
SE15 3BS - 1,027,000
- Freehold Mid terrace house
SE15 3BS - 1,006,000
- Freehold Mid terrace house
SE15 3BS - 1,042,000
- Freehold Terrace property
SE15 3BS - 554,000
- Leasehold Converted flat
SE15 3BS - 1,084,000
- Freehold Mid terrace house
SE15 3BS - 1,043,000
- Freehold Mid terrace house
SE15 3BS - 1,004,000
- Freehold Mid terrace property
SE15 3BS - 476,000
- Leasehold Converted flat
SE15 3BS - 474,000
- Leasehold Converted flat
SE15 3BS - 999,000
- Freehold Terrace property
SE15 3BS - 476,000
- Leasehold Converted flat
SE15 3BS - 534,000
- Leasehold Converted flat
SE15 3BS - 505,000
- Leasehold Converted flat
SE15 3BS - 551,000
- Leasehold Converted flat
SE15 3BS - 518,000
- Leasehold Converted flat
SE15 3BS - 1,059,000
- Freehold Mid terrace house
SE15 3BS - 526,000
- Leasehold Purpose built flat
SE15 3BS - 520,000
- Leasehold Purpose built flat
SE15 3BS - 1,009,000
- Freehold Mid terrace house
SE15 3BS - 1,072,000
- Freehold Mid terrace house
SE15 3BS - 497,000
- Leasehold Converted flat
SE15 3BS - 537,000
- Leasehold Converted flat
SE15 3BS - 525,000
- Leasehold Converted flat
SE15 3BS - 1,053,000
- Freehold Terrace property
SE15 3BS - 1,062,000
- Freehold Mid terrace house
SE15 3BS - 512,000
- Freehold Flat/Maisonette
SE15 3BS - 506,000
- Leasehold Converted flat
SE15 3BS - 1,058,000
- Freehold Mid terrace house
SE15 3BS - 529,000
- Leasehold Converted flat
SE15 3BS - 1,179,000
- Freehold Terrace property
SE15 3BS - 1,097,000
- Freehold Mid terrace house
SE15 3BS - 1,072,000
- Freehold Mid terrace house
SE15 3BS - 460,000
- Leasehold Flat/Maisonette
SE15 3BS - 1,096,000
- Freehold Mid terrace house
SE15 3BS - 521,000
- Leasehold Converted flat
SE15 3BS - 471,000
- Leasehold Flat/Maisonette
SE15 3BS - 1,075,000
- Freehold Mid terrace house
SE15 3BS - 1,273,000
- Freehold Terrace property
SE15 3BS - 517,000
- Leasehold Converted flat
SE15 3BS - 520,000
- Leasehold Converted flat
SE15 3BS - 501,000
- Leasehold Converted flat
SE15 3BS - 546,000
- Leasehold Converted flat
SE15 3BS - 496,000
- Leasehold Converted flat
SE15 3BS - 473,000
- Leasehold Converted flat