GSRAW

List of custom GSRAW API services aimed at exchanging information securely over the Internet.
They are developed so that it is possible to add, modify or eliminate more or less input parameters depending on the client's needs.
There are also different answers, depending on the output format, for instance: json, csv, ndjson...

GETindicators

https://{{id}}.execute-api.eu-west-1.amazonaws.com/pro/v1/indicators?lat=40.437550560499695&lon=-3.7115688065998644&level=15&indicators=re_o_20, re_o_21&operations=2&propertytype=1&segments=0

This endpoint returns real estate indicators based on geographical and market information. The kpis are differents area: financial, demography, population

The Request is segmented:

Date : Year and quarter

Administrative levels:
- Country
- State
- Province
- City
- District
- Neighborhood

Types of properties: flat, house,...

Area: <70m2, <100m2, >250m2...

Number of rooms:1,2,3...

HEADERS

x-api-key

PARAMS

lat

40.437550560499695

coordenate y

lon

-3.7115688065998644

coordenate x

level

administrative boundary 15 => neighborhood / 14 => district / 13 => municipality / 12 => province /

indicators

re_o_20, re_o_21

re_o_20 => Average Price per Asset (€) / re_o_21 =>Average sqm Price (€/sqm) / re_o_25 => Stock of properties / re_o_26 => Absorption Rate / re_o_28 => Time to market (weeks) / re_o_29 => Gross margin rent / re_o_30 => Average sqm per asset / re_o_31 => Quarterly price variation / re_o_37 => Interannual price variation / re_o_58 => Gross margin sale / re_o_61 => Min Average Price / re_o_62 => Max Average Price / re_o_65 => Number of properties sold or rented / re_o_66 => Negotiation factor

operations

1 => Rent / 2 => Sold

propertytype

1 => flat / 2 => house (*Optional)

segments

0 => all segments / 1 => flat / 2 => house (*Optional)

Example Request

curl

curl --location -g 'https://{{id}}.execute-api.eu-west-1.amazonaws.com/pro/v1/indicators?lat=40.437550560499695&lon=-3.7115688065998644&level=15&indicators=re_o_20%2C%20re_o_21&operations=2&propertytype=1&segments=0' \
--header 'x-api-key: {{api-key}}'

200 OK

Example Response

json

{
  "id": 25625,
  "level": 15,
  "period": "2023Q3",
  "operation": 2,
  "segment": 0,
  "re_o_20": 750000,
  "re_o_21": 5200
}

Date

Fri, 10 Nov 2023 08:53:31 GMT

Content-Type

application/x-ndjson

Content-Length

110

Connection

keep-alive

x-amzn-RequestId

dde3d776-89fc-4f7d-8bae-04c1eb3edc5c

Access-Control-Allow-Origin

Content-Encoding

gzip

Strict-Transport-Security

max-age=63072000

X-Tb-R

92357de8

x-amzn-Remapped-Content-Length

110

X-Frame-Options

sameorigin

Access-Control-Allow-Headers

Authorization, Content-Type, X-Requested-With

x-amzn-Remapped-Connection

keep-alive

X-Tb-Statistics

{"elapsed":0.06061959266662598,"db":0.04756,"fetch":0.04850149154663086,"threads":None}

X-Request-Id

803febcd-1182-4008-877f-7b8618ba7ba9

x-amz-apigw-id

OLJd3GNdjoEEiVg=

x-amzn-Remapped-Server

nginx

Etag

"ed636c915e2cc11a4909c4ea9ddd07d0c2d836f1"

Access-Control-Allow-Methods

GET, POST, PUT, DELETE, OPTIONS

X-Db-Backend

backend_eu_public_a_2

Access-Control-Max-Age

86400

x-amzn-Remapped-Date

Fri, 10 Nov 2023 08:53:31 GMT

X-Db-Statistics

{"read_rows":"45059","read_bytes":"31612346","written_rows":"0","written_bytes":"0","total_rows_to_read":"45056","result_rows":"1","result_bytes":"36928"}

GETAVM 1.0

https://{{id}}.execute-api.eu-west-1.amazonaws.com/pro/v1/avm?operation=2&latitude=40.4089626&longitude=-3.6136012&size=65&propertytype=4&rooms=3&bathrooms=1&floor=2&status=1&elevator=1&terrace=1&garage=1&storage=1&pool=1&ac=1

This endpoint creates an valuation of asset with Automated Valuation Model.

AVM combines a variety of data on price trends, property characteristics, and local market information.

HEADERS

x-api-key

PARAMS

operation

latitude

40.4089626

longitude

-3.6136012

size

propertytype

rooms

bathrooms

floor

status

elevator

terrace

garage

storage

pool

Example Request

curl

curl --location 'https://1pm3nkb5k9.execute-api.eu-west-1.amazonaws.com/pro/v1/avm?operation=2&latitude=40.4089626&longitude=-3.6136012&size=65&propertytype=1&rooms=3&bathrooms=1' \
--header 'x-api-key: {{propper_aws}}'

200 OK

Example Response

json

{
  "avm": 132535,
  "accuracy": 4
}

Date

Fri, 10 Nov 2023 08:56:18 GMT

Content-Type

application/x-ndjson

Content-Length

Connection

keep-alive

x-amzn-RequestId

e27227c7-adb9-4f8d-a7d4-5b941824f10a

Access-Control-Allow-Origin

Content-Encoding

gzip

Strict-Transport-Security

max-age=63072000

X-Tb-R

92357de8

x-amzn-Remapped-Content-Length

X-Frame-Options

sameorigin

Access-Control-Allow-Headers

Authorization, Content-Type, X-Requested-With

x-amzn-Remapped-Connection

keep-alive

X-Tb-Statistics

{"elapsed":0.532393217086792,"db":0.494269,"fetch":0.4947640895843506,"threads":None}

X-Request-Id

1203f86a-5581-4c0e-b78f-322f567d0898

x-amz-apigw-id

OLJ30FG_joEELZg=

x-amzn-Remapped-Server

nginx

Etag

"34aafb1ed5c06a6e6244e837cf11062cf291e4e0"

Access-Control-Allow-Methods

GET, POST, PUT, DELETE, OPTIONS

X-Db-Backend

backend_eu_public_a_2

Access-Control-Max-Age

86400

x-amzn-Remapped-Date

Fri, 10 Nov 2023 08:56:18 GMT

X-Db-Statistics

{"read_rows":"3854258","read_bytes":"161752239","written_rows":"0","written_bytes":"0","total_rows_to_read":"3854258","result_rows":"1","result_bytes":"4192"}

GETAVM 2.0

https://avm.gsraw.io/avm_comparables?pt=4&geo=40.4089668%2C%20-3.6116914&area=66&room=3&bath=1&floors=4&conservation=1&elevator=1&storage=1&garage=1&zones=1&pool=1&year=1960

HEADERS

Authorization

PARAMS

indicates the asset property type {4 = Pisos, 6 = Áticos, 10 = Apartamento, 12 = Casa o Chalet independiente, 13 = Dúplex, 16 = Chalet pareado, 17 = Estudio, 18 = Chalet adosado}.

geo

40.4089668%2C%20-3.6116914

indicates the lat and longitude (e.g 32.1,2.4)

area

indicates the house size (meters)

room

indicates the number of rooms

bath

indicates the number of bathrooms

floors

indicates the number of floors

conservation

{1 = En buen estado, 2 = A reformar, 3 = A estrenar}

elevator

indicates if the house has elevator or not (capital letters. e.g TRUE). Default is FALSE

storage

indicates if the house has storage or not (capital letters. e.g TRUE). Default is FALSE.

garage

indicates if the house has garage or not (capital letters. e.g TRUE). Default is FALSE.

zones

indicates if the house has common zones or not (capital letters. e.g TRUE). Default is FALSE.

pool

indicates if the house has pool or not (capital letters. e.g TRUE). Default is FALSE.

year

1960

indicates the year of construction

Example Request

curl

curl --location 'https://avm.gsraw.io/avm_comparables?pt=4&geo=40.4089668%252C%2520-3.6116914&area=66&room=3&bath=1&floors=4&conservation=1&elevator=1&storage=1&garage=1&zones=1&pool=1&year=1960' \
--header 'x-api-key: {token}'

200 OK

Example Response

json

[
  {
    "origin_id": "ZOVC4640072037",
    "lat": 40.409,
    "lon": -3.6117,
    "operation_type_id": 2,
    "area": 66,
    "n_rooms": 3,
    "n_baths": 1,
    "n_floor": 4,
    "conservation_id": 1,
    "construction_year": 1960,
    "avm_closing_adjusted": 129812,
    "n_comparables": 58,
    "avg_score": 0.7764,
    "avg_asking_to_close_pct": -0.1448,
    "avg_distance": 0.1386,
    "asking_avm_adjusted": 151800,
    "interval": 4142,
    "lower_value": 125670,
    "upper_value": 133954,
    "qa_score": 4
  }
]

Date

Mon, 23 Oct 2023 12:46:27 GMT

Content-Type

application/json

Transfer-Encoding

chunked

Connection

keep-alive

Content-Encoding

gzip

GETcomparables

https://{{id}}.execute-api.eu-west-1.amazonaws.com/pro/v1/comparables?operation=2&latitude=40.3912941&longitude=-3.7115688065998644&radio=4000&nresults=10&size=100&propertytype=1&rooms=3&bathrooms=2

This endpoint returns those assets with defined characteristics and that are within a radius established through coordinates.

The system finds similar assets and it lists all important information about the comparables.

HEADERS

x-api-key

PARAMS

operation

1 => Rent / 2 => Sold

latitude

40.3912941

coordenate y

longitude

-3.7115688065998644

coordenate x

radio

4000

radius of meters

nresults

count of results

size

100

threshold +/- 20% area (*Optional)

propertytype

(*Optional) 1 => flat / 2 => house

rooms

threshold +/- 20% rooms (*Optional)

bathrooms

threshold +/- 20% bathrooms (*Optional)

Example Request

curl

curl --location 'https://1w81ht02r1.execute-api.eu-west-1.amazonaws.com/pro/v1/comparables?operation=2&latitude=40.3912941&longitude=-3.7115688065998644&radio=4000&nresults=10&size=100&propertytype=1&rooms=3&bathrooms=2' \
--header 'x-api-key: {{gesvalt_aws}}'

200 OK

Example Response

json

{"origin_id":98822324,"boundary_id":70408,"operation_type_id":2,"lat":40.391422,"lon":-3.7118788,"local_price":335000,"area":120,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-01-18","n_rooms":3,"n_baths":2,"n_floor":3,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"","has_terrace":"","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/98822324","year_of_construction":1972,"full_address":"Calle del Marqués de Jura Real","closing_local_price":324823,"is_active":0,"distance":30}
{"origin_id":101497581,"boundary_id":70402,"operation_type_id":2,"lat":40.392265,"lon":-3.7128708,"local_price":239000,"area":80,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-06-21","n_rooms":3,"n_baths":2,"n_floor":3,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"TRUE","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"TRUE","has_elevator":"FALSE","url":"https:\/\/www.idealista.com\/inmueble\/101497581","year_of_construction":null,"full_address":"Calle Baleares  47","closing_local_price":231739,"is_active":0,"distance":155}
{"origin_id":101535944,"boundary_id":70399,"operation_type_id":2,"lat":40.39244,"lon":-3.7099946,"local_price":269000,"area":92,"usage_id":1,"build_status_id":2,"conservation_id":2,"property_type_id":4,"last_appearance":"2023-07-12","n_rooms":3,"n_baths":2,"n_floor":3,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/101535944","year_of_construction":null,"full_address":"Calle del Marqués de Jura Real","closing_local_price":260828,"is_active":0,"distance":185}
{"origin_id":102036844,"boundary_id":70399,"operation_type_id":2,"lat":40.392612,"lon":-3.7099216,"local_price":255000,"area":92,"usage_id":1,"build_status_id":2,"conservation_id":2,"property_type_id":4,"last_appearance":"2023-07-19","n_rooms":3,"n_baths":2,"n_floor":3,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/102036844","year_of_construction":null,"full_address":"Calle del Marqués de Jura Real","closing_local_price":247253,"is_active":0,"distance":203}
{"origin_id":101156533,"boundary_id":70402,"operation_type_id":2,"lat":40.393154,"lon":-3.712458,"local_price":265000,"area":100,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-05-24","n_rooms":3,"n_baths":2,"n_floor":3,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/101156533","year_of_construction":null,"full_address":"","closing_local_price":256949,"is_active":0,"distance":220}
{"origin_id":100725560,"boundary_id":70411,"operation_type_id":2,"lat":40.392223,"lon":-3.709053,"local_price":316000,"area":100,"usage_id":1,"build_status_id":2,"conservation_id":2,"property_type_id":4,"last_appearance":"2023-04-26","n_rooms":3,"n_baths":2,"n_floor":3,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"TRUE","has_pool":"FALSE","has_air_conditioner":"TRUE","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/100725560","year_of_construction":1985,"full_address":"","closing_local_price":306400,"is_active":0,"distance":237}
{"origin_id":101306199,"boundary_id":70399,"operation_type_id":2,"lat":40.39271,"lon":-3.7094655,"local_price":330000,"area":102,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-10-25","n_rooms":3,"n_baths":2,"n_floor":4,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"TRUE","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/101306199","year_of_construction":1963,"full_address":"Paseo de Santa María de la Cabeza","closing_local_price":319975,"is_active":1,"distance":238}
{"origin_id":100631792,"boundary_id":70405,"operation_type_id":2,"lat":40.393044,"lon":-3.7098823,"local_price":344000,"area":114,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-04-12","n_rooms":3,"n_baths":2,"n_floor":4,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"TRUE","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/100631792","year_of_construction":1955,"full_address":"Calle de Antonio López","closing_local_price":333549,"is_active":0,"distance":241}
{"origin_id":101949788,"boundary_id":70405,"operation_type_id":2,"lat":40.393456,"lon":-3.7110293,"local_price":213000,"area":88,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-10-25","n_rooms":3,"n_baths":2,"n_floor":8,"is_vertical":1,"has_storage":"","has_garage":"","has_garage_included":"","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"TRUE","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"FALSE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/101949788","year_of_construction":1970,"full_address":"","closing_local_price":206529,"is_active":1,"distance":245}
{"origin_id":101682753,"boundary_id":70411,"operation_type_id":2,"lat":40.391743,"lon":-3.7087278,"local_price":320000,"area":102,"usage_id":1,"build_status_id":2,"conservation_id":1,"property_type_id":4,"last_appearance":"2023-07-19","n_rooms":3,"n_baths":2,"n_floor":7,"is_vertical":1,"has_storage":"","has_garage":"TRUE","has_garage_included":"TRUE","has_common_zones":"FALSE","has_pool":"FALSE","has_air_conditioner":"TRUE","has_terrace":"TRUE","is_exterior":"TRUE","geohash":"ezjmg9","is_exact_address":"TRUE","has_elevator":"TRUE","url":"https:\/\/www.idealista.com\/inmueble\/101682753","year_of_construction":null,"full_address":"Paseo de Santa María de la Cabeza  116","closing_local_price":310278,"is_active":0,"distance":246}

Date

Fri, 10 Nov 2023 08:57:52 GMT

Content-Type

application/x-ndjson

Content-Length

1126

Connection

keep-alive

x-amzn-RequestId

14d9189c-b603-44ee-8589-1de43418d184

Access-Control-Allow-Origin

Content-Encoding

gzip

Strict-Transport-Security

max-age=63072000

X-Tb-R

92357de8

x-amzn-Remapped-Content-Length

1126

X-Frame-Options

sameorigin

Access-Control-Allow-Headers

Authorization, Content-Type, X-Requested-With

x-amzn-Remapped-Connection

keep-alive

X-Tb-Statistics

{"elapsed":0.11765670776367188,"db":0.106772,"fetch":0.10736489295959473,"threads":None}

X-Request-Id

ae86a038-6de6-496e-81e2-f1511126e44a

x-amz-apigw-id

OLKGlHFXDoEErdA=

x-amzn-Remapped-Server

nginx

Etag

"f22f1f1ddf57bc8c8e955fbb6284065d289f7018"

Access-Control-Allow-Methods

GET, POST, PUT, DELETE, OPTIONS

X-Db-Backend

backend_eu_public_a_2

Access-Control-Max-Age

86400

x-amzn-Remapped-Date

Fri, 10 Nov 2023 08:57:52 GMT

X-Db-Statistics

{"read_rows":"835584","read_bytes":"72028274","written_rows":"0","written_bytes":"0","total_rows_to_read":"835584","result_rows":"10","result_bytes":"222720"}