SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NW7 4LL' order by fulladdress
NW7 4LL - 590,000
- Freehold End terrace house
NW7 4LL - 736,000
- Freehold End terrace house
NW7 4LL - 694,000
- Freehold Semi-detached house
NW7 4LL - 738,000
- Freehold Semi-detached house
NW7 4LL - 748,000
- Freehold Semi-detached house
NW7 4LL - 954,000
- Freehold Semi-detached house
NW7 4LL - 998,000
- Freehold Semi-detached house
NW7 4LL - 853,000
- Freehold Semi-detached house
NW7 4LL - 959,000
- Freehold Semi-detached house
NW7 4LL - 1,408,000
- Freehold Semi-detached house
NW7 4LL - 796,000
- Semi-detached house
NW7 4LL - 905,000
- Freehold Semi-detached house
NW7 4LL - 806,000
- Freehold Semi-detached house
NW7 4LL - 980,000
- Freehold Semi-detached house
NW7 4LL - 901,000
- Freehold Semi-detached property
NW7 4LL - 875,000
- Freehold Semi-detached house
NW7 4LL - 911,000
- Freehold Semi-detached house
NW7 4LL - 871,000
- Freehold Semi-detached house
NW7 4LL - 854,000
- Freehold Semi-detached house
NW7 4LL - 739,000
- Freehold Semi-detached house
NW7 4LL - 702,000
- Freehold Semi-detached house
NW7 4LL - 718,000
- Freehold Semi-detached house
NW7 4LL - 647,000
- Freehold End terrace house
NW7 4LL - 639,000
- Freehold Terrace property
NW7 4LL - 630,000
- Freehold Mid terrace house
NW7 4LL - 626,000
- Freehold Mid terrace house
NW7 4LL - 683,000
- Freehold Semi-detached property