{"Id":1417712,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6797293","MLSAGENTID":"NST502015699","MLSOFFICEID":"NST5917","ADDRESS":"568 Farrington Street","ACRES":0.15,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":1550.0,"LASTPRICEDATE":"2025-10-04T17:19:04.037","LATITUDE":44.958199,"LENDEROWNED":"No","LISTDATE":"2025-10-04T05:00:00","LISTPRICE":1550.0,"LIVINGAREA":880.0,"LONGITUDE":-93.113203,"LOTDESCRIPTION":"Zero Lot Line","MODIFICATIONTIMESTAMP":"2025-10-05T02:06:04.813","NEIGHBORHOOD":"Thomas-Dale (Frogtown)","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":14,"POSTALCODE":"55103","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-04T17:19:04.037","LASTSTATUS":"Active","STREETNAME":"Farrington","STREETNUMBER":"568","STREETSUFFIX":"Street","STYLE":"Apartment","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1906,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-05T02:06:04.813","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1_8f8a2702.jpg\"},{\"Order\":2,\"Remarks\":\"2_8f8a2687.jpg\"},{\"Order\":3,\"Remarks\":\"3_8f8a2632.jpg\"},{\"Order\":4,\"Remarks\":\"4_8f8a2637.jpg\"},{\"Order\":5,\"Remarks\":\"5_8f8a2647.jpg\"},{\"Order\":6,\"Remarks\":\"6_8f8a2667.jpg\"},{\"Order\":7,\"Remarks\":\"7_8f8a2672.jpg\"},{\"Order\":8,\"Remarks\":\"8_8f8a2652.jpg\"},{\"Order\":9,\"Remarks\":\"9_8f8a2657.jpg\"},{\"Order\":10,\"Remarks\":\"10_8f8a2677.jpg\"},{\"Order\":11,\"Remarks\":\"11_8f8a2682.jpg\"},{\"Order\":12,\"Remarks\":\"12_8f8a2662.jpg\"},{\"Order\":13,\"Remarks\":\"13_8f8a2692.jpg\"},{\"Order\":14,\"Remarks\":\"14_8f8a2697.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7809697","LotSizeArea":"0.15","NST_AgeOfProperty":"119","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","Appliances":"Disposal,Exhaust Fan","NST_ApplicationFee":"0.0000","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"True","NST_AttributionContact":"612-750-0035","NST_AttributionName":"Christopher P Grimes","AvailabilityDate":"2025-10-01T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"None","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential Lease","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","Directions":"N/A","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Vinyl Siding","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"44x20","FoundationArea":"880","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Electric,Natural Gas","Furnished":"Unfurnished","ParkingFeatures":"None","AccessibilityFeatures":"Other","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-04T17:17:43Z","NST_InternetOptions":"Cable,Satellite","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-04","Latitude":"44.958199","NST_LeasePrice":"1550.0000","NST_LenderOwned":"No","ListAgentKey":"NST82137","ListAgentMlsId":"NST502015699","ListingContractDate":"2025-10-04T05:00:00Z","ListOfficeKey":"NST16645","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST5917","LivingArea":"880","Longitude":"-93.113203","LotFeatures":"Zero Lot Line","LotSizeDimensions":"0","LotSizeUnits":"Acres","ListingId":"NST6797293","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Thomas-Dale (Frogtown)","NST_OfficeBoard":"MAAR","OwnerPays":"Gas,Trash Collection,Water","ParcelNumber":"362923130065","GarageSpaces":"0","PhotosCount":"14","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55103","NST_PrePaidRent":"Yes","NST_PresentUse":"Yearly","PublicSurveyRange":"23","PublicSurveySection":"36","PublicSurveyTownship":"29","ListPrice":"1550","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","RoomType":"Kitchen,Family Room,Bedroom 1,Bedroom 2,Bedroom 3,Foyer","NST_AboveGradeSqFtTotal":"880.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"880.0000","BuildingAreaTotal":"880","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","NST_SecurityDeposit":"0.0000","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"No","NST_SpecialSearch":"3 BR on One Level,All Living Facilities on One Level,Main Floor Bedroom","AboveGradeFinishedArea":"880","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Farrington","StreetNumber":"568","StreetNumberNumeric":"568","StreetSuffix":"Street","PropertySubType":"Apartment","SubdivisionName":"Robertson & Van Etten, Addition","TenantPays":"Heat","UnitNumber":"1","WaterSource":"City Water/Connected","YearBuilt":"1906","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-10-05T02:06:04.813Z","PhotosChangeTimestamp":"2025-10-05T02:06:04.813Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7809697\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1_8f8a2702.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/79cbfef5-311c-4709-82a0-58f276a2d2c2.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.523Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1c4\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"2_8f8a2687.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/2d10dd6d-261f-49c9-b9ee-2f48f59e8d9d.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.523Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1c5\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"3_8f8a2632.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/5b5c7dee-a4a9-44b2-89b6-31987e5efe51.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.47Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1c6\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"4_8f8a2637.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/bd004eee-4975-42ce-9859-1ffb40d140b7.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.503Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1c7\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"5_8f8a2647.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/40b22489-47d0-47c1-ab07-c225dc7fead8.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.469Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1c8\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"6_8f8a2667.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/d37d91e0-4c0a-4d24-a994-55f866faae13.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.495Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1c9\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"7_8f8a2672.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/8ab4afb7-c2e2-4c2b-8ed6-29a66ffd0c2c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.522Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1ca\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8_8f8a2652.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/0a148352-2f0c-4db3-9174-af7d082fa04e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.471Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1cb\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"9_8f8a2657.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/eaff0394-c75e-4e54-acf2-c2bf2c03c2aa.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.508Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1cc\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"10_8f8a2677.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/197ff2f0-cbc7-465d-8856-47a578927e74.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.463Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1cd\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"11_8f8a2682.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/ef4d89fa-2b69-47eb-ab8b-433220a97b8e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.48Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1ce\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"12_8f8a2662.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/2303875a-5390-40eb-ad20-cb0b5bdf13e4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.487Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1cf\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"13_8f8a2692.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/ff4c84e4-4bc6-4db6-9343-fd3b19f0a288.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.498Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1d0\"},{\"ResourceRecordKey\":\"NST7809697\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"14_8f8a2697.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809697/5518b6a3-b106-4d51-b597-be55f41de837.jpeg\",\"MediaModificationTimestamp\":\"2025-10-05T02:05:16.656Z\",\"MediaKey\":\"68e1d25c37c2ee1480a5f1d1\"}]","Rooms":"[{\"RoomKey\":\"NST115674410\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x11\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115674411\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115674412\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115674413\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x8\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115674414\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x8\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115674415\",\"RoomType\":\"Foyer\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x5\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1_8f8a2702.jpg\"},{\"Order\":2,\"Remarks\":\"2_8f8a2687.jpg\"},{\"Order\":3,\"Remarks\":\"3_8f8a2632.jpg\"},{\"Order\":4,\"Remarks\":\"4_8f8a2637.jpg\"},{\"Order\":5,\"Remarks\":\"5_8f8a2647.jpg\"},{\"Order\":6,\"Remarks\":\"6_8f8a2667.jpg\"},{\"Order\":7,\"Remarks\":\"7_8f8a2672.jpg\"},{\"Order\":8,\"Remarks\":\"8_8f8a2652.jpg\"},{\"Order\":9,\"Remarks\":\"9_8f8a2657.jpg\"},{\"Order\":10,\"Remarks\":\"10_8f8a2677.jpg\"},{\"Order\":11,\"Remarks\":\"11_8f8a2682.jpg\"},{\"Order\":12,\"Remarks\":\"12_8f8a2662.jpg\"},{\"Order\":13,\"Remarks\":\"13_8f8a2692.jpg\"},{\"Order\":14,\"Remarks\":\"14_8f8a2697.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}