{"Id":544379,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7058165","MLSAGENTID":"NST506019258","MLSOFFICEID":"NST26348","ADDRESS":"95 Rose Avenue W","ACRES":0.174,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Finished","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick","FORECLOSURE":"No","LASTPRICE":299000.0,"LASTPRICEDATE":"2026-07-20T02:38:05.707","LATITUDE":44.976673,"LENDEROWNED":"No","LISTDATE":"2026-04-20T05:00:00","LISTPRICE":289000.0,"LIVINGAREA":1538.0,"LONGITUDE":-93.104035,"MODIFICATIONTIMESTAMP":"2026-07-20T02:38:05.707","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Partners Realty Inc.","PHOTOCOUNT":14,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this spacious and well-maintained home featuring 3 bedrooms and 2 bathrooms, along with additional rooms that offer flexibility for a home office, guest space, or other uses.\n\nRecent updates include new windows (2024) and a new roof (2025), providing added value and peace of mind.\n\nThis property offers excellent versatility to fit your lifestyle—whether you need extra living space, work-from-home options, or potential rental opportunities. Conveniently located with easy access to local amenities, shopping, and transportation.\n\nDon’t miss this opportunity to own a wonderful home in a desirable area!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-20T16:49:06.927","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Rose","STREETNUMBER":"95","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1950,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-20T16:49:06.928","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"3D7A9000.JPG\"},{\"Order\":2,\"Remarks\":\"3D7A9018.JPG\"},{\"Order\":3,\"Remarks\":\"3D7A9027.JPG\"},{\"Order\":4,\"Remarks\":\"3D7A9029.JPG\"},{\"Order\":5,\"Remarks\":\"3D7A9041.JPG\"},{\"Order\":6,\"Remarks\":\"3D7A9047.JPG\"},{\"Order\":7,\"Remarks\":\"3D7A9049.JPG\"},{\"Order\":8,\"Remarks\":\"3D7A9051.JPG\"},{\"Order\":9,\"Remarks\":\"3D7A9058.JPG\"},{\"Order\":10,\"Remarks\":\"3D7A9063.JPG\"},{\"Order\":11,\"Remarks\":\"3D7A9064.JPG\"},{\"Order\":12,\"Remarks\":\"3D7A9067.JPG\"},{\"Order\":13,\"Remarks\":\"3D7A9071.JPG\"},{\"Order\":14,\"Remarks\":\"3D7A9072.JPG\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7887778","NST_AboveGradeSqFtTotal":"1003","AboveGradeFinishedArea":"1003","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s)","Appliances":"Dryer,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Egress Window(s),Finished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"535","BelowGradeFinishedArea":"535","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Brick","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Ductless Mini-Split","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"Near Soccer Filed by Double Dragan Food Market","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Other","ExteriorFeatures":"Stone","Fencing":"Other,Wood","FireplaceFeatures":"Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1538","FoundationDetails":"Block","NST_FoundationDimensions":"1538","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"311","GarageSpaces":"1","Heating":"Hot Water","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.976673","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One","ListPrice":"289000","ListingContractDate":"2026-04-20T05:00:00Z","ListingId":"NST7058165","LivingArea":"1538","Longitude":"-93.104035","LotSizeArea":"0.174","LotSizeDimensions":"7600","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1003","NST_ManufacturedHome":"N","NST_NeighborhoodName":"North End","NST_NeighborhoodNumber":"97","OriginalEntryTimestamp":"2026-04-20T11:47:28Z","ParcelNumber":"302922220018","ParkingFeatures":"Attached Garage","PhotosCount":"14","PhotosChangeTimestamp":"2026-04-20T16:49:06.928Z","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to this spacious and well-maintained home featuring 3 bedrooms and 2 bathrooms, along with additional rooms that offer flexibility for a home office, guest space, or other uses.\n\nRecent updates include new windows (2024) and a new roof (2025), providing added value and peace of mind.\n\nThis property offers excellent versatility to fit your lifestyle—whether you need extra living space, work-from-home options, or potential rental opportunities. Conveniently located with easy access to local amenities, shopping, and transportation.\n\nDon’t miss this opportunity to own a wonderful home in a desirable area!","PublicSurveyRange":"22","PublicSurveySection":"30","PublicSurveyTownship":"29","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"W","StreetName":"Rose","StreetNumber":"95","StreetNumberNumeric":"95","StreetSuffix":"Avenue","SubdivisionName":"Stinsons Rice Street, Addition","TaxAnnualAmount":"3644","NST_TaxWithAssessments":"3644","TaxYear":"2026","NST_TotalArea":"1538","BuildingAreaTotal":"1538","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1950","ZoningDescription":"Residential-Single Family","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","ListAgentKey":"NST506481","ListAgentMlsId":"NST506019258","ListOfficeMlsId":"NST26348","ListOfficeName":"Partners Realty Inc.","ListOfficeKey":"NST26348","ModificationTimestamp":"2026-07-20T02:38:05.707Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"3D7A9072.JPG\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/29206198-c848-460b-94c3-6b0b9438f0a5.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636005\"},{\"LongDescription\":\"3D7A9047.JPG\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/a8f7ecf6-5cb1-4e63-b911-4f92bcd7205b.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636013\"},{\"LongDescription\":\"3D7A9041.JPG\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/ba4586da-8c4e-4e6e-8ea3-6b67893caf16.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636014\"},{\"LongDescription\":\"3D7A9051.JPG\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/32ce2e8b-4cc9-4aec-867a-d35529c3821c.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636011\"},{\"LongDescription\":\"3D7A9063.JPG\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/6e69ea08-e6bd-482b-9cbd-057a36398524.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.272Z\",\"MediaKey\":\"NST121636009\"},{\"LongDescription\":\"3D7A9071.JPG\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/ade7aecb-539a-429b-b814-7082e786d206.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636006\"},{\"LongDescription\":\"3D7A9058.JPG\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/a41ba304-1276-4002-b275-662a22702c86.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636010\"},{\"LongDescription\":\"3D7A9067.JPG\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/6ac8a17f-70f4-4c22-a889-2c611a85fc72.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.361Z\",\"MediaKey\":\"NST121636007\"},{\"LongDescription\":\"3D7A9029.JPG\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/878da04f-b500-4532-a166-c689f371354a.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.312Z\",\"MediaKey\":\"NST121636015\"},{\"LongDescription\":\"3D7A9027.JPG\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/a486fec9-2c90-461b-b537-7a15f0c1127b.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636016\"},{\"LongDescription\":\"3D7A9049.JPG\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/5f9d291a-1e88-4ef6-8f4e-fa5a3f371022.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636012\"},{\"LongDescription\":\"3D7A9064.JPG\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/72be4924-5e8c-4b62-8995-47a3f8175d5b.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.285Z\",\"MediaKey\":\"NST121636008\"},{\"LongDescription\":\"3D7A9018.JPG\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/4af8bad8-ccd9-4f77-8974-00bae76c01b9.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.308Z\",\"MediaKey\":\"NST121636019\"},{\"LongDescription\":\"3D7A9000.JPG\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887778/e8a0c0e6-4106-4613-a119-ae5a5bbdd383.jpeg\",\"ResourceRecordKey\":\"NST7887778\",\"ImageWidth\":2080,\"ImageHeight\":1561,\"ImageSizeDescription\":\"2080x1561\",\"MediaModificationTimestamp\":\"2026-04-20T16:48:14.336Z\",\"MediaKey\":\"NST121636021\"}]","Media__LongDescription":"3D7A9072.JPG","Media__Order":"14","Media__MediaObjectID":"NST14","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7887778/29206198-c848-460b-94c3-6b0b9438f0a5.jpeg","Media__ResourceRecordKey":"NST7887778","Media__ImageWidth":"2080","Media__ImageHeight":"1561","Media__ImageSizeDescription":"2080x1561","Media__MediaModificationTimestamp":"4/20/2026 4:48:14 PM","Media__MediaKey":"NST121636005","DocumentsChangeTimestamp":"2026-04-20T16:48:07.411Z","Rooms":"[{\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST116135909\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4},{\"RoomDimensions\":\"10x15\",\"RoomKey\":\"NST116135908\",\"RoomType\":\"Four Season Porch\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":3},{\"RoomDimensions\":\"15x10\",\"RoomKey\":\"NST116135907\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomDimensions\":\"25x20\",\"RoomKey\":\"NST116135906\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomDimensions\":\"15x19\",\"RoomKey\":\"NST116135912\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":7},{\"RoomDimensions\":\"13x10\",\"RoomKey\":\"NST116135910\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5},{\"RoomDimensions\":\"10x9\",\"RoomKey\":\"NST116135911\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6}]","Rooms__RoomDimensions":"13x11","Rooms__RoomKey":"NST116135909","Rooms__RoomType":"Bedroom","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"4","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"3D7A9000.JPG\"},{\"Order\":2,\"Remarks\":\"3D7A9018.JPG\"},{\"Order\":3,\"Remarks\":\"3D7A9027.JPG\"},{\"Order\":4,\"Remarks\":\"3D7A9029.JPG\"},{\"Order\":5,\"Remarks\":\"3D7A9041.JPG\"},{\"Order\":6,\"Remarks\":\"3D7A9047.JPG\"},{\"Order\":7,\"Remarks\":\"3D7A9049.JPG\"},{\"Order\":8,\"Remarks\":\"3D7A9051.JPG\"},{\"Order\":9,\"Remarks\":\"3D7A9058.JPG\"},{\"Order\":10,\"Remarks\":\"3D7A9063.JPG\"},{\"Order\":11,\"Remarks\":\"3D7A9064.JPG\"},{\"Order\":12,\"Remarks\":\"3D7A9067.JPG\"},{\"Order\":13,\"Remarks\":\"3D7A9071.JPG\"},{\"Order\":14,\"Remarks\":\"3D7A9072.JPG\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}