SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW15 1QG' order by fulladdress
SW15 1QG - 1,688,000
- Freehold End terrace house
SW15 1QG - 791,000
- Leasehold Flat/Maisonette
SW15 1QG - 855,000
- Leasehold Flat/Maisonette
SW15 1QG - 1,533,000
- Freehold Mid terrace house
SW15 1QG - 789,000
- Leasehold Flat/Maisonette
SW15 1QG - 973,000
- Leasehold Converted flat
SW15 1QG - 1,494,000
- Freehold Mid terrace house
SW15 1QG - 828,000
- Leasehold Flat/Maisonette
SW15 1QG - 802,000
- Leasehold Flat/Maisonette
SW15 1QG - 968,000
- Leasehold Purpose built flat
SW15 1QG - 1,174,000
- Leasehold Purpose built flat
SW15 1QG - 1,618,000
- Freehold Mid terrace house
SW15 1QG - 764,000
- Leasehold Flat/Maisonette
SW15 1QG - 868,000
- Leasehold Purpose built flat
SW15 1QG - 871,000
- Leasehold Flat/Maisonette
SW15 1QG - 1,518,000
- Freehold Mid terrace house
SW15 1QG - 1,633,000
- Freehold Mid terrace house
SW15 1QG - 796,000
- Leasehold Purpose built flat
SW15 1QG - 847,000
- Leasehold Converted flat
SW15 1QG - 1,504,000
- Freehold Terrace property
SW15 1QG - 809,000
- Freehold Purpose built flat
SW15 1QG - 918,000
- Leasehold Flat/Maisonette
SW15 1QG - 1,479,000
- Freehold End terrace house
SW15 1QG - 778,000
- Leasehold Flat/Maisonette
SW15 1QG - 1,762,000
- Freehold Mid terrace house
SW15 1QG - 774,000
- Leasehold Purpose built flat
SW15 1QG - 813,000
- Leasehold Purpose built flat
SW15 1QG - 1,499,000
- Freehold Mid terrace house
SW15 1QG - 994,000
- Freehold Purpose built flat
SW15 1QG - 910,000
- Freehold Flat/Maisonette
SW15 1QG - 1,545,000
- Freehold Terrace property
SW15 1QG - 766,000
- Leasehold Purpose built flat
SW15 1QG - 787,000
- Leasehold Purpose built flat
SW15 1QG - 1,669,000
- Freehold Mid terrace house
