SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='NN4 6BY' order by fulladdress
NN4 6BY - 517,000
- Freehold Detached bungalow
NN4 6BY - 524,000
- Freehold Detached bungalow
NN4 6BY - 582,000
- Freehold Semi-detached property
NN4 6BY - 1,602,000
- Freehold Detached house
NN4 6BY - 927,000
- Freehold Semi-detached house
NN4 6BY - 539,000
- Freehold Detached house
NN4 6BY - 567,000
- Freehold Semi-detached house
NN4 6BY - 464,000
- Freehold Detached house
NN4 6BY - 933,000
- Freehold Mid terrace house
NN4 6BY - 332,000
- Freehold Detached property
NN4 6BY - 474,000
- Freehold Detached bungalow
NN4 6BY - 446,000
- Freehold Semi-detached property
NN4 6BY - 484,000
- Freehold Semi-detached property
NN4 6BY - 744,000
- Freehold Semi-detached house
NN4 6BY - 643,000
- Semi-detached house
NN4 6BY - 352,000
- Freehold Detached house
NN4 6BY - 795,000
- Freehold Detached house
NN4 6BY - 998,000
- Freehold End terrace house
NN4 6BY - 393,000
- Freehold Detached house
NN4 6BY - 572,000
- Freehold Detached bungalow
