{"Id":521461,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7025303","MLSAGENTID":"NST502054293","MLSOFFICEID":"NST5369","ADDRESS":"1596 Mclean Avenue","ACRES":0.14,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Shared Access","BATHSTOTAL":2.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":400000.0,"LASTPRICEDATE":"2026-02-23T20:57:06.263","LATITUDE":44.950233,"LENDEROWNED":"No","LISTDATE":"2026-02-23T06:00:00","LISTPRICE":400000.0,"LIVINGAREA":2013.0,"LONGITUDE":-93.032493,"MODIFICATIONTIMESTAMP":"2026-02-24T11:03:14.289","NEIGHBORHOOD":"88","OFFICE_OFFICENAME":"Home-Mart Realty","PHOTOCOUNT":5,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This turnkey rental is an ideal addition to your investment portfolio! The lower-level unit features brand-new carpets throughout, providing a fresh and inviting space. Conveniently situated near shopping centers and parks, it also offers easy access to highways, making it a prime location for tenants. Don't miss this opportunity to enhance your real estate investments!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-02-23T20:57:06.263","LASTSTATUS":"Active","STREETNAME":"Mclean","STREETNUMBER":"1596","STREETSUFFIX":"Avenue","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1963,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-02-23T20:59:07.225","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_4539.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_4538.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_4537.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_4536.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_4535.jpeg\"}]","PHOTOORDER":"1,2,3,4,5","SOURCE":"MG_NST"}
{"ListingKey":"NST7857022","NST_AboveGradeSqFtTotal":"2013","AboveGradeFinishedArea":"2013","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationAmenities":"Laundry","Basement":"Shared Access","BasementYN":"False","BathroomsTotalInteger":"2","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"2013","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Hwy 94 to Hwy 61, south to Burns Ave, east on Burns Ave, North on Hazelwood to McLean Ave, East to home.","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-02-23T20:59:07.225Z","DaysOnMarket":"0","ElectricExpense":"0","FoundationArea":"1056","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","GarageSpaces":"0","GrossIncome":"34400","Heating":"Hot Water","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InsuranceExpense":"2000","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.950233","LaundryFeatures":"Common Area","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"400000","ListingContractDate":"2026-02-23T06:00:00Z","ListingId":"NST7025303","LivingArea":"2013","Longitude":"-93.032493","LotSizeArea":"0.14","LotSizeDimensions":"60x120","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"2013","MaintenanceExpense":"1500","ManagerExpense":"0","NST_IncomeMiscAnn":"0","NST_IncomeMiscMon":"0","NST_RefrigeratorNum":"Two","NST_NeighborhoodNumber":"88","NumberOfUnitsTotal":"2","OperatingExpense":"3500","OriginalEntryTimestamp":"2026-02-23T14:54:10Z","OtherExpense":"0","NST_OwnerOccupied":"No","OwnerPays":"Trash Collection","ParcelNumber":"342922430074","NST_SchoolDistrictNumber":"2102","PhotosCount":"5","PhotosChangeTimestamp":"2026-02-23T20:59:07.225Z","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyType":"Residential Income","PublicRemarks":"This turnkey rental is an ideal addition to your investment portfolio! The lower-level unit features brand-new carpets throughout, providing a fresh and inviting space. Conveniently situated near shopping centers and parks, it also offers easy access to highways, making it a prime location for tenants. Don't miss this opportunity to enhance your real estate investments!","PublicSurveyRange":"22","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer - In Street","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Mclean","StreetNumber":"1596","StreetNumberNumeric":"1596","StreetSuffix":"Avenue","SubdivisionName":"Wessels Add","TaxAnnualAmount":"6456","NST_TaxWithAssessments":"0","TaxYear":"2025","Township":"Saint Paul","TrashExpense":"0","VideosCount":"0","WaterSewerExpense":"0","WaterSource":"City Water - In Street","YearBuilt":"1963","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST519653","ListAgentMlsId":"NST502054293","ListOfficeMlsId":"NST5369","ListOfficeName":"Home-Mart Realty","ListOfficeKey":"NST15745","ModificationTimestamp":"2026-02-24T11:03:14.289Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7857022/997f26ec-730c-4407-b64b-00b6ba3e7ac9.jpeg\",\"LongDescription\":\"IMG_4535.jpeg\",\"ResourceRecordKey\":\"NST7857022\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-23T20:58:29.525Z\",\"MediaKey\":\"NST120616975\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7857022/9863c6c0-1053-4cdb-b80c-40aab5de6a01.jpeg\",\"LongDescription\":\"IMG_4536.jpeg\",\"ResourceRecordKey\":\"NST7857022\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-23T20:58:29.584Z\",\"MediaKey\":\"NST120616976\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7857022/165987bb-b961-423a-b421-4ddacc24fb3a.jpeg\",\"LongDescription\":\"IMG_4538.jpeg\",\"ResourceRecordKey\":\"NST7857022\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-23T20:56:16.493Z\",\"MediaKey\":\"NST120616978\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7857022/ae8dd926-2a76-42b3-bdc8-a2d46aa9ee1a.jpeg\",\"LongDescription\":\"IMG_4537.jpeg\",\"ResourceRecordKey\":\"NST7857022\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-23T20:58:29.579Z\",\"MediaKey\":\"NST120616977\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7857022/d8cc2be3-33a3-4bb0-8e2c-7ba10a294bf3.jpeg\",\"LongDescription\":\"IMG_4539.jpeg\",\"ResourceRecordKey\":\"NST7857022\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-02-23T20:56:16.597Z\",\"MediaKey\":\"NST120616979\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7857022/997f26ec-730c-4407-b64b-00b6ba3e7ac9.jpeg","Media__LongDescription":"IMG_4535.jpeg","Media__ResourceRecordKey":"NST7857022","Media__Order":"5","Media__MediaObjectID":"NST5","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"2/23/2026 8:58:29 PM","Media__MediaKey":"NST120616975","UnitTypes":"[{\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":3,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":2,\"NST_UnitID\":1,\"UnitTypeTotalRent\":16,\"NST_UnitFireplaceNum\":1,\"NST_MonthlyExpenses\":1550,\"NST_UnitBathFull\":1,\"NST_UnitIsLeased\":\"N\",\"NST_UnitSqFt\":1056,\"UnitTypeKey\":\"NST158183\"},{\"NST_UnitLevel\":\"Below Ground\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":2,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":3,\"NST_UnitID\":2,\"UnitTypeTotalRent\":1250,\"NST_MonthlyExpenses\":100,\"NST_UnitBathFull\":1,\"NST_UnitIsLeased\":\"N\",\"NST_UnitSqFt\":900,\"UnitTypeKey\":\"NST158188\"}]","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__UnitTypeBedsTotal":"3","UnitTypes__UnitTypeUnitsTotal":"1","UnitTypes__NST_UnitRoomsTotal":"2","UnitTypes__NST_UnitID":"1","UnitTypes__UnitTypeTotalRent":"16","UnitTypes__NST_UnitFireplaceNum":"1","UnitTypes__NST_MonthlyExpenses":"1550","UnitTypes__NST_UnitBathFull":"1","UnitTypes__NST_UnitIsLeased":"N","UnitTypes__NST_UnitSqFt":"1056","UnitTypes__UnitTypeKey":"NST158183","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_4539.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_4538.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_4537.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_4536.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_4535.jpeg\"}]","PhotoOrder":"1,2,3,4,5","CustomVTourURL":""}