{"rows":[{"cartodb_id":2070,"the_geom":"0101000020E6100000F41403760CC752C04DBAF7FA37FF4340","the_geom_webmercator":"0101000020110F00006FBACC8241E55FC1FA2649D2078F5241","assessment_date":"2026-04-29T15:40:04Z","basements":"C","beginning_point":"253'2 7/8\" E EMERALD","book_and_page":"54588176","building_code":"H50","building_code_description":"SEMI/DET 3 STY MASONRY","category_code":"1","category_code_description":"SINGLE FAMILY","census_tract":"188","central_air":"N","cross_reference":null,"date_exterior_condition":null,"depth":100,"exempt_building":0,"exempt_land":0,"exterior_condition":"7","fireplaces":0,"frontage":27,"fuel":"A","garage_spaces":0,"garage_type":"0","general_construction":"A","geographic_ward":"45","homestead_exemption":0,"house_extension":null,"house_number":"2024","interior_condition":"7","location":"2024 E MADISON ST","mailing_address_1":"U S BANK TRUST NATIONAL ASSOCIATION TR","mailing_address_2":null,"mailing_care_of":null,"mailing_city_state":"ST PAUL MN","mailing_street":"60 LIVINGTON AVE EP-MN-WS3D","mailing_zip":"55107","market_value":143200,"market_value_date":null,"number_of_bathrooms":2,"number_of_bedrooms":5,"number_of_rooms":null,"number_stories":3,"off_street_open":897,"other_building":null,"owner_1":"U S BANK TRUST NATIONAL ASSOCIATION TR","owner_2":"LEGACY MORTGAGE ASSET TRUST 2024-INV1","parcel_number":"452014710","parcel_shape":"E","quality_grade":"B","recording_date":"2026-08-20T04:00:00Z","registry_number":"024N120247","sale_date":"2026-08-04T04:00:00Z","sale_price":11800,"separate_utilities":null,"sewer":null,"site_type":null,"state_code":"MN","street_code":"52840","street_designation":"ST","street_direction":"E","street_name":"MADISON","suffix":null,"taxable_building":114560,"taxable_land":28640,"topography":"F","total_area":2689,"total_livable_area":2430,"type_heater":"B","unfinished":null,"unit":null,"utility":null,"view_type":"I","year_built":"1900","year_built_estimate":"Y","zip_code":"19134","zoning":"RSA5","pin":1001341155,"building_code_new":"32","building_code_description_new":"TWIN CONVENTIONAL","gdb_geomattr_data":null,"objectid":2043}],"time":0.003,"fields":{"cartodb_id":{"type":"number","pgtype":"int8"},"the_geom":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":4326},"the_geom_webmercator":{"type":"geometry","wkbtype":"Unknown","dims":2,"srid":3857},"assessment_date":{"type":"date","pgtype":"timestamptz"},"basements":{"type":"string","pgtype":"varchar"},"beginning_point":{"type":"string","pgtype":"varchar"},"book_and_page":{"type":"string","pgtype":"varchar"},"building_code":{"type":"string","pgtype":"varchar"},"building_code_description":{"type":"string","pgtype":"varchar"},"category_code":{"type":"string","pgtype":"varchar"},"category_code_description":{"type":"string","pgtype":"varchar"},"census_tract":{"type":"string","pgtype":"varchar"},"central_air":{"type":"string","pgtype":"varchar"},"cross_reference":{"type":"string","pgtype":"varchar"},"date_exterior_condition":{"type":"date","pgtype":"timestamptz"},"depth":{"type":"number","pgtype":"numeric"},"exempt_building":{"type":"number","pgtype":"numeric"},"exempt_land":{"type":"number","pgtype":"numeric"},"exterior_condition":{"type":"string","pgtype":"varchar"},"fireplaces":{"type":"number","pgtype":"int4"},"frontage":{"type":"number","pgtype":"numeric"},"fuel":{"type":"string","pgtype":"varchar"},"garage_spaces":{"type":"number","pgtype":"int4"},"garage_type":{"type":"string","pgtype":"varchar"},"general_construction":{"type":"string","pgtype":"varchar"},"geographic_ward":{"type":"string","pgtype":"varchar"},"homestead_exemption":{"type":"number","pgtype":"int4"},"house_extension":{"type":"string","pgtype":"varchar"},"house_number":{"type":"string","pgtype":"varchar"},"interior_condition":{"type":"string","pgtype":"varchar"},"location":{"type":"string","pgtype":"varchar"},"mailing_address_1":{"type":"string","pgtype":"varchar"},"mailing_address_2":{"type":"string","pgtype":"varchar"},"mailing_care_of":{"type":"string","pgtype":"varchar"},"mailing_city_state":{"type":"string","pgtype":"varchar"},"mailing_street":{"type":"string","pgtype":"varchar"},"mailing_zip":{"type":"string","pgtype":"varchar"},"market_value":{"type":"number","pgtype":"numeric"},"market_value_date":{"type":"date","pgtype":"timestamptz"},"number_of_bathrooms":{"type":"number","pgtype":"int4"},"number_of_bedrooms":{"type":"number","pgtype":"int4"},"number_of_rooms":{"type":"number","pgtype":"int4"},"number_stories":{"type":"number","pgtype":"int4"},"off_street_open":{"type":"number","pgtype":"int4"},"other_building":{"type":"string","pgtype":"varchar"},"owner_1":{"type":"string","pgtype":"varchar"},"owner_2":{"type":"string","pgtype":"varchar"},"parcel_number":{"type":"string","pgtype":"varchar"},"parcel_shape":{"type":"string","pgtype":"varchar"},"quality_grade":{"type":"string","pgtype":"varchar"},"recording_date":{"type":"date","pgtype":"timestamptz"},"registry_number":{"type":"string","pgtype":"varchar"},"sale_date":{"type":"date","pgtype":"timestamptz"},"sale_price":{"type":"number","pgtype":"numeric"},"separate_utilities":{"type":"string","pgtype":"varchar"},"sewer":{"type":"string","pgtype":"varchar"},"site_type":{"type":"string","pgtype":"varchar"},"state_code":{"type":"string","pgtype":"varchar"},"street_code":{"type":"string","pgtype":"varchar"},"street_designation":{"type":"string","pgtype":"varchar"},"street_direction":{"type":"string","pgtype":"varchar"},"street_name":{"type":"string","pgtype":"varchar"},"suffix":{"type":"string","pgtype":"varchar"},"taxable_building":{"type":"number","pgtype":"numeric"},"taxable_land":{"type":"number","pgtype":"numeric"},"topography":{"type":"string","pgtype":"varchar"},"total_area":{"type":"number","pgtype":"numeric"},"total_livable_area":{"type":"number","pgtype":"numeric"},"type_heater":{"type":"string","pgtype":"varchar"},"unfinished":{"type":"string","pgtype":"varchar"},"unit":{"type":"string","pgtype":"varchar"},"utility":{"type":"string","pgtype":"varchar"},"view_type":{"type":"string","pgtype":"varchar"},"year_built":{"type":"string","pgtype":"varchar"},"year_built_estimate":{"type":"string","pgtype":"varchar"},"zip_code":{"type":"string","pgtype":"varchar"},"zoning":{"type":"string","pgtype":"varchar"},"pin":{"type":"number","pgtype":"int4"},"building_code_new":{"type":"string","pgtype":"varchar"},"building_code_description_new":{"type":"string","pgtype":"varchar"},"gdb_geomattr_data":{"type":"bytea","pgtype":"bytea"},"objectid":{"type":"number","pgtype":"int4"}},"total_rows":1}