SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NG8 1FN' order by fulladdress
NG8 1FN - 515,000
- Freehold Detached property
NG8 1FN - 493,000
- Freehold Detached house
NG8 1FN - 512,000
- Freehold Detached house
NG8 1FN - 495,000
- Freehold Detached house
NG8 1FN - 608,000
- Freehold Detached house
NG8 1FN - 559,000
- Freehold Detached house
NG8 1FN - 483,000
- Freehold Detached house
NG8 1FN - 513,000
- Freehold Detached property
NG8 1FN - 610,000
- Freehold Detached house
NG8 1FN - 512,000
- Freehold Detached house
NG8 1FN - 727,000
- Freehold Detached house
NG8 1FN - 625,000
- Freehold Detached house
NG8 1FN - 652,000
- Freehold Detached house
NG8 1FN - 490,000
- Freehold Semi-detached property
NG8 1FN - 667,000
- Freehold Detached house
NG8 1FN - 538,000
- Freehold Detached house
NG8 1FN - 658,000
- Freehold Detached house
NG8 1FN - 623,000
- Freehold Detached property
NG8 1FN - 672,000
- Freehold Detached house
NG8 1FN - 711,000
- Freehold Detached house
NG8 1FN - 616,000
- Freehold Detached house
NG8 1FN - 664,000
- Freehold Detached house
NG8 1FN - 700,000
- Freehold Detached house
NG8 1FN - 688,000
- Freehold Detached house
NG8 1FN - 810,000
- Freehold Detached house
NG8 1FN - 687,000
- Freehold Detached house
NG8 1FN - 701,000
- Freehold Detached property
NG8 1FN - 625,000
- Freehold Detached house
NG8 1FN - 674,000
- Freehold Detached house
NG8 1FN - 677,000
- Freehold Detached house
NG8 1FN - 695,000
- Freehold Detached house
NG8 1FN - 681,000
- Freehold Detached house
NG8 1FN - 696,000
- Freehold Detached house
NG8 1FN - 691,000
- Freehold Detached property
NG8 1FN - 703,000
- Freehold Detached property
