{"Id":551319,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7066770","MLSAGENTID":"NST506019249","MLSOFFICEID":"NST25853","ADDRESS":"1685 Selby Avenue","ACRES":0.095,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Storage Space,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":339000.0,"LASTPRICEDATE":"2026-05-03T17:36:07.077","LATITUDE":44.946806,"LENDEROWNED":"No","LISTDATE":"2026-05-03T05:00:00","LISTPRICE":339000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.171526,"MODIFICATIONTIMESTAMP":"2026-05-03T17:36:07.076","NEIGHBORHOOD":"96","OFFICE_OFFICENAME":"Red Fence Realty, LLC","PHOTOCOUNT":13,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Charming 3-bedroom home in a highly convenient location near shopping, restaurants, grocery stores, and colleges. This home features a formal dining room with a beautiful built-in natural oak buffet showcasing original glass panes. Enjoy abundant natural light throughout, a spacious living room, and a welcoming 3-season porch. The upper level includes a bonus/storage room, and the large basement offers additional space ready for your personal touch.\n\nSituated on a bus line and within an Opportunity Zone. **Additional opportunity: Three adjacent homes to the left are also available—purchase all four properties for redevelopment potential. Concept renderings have been previously drafted and received positive feedback from the city.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-03T17:36:07.077","LASTSTATUS":"Active","STREETNAME":"Selby","STREETNUMBER":"1685","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1912,"ZONING":"Residential-Multi-Family,Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-03T17:36:07.076","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"front.jpg\"},{\"Order\":2,\"Remarks\":\"image(6).jpg\"},{\"Order\":3,\"Remarks\":\"image.jpg\"},{\"Order\":4,\"Remarks\":\"image 2.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"image(3).jpg\"},{\"Order\":7,\"Remarks\":\"image(2).jpg\"},{\"Order\":8,\"Remarks\":\"image(1).jpg\"},{\"Order\":9,\"Remarks\":\"image(4).jpg\"},{\"Order\":10,\"Remarks\":\"image(5).jpg\"},{\"Order\":11,\"Remarks\":\"image(7).jpg\"},{\"Order\":12,\"Remarks\":\"4 Houses.jpg\"},{\"Order\":13,\"Remarks\":\"Restaurants Near Selby.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7895286","NST_AboveGradeSqFtTotal":"1432","AboveGradeFinishedArea":"0","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Main Floor Primary Bedroom,Natural Woodwork,Washer/Dryer Hookup","Appliances":"Dishwasher,Disposal,Dryer,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationAmenities":"None","AssociationFee":"0","Basement":"Daylight/Lookout Windows,Storage Space,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","Directions":"Located near the corner of Selby and Snelling","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Circuit Breakers","Fencing":"Chain Link,Full","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1040","NST_FoundationDimensions":"40x104","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"1.5","Heating":"Hot Water","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.946806","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"Two","ListPrice":"339000","ListingContractDate":"2026-05-03T05:00:00Z","ListingId":"NST7066770","LivingArea":"0","LockBoxType":"Combo","Longitude":"-93.171526","LotSizeArea":"0.095","LotSizeDimensions":"40x104","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"0","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"96","OriginalEntryTimestamp":"2026-05-03T12:35:47Z","ParcelNumber":"042823110161","ParkingFeatures":"Detached Garage,Asphalt","NST_PatioPorchType":"Deck","PhotosCount":"13","PhotosChangeTimestamp":"2026-05-03T17:36:07.076Z","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Charming 3-bedroom home in a highly convenient location near shopping, restaurants, grocery stores, and colleges. This home features a formal dining room with a beautiful built-in natural oak buffet showcasing original glass panes. Enjoy abundant natural light throughout, a spacious living room, and a welcoming 3-season porch. The upper level includes a bonus/storage room, and the large basement offers additional space ready for your personal touch.\n\nSituated on a bus line and within an Opportunity Zone. **Additional opportunity: Three adjacent homes to the left are also available—purchase all four properties for redevelopment potential. Concept renderings have been previously drafted and received positive feedback from the city.","PublicSurveyRange":"23","PublicSurveySection":"04","PublicSurveyTownship":"28","Roof":"Age Over 8 Years","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Selby","StreetNumber":"1685","StreetNumberNumeric":"1685","StreetSuffix":"Avenue","SubdivisionName":"Kuhls Add To The City, Of","TaxAnnualAmount":"5694","NST_TaxWithAssessments":"5694","TaxYear":"2025","BuildingAreaTotal":"1432","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1912","ZoningDescription":"Residential-Multi-Family,Residential-Single Family","ListAgentKey":"NST506458","ListAgentMlsId":"NST506019249","ListOfficeMlsId":"NST25853","ListOfficeName":"Red Fence Realty, LLC","ListOfficeKey":"NST25853","ModificationTimestamp":"2026-05-03T17:36:07.076Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Kitchen.jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/f1388cec-be23-4342-ae38-5500378e529f.jpeg\",\"ImageWidth\":582,\"ImageHeight\":440,\"ImageSizeDescription\":\"582x440\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.424Z\",\"MediaKey\":\"NST121946905\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"4 Houses.jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/8f206926-cbf5-4c26-87a7-0646a0fa39e1.jpeg\",\"ImageWidth\":1047,\"ImageHeight\":565,\"ImageSizeDescription\":\"1047x565\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.417Z\",\"MediaKey\":\"NST121946882\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"front.jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/3cb74807-e8b3-48db-90f6-0338076c6f33.jpeg\",\"ImageWidth\":1187,\"ImageHeight\":782,\"ImageSizeDescription\":\"1187x782\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.42Z\",\"MediaKey\":\"NST121946894\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"image(3).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/f35817ab-ce69-4219-89ba-575f36730071.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.423Z\",\"MediaKey\":\"NST121946826\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"Restaurants Near Selby.jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/6b7f0e73-88c8-49a5-b914-e2f4c5786ba0.jpeg\",\"ImageWidth\":906,\"ImageHeight\":632,\"ImageSizeDescription\":\"906x632\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.416Z\",\"MediaKey\":\"NST121946908\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"image.jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/3b2b5ada-3217-4b41-8540-56f907e2609b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.428Z\",\"MediaKey\":\"NST121946821\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"image(1).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/8b29876c-5b7a-4e3a-ba62-1136ef441eed.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.428Z\",\"MediaKey\":\"NST121946828\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"image(4).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/7226350d-2dc8-46b6-bbe0-cbaaba524f5d.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.422Z\",\"MediaKey\":\"NST121946825\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"image(2).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/2bf28362-a7df-4187-b553-c5e713f2d048.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.429Z\",\"MediaKey\":\"NST121946827\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"image(6).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/0471f277-3de1-4321-957f-4b890e878871.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.465Z\",\"MediaKey\":\"NST121946823\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"image 2.jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/64aa10fa-53f1-40ea-b5ab-8c572f78fc8c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.432Z\",\"MediaKey\":\"NST121946829\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"image(5).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/40a99bfb-f05b-49e3-b8d6-133b8ae943a8.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.446Z\",\"MediaKey\":\"NST121946824\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"image(7).jpg\",\"ResourceRecordKey\":\"NST7895286\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7895286/128e7ba5-83a1-45d5-a93f-c470c2cc1433.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-05-03T17:36:04.44Z\",\"MediaKey\":\"NST121946822\"}]","Media__Order":"5","Media__MediaObjectID":"NST5","Media__LongDescription":"Kitchen.jpg","Media__ResourceRecordKey":"NST7895286","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7895286/f1388cec-be23-4342-ae38-5500378e529f.jpeg","Media__ImageWidth":"582","Media__ImageHeight":"440","Media__ImageSizeDescription":"582x440","Media__MediaModificationTimestamp":"5/3/2026 5:36:04 PM","Media__MediaKey":"NST121946905","DocumentsChangeTimestamp":"2026-05-03T17:36:07.076Z","Rooms":"[{\"RoomType\":\"Three Season Porch\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190473\",\"RoomDimensions\":\"8x23\"},{\"RoomType\":\"Bonus Room\",\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116190476\",\"RoomDimensions\":\"20x26\"},{\"RoomType\":\"Deck\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190474\",\"RoomDimensions\":\"8x10\"},{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190468\",\"RoomDimensions\":\"11x13\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190470\",\"RoomDimensions\":\"10x11\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190469\",\"RoomDimensions\":\"13x14\"},{\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190467\",\"RoomDimensions\":\"11x25\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116190471\",\"RoomDimensions\":\"10x11\"},{\"RoomType\":\"Storage\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116190475\",\"RoomDimensions\":\"10x14\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116190472\",\"RoomDimensions\":\"12x21\"}]","Rooms__RoomType":"Three Season Porch","Rooms__NST_RoomSortOrder":"7","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST116190473","Rooms__RoomDimensions":"8x23","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"front.jpg\"},{\"Order\":2,\"Remarks\":\"image(6).jpg\"},{\"Order\":3,\"Remarks\":\"image.jpg\"},{\"Order\":4,\"Remarks\":\"image 2.jpg\"},{\"Order\":5,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"image(3).jpg\"},{\"Order\":7,\"Remarks\":\"image(2).jpg\"},{\"Order\":8,\"Remarks\":\"image(1).jpg\"},{\"Order\":9,\"Remarks\":\"image(4).jpg\"},{\"Order\":10,\"Remarks\":\"image(5).jpg\"},{\"Order\":11,\"Remarks\":\"image(7).jpg\"},{\"Order\":12,\"Remarks\":\"4 Houses.jpg\"},{\"Order\":13,\"Remarks\":\"Restaurants Near Selby.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}