SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NG12 2NW' order by fulladdress
NG12 2NW - 886,000
- Freehold Detached house
NG12 2NW - 791,000
- Freehold Detached house
NG12 2NW - 758,000
- Freehold Mid terrace house
NG12 2NW - 874,000
- Freehold Detached house
NG12 2NW - 846,000
- Freehold Detached property
NG12 2NW - 851,000
- Freehold Detached house
NG12 2NW - 812,000
- Freehold Detached house
NG12 2NW - 884,000
- Freehold Detached house
NG12 2NW - 800,000
- Freehold Detached house
NG12 2NW - 735,000
- Freehold Detached house
NG12 2NW - 837,000
- Freehold Detached property
NG12 2NW - 781,000
- Freehold Detached house
NG12 2NW - 838,000
- Freehold Detached property
NG12 2NW - 942,000
- Freehold Detached property
NG12 2NW - 898,000
- Freehold Detached house
NG12 2NW - 949,000
- Freehold Detached house
NG12 2NW - 835,000
- Freehold Detached house
NG12 2NW - 1,407,000
- Freehold Semi-detached house
