SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='SW3 4NG' order by fulladdress
SW3 4NG - 3,668,000
- Freehold End terrace house
SW3 4NG - 2,437,000
- Freehold Terraced
SW3 4NG - 3,956,000
- Freehold Mid terrace house
SW3 4NG - 4,277,000
- Freehold Terraced
SW3 4NG - 2,935,000
- Freehold Detached house
SW3 4NG - 2,732,000
- Freehold Mid terrace house
SW3 4NG - 2,673,000
- Freehold Mid terrace house
SW3 4NG - 1,386,000
- Freehold Converted flat
SW3 4NG - 2,670,000
- Freehold Mid terrace house
SW3 4NG - 4,083,000
- Freehold Terrace property
SW3 4NG - 4,390,000
- Freehold Mid terrace house
SW3 4NG - 3,793,000
- Mid terrace house
SW3 4NG - 3,503,000
- Freehold Mid terrace house
SW3 4NG - 3,652,000
- Mid terrace house
SW3 4NG - 3,738,000
- Freehold Terrace property
SW3 4NG - 4,233,000
- Freehold Terrace property
SW3 4NG - 4,000,000
- Freehold Mid terrace house
SW3 4NG - 3,271,000
- Freehold Terrace property
SW3 4NG - 2,816,000
- Freehold Mid terrace house
SW3 4NG - 3,832,000
- Mid terrace house
SW3 4NG - 3,997,000
- Freehold Mid terrace house
SW3 4NG - 3,513,000
- Freehold Mid terrace house
SW3 4NG - 4,882,000
- Freehold Terrace property
SW3 4NG - 3,719,000
- Freehold Mid terrace house
SW3 4NG - 3,097,000
- Freehold End terrace house
SW3 4NG - 3,605,000
- Freehold Mid terrace house
SW3 4NG - 3,712,000
- Freehold Terrace property
SW3 4NG - 3,810,000
- Mid terrace house
SW3 4NG - 3,287,000
- Mid terrace house
SW3 4NG - 3,163,000
- Freehold Terrace property
SW3 4NG - 3,876,000
- Freehold Mid terrace house
SW3 4NG - 3,962,000
- Freehold Mid terrace house
SW3 4NG - 3,496,000
- Mid terrace house
SW3 4NG - 3,425,000
- Freehold Terrace property
SW3 4NG - 2,728,000
- Freehold Mid terrace house
SW3 4NG - 2,679,000
- Freehold Mid terrace house
SW3 4NG - 2,922,000
- Freehold Terraced
SW3 4NG - 853,000
- Freehold Flat/Maisonette
SW3 4NG - 3,570,000
- Freehold Mid terrace house
SW3 4NG - 3,487,000
- Freehold Terrace property
SW3 4NG - 3,838,000
- Freehold Mid terrace house
SW3 4NG - 3,107,000
- Freehold Terrace property