• Active/Pending
  • Clearwater - Recently Sold
  • Clearwater Lake Lots
  • Search MLS #
  • Search other lakes
  • Sign up for automated updates
  • Mortgage calculator
  • Favorites
  • Contact Us
  • MENU

    MLS# 6742043 - 820 Emerald Street Saint Paul, MN 55114

    Neighborhoods

    Keller Williams Classic 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

    {"Id":1372190,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6742043","MLSAGENTID":"NST506008884","MLSCOAGENTID":"NST506013995","MLSOFFICEID":"NST1865","ADDRESS":"820 Emerald Street","ACRES":0.91,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone","FORECLOSURE":"No","LASTPRICE":1800.0,"LASTPRICEDATE":"2025-06-19T17:35:04.533","LATITUDE":44.965538,"LENDEROWNED":"No","LISTDATE":"2025-06-19T05:00:00","LISTPRICE":1800.0,"LIVINGAREA":930.0,"LONGITUDE":-93.207381,"MODIFICATIONTIMESTAMP":"2025-06-20T02:05:04.534","NEIGHBORHOOD":"St. Anthony Park","OFFICE_OFFICENAME":"Keller Williams Classic Realty","PHOTOCOUNT":3,"POSTALCODE":"55114","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-19T17:35:04.533","LASTSTATUS":"Active","STREETNAME":"Emerald","STREETNUMBER":"820","STREETSUFFIX":"Street","STYLE":"High Rise","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2003,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-20T02:05:04.534","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_0236.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_0237.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_0238.jpg\"}]","PHOTOORDER":"1,2,3","SOURCE":"MG_NST"}
    {"ListingKey":"NST7761743","LotSizeArea":"0.91","NST_AgeOfProperty":"22","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Balcony,Security System,Walk-In Closet","Appliances":"Dishwasher,Disposal,Dryer,Electric Water Heater,Microwave,Range,Refrigerator,Washer","NST_ApplicationFee":"50.0000","AssociationFeeIncludes":"Air Conditioning,Maintenance Structure,Cable TV,Hazard Insurance,Internet,Lawn Care,Parking,Trash,Security,Sewer,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"240","PropertyAttachedYN":"True","AvailabilityDate":"2025-08-01T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential Lease","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"I-94 to Hwy. 280, N. immediate exit at Franklin Ave., East 5-blks on Franklin to Emerald, N. to 820 building","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"930","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","ParkingFeatures":"Underground","NST_GarageSquareFeet":"20","AccessibilityFeatures":"Accessible Elevator Installed","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-19T17:32:39Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-19","Latitude":"44.965538","NST_LeasePrice":"1800.0000","NST_LenderOwned":"No","ListAgentKey":"NST98319","ListAgentMlsId":"NST506008884","CoListAgentKey":"NST106868","CoListAgentMlsId":"NST506013995","ListingContractDate":"2025-06-19T05:00:00Z","ListOfficeKey":"NST14003","ListOfficeName":"Keller Williams Classic Realty","ListOfficeMlsId":"NST1865","LivingArea":"930","LockBoxType":"Combo","Longitude":"-93.207381","LotSizeDimensions":"na","LotSizeUnits":"Acres","ListingId":"NST6742043","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","LeaseTerm":"12 Months","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"St. Anthony Park","NST_OfficeBoard":"SPAAR","OwnerPays":"Cable TV,Trash Collection","ParcelNumber":"292923330145","GarageSpaces":"1","PhotosCount":"3","PostalCity":"Saint Paul","PostalCode":"55114","NST_PrePaidRent":"Yes","NST_PresentUse":"Yearly","PublicSurveyRange":"23","PublicSurveySection":"29","PublicSurveyTownship":"29","ListPrice":"1800","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Yes","NST_Restrictions":"Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit,Pets - Weight/Height Limit","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"930.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"930.0000","BuildingAreaTotal":"930","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","NST_SecurityDeposit":"1800.0000","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"No","AboveGradeFinishedArea":"930","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Emerald","StreetNumber":"820","StreetNumberNumeric":"820","StreetSuffix":"Street","PropertySubType":"High Rise","SubdivisionName":"Cic 486 Emerald Gardens","TenantPays":"Gas,Heat","UnitNumber":"307","WaterSource":"City Water/Connected","YearBuilt":"2003","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-20T02:05:04.534Z","PhotosChangeTimestamp":"2025-06-20T02:05:04.534Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7761743\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_0236.jpg\",\"ImageWidth\":1290,\"ImageHeight\":980,\"ImageSizeDescription\":\"1290x980\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7761743/45a3b654-2b28-475b-a37e-8336be1456d0.jpeg\",\"MediaModificationTimestamp\":\"2025-06-20T02:04:27.738Z\",\"MediaKey\":\"6854c1aba9795846e93f86d8\"},{\"ResourceRecordKey\":\"NST7761743\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_0237.jpg\",\"ImageWidth\":1290,\"ImageHeight\":950,\"ImageSizeDescription\":\"1290x950\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7761743/2e779b8f-c2eb-45a9-a0ba-471ad103ec02.jpeg\",\"MediaModificationTimestamp\":\"2025-06-20T02:04:27.776Z\",\"MediaKey\":\"6854c1aba9795846e93f86d9\"},{\"ResourceRecordKey\":\"NST7761743\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_0238.jpg\",\"ImageWidth\":1290,\"ImageHeight\":987,\"ImageSizeDescription\":\"1290x987\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7761743/c97c1b26-ab40-42ee-838e-c7ed837df7a6.jpeg\",\"MediaModificationTimestamp\":\"2025-06-20T02:04:27.75Z\",\"MediaKey\":\"6854c1aba9795846e93f86da\"}]","Rooms":"[{\"RoomKey\":\"NST115339716\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115339717\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115339718\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115339750\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115339751\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_0236.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_0237.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_0238.jpg\"}]","PhotoOrder":"1,2,3","CustomVTourURL":""}
    ©2025, All rights reserved. Created with REC by AfterNorth.