{"Id":562227,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7080131","MLSAGENTID":"NST502004578","MLSOFFICEID":"NST6082","ADDRESS":"4023 6th Street NE","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Columbia Heights","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":399900.0,"LASTPRICEDATE":"2026-05-25T02:17:06.433","LATITUDE":45.04167023,"LENDEROWNED":"No","LISTDATE":"2026-05-24T05:00:00","LISTPRICE":399900.0,"LIVINGAREA":1748.0,"LONGITUDE":-93.25853903,"MODIFICATIONTIMESTAMP":"2026-05-25T13:16:06.459","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":13,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Classic two story up/down duplex with loads of charm. Each unit has two bedrooms + a sun room, replacement windows and hardwood floors. The lower unit has original kitchen cabinets, unpainted woodwork and is currently vacant. The upper unit has updated cabinets and is leased and tenant is interested in staying. The upper unit can be seen on second showings and requires 24 hour notice, so please plan accordingly.\nBrand new boilers and water heaters! 3rd unit down has separate entrance and is not being used needs a lot of work.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"13-Columbia Heights","SCHOOLDISTRICTPHONE":"7635284500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-25T02:17:06.433","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"6th","STREETNUMBER":"4023","STREETSUFFIX":"Street","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1927,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-25T13:15:06.635","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_7657.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_7658.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_7659.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_7660.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_7661.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_7662.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_7663.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_7664.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_7665.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_7666.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_7667.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_7668.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_7669.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7906963","NST_AboveGradeSqFtTotal":"1882","AboveGradeFinishedArea":"1748","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationAmenities":"Other","Basement":"Full,Unfinished","BasementYN":"True","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"874","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Columbia Heights","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Anoka","NST_DPResource":"Yes","Directions":"From I-35W northbound, exit at Johnson St NE. Left on St Anthony Pkwy and then right on Central Ave NE. Take a left onto 40th Ave NE and then a right onto 6th St NE. Home will be on your right.","DocumentsCount":"0","DaysOnMarket":"0","ElectricExpense":"0","Fencing":"None","FoundationArea":"1008","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","NST_GarageSquareFeet":"589","NST_GarageDimensions":"19x31","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","GarageSpaces":"3","GrossIncome":"36000","Heating":"Boiler","HighSchoolDistrict":"Columbia Heights","NST_ForeclosureStatus":"No","InsuranceExpense":"2080","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0416702264","NST_LenderOwned":"No","Levels":"Two","ListPrice":"399900","ListingContractDate":"2026-05-24T05:00:00Z","ListingId":"NST7080131","LivingArea":"1748","Longitude":"-93.2585390278","LotSizeArea":"0.11","LotSizeDimensions":"40x130","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"874","MaintenanceExpense":"1300","ManagerExpense":"0","NST_RefrigeratorNum":"Two","NetOperatingIncome":"20000","NumberOfUnitsTotal":"2","OperatingExpense":"6680","OriginalEntryTimestamp":"2026-05-24T21:16:41Z","OtherExpense":"1200","NST_OwnerOccupied":"Yes","OwnerPays":"Grounds Care,Snow Removal","ParcelNumber":"353024310076","ParkingFeatures":"Detached Garage,Garage Door Opener","NST_PatioPorchType":"Patio","PhotosCount":"13","PhotosChangeTimestamp":"2026-05-25T13:15:06.635Z","PostalCity":"Columbia Heights","PostalCode":"55421","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertySubType":"Duplex Up and Down","PropertyType":"Residential Income","PublicRemarks":"Classic two story up/down duplex with loads of charm. Each unit has two bedrooms + a sun room, replacement windows and hardwood floors. The lower unit has original kitchen cabinets, unpainted woodwork and is currently vacant. The upper unit has updated cabinets and is leased and tenant is interested in staying. The upper unit can be seen on second showings and requires 24 hour notice, so please plan accordingly.\nBrand new boilers and water heaters! 3rd unit down has separate entrance and is not being used needs a lot of work.","PublicSurveyRange":"24","PublicSurveySection":"35","PublicSurveyTownship":"30","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt","NST_SchoolDistrictNumber":"13","NST_SchoolDistrictPhone":"7635284500","Sewer":"City Sewer/Connected","NST_SharedRooms":"Other","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"6th","StreetNumber":"4023","StreetNumberNumeric":"4023","StreetSuffix":"Street","SubdivisionName":"Columbia Heights Annex","TaxAnnualAmount":"4157","NST_TaxWithAssessments":"4157","TaxYear":"2025","TenantPays":"Electricity,Fuel","BuildingAreaTotal":"2756","Township":"Columbia Heights","TrashExpense":"0","VideosCount":"0","WaterSewerExpense":"2100","WaterSource":"City Water/Connected","YearBuilt":"1927","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST58740","ListAgentMlsId":"NST502004578","ListOfficeMlsId":"NST6082","ListOfficeName":"RE/MAX Results","ListOfficeKey":"NST16655","ModificationTimestamp":"2026-05-25T13:16:06.459Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"IMG_7666.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/becc81a1-71d5-4ff5-b3bd-0611cdc1c4d0.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.75Z\",\"MediaKey\":\"NST122462608\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"IMG_7665.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/806de1bc-57b5-40b5-97cb-2874ccf3fd80.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.792Z\",\"MediaKey\":\"NST122462609\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"IMG_7662.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/f1358345-7bfc-4fdf-8d24-5562f9258e63.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.776Z\",\"MediaKey\":\"NST122462599\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"IMG_7664.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/74987490-0fd9-477b-bcec-f7c135aea8bb.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.757Z\",\"MediaKey\":\"NST122462597\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"IMG_7668.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/f1e0e569-36f5-4eab-8843-235c21da209e.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.73Z\",\"MediaKey\":\"NST122462606\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"IMG_7669.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/43e859cf-8053-46b2-b0d4-af29077c800b.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.733Z\",\"MediaKey\":\"NST122462605\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"IMG_7663.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/62fec841-e4f7-4558-b9eb-1d0e69324dbc.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.724Z\",\"MediaKey\":\"NST122462598\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_7659.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/933a4c55-3d5f-4d23-87d6-6ca1140007cb.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.805Z\",\"MediaKey\":\"NST122462602\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_7660.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/f39f7991-41f0-4074-aae4-43556be4d62f.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.734Z\",\"MediaKey\":\"NST122462601\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"IMG_7661.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/46d8a09a-a63b-4701-80bd-becb2e7c84a2.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.794Z\",\"MediaKey\":\"NST122462600\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"IMG_7667.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/2b240325-b226-4e7b-8efb-cda90d6f3fd4.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.722Z\",\"MediaKey\":\"NST122462607\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_7657.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/eb2e0993-bccb-4fcf-bcfb-f5f87c1231ac.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.805Z\",\"MediaKey\":\"NST122463037\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"IMG_7658.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906963/163c3cb4-3ad2-4198-ae2b-599259969f12.jpeg\",\"ResourceRecordKey\":\"NST7906963\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-25T13:15:05.741Z\",\"MediaKey\":\"NST122462603\"}]","Media__Order":"10","Media__MediaObjectID":"NST10","Media__LongDescription":"IMG_7666.jpeg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7906963/becc81a1-71d5-4ff5-b3bd-0611cdc1c4d0.jpeg","Media__ResourceRecordKey":"NST7906963","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"5/25/2026 1:15:05 PM","Media__MediaKey":"NST122462608","DocumentsChangeTimestamp":"2026-05-25T02:17:06.434Z","UnitTypes":"[{\"NST_UnitSqFt\":874,\"UnitTypeBedsTotal\":2,\"NST_UnitParking\":3,\"NST_UnitAmenities\":[\"Hardwood Floors\",\"Kitchen Window\",\"Natural Woodwork\",\"Sun Room\"],\"NST_UnitFurnished\":\"Unfurnished\",\"NST_MonthlyExpenses\":80,\"NST_UnitID\":1,\"NST_UnitCoolSystem\":[\"None\"],\"NST_UnitRoomsTotal\":7,\"NST_DiningRoomRoomDescription\":[\"Living/Dining Room\",\"Separate/Formal Dining Room\"],\"NST_UnitBathFull\":1,\"UnitTypeUnitsTotal\":1,\"NST_BathDescription\":[\"Main Floor Full Bath\"],\"UnitTypeTotalRent\":1500,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"Main Level\",\"UnitTypeKey\":\"NST160189\",\"NST_UnitAppl\":[\"Range\",\"Refrigerator\"],\"NST_UnitIsLeased\":\"N\"},{\"NST_UnitSqFt\":874,\"UnitTypeBedsTotal\":2,\"NST_UnitAmenities\":[\"Hardwood Floors\",\"Kitchen Window\",\"Natural Woodwork\",\"Sun Room\"],\"NST_UnitFurnished\":\"Unfurnished\",\"NST_MonthlyExpenses\":80,\"NST_UnitID\":2,\"NST_UnitCoolSystem\":[\"None\"],\"NST_UnitRoomsTotal\":7,\"NST_DiningRoomRoomDescription\":[\"Living/Dining Room\",\"Separate/Formal Dining Room\"],\"NST_UnitBathFull\":1,\"UnitTypeUnitsTotal\":1,\"NST_BathDescription\":[\"Upper Level Full Bath\"],\"UnitTypeTotalRent\":1350,\"UnitTypeBathsTotal\":1,\"NST_UnitLevel\":\"2nd Level\",\"UnitTypeKey\":\"NST160190\",\"NST_UnitAppl\":[\"Range\",\"Refrigerator\"],\"NST_UnitIsLeased\":\"Y\",\"NST_LeaseExpirationDt\":\"2026-06-30\"}]","UnitTypes__NST_UnitSqFt":"874","UnitTypes__UnitTypeBedsTotal":"2","UnitTypes__NST_UnitParking":"3","UnitTypes__NST_UnitAmenities":"Hardwood Floors,Kitchen Window,Natural Woodwork,Sun Room","UnitTypes__NST_UnitFurnished":"Unfurnished","UnitTypes__NST_MonthlyExpenses":"80","UnitTypes__NST_UnitID":"1","UnitTypes__NST_UnitCoolSystem":"None","UnitTypes__NST_UnitRoomsTotal":"7","UnitTypes__NST_DiningRoomRoomDescription":"Living/Dining Room,Separate/Formal Dining Room","UnitTypes__NST_UnitBathFull":"1","UnitTypes__UnitTypeUnitsTotal":"1","UnitTypes__NST_BathDescription":"Main Floor Full Bath","UnitTypes__UnitTypeTotalRent":"1500","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitLevel":"Main Level","UnitTypes__UnitTypeKey":"NST160189","UnitTypes__NST_UnitAppl":"Range,Refrigerator","UnitTypes__NST_UnitIsLeased":"N","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_7657.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_7658.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_7659.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_7660.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_7661.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_7662.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_7663.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_7664.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_7665.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_7666.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_7667.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_7668.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_7669.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}