{"Id":594979,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7121070","MLSAGENTID":"NST506014979","MLSOFFICEID":"NST27016","ADDRESS":"4602 Pierce Street NE","ACRES":0.178,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Columbia Heights","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":3500.0,"LASTPRICEDATE":"2026-08-04T02:28:06.467","LATITUDE":45.051964,"LENDEROWNED":"No","LISTDATE":"2026-08-03T05:00:00","LISTPRICE":3500.0,"LIVINGAREA":2675.0,"LONGITUDE":-93.241508,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2026-08-04T02:28:06.467","OFFICE_OFFICENAME":"HomeSmart Sapphire Realty","PHOTOCOUNT":16,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Beautifully updated home situated on a large corner lot with a fully fenced backyard. This well maintained property features an open-concept floor plan, a spacious kitchen, convenient laundry area, and a whole-home water filtration system. The primary suite offers a walk-in closet, double-sink vanity, and a relaxing Jacuzzi tub. Generously sized bedrooms provide plenty of living space for everyone. Enjoy the convenience of an attached 3-car garage and an expansive driveway with ample additional parking. Conveniently located near parks, shopping, schools, and major highways. Minimum one-year lease required.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"13-Columbia Heights","SCHOOLDISTRICTPHONE":"7635284500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-04T02:28:06.467","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"Pierce","STREETNUMBER":"4602","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1997,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-04T02:28:06.467","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"4602 Pierce Front driveway\"},{\"Order\":2,\"Remarks\":\"4602 Pierce front\"},{\"Order\":3,\"Remarks\":\"4602 Livingroom\"},{\"Order\":4,\"Remarks\":\"DSC00989.JPG\"},{\"Order\":5,\"Remarks\":\"DSC00992.JPG\"},{\"Order\":6,\"Remarks\":\"DSC00994.JPG\"},{\"Order\":7,\"Remarks\":\"DSC01000.JPG\"},{\"Order\":8,\"Remarks\":\"DSC01003.JPG\"},{\"Order\":9,\"Remarks\":\"DSC01007.JPG\"},{\"Order\":10,\"Remarks\":\"DSC01010.JPG\"},{\"Order\":11,\"Remarks\":\"DSC01011.JPG\"},{\"Order\":12,\"Remarks\":\"DSC01013.JPG\"},{\"Order\":13,\"Remarks\":\"IMG_8311.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_8312.jpg\"},{\"Order\":15,\"Remarks\":\"4602 kitchen\"},{\"Order\":16,\"Remarks\":\"4602 backyard\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7945650","NST_AboveGradeSqFtTotal":"2051","AboveGradeFinishedArea":"2075","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Deck,Hardwood Floors,Kitchen Center Island,Patio,Walk-In Closet","Appliances":"Dishwasher,Dryer,Freezer,Water Filtration System,Microwave,Range,Refrigerator,Stainless Steel Appliances","NST_ApplicationFee":"50","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-08-01T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"Double Sink,Private Primary,Main Floor Full Bath","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"624","BelowGradeFinishedArea":"600","CumulativeDaysOnMarket":"0","City":"Columbia Heights","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","Directions":"I-694 to Central Ave (Hwy 65), south on Central Ave, east on 47th Ave NE, south on Pierce St NE to home on the right.","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","Fencing":"Chain Link,Full,Vinyl","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"624","FoundationDetails":"Poured Concrete","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","Furnished":"Unfurnished","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"Columbia Heights","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.051964","LaundryFeatures":"Laundry Room,Main Level","NST_LeasePrice":"3500","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2026-08-03T05:00:00Z","ListingId":"NST7121070","LivingArea":"2675","LockBoxType":"Supra","Longitude":"-93.241508","LotFeatures":"Corner Lot","LotSizeArea":"0.178","LotSizeDimensions":"75x120","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1151","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-03T21:26:34Z","OwnerPays":"None","ParcelNumber":"253024340129","ParkingFeatures":"Attached Garage","PhotosCount":"16","PhotosChangeTimestamp":"2026-08-04T02:28:06.467Z","PostalCity":"Columbia Heights","PostalCode":"55421","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","PublicRemarks":"Beautifully updated home situated on a large corner lot with a fully fenced backyard. This well maintained property features an open-concept floor plan, a spacious kitchen, convenient laundry area, and a whole-home water filtration system. The primary suite offers a walk-in closet, double-sink vanity, and a relaxing Jacuzzi tub. Generously sized bedrooms provide plenty of living space for everyone. Enjoy the convenience of an attached 3-car garage and an expansive driveway with ample additional parking. Conveniently located near parks, shopping, schools, and major highways. Minimum one-year lease required.","PublicSurveyRange":"24","PublicSurveySection":"25","PublicSurveyTownship":"30","NST_RentSpreeURL":"https://www.rentspree.com/apply/6a714d6f2494382b183d1a14?utm_source=northstarmls&utm_medium=applylink&utm_campaign=partner_integration","NST_RentSpreeYN":"Y","NST_SchoolDistrictFullName":"13 - Columbia Heights","NST_SchoolDistrictNumber":"13","NST_SchoolDistrictPhone":"7635284500","NST_SecurityDeposit":"3500","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"Pierce","StreetNumber":"4602","StreetNumberNumeric":"4602","StreetSuffix":"Street","SubdivisionName":"Heritage Heights","TenantPays":"All Utilities","NST_TotalArea":"2675","BuildingAreaTotal":"2675","Township":"Columbia Heights","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1997","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST108956","ListAgentMlsId":"NST506014979","ListOfficeMlsId":"NST27016","ListOfficeName":"HomeSmart Sapphire Realty","ListOfficeKey":"NST27016","ModificationTimestamp":"2026-08-04T02:28:06.467Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC01007.JPG\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/4ed239ee-9d8f-4af3-90dd-0a6407478c47.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.154Z\",\"MediaKey\":\"NST124021993\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC01013.JPG\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/5ba4fa75-c596-4bff-8227-1f9b8141f0f0.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.102Z\",\"MediaKey\":\"NST124021990\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC00992.JPG\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/67656df1-5439-4f4c-bc50-fd5d5479e56f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.17Z\",\"MediaKey\":\"NST124021997\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC00994.JPG\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/6cfbd52f-895e-4599-a8a0-81f0c2fdee26.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.116Z\",\"MediaKey\":\"NST124021996\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC01011.JPG\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/a1869b5c-4b2a-48bd-906b-3ff7631994de.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.102Z\",\"MediaKey\":\"NST124021991\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"IMG_8312.jpg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/cbe55bbb-677d-45f9-bdd6-769383c47f7c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.143Z\",\"MediaKey\":\"NST124021988\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC01010.JPG\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/e7a187ef-01dd-4cc4-8222-03e3babb8b1c.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.103Z\",\"MediaKey\":\"NST124021992\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC00989.JPG\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/f314939a-3a7b-458d-bf03-85c32bed74d8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.097Z\",\"MediaKey\":\"NST124021998\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC01003.JPG\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/75d182fa-a0bf-4e21-bcc8-ff5ceedeb4fc.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.098Z\",\"MediaKey\":\"NST124021994\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"DSC01000.JPG\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/48bbd2d8-7330-4b44-bf65-14a6e0260bae.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.104Z\",\"MediaKey\":\"NST124021995\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"IMG_8311.jpg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/0ccac1c6-5e39-4d12-abc9-9683a9da5ebd.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.135Z\",\"MediaKey\":\"NST124021989\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"4602 Pierce front\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/d79f0fbb-63c7-456a-9843-2478c9906003.jpeg\",\"ImageWidth\":1537,\"ImageHeight\":1023,\"ImageSizeDescription\":\"1537x1023\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.193Z\",\"MediaKey\":\"NST124021969\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"4602 Livingroom\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/5725e349-45f3-435f-b343-14e621c86982.jpeg\",\"ImageWidth\":1537,\"ImageHeight\":1023,\"ImageSizeDescription\":\"1537x1023\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.23Z\",\"MediaKey\":\"NST124021972\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"4602 Pierce Front driveway\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/0ada8337-f5f3-4797-ac48-ef2338695568.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.298Z\",\"MediaKey\":\"NST124021970\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"4602 kitchen\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/cab7ccfd-d048-410e-9b26-0eb2ef4f40e8.jpeg\",\"ImageWidth\":1448,\"ImageHeight\":1086,\"ImageSizeDescription\":\"1448x1086\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.196Z\",\"MediaKey\":\"NST124021999\"},{\"ResourceRecordKey\":\"NST7945650\",\"LongDescription\":\"4602 backyard\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7945650/a3097a74-e226-4e00-8f24-8832bd5a269f.jpeg\",\"ImageWidth\":1537,\"ImageHeight\":1023,\"ImageSizeDescription\":\"1537x1023\",\"MediaModificationTimestamp\":\"2026-08-04T02:27:08.213Z\",\"MediaKey\":\"NST124022000\"}]","Media__ResourceRecordKey":"NST7945650","Media__LongDescription":"DSC01007.JPG","Media__Order":"9","Media__MediaObjectID":"NST9","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7945650/4ed239ee-9d8f-4af3-90dd-0a6407478c47.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"8/4/2026 2:27:08 AM","Media__MediaKey":"NST124021993","DocumentsChangeTimestamp":"2026-08-04T02:27:06.097Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"4602 Pierce Front driveway\"},{\"Order\":2,\"Remarks\":\"4602 Pierce front\"},{\"Order\":3,\"Remarks\":\"4602 Livingroom\"},{\"Order\":4,\"Remarks\":\"DSC00989.JPG\"},{\"Order\":5,\"Remarks\":\"DSC00992.JPG\"},{\"Order\":6,\"Remarks\":\"DSC00994.JPG\"},{\"Order\":7,\"Remarks\":\"DSC01000.JPG\"},{\"Order\":8,\"Remarks\":\"DSC01003.JPG\"},{\"Order\":9,\"Remarks\":\"DSC01007.JPG\"},{\"Order\":10,\"Remarks\":\"DSC01010.JPG\"},{\"Order\":11,\"Remarks\":\"DSC01011.JPG\"},{\"Order\":12,\"Remarks\":\"DSC01013.JPG\"},{\"Order\":13,\"Remarks\":\"IMG_8311.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_8312.jpg\"},{\"Order\":15,\"Remarks\":\"4602 kitchen\"},{\"Order\":16,\"Remarks\":\"4602 backyard\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}