{"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-27T21:15:03.588","NEIGHBORHOOD":"Merriam Park/Lexington-Hamline","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":21,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Furnished, sun lit 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. Owner occupied on first floor of the duplex. Quiet professional space to relax. Unit is also available unfurnished for a longer term renter with modified terms.\n Great neighborhood with tons to do. Close to Whole Foods, neighborhood restaurants, and shops. Bike to the Mississippi river and Allianz soccer field. Easy access to freeways. Close 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-27T21:15:03.588","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"6.jpg\"},{\"Order\":6,\"Remarks\":\"7.jpg\"},{\"Order\":7,\"Remarks\":\"8.jpg\"},{\"Order\":8,\"Remarks\":\"9.jpg\"},{\"Order\":9,\"Remarks\":\"10.jpg\"},{\"Order\":10,\"Remarks\":\"11.jpg\"},{\"Order\":11,\"Remarks\":\"12.jpg\"},{\"Order\":12,\"Remarks\":\"13.jpg\"},{\"Order\":13,\"Remarks\":\"14.jpg\"},{\"Order\":14,\"Remarks\":\"15.jpg\"},{\"Order\":15,\"Remarks\":\"16.jpg\"},{\"Order\":16,\"Remarks\":\"17.jpg\"},{\"Order\":17,\"Remarks\":\"18.jpg\"},{\"Order\":18,\"Remarks\":\"19.jpg\"},{\"Order\":19,\"Remarks\":\"20.jpg\"},{\"Order\":20,\"Remarks\":\"21.jpg\"},{\"Order\":21,\"Remarks\":\"22.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":"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":"21","PostalCity":"Saint Paul","PostalCode":"55104","NST_PrePaidRent":"No","NST_PresentUse":"Yearly","PublicRemarks":"Furnished, sun lit 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. Owner occupied on first floor of the duplex. Quiet professional space to relax. Unit is also available unfurnished for a longer term renter with modified terms.\n Great neighborhood with tons to do. Close to Whole Foods, neighborhood restaurants, and shops. Bike to the Mississippi river and Allianz soccer field. Easy access to freeways. Close 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-27T21:15:03.588Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7808376\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/a3c8b3ba-9da6-460e-a3e1-a9e95e169f9a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.228Z\",\"MediaKey\":\"68d84feea5496360e4e55640\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"2.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/ad81646d-3c61-4e31-92d2-9e9ffda87ef1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.225Z\",\"MediaKey\":\"68d84feea5496360e4e55641\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"3.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/083e0666-e530-4418-b38a-e27addcde730.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.22Z\",\"MediaKey\":\"68d84feea5496360e4e55642\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"4.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/45b9153c-8d4b-4d31-898d-583b4762aa3e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.22Z\",\"MediaKey\":\"68d84feea5496360e4e55643\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"6.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/e67198cb-37ee-4d42-901c-5209ab0dafae.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.223Z\",\"MediaKey\":\"68d84feea5496360e4e55645\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"7.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/75d98d2d-6593-468e-b2f4-1f07364856f7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.217Z\",\"MediaKey\":\"68d84feea5496360e4e55646\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"8.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/52c2e38f-da55-4fab-bf71-9150c59d16ec.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.22Z\",\"MediaKey\":\"68d84feea5496360e4e55647\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"9.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/4c4c2eb2-f70b-4c18-a43b-b8591595436a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.213Z\",\"MediaKey\":\"68d84feea5496360e4e55648\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"10.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/580ae2b3-303a-4d83-ad03-b84a809be199.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.218Z\",\"MediaKey\":\"68d84feea5496360e4e55649\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"11.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/63ce46b4-6a3b-4ddd-bbb2-21c6361e2b79.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.213Z\",\"MediaKey\":\"68d84feea5496360e4e5564a\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"12.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/9d6f8826-fe83-4cb7-8d19-f4595b55d904.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.213Z\",\"MediaKey\":\"68d84feea5496360e4e5564b\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"13.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/7139eeac-c6ea-45b4-bed1-c9629a2873db.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.219Z\",\"MediaKey\":\"68d84feea5496360e4e5564c\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"14.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/f7ac797d-4772-4dd5-bf66-ebc9aa4ef51c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.21Z\",\"MediaKey\":\"68d84feea5496360e4e5564d\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"15.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/2c1defb5-c66f-4f8f-b5eb-f3a354f859e3.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.221Z\",\"MediaKey\":\"68d84feea5496360e4e5564e\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"16.jpg\",\"ImageWidth\":194,\"ImageHeight\":243,\"ImageSizeDescription\":\"194x243\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/1e7c15a0-cc76-4015-8aa3-8245021afcfc.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.218Z\",\"MediaKey\":\"68d84feea5496360e4e5564f\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"17.jpg\",\"ImageWidth\":194,\"ImageHeight\":162,\"ImageSizeDescription\":\"194x162\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/be235e4e-71b1-4364-ad89-24dda6317f09.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.208Z\",\"MediaKey\":\"68d84feea5496360e4e55650\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"18.jpg\",\"ImageWidth\":178,\"ImageHeight\":127,\"ImageSizeDescription\":\"178x127\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/b972159f-f18e-416b-b192-9c26d98b0ade.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.208Z\",\"MediaKey\":\"68d84feea5496360e4e55651\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"19.jpg\",\"ImageWidth\":780,\"ImageHeight\":585,\"ImageSizeDescription\":\"780x585\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/b3dafe98-851e-4cba-b4db-c073e4777afe.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.205Z\",\"MediaKey\":\"68d84feea5496360e4e55652\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"20.jpg\",\"ImageWidth\":900,\"ImageHeight\":562,\"ImageSizeDescription\":\"900x562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/00a2de1a-f983-48d8-95fb-f62570b350a1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.222Z\",\"MediaKey\":\"68d84feea5496360e4e55653\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":20,\"MediaObjectID\":\"20\",\"LongDescription\":\"21.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/647470ff-779d-4973-a97a-fd048031c663.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.243Z\",\"MediaKey\":\"68d84feea5496360e4e55654\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":21,\"MediaObjectID\":\"21\",\"LongDescription\":\"22.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/e15f0e99-2bdb-4a18-bbee-9a61fd7cf1d7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T20:58:22.245Z\",\"MediaKey\":\"68d84feea5496360e4e55655\"}]","PhotosChangeTimestamp":"2025-09-27T21:15:03.588Z","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","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"6.jpg\"},{\"Order\":6,\"Remarks\":\"7.jpg\"},{\"Order\":7,\"Remarks\":\"8.jpg\"},{\"Order\":8,\"Remarks\":\"9.jpg\"},{\"Order\":9,\"Remarks\":\"10.jpg\"},{\"Order\":10,\"Remarks\":\"11.jpg\"},{\"Order\":11,\"Remarks\":\"12.jpg\"},{\"Order\":12,\"Remarks\":\"13.jpg\"},{\"Order\":13,\"Remarks\":\"14.jpg\"},{\"Order\":14,\"Remarks\":\"15.jpg\"},{\"Order\":15,\"Remarks\":\"16.jpg\"},{\"Order\":16,\"Remarks\":\"17.jpg\"},{\"Order\":17,\"Remarks\":\"18.jpg\"},{\"Order\":18,\"Remarks\":\"19.jpg\"},{\"Order\":19,\"Remarks\":\"20.jpg\"},{\"Order\":20,\"Remarks\":\"21.jpg\"},{\"Order\":21,\"Remarks\":\"22.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","CustomVTourURL":""}