{"Id":618386,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7149671","MLSAGENTID":"NST506020449","MLSOFFICEID":"NST200072","ADDRESS":"397 Burgess Street","ACRES":0.1,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Concrete","FORECLOSURE":"No","LASTPRICE":185000.0,"LASTPRICEDATE":"2026-09-29T01:14:06.093","LATITUDE":44.96863,"LENDEROWNED":"No","LISTDATE":"2026-09-28T05:00:00","LISTPRICE":185000.0,"LIVINGAREA":1282.0,"LONGITUDE":-93.117004,"MODIFICATIONTIMESTAMP":"2026-09-29T10:07:11.691","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Diversified Realty","PHOTOCOUNT":1,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this charming two-story home nestled on a quiet street in St. Paul's North End neighborhood. This well-maintained property features four bedrooms, two bathrooms, and a two-car garage. Enjoy a blend of classic charm and modern updates with beautiful hardwood floors, brand-new carpet, a new furnace, central air conditioning, and fresh paint throughout. Home has a fenced in backyard. Conveniently located just minutes from major highways, this home offers easy access to shopping, dining, and everyday amenities, as well as nearby Como Lake for outdoor recreation. A perfect combination of comfort, location, and value—don’t miss this opportunity!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-09-29T01:14:06.093","LASTSTATUS":"Active","STREETNAME":"Burgess","STREETNUMBER":"397","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1889,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-09-29T01:14:06.092","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1000027327.jpg\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7974263","NST_AboveGradeSqFtTotal":"1282","AboveGradeFinishedArea":"1282","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Deck,Hardwood Floors","Appliances":"Dishwasher,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"500","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"169","CarportSpaces":"0","City":"Saint Paul","ConstructionMaterials":"Block,Concrete","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"94 to Marion, North to Como, West to Western, then North to Burgess.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Circuit Breakers","ExteriorFeatures":"Aluminum Siding","Fencing":"Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"500","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"441","NST_GarageDimensions":"21x21","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.96863","NST_LenderOwned":"No","Levels":"Two","ListPrice":"185000","ListingContractDate":"2026-09-28T05:00:00Z","ListingId":"NST7149671","LivingArea":"1282","LockBoxType":"Combo","Longitude":"-93.117004","LotSizeArea":"0.1","LotSizeDimensions":"35x125","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"700","NST_ManufacturedHome":"N","NST_NeighborhoodName":"North End","NST_NeighborhoodNumber":"97","OriginalEntryTimestamp":"2026-09-28T20:13:31Z","ParcelNumber":"252923310030","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Rear Porch","PhotosCount":"1","PhotosChangeTimestamp":"2026-09-29T01:14:06.092Z","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to this charming two-story home nestled on a quiet street in St. Paul's North End neighborhood. This well-maintained property features four bedrooms, two bathrooms, and a two-car garage. Enjoy a blend of classic charm and modern updates with beautiful hardwood floors, brand-new carpet, a new furnace, central air conditioning, and fresh paint throughout. Home has a fenced in backyard. Conveniently located just minutes from major highways, this home offers easy access to shopping, dining, and everyday amenities, as well as nearby Como Lake for outdoor recreation. A perfect combination of comfort, location, and value—don’t miss this opportunity!","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"29","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","Roof":"Age Over 8 Years","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer - In Street","NST_SpecialSearch":"3 BR on One Level,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Burgess","StreetNumber":"397","StreetNumberNumeric":"397","StreetSuffix":"Street","SubdivisionName":"Robert A Smiths Rearran-, Gem","TaxAnnualAmount":"4190","NST_TaxWithAssessments":"5096","TaxYear":"2026","NST_TotalArea":"1782","BuildingAreaTotal":"1782","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water - In Street","WaterfrontYN":"False","YearBuilt":"1889","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST518437","ListAgentMlsId":"NST506020449","ListOfficeMlsId":"NST200072","ListOfficeName":"Diversified Realty","ListOfficeKey":"NST1000052","ModificationTimestamp":"2026-09-29T10:07:11.691Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7974263\",\"LongDescription\":\"1000027327.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=zz06jTOVizsaESVyDbz10Gt3n3VfgpOVLmU_UmrbK3U&expires=1790680780&id=5d6fc86794c5224544394849/images/NST7974263/e15ab1cf-37f1-4ef3-85ae-9e02e13befce.jpeg\",\"ImageWidth\":1080,\"ImageHeight\":696,\"ImageSizeDescription\":\"1080x696\",\"MediaModificationTimestamp\":\"2026-09-29T01:14:03.77Z\",\"MediaKey\":\"NST125124865\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ResourceRecordKey":"NST7974263","Media__LongDescription":"1000027327.jpg","Media__MediaURL":"https://media.mlsgrid.com/token=zz06jTOVizsaESVyDbz10Gt3n3VfgpOVLmU_UmrbK3U&expires=1790680780&id=5d6fc86794c5224544394849/images/NST7974263/e15ab1cf-37f1-4ef3-85ae-9e02e13befce.jpeg","Media__ImageWidth":"1080","Media__ImageHeight":"696","Media__ImageSizeDescription":"1080x696","Media__MediaModificationTimestamp":"9/29/2026 1:14:03 AM","Media__MediaKey":"NST125124865","DocumentsChangeTimestamp":"2026-09-29T01:14:06.093Z","Rooms":"[{\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116711428\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"7x13\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116711430\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"13x8\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116711433\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"14x8\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116711429\",\"RoomType\":\"Kitchen\"},{\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116711427\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116711434\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116711431\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\"},{\"RoomDimensions\":\"7x13\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116711432\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\"}]","Rooms__RoomDimensions":"13x12","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116711428","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1000027327.jpg\"}]","PhotoOrder":"1","CustomVTourURL":""}