SELECT Distinct [UPRN],[postcode] ,[fulladdress] ,[propertyIndicators] ,[EstimatedSalesLow] ,[EstimatedSalesHigh] ,[EstimatedRentalsLow] ,[EstimatedRentalsHigh] ,[EstimatedSalesPrice] ,[EstimatedRentalsPrice] FROM [Zoopla_Estimates_Export].[dbo].[zoopla_estimates_extraction_2024_01] where postcode='HR2 7ZP' order by fulladdress
HR2 7ZP - 352,000
- Freehold Detached property
HR2 7ZP - 411,000
- Freehold Detached property
HR2 7ZP - 489,000
- Freehold Detached property
HR2 7ZP - 435,000
- Freehold Detached house
HR2 7ZP - 469,000
- Freehold Detached property
HR2 7ZP - 454,000
- Freehold Detached property
HR2 7ZP - 508,000
- Freehold Detached house
HR2 7ZP - 406,000
- Freehold Detached property
HR2 7ZP - 404,000
- Freehold Detached property
HR2 7ZP - 385,000
- Freehold Detached house
HR2 7ZP - 260,000
- Freehold Semi-detached house
HR2 7ZP - 473,000
- Freehold Detached house
HR2 7ZP - 448,000
- Freehold Detached property
HR2 7ZP - 407,000
- Freehold Detached property
HR2 7ZP - 515,000
- Freehold Detached house
HR2 7ZP - 406,000
- Freehold Detached house
HR2 7ZP - 455,000
- Freehold Detached house
HR2 7ZP - 461,000
- Freehold Detached house
HR2 7ZP - 408,000
- Freehold Detached house
HR2 7ZP - 428,000
- Freehold Detached house
HR2 7ZP - 376,000
- Freehold Detached house
HR2 7ZP - 308,000
- Freehold Semi-detached house
HR2 7ZP - 263,000
- Freehold Semi-detached house
HR2 7ZP - 265,000
- Freehold Semi-detached house
HR2 7ZP - 253,000
- Freehold Semi-detached house
HR2 7ZP - 260,000
- Freehold Semi-detached house
HR2 7ZP - 328,000
- Freehold Detached house
HR2 7ZP - 375,000
- Freehold Detached property
HR2 7ZP - 359,000
- Freehold Detached house
HR2 7ZP - 424,000
- Freehold Detached property
HR2 7ZP - 424,000
- Freehold Detached house
HR2 7ZP - 422,000
- Freehold Detached property
HR2 7ZP - 404,000
- Freehold Detached house
HR2 7ZP - 405,000
- Freehold Detached house
HR2 7ZP - 398,000
- Freehold Detached house
HR2 7ZP - 260,000
- Freehold Semi-detached house
HR2 7ZP - 399,000
- Freehold Detached house
HR2 7ZP - 409,000
- Freehold Detached property
HR2 7ZP - 302,000
- Freehold Detached house
HR2 7ZP - 335,000
- Freehold Detached house
HR2 7ZP - 334,000
- Freehold Detached house
HR2 7ZP - 395,000
- Freehold Detached property
HR2 7ZP - 414,000
- Freehold Detached property
HR2 7ZP - 389,000
- Freehold Detached house
HR2 7ZP - 409,000
- Freehold Detached property
HR2 7ZP - 346,000
- Freehold Detached house
HR2 7ZP - 370,000
- Freehold Detached house
HR2 7ZP - 423,000
- Freehold Detached house
HR2 7ZP - 395,000
- Freehold Detached house
HR2 7ZP - 444,000
- Freehold Detached property
HR2 7ZP - 341,000
- Freehold Detached house
HR2 7ZP - 345,000
- Freehold Detached house
HR2 7ZP - 432,000
- Freehold Detached house
HR2 7ZP - 341,000
- Freehold Detached house
HR2 7ZP - 409,000
- Freehold Detached house
HR2 7ZP - 405,000
- Freehold Detached house
HR2 7ZP - 402,000
- Freehold Detached house
HR2 7ZP - 371,000
- Freehold Detached house
HR2 7ZP - 416,000
- Freehold Detached house
HR2 7ZP - 414,000
- Freehold Detached property
HR2 7ZP - 436,000
- Freehold Detached house
HR2 7ZP - 418,000
- Freehold Detached house
HR2 7ZP - 333,000
- Freehold Detached house
HR2 7ZP - 334,000
- Freehold Detached house
HR2 7ZP - 332,000
- Freehold Detached house
HR2 7ZP - 343,000
- Freehold Detached house
HR2 7ZP - 419,000
- Freehold Detached property
HR2 7ZP - 483,000
- Freehold Detached property
HR2 7ZP - 401,000
- Freehold Detached house
