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_room_type/?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_room_type/2/?app=html-json&manifest=row" } }, "meta": { "query": { "page": 1, "limit": 100, "limit_total": 400, "time": 0.0049300000000000003541611448554249363951385021209716796875 }, "stats": { "raw_rows": 100, "rows": 100, "rows_total": 4923, "pages_total": 50 }, "struct": { "stem": { "0": "real_estate_x_room_type", "1": "real_estate", "2": "building_address", "3": "street", "4": "code", "5": "county", "6": "state", "7": "room_type" }, "leaf": "real_estate_x_room_type.id", "leaf_stem": {}, "leaf_stem_leaf": null } }, "output": { "rows": { "1": { "real_estate_x_room_type.id": 1, "real_estate.id": 1, "real_estate.ts": "2017-03-21 21:58:40", "real_estate.title": "5050 Linden Ave, Long Beach, CA 90895", "real_estate.latitude": 33.847679999999996880433172918856143951416015625, "real_estate.longitude": -118.185800000000000409272615797817707061767578125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 555, "building_address.id": 1, "building_address.ts": "2017-03-08 06:33:07", "building_address.title": "5050 Linden Ave Long Beach, CA 90895", "building_address.street": "Linden Ave", "street.id": 1, "street.ts": "2017-03-02 20:35:21", "street.title": "Linden Ave", "street.code": 90895, "code.id": 1, "code.ts": "2017-03-02 05:11:30", "code.title": 90895, "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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "2": { "real_estate_x_room_type.id": 2, "real_estate.id": 1, "real_estate.ts": "2017-03-21 21:58:40", "real_estate.title": "5050 Linden Ave, Long Beach, CA 90895", "real_estate.latitude": 33.847679999999996880433172918856143951416015625, "real_estate.longitude": -118.185800000000000409272615797817707061767578125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 1, "real_estate.sqft": 555, "building_address.id": 1, "building_address.ts": "2017-03-08 06:33:07", "building_address.title": "5050 Linden Ave Long Beach, CA 90895", "building_address.street": "Linden Ave", "street.id": 1, "street.ts": "2017-03-02 20:35:21", "street.title": "Linden Ave", "street.code": 90895, "code.id": 1, "code.ts": "2017-03-02 05:11:30", "code.title": 90895, "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "3": { "real_estate_x_room_type.id": 3, "real_estate.id": 54, "real_estate.ts": "2017-03-21 22:13:40", "real_estate.title": "1549 Sutherland St, Lancaster, CA 93534", "real_estate.latitude": 34.71673200000000036880010156892240047454833984375, "real_estate.longitude": -118.1590800000000029967850423417985439300537109375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,590", "building_address.id": 96001, "building_address.ts": "2017-03-08 22:52:06", "building_address.title": "1549 Sutherland St Lancaster, CA 93534", "building_address.street": "Sutherland St", "street.id": 4369, "street.ts": "2017-03-02 20:38:01", "street.title": "Sutherland St", "street.code": 93534, "code.id": 20, "code.ts": "2017-03-02 05:11:30", "code.title": 93534, "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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "4": { "real_estate_x_room_type.id": 4, "real_estate.id": 54, "real_estate.ts": "2017-03-21 22:13:40", "real_estate.title": "1549 Sutherland St, Lancaster, CA 93534", "real_estate.latitude": 34.71673200000000036880010156892240047454833984375, "real_estate.longitude": -118.1590800000000029967850423417985439300537109375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,590", "building_address.id": 96001, "building_address.ts": "2017-03-08 22:52:06", "building_address.title": "1549 Sutherland St Lancaster, CA 93534", "building_address.street": "Sutherland St", "street.id": 4369, "street.ts": "2017-03-02 20:38:01", "street.title": "Sutherland St", "street.code": 93534, "code.id": 20, "code.ts": "2017-03-02 05:11:30", "code.title": 93534, "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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "7": { "real_estate_x_room_type.id": 7, "real_estate.id": 59, "real_estate.ts": "2017-03-21 22:21:59", "real_estate.title": "748 Colman Street # FL 2ND, Altadena, CA 91001", "real_estate.latitude": 34.1835099999999982856024871580302715301513671875, "real_estate.longitude": -118.135077999999992925950209610164165496826171875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,300", "building_address.id": 5, "building_address.ts": "2017-03-08 06:33:42", "building_address.title": "748 Colman Street # Fl 2nd Altadena, CA 91001", "building_address.street": "Colman Street #", "street.id": 3, "street.ts": "2017-03-02 20:35:23", "street.title": "Colman Street #", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "8": { "real_estate_x_room_type.id": 8, "real_estate.id": 59, "real_estate.ts": "2017-03-21 22:21:59", "real_estate.title": "748 Colman Street # FL 2ND, Altadena, CA 91001", "real_estate.latitude": 34.1835099999999982856024871580302715301513671875, "real_estate.longitude": -118.135077999999992925950209610164165496826171875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,300", "building_address.id": 5, "building_address.ts": "2017-03-08 06:33:42", "building_address.title": "748 Colman Street # Fl 2nd Altadena, CA 91001", "building_address.street": "Colman Street #", "street.id": 3, "street.ts": "2017-03-02 20:35:23", "street.title": "Colman Street #", "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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "9": { "real_estate_x_room_type.id": 9, "real_estate.id": 63, "real_estate.ts": "2017-03-21 22:22:30", "real_estate.title": "521 Colman St, Altadena, CA 91001", "real_estate.latitude": 34.1854119999999994661266100592911243438720703125, "real_estate.longitude": -118.13952100000000200452632270753383636474609375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,891", "building_address.id": 9, "building_address.ts": "2017-03-08 06:33:42", "building_address.title": "521 Colman St Altadena, CA 91001", "building_address.street": "Colman St", "street.id": 4, "street.ts": "2017-03-02 20:35:23", "street.title": "Colman 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "11": { "real_estate_x_room_type.id": 11, "real_estate.id": 63, "real_estate.ts": "2017-03-21 22:22:30", "real_estate.title": "521 Colman St, Altadena, CA 91001", "real_estate.latitude": 34.1854119999999994661266100592911243438720703125, "real_estate.longitude": -118.13952100000000200452632270753383636474609375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,891", "building_address.id": 9, "building_address.ts": "2017-03-08 06:33:42", "building_address.title": "521 Colman St Altadena, CA 91001", "building_address.street": "Colman St", "street.id": 4, "street.ts": "2017-03-02 20:35:23", "street.title": "Colman 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "10": { "real_estate_x_room_type.id": 10, "real_estate.id": 63, "real_estate.ts": "2017-03-21 22:22:30", "real_estate.title": "521 Colman St, Altadena, CA 91001", "real_estate.latitude": 34.1854119999999994661266100592911243438720703125, "real_estate.longitude": -118.13952100000000200452632270753383636474609375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,891", "building_address.id": 9, "building_address.ts": "2017-03-08 06:33:42", "building_address.title": "521 Colman St Altadena, CA 91001", "building_address.street": "Colman St", "street.id": 4, "street.ts": "2017-03-02 20:35:23", "street.title": "Colman 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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "12": { "real_estate_x_room_type.id": 12, "real_estate.id": 63, "real_estate.ts": "2017-03-21 22:22:30", "real_estate.title": "521 Colman St, Altadena, CA 91001", "real_estate.latitude": 34.1854119999999994661266100592911243438720703125, "real_estate.longitude": -118.13952100000000200452632270753383636474609375, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,891", "building_address.id": 9, "building_address.ts": "2017-03-08 06:33:42", "building_address.title": "521 Colman St Altadena, CA 91001", "building_address.street": "Colman St", "street.id": 4, "street.ts": "2017-03-02 20:35:23", "street.title": "Colman 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", "room_type.id": 12, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Pantry" }, "13": { "real_estate_x_room_type.id": 13, "real_estate.id": 73, "real_estate.ts": "2017-03-21 22:24:58", "real_estate.title": "3501 Hollyslope Rd, Altadena, CA 91001", "real_estate.latitude": 34.2053149999999988040144671685993671417236328125, "real_estate.longitude": -118.1392129999999980327629600651562213897705078125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": "1,602", "building_address.id": 1009, "building_address.ts": "2017-03-08 06:42:03", "building_address.title": "3501 Hollyslope Rd Altadena, CA 91001", "building_address.street": "Hollyslope Rd", "street.id": 41, "street.ts": "2017-03-02 20:35:23", "street.title": "Hollyslope Rd", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "14": { "real_estate_x_room_type.id": 14, "real_estate.id": 73, "real_estate.ts": "2017-03-21 22:24:58", "real_estate.title": "3501 Hollyslope Rd, Altadena, CA 91001", "real_estate.latitude": 34.2053149999999988040144671685993671417236328125, "real_estate.longitude": -118.1392129999999980327629600651562213897705078125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": "1,602", "building_address.id": 1009, "building_address.ts": "2017-03-08 06:42:03", "building_address.title": "3501 Hollyslope Rd Altadena, CA 91001", "building_address.street": "Hollyslope Rd", "street.id": 41, "street.ts": "2017-03-02 20:35:23", "street.title": "Hollyslope Rd", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "15": { "real_estate_x_room_type.id": 15, "real_estate.id": 73, "real_estate.ts": "2017-03-21 22:24:58", "real_estate.title": "3501 Hollyslope Rd, Altadena, CA 91001", "real_estate.latitude": 34.2053149999999988040144671685993671417236328125, "real_estate.longitude": -118.1392129999999980327629600651562213897705078125, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": "1,602", "building_address.id": 1009, "building_address.ts": "2017-03-08 06:42:03", "building_address.title": "3501 Hollyslope Rd Altadena, CA 91001", "building_address.street": "Hollyslope Rd", "street.id": 41, "street.ts": "2017-03-02 20:35:23", "street.title": "Hollyslope Rd", "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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "16": { "real_estate_x_room_type.id": 16, "real_estate.id": 75, "real_estate.ts": "2017-03-21 22:25:28", "real_estate.title": "3364 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20084700000000310637915390543639659881591796875, "real_estate.longitude": -118.1456280000000020891093299724161624908447265625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,532", "building_address.id": 1011, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3364 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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "17": { "real_estate_x_room_type.id": 17, "real_estate.id": 75, "real_estate.ts": "2017-03-21 22:25:28", "real_estate.title": "3364 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20084700000000310637915390543639659881591796875, "real_estate.longitude": -118.1456280000000020891093299724161624908447265625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,532", "building_address.id": 1011, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3364 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "19": { "real_estate_x_room_type.id": 19, "real_estate.id": 75, "real_estate.ts": "2017-03-21 22:25:28", "real_estate.title": "3364 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20084700000000310637915390543639659881591796875, "real_estate.longitude": -118.1456280000000020891093299724161624908447265625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,532", "building_address.id": 1011, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3364 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "20": { "real_estate_x_room_type.id": 20, "real_estate.id": 75, "real_estate.ts": "2017-03-21 22:25:28", "real_estate.title": "3364 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20084700000000310637915390543639659881591796875, "real_estate.longitude": -118.1456280000000020891093299724161624908447265625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,532", "building_address.id": 1011, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3364 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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "18": { "real_estate_x_room_type.id": 18, "real_estate.id": 75, "real_estate.ts": "2017-03-21 22:25:28", "real_estate.title": "3364 La Corona Ave, Altadena, CA 91001", "real_estate.latitude": 34.20084700000000310637915390543639659881591796875, "real_estate.longitude": -118.1456280000000020891093299724161624908447265625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,532", "building_address.id": 1011, "building_address.ts": "2017-03-08 06:42:24", "building_address.title": "3364 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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "21": { "real_estate_x_room_type.id": 21, "real_estate.id": 109, "real_estate.ts": "2017-03-21 22:31:29", "real_estate.title": "823 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.193680000000000518411980010569095611572265625, "real_estate.longitude": -118.1660650000000032378011383116245269775390625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,430", "building_address.id": 1045, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "823 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "22": { "real_estate_x_room_type.id": 22, "real_estate.id": 109, "real_estate.ts": "2017-03-21 22:31:29", "real_estate.title": "823 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.193680000000000518411980010569095611572265625, "real_estate.longitude": -118.1660650000000032378011383116245269775390625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,430", "building_address.id": 1045, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "823 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", "room_type.id": 22, "room_type.ts": "2017-03-21 22:31:29", "room_type.title": "Recreation room" }, "23": { "real_estate_x_room_type.id": 23, "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "24": { "real_estate_x_room_type.id": 24, "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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "25": { "real_estate_x_room_type.id": 25, "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "26": { "real_estate_x_room_type.id": 26, "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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "28": { "real_estate_x_room_type.id": 28, "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", "room_type.id": 12, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Pantry" }, "27": { "real_estate_x_room_type.id": 27, "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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "29": { "real_estate_x_room_type.id": 29, "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", "room_type.id": 29, "room_type.ts": "2017-03-21 22:31:54", "room_type.title": "Sun room" }, "30": { "real_estate_x_room_type.id": 30, "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", "room_type.id": 30, "room_type.ts": "2017-03-21 22:31:54", "room_type.title": "Workshop" }, "31": { "real_estate_x_room_type.id": 31, "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "32": { "real_estate_x_room_type.id": 32, "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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "33": { "real_estate_x_room_type.id": 33, "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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "34": { "real_estate_x_room_type.id": 34, "real_estate.id": 151, "real_estate.ts": "2017-03-21 22:39:00", "real_estate.title": "372 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.190111999999999170540831983089447021484375, "real_estate.longitude": -118.1575739999999967722033034078776836395263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,458", "building_address.id": 1087, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "372 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "36": { "real_estate_x_room_type.id": 36, "real_estate.id": 151, "real_estate.ts": "2017-03-21 22:39:00", "real_estate.title": "372 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.190111999999999170540831983089447021484375, "real_estate.longitude": -118.1575739999999967722033034078776836395263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,458", "building_address.id": 1087, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "372 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "35": { "real_estate_x_room_type.id": 35, "real_estate.id": 151, "real_estate.ts": "2017-03-21 22:39:00", "real_estate.title": "372 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.190111999999999170540831983089447021484375, "real_estate.longitude": -118.1575739999999967722033034078776836395263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,458", "building_address.id": 1087, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "372 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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "37": { "real_estate_x_room_type.id": 37, "real_estate.id": 151, "real_estate.ts": "2017-03-21 22:39:00", "real_estate.title": "372 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.190111999999999170540831983089447021484375, "real_estate.longitude": -118.1575739999999967722033034078776836395263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,458", "building_address.id": 1087, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "372 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", "room_type.id": 22, "room_type.ts": "2017-03-21 22:31:29", "room_type.title": "Recreation room" }, "39": { "real_estate_x_room_type.id": 39, "real_estate.id": 155, "real_estate.ts": "2017-03-21 22:39:52", "real_estate.title": "139 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1894649999999984402165864594280719757080078125, "real_estate.longitude": -118.1529699999999962756191962398588657379150390625, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": "1,025", "building_address.id": 1091, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "139 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "38": { "real_estate_x_room_type.id": 38, "real_estate.id": 155, "real_estate.ts": "2017-03-21 22:39:52", "real_estate.title": "139 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1894649999999984402165864594280719757080078125, "real_estate.longitude": -118.1529699999999962756191962398588657379150390625, "real_estate.bedrooms": 2, "real_estate.bathrooms": 2, "real_estate.sqft": "1,025", "building_address.id": 1091, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "139 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "40": { "real_estate_x_room_type.id": 40, "real_estate.id": 167, "real_estate.ts": "2017-03-21 22:41:55", "real_estate.title": "560 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1915139999999979636413627304136753082275390625, "real_estate.longitude": -118.16122400000000425279722549021244049072265625, "real_estate.bedrooms": 6, "real_estate.bathrooms": 3.75, "real_estate.sqft": "3,000", "building_address.id": 1103, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "560 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "43": { "real_estate_x_room_type.id": 43, "real_estate.id": 167, "real_estate.ts": "2017-03-21 22:41:55", "real_estate.title": "560 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1915139999999979636413627304136753082275390625, "real_estate.longitude": -118.16122400000000425279722549021244049072265625, "real_estate.bedrooms": 6, "real_estate.bathrooms": 3.75, "real_estate.sqft": "3,000", "building_address.id": 1103, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "560 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "41": { "real_estate_x_room_type.id": 41, "real_estate.id": 167, "real_estate.ts": "2017-03-21 22:41:55", "real_estate.title": "560 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1915139999999979636413627304136753082275390625, "real_estate.longitude": -118.16122400000000425279722549021244049072265625, "real_estate.bedrooms": 6, "real_estate.bathrooms": 3.75, "real_estate.sqft": "3,000", "building_address.id": 1103, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "560 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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "42": { "real_estate_x_room_type.id": 42, "real_estate.id": 167, "real_estate.ts": "2017-03-21 22:41:55", "real_estate.title": "560 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1915139999999979636413627304136753082275390625, "real_estate.longitude": -118.16122400000000425279722549021244049072265625, "real_estate.bedrooms": 6, "real_estate.bathrooms": 3.75, "real_estate.sqft": "3,000", "building_address.id": 1103, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "560 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "44": { "real_estate_x_room_type.id": 44, "real_estate.id": 167, "real_estate.ts": "2017-03-21 22:41:55", "real_estate.title": "560 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1915139999999979636413627304136753082275390625, "real_estate.longitude": -118.16122400000000425279722549021244049072265625, "real_estate.bedrooms": 6, "real_estate.bathrooms": 3.75, "real_estate.sqft": "3,000", "building_address.id": 1103, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "560 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", "room_type.id": 44, "room_type.ts": "2017-03-21 22:41:55", "room_type.title": "Mud room" }, "45": { "real_estate_x_room_type.id": 45, "real_estate.id": 179, "real_estate.ts": "2017-03-21 22:44:24", "real_estate.title": "706 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19236000000000075260686571709811687469482421875, "real_estate.longitude": -118.164052999999995563484844751656055450439453125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,224", "building_address.id": 1115, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "706 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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "49": { "real_estate_x_room_type.id": 49, "real_estate.id": 179, "real_estate.ts": "2017-03-21 22:44:24", "real_estate.title": "706 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19236000000000075260686571709811687469482421875, "real_estate.longitude": -118.164052999999995563484844751656055450439453125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,224", "building_address.id": 1115, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "706 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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "46": { "real_estate_x_room_type.id": 46, "real_estate.id": 179, "real_estate.ts": "2017-03-21 22:44:24", "real_estate.title": "706 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19236000000000075260686571709811687469482421875, "real_estate.longitude": -118.164052999999995563484844751656055450439453125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,224", "building_address.id": 1115, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "706 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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "48": { "real_estate_x_room_type.id": 48, "real_estate.id": 179, "real_estate.ts": "2017-03-21 22:44:24", "real_estate.title": "706 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19236000000000075260686571709811687469482421875, "real_estate.longitude": -118.164052999999995563484844751656055450439453125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,224", "building_address.id": 1115, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "706 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", "room_type.id": 22, "room_type.ts": "2017-03-21 22:31:29", "room_type.title": "Recreation room" }, "47": { "real_estate_x_room_type.id": 47, "real_estate.id": 179, "real_estate.ts": "2017-03-21 22:44:24", "real_estate.title": "706 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19236000000000075260686571709811687469482421875, "real_estate.longitude": -118.164052999999995563484844751656055450439453125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,224", "building_address.id": 1115, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "706 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "50": { "real_estate_x_room_type.id": 50, "real_estate.id": 183, "real_estate.ts": "2017-03-21 22:45:06", "real_estate.title": "772 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19264199999999931378624751232564449310302734375, "real_estate.longitude": -118.16568200000000388172338716685771942138671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,664", "building_address.id": 1119, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "772 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "53": { "real_estate_x_room_type.id": 53, "real_estate.id": 183, "real_estate.ts": "2017-03-21 22:45:06", "real_estate.title": "772 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19264199999999931378624751232564449310302734375, "real_estate.longitude": -118.16568200000000388172338716685771942138671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,664", "building_address.id": 1119, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "772 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "54": { "real_estate_x_room_type.id": 54, "real_estate.id": 183, "real_estate.ts": "2017-03-21 22:45:06", "real_estate.title": "772 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19264199999999931378624751232564449310302734375, "real_estate.longitude": -118.16568200000000388172338716685771942138671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,664", "building_address.id": 1119, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "772 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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "51": { "real_estate_x_room_type.id": 51, "real_estate.id": 183, "real_estate.ts": "2017-03-21 22:45:06", "real_estate.title": "772 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19264199999999931378624751232564449310302734375, "real_estate.longitude": -118.16568200000000388172338716685771942138671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,664", "building_address.id": 1119, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "772 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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "52": { "real_estate_x_room_type.id": 52, "real_estate.id": 183, "real_estate.ts": "2017-03-21 22:45:06", "real_estate.title": "772 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19264199999999931378624751232564449310302734375, "real_estate.longitude": -118.16568200000000388172338716685771942138671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,664", "building_address.id": 1119, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "772 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "55": { "real_estate_x_room_type.id": 55, "real_estate.id": 191, "real_estate.ts": "2017-03-21 22:46:34", "real_estate.title": "370 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.19028200000000339286998496390879154205322265625, "real_estate.longitude": -118.1575389999999998735802364535629749298095703125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,476", "building_address.id": 1127, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "370 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "56": { "real_estate_x_room_type.id": 56, "real_estate.id": 235, "real_estate.ts": "2017-03-21 22:54:34", "real_estate.title": "336 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18961399999999883903001318685710430145263671875, "real_estate.longitude": -118.1568400000000025329427444376051425933837890625, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,143", "building_address.id": 1171, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "336 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "58": { "real_estate_x_room_type.id": 58, "real_estate.id": 235, "real_estate.ts": "2017-03-21 22:54:34", "real_estate.title": "336 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18961399999999883903001318685710430145263671875, "real_estate.longitude": -118.1568400000000025329427444376051425933837890625, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,143", "building_address.id": 1171, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "336 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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "60": { "real_estate_x_room_type.id": 60, "real_estate.id": 235, "real_estate.ts": "2017-03-21 22:54:34", "real_estate.title": "336 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18961399999999883903001318685710430145263671875, "real_estate.longitude": -118.1568400000000025329427444376051425933837890625, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,143", "building_address.id": 1171, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "336 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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "59": { "real_estate_x_room_type.id": 59, "real_estate.id": 235, "real_estate.ts": "2017-03-21 22:54:34", "real_estate.title": "336 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18961399999999883903001318685710430145263671875, "real_estate.longitude": -118.1568400000000025329427444376051425933837890625, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,143", "building_address.id": 1171, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "336 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", "room_type.id": 29, "room_type.ts": "2017-03-21 22:31:54", "room_type.title": "Sun room" }, "57": { "real_estate_x_room_type.id": 57, "real_estate.id": 235, "real_estate.ts": "2017-03-21 22:54:34", "real_estate.title": "336 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.18961399999999883903001318685710430145263671875, "real_estate.longitude": -118.1568400000000025329427444376051425933837890625, "real_estate.bedrooms": 5, "real_estate.bathrooms": 3, "real_estate.sqft": "2,143", "building_address.id": 1171, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "336 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "61": { "real_estate_x_room_type.id": 61, "real_estate.id": 237, "real_estate.ts": "2017-03-21 22:54:47", "real_estate.title": "314 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.190032999999999674400896765291690826416015625, "real_estate.longitude": -118.15652000000000043655745685100555419921875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,598", "building_address.id": 1173, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "314 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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "62": { "real_estate_x_room_type.id": 62, "real_estate.id": 237, "real_estate.ts": "2017-03-21 22:54:47", "real_estate.title": "314 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.190032999999999674400896765291690826416015625, "real_estate.longitude": -118.15652000000000043655745685100555419921875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,598", "building_address.id": 1173, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "314 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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "63": { "real_estate_x_room_type.id": 63, "real_estate.id": 246, "real_estate.ts": "2017-03-21 22:56:07", "real_estate.title": "820 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1930559999999985620888764970004558563232421875, "real_estate.longitude": -118.1662769999999937908796709962189197540283203125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,452", "building_address.id": 1182, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "820 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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "65": { "real_estate_x_room_type.id": 65, "real_estate.id": 246, "real_estate.ts": "2017-03-21 22:56:07", "real_estate.title": "820 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1930559999999985620888764970004558563232421875, "real_estate.longitude": -118.1662769999999937908796709962189197540283203125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,452", "building_address.id": 1182, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "820 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", "room_type.id": 22, "room_type.ts": "2017-03-21 22:31:29", "room_type.title": "Recreation room" }, "66": { "real_estate_x_room_type.id": 66, "real_estate.id": 246, "real_estate.ts": "2017-03-21 22:56:07", "real_estate.title": "820 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1930559999999985620888764970004558563232421875, "real_estate.longitude": -118.1662769999999937908796709962189197540283203125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,452", "building_address.id": 1182, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "820 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", "room_type.id": 29, "room_type.ts": "2017-03-21 22:31:54", "room_type.title": "Sun room" }, "67": { "real_estate_x_room_type.id": 67, "real_estate.id": 246, "real_estate.ts": "2017-03-21 22:56:07", "real_estate.title": "820 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1930559999999985620888764970004558563232421875, "real_estate.longitude": -118.1662769999999937908796709962189197540283203125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,452", "building_address.id": 1182, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "820 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", "room_type.id": 30, "room_type.ts": "2017-03-21 22:31:54", "room_type.title": "Workshop" }, "64": { "real_estate_x_room_type.id": 64, "real_estate.id": 246, "real_estate.ts": "2017-03-21 22:56:07", "real_estate.title": "820 Ventura St, Altadena, CA 91001", "real_estate.latitude": 34.1930559999999985620888764970004558563232421875, "real_estate.longitude": -118.1662769999999937908796709962189197540283203125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 1, "real_estate.sqft": "1,452", "building_address.id": 1182, "building_address.ts": "2017-03-08 06:42:41", "building_address.title": "820 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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "68": { "real_estate_x_room_type.id": 68, "real_estate.id": 255, "real_estate.ts": "2017-03-21 22:57:45", "real_estate.title": "1941 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17818799999999868077793507836759090423583984375, "real_estate.longitude": -118.1105649999999940291672828607261180877685546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2.5, "real_estate.sqft": "2,126", "building_address.id": 1191, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1941 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "71": { "real_estate_x_room_type.id": 71, "real_estate.id": 255, "real_estate.ts": "2017-03-21 22:57:45", "real_estate.title": "1941 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17818799999999868077793507836759090423583984375, "real_estate.longitude": -118.1105649999999940291672828607261180877685546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2.5, "real_estate.sqft": "2,126", "building_address.id": 1191, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1941 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "72": { "real_estate_x_room_type.id": 72, "real_estate.id": 255, "real_estate.ts": "2017-03-21 22:57:45", "real_estate.title": "1941 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17818799999999868077793507836759090423583984375, "real_estate.longitude": -118.1105649999999940291672828607261180877685546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2.5, "real_estate.sqft": "2,126", "building_address.id": 1191, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1941 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "69": { "real_estate_x_room_type.id": 69, "real_estate.id": 255, "real_estate.ts": "2017-03-21 22:57:45", "real_estate.title": "1941 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17818799999999868077793507836759090423583984375, "real_estate.longitude": -118.1105649999999940291672828607261180877685546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2.5, "real_estate.sqft": "2,126", "building_address.id": 1191, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1941 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "70": { "real_estate_x_room_type.id": 70, "real_estate.id": 255, "real_estate.ts": "2017-03-21 22:57:45", "real_estate.title": "1941 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17818799999999868077793507836759090423583984375, "real_estate.longitude": -118.1105649999999940291672828607261180877685546875, "real_estate.bedrooms": 4, "real_estate.bathrooms": 2.5, "real_estate.sqft": "2,126", "building_address.id": 1191, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1941 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "73": { "real_estate_x_room_type.id": 73, "real_estate.id": 258, "real_estate.ts": "2017-03-21 22:58:43", "real_estate.title": "1052 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17806499999999658712113159708678722381591796875, "real_estate.longitude": -118.128793000000001711669028736650943756103515625, "real_estate.bedrooms": 7, "real_estate.bathrooms": 5.5, "real_estate.sqft": "5,841", "building_address.id": 1194, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1052 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "75": { "real_estate_x_room_type.id": 75, "real_estate.id": 258, "real_estate.ts": "2017-03-21 22:58:43", "real_estate.title": "1052 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17806499999999658712113159708678722381591796875, "real_estate.longitude": -118.128793000000001711669028736650943756103515625, "real_estate.bedrooms": 7, "real_estate.bathrooms": 5.5, "real_estate.sqft": "5,841", "building_address.id": 1194, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1052 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "76": { "real_estate_x_room_type.id": 76, "real_estate.id": 258, "real_estate.ts": "2017-03-21 22:58:43", "real_estate.title": "1052 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17806499999999658712113159708678722381591796875, "real_estate.longitude": -118.128793000000001711669028736650943756103515625, "real_estate.bedrooms": 7, "real_estate.bathrooms": 5.5, "real_estate.sqft": "5,841", "building_address.id": 1194, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1052 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "74": { "real_estate_x_room_type.id": 74, "real_estate.id": 258, "real_estate.ts": "2017-03-21 22:58:43", "real_estate.title": "1052 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17806499999999658712113159708678722381591796875, "real_estate.longitude": -118.128793000000001711669028736650943756103515625, "real_estate.bedrooms": 7, "real_estate.bathrooms": 5.5, "real_estate.sqft": "5,841", "building_address.id": 1194, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1052 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "77": { "real_estate_x_room_type.id": 77, "real_estate.id": 259, "real_estate.ts": "2017-03-21 22:59:03", "real_estate.title": "2276 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17470300000000094087226898409426212310791015625, "real_estate.longitude": -118.105312999999995327016222290694713592529296875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,775", "building_address.id": 1195, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2276 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "78": { "real_estate_x_room_type.id": 78, "real_estate.id": 259, "real_estate.ts": "2017-03-21 22:59:03", "real_estate.title": "2276 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17470300000000094087226898409426212310791015625, "real_estate.longitude": -118.105312999999995327016222290694713592529296875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,775", "building_address.id": 1195, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2276 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "79": { "real_estate_x_room_type.id": 79, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "80": { "real_estate_x_room_type.id": 80, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "83": { "real_estate_x_room_type.id": 83, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 3, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Master bath" }, "85": { "real_estate_x_room_type.id": 85, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "81": { "real_estate_x_room_type.id": 81, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "84": { "real_estate_x_room_type.id": 84, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 12, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Pantry" }, "82": { "real_estate_x_room_type.id": 82, "real_estate.id": 261, "real_estate.ts": "2017-03-21 22:59:28", "real_estate.title": "1177 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1788099999999985811882652342319488525390625, "real_estate.longitude": -118.1264100000000070167516241781413555145263671875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "2,445", "building_address.id": 1197, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1177 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 82, "room_type.ts": "2017-03-21 22:59:28", "room_type.title": "Library" }, "86": { "real_estate_x_room_type.id": 86, "real_estate.id": 263, "real_estate.ts": "2017-03-21 22:59:42", "real_estate.title": "1807 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17884000000000099817043519578874111175537109375, "real_estate.longitude": -118.1132730000000066183929448015987873077392578125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,865", "building_address.id": 1199, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1807 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "87": { "real_estate_x_room_type.id": 87, "real_estate.id": 263, "real_estate.ts": "2017-03-21 22:59:42", "real_estate.title": "1807 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17884000000000099817043519578874111175537109375, "real_estate.longitude": -118.1132730000000066183929448015987873077392578125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,865", "building_address.id": 1199, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1807 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "90": { "real_estate_x_room_type.id": 90, "real_estate.id": 263, "real_estate.ts": "2017-03-21 22:59:42", "real_estate.title": "1807 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17884000000000099817043519578874111175537109375, "real_estate.longitude": -118.1132730000000066183929448015987873077392578125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,865", "building_address.id": 1199, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1807 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "88": { "real_estate_x_room_type.id": 88, "real_estate.id": 263, "real_estate.ts": "2017-03-21 22:59:42", "real_estate.title": "1807 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17884000000000099817043519578874111175537109375, "real_estate.longitude": -118.1132730000000066183929448015987873077392578125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,865", "building_address.id": 1199, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1807 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" }, "89": { "real_estate_x_room_type.id": 89, "real_estate.id": 263, "real_estate.ts": "2017-03-21 22:59:42", "real_estate.title": "1807 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17884000000000099817043519578874111175537109375, "real_estate.longitude": -118.1132730000000066183929448015987873077392578125, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,865", "building_address.id": 1199, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1807 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 32, "room_type.ts": "2017-03-21 22:33:28", "room_type.title": "Laundry room" }, "91": { "real_estate_x_room_type.id": 91, "real_estate.id": 265, "real_estate.ts": "2017-03-21 23:00:12", "real_estate.title": "2155 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1757530000000002701199264265596866607666015625, "real_estate.longitude": -118.107483000000001993612386286258697509765625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "2,642", "building_address.id": 1201, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2155 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "92": { "real_estate_x_room_type.id": 92, "real_estate.id": 265, "real_estate.ts": "2017-03-21 23:00:12", "real_estate.title": "2155 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1757530000000002701199264265596866607666015625, "real_estate.longitude": -118.107483000000001993612386286258697509765625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 3, "real_estate.sqft": "2,642", "building_address.id": 1201, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2155 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "94": { "real_estate_x_room_type.id": 94, "real_estate.id": 266, "real_estate.ts": "2017-03-21 23:00:25", "real_estate.title": "2080 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1760110000000025820554583333432674407958984375, "real_estate.longitude": -118.10912899999999581268639303743839263916015625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "3,223", "building_address.id": 1202, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2080 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "93": { "real_estate_x_room_type.id": 93, "real_estate.id": 266, "real_estate.ts": "2017-03-21 23:00:25", "real_estate.title": "2080 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.1760110000000025820554583333432674407958984375, "real_estate.longitude": -118.10912899999999581268639303743839263916015625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "3,223", "building_address.id": 1202, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2080 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 82, "room_type.ts": "2017-03-21 22:59:28", "room_type.title": "Library" }, "95": { "real_estate_x_room_type.id": 95, "real_estate.id": 269, "real_estate.ts": "2017-03-21 23:00:54", "real_estate.title": "2545 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17489499999999935653249849565327167510986328125, "real_estate.longitude": -118.0995640000000008740244084037840366363525390625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,560", "building_address.id": 1205, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2545 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "96": { "real_estate_x_room_type.id": 96, "real_estate.id": 269, "real_estate.ts": "2017-03-21 23:00:54", "real_estate.title": "2545 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17489499999999935653249849565327167510986328125, "real_estate.longitude": -118.0995640000000008740244084037840366363525390625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,560", "building_address.id": 1205, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2545 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "97": { "real_estate_x_room_type.id": 97, "real_estate.id": 269, "real_estate.ts": "2017-03-21 23:00:54", "real_estate.title": "2545 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17489499999999935653249849565327167510986328125, "real_estate.longitude": -118.0995640000000008740244084037840366363525390625, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,560", "building_address.id": 1205, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "2545 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 15, "room_type.ts": "2017-03-21 22:24:58", "room_type.title": "Office" }, "98": { "real_estate_x_room_type.id": 98, "real_estate.id": 270, "real_estate.ts": "2017-03-21 23:00:58", "real_estate.title": "1489 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17878999999999933834260446019470691680908203125, "real_estate.longitude": -118.1198380000000014433680917136371135711669921875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,594", "building_address.id": 1206, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1489 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 1, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Breakfast nook" }, "99": { "real_estate_x_room_type.id": 99, "real_estate.id": 270, "real_estate.ts": "2017-03-21 23:00:58", "real_estate.title": "1489 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.17878999999999933834260446019470691680908203125, "real_estate.longitude": -118.1198380000000014433680917136371135711669921875, "real_estate.bedrooms": 3, "real_estate.bathrooms": 2, "real_estate.sqft": "1,594", "building_address.id": 1206, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1489 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "100": { "real_estate_x_room_type.id": 100, "real_estate.id": 273, "real_estate.ts": "2017-03-21 23:01:37", "real_estate.title": "1963 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.177964000000002897650119848549365997314453125, "real_estate.longitude": -118.110104000000006863047019578516483306884765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "2,720", "building_address.id": 1209, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1963 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 2, "room_type.ts": "2017-03-21 21:58:40", "room_type.title": "Dining room" }, "103": { "real_estate_x_room_type.id": 103, "real_estate.id": 273, "real_estate.ts": "2017-03-21 23:01:37", "real_estate.title": "1963 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.177964000000002897650119848549365997314453125, "real_estate.longitude": -118.110104000000006863047019578516483306884765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "2,720", "building_address.id": 1209, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1963 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 4, "room_type.ts": "2017-03-21 22:13:40", "room_type.title": "Walk-in closet" }, "101": { "real_estate_x_room_type.id": 101, "real_estate.id": 273, "real_estate.ts": "2017-03-21 23:01:37", "real_estate.title": "1963 New York Dr, Altadena, CA 91001", "real_estate.latitude": 34.177964000000002897650119848549365997314453125, "real_estate.longitude": -118.110104000000006863047019578516483306884765625, "real_estate.bedrooms": 4, "real_estate.bathrooms": 3, "real_estate.sqft": "2,720", "building_address.id": 1209, "building_address.ts": "2017-03-08 06:42:43", "building_address.title": "1963 New York Dr Altadena, CA 91001", "building_address.street": "New York Dr", "street.id": 44, "street.ts": "2017-03-02 20:35:23", "street.title": "New York Dr", "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", "room_type.id": 10, "room_type.ts": "2017-03-21 22:22:30", "room_type.title": "Family room" } } } }