$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
HomeSmart Sapphire 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. Heartland Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. Heartland Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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":""}
Box 152 Pine River, MN 56474
Doug Zaske, Owner/Broker
Office: 218.587.4424
Cell: 218.820.8688