{"Id":560050,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7077582","MLSAGENTID":"NST506018748","MLSCOAGENTID":"NST506020343","MLSOFFICEID":"NST29547","ADDRESS":"256 Rose Avenue W","ACRES":0.08,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":199900.0,"LASTPRICEDATE":"2026-05-20T14:49:07.88","LATITUDE":44.976281,"LENDEROWNED":"No","LISTDATE":"2026-05-20T05:00:00","LISTPRICE":199900.0,"LIVINGAREA":1260.0,"LONGITUDE":-93.11083,"MODIFICATIONTIMESTAMP":"2026-05-20T16:03:09.519","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Home Sellers","PHOTOCOUNT":17,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"New carpet, new floor, new paint ready for a new owner. Close to Como Lake for walking/biking, shopping and grocery. Can accommodate a quick close! Don't miss this one!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-20T14:49:07.88","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Rose","STREETNUMBER":"256","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1889,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-20T15:22:07.988","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1-print-256_Rose_Ave_W_Saint_Paul_MN_024.jpg\"},{\"Order\":2,\"Remarks\":\"4-print-256_Rose_Ave_W_Saint_Paul_MN_026.jpg\"},{\"Order\":3,\"Remarks\":\"3-print-256_Rose_Ave_W_Saint_Paul_MN_023.jpg\"},{\"Order\":4,\"Remarks\":\"6-print-256_Rose_Ave_W_Saint_Paul_MN_028.jpg\"},{\"Order\":5,\"Remarks\":\"8-print-256_Rose_Ave_W_Saint_Paul_MN_001.jpg\"},{\"Order\":6,\"Remarks\":\"11-print-256_Rose_Ave_W_Saint_Paul_MN_004.jpg\"},{\"Order\":7,\"Remarks\":\"14-print-256_Rose_Ave_W_Saint_Paul_MN_007.jpg\"},{\"Order\":8,\"Remarks\":\"12-print-256_Rose_Ave_W_Saint_Paul_MN_005.jpg\"},{\"Order\":9,\"Remarks\":\"17-print-256_Rose_Ave_W_Saint_Paul_MN_010.jpg\"},{\"Order\":10,\"Remarks\":\"18-print-256_Rose_Ave_W_Saint_Paul_MN_011.jpg\"},{\"Order\":11,\"Remarks\":\"19-print-256_Rose_Ave_W_Saint_Paul_MN_012.jpg\"},{\"Order\":12,\"Remarks\":\"9-print-256_Rose_Ave_W_Saint_Paul_MN_002.jpg\"},{\"Order\":13,\"Remarks\":\"23-print-256_Rose_Ave_W_Saint_Paul_MN_016.jpg\"},{\"Order\":14,\"Remarks\":\"30-print-256_Rose_Ave_W_Saint_Paul_MN_030.jpg\"},{\"Order\":15,\"Remarks\":\"24-print-256_Rose_Ave_W_Saint_Paul_MN_017.jpg\"},{\"Order\":16,\"Remarks\":\"28-print-256_Rose_Ave_W_Saint_Paul_MN_021.jpg\"},{\"Order\":17,\"Remarks\":\"27-print-256_Rose_Ave_W_Saint_Paul_MN_020.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7904762","NST_AboveGradeSqFtTotal":"1085","AboveGradeFinishedArea":"1260","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"253","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","Directions":"Hwy 35E to Maryland (west) to Marion (south) to Rose Ave (west)","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-05-20T16:03:09.519Z","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"253","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Baseboard","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.976281","NST_LenderOwned":"No","Levels":"Two","ListPrice":"199900","ListingContractDate":"2026-05-20T05:00:00Z","ListingId":"NST7077582","LivingArea":"1260","LockBoxType":"Combo","Longitude":"-93.11083","LotSizeArea":"0.08","LotSizeDimensions":"45x78","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"653","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"97","OriginalEntryTimestamp":"2026-05-20T09:46:02Z","ParcelNumber":"252923110079","ParkingFeatures":"On-Street Parking Only","PhotosCount":"17","PhotosChangeTimestamp":"2026-05-20T15:22:07.988Z","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"New carpet, new floor, new paint ready for a new owner. Close to Como Lake for walking/biking, shopping and grocery. Can accommodate a quick close! Don't miss this one!","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"29","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"W","StreetName":"Rose","StreetNumber":"256","StreetNumberNumeric":"256","StreetSuffix":"Avenue","SubdivisionName":"Auerbach & Hands Addition, To","TaxAnnualAmount":"2284","NST_TaxWithAssessments":"2284","TaxYear":"2025","BuildingAreaTotal":"1338","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1889","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST518098","CoListAgentMlsId":"NST506020343","CoListOfficeName":"Home Sellers","ListAgentKey":"NST504404","ListAgentMlsId":"NST506018748","ListOfficeMlsId":"NST29547","ListOfficeName":"Home Sellers","ListOfficeKey":"NST29547","ModificationTimestamp":"2026-05-20T16:03:09.519Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"28-print-256_Rose_Ave_W_Saint_Paul_MN_021.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/60ad37e8-e6a3-4586-879c-042d11e88808.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.937Z\",\"MediaKey\":\"NST122359501\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"30-print-256_Rose_Ave_W_Saint_Paul_MN_030.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/ec3882d9-ab97-4c82-9cbd-122ff0bee2ce.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.84Z\",\"MediaKey\":\"NST122359500\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"3-print-256_Rose_Ave_W_Saint_Paul_MN_023.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/dc67ca57-6a56-47cf-8ae0-5cd82af5c481.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T14:49:10.053Z\",\"MediaKey\":\"NST122359518\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"11-print-256_Rose_Ave_W_Saint_Paul_MN_004.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/2fbb64e8-f0cd-455e-8317-80ea9cbb6523.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.887Z\",\"MediaKey\":\"NST122359511\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"9-print-256_Rose_Ave_W_Saint_Paul_MN_002.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/653b75fc-4d3a-48aa-bde3-e6ceda687ae1.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.825Z\",\"MediaKey\":\"NST122359513\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"17-print-256_Rose_Ave_W_Saint_Paul_MN_010.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/51bf980f-b226-4653-bf9f-96138727da9a.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.929Z\",\"MediaKey\":\"NST122359508\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"23-print-256_Rose_Ave_W_Saint_Paul_MN_016.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/5aed280e-30b7-4deb-a6b4-4c1ffd8180f5.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.833Z\",\"MediaKey\":\"NST122359505\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"19-print-256_Rose_Ave_W_Saint_Paul_MN_012.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/fcb012ae-87e1-4f3d-b83b-8aacb79d82d7.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.827Z\",\"MediaKey\":\"NST122359506\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"24-print-256_Rose_Ave_W_Saint_Paul_MN_017.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/d0cd66ab-c591-443c-8063-ad6c697099a4.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.823Z\",\"MediaKey\":\"NST122359504\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"27-print-256_Rose_Ave_W_Saint_Paul_MN_020.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/336af96f-26b0-4c30-aa2a-8e0d8cdba1f3.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.83Z\",\"MediaKey\":\"NST122359502\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"8-print-256_Rose_Ave_W_Saint_Paul_MN_001.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/9833b285-fc77-4272-b050-191bc21fee86.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.834Z\",\"MediaKey\":\"NST122359848\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"1-print-256_Rose_Ave_W_Saint_Paul_MN_024.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/4ee2e7fe-5619-4872-88f8-9e9ab33f9e56.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T14:49:10.038Z\",\"MediaKey\":\"NST122359520\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"14-print-256_Rose_Ave_W_Saint_Paul_MN_007.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/894b38c1-d221-4293-920f-c157ecdace46.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.846Z\",\"MediaKey\":\"NST122359509\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"12-print-256_Rose_Ave_W_Saint_Paul_MN_005.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/3f17cd9e-b7d5-49eb-abaa-f80406873392.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.865Z\",\"MediaKey\":\"NST122359510\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"6-print-256_Rose_Ave_W_Saint_Paul_MN_028.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/df179ed1-9d05-485e-9ce6-800d5a2aa9db.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T14:50:06.361Z\",\"MediaKey\":\"NST122359516\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"18-print-256_Rose_Ave_W_Saint_Paul_MN_011.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/3059ffb2-0d53-4f35-9d3b-b7a54258bc58.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T15:21:10.832Z\",\"MediaKey\":\"NST122359507\"},{\"ResourceRecordKey\":\"NST7904762\",\"LongDescription\":\"4-print-256_Rose_Ave_W_Saint_Paul_MN_026.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904762/3318a907-9f4f-4a5e-b199-bc5180d1c848.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-05-20T14:49:10.038Z\",\"MediaKey\":\"NST122359517\"}]","Media__ResourceRecordKey":"NST7904762","Media__LongDescription":"28-print-256_Rose_Ave_W_Saint_Paul_MN_021.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7904762/60ad37e8-e6a3-4586-879c-042d11e88808.jpeg","Media__Order":"16","Media__MediaObjectID":"NST16","Media__ImageWidth":"2080","Media__ImageHeight":"1388","Media__ImageSizeDescription":"2080x1388","Media__MediaModificationTimestamp":"5/20/2026 3:21:10 PM","Media__MediaKey":"NST122359501","Rooms":"[{\"RoomType\":\"Bathroom\",\"RoomDimensions\":\"7x13\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116257851\"},{\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"8x13\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116257847\"},{\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"8x10\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116257849\"},{\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116257848\"},{\"RoomType\":\"Living Room\",\"RoomDimensions\":\"17x13\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116257846\"},{\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116257850\"}]","Rooms__RoomType":"Bathroom","Rooms__RoomDimensions":"7x13","Rooms__NST_RoomSortOrder":"6","Rooms__RoomLevel":"Upper","Rooms__RoomKey":"NST116257851","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1-print-256_Rose_Ave_W_Saint_Paul_MN_024.jpg\"},{\"Order\":2,\"Remarks\":\"4-print-256_Rose_Ave_W_Saint_Paul_MN_026.jpg\"},{\"Order\":3,\"Remarks\":\"3-print-256_Rose_Ave_W_Saint_Paul_MN_023.jpg\"},{\"Order\":4,\"Remarks\":\"6-print-256_Rose_Ave_W_Saint_Paul_MN_028.jpg\"},{\"Order\":5,\"Remarks\":\"8-print-256_Rose_Ave_W_Saint_Paul_MN_001.jpg\"},{\"Order\":6,\"Remarks\":\"11-print-256_Rose_Ave_W_Saint_Paul_MN_004.jpg\"},{\"Order\":7,\"Remarks\":\"14-print-256_Rose_Ave_W_Saint_Paul_MN_007.jpg\"},{\"Order\":8,\"Remarks\":\"12-print-256_Rose_Ave_W_Saint_Paul_MN_005.jpg\"},{\"Order\":9,\"Remarks\":\"17-print-256_Rose_Ave_W_Saint_Paul_MN_010.jpg\"},{\"Order\":10,\"Remarks\":\"18-print-256_Rose_Ave_W_Saint_Paul_MN_011.jpg\"},{\"Order\":11,\"Remarks\":\"19-print-256_Rose_Ave_W_Saint_Paul_MN_012.jpg\"},{\"Order\":12,\"Remarks\":\"9-print-256_Rose_Ave_W_Saint_Paul_MN_002.jpg\"},{\"Order\":13,\"Remarks\":\"23-print-256_Rose_Ave_W_Saint_Paul_MN_016.jpg\"},{\"Order\":14,\"Remarks\":\"30-print-256_Rose_Ave_W_Saint_Paul_MN_030.jpg\"},{\"Order\":15,\"Remarks\":\"24-print-256_Rose_Ave_W_Saint_Paul_MN_017.jpg\"},{\"Order\":16,\"Remarks\":\"28-print-256_Rose_Ave_W_Saint_Paul_MN_021.jpg\"},{\"Order\":17,\"Remarks\":\"27-print-256_Rose_Ave_W_Saint_Paul_MN_020.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}