{"Id":1429277,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6814578","MLSAGENTID":"NST506068701","MLSOFFICEID":"NST9887","ADDRESS":"1599 Juno Avenue","ACRES":0.04,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":1,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":239900.0,"LASTPRICEDATE":"2025-11-18T17:48:03.94","LATITUDE":44.92622793,"LENDEROWNED":"No","LISTDATE":"2025-11-04T06:00:00","LISTPRICE":224900.0,"LIVINGAREA":690.0,"LONGITUDE":-93.16793522,"MODIFICATIONTIMESTAMP":"2025-11-18T17:48:03.94","NEIGHBORHOOD":"Highland","OFFICE_OFFICENAME":"Lynden Realty, Ltd.","PHOTOCOUNT":21,"POSTALCODE":"55116","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Charming efficient townhome in highland park. Perfect condo alternative, Airbnb, or in town residence. This 1920’s tiny home features hardwood floors, a large living room, eat-in kitchen, fireplace, ample closet space, laundry chute, and lower level expansion potential. Walk to coffee, services and restaurants. Easy access to public transportation and bike routes.**No association fee**","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-07T06:05:09.22","LASTSTATUS":"Coming Soon","STREETNAME":"Juno","STREETNUMBER":"1599","STREETSUFFIX":"Avenue","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1926,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-06T03:24:03.613","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"web_front.jpg\"},{\"Order\":2,\"Remarks\":\"web_Entry .jpg\"},{\"Order\":3,\"Remarks\":\"web_Living 1.jpg\"},{\"Order\":4,\"Remarks\":\"web_Living 4.jpg\"},{\"Order\":5,\"Remarks\":\"web_Living 2.jpg\"},{\"Order\":6,\"Remarks\":\"web_Living 3.jpg\"},{\"Order\":7,\"Remarks\":\"web_Living vert.jpg\"},{\"Order\":8,\"Remarks\":\"web_Bedroom one 2.jpg\"},{\"Order\":9,\"Remarks\":\"web_Bedroom one 1.jpg\"},{\"Order\":10,\"Remarks\":\"web_Bathroom vert.jpg\"},{\"Order\":11,\"Remarks\":\"web_Kitchen vert 4.jpg\"},{\"Order\":12,\"Remarks\":\"web_Kitchen vert 2.jpg\"},{\"Order\":13,\"Remarks\":\"web_Kitchen vert 3.jpg\"},{\"Order\":14,\"Remarks\":\"web_Kitchen vert.jpg\"},{\"Order\":15,\"Remarks\":\"web_Kitchen 3.jpg\"},{\"Order\":16,\"Remarks\":\"web_Kitchen 2.jpg\"},{\"Order\":17,\"Remarks\":\"web_Kitchen 1.jpg\"},{\"Order\":18,\"Remarks\":\"web_Lower 2.jpg\"},{\"Order\":19,\"Remarks\":\"web_Lower 3.jpg\"},{\"Order\":20,\"Remarks\":\"web_Lower 1.jpg\"},{\"Order\":21,\"Remarks\":\"web_Back patio.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","SOURCE":"MG_NST"}
{"ListingKey":"NST7824625","LotSizeArea":"0.04","NST_AgeOfProperty":"99","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Patio","Appliances":"Range","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"True","Basement":"Full,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"1","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"11","CumulativeDaysOnMarket":"11","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"94 to Snelling, South to Juno, West to property on your right","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-11-07","ConstructionMaterials":"Stucco","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"690","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"None","AccessibilityFeatures":"None","Heating":"Fireplace(s),Gravity","OriginalEntryTimestamp":"2025-11-07T06:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-18","Latitude":"44.9262279328","NST_LenderOwned":"No","ListAgentKey":"NST51715","ListAgentMlsId":"NST506068701","ListingContractDate":"2025-11-04T06:00:00Z","ListOfficeKey":"NST15565","ListOfficeName":"Lynden Realty, Ltd.","ListOfficeMlsId":"NST9887","ListPrice":"224900","LivingArea":"690","Longitude":"-93.1679352221","LotSizeDimensions":"40x45","LotSizeSquareFeet":"1742.4","LotSizeUnits":"Acres","ListingId":"NST6814578","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Highland","NST_OfficeBoard":"SPAAR","ParcelNumber":"092823410017","GarageSpaces":"0","PhotosCount":"21","PostalCity":"Saint Paul","PostalCode":"55116","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Charming efficient townhome in highland park. Perfect condo alternative, Airbnb, or in town residence. This 1920’s tiny home features hardwood floors, a large living room, eat-in kitchen, fireplace, ample closet space, laundry chute, and lower level expansion potential. Walk to coffee, services and restaurants. Easy access to public transportation and bike routes.**No association fee**","NST_RentalLicenseYN":"No","NST_Restrictions":"None","Roof":"Age 8 Years or Less","RoomType":"Living Room,Kitchen,Bedroom 1","NST_AboveGradeSqFtTotal":"690.0000","NST_BelowGradeSqFtTotal":"690.0000","NST_MainLevelFinishedArea":"690.0000","BuildingAreaTotal":"1380","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"690","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Juno","StreetNumber":"1599","StreetNumberNumeric":"1599","StreetSuffix":"Avenue","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Highland","NST_TaxWithAssessments":"3292.0000","TaxYear":"2025","TaxAnnualAmount":"3292","WaterSource":"City Water/Connected","YearBuilt":"1926","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-18T17:48:03.94Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7824625\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"web_front.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1203,\"ImageSizeDescription\":\"1800x1203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/2045e8da-5eff-4003-9ff8-3908b016c438.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.773Z\",\"MediaKey\":\"690c14bef250b31afa2de962\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"web_Entry .jpg\",\"ImageWidth\":1196,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1196x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/a183211c-a441-4852-8e0a-5dacb8f2140d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de963\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"web_Living 1.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/84797ed6-6690-4d85-92f5-808ac752e011.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.748Z\",\"MediaKey\":\"690c14bef250b31afa2de964\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"web_Living 4.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/ed87bc67-deea-4adf-b1b0-80ba2ea92e5a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.706Z\",\"MediaKey\":\"690c14bef250b31afa2de965\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"web_Living 2.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1202,\"ImageSizeDescription\":\"1800x1202\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/06852fca-bdca-408a-8ae5-b4b16d3e7998.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de966\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"web_Living 3.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1800x1201\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/6043e2f7-876e-4e5f-81e2-169a83032a6a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de967\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"web_Living vert.jpg\",\"ImageWidth\":1196,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1196x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/55f70cbe-12b7-48a3-a024-45cc351b1d7d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.708Z\",\"MediaKey\":\"690c14bef250b31afa2de968\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"web_Bedroom one 2.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1202,\"ImageSizeDescription\":\"1800x1202\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/6e1aefb5-c16a-480f-b7a0-785705965b78.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de969\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"web_Bedroom one 1.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1202,\"ImageSizeDescription\":\"1800x1202\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/a11a1a4d-f23b-450d-b4bf-6ee816c59ed0.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de96a\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"web_Bathroom vert.jpg\",\"ImageWidth\":1200,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1200x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/1a64ee08-6c79-48eb-8f22-1d52d775f974.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de96b\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"web_Kitchen vert 4.jpg\",\"ImageWidth\":1200,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1200x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/76fdc075-ecdb-42b9-a950-d81e96dd3b63.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de96c\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"web_Kitchen vert 2.jpg\",\"ImageWidth\":1199,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1199x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/7ea6720f-6f4e-4e25-8864-1eb339039710.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de96d\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"web_Kitchen vert 3.jpg\",\"ImageWidth\":1200,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1200x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/c5722786-b74c-447c-9313-03c33ad50bf2.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de96e\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"web_Kitchen vert.jpg\",\"ImageWidth\":1200,\"ImageHeight\":1800,\"ImageSizeDescription\":\"1200x1800\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/86c7b9f2-ef17-42e2-9c48-5afd6f4d337c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.7Z\",\"MediaKey\":\"690c14bef250b31afa2de96f\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"web_Kitchen 3.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1800x1201\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/416cb8bc-7a00-43c5-8595-daba74b6620b.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.728Z\",\"MediaKey\":\"690c14bef250b31afa2de970\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"web_Kitchen 2.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1203,\"ImageSizeDescription\":\"1800x1203\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/ab8df374-3ac4-4db7-ab6b-1e92c97067ee.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.701Z\",\"MediaKey\":\"690c14bef250b31afa2de971\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"web_Kitchen 1.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/563e8d5b-70c7-4160-84e8-f0cbeed36260.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.731Z\",\"MediaKey\":\"690c14bef250b31afa2de972\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"web_Lower 2.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/a6b9083e-139c-47ca-b0cb-2a7f12934ec3.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.708Z\",\"MediaKey\":\"690c14bef250b31afa2de973\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"web_Lower 3.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/7664a8a5-224a-44ac-bcd7-648c79cd3076.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.728Z\",\"MediaKey\":\"690c14bef250b31afa2de974\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":20,\"MediaObjectID\":\"20\",\"LongDescription\":\"web_Lower 1.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1198,\"ImageSizeDescription\":\"1800x1198\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/8774e078-117b-4382-944e-46686a831adc.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.746Z\",\"MediaKey\":\"690c14bef250b31afa2de975\"},{\"ResourceRecordKey\":\"NST7824625\",\"Order\":21,\"MediaObjectID\":\"21\",\"LongDescription\":\"web_Back patio.jpg\",\"ImageWidth\":1800,\"ImageHeight\":1201,\"ImageSizeDescription\":\"1800x1201\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824625/9ccea244-3224-490f-9d1b-432eaca37550.jpeg\",\"MediaModificationTimestamp\":\"2025-11-06T03:23:42.779Z\",\"MediaKey\":\"690c14bef250b31afa2de976\"}]","PhotosChangeTimestamp":"2025-11-06T03:24:03.613Z","Rooms":"[{\"RoomKey\":\"NST115758620\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115758623\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x7\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115758624\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"3\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"web_front.jpg\"},{\"Order\":2,\"Remarks\":\"web_Entry .jpg\"},{\"Order\":3,\"Remarks\":\"web_Living 1.jpg\"},{\"Order\":4,\"Remarks\":\"web_Living 4.jpg\"},{\"Order\":5,\"Remarks\":\"web_Living 2.jpg\"},{\"Order\":6,\"Remarks\":\"web_Living 3.jpg\"},{\"Order\":7,\"Remarks\":\"web_Living vert.jpg\"},{\"Order\":8,\"Remarks\":\"web_Bedroom one 2.jpg\"},{\"Order\":9,\"Remarks\":\"web_Bedroom one 1.jpg\"},{\"Order\":10,\"Remarks\":\"web_Bathroom vert.jpg\"},{\"Order\":11,\"Remarks\":\"web_Kitchen vert 4.jpg\"},{\"Order\":12,\"Remarks\":\"web_Kitchen vert 2.jpg\"},{\"Order\":13,\"Remarks\":\"web_Kitchen vert 3.jpg\"},{\"Order\":14,\"Remarks\":\"web_Kitchen vert.jpg\"},{\"Order\":15,\"Remarks\":\"web_Kitchen 3.jpg\"},{\"Order\":16,\"Remarks\":\"web_Kitchen 2.jpg\"},{\"Order\":17,\"Remarks\":\"web_Kitchen 1.jpg\"},{\"Order\":18,\"Remarks\":\"web_Lower 2.jpg\"},{\"Order\":19,\"Remarks\":\"web_Lower 3.jpg\"},{\"Order\":20,\"Remarks\":\"web_Lower 1.jpg\"},{\"Order\":21,\"Remarks\":\"web_Back patio.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","CustomVTourURL":""}