{"Id":1402034,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6780691","MLSAGENTID":"NST506015923","MLSOFFICEID":"NST10982","ADDRESS":"439 Clinton Avenue","ACRES":0.1,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Finished,Concrete","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":299000.0,"LASTPRICEDATE":"2025-08-29T20:22:03.747","LATITUDE":44.93272609,"LENDEROWNED":"No","LISTDATE":"2025-08-29T05:00:00","LISTPRICE":299000.0,"LIVINGAREA":1872.0,"LONGITUDE":-93.07970116,"LOTDESCRIPTION":"Public Transit (w/in 6 blks)","MODIFICATIONTIMESTAMP":"2025-08-30T13:20:03.489","NEIGHBORHOOD":"West Side","OFFICE_OFFICENAME":"Bridge Realty, LLC","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":18,"POSTALCODE":"55107","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"SUPERB LOCATION: Quiet neighborhood just one block to Riverview Elementary, Community Center, Playgrounds, restaurants and Bus Stop; half-mile to Humboldt High School; less than one mile to Harriet Island and Lilydale Park; close to Downtown Saint Paul and Robert Street shopping. Many updates including landscaping, gardens, murals and more. Lower level features a large flex room, three-quarter bath, family/entertainment room, and unfinished space to be used creatively.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-29T20:22:03.747","LASTSTATUS":"Active","STREETNAME":"Clinton","STREETNUMBER":"439","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1973,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-08-30T13:14:03.682","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front.jpg\"},{\"Order\":2,\"Remarks\":\"Front_2.jpg\"},{\"Order\":3,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen_2.jpg\"},{\"Order\":5,\"Remarks\":\"Livingroom.jpg\"},{\"Order\":6,\"Remarks\":\"Breakfast Nook.jpg\"},{\"Order\":7,\"Remarks\":\"Main Bath.jpg\"},{\"Order\":8,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom_2.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom_3.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom_4.jpg\"},{\"Order\":12,\"Remarks\":\"Lower Level.jpg\"},{\"Order\":13,\"Remarks\":\"Flex Room.jpg\"},{\"Order\":14,\"Remarks\":\"Entertainment or Family room.jpg\"},{\"Order\":15,\"Remarks\":\"Lower Bath.jpg\"},{\"Order\":16,\"Remarks\":\"Lower Creative Space.jpg\"},{\"Order\":17,\"Remarks\":\"Backyard.jpg\"},{\"Order\":18,\"Remarks\":\"Back of Home.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7795449","LotSizeArea":"0.1","NST_AgeOfProperty":"52","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Daylight/Lookout Windows,Finished,Concrete","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Concord to Robert N to Isabel E to Clinton","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Vinyl Siding","Fencing":"Chain Link,Wood","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1144","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Asphalt","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-29T20:20:10Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-30","Latitude":"44.9327260886","NST_LenderOwned":"No","ListAgentKey":"NST113365","ListAgentMlsId":"NST506015923","ListingContractDate":"2025-08-29T05:00:00Z","ListOfficeKey":"NST18899","ListOfficeName":"Bridge Realty, LLC","ListOfficeMlsId":"NST10982","ListPrice":"299000","LivingArea":"1872","NST_LockBoxSource":"OTHER","LockBoxType":"Combo","Longitude":"-93.0797011593","LotFeatures":"Public Transit (w/in 6 blks)","LotSizeDimensions":"45x100","LotSizeSquareFeet":"4356","LotSizeUnits":"Acres","ListingId":"NST6780691","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"West Side","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"082822210055","GarageSpaces":"0","NST_ParkingOpen":"2","PhotosCount":"18","PostalCity":"Saint Paul","PostalCode":"55107","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"SUPERB LOCATION: Quiet neighborhood just one block to Riverview Elementary, Community Center, Playgrounds, restaurants and Bus Stop; half-mile to Humboldt High School; less than one mile to Harriet Island and Lilydale Park; close to Downtown Saint Paul and Robert Street shopping. Many updates including landscaping, gardens, murals and more. Lower level features a large flex room, three-quarter bath, family/entertainment room, and unfinished space to be used creatively.","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Flex Room,Family Room,Unfinished","NST_AboveGradeSqFtTotal":"1144.0000","NST_BelowGradeSqFtTotal":"684.0000","NST_MainLevelFinishedArea":"1144.0000","BuildingAreaTotal":"1828","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,4 BR on One Level","AboveGradeFinishedArea":"1144","BelowGradeFinishedArea":"728","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Clinton","StreetNumber":"439","StreetNumberNumeric":"439","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"3910.0000","TaxYear":"2025","TaxAnnualAmount":"3910","WaterSource":"City Water/Connected","YearBuilt":"1973","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-30T13:20:03.489Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7795449\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/ae1e2d41-62ac-4a16-a679-2585a895e6eb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.637Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c3\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Front_2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1239,\"ImageSizeDescription\":\"2080x1239\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/ebb9b5dd-67eb-4f46-a45a-4a9b182553e4.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.508Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c4\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Kitchen.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/d9a2dede-2e75-474a-9604-321d3cb7a219.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.505Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c5\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Kitchen_2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/632af4a8-75d0-4d61-875a-1ef92ed4113b.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.551Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c6\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Livingroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/6dda6cdb-c10a-4a70-97ae-5a9e17547f4d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.489Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1d0\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Breakfast Nook.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/d93b1a91-804f-4bcf-b293-996514266064.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.56Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1cd\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Main Bath.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/ddabbd6f-f73e-49b7-bafe-f73433c1dc4a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.527Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1d4\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Bedroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/7c00de26-a7f2-4ecf-808e-d0c827115833.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.505Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c9\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Bedroom_2.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/5ebca5c2-15ef-4a35-8414-141e285e7f1e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.586Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1ca\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Bedroom_3.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/8f216a91-5e73-4c3c-9f82-79354fc42016.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.51Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1cb\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Bedroom_4.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/0fa94dc0-6e2a-4331-86c1-9d8c966fb30e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.472Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1cc\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Lower Level.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/6fcca854-90a5-4de9-86ab-882bc08ccf37.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.577Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1d3\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Flex Room.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/377aa8f9-722d-471b-bb26-a0012e48e416.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.489Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1cf\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Entertainment or Family room.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/0d92f55b-409a-4bbe-ae93-131e269e171e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.507Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1ce\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Lower Bath.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/400e6168-82a1-4456-8848-cb00269ecaa7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.509Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1d1\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Lower Creative Space.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/91ffefdf-b09b-4436-bbda-c7bc0dad4289.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.574Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1d2\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Backyard.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/877bfc2b-e089-4109-8782-b7e564047d8a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.505Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c8\"},{\"ResourceRecordKey\":\"NST7795449\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"Back of Home.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795449/f43f70b4-da77-4eba-bebe-846a3040d997.jpeg\",\"MediaModificationTimestamp\":\"2025-08-30T13:09:21.566Z\",\"MediaKey\":\"68b2f80135c78c1bfd40b1c7\"}]","PhotosChangeTimestamp":"2025-08-30T13:14:03.682Z","Rooms":"[{\"RoomKey\":\"NST115565256\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115565257\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115565258\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115565259\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115565260\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x8\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115565261\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115565356\",\"RoomType\":\"Flex Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"15x10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115565357\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x26\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115565358\",\"RoomType\":\"Unfinished\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x13\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front.jpg\"},{\"Order\":2,\"Remarks\":\"Front_2.jpg\"},{\"Order\":3,\"Remarks\":\"Kitchen.jpg\"},{\"Order\":4,\"Remarks\":\"Kitchen_2.jpg\"},{\"Order\":5,\"Remarks\":\"Livingroom.jpg\"},{\"Order\":6,\"Remarks\":\"Breakfast Nook.jpg\"},{\"Order\":7,\"Remarks\":\"Main Bath.jpg\"},{\"Order\":8,\"Remarks\":\"Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"Bedroom_2.jpg\"},{\"Order\":10,\"Remarks\":\"Bedroom_3.jpg\"},{\"Order\":11,\"Remarks\":\"Bedroom_4.jpg\"},{\"Order\":12,\"Remarks\":\"Lower Level.jpg\"},{\"Order\":13,\"Remarks\":\"Flex Room.jpg\"},{\"Order\":14,\"Remarks\":\"Entertainment or Family room.jpg\"},{\"Order\":15,\"Remarks\":\"Lower Bath.jpg\"},{\"Order\":16,\"Remarks\":\"Lower Creative Space.jpg\"},{\"Order\":17,\"Remarks\":\"Backyard.jpg\"},{\"Order\":18,\"Remarks\":\"Back of Home.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}