{"Id":543822,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7057749","MLSAGENTID":"NST502046527","MLSOFFICEID":"NST20530","ADDRESS":"2800 Hamline Avenue N","ACRES":0.016,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":1.0,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick","FORECLOSURE":"No","LASTPRICE":165000.0,"LASTPRICEDATE":"2026-04-18T00:54:06.593","LATITUDE":45.02611322,"LENDEROWNED":"No","LISTDATE":"2026-04-17T05:00:00","LISTPRICE":165000.0,"LIVINGAREA":710.0,"LONGITUDE":-93.15610329,"MODIFICATIONTIMESTAMP":"2026-04-18T09:07:08.086","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":18,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Introducing your dream condo! This stunning unit features 1 bed, 1 bath, and a convenient parking stall. Step into modern luxury with stainless steel appliances, sleek newer cabinets, and stylish vinyl flooring throughout. Enjoy the ease of ground-floor living with direct access to your private patio, perfect for relaxing or entertaining. Don't miss out on the impeccable blend of comfort and convenience.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Flat","SCHOOLDISTRICTNUMBER":"2096-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-18T00:54:06.593","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hamline","STREETNUMBER":"2800","STREETSUFFIX":"Avenue","STYLE":"(CC) Low Rise (3- Levels)","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1969,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-18T00:54:06.593","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"2800HamlineAveN-9.jpg\"},{\"Order\":2,\"Remarks\":\"0X5A2417-HDR.jpg\"},{\"Order\":3,\"Remarks\":\"0X5A2420-HDR.jpg\"},{\"Order\":4,\"Remarks\":\"0X5A2423-HDR.jpg\"},{\"Order\":5,\"Remarks\":\"0X5A2414-HDR.jpg\"},{\"Order\":6,\"Remarks\":\"2800HamlineAveN-8.jpg\"},{\"Order\":7,\"Remarks\":\"2800HamlineAveN-7.jpg\"},{\"Order\":8,\"Remarks\":\"0X5A2411-HDR.jpg\"},{\"Order\":9,\"Remarks\":\"2800HamlineAveN-14.jpg\"},{\"Order\":10,\"Remarks\":\"2800HamlineAveN-13.jpg\"},{\"Order\":11,\"Remarks\":\"2800HamlineAveN-12.jpg\"},{\"Order\":12,\"Remarks\":\"2800HamlineAveN-10.jpg\"},{\"Order\":13,\"Remarks\":\"2800HamlineAveN-15.jpg\"},{\"Order\":14,\"Remarks\":\"GetMedia (10).jpeg\"},{\"Order\":15,\"Remarks\":\"GetMedia (9).jpeg\"},{\"Order\":16,\"Remarks\":\"435874242_3557675967880358_852791987015863092_n.jpg\"},{\"Order\":17,\"Remarks\":\"GetMedia (5).jpeg\"},{\"Order\":18,\"Remarks\":\"GetMedia (8).jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7887423","NST_AboveGradeSqFtTotal":"710","AboveGradeFinishedArea":"710","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Exercise Room,Intercom System,Patio,Security System,Tile Floors","Appliances":"Dishwasher,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationAmenities":"Car Wash,Elevator(s),Hot Tub,Lobby Entrance,Patio,Sauna,Security Building","AssociationFee":"508","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Controlled Access,Heating,Lawn Care,Maintenance Grounds,Parking,Professional Mgmt,Sanitation","AssociationName":"Compass Management","AssociationPhone":"6128884710","Basement":"None","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"1","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Roseville","ConstructionMaterials":"Brick","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Wall Unit(s),Window Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Hamline Ave., North of County Road C","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Circuit Breakers,100 Amp Service","FireplacesTotal":"0","FoundationArea":"710","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"1","Heating":"Hot Water","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0261132182","NST_LenderOwned":"No","Levels":"More Than 2 Stories","ListPrice":"165000","ListingContractDate":"2026-04-17T05:00:00Z","ListingId":"NST7057749","LivingArea":"710","LockBoxType":"Combo","Longitude":"-93.1561032921","LotSizeArea":"0.016","LotSizeDimensions":"COMMON","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"710","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-17T19:54:00Z","ParcelNumber":"032923420150","NST_SchoolDistrictNumber":"2096","ParkingFeatures":"Heated Garage,Insulated Garage,Underground","PhotosCount":"18","PhotosChangeTimestamp":"2026-04-18T00:54:06.593Z","PoolFeatures":"Below Ground","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) Low Rise (3- Levels)","PropertyType":"Residential","PublicRemarks":"Introducing your dream condo! This stunning unit features 1 bed, 1 bath, and a convenient parking stall. Step into modern luxury with stainless steel appliances, sleek newer cabinets, and stylish vinyl flooring throughout. Enjoy the ease of ground-floor living with direct access to your private patio, perfect for relaxing or entertaining. Don't miss out on the impeccable blend of comfort and convenience.","RoadFrontageType":"Curbs,Paved Streets,Private Road,Storm Sewer","RoadResponsibility":"Public Maintained Road","Roof":"Flat","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","NST_SharedRooms":"Amusement/Party Room,Exercise Room","NST_SpecialSearch":"All Living Facilities on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Hamline","StreetNumber":"2800","StreetNumberNumeric":"2800","StreetSuffix":"Avenue","SubdivisionName":"HAMLINE HOUSE CONDOMINIUMS","TaxAnnualAmount":"1850","NST_TaxWithAssessments":"1850","TaxYear":"2025","BuildingAreaTotal":"710","Township":"Roseville","UnitNumber":"130","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1969","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST106802","ListAgentMlsId":"NST502046527","ListOfficeMlsId":"NST20530","ListOfficeName":"RE/MAX Results","ListOfficeKey":"NST20530","ModificationTimestamp":"2026-04-18T09:07:08.086Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"0X5A2423-HDR.jpg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/6a8c2231-67b1-4722-8d04-125e2c693124.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":586,\"ImageSizeDescription\":\"1024x586\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.641Z\",\"MediaKey\":\"NST121611139\"},{\"LongDescription\":\"GetMedia (5).jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/18bf4dd2-2893-4cbd-8694-355b18a46794.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.633Z\",\"MediaKey\":\"NST121611126\"},{\"LongDescription\":\"2800HamlineAveN-15.jpg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/d7ebff68-a989-462f-8585-10661a992856.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.625Z\",\"MediaKey\":\"NST121611144\"},{\"LongDescription\":\"2800HamlineAveN-12.jpg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/1387d7a2-09df-4073-adfa-5f2d414c2024.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.649Z\",\"MediaKey\":\"NST121611134\"},{\"LongDescription\":\"0X5A2411-HDR.jpg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/9ac31fb1-11ea-42cf-9a00-f9cebdb4550f.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.624Z\",\"MediaKey\":\"NST121611136\"},{\"LongDescription\":\"0X5A2417-HDR.jpg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/27cd673e-ecb6-4334-95af-8d2496b0422e.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.631Z\",\"MediaKey\":\"NST121611141\"},{\"LongDescription\":\"2800HamlineAveN-8.jpg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/a53896ff-02da-4f24-85b0-81decad8cf45.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.64Z\",\"MediaKey\":\"NST121611138\"},{\"LongDescription\":\"2800HamlineAveN-7.jpg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/a529da66-e24c-4d29-8a85-0cc6a7b2764a.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.64Z\",\"MediaKey\":\"NST121611135\"},{\"LongDescription\":\"2800HamlineAveN-10.jpg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/c3811d70-990d-4296-9959-b270884cebb3.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.665Z\",\"MediaKey\":\"NST121611143\"},{\"LongDescription\":\"GetMedia (8).jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/d0c5a69a-a4f2-4c37-a155-1d246cbb4444.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.758Z\",\"MediaKey\":\"NST121611123\"},{\"LongDescription\":\"435874242_3557675967880358_852791987015863092_n.jpg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/f9f23860-2b04-4999-90f6-555c99256a1b.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":694,\"ImageSizeDescription\":\"1024x694\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.629Z\",\"MediaKey\":\"NST121611127\"},{\"LongDescription\":\"0X5A2420-HDR.jpg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/cceb9bdf-33f8-421d-8507-21cdde9d069c.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.631Z\",\"MediaKey\":\"NST121611140\"},{\"LongDescription\":\"2800HamlineAveN-9.jpg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/65ac82e1-2de6-42a2-8f08-af0c4c210581.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.626Z\",\"MediaKey\":\"NST121611137\"},{\"LongDescription\":\"0X5A2414-HDR.jpg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/0a27006d-bba8-498a-95f0-9aee4d710a29.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.63Z\",\"MediaKey\":\"NST121611142\"},{\"LongDescription\":\"2800HamlineAveN-14.jpg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/3fb7ed91-f042-47b6-950c-aee161d3a8ab.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.624Z\",\"MediaKey\":\"NST121611132\"},{\"LongDescription\":\"GetMedia (10).jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/e8238b5d-1e8c-40f6-81c0-8a801d0f3d1d.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.655Z\",\"MediaKey\":\"NST121611121\"},{\"LongDescription\":\"2800HamlineAveN-13.jpg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/3280c847-3850-4788-9264-5dbcd2502f89.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.629Z\",\"MediaKey\":\"NST121611133\"},{\"LongDescription\":\"GetMedia (9).jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7887423/4de4c4fe-d0f7-4f85-854a-e30f8e24eccc.jpeg\",\"ResourceRecordKey\":\"NST7887423\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-04-18T00:54:05.671Z\",\"MediaKey\":\"NST121611122\"}]","Media__LongDescription":"0X5A2423-HDR.jpg","Media__Order":"4","Media__MediaObjectID":"NST4","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7887423/6a8c2231-67b1-4722-8d04-125e2c693124.jpeg","Media__ResourceRecordKey":"NST7887423","Media__ImageWidth":"1024","Media__ImageHeight":"586","Media__ImageSizeDescription":"1024x586","Media__MediaModificationTimestamp":"4/18/2026 12:54:05 AM","Media__MediaKey":"NST121611139","DocumentsChangeTimestamp":"2026-04-18T00:54:06.593Z","Rooms":"[{\"RoomKey\":\"NST116133354\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"8x7\"},{\"RoomKey\":\"NST116133356\",\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"13X12\"},{\"RoomKey\":\"NST116133355\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"7X7\"},{\"RoomKey\":\"NST116133353\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"19X13\"}]","Rooms__RoomKey":"NST116133354","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"8x7","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"2800HamlineAveN-9.jpg\"},{\"Order\":2,\"Remarks\":\"0X5A2417-HDR.jpg\"},{\"Order\":3,\"Remarks\":\"0X5A2420-HDR.jpg\"},{\"Order\":4,\"Remarks\":\"0X5A2423-HDR.jpg\"},{\"Order\":5,\"Remarks\":\"0X5A2414-HDR.jpg\"},{\"Order\":6,\"Remarks\":\"2800HamlineAveN-8.jpg\"},{\"Order\":7,\"Remarks\":\"2800HamlineAveN-7.jpg\"},{\"Order\":8,\"Remarks\":\"0X5A2411-HDR.jpg\"},{\"Order\":9,\"Remarks\":\"2800HamlineAveN-14.jpg\"},{\"Order\":10,\"Remarks\":\"2800HamlineAveN-13.jpg\"},{\"Order\":11,\"Remarks\":\"2800HamlineAveN-12.jpg\"},{\"Order\":12,\"Remarks\":\"2800HamlineAveN-10.jpg\"},{\"Order\":13,\"Remarks\":\"2800HamlineAveN-15.jpg\"},{\"Order\":14,\"Remarks\":\"GetMedia (10).jpeg\"},{\"Order\":15,\"Remarks\":\"GetMedia (9).jpeg\"},{\"Order\":16,\"Remarks\":\"435874242_3557675967880358_852791987015863092_n.jpg\"},{\"Order\":17,\"Remarks\":\"GetMedia (5).jpeg\"},{\"Order\":18,\"Remarks\":\"GetMedia (8).jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}