{"Id":588042,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7112126","MLSAGENTID":"NST506095956","MLSOFFICEID":"NST10956","ADDRESS":"1173 Mclean Avenue","ACRES":0.108,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":1.0,"BEDROOMS":2.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":209900.0,"LASTPRICEDATE":"2026-07-19T18:07:06.677","LATITUDE":44.9531864,"LENDEROWNED":"No","LISTDATE":"2026-07-19T05:00:00","LISTPRICE":209900.0,"LIVINGAREA":1102.0,"LONGITUDE":-93.06122392,"MODIFICATIONTIMESTAMP":"2026-07-20T10:18:10.085","NEIGHBORHOOD":"90","OFFICE_OFFICENAME":"Creative Results","PHOTOCOUNT":4,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"High-demand home on the East Side Saint Paul neighborhood! Conveniently located on a major highways and shopping centers, this home offers both comfort and accessibility. Enjoy a spacious living area that opens to a beautiful four-season enclosed porch, perfect for relaxing year-round. The lower level features a versatile office and a cozy den, providing flexible space for working from home, hobbies, or additional living needs. This is a wonderful opportunity to own a home with plenty of potential.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-19T18:07:06.677","LASTSTATUS":"Active","STREETNAME":"Mclean","STREETNUMBER":"1173","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1922,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-19T18:07:06.677","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"}]","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7936877","NST_AboveGradeSqFtTotal":"992","AboveGradeFinishedArea":"992","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dryer,Gas Water Heater,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"110","BelowGradeFinishedArea":"110","CumulativeDaysOnMarket":"145","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"HWY 61 North to Burns Ave. go west take a right on Johnson Parkway left on Mclean","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"992","FoundationDetails":"Block","NST_FoundationDimensions":"0","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"220","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9531864011","NST_LenderOwned":"No","Levels":"One","ListPrice":"209900","ListingContractDate":"2026-07-19T05:00:00Z","ListingId":"NST7112126","LivingArea":"1102","Longitude":"-93.0612239194","LotSizeArea":"0.108","LotSizeDimensions":"128x37","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"992","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Dayton's Bluff","NST_NeighborhoodNumber":"90","OriginalEntryTimestamp":"2026-07-19T13:05:08Z","ParcelNumber":"332922430025","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Deck,Enclosed,Front Porch","PhotosCount":"4","PhotosChangeTimestamp":"2026-07-19T18:07:06.677Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"High-demand home on the East Side Saint Paul neighborhood! Conveniently located on a major highways and shopping centers, this home offers both comfort and accessibility. Enjoy a spacious living area that opens to a beautiful four-season enclosed porch, perfect for relaxing year-round. The lower level features a versatile office and a cozy den, providing flexible space for working from home, hobbies, or additional living needs. This is a wonderful opportunity to own a home with plenty of potential.","PublicSurveyRange":"22","PublicSurveySection":"33","PublicSurveyTownship":"29","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Mclean","StreetNumber":"1173","StreetNumberNumeric":"1173","StreetSuffix":"Avenue","SubdivisionName":"Kings Add To, St Paul, M","TaxAnnualAmount":"3842","NST_TaxWithAssessments":"3842","TaxYear":"2026","NST_TotalArea":"1102","BuildingAreaTotal":"1102","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1922","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST62343","ListAgentMlsId":"NST506095956","ListOfficeMlsId":"NST10956","ListOfficeName":"Creative Results","ListOfficeKey":"NST18608","ModificationTimestamp":"2026-07-20T10:18:10.085Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7936877\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936877/80181c89-a981-4071-b857-a54008d42404.jpeg\",\"LongDescription\":\"4.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-07-19T18:07:04.655Z\",\"MediaKey\":\"NST123694294\"},{\"ResourceRecordKey\":\"NST7936877\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936877/0c89af22-e60e-4ade-8de2-d499164d46ea.jpeg\",\"LongDescription\":\"3.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-07-19T18:07:04.655Z\",\"MediaKey\":\"NST123694295\"},{\"ResourceRecordKey\":\"NST7936877\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936877/44d079c2-3324-43c9-a94a-7cbd63614ee8.jpeg\",\"LongDescription\":\"2.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-07-19T18:07:04.767Z\",\"MediaKey\":\"NST123694296\"},{\"ResourceRecordKey\":\"NST7936877\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7936877/726c90f1-adf1-41a9-be3d-0c363ad59e47.jpeg\",\"LongDescription\":\"1.jpg\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaModificationTimestamp\":\"2026-07-19T18:07:04.667Z\",\"MediaKey\":\"NST123694297\"}]","Media__ResourceRecordKey":"NST7936877","Media__Order":"4","Media__MediaObjectID":"NST4","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7936877/80181c89-a981-4071-b857-a54008d42404.jpeg","Media__LongDescription":"4.jpg","Media__ImageWidth":"1024","Media__ImageHeight":"768","Media__ImageSizeDescription":"1024x768","Media__MediaModificationTimestamp":"7/19/2026 6:07:04 PM","Media__MediaKey":"NST123694294","DocumentsChangeTimestamp":"2026-07-19T18:06:06.122Z","Rooms":"[{\"RoomDimensions\":\"16x8\",\"RoomKey\":\"NST116474900\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":9},{\"RoomDimensions\":\"11x10\",\"RoomKey\":\"NST116474898\",\"RoomType\":\"Den\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":7},{\"RoomDimensions\":\"12x8\",\"RoomKey\":\"NST116474893\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomDimensions\":\"11x11\",\"RoomKey\":\"NST116474895\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4},{\"RoomDimensions\":\"18x7\",\"RoomKey\":\"NST116474897\",\"RoomType\":\"Four Season Porch\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6},{\"RoomDimensions\":\"18x11\",\"RoomKey\":\"NST116474894\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomDimensions\":\"20x11.6\",\"RoomKey\":\"NST116474892\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomDimensions\":\"11x10\",\"RoomKey\":\"NST116474899\",\"RoomType\":\"Office\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":8},{\"RoomDimensions\":\"11x11\",\"RoomKey\":\"NST116474896\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5}]","Rooms__RoomDimensions":"16x8","Rooms__RoomKey":"NST116474900","Rooms__RoomType":"Deck","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"9","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"}]","PhotoOrder":"1,2,3,4","CustomVTourURL":""}