$LABEL$$CONTENT$
$DESC$
MLS# 6795697 - 224 Fairview Avenue N Saint Paul, MN 55104
Keller Williams Integrity Realty is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Cummings Janzen Realty, Inc. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Cummings Janzen Realty, Inc., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"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":1695.0,"LASTPRICEDATE":"2025-11-05T18:20:03.793","LATITUDE":44.947957,"LENDEROWNED":"No","LISTDATE":"2025-09-26T05:00:00","LISTPRICE":1595.0,"LIVINGAREA":2280.0,"LONGITUDE":-93.176937,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-11-05T18:20:03.793","NEIGHBORHOOD":"Merriam Park/Lexington-Hamline","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":19,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Sunlit upper duplex with two bedrooms plus a den, perfect for a home office or creative workspace. Features include hardwood floors, built in bookcases, a new dishwasher and portable AC. Owner occupies the first floor of the duplex, ensuring a well-maintained and peaceful environment. Located in a neighborhood close to Whole Foods, Merriam Park library, local restaurants, and shops. Enjoy easy access to the Mississippi River, Allianz Field, major freeways, and all St. Paul and Minneapolis college 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-10-06T02:01:03.552","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\":\"9.jpg\"},{\"Order\":8,\"Remarks\":\"10.jpg\"},{\"Order\":9,\"Remarks\":\"11.jpg\"},{\"Order\":10,\"Remarks\":\"12.jpg\"},{\"Order\":11,\"Remarks\":\"22.jpg\"},{\"Order\":12,\"Remarks\":\"13.jpg\"},{\"Order\":13,\"Remarks\":\"15.jpg\"},{\"Order\":14,\"Remarks\":\"14.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\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","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","DaysOnMarket":"40","CumulativeDaysOnMarket":"40","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-11-05","Latitude":"44.947957","NST_LeasePrice":"1595.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":"19","PostalCity":"Saint Paul","PostalCode":"55104","NST_PrePaidRent":"No","NST_PresentUse":"Yearly","PublicRemarks":"Sunlit upper duplex with two bedrooms plus a den, perfect for a home office or creative workspace. Features include hardwood floors, built in bookcases, a new dishwasher and portable AC. Owner occupies the first floor of the duplex, ensuring a well-maintained and peaceful environment. Located in a neighborhood close to Whole Foods, Merriam Park library, local restaurants, and shops. Enjoy easy access to the Mississippi River, Allianz Field, major freeways, and all St. Paul and Minneapolis college and university campuses.","PublicSurveyRange":"23","PublicSurveySection":"04","PublicSurveyTownship":"28","ListPrice":"1595","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-11-05T18:20:03.793Z","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/621b6cea-00a4-4073-bccf-afcfddf1b89a.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.816Z\",\"MediaKey\":\"68e322c937c2ee1480a62183\"},{\"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/3bc5696d-ce09-4bc6-bbfb-1c4a56f7d64c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.806Z\",\"MediaKey\":\"68e322c937c2ee1480a62184\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":7,\"MediaObjectID\":\"7\",\"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\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"10.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/4b617c83-0cad-44bf-8869-7cabb1bc67d2.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.775Z\",\"MediaKey\":\"68e322c937c2ee1480a62185\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"11.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/57487e76-ebe5-4206-b343-ac0ab06c7ad6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.785Z\",\"MediaKey\":\"68e322c937c2ee1480a62186\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":10,\"MediaObjectID\":\"10\",\"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\":11,\"MediaObjectID\":\"11\",\"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\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"13.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/b159c7f3-a484-499c-91ba-2999e030e979.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.77Z\",\"MediaKey\":\"68e322c937c2ee1480a62187\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"15.jpg\",\"ImageWidth\":900,\"ImageHeight\":1200,\"ImageSizeDescription\":\"900x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/009a71f6-cfd4-484d-968e-3c605dfa2e6f.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.785Z\",\"MediaKey\":\"68e322c937c2ee1480a62188\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":14,\"MediaObjectID\":\"14\",\"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\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"16.jpg\",\"ImageWidth\":194,\"ImageHeight\":243,\"ImageSizeDescription\":\"194x243\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/0c7e1839-231e-42d2-be72-8043dae78f69.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.785Z\",\"MediaKey\":\"68e322c937c2ee1480a62189\"},{\"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/50ca95a4-31ac-42de-87a3-c06850d55e31.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.777Z\",\"MediaKey\":\"68e322c937c2ee1480a6218a\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"19.jpg\",\"ImageWidth\":780,\"ImageHeight\":585,\"ImageSizeDescription\":\"780x585\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/8ba84043-c854-494a-bba7-185e0d0b957e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.821Z\",\"MediaKey\":\"68e322c937c2ee1480a6218b\"},{\"ResourceRecordKey\":\"NST7808376\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"20.jpg\",\"ImageWidth\":900,\"ImageHeight\":562,\"ImageSizeDescription\":\"900x562\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808376/e821a856-62f8-4a44-a4b7-7ef19823cd74.jpeg\",\"MediaModificationTimestamp\":\"2025-10-06T02:00:41.795Z\",\"MediaKey\":\"68e322c937c2ee1480a6218c\"}]","PhotosChangeTimestamp":"2025-10-06T02:01:03.552Z","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\":\"9.jpg\"},{\"Order\":8,\"Remarks\":\"10.jpg\"},{\"Order\":9,\"Remarks\":\"11.jpg\"},{\"Order\":10,\"Remarks\":\"12.jpg\"},{\"Order\":11,\"Remarks\":\"22.jpg\"},{\"Order\":12,\"Remarks\":\"13.jpg\"},{\"Order\":13,\"Remarks\":\"15.jpg\"},{\"Order\":14,\"Remarks\":\"14.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\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}