{"Id":1414213,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6795697","MLSAGENTID":"NST506094338","MLSOFFICEID":"NST10071","ADDRESS":"224 Fairview Avenue N","ACRES":0.06,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":1895.0,"LASTPRICEDATE":"2025-09-27T17:43:03.593","LATITUDE":44.947957,"LENDEROWNED":"No","LISTDATE":"2025-09-26T05:00:00","LISTPRICE":1895.0,"LIVINGAREA":2280.0,"LONGITUDE":-93.176937,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-09-27T17:43:03.594","NEIGHBORHOOD":"Merriam Park/Lexington-Hamline","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":0,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Upper duplex. Two bedroom, plus den for workspace. New queen mattress, new dishwasher, new smart tv, new portable AC, and more. Cozy, with everything you will need for kitchen and comfortable living. Share the house with owners who live on first floor duplex. Quiet professional space to relax.\n\nGreat neighborhood with tons to do. Walk to Whole Foods, neighborhood restaurants, and shops. Bike to the Mississippi river and Allianz soccer field. Easy access to freeways. Close to all major St. Paul and Minneapolis colleges and university campuses.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Architectural Shingle","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-27T17:43:03.593","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Fairview","STREETNUMBER":"224","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1909,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-27T17:40:04.284","SOURCE":"MG_NST"}
{"ListingKey":"NST7808376","LotSizeArea":"0.06","NST_AgeOfProperty":"116","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors","Appliances":"Dishwasher,Microwave,Range,Refrigerator","NST_ApplicationFee":"100.0000","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"True","AvailabilityDate":"2025-09-28T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"Finished","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential Lease","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"Fairview & Marshall, Snelling to Marshall, West to Fairview, South to Home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Wood Siding","Fencing":"Wood","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"890","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Furnished","ParkingFeatures":"None","AccessibilityFeatures":"None","Heating":"Hot Water,Radiator(s)","OriginalEntryTimestamp":"2025-09-27T17:38:52Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-27","Latitude":"44.947957","NST_LeasePrice":"1895.0000","NST_LenderOwned":"No","ListAgentKey":"NST53356","ListAgentMlsId":"NST506094338","ListingContractDate":"2025-09-26T05:00:00Z","ListOfficeKey":"NST16710","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeMlsId":"NST10071","LivingArea":"2280","Longitude":"-93.176937","LotFeatures":"Public Transit (w/in 6 blks),Many Trees","LotSizeDimensions":"45x54","LotSizeUnits":"Acres","ListingId":"NST6795697","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Merriam Park/Lexington-Hamline","NST_OfficeBoard":"SPAAR","OwnerPays":"Heat,Trash Collection,Water","ParcelNumber":"042823120115","GarageSpaces":"0","PhotosCount":"0","PostalCity":"Saint Paul","PostalCode":"55104","NST_PrePaidRent":"No","NST_PresentUse":"Yearly","PublicRemarks":"Upper duplex. Two bedroom, plus den for workspace. New queen mattress, new dishwasher, new smart tv, new portable AC, and more. Cozy, with everything you will need for kitchen and comfortable living. Share the house with owners who live on first floor duplex. Quiet professional space to relax.\n\nGreat neighborhood with tons to do. Walk to Whole Foods, neighborhood restaurants, and shops. Bike to the Mississippi river and Allianz soccer field. Easy access to freeways. Close to all major St. Paul and Minneapolis colleges and university campuses.","PublicSurveyRange":"23","PublicSurveySection":"04","PublicSurveyTownship":"28","ListPrice":"1895","NST_RentalLicenseYN":"No","Roof":"Architectural Shingle","RoomType":"Bedroom 1,Bedroom 2,Kitchen,Living Room,Bar/Wet Bar Room","NST_AboveGradeSqFtTotal":"890.0000","NST_BelowGradeSqFtTotal":"890.0000","NST_MainLevelFinishedArea":"890.0000","BuildingAreaTotal":"1780","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","NST_SecurityDeposit":"1000.0000","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"No","AboveGradeFinishedArea":"1780","BelowGradeFinishedArea":"500","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"N","StreetName":"Fairview","StreetNumber":"224","StreetNumberNumeric":"224","StreetSuffix":"Avenue","PropertySubType":"Duplex Up and Down","SubdivisionName":"Skidmore & Cassedys, Park Add","TenantPays":"Heat,Trash Collection,Water","WaterSource":"City Water/Connected","YearBuilt":"1909","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-27T17:43:03.594Z","OriginatingSystemName":"northstar","PhotosChangeTimestamp":"2025-09-27T17:40:04.284Z","Rooms":"[{\"RoomKey\":\"NST115652832\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x9\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115652833\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x8\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115652834\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115652835\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"17x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115652836\",\"RoomType\":\"Bar/Wet Bar Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","CustomVTourURL":""}