SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW7 2PR' order by fulladdress
SW7 2PR - 4,289,000
- Freehold Terraced
SW7 2PR - 3,734,000
- Freehold Mid terrace house
SW7 2PR - 4,054,000
- Freehold Terrace property
SW7 2PR - 3,776,000
- Freehold Mid terrace house
SW7 2PR - 4,128,000
- Freehold Mid terrace house
SW7 2PR - 3,460,000
- Mid terrace house
SW7 2PR - 4,389,000
- Freehold Mid terrace house
SW7 2PR - 3,941,000
- Freehold Mid terrace house
SW7 2PR - 3,490,000
- Freehold Terrace property
SW7 2PR - 4,247,000
- Freehold End terrace house
SW7 2PR - 5,966,000
- Freehold Terrace property
SW7 2PR - 3,613,000
- Freehold Mid terrace house
SW7 2PR - 4,280,000
- Freehold Terrace property
SW7 2PR - 4,116,000
- Freehold Mid terrace house
SW7 2PR - 4,786,000
- Freehold Mid terrace property
SW7 2PR - 3,437,000
- Freehold Mid terrace house
SW7 2PR - 4,867,000
- Freehold Mid terrace house
SW7 2PR - 3,479,000
- Freehold Mid terrace house
SW7 2PR - 3,834,000
- Freehold Mid terrace house
SW7 2PR - 2,306,000
- Leasehold Terrace property
