{"Id":1393234,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6768657","MLSAGENTID":"NST502050177","MLSOFFICEID":"NST253076","ADDRESS":"880 2nd Street NW","ACRES":0.31,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Partially Finished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"New Brighton","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding","FORECLOSURE":"No","LASTPRICE":330000.0,"LASTPRICEDATE":"2025-08-08T03:16:07.343","LATITUDE":45.052938,"LENDEROWNED":"No","LISTDATE":"2025-08-07T05:00:00","LISTPRICE":330000.0,"LIVINGAREA":1104.0,"LONGITUDE":-93.199101,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-08-08T10:08:11.83","OFFICE_OFFICENAME":"Hallel Properties, LLC","PHOTOCOUNT":18,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This home is in the wonderful city of New Brighton, within the highly rated Mounds View School District. Come see the expansive living room, with shiny hardwood floors. Then step into the tiled kitchen, which offers simplicity for your everyday needs. The main level is complete with 3 generous sized rooms and a full bathroom. The basement is unfinished, awaiting your creativity and finishing touches. It does offer another bathroom for your added convenience. Heading outside, enjoy the huge backyard, which provides a maintenance free deck, a 2-year-old roof and ample space to enjoy your outdoor activities. The home comes with detached garage with enough space for vehicles and tools. This home can be all yours, tour it today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-08T03:16:07.343","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"2nd","STREETNUMBER":"880","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1957,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-08T03:25:03.962","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"19-DSC09351.jpg\"},{\"Order\":2,\"Remarks\":\"20-DSC09357.jpg\"},{\"Order\":3,\"Remarks\":\"11-DSC09313.jpg\"},{\"Order\":4,\"Remarks\":\"12-DSC09318.jpg\"},{\"Order\":5,\"Remarks\":\"10-DSC09308.jpg\"},{\"Order\":6,\"Remarks\":\"09-DSC09303.jpg\"},{\"Order\":7,\"Remarks\":\"01-DSC09263.jpg\"},{\"Order\":8,\"Remarks\":\"02-DSC09266.jpg\"},{\"Order\":9,\"Remarks\":\"03-DSC09273.jpg\"},{\"Order\":10,\"Remarks\":\"04-DSC09278.jpg\"},{\"Order\":11,\"Remarks\":\"14-DSC09326.jpg\"},{\"Order\":12,\"Remarks\":\"15-DSC09333.jpg\"},{\"Order\":13,\"Remarks\":\"16-DSC09338.jpg\"},{\"Order\":14,\"Remarks\":\"17-DSC09343.jpg\"},{\"Order\":15,\"Remarks\":\"21-DSC09361.jpg\"},{\"Order\":16,\"Remarks\":\"23-DSC09371.jpg\"},{\"Order\":17,\"Remarks\":\"24-DSC09376.jpg\"},{\"Order\":18,\"Remarks\":\"25-DSC09381.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7784876","LotSizeArea":"0.31","NST_AgeOfProperty":"68","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Deck,In-Ground Sprinkler","Appliances":"Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Washer,Water Softener Owned","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full,Partially Finished","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"New Brighton","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Old Hwy 8 SW, LEFT ON 2ND ST NW, HOME IS ON THE RIGHT","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Metal Siding","Fencing":"Chain Link","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1040","NST_FractionalOwnershipYN":"No","RoadFrontageType":"Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Concrete","NST_GarageDimensions":"26X23","NST_GarageSquareFeet":"598","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-08T03:10:35Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-08","Latitude":"45.052938","NST_LenderOwned":"No","ListAgentKey":"NST226838","ListAgentMlsId":"NST502050177","ListingContractDate":"2025-08-07T05:00:00Z","ListOfficeKey":"NST1001820","ListOfficeName":"Hallel Properties, LLC","ListOfficeMlsId":"NST253076","ListPrice":"330000","LivingArea":"1104","LockBoxType":"Combo","Longitude":"-93.199101","LotFeatures":"Some Trees","LotSizeDimensions":"75X181","LotSizeSquareFeet":"13547.16","LotSizeUnits":"Acres","ListingId":"NST6768657","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"293023340006","GarageSpaces":"2","NST_PatioPorchType":"Deck","PhotosCount":"18","PostalCity":"Saint Paul","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"This home is in the wonderful city of New Brighton, within the highly rated Mounds View School District. Come see the expansive living room, with shiny hardwood floors. Then step into the tiled kitchen, which offers simplicity for your everyday needs. The main level is complete with 3 generous sized rooms and a full bathroom. The basement is unfinished, awaiting your creativity and finishing touches. It does offer another bathroom for your added convenience. Heading outside, enjoy the huge backyard, which provides a maintenance free deck, a 2-year-old roof and ample space to enjoy your outdoor activities. The home comes with detached garage with enough space for vehicles and tools. This home can be all yours, tour it today!","PublicSurveyRange":"23","PublicSurveySection":"29","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","Roof":"Asphalt","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"1040.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1040.0000","BuildingAreaTotal":"1040","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom","AboveGradeFinishedArea":"1040","BelowGradeFinishedArea":"64","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NW","StreetName":"2nd","StreetNumber":"880","StreetNumberNumeric":"880","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Mork-Campion Terrace","NST_TaxWithAssessments":"3720.0000","TaxYear":"2025","TaxAnnualAmount":"3720","WaterSource":"City Water/Connected","YearBuilt":"1957","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-08T10:08:11.83Z","PhotosChangeTimestamp":"2025-08-08T03:25:03.962Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7784876\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"19-DSC09351.jpg\",\"ImageWidth\":1200,\"ImageHeight\":674,\"ImageSizeDescription\":\"1200x674\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/2c064668-ddd4-404f-8317-646f3d044f87.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.924Z\",\"MediaKey\":\"68956df0e3c8495ba35473a9\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"20-DSC09357.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/51c67a61-2340-42f9-ae25-7e17e23df196.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.86Z\",\"MediaKey\":\"68956df0e3c8495ba35473aa\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"11-DSC09313.jpg\",\"ImageWidth\":1200,\"ImageHeight\":676,\"ImageSizeDescription\":\"1200x676\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/2e91caa8-a649-4cf9-b9fc-c6042aab89b3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.805Z\",\"MediaKey\":\"68956df0e3c8495ba35473ab\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"12-DSC09318.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/0f10e67e-0fb7-4a36-b0ff-eb0d16eb735b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.768Z\",\"MediaKey\":\"68956df0e3c8495ba35473ac\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"10-DSC09308.jpg\",\"ImageWidth\":1200,\"ImageHeight\":678,\"ImageSizeDescription\":\"1200x678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/bdff4bfb-74a0-4704-b317-84ff14010adf.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.798Z\",\"MediaKey\":\"68956df0e3c8495ba35473ad\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"09-DSC09303.jpg\",\"ImageWidth\":1200,\"ImageHeight\":675,\"ImageSizeDescription\":\"1200x675\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/64df3547-6305-4aea-977e-37e054072f9e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.819Z\",\"MediaKey\":\"68956df0e3c8495ba35473ae\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"01-DSC09263.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/8221ca92-770d-4aff-95ef-df059c27c9c3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.767Z\",\"MediaKey\":\"68956df0e3c8495ba35473af\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"02-DSC09266.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/e474c041-bc3d-46aa-a4f8-3cd6b448762e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.756Z\",\"MediaKey\":\"68956df0e3c8495ba35473b0\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"03-DSC09273.jpg\",\"ImageWidth\":1200,\"ImageHeight\":676,\"ImageSizeDescription\":\"1200x676\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/1aa9fe35-835c-42a1-90be-a22c003c9dc7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.801Z\",\"MediaKey\":\"68956df0e3c8495ba35473b1\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"04-DSC09278.jpg\",\"ImageWidth\":1200,\"ImageHeight\":680,\"ImageSizeDescription\":\"1200x680\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/55e81ca9-a055-4f2a-87d5-b6806a0359ac.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.817Z\",\"MediaKey\":\"68956df0e3c8495ba35473b2\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"14-DSC09326.jpg\",\"ImageWidth\":1200,\"ImageHeight\":680,\"ImageSizeDescription\":\"1200x680\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/d9a5233a-9352-4231-9a14-882777127ca6.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.798Z\",\"MediaKey\":\"68956df0e3c8495ba35473b3\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"15-DSC09333.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/8cfc8430-497b-44f1-9cca-386440c13fe3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.839Z\",\"MediaKey\":\"68956df0e3c8495ba35473b4\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"16-DSC09338.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/e0cbe762-d523-4e73-bdf7-c15e2fb8bf0c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.818Z\",\"MediaKey\":\"68956df0e3c8495ba35473b5\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"17-DSC09343.jpg\",\"ImageWidth\":1200,\"ImageHeight\":679,\"ImageSizeDescription\":\"1200x679\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/f0eeeed2-a853-463f-9856-f7ee7fd79a43.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.767Z\",\"MediaKey\":\"68956df0e3c8495ba35473b6\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"21-DSC09361.jpg\",\"ImageWidth\":1200,\"ImageHeight\":681,\"ImageSizeDescription\":\"1200x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/0ab2ee18-b7eb-4592-91fb-b66698e79825.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.823Z\",\"MediaKey\":\"68956df0e3c8495ba35473b7\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"23-DSC09371.jpg\",\"ImageWidth\":1200,\"ImageHeight\":677,\"ImageSizeDescription\":\"1200x677\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/ed3d1e14-0d48-403d-9aee-bf88821b0121.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.88Z\",\"MediaKey\":\"68956df0e3c8495ba35473b8\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"24-DSC09376.jpg\",\"ImageWidth\":1200,\"ImageHeight\":676,\"ImageSizeDescription\":\"1200x676\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/3c2ab520-af1f-42fc-aa01-a9f12abb4f63.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.823Z\",\"MediaKey\":\"68956df0e3c8495ba35473b9\"},{\"ResourceRecordKey\":\"NST7784876\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"25-DSC09381.jpg\",\"ImageWidth\":1200,\"ImageHeight\":678,\"ImageSizeDescription\":\"1200x678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7784876/ab313d20-ce90-4a85-8642-71bfc1ccd130.jpeg\",\"MediaModificationTimestamp\":\"2025-08-08T03:24:32.796Z\",\"MediaKey\":\"68956df0e3c8495ba35473ba\"}]","Rooms":"[{\"RoomKey\":\"NST115496762\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"21 x 13.5\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115496763\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9 x 7\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115496764\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9 x 8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115496765\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13 x 11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115496766\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11 x 9.\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115496767\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11 x 9.\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"19-DSC09351.jpg\"},{\"Order\":2,\"Remarks\":\"20-DSC09357.jpg\"},{\"Order\":3,\"Remarks\":\"11-DSC09313.jpg\"},{\"Order\":4,\"Remarks\":\"12-DSC09318.jpg\"},{\"Order\":5,\"Remarks\":\"10-DSC09308.jpg\"},{\"Order\":6,\"Remarks\":\"09-DSC09303.jpg\"},{\"Order\":7,\"Remarks\":\"01-DSC09263.jpg\"},{\"Order\":8,\"Remarks\":\"02-DSC09266.jpg\"},{\"Order\":9,\"Remarks\":\"03-DSC09273.jpg\"},{\"Order\":10,\"Remarks\":\"04-DSC09278.jpg\"},{\"Order\":11,\"Remarks\":\"14-DSC09326.jpg\"},{\"Order\":12,\"Remarks\":\"15-DSC09333.jpg\"},{\"Order\":13,\"Remarks\":\"16-DSC09338.jpg\"},{\"Order\":14,\"Remarks\":\"17-DSC09343.jpg\"},{\"Order\":15,\"Remarks\":\"21-DSC09361.jpg\"},{\"Order\":16,\"Remarks\":\"23-DSC09371.jpg\"},{\"Order\":17,\"Remarks\":\"24-DSC09376.jpg\"},{\"Order\":18,\"Remarks\":\"25-DSC09381.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}