{"Id":533003,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7021944","MLSAGENTID":"NST506018808","MLSOFFICEID":"NST9990","ADDRESS":"246 Sidney Street E","ACRES":0.112,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":267900.0,"LASTPRICEDATE":"2026-03-25T18:37:06.133","LATITUDE":44.923717,"LENDEROWNED":"No","LISTDATE":"2026-02-16T06:00:00","LISTPRICE":267900.0,"LIVINGAREA":1400.0,"LONGITUDE":-93.07541,"MODIFICATIONTIMESTAMP":"2026-03-25T18:37:06.132","NEIGHBORHOOD":"104","OFFICE_OFFICENAME":"Northstar Real Estate Associates","PHOTOCOUNT":13,"POSTALCODE":"55107","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Come check this out beautiful home! This charming 3-bedroom, 1.5-bath home offers comfortable living with great space to spread out. Enjoy a functional layout, bright natural light, and the convenience of a half bath for guests on the main floor and a beautiful 3 season enclosed front porch. A solid opportunity in a great Saint Paul location, schedule a showing today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-25T18:37:06.133","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Sidney","STREETNUMBER":"246","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1889,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-02-16T18:42:06.929","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"FullSizeRender (7).jpg\"},{\"Order\":2,\"Remarks\":\"FullSizeRender (6).jpg\"},{\"Order\":3,\"Remarks\":\"FullSizeRender (8).jpg\"},{\"Order\":4,\"Remarks\":\"FullSizeRender.jpg\"},{\"Order\":5,\"Remarks\":\"FullSizeRender.heic (1).JPEG\"},{\"Order\":6,\"Remarks\":\"FullSizeRender (2).jpg\"},{\"Order\":7,\"Remarks\":\"FullSizeRender (4).jpg\"},{\"Order\":8,\"Remarks\":\"FullSizeRender (5).jpg\"},{\"Order\":9,\"Remarks\":\"FullSizeRender (12).jpg\"},{\"Order\":10,\"Remarks\":\"FullSizeRender (9).jpg\"},{\"Order\":11,\"Remarks\":\"FullSizeRender (11).jpg\"},{\"Order\":12,\"Remarks\":\"FullSizeRender (10).jpg\"},{\"Order\":13,\"Remarks\":\"FullSizeRender (13).jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7854102","NST_AboveGradeSqFtTotal":"1400","AboveGradeFinishedArea":"1400","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","Appliances":"Dishwasher,Refrigerator,Stainless Steel Appliances","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Daylight/Lookout Windows,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"24","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Robert Street to Sidney Street, East to home.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-02-18T18:12:06.632Z","DaysOnMarket":"24","FireplaceYN":"False","FireplacesTotal":"0","NST_ForRentMLNumber":"7022052","FoundationArea":"700","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"440","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.923717","NST_LenderOwned":"No","Levels":"Two","ListPrice":"267900","ListingContractDate":"2026-02-16T06:00:00Z","ListingId":"NST7021944","LivingArea":"1400","Longitude":"-93.07541","LotSizeArea":"0.112","LotSizeDimensions":"40x123","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"840","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"104","OriginalEntryTimestamp":"2026-02-16T12:38:37Z","ParcelNumber":"082822420154","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"13","PhotosChangeTimestamp":"2026-02-16T18:42:06.929Z","PostalCity":"Saint Paul","PostalCode":"55107","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Come check this out beautiful home! This charming 3-bedroom, 1.5-bath home offers comfortable living with great space to spread out. Enjoy a functional layout, bright natural light, and the convenience of a half bath for guests on the main floor and a beautiful 3 season enclosed front porch. A solid opportunity in a great Saint Paul location, schedule a showing today!","PublicSurveyRange":"22","PublicSurveySection":"08","PublicSurveyTownship":"28","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"Sidney","StreetNumber":"246","StreetNumberNumeric":"246","StreetSuffix":"Street","SubdivisionName":"Lawton & Meyers Re B25 Woodbu","TaxAnnualAmount":"4390","NST_TaxWithAssessments":"4390","TaxYear":"2025","BuildingAreaTotal":"1400","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1889","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST504612","ListAgentMlsId":"NST506018808","ListOfficeMlsId":"NST9990","ListOfficeName":"Northstar Real Estate Associates","ListOfficeKey":"NST15562","ModificationTimestamp":"2026-03-25T18:37:06.132Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/5c4a5d9c-1961-4ab6-a7fb-ba359d0f0c3c.jpeg\",\"LongDescription\":\"FullSizeRender.heic (1).JPEG\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.726Z\",\"MediaKey\":\"NST120516369\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/88be8620-d69e-467e-812b-4357a7311428.jpeg\",\"LongDescription\":\"FullSizeRender (13).jpg\",\"ImageWidth\":1120,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1120x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.712Z\",\"MediaKey\":\"NST120516368\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/c05703c6-3691-4a26-b80a-ec2860b33321.jpeg\",\"LongDescription\":\"FullSizeRender (10).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.719Z\",\"MediaKey\":\"NST120516461\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/fd12c7f0-12aa-436f-ae97-ff25c07c83fe.jpeg\",\"LongDescription\":\"FullSizeRender (5).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.706Z\",\"MediaKey\":\"NST120516365\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/7dc76e40-11c6-41e0-acc7-1351f2350ff7.jpeg\",\"LongDescription\":\"FullSizeRender (9).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.781Z\",\"MediaKey\":\"NST120516366\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/e00bcccf-8c99-4668-b1ba-31f85b29befd.jpeg\",\"LongDescription\":\"FullSizeRender (11).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.763Z\",\"MediaKey\":\"NST120516462\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/00169bd0-b05e-4152-a3ed-81b272d72a47.jpeg\",\"LongDescription\":\"FullSizeRender (7).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.77Z\",\"MediaKey\":\"NST120516459\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/56b5be06-ba88-4309-acb2-a403c7ce5537.jpeg\",\"LongDescription\":\"FullSizeRender.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.74Z\",\"MediaKey\":\"NST120516526\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/57d80562-180b-427c-ad0c-d9132bce6543.jpeg\",\"LongDescription\":\"FullSizeRender (4).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.714Z\",\"MediaKey\":\"NST120516364\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/4c944b2a-1136-40bb-b5c9-82c26fb13c05.jpeg\",\"LongDescription\":\"FullSizeRender (12).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.73Z\",\"MediaKey\":\"NST120516367\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/e4d66761-2d10-49d6-b9f1-791e7defa5cb.jpeg\",\"LongDescription\":\"FullSizeRender (2).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.707Z\",\"MediaKey\":\"NST120516527\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/ad0fa919-8328-4d95-b057-23ec70a8c4bf.jpeg\",\"LongDescription\":\"FullSizeRender (6).jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.808Z\",\"MediaKey\":\"NST120516458\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7854102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7854102/5c3f2783-7ff6-45c9-806d-6109108cbff6.jpeg\",\"LongDescription\":\"FullSizeRender (8).jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-02-16T18:41:11.721Z\",\"MediaKey\":\"NST120516460\"}]","Media__Order":"5","Media__MediaObjectID":"NST5","Media__ResourceRecordKey":"NST7854102","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7854102/5c4a5d9c-1961-4ab6-a7fb-ba359d0f0c3c.jpeg","Media__LongDescription":"FullSizeRender.heic (1).JPEG","Media__ImageWidth":"1600","Media__ImageHeight":"1200","Media__ImageSizeDescription":"1600x1200","Media__MediaModificationTimestamp":"2/16/2026 6:41:11 PM","Media__MediaKey":"NST120516369","Rooms":"[{\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115937353\",\"RoomType\":\"Dining Room\",\"RoomDimensions\":\"20x12\"},{\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115937354\",\"RoomType\":\"Bedroom\",\"RoomDimensions\":\"12x10\"},{\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115937352\",\"RoomType\":\"Kitchen\",\"RoomDimensions\":\"12x11\"},{\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST115937351\",\"RoomType\":\"Living Room\",\"RoomDimensions\":\"16x12\"},{\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115937355\",\"RoomType\":\"Bedroom 2\",\"RoomDimensions\":\"9x8\"},{\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST115937356\",\"RoomType\":\"Bedroom 3\",\"RoomDimensions\":\"10x10\"}]","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST115937353","Rooms__RoomType":"Dining Room","Rooms__RoomDimensions":"20x12","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"FullSizeRender (7).jpg\"},{\"Order\":2,\"Remarks\":\"FullSizeRender (6).jpg\"},{\"Order\":3,\"Remarks\":\"FullSizeRender (8).jpg\"},{\"Order\":4,\"Remarks\":\"FullSizeRender.jpg\"},{\"Order\":5,\"Remarks\":\"FullSizeRender.heic (1).JPEG\"},{\"Order\":6,\"Remarks\":\"FullSizeRender (2).jpg\"},{\"Order\":7,\"Remarks\":\"FullSizeRender (4).jpg\"},{\"Order\":8,\"Remarks\":\"FullSizeRender (5).jpg\"},{\"Order\":9,\"Remarks\":\"FullSizeRender (12).jpg\"},{\"Order\":10,\"Remarks\":\"FullSizeRender (9).jpg\"},{\"Order\":11,\"Remarks\":\"FullSizeRender (11).jpg\"},{\"Order\":12,\"Remarks\":\"FullSizeRender (10).jpg\"},{\"Order\":13,\"Remarks\":\"FullSizeRender (13).jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}