SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='LU4 0YR' order by fulladdress
LU4 0YR - 259,000
- Freehold End terrace house
LU4 0YR - 297,000
- Freehold End terrace house
LU4 0YR - 276,000
- Freehold Mid terrace house
LU4 0YR - 257,000
- Freehold Mid terrace house
LU4 0YR - 271,000
- Freehold Mid terrace house
LU4 0YR - 305,000
- Freehold End terrace house
LU4 0YR - 260,000
- Freehold Mid terrace house
LU4 0YR - 287,000
- Freehold Mid terrace house
LU4 0YR - 333,000
- Freehold Semi-detached house
LU4 0YR - 312,000
- Freehold End terrace house
LU4 0YR - 258,000
- Freehold Terrace property
LU4 0YR - 307,000
- Freehold End terrace house
LU4 0YR - 265,000
- Freehold Mid terrace house
LU4 0YR - 263,000
- Freehold Mid terrace house
LU4 0YR - 271,000
- Freehold Mid terrace house
LU4 0YR - 298,000
- Freehold Mid terrace house
LU4 0YR - 251,000
- Freehold Mid terrace house
LU4 0YR - 303,000
- Freehold End terrace house
LU4 0YR - 305,000
- Freehold End terrace house
LU4 0YR - 271,000
- Freehold Mid terrace house
LU4 0YR - 266,000
- Freehold Mid terrace house
LU4 0YR - 278,000
- Freehold Mid terrace house
LU4 0YR - 268,000
- Freehold Mid terrace house
LU4 0YR - 309,000
- Freehold End terrace house
LU4 0YR - 226,000
- Freehold End terrace house
LU4 0YR - 199,000
- Freehold Detached house
LU4 0YR - 221,000
- Freehold End terrace house
LU4 0YR - 226,000
- Freehold End terrace house
LU4 0YR - 223,000
- Freehold End terrace house
LU4 0YR - 220,000
- Freehold Mid terrace house
LU4 0YR - 226,000
- Freehold Terrace property
LU4 0YR - 222,000
- Freehold Mid terrace house
LU4 0YR - 263,000
- Freehold Terrace property
LU4 0YR - 200,000
- Freehold End terrace house
LU4 0YR - 296,000
- Freehold Detached house
LU4 0YR - 227,000
- Freehold End terrace house
LU4 0YR - 445,000
- Freehold Detached property
LU4 0YR - 405,000
- Freehold Detached house
LU4 0YR - 335,000
- Freehold Detached house
LU4 0YR - 332,000
- Freehold Detached house
LU4 0YR - 347,000
- Freehold Detached house
LU4 0YR - 271,000
- Freehold Semi-detached house
LU4 0YR - 465,000
- Freehold Detached house
LU4 0YR - 412,000
- Leasehold Detached house
LU4 0YR - 387,000
- Freehold Detached house
LU4 0YR - 347,000
- Freehold Detached house
LU4 0YR - 343,000
- Freehold Detached house
LU4 0YR - 383,000
- Freehold Detached house
LU4 0YR - 332,000
- Freehold Detached house
LU4 0YR - 398,000
- Freehold Detached house
LU4 0YR - 332,000
- Freehold Detached property
