{"Id":581325,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7103738","MLSAGENTID":"NST502050986","MLSOFFICEID":"NST25806","ADDRESS":"4039 Main Street NE","ACRES":0.175,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Finished,Full","BATHSTOTAL":2.0,"BEDROOMS":5.0,"CITY":"Columbia Heights","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":369900.0,"LASTPRICEDATE":"2026-07-03T22:25:06.363","LATITUDE":45.04213513,"LENDEROWNED":"No","LISTDATE":"2026-07-03T05:00:00","LISTPRICE":369900.0,"LIVINGAREA":2111.0,"LONGITUDE":-93.26745873,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-07-04T09:18:11.266","OFFICE_OFFICENAME":"Longhouse Realty","PHOTOCOUNT":17,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this beautifully updated **5-bedroom, 2 full-bath** home offering the perfect blend of space, comfort, and modern improvements. From the moment you arrive, you'll appreciate the extensive updates that make this home truly move-in ready. The kitchen features a **new refrigerator (2024), new cooking range (2025), and new dishwasher (2025)**. Major mechanical updates include a **new furnace (2023)** and **new water heater (2023)**, providing added peace of mind. Enjoy the beauty of **hardwood floors** throughout much of the home, along with **new insulation in the attic and exterior walls** for improved energy efficiency and year-round comfort. Step outside to a **new concrete patio**, plus **new concrete surrounding the home and a new walkway leading to the garage (2023)**, creating an attractive and low-maintenance outdoor space perfect for relaxing or entertaining. With five spacious bedrooms, two full bathrooms, and numerous high-value improvements already completed, this home is an exceptional opportunity for buyers seeking space, quality, and lasting value. Conveniently located near parks, schools, shopping, dining, and major commuter routes, this is a home you won't want to miss. Schedule your private showing today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"13-Columbia Heights","SCHOOLDISTRICTPHONE":"7635284500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-03T22:25:06.363","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"Main","STREETNUMBER":"4039","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1957,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-03T22:25:06.364","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front of House.jpg\"},{\"Order\":2,\"Remarks\":\"Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"Kitchen1.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen2.jpg\"},{\"Order\":5,\"Remarks\":\"Bedroom1.jpg\"},{\"Order\":6,\"Remarks\":\"Bedroom2.jpg\"},{\"Order\":7,\"Remarks\":\"Bedroom3.jpg\"},{\"Order\":8,\"Remarks\":\"Bathroom1.jpg\"},{\"Order\":9,\"Remarks\":\"Bathroom2.jpg\"},{\"Order\":10,\"Remarks\":\"Familyroom.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom4.jpg\"},{\"Order\":12,\"Remarks\":\"Bedroom5.jpg\"},{\"Order\":13,\"Remarks\":\"UtilityRoom.jpg\"},{\"Order\":14,\"Remarks\":\"LaundryRoom.jpg\"},{\"Order\":15,\"Remarks\":\"Extra storage space.jpg\"},{\"Order\":16,\"Remarks\":\"Patio.jpg\"},{\"Order\":17,\"Remarks\":\"BackYard.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7929554","NST_AboveGradeSqFtTotal":"1078","AboveGradeFinishedArea":"1078","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Washer/Dryer Hookup","Appliances":"Cooktop,Dishwasher,Dryer,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AssociationFeeFrequency":"N/A","Basement":"Egress Window(s),Finished,Full","BasementYN":"True","NST_BathDesc":"Full Basement,Main Floor Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"78","BelowGradeFinishedArea":"1033","CumulativeDaysOnMarket":"0","City":"Columbia Heights","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"None","CountyOrParish":"Anoka","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"University to 40th W to Main - N 1 block","DocumentsCount":"4","DocumentsChangeTimestamp":"2026-07-03T22:25:06.364Z","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","Fencing":"Chain Link,Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1078","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"Columbia Heights","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0421351262","LaundryFeatures":"Laundry Room","NST_LenderOwned":"No","Levels":"One","ListPrice":"369900","ListingContractDate":"2026-07-03T05:00:00Z","ListingId":"NST7103738","LivingArea":"2111","LockBoxType":"Combo","Longitude":"-93.2674587306","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.175","LotSizeDimensions":"60x127","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1078","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-07-03T17:24:54Z","ParcelNumber":"353024320023","ParkingFeatures":"Detached Garage,Concrete","NST_PatioPorchType":"Patio","PhotosCount":"17","PhotosChangeTimestamp":"2026-07-03T22:25:06.364Z","PostalCity":"Columbia Heights","PostalCode":"55421","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to this beautifully updated **5-bedroom, 2 full-bath** home offering the perfect blend of space, comfort, and modern improvements. From the moment you arrive, you'll appreciate the extensive updates that make this home truly move-in ready. The kitchen features a **new refrigerator (2024), new cooking range (2025), and new dishwasher (2025)**. Major mechanical updates include a **new furnace (2023)** and **new water heater (2023)**, providing added peace of mind. Enjoy the beauty of **hardwood floors** throughout much of the home, along with **new insulation in the attic and exterior walls** for improved energy efficiency and year-round comfort. Step outside to a **new concrete patio**, plus **new concrete surrounding the home and a new walkway leading to the garage (2023)**, creating an attractive and low-maintenance outdoor space perfect for relaxing or entertaining. With five spacious bedrooms, two full bathrooms, and numerous high-value improvements already completed, this home is an exceptional opportunity for buyers seeking space, quality, and lasting value. Conveniently located near parks, schools, shopping, dining, and major commuter routes, this is a home you won't want to miss. Schedule your private showing today!","Roof":"Asphalt","NST_SchoolDistrictFullName":"13 - Columbia Heights","NST_SchoolDistrictNumber":"13","NST_SchoolDistrictPhone":"7635284500","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"Main","StreetNumber":"4039","StreetNumberNumeric":"4039","StreetSuffix":"Street","TaxAnnualAmount":"3914.76","NST_TaxWithAssessments":"3938.78","TaxYear":"2025","NST_TotalArea":"1156","BuildingAreaTotal":"1156","Township":"Columbia Heights","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1957","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST228869","ListAgentMlsId":"NST502050986","ListOfficeMlsId":"NST25806","ListOfficeName":"Longhouse Realty","ListOfficeKey":"NST25806","ModificationTimestamp":"2026-07-04T09:18:11.266Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/30792765-4143-4dbb-8204-fd73d832b379.jpeg\",\"LongDescription\":\"UtilityRoom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.679Z\",\"MediaKey\":\"NST123375456\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/3d2d936d-f94a-45bf-898c-abf6dd8fb2ff.jpeg\",\"LongDescription\":\"Front of House.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.638Z\",\"MediaKey\":\"NST123375443\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/c1506a98-0e0e-4360-b1b5-f7046e7f1f5d.jpeg\",\"LongDescription\":\"Bathroom1.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.656Z\",\"MediaKey\":\"NST123375468\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/0f7f56bf-7210-4f8c-88d7-80e9a98e7799.jpeg\",\"LongDescription\":\"Familyroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.651Z\",\"MediaKey\":\"NST123375462\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/f84d0eeb-f60b-478e-9232-28a7649d72f7.jpeg\",\"LongDescription\":\"Patio.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.643Z\",\"MediaKey\":\"NST123375457\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/f3e8e624-8981-42d1-b591-9110d1ae5a42.jpeg\",\"LongDescription\":\"Kitchen1.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.625Z\",\"MediaKey\":\"NST123375460\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/fbb1e7ae-3274-4945-84ad-1f849856d296.jpeg\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.599Z\",\"MediaKey\":\"NST123375458\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/98851fba-fd47-485c-a833-0df118e5c954.jpeg\",\"LongDescription\":\"Kitchen2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.679Z\",\"MediaKey\":\"NST123375461\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/733aa8e9-4088-4d4d-9db5-94a314dc1584.jpeg\",\"LongDescription\":\"BackYard.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.73Z\",\"MediaKey\":\"NST123375470\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/9b313c13-10fb-4831-94fc-9bd5fc7158bc.jpeg\",\"LongDescription\":\"Bedroom4.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.644Z\",\"MediaKey\":\"NST123375464\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/f59c1c39-8088-46f8-b3ec-1928f007bf27.jpeg\",\"LongDescription\":\"Bathroom2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.625Z\",\"MediaKey\":\"NST123375469\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/f804b42f-f49c-422e-9e50-416f4e2596f4.jpeg\",\"LongDescription\":\"Bedroom5.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.679Z\",\"MediaKey\":\"NST123375465\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/b8876409-71aa-4f91-8426-cffa30ebe8e5.jpeg\",\"LongDescription\":\"LaundryRoom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.661Z\",\"MediaKey\":\"NST123375810\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/517eaebc-7142-4fc9-b9c6-ab708b8d262c.jpeg\",\"LongDescription\":\"Bedroom3.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.658Z\",\"MediaKey\":\"NST123375466\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/8fadae40-33ef-4f7a-89ce-0f9891b7c67f.jpeg\",\"LongDescription\":\"Extra storage space.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.705Z\",\"MediaKey\":\"NST123376009\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/3e0a6954-fab6-45d7-a67d-0b9b37bc2317.jpeg\",\"LongDescription\":\"Bedroom2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.679Z\",\"MediaKey\":\"NST123375467\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7929554\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7929554/20cbe21c-426f-4767-90cc-d87f9d7f7885.jpeg\",\"LongDescription\":\"Bedroom1.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-07-03T20:22:05.635Z\",\"MediaKey\":\"NST123375463\"}]","Media__Order":"13","Media__MediaObjectID":"NST13","Media__ResourceRecordKey":"NST7929554","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7929554/30792765-4143-4dbb-8204-fd73d832b379.jpeg","Media__LongDescription":"UtilityRoom.jpg","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"7/3/2026 8:22:05 PM","Media__MediaKey":"NST123375456","Rooms":"[{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116421883\",\"RoomType\":\"Family Room\",\"RoomDimensions\":\"12x20\"},{\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116421889\",\"RoomType\":\"Bedroom 5\",\"RoomDimensions\":\"8x13\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116421885\",\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"13x12\"},{\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116421888\",\"RoomType\":\"Bedroom 4\",\"RoomDimensions\":\"11x13\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116421884\",\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"18x10\"},{\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116422407\",\"RoomType\":\"Laundry\",\"RoomDimensions\":\"10x7.5\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116421882\",\"RoomType\":\"Living Room\",\"RoomDimensions\":\"13x24\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116421886\",\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"13x11\"},{\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116422408\",\"RoomType\":\"Storage\",\"RoomDimensions\":\"12x7\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116421887\",\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"11x10\"}]","Rooms__RoomLevel":"Lower","Rooms__NST_RoomSortOrder":"3","Rooms__RoomKey":"NST116421883","Rooms__RoomType":"Family Room","Rooms__RoomDimensions":"12x20","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front of House.jpg\"},{\"Order\":2,\"Remarks\":\"Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"Kitchen1.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen2.jpg\"},{\"Order\":5,\"Remarks\":\"Bedroom1.jpg\"},{\"Order\":6,\"Remarks\":\"Bedroom2.jpg\"},{\"Order\":7,\"Remarks\":\"Bedroom3.jpg\"},{\"Order\":8,\"Remarks\":\"Bathroom1.jpg\"},{\"Order\":9,\"Remarks\":\"Bathroom2.jpg\"},{\"Order\":10,\"Remarks\":\"Familyroom.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom4.jpg\"},{\"Order\":12,\"Remarks\":\"Bedroom5.jpg\"},{\"Order\":13,\"Remarks\":\"UtilityRoom.jpg\"},{\"Order\":14,\"Remarks\":\"LaundryRoom.jpg\"},{\"Order\":15,\"Remarks\":\"Extra storage space.jpg\"},{\"Order\":16,\"Remarks\":\"Patio.jpg\"},{\"Order\":17,\"Remarks\":\"BackYard.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}