{"Id":1399380,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6777081","MLSAGENTID":"NST506091527","MLSOFFICEID":"NST8814","ADDRESS":"552 Burgess Street","ACRES":0.23,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":289900.0,"LASTPRICEDATE":"2025-09-29T21:15:03.697","LATITUDE":44.96813,"LENDEROWNED":"No","LISTDATE":"2025-08-22T05:00:00","LISTPRICE":279900.0,"LIVINGAREA":2231.0,"LONGITUDE":-93.123434,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2025-09-29T21:15:03.697","NEIGHBORHOOD":"North End","OFFICE_OFFICENAME":"Real Estate Masters, Ltd.","PHOTOCOUNT":11,"POSTALCODE":"55103","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Located near Como Lake, this spacious 3 bedrooms/3 baths home showcase natural woodwork, hardwood floors and turn-of-the-century charm. With the potential to convert to 5 bedrooms it offers a strong value-add opportunity, ideal for investors looking to maximize rental income or families needing more space. Enjoy a private, fenced-in backyard with a finished patio, perfect for outdoor entertaining or relaxing in quiet urban oasis, a detached two-car garage with a newer concrete long driveway offering ample of space for parking. Home is conveniently located with easy access to main roads, freeways, parks, and local shops. Don't miss the opportunity to make this home yours.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-22T19:28:04.197","LASTSTATUS":"Active","STREETNAME":"Burgess","STREETNUMBER":"552","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1894,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-25T19:41:03.934","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front house 1.jpg\"},{\"Order\":2,\"Remarks\":\"Back of house .jpg\"},{\"Order\":3,\"Remarks\":\"garage 2.jpg\"},{\"Order\":4,\"Remarks\":\"patio.jpg\"},{\"Order\":5,\"Remarks\":\"Living Room.jpg\"},{\"Order\":6,\"Remarks\":\"dining.jpg\"},{\"Order\":7,\"Remarks\":\"kitchen 2.jpg\"},{\"Order\":8,\"Remarks\":\"kitchen 1.jpg\"},{\"Order\":9,\"Remarks\":\"loft.jpg\"},{\"Order\":10,\"Remarks\":\"Back of house 2.jpg\"},{\"Order\":11,\"Remarks\":\"front of home 2.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7792298","LotSizeArea":"0.23","NST_AgeOfProperty":"131","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors,Porch,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Exhaust Fan,Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BrokerRedirectLink":"https://broker-redirect.northstarmls.com/broker-redirect/6777081","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"38","CumulativeDaysOnMarket":"38","NST_DiningRoomDescription":"Living/Dining Room","Directions":"I-94 exit Dale St go north, east on Burgess St to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Metal Siding,Vinyl Siding","Fencing":"Wood","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"996","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Sidewalks","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Concrete,Garage Door Opener","NST_GarageSquareFeet":"360","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-22T19:26:07Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-29","Latitude":"44.96813","NST_LenderOwned":"No","ListAgentKey":"NST57000","ListAgentMlsId":"NST506091527","ListingContractDate":"2025-08-22T05:00:00Z","ListOfficeKey":"NST16747","ListOfficeName":"Real Estate Masters, Ltd.","ListOfficeMlsId":"NST8814","ListPrice":"279900","LivingArea":"2231","Longitude":"-93.123434","LotFeatures":"Corner Lot","LotSizeDimensions":"71x135","LotSizeSquareFeet":"10105.92","LotSizeUnits":"Acres","ListingId":"NST6777081","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"North End","NST_OfficeBoard":"SPAAR","ParcelNumber":"252923320088","GarageSpaces":"2","NST_PatioPorchType":"Front Porch","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55103","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Located near Como Lake, this spacious 3 bedrooms/3 baths home showcase natural woodwork, hardwood floors and turn-of-the-century charm. With the potential to convert to 5 bedrooms it offers a strong value-add opportunity, ideal for investors looking to maximize rental income or families needing more space. Enjoy a private, fenced-in backyard with a finished patio, perfect for outdoor entertaining or relaxing in quiet urban oasis, a detached two-car garage with a newer concrete long driveway offering ample of space for parking. Home is conveniently located with easy access to main roads, freeways, parks, and local shops. Don't miss the opportunity to make this home yours.","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Asphalt","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"1972.0000","NST_BelowGradeSqFtTotal":"259.0000","NST_MainLevelFinishedArea":"996.0000","BuildingAreaTotal":"2231","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1972","BelowGradeFinishedArea":"259","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Burgess","StreetNumber":"552","StreetNumberNumeric":"552","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Foundry Add","NST_TaxWithAssessments":"4002.0000","TaxYear":"2025","TaxAnnualAmount":"4002","WaterSource":"City Water/Connected","YearBuilt":"1894","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-29T21:15:03.697Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7792298\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front house 1.jpg\",\"ImageWidth\":480,\"ImageHeight\":630,\"ImageSizeDescription\":\"480x630\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/5f20d97b-8f00-45cf-9e30-8f41e04eb72a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T19:37:14.885Z\",\"MediaKey\":\"68d599ead70f773b48ce400e\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Back of house .jpg\",\"ImageWidth\":1290,\"ImageHeight\":968,\"ImageSizeDescription\":\"1290x968\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/c3cbe36d-dbb7-4fd9-97c4-f6edcafced7d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.72Z\",\"MediaKey\":\"68d3573c5f7b9b156180e481\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"garage 2.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/91c76e87-906f-498e-9b1e-c586128edb56.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.713Z\",\"MediaKey\":\"68d3573c5f7b9b156180e483\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"patio.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/930e7606-4c11-41bc-ac52-098b101e05be.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.742Z\",\"MediaKey\":\"68d3573c5f7b9b156180e484\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Living Room.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1431,\"ImageSizeDescription\":\"2048x1431\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/b9a966b5-9834-4faa-af0e-380ee9624091.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T19:40:21.748Z\",\"MediaKey\":\"68d59aa5e856c679ef236ad5\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"dining.jpg\",\"ImageWidth\":526,\"ImageHeight\":391,\"ImageSizeDescription\":\"526x391\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/e9aec821-2d34-4d5c-8f04-8695d944ebd4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.704Z\",\"MediaKey\":\"68d3573c5f7b9b156180e487\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"kitchen 2.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1442,\"ImageSizeDescription\":\"2048x1442\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/f43cf8cd-f2a3-4a8a-84ce-6fc6db8978c7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T19:38:14.551Z\",\"MediaKey\":\"68d59a264021ca492b440733\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"kitchen 1.jpg\",\"ImageWidth\":1290,\"ImageHeight\":1720,\"ImageSizeDescription\":\"1290x1720\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/40abbd58-f643-40e1-9fd7-591356956cd2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-25T19:38:14.622Z\",\"MediaKey\":\"68d59a264021ca492b440734\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"loft.jpg\",\"ImageWidth\":480,\"ImageHeight\":360,\"ImageSizeDescription\":\"480x360\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/f52c8f61-b602-448d-bee4-d0bfb1d423c4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.697Z\",\"MediaKey\":\"68d3573c5f7b9b156180e486\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Back of house 2.jpg\",\"ImageWidth\":1290,\"ImageHeight\":980,\"ImageSizeDescription\":\"1290x980\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/3f531a95-0087-4464-b259-2267c5dc098d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.72Z\",\"MediaKey\":\"68d3573c5f7b9b156180e482\"},{\"ResourceRecordKey\":\"NST7792298\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"front of home 2.jpg\",\"ImageWidth\":480,\"ImageHeight\":361,\"ImageSizeDescription\":\"480x361\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7792298/51b2dd2d-c1a4-4448-bf94-54689db5f2f8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T02:28:12.705Z\",\"MediaKey\":\"68d3573c5f7b9b156180e488\"}]","PhotosChangeTimestamp":"2025-09-25T19:41:03.934Z","Rooms":"[{\"RoomKey\":\"NST115544885\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115544886\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115544887\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115544888\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115544889\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115544890\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115544891\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front house 1.jpg\"},{\"Order\":2,\"Remarks\":\"Back of house .jpg\"},{\"Order\":3,\"Remarks\":\"garage 2.jpg\"},{\"Order\":4,\"Remarks\":\"patio.jpg\"},{\"Order\":5,\"Remarks\":\"Living Room.jpg\"},{\"Order\":6,\"Remarks\":\"dining.jpg\"},{\"Order\":7,\"Remarks\":\"kitchen 2.jpg\"},{\"Order\":8,\"Remarks\":\"kitchen 1.jpg\"},{\"Order\":9,\"Remarks\":\"loft.jpg\"},{\"Order\":10,\"Remarks\":\"Back of house 2.jpg\"},{\"Order\":11,\"Remarks\":\"front of home 2.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}