!

Expanding

Many properties have additional data sets, in addition to the regular fields. For example, a property may have a expansion set, which contains information about the schools in the area.

To retrieve this data, you can use the expand query parameter. For example, to retrieve the school data, you would add the following to the request URL: ?expand=schools

Multiple expansions can be specified by seperating them with a comma. For example, to retrieve the school and crime data, you would add the following to the request URL: ?expand=schools,crime

There are lots of other expansion sets, including photos, videos, and more. To see a full list of available expansions, visit the fields & expansions page.

It's important to note that not all properties have all expansion sets. If you request an expansion set that is not available for a property, the API will return an empty array for that expansion set.

Expansion set pricing also varies, and the pricing is based on the cost of the expansion set, multiplied by the number of rows returned.

Programming language

Select the programming language you want to display the code examples in.

Expanding a property's assessment data

Note that property_id and address are expanded by default by the properties endpoint.

Request
Shell session
curl -X GET "https://api.houski.ca/properties?api_key=YOUR_API_KEY&city=calgary&country_abbreviation=ca&expand=assessments&province_abbreviation=ab"
TypeScript code
const houski_properties_data = async (): Promise<PropertiesResponse> => {

    // You must copy the PropertiesResponse type declarations from the 
    // Houski API documentation to strongly type the response

    const url = new URL('https://api.houski.ca/properties');
    url.searchParams.set('api_key', 'YOUR_API_KEY');
    url.searchParams.set('city', 'calgary');
    url.searchParams.set('country_abbreviation', 'ca');
    url.searchParams.set('expand', 'assessments');
    url.searchParams.set('province_abbreviation', 'ab');

    const response = await fetch(url);
    const data = await response.json();

    return data;
}

(async () => {
let data: PropertiesResponse = await houski_properties_data();

// Log the response
console.log(data);
})();
Response
JSON
{
  "cache_hit": false,
  "cost_cents": 2.2899999618530273,
  "data": [
    {
      "address": "26 Evansview Court NW",
      "assessments": [
        {
          "expand_assessment_value": 604000,
          "expand_assessment_year": 2015,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 587000,
          "expand_assessment_year": 2016,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 564500,
          "expand_assessment_year": 2017,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 586000,
          "expand_assessment_year": 2018,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 578000,
          "expand_assessment_year": 2019,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 546500,
          "expand_assessment_year": 2020,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 538500,
          "expand_assessment_year": 2021,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 592500,
          "expand_assessment_year": 2022,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 704500,
          "expand_assessment_year": 2023,
          "property_id": "3aa3842caaeed4b6"
        },
        {
          "expand_assessment_value": 757500,
          "expand_assessment_year": 2024,
          "property_id": "3aa3842caaeed4b6"
        }
      ],
      "property_id": "3aa3842caaeed4b6"
    },
    {
      "address": "309 Tarington Close NE",
      "assessments": [
        {
          "expand_assessment_value": 173000,
          "expand_assessment_year": 2005,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 180500,
          "expand_assessment_year": 2006,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 269000,
          "expand_assessment_year": 2007,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 368500,
          "expand_assessment_year": 2008,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 346500,
          "expand_assessment_year": 2009,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 284000,
          "expand_assessment_year": 2010,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 309000,
          "expand_assessment_year": 2011,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 287000,
          "expand_assessment_year": 2012,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 324500,
          "expand_assessment_year": 2013,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 391500,
          "expand_assessment_year": 2015,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 384500,
          "expand_assessment_year": 2016,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 378500,
          "expand_assessment_year": 2017,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 385000,
          "expand_assessment_year": 2018,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 378000,
          "expand_assessment_year": 2019,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 370500,
          "expand_assessment_year": 2020,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 355000,
          "expand_assessment_year": 2021,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 392500,
          "expand_assessment_year": 2022,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 446000,
          "expand_assessment_year": 2023,
          "property_id": "61caf4b07f06fcf6"
        },
        {
          "expand_assessment_value": 503000,
          "expand_assessment_year": 2024,
          "property_id": "61caf4b07f06fcf6"
        }
      ],
      "property_id": "61caf4b07f06fcf6"
    },
    {
      "address": "90 2720 Rundleson Road NE",
      "assessments": [
        {
          "expand_assessment_value": 115000,
          "expand_assessment_year": 2005,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 112000,
          "expand_assessment_year": 2006,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 179500,
          "expand_assessment_year": 2007,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 266000,
          "expand_assessment_year": 2008,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 247500,
          "expand_assessment_year": 2009,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 202500,
          "expand_assessment_year": 2010,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 202500,
          "expand_assessment_year": 2011,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 177500,
          "expand_assessment_year": 2012,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 184000,
          "expand_assessment_year": 2013,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 208500,
          "expand_assessment_year": 2014,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 231500,
          "expand_assessment_year": 2015,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 228500,
          "expand_assessment_year": 2016,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 214500,
          "expand_assessment_year": 2017,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 216000,
          "expand_assessment_year": 2018,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 205500,
          "expand_assessment_year": 2019,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 204500,
          "expand_assessment_year": 2020,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 197500,
          "expand_assessment_year": 2021,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 204500,
          "expand_assessment_year": 2022,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 228000,
          "expand_assessment_year": 2023,
          "property_id": "1337ef6c8a910b3"
        },
        {
          "expand_assessment_value": 252500,
          "expand_assessment_year": 2024,
          "property_id": "1337ef6c8a910b3"
        }
      ],
      "property_id": "1337ef6c8a910b3"
    },
    {
      "address": "82 Cramond Circle SE",
      "assessments": [
        {
          "expand_assessment_value": 189000,
          "expand_assessment_year": 2005,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 205500,
          "expand_assessment_year": 2006,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 277000,
          "expand_assessment_year": 2007,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 394000,
          "expand_assessment_year": 2008,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 371500,
          "expand_assessment_year": 2009,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 345500,
          "expand_assessment_year": 2010,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 373000,
          "expand_assessment_year": 2011,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 363000,
          "expand_assessment_year": 2012,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 366000,
          "expand_assessment_year": 2013,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 384000,
          "expand_assessment_year": 2014,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 423000,
          "expand_assessment_year": 2015,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 420500,
          "expand_assessment_year": 2016,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 403500,
          "expand_assessment_year": 2017,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 413000,
          "expand_assessment_year": 2018,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 414500,
          "expand_assessment_year": 2019,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 390500,
          "expand_assessment_year": 2020,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 392000,
          "expand_assessment_year": 2021,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 431500,
          "expand_assessment_year": 2022,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 490000,
          "expand_assessment_year": 2023,
          "property_id": "13e1a7f1a9285f91"
        },
        {
          "expand_assessment_value": 530000,
          "expand_assessment_year": 2024,
          "property_id": "13e1a7f1a9285f91"
        }
      ],
      "property_id": "13e1a7f1a9285f91"
    },
    {
      "address": "4632 20 Avenue NW",
      "assessments": [
        {
          "expand_assessment_value": 205000,
          "expand_assessment_year": 2005,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 232500,
          "expand_assessment_year": 2006,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 364500,
          "expand_assessment_year": 2007,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 395000,
          "expand_assessment_year": 2008,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 398500,
          "expand_assessment_year": 2009,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 344000,
          "expand_assessment_year": 2010,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 354000,
          "expand_assessment_year": 2011,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 349000,
          "expand_assessment_year": 2012,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 354500,
          "expand_assessment_year": 2013,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 395500,
          "expand_assessment_year": 2014,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 439500,
          "expand_assessment_year": 2015,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 443000,
          "expand_assessment_year": 2016,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 417500,
          "expand_assessment_year": 2017,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 452500,
          "expand_assessment_year": 2018,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 453000,
          "expand_assessment_year": 2019,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 406000,
          "expand_assessment_year": 2020,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 405000,
          "expand_assessment_year": 2021,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 399000,
          "expand_assessment_year": 2022,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 452000,
          "expand_assessment_year": 2023,
          "property_id": "a864cb979d86a032"
        },
        {
          "expand_assessment_value": 513500,
          "expand_assessment_year": 2024,
          "property_id": "a864cb979d86a032"
        }
      ],
      "property_id": "a864cb979d86a032"
    },
    {
      "address": "90 Woodmeadow Close SW",
      "assessments": [
        {
          "expand_assessment_value": 240500,
          "expand_assessment_year": 2005,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 251500,
          "expand_assessment_year": 2006,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 517500,
          "expand_assessment_year": 2007,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 517500,
          "expand_assessment_year": 2008,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 437000,
          "expand_assessment_year": 2009,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 364000,
          "expand_assessment_year": 2010,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 394000,
          "expand_assessment_year": 2011,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 378000,
          "expand_assessment_year": 2012,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 343000,
          "expand_assessment_year": 2013,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 404000,
          "expand_assessment_year": 2014,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 452000,
          "expand_assessment_year": 2015,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 412000,
          "expand_assessment_year": 2016,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 406500,
          "expand_assessment_year": 2017,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 403500,
          "expand_assessment_year": 2018,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 389500,
          "expand_assessment_year": 2019,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 368500,
          "expand_assessment_year": 2020,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 364000,
          "expand_assessment_year": 2021,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 370500,
          "expand_assessment_year": 2022,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 394000,
          "expand_assessment_year": 2023,
          "property_id": "7d81954d14a10362"
        },
        {
          "expand_assessment_value": 412500,
          "expand_assessment_year": 2024,
          "property_id": "7d81954d14a10362"
        }
      ],
      "property_id": "7d81954d14a10362"
    }
  ],
  "error": "",
  "pagination": {
    "current_page": 1,
    "has_next_page": true,
    "has_previous_page": false,
    "page_total": 86853
  },
  "price_quote": false,
  "result_total": 521118,
  "time_ms": 74,
  "ui_info": {
    "city": "Calgary",
    "city_id": "6ec95b53075d062c",
    "city_link": "ca/ab/calgary",
    "city_slug": "calgary",
    "country": "Canada",
    "country_abbreviation": "CA",
    "country_abbreviation_id": "9ace2b6431b7f1be",
    "country_abbreviation_link": "ca",
    "country_slug": "canada",
    "province": "Alberta",
    "province_abbreviation": "AB",
    "province_abbreviation_id": "aae1f05a0f89d2c7",
    "province_abbreviation_link": "ca/ab",
    "province_slug": "alberta"
  }
}