SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='FK2 0AP' order by fulladdress
FK2 0AP - 220,000
- Feudal Bungalow property
FK2 0AP - 196,000
- Feudal Semi-detached house
FK2 0AP - 337,000
- Feudal Detached house
FK2 0AP - 189,000
- Feudal Semi-detached house
FK2 0AP - 185,000
- Freehold Semi-detached house
FK2 0AP - 229,000
- Freehold Detached house
FK2 0AP - 174,000
- Freehold Semi-detached house
FK2 0AP - 170,000
- Feudal Semi-detached house
FK2 0AP - 184,000
- Feudal Semi-detached house
FK2 0AP - 160,000
- Feudal Semi-detached house
FK2 0AP - 271,000
- Freehold Detached bungalow
FK2 0AP - 166,000
- Semi-detached house
FK2 0AP - 170,000
- Feudal Semi-detached house
FK2 0AP - 169,000
- Freehold Semi-detached house
FK2 0AP - 192,000
- Feudal Detached bungalow
FK2 0AP - 187,000
- Freehold Detached house
FK2 0AP - 182,000
- Feudal Semi-detached bungalow
FK2 0AP - 225,000
- Feudal Detached property
FK2 0AP - 266,000
- Feudal Detached house
FK2 0AP - 218,000
- Feudal Detached bungalow
FK2 0AP - 189,000
- Feudal Semi-detached house
FK2 0AP - 186,000
- Feudal Semi-detached house
FK2 0AP - 266,000
- Feudal Detached house
FK2 0AP - 270,000
- Feudal Detached house
FK2 0AP - 259,000
- Feudal Detached house
FK2 0AP - 237,000
- Freehold Detached house
FK2 0AP - 266,000
- Feudal Detached house
FK2 0AP - 266,000
- Feudal Detached house
FK2 0AP - 188,000
- Feudal Semi-detached house
FK2 0AP - 266,000
- Freehold Detached house
FK2 0AP - 228,000
- Feudal Detached bungalow
FK2 0AP - 235,000
- Feudal Detached property
FK2 0AP - 231,000
- Feudal Detached house
FK2 0AP - 166,000
- Freehold Semi-detached bungalow
FK2 0AP - 154,000
- Semi-detached property
FK2 0AP - 181,000
- Feudal Semi-detached house
FK2 0AP - 163,000
- Semi-detached property
FK2 0AP - 165,000
- Feudal Semi-detached house
FK2 0AP - 250,000
- Feudal Detached house