{"Id":572130,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7092375","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"1587 Hudson Road","ACRES":0.247,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":291000.0,"LASTPRICEDATE":"2026-06-12T23:01:10.8","LATITUDE":44.952791,"LENDEROWNED":"No","LISTDATE":"2026-06-12T05:00:00","LISTPRICE":291000.0,"LIVINGAREA":1702.0,"LONGITUDE":-93.033332,"MODIFICATIONTIMESTAMP":"2026-06-13T09:21:12.882","NEIGHBORHOOD":"88","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":17,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"1587 Hudson Rd is a one-story St.1587 Hudson Rd is a one-story St. Paul home with a functional layout and comfortable living spaces throughout. A fireplace serves as a warm focal point within the main living area, adding ambiance and character to the interior. Clean interior finishes and updated flooring carry through the home, creating a well-maintained and move-in ready aesthetic. A two-car garage provides secure parking and additional storage. This residence balances everyday comfort with practical design, creating distinct spaces for gathering, relaxing, and everyday living throughout every room. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-12T23:01:10.8","LASTSTATUS":"Active","STREETNAME":"Hudson","STREETNUMBER":"1587","STREETSUFFIX":"Road","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1957,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-06-12T23:00:07.249","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"listing_16.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7917695","NST_AboveGradeSqFtTotal":"1022","AboveGradeFinishedArea":"1022","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"680","BelowGradeFinishedArea":"680","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Head south on White Bear Ave.\nTurn right onto Old Hudson Rd.\nTurn left.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-06-12T22:59:06.244Z","DaysOnMarket":"0","ExteriorFeatures":"Brick Veneer,Vinyl","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1022","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"624","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.952791","NST_LenderOwned":"No","Levels":"One","ListPrice":"291000","ListingContractDate":"2026-06-12T05:00:00Z","ListingId":"NST7092375","LivingArea":"1702","Longitude":"-93.033332","LotSizeArea":"0.247","LotSizeDimensions":"60 x 128","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1022","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Battle Creek-Highwood","NST_NeighborhoodNumber":"88","OriginalEntryTimestamp":"2026-06-12T17:58:31Z","ParcelNumber":"342922420132","ParkingFeatures":"Detached Garage","PhotosCount":"17","PhotosChangeTimestamp":"2026-06-12T23:00:07.249Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"1587 Hudson Rd is a one-story St.1587 Hudson Rd is a one-story St. Paul home with a functional layout and comfortable living spaces throughout. A fireplace serves as a warm focal point within the main living area, adding ambiance and character to the interior. Clean interior finishes and updated flooring carry through the home, creating a well-maintained and move-in ready aesthetic. A two-car garage provides secure parking and additional storage. This residence balances everyday comfort with practical design, creating distinct spaces for gathering, relaxing, and everyday living throughout every room. This home has been virtually staged to illustrate its potential.. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"22","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Hudson","StreetNumber":"1587","StreetNumberNumeric":"1587","StreetSuffix":"Road","SubdivisionName":"Section 34 Town 29 Range 22","TaxAnnualAmount":"4524","NST_TaxWithAssessments":"4524","TaxYear":"2026","NST_TotalArea":"1702","BuildingAreaTotal":"1702","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1957","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeName":"Opendoor Brokerage, LLC","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-06-13T09:21:12.882Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"listing_10.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/39033c4a-05eb-432e-aaad-08c8f441a43c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.581Z\",\"MediaKey\":\"NST122938060\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"listing_6.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/0b19afbb-0f50-4cc8-958c-4f075554ab7d.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.597Z\",\"MediaKey\":\"NST122938064\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"listing_9.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/ce9feafc-8b61-4252-8ded-e6be8e3584aa.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.564Z\",\"MediaKey\":\"NST122938061\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"listing_5.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/d86e3409-8220-487f-90fa-4e6c881ea1b6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.597Z\",\"MediaKey\":\"NST122938065\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"listing_8.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/802bb0a6-4cc7-4609-9565-a990b8bcb6a2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.597Z\",\"MediaKey\":\"NST122938062\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"listing_13.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/8c5e84bd-1bc8-41a8-93b0-e3ee82bf9635.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.56Z\",\"MediaKey\":\"NST122938057\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"listing_4.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/10f10d47-78e6-4f13-a18b-f6e974a000a8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.64Z\",\"MediaKey\":\"NST122938066\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"listing_0.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/c754a08b-a428-43bd-91d3-8c27ad586439.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.575Z\",\"MediaKey\":\"NST122938070\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"VIRTUALLY STAGED\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/6a04cb2c-2ad2-477b-ac2e-88168aec48c3.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.566Z\",\"MediaKey\":\"NST122938069\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"listing_16.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/84b2103e-e214-4b11-b9ba-dbc265cc2a06.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.607Z\",\"MediaKey\":\"NST122938054\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"listing_7.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/63cf2f41-3ed3-416f-b4f5-2185115bfff1.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.559Z\",\"MediaKey\":\"NST122938063\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"listing_2.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/ce595ac5-536f-42d0-854b-0ea38ea6eae2.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.567Z\",\"MediaKey\":\"NST122938068\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"listing_12.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/d623fe19-d022-4a72-a20b-251ff7b18d82.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.564Z\",\"MediaKey\":\"NST122938058\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"VIRTUALLY STAGED\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/dae10244-9b35-4e8f-87f1-bee24218a59f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.596Z\",\"MediaKey\":\"NST122938067\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"listing_11.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/ef2ec09d-d9f3-4735-bfac-4041faa1d82f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.579Z\",\"MediaKey\":\"NST122938059\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"listing_14.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/9802ec71-2c8f-4434-80b1-006b6ba5ff3c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.612Z\",\"MediaKey\":\"NST122938056\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"listing_15.jpg\",\"ResourceRecordKey\":\"NST7917695\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917695/9bf4f8d6-c3d6-418f-80ad-a3a9fb01c368.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1552,\"ImageSizeDescription\":\"2080x1552\",\"MediaModificationTimestamp\":\"2026-06-12T22:59:11.65Z\",\"MediaKey\":\"NST122938055\"}]","Media__Order":"11","Media__MediaObjectID":"NST11","Media__LongDescription":"listing_10.jpg","Media__ResourceRecordKey":"NST7917695","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7917695/39033c4a-05eb-432e-aaad-08c8f441a43c.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1552","Media__ImageSizeDescription":"2080x1552","Media__MediaModificationTimestamp":"6/12/2026 10:59:11 PM","Media__MediaKey":"NST122938060","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"VIRTUALLY STAGED\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"listing_16.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}