You are browsing sample data. Buy download of full dataset or subscribe to API access with one of our member plans.
{ "sample": { "is_sample": "TRUE", "limit_total": 400 }, "api": { "title": "Real Estate & Apartments", "point": { "title": "By Table", "desc": "Each API function returns data from a specific database table. " } }, "input": { "url": false, "get": false, "post": false }, "links": { "up": { "href": "https://songer.datasn.com/data/api/v1/u_15ff9ad43f41a2ff2f41/real_estate_and_apartments_1/by_table/" }, "home": { "href": "https://songer.datasn.com/data/api/v1/u_15ff9ad43f41a2ff2f41/real_estate_and_apartments_1/by_table/real_estate_x_construction/?app=html-json&manifest=row" }, "prev": { "href": "https://songer.datasn.com/data/api/v1/u_15ff9ad43f41a2ff2f41/real_estate_and_apartments_1/by_table/real_estate_x_construction/?app=html-json&manifest=row" }, "next": { "href": "https://songer.datasn.com/data/api/v1/u_15ff9ad43f41a2ff2f41/real_estate_and_apartments_1/by_table/real_estate_x_construction/3/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 2, "limit": 100, "limit_total": 400, "time": 0.005250000000000000326128013483639733749441802501678466796875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 30589, "pages_total": 306 }, "struct": { "stem": { "0": "real_estate_x_construction", "1": "real_estate", "2": "building_address", "3": "street", "4": "code", "5": "county", "6": "state", "7": "construction" }, "leaf": "real_estate_x_construction.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "102": { "real_estate_x_construction.id": 102, "real_estate.id": 93, "real_estate.ts": "2017-03-21 22:28:09", "real_estate.title": "3114 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19866499999999831516106496565043926239013671875, "real_estate.longitude": -118.1464030000000065001586335711181163787841796875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,757", "building_address.id": 1029, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3114 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "103": { "real_estate_x_construction.id": 103, "real_estate.id": 93, "real_estate.ts": "2017-03-21 22:28:09", "real_estate.title": "3114 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19866499999999831516106496565043926239013671875, "real_estate.longitude": -118.1464030000000065001586335711181163787841796875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,757", "building_address.id": 1029, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3114 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "101": { "real_estate_x_construction.id": 101, "real_estate.id": 93, "real_estate.ts": "2017-03-21 22:28:09", "real_estate.title": "3114 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19866499999999831516106496565043926239013671875, "real_estate.longitude": -118.1464030000000065001586335711181163787841796875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,757", "building_address.id": 1029, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3114 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 30, "construction.ts": "2017-03-21 22:24:43", "construction.title": "Room count: 10" }, "105": { "real_estate_x_construction.id": 105, "real_estate.id": 94, "real_estate.ts": "2017-03-21 22:28:19", "real_estate.title": "3375 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.201177999999998746716300956904888153076171875, "real_estate.longitude": -118.146015000000005557012627832591533660888671875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 2, "real_estate.sqft": "1,493", "building_address.id": 1030, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3375 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "106": { "real_estate_x_construction.id": 106, "real_estate.id": 94, "real_estate.ts": "2017-03-21 22:28:19", "real_estate.title": "3375 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.201177999999998746716300956904888153076171875, "real_estate.longitude": -118.146015000000005557012627832591533660888671875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 2, "real_estate.sqft": "1,493", "building_address.id": 1030, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3375 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "104": { "real_estate_x_construction.id": 104, "real_estate.id": 94, "real_estate.ts": "2017-03-21 22:28:19", "real_estate.title": "3375 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.201177999999998746716300956904888153076171875, "real_estate.longitude": -118.146015000000005557012627832591533660888671875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 2, "real_estate.sqft": "1,493", "building_address.id": 1030, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3375 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 53, "construction.ts": "2017-03-21 22:25:48", "construction.title": "Room count: 9" }, "108": { "real_estate_x_construction.id": 108, "real_estate.id": 95, "real_estate.ts": "2017-03-21 22:28:38", "real_estate.title": "3053 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19785499999999700548869441263377666473388671875, "real_estate.longitude": -118.1474620000000044228727347217500209808349609375, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,634", "building_address.id": 1031, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3053 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "109": { "real_estate_x_construction.id": 109, "real_estate.id": 95, "real_estate.ts": "2017-03-21 22:28:38", "real_estate.title": "3053 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19785499999999700548869441263377666473388671875, "real_estate.longitude": -118.1474620000000044228727347217500209808349609375, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,634", "building_address.id": 1031, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3053 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "107": { "real_estate_x_construction.id": 107, "real_estate.id": 95, "real_estate.ts": "2017-03-21 22:28:38", "real_estate.title": "3053 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19785499999999700548869441263377666473388671875, "real_estate.longitude": -118.1474620000000044228727347217500209808349609375, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,634", "building_address.id": 1031, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3053 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 8, "construction.ts": "2017-03-21 22:21:35", "construction.title": "Room count: 6" }, "111": { "real_estate_x_construction.id": 111, "real_estate.id": 96, "real_estate.ts": "2017-03-21 22:28:58", "real_estate.title": "3340 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20048899999999747478796052746474742889404296875, "real_estate.longitude": -118.145791000000002668457455001771450042724609375, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,746", "building_address.id": 1032, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3340 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "112": { "real_estate_x_construction.id": 112, "real_estate.id": 96, "real_estate.ts": "2017-03-21 22:28:58", "real_estate.title": "3340 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20048899999999747478796052746474742889404296875, "real_estate.longitude": -118.145791000000002668457455001771450042724609375, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,746", "building_address.id": 1032, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3340 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "110": { "real_estate_x_construction.id": 110, "real_estate.id": 96, "real_estate.ts": "2017-03-21 22:28:58", "real_estate.title": "3340 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20048899999999747478796052746474742889404296875, "real_estate.longitude": -118.145791000000002668457455001771450042724609375, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,746", "building_address.id": 1032, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3340 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 30, "construction.ts": "2017-03-21 22:24:43", "construction.title": "Room count: 10" }, "113": { "real_estate_x_construction.id": 113, "real_estate.id": 97, "real_estate.ts": "2017-03-21 22:29:08", "real_estate.title": "3082 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.198092000000002599335857667028903961181640625, "real_estate.longitude": -118.1466060000000055651980801485478878021240234375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "1,281", "building_address.id": 1033, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3082 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 1, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Roof type: Other" }, "115": { "real_estate_x_construction.id": 115, "real_estate.id": 97, "real_estate.ts": "2017-03-21 22:29:08", "real_estate.title": "3082 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.198092000000002599335857667028903961181640625, "real_estate.longitude": -118.1466060000000055651980801485478878021240234375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "1,281", "building_address.id": 1033, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3082 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "117": { "real_estate_x_construction.id": 117, "real_estate.id": 97, "real_estate.ts": "2017-03-21 22:29:08", "real_estate.title": "3082 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.198092000000002599335857667028903961181640625, "real_estate.longitude": -118.1466060000000055651980801485478878021240234375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "1,281", "building_address.id": 1033, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3082 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "116": { "real_estate_x_construction.id": 116, "real_estate.id": 97, "real_estate.ts": "2017-03-21 22:29:08", "real_estate.title": "3082 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.198092000000002599335857667028903961181640625, "real_estate.longitude": -118.1466060000000055651980801485478878021240234375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "1,281", "building_address.id": 1033, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3082 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 45, "construction.ts": "2017-03-21 22:25:12", "construction.title": "Structure type: Other" }, "114": { "real_estate_x_construction.id": 114, "real_estate.id": 97, "real_estate.ts": "2017-03-21 22:29:08", "real_estate.title": "3082 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.198092000000002599335857667028903961181640625, "real_estate.longitude": -118.1466060000000055651980801485478878021240234375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "1,281", "building_address.id": 1033, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3082 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 53, "construction.ts": "2017-03-21 22:25:48", "construction.title": "Room count: 9" }, "119": { "real_estate_x_construction.id": 119, "real_estate.id": 98, "real_estate.ts": "2017-03-21 22:29:22", "real_estate.title": "3028 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19730100000000305726644000969827175140380859375, "real_estate.longitude": -118.1470649999999977808329276740550994873046875, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 930, "building_address.id": 1034, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3028 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "120": { "real_estate_x_construction.id": 120, "real_estate.id": 98, "real_estate.ts": "2017-03-21 22:29:22", "real_estate.title": "3028 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19730100000000305726644000969827175140380859375, "real_estate.longitude": -118.1470649999999977808329276740550994873046875, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 930, "building_address.id": 1034, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3028 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "118": { "real_estate_x_construction.id": 118, "real_estate.id": 98, "real_estate.ts": "2017-03-21 22:29:22", "real_estate.title": "3028 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19730100000000305726644000969827175140380859375, "real_estate.longitude": -118.1470649999999977808329276740550994873046875, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 930, "building_address.id": 1034, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3028 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 8, "construction.ts": "2017-03-21 22:21:35", "construction.title": "Room count: 6" }, "123": { "real_estate_x_construction.id": 123, "real_estate.id": 99, "real_estate.ts": "2017-03-21 22:29:40", "real_estate.title": "3131 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19910300000000091813490143977105617523193359375, "real_estate.longitude": -118.146826000000004341927706263959407806396484375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 967, "building_address.id": 1035, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3131 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 2, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Room count: 5" }, "124": { "real_estate_x_construction.id": 124, "real_estate.id": 99, "real_estate.ts": "2017-03-21 22:29:40", "real_estate.title": "3131 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19910300000000091813490143977105617523193359375, "real_estate.longitude": -118.146826000000004341927706263959407806396484375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 967, "building_address.id": 1035, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3131 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "125": { "real_estate_x_construction.id": 125, "real_estate.id": 99, "real_estate.ts": "2017-03-21 22:29:40", "real_estate.title": "3131 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19910300000000091813490143977105617523193359375, "real_estate.longitude": -118.146826000000004341927706263959407806396484375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 967, "building_address.id": 1035, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3131 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "122": { "real_estate_x_construction.id": 122, "real_estate.id": 99, "real_estate.ts": "2017-03-21 22:29:40", "real_estate.title": "3131 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19910300000000091813490143977105617523193359375, "real_estate.longitude": -118.146826000000004341927706263959407806396484375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 967, "building_address.id": 1035, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3131 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 12, "construction.ts": "2017-03-21 22:22:30", "construction.title": "Roof type: Composition" }, "121": { "real_estate_x_construction.id": 121, "real_estate.id": 99, "real_estate.ts": "2017-03-21 22:29:40", "real_estate.title": "3131 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19910300000000091813490143977105617523193359375, "real_estate.longitude": -118.146826000000004341927706263959407806396484375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 967, "building_address.id": 1035, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3131 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 36, "construction.ts": "2017-03-21 22:24:58", "construction.title": "Exterior material: Wood" }, "126": { "real_estate_x_construction.id": 126, "real_estate.id": 100, "real_estate.ts": "2017-03-21 22:29:55", "real_estate.title": "3094 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19833100000000314366843667812645435333251953125, "real_estate.longitude": -118.1464940000000041209204937331378459930419921875, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,147", "building_address.id": 1036, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3094 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 2, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Room count: 5" }, "127": { "real_estate_x_construction.id": 127, "real_estate.id": 100, "real_estate.ts": "2017-03-21 22:29:55", "real_estate.title": "3094 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19833100000000314366843667812645435333251953125, "real_estate.longitude": -118.1464940000000041209204937331378459930419921875, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,147", "building_address.id": 1036, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3094 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "128": { "real_estate_x_construction.id": 128, "real_estate.id": 100, "real_estate.ts": "2017-03-21 22:29:55", "real_estate.title": "3094 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19833100000000314366843667812645435333251953125, "real_estate.longitude": -118.1464940000000041209204937331378459930419921875, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,147", "building_address.id": 1036, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3094 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "129": { "real_estate_x_construction.id": 129, "real_estate.id": 101, "real_estate.ts": "2017-03-21 22:29:59", "real_estate.title": "3130 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19895600000000257523424807004630565643310546875, "real_estate.longitude": -118.14636699999999791543814353644847869873046875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,428", "building_address.id": 1037, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3130 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 2, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Room count: 5" }, "130": { "real_estate_x_construction.id": 130, "real_estate.id": 101, "real_estate.ts": "2017-03-21 22:29:59", "real_estate.title": "3130 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19895600000000257523424807004630565643310546875, "real_estate.longitude": -118.14636699999999791543814353644847869873046875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,428", "building_address.id": 1037, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3130 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "131": { "real_estate_x_construction.id": 131, "real_estate.id": 101, "real_estate.ts": "2017-03-21 22:29:59", "real_estate.title": "3130 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19895600000000257523424807004630565643310546875, "real_estate.longitude": -118.14636699999999791543814353644847869873046875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,428", "building_address.id": 1037, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3130 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "133": { "real_estate_x_construction.id": 133, "real_estate.id": 103, "real_estate.ts": "2017-03-21 22:30:21", "real_estate.title": "3075 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19823000000000234877006732858717441558837890625, "real_estate.longitude": -118.1472849999999965575625537894666194915771484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,482", "building_address.id": 1039, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3075 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "134": { "real_estate_x_construction.id": 134, "real_estate.id": 103, "real_estate.ts": "2017-03-21 22:30:21", "real_estate.title": "3075 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19823000000000234877006732858717441558837890625, "real_estate.longitude": -118.1472849999999965575625537894666194915771484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,482", "building_address.id": 1039, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3075 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "132": { "real_estate_x_construction.id": 132, "real_estate.id": 103, "real_estate.ts": "2017-03-21 22:30:21", "real_estate.title": "3075 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19823000000000234877006732858717441558837890625, "real_estate.longitude": -118.1472849999999965575625537894666194915771484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,482", "building_address.id": 1039, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3075 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 22, "construction.ts": "2017-03-21 22:23:18", "construction.title": "Room count: 7" }, "136": { "real_estate_x_construction.id": 136, "real_estate.id": 104, "real_estate.ts": "2017-03-21 22:30:28", "real_estate.title": "3029 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.1974579999999974688762449659407138824462890625, "real_estate.longitude": -118.1475590000000011059455573558807373046875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 2, "real_estate.sqft": "1,922", "building_address.id": 1040, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3029 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "137": { "real_estate_x_construction.id": 137, "real_estate.id": 104, "real_estate.ts": "2017-03-21 22:30:28", "real_estate.title": "3029 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.1974579999999974688762449659407138824462890625, "real_estate.longitude": -118.1475590000000011059455573558807373046875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 2, "real_estate.sqft": "1,922", "building_address.id": 1040, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3029 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "135": { "real_estate_x_construction.id": 135, "real_estate.id": 104, "real_estate.ts": "2017-03-21 22:30:28", "real_estate.title": "3029 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.1974579999999974688762449659407138824462890625, "real_estate.longitude": -118.1475590000000011059455573558807373046875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 2, "real_estate.sqft": "1,922", "building_address.id": 1040, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3029 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 22, "construction.ts": "2017-03-21 22:23:18", "construction.title": "Room count: 7" }, "139": { "real_estate_x_construction.id": 139, "real_estate.id": 105, "real_estate.ts": "2017-03-21 22:30:34", "real_estate.title": "3093 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19851100000000343470674124546349048614501953125, "real_estate.longitude": -118.1471559999999954015947878360748291015625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,254", "building_address.id": 1041, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3093 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "140": { "real_estate_x_construction.id": 140, "real_estate.id": 105, "real_estate.ts": "2017-03-21 22:30:34", "real_estate.title": "3093 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19851100000000343470674124546349048614501953125, "real_estate.longitude": -118.1471559999999954015947878360748291015625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,254", "building_address.id": 1041, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3093 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "138": { "real_estate_x_construction.id": 138, "real_estate.id": 105, "real_estate.ts": "2017-03-21 22:30:34", "real_estate.title": "3093 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.19851100000000343470674124546349048614501953125, "real_estate.longitude": -118.1471559999999954015947878360748291015625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,254", "building_address.id": 1041, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3093 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 22, "construction.ts": "2017-03-21 22:23:18", "construction.title": "Room count: 7" }, "142": { "real_estate_x_construction.id": 142, "real_estate.id": 106, "real_estate.ts": "2017-03-21 22:30:44", "real_estate.title": "3330 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.2002269999999981564542395062744617462158203125, "real_estate.longitude": -118.145883999999995239704730920493602752685546875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,137", "building_address.id": 1042, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3330 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "143": { "real_estate_x_construction.id": 143, "real_estate.id": 106, "real_estate.ts": "2017-03-21 22:30:44", "real_estate.title": "3330 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.2002269999999981564542395062744617462158203125, "real_estate.longitude": -118.145883999999995239704730920493602752685546875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,137", "building_address.id": 1042, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3330 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "141": { "real_estate_x_construction.id": 141, "real_estate.id": 106, "real_estate.ts": "2017-03-21 22:30:44", "real_estate.title": "3330 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.2002269999999981564542395062744617462158203125, "real_estate.longitude": -118.145883999999995239704730920493602752685546875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,137", "building_address.id": 1042, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3330 La Corona Ave Altadena, CA 91001", "building_address.street": "La Corona Ave", "street.id": 42, "street.ts": "2017-03-02 20:35:23", "street.title": "La Corona Ave", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 8, "construction.ts": "2017-03-21 22:21:35", "construction.title": "Room count: 6" }, "145": { "real_estate_x_construction.id": 145, "real_estate.id": 107, "real_estate.ts": "2017-03-21 22:31:06", "real_estate.title": "595 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19227099999999808233042131178081035614013671875, "real_estate.longitude": -118.1616819999999989931893651373684406280517578125, "real_estate.bedrooms": "", "real_estate.bathrooms": "", "real_estate.sqft": "", "building_address.id": 1043, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "595 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 29, "construction.ts": "2017-03-21 22:24:36", "construction.title": "Unit count: 2" }, "144": { "real_estate_x_construction.id": 144, "real_estate.id": 107, "real_estate.ts": "2017-03-21 22:31:06", "real_estate.title": "595 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19227099999999808233042131178081035614013671875, "real_estate.longitude": -118.1616819999999989931893651373684406280517578125, "real_estate.bedrooms": "", "real_estate.bathrooms": "", "real_estate.sqft": "", "building_address.id": 1043, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "595 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 144, "construction.ts": "2017-03-21 22:31:06", "construction.title": "Stories: 0" }, "146": { "real_estate_x_construction.id": 146, "real_estate.id": 108, "real_estate.ts": "2017-03-21 22:31:19", "real_estate.title": "115 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18935499999999905185177340172231197357177734375, "real_estate.longitude": -118.1523770000000013169483281672000885009765625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": 942, "building_address.id": 1044, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "115 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 1, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Roof type: Other" }, "149": { "real_estate_x_construction.id": 149, "real_estate.id": 108, "real_estate.ts": "2017-03-21 22:31:19", "real_estate.title": "115 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18935499999999905185177340172231197357177734375, "real_estate.longitude": -118.1523770000000013169483281672000885009765625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": 942, "building_address.id": 1044, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "115 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "148": { "real_estate_x_construction.id": 148, "real_estate.id": 108, "real_estate.ts": "2017-03-21 22:31:19", "real_estate.title": "115 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18935499999999905185177340172231197357177734375, "real_estate.longitude": -118.1523770000000013169483281672000885009765625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": 942, "building_address.id": 1044, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "115 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 45, "construction.ts": "2017-03-21 22:25:12", "construction.title": "Structure type: Other" }, "147": { "real_estate_x_construction.id": 147, "real_estate.id": 108, "real_estate.ts": "2017-03-21 22:31:19", "real_estate.title": "115 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18935499999999905185177340172231197357177734375, "real_estate.longitude": -118.1523770000000013169483281672000885009765625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": 942, "building_address.id": 1044, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "115 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 144, "construction.ts": "2017-03-21 22:31:06", "construction.title": "Stories: 0" }, "151": { "real_estate_x_construction.id": 151, "real_estate.id": 110, "real_estate.ts": "2017-03-21 22:31:33", "real_estate.title": "605 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1922569999999979017957230098545551300048828125, "real_estate.longitude": -118.1619290000000006557456799782812595367431640625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,330", "building_address.id": 1046, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "605 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "152": { "real_estate_x_construction.id": 152, "real_estate.id": 110, "real_estate.ts": "2017-03-21 22:31:33", "real_estate.title": "605 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1922569999999979017957230098545551300048828125, "real_estate.longitude": -118.1619290000000006557456799782812595367431640625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,330", "building_address.id": 1046, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "605 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "150": { "real_estate_x_construction.id": 150, "real_estate.id": 110, "real_estate.ts": "2017-03-21 22:31:33", "real_estate.title": "605 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1922569999999979017957230098545551300048828125, "real_estate.longitude": -118.1619290000000006557456799782812595367431640625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,330", "building_address.id": 1046, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "605 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 22, "construction.ts": "2017-03-21 22:23:18", "construction.title": "Room count: 7" }, "156": { "real_estate_x_construction.id": 156, "real_estate.id": 111, "real_estate.ts": "2017-03-21 22:31:35", "real_estate.title": "338 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18978299999999848068910068832337856292724609375, "real_estate.longitude": -118.1573029999999988604031386785209178924560546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,625", "building_address.id": 1047, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "338 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "157": { "real_estate_x_construction.id": 157, "real_estate.id": 111, "real_estate.ts": "2017-03-21 22:31:35", "real_estate.title": "338 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18978299999999848068910068832337856292724609375, "real_estate.longitude": -118.1573029999999988604031386785209178924560546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,625", "building_address.id": 1047, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "338 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "155": { "real_estate_x_construction.id": 155, "real_estate.id": 111, "real_estate.ts": "2017-03-21 22:31:35", "real_estate.title": "338 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18978299999999848068910068832337856292724609375, "real_estate.longitude": -118.1573029999999988604031386785209178924560546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,625", "building_address.id": 1047, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "338 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 8, "construction.ts": "2017-03-21 22:21:35", "construction.title": "Room count: 6" }, "153": { "real_estate_x_construction.id": 153, "real_estate.id": 111, "real_estate.ts": "2017-03-21 22:31:35", "real_estate.title": "338 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18978299999999848068910068832337856292724609375, "real_estate.longitude": -118.1573029999999988604031386785209178924560546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,625", "building_address.id": 1047, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "338 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 47, "construction.ts": "2017-03-21 22:25:28", "construction.title": "Exterior material: Stucco" }, "154": { "real_estate_x_construction.id": 154, "real_estate.id": 111, "real_estate.ts": "2017-03-21 22:31:35", "real_estate.title": "338 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18978299999999848068910068832337856292724609375, "real_estate.longitude": -118.1573029999999988604031386785209178924560546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,625", "building_address.id": 1047, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "338 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 48, "construction.ts": "2017-03-21 22:25:28", "construction.title": "Roof type: Shake Shingle" }, "161": { "real_estate_x_construction.id": 161, "real_estate.id": 112, "real_estate.ts": "2017-03-21 22:31:54", "real_estate.title": "694 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19237199999999887722879066132009029388427734375, "real_estate.longitude": -118.1638530000000031350282370112836360931396484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,287", "building_address.id": 1048, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "694 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "163": { "real_estate_x_construction.id": 163, "real_estate.id": 112, "real_estate.ts": "2017-03-21 22:31:54", "real_estate.title": "694 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19237199999999887722879066132009029388427734375, "real_estate.longitude": -118.1638530000000031350282370112836360931396484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,287", "building_address.id": 1048, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "694 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "160": { "real_estate_x_construction.id": 160, "real_estate.id": 112, "real_estate.ts": "2017-03-21 22:31:54", "real_estate.title": "694 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19237199999999887722879066132009029388427734375, "real_estate.longitude": -118.1638530000000031350282370112836360931396484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,287", "building_address.id": 1048, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "694 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 8, "construction.ts": "2017-03-21 22:21:35", "construction.title": "Room count: 6" }, "158": { "real_estate_x_construction.id": 158, "real_estate.id": 112, "real_estate.ts": "2017-03-21 22:31:54", "real_estate.title": "694 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19237199999999887722879066132009029388427734375, "real_estate.longitude": -118.1638530000000031350282370112836360931396484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,287", "building_address.id": 1048, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "694 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 47, "construction.ts": "2017-03-21 22:25:28", "construction.title": "Exterior material: Stucco" }, "159": { "real_estate_x_construction.id": 159, "real_estate.id": 112, "real_estate.ts": "2017-03-21 22:31:54", "real_estate.title": "694 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19237199999999887722879066132009029388427734375, "real_estate.longitude": -118.1638530000000031350282370112836360931396484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,287", "building_address.id": 1048, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "694 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 48, "construction.ts": "2017-03-21 22:25:28", "construction.title": "Roof type: Shake Shingle" }, "162": { "real_estate_x_construction.id": 162, "real_estate.id": 112, "real_estate.ts": "2017-03-21 22:31:54", "real_estate.title": "694 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19237199999999887722879066132009029388427734375, "real_estate.longitude": -118.1638530000000031350282370112836360931396484375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,287", "building_address.id": 1048, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "694 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 162, "construction.ts": "2017-03-21 22:31:54", "construction.title": "Structure type: Loft" }, "165": { "real_estate_x_construction.id": 165, "real_estate.id": 113, "real_estate.ts": "2017-03-21 22:32:03", "real_estate.title": "235 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19003500000000173031367012299597263336181640625, "real_estate.longitude": -118.1547149999999959391061565838754177093505859375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,456", "building_address.id": 1049, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "235 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "166": { "real_estate_x_construction.id": 166, "real_estate.id": 113, "real_estate.ts": "2017-03-21 22:32:03", "real_estate.title": "235 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19003500000000173031367012299597263336181640625, "real_estate.longitude": -118.1547149999999959391061565838754177093505859375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,456", "building_address.id": 1049, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "235 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "164": { "real_estate_x_construction.id": 164, "real_estate.id": 113, "real_estate.ts": "2017-03-21 22:32:03", "real_estate.title": "235 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19003500000000173031367012299597263336181640625, "real_estate.longitude": -118.1547149999999959391061565838754177093505859375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,456", "building_address.id": 1049, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "235 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 13, "construction.ts": "2017-03-21 22:22:30", "construction.title": "Room count: 8" }, "167": { "real_estate_x_construction.id": 167, "real_estate.id": 114, "real_estate.ts": "2017-03-21 22:32:19", "real_estate.title": "840 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19321000000000054797055781818926334381103515625, "real_estate.longitude": -118.1667589999999989913703757338225841522216796875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "2,521", "building_address.id": 1050, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "840 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 12, "construction.ts": "2017-03-21 22:22:30", "construction.title": "Roof type: Composition" }, "168": { "real_estate_x_construction.id": 168, "real_estate.id": 114, "real_estate.ts": "2017-03-21 22:32:19", "real_estate.title": "840 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19321000000000054797055781818926334381103515625, "real_estate.longitude": -118.1667589999999989913703757338225841522216796875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "2,521", "building_address.id": 1050, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "840 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 45, "construction.ts": "2017-03-21 22:25:12", "construction.title": "Structure type: Other" }, "169": { "real_estate_x_construction.id": 169, "real_estate.id": 114, "real_estate.ts": "2017-03-21 22:32:19", "real_estate.title": "840 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19321000000000054797055781818926334381103515625, "real_estate.longitude": -118.1667589999999989913703757338225841522216796875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "2,521", "building_address.id": 1050, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "840 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 169, "construction.ts": "2017-03-21 22:32:19", "construction.title": "Unit count: 3" }, "171": { "real_estate_x_construction.id": 171, "real_estate.id": 115, "real_estate.ts": "2017-03-21 22:32:30", "real_estate.title": "634 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.191969000000000278305378742516040802001953125, "real_estate.longitude": -118.162610000000000809450284577906131744384765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "1,892", "building_address.id": 1051, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "634 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "173": { "real_estate_x_construction.id": 173, "real_estate.id": 115, "real_estate.ts": "2017-03-21 22:32:30", "real_estate.title": "634 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.191969000000000278305378742516040802001953125, "real_estate.longitude": -118.162610000000000809450284577906131744384765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "1,892", "building_address.id": 1051, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "634 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "170": { "real_estate_x_construction.id": 170, "real_estate.id": 115, "real_estate.ts": "2017-03-21 22:32:30", "real_estate.title": "634 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.191969000000000278305378742516040802001953125, "real_estate.longitude": -118.162610000000000809450284577906131744384765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "1,892", "building_address.id": 1051, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "634 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 13, "construction.ts": "2017-03-21 22:22:30", "construction.title": "Room count: 8" }, "172": { "real_estate_x_construction.id": 172, "real_estate.id": 115, "real_estate.ts": "2017-03-21 22:32:30", "real_estate.title": "634 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.191969000000000278305378742516040802001953125, "real_estate.longitude": -118.162610000000000809450284577906131744384765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "1,892", "building_address.id": 1051, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "634 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 40, "construction.ts": "2017-03-21 22:24:58", "construction.title": "Structure type: Ranch" }, "175": { "real_estate_x_construction.id": 175, "real_estate.id": 116, "real_estate.ts": "2017-03-21 22:32:47", "real_estate.title": "592 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19165699999999930014382698573172092437744140625, "real_estate.longitude": -118.1618619999999992842276697047054767608642578125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,080", "building_address.id": 1052, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "592 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "176": { "real_estate_x_construction.id": 176, "real_estate.id": 116, "real_estate.ts": "2017-03-21 22:32:47", "real_estate.title": "592 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19165699999999930014382698573172092437744140625, "real_estate.longitude": -118.1618619999999992842276697047054767608642578125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,080", "building_address.id": 1052, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "592 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "174": { "real_estate_x_construction.id": 174, "real_estate.id": 116, "real_estate.ts": "2017-03-21 22:32:47", "real_estate.title": "592 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19165699999999930014382698573172092437744140625, "real_estate.longitude": -118.1618619999999992842276697047054767608642578125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,080", "building_address.id": 1052, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "592 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 22, "construction.ts": "2017-03-21 22:23:18", "construction.title": "Room count: 7" }, "178": { "real_estate_x_construction.id": 178, "real_estate.id": 117, "real_estate.ts": "2017-03-21 22:33:09", "real_estate.title": "606 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19175599999999803912942297756671905517578125, "real_estate.longitude": -118.16217100000000073123374022543430328369140625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,632", "building_address.id": 1053, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "606 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "179": { "real_estate_x_construction.id": 179, "real_estate.id": 117, "real_estate.ts": "2017-03-21 22:33:09", "real_estate.title": "606 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19175599999999803912942297756671905517578125, "real_estate.longitude": -118.16217100000000073123374022543430328369140625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,632", "building_address.id": 1053, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "606 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "177": { "real_estate_x_construction.id": 177, "real_estate.id": 117, "real_estate.ts": "2017-03-21 22:33:09", "real_estate.title": "606 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19175599999999803912942297756671905517578125, "real_estate.longitude": -118.16217100000000073123374022543430328369140625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2, "real_estate.sqft": "1,632", "building_address.id": 1053, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "606 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 30, "construction.ts": "2017-03-21 22:24:43", "construction.title": "Room count: 10" }, "182": { "real_estate_x_construction.id": 182, "real_estate.id": 118, "real_estate.ts": "2017-03-21 22:33:28", "real_estate.title": "750 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1926399999999972578734741546213626861572265625, "real_estate.longitude": -118.1649579999999986057446221821010112762451171875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,218", "building_address.id": 1054, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "750 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "181": { "real_estate_x_construction.id": 181, "real_estate.id": 118, "real_estate.ts": "2017-03-21 22:33:28", "real_estate.title": "750 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1926399999999972578734741546213626861572265625, "real_estate.longitude": -118.1649579999999986057446221821010112762451171875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,218", "building_address.id": 1054, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "750 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 12, "construction.ts": "2017-03-21 22:22:30", "construction.title": "Roof type: Composition" }, "180": { "real_estate_x_construction.id": 180, "real_estate.id": 118, "real_estate.ts": "2017-03-21 22:33:28", "real_estate.title": "750 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1926399999999972578734741546213626861572265625, "real_estate.longitude": -118.1649579999999986057446221821010112762451171875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,218", "building_address.id": 1054, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "750 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 36, "construction.ts": "2017-03-21 22:24:58", "construction.title": "Exterior material: Wood" }, "184": { "real_estate_x_construction.id": 184, "real_estate.id": 118, "real_estate.ts": "2017-03-21 22:33:28", "real_estate.title": "750 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1926399999999972578734741546213626861572265625, "real_estate.longitude": -118.1649579999999986057446221821010112762451171875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,218", "building_address.id": 1054, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "750 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 169, "construction.ts": "2017-03-21 22:32:19", "construction.title": "Unit count: 3" }, "183": { "real_estate_x_construction.id": 183, "real_estate.id": 118, "real_estate.ts": "2017-03-21 22:33:28", "real_estate.title": "750 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1926399999999972578734741546213626861572265625, "real_estate.longitude": -118.1649579999999986057446221821010112762451171875, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,218", "building_address.id": 1054, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "750 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 183, "construction.ts": "2017-03-21 22:33:28", "construction.title": "Structure type: Bungalow" }, "186": { "real_estate_x_construction.id": 186, "real_estate.id": 119, "real_estate.ts": "2017-03-21 22:33:36", "real_estate.title": "277 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19041899999999856163412914611399173736572265625, "real_estate.longitude": -118.1555029999999959500200930051505565643310546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": "--", "real_estate.sqft": "2,535", "building_address.id": 1055, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "277 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 1, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Roof type: Other" }, "187": { "real_estate_x_construction.id": 187, "real_estate.id": 119, "real_estate.ts": "2017-03-21 22:33:36", "real_estate.title": "277 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19041899999999856163412914611399173736572265625, "real_estate.longitude": -118.1555029999999959500200930051505565643310546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": "--", "real_estate.sqft": "2,535", "building_address.id": 1055, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "277 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "189": { "real_estate_x_construction.id": 189, "real_estate.id": 119, "real_estate.ts": "2017-03-21 22:33:36", "real_estate.title": "277 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19041899999999856163412914611399173736572265625, "real_estate.longitude": -118.1555029999999959500200930051505565643310546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": "--", "real_estate.sqft": "2,535", "building_address.id": 1055, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "277 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 29, "construction.ts": "2017-03-21 22:24:36", "construction.title": "Unit count: 2" }, "188": { "real_estate_x_construction.id": 188, "real_estate.id": 119, "real_estate.ts": "2017-03-21 22:33:36", "real_estate.title": "277 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19041899999999856163412914611399173736572265625, "real_estate.longitude": -118.1555029999999959500200930051505565643310546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": "--", "real_estate.sqft": "2,535", "building_address.id": 1055, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "277 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 45, "construction.ts": "2017-03-21 22:25:12", "construction.title": "Structure type: Other" }, "185": { "real_estate_x_construction.id": 185, "real_estate.id": 119, "real_estate.ts": "2017-03-21 22:33:36", "real_estate.title": "277 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19041899999999856163412914611399173736572265625, "real_estate.longitude": -118.1555029999999959500200930051505565643310546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": "--", "real_estate.sqft": "2,535", "building_address.id": 1055, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "277 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 185, "construction.ts": "2017-03-21 22:33:36", "construction.title": "Exterior material: Other" }, "190": { "real_estate_x_construction.id": 190, "real_estate.id": 120, "real_estate.ts": "2017-03-21 22:33:54", "real_estate.title": "538 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19140900000000016234480426646769046783447265625, "real_estate.longitude": -118.160901999999992995071806944906711578369140625, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,060", "building_address.id": 1056, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "538 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 2, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Room count: 5" }, "191": { "real_estate_x_construction.id": 191, "real_estate.id": 120, "real_estate.ts": "2017-03-21 22:33:54", "real_estate.title": "538 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19140900000000016234480426646769046783447265625, "real_estate.longitude": -118.160901999999992995071806944906711578369140625, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,060", "building_address.id": 1056, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "538 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" }, "192": { "real_estate_x_construction.id": 192, "real_estate.id": 120, "real_estate.ts": "2017-03-21 22:33:54", "real_estate.title": "538 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19140900000000016234480426646769046783447265625, "real_estate.longitude": -118.160901999999992995071806944906711578369140625, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": "1,060", "building_address.id": 1056, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "538 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "194": { "real_estate_x_construction.id": 194, "real_estate.id": 121, "real_estate.ts": "2017-03-21 22:33:57", "real_estate.title": "334 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1897799999999989495336194522678852081298828125, "real_estate.longitude": -118.156780999999995174221112392842769622802734375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 798, "building_address.id": 1057, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "334 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 1, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Roof type: Other" }, "195": { "real_estate_x_construction.id": 195, "real_estate.id": 121, "real_estate.ts": "2017-03-21 22:33:57", "real_estate.title": "334 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1897799999999989495336194522678852081298828125, "real_estate.longitude": -118.156780999999995174221112392842769622802734375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 798, "building_address.id": 1057, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "334 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 2, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Room count: 5" }, "198": { "real_estate_x_construction.id": 198, "real_estate.id": 121, "real_estate.ts": "2017-03-21 22:33:57", "real_estate.title": "334 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1897799999999989495336194522678852081298828125, "real_estate.longitude": -118.156780999999995174221112392842769622802734375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 798, "building_address.id": 1057, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "334 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 4, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Unit count: 1" }, "197": { "real_estate_x_construction.id": 197, "real_estate.id": 121, "real_estate.ts": "2017-03-21 22:33:57", "real_estate.title": "334 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1897799999999989495336194522678852081298828125, "real_estate.longitude": -118.156780999999995174221112392842769622802734375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 798, "building_address.id": 1057, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "334 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 45, "construction.ts": "2017-03-21 22:25:12", "construction.title": "Structure type: Other" }, "193": { "real_estate_x_construction.id": 193, "real_estate.id": 121, "real_estate.ts": "2017-03-21 22:33:57", "real_estate.title": "334 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1897799999999989495336194522678852081298828125, "real_estate.longitude": -118.156780999999995174221112392842769622802734375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 798, "building_address.id": 1057, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "334 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 47, "construction.ts": "2017-03-21 22:25:28", "construction.title": "Exterior material: Stucco" }, "196": { "real_estate_x_construction.id": 196, "real_estate.id": 121, "real_estate.ts": "2017-03-21 22:33:57", "real_estate.title": "334 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1897799999999989495336194522678852081298828125, "real_estate.longitude": -118.156780999999995174221112392842769622802734375, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 798, "building_address.id": 1057, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "334 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 144, "construction.ts": "2017-03-21 22:31:06", "construction.title": "Stories: 0" }, "199": { "real_estate_x_construction.id": 199, "real_estate.id": 122, "real_estate.ts": "2017-03-21 22:34:00", "real_estate.title": "861 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1939220000000005939000402577221393585205078125, "real_estate.longitude": -118.1668619999999947367541608400642871856689453125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": 970, "building_address.id": 1058, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "861 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 2, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Room count: 5" }, "200": { "real_estate_x_construction.id": 200, "real_estate.id": 122, "real_estate.ts": "2017-03-21 22:34:00", "real_estate.title": "861 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1939220000000005939000402577221393585205078125, "real_estate.longitude": -118.1668619999999947367541608400642871856689453125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": 970, "building_address.id": 1058, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "861 Ventura St Altadena, CA 91001", "building_address.street": "Ventura St", "street.id": 43, "street.ts": "2017-03-02 20:35:23", "street.title": "Ventura St", "street.code": 91001, "code.id": 2, "code.ts": "2017-03-02 05:11:30", "code.title": 91001, "code.county": "Los Angeles", "county.id": 1, "county.ts": "2017-03-02 05:04:17", "county.title": "Los Angeles", "county.state": "California", "state.id": 1, "state.ts": "2017-03-02 05:03:14", "state.title": "California", "construction.id": 3, "construction.ts": "2017-03-21 22:21:07", "construction.title": "Stories: 1" } } } }