$LABEL$$CONTENT$
$DESC$
MLS# 7166918 - 5418 142nd Avenue NW Ramsey, MN 55303
Opendoor Brokerage, LLC 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":629336,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7166918","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"5418 142nd Avenue NW","ACRES":0.137,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":345000.0,"LASTPRICEDATE":"2026-10-29T21:31:10.9","LATITUDE":45.227899,"LENDEROWNED":"No","LISTDATE":"2026-10-29T05:00:00","LISTPRICE":345000.0,"LIVINGAREA":1477.0,"LONGITUDE":-93.404695,"MODIFICATIONTIMESTAMP":"2026-10-29T21:31:10.899","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":15,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Seller will pay $5,000 in permanent mortgage rate buy-down costs.\n\nSeparate living areas on two levels create space for both everyday routines and recreation at 5418 142nd Ave NW in Ramsey. Upstairs, the living room connects to a kitchen with white cabinetry, a gas range and an adjoining dining area. Sliding doors open from the dining space onto a stepped deck above the backyard. The primary bedroom and another bedroom sit along the upper hall near the full bathroom. Downstairs, carpeted rooms with windows and an arched opening provide additional space for a lounge, study or hobbies. A second bathroom includes a double vanity, and the attached garage and backyard shed add storage. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-10-29T21:31:10.9","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"142nd","STREETNUMBER":"5418","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1988,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-10-29T21:20:09.703","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"listing_1.jpg\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"listing_3.jpg\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7992117","NST_AboveGradeSqFtTotal":"818","AboveGradeFinishedArea":"818","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","BasementYN":"True","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"775","BelowGradeFinishedArea":"659","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Ramsey","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","Directions":"Head northeast on Dysprosium St\nTurn left on 142nd Ave\nProperty is on the left.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-10-29T21:20:09.703Z","DaysOnMarket":"0","NST_DomIncrementTimestamp":"2026-10-29","NST_DomIncrementYN":"true","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"805","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"425","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.227899","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"345000","ListingContractDate":"2026-10-29T05:00:00Z","ListingId":"NST7166918","LivingArea":"1477","Longitude":"-93.404695","LotSizeArea":"0.137","LotSizeDimensions":"70 x 85","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"818","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-10-29T16:19:59Z","ParcelNumber":"253225330028","ParkingFeatures":"Attached Garage","PhotosCount":"15","PhotosChangeTimestamp":"2026-10-29T21:20:09.703Z","PostalCity":"Ramsey","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Seller will pay $5,000 in permanent mortgage rate buy-down costs.\n\nSeparate living areas on two levels create space for both everyday routines and recreation at 5418 142nd Ave NW in Ramsey. Upstairs, the living room connects to a kitchen with white cabinetry, a gas range and an adjoining dining area. Sliding doors open from the dining space onto a stepped deck above the backyard. The primary bedroom and another bedroom sit along the upper hall near the full bathroom. Downstairs, carpeted rooms with windows and an arched opening provide additional space for a lounge, study or hobbies. A second bathroom includes a double vanity, and the attached garage and backyard shed add storage. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"25","PublicSurveySection":"25","PublicSurveyTownship":"32","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"142nd","StreetNumber":"5418","StreetNumberNumeric":"5418","StreetSuffix":"Avenue","SubdivisionName":"Flintwood Hills 2nd Add","TaxAnnualAmount":"3435","NST_TaxWithAssessments":"3435","TaxYear":"2026","NST_TotalArea":"1593","BuildingAreaTotal":"1593","Township":"Ramsey","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1988","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeMlsId":"NST26320","CoListOfficeName":"Opendoor Brokerage, LLC","CoListOfficeKey":"NST26320","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-10-29T21:31:10.899Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/f3a4dd54-8067-4cc9-b84f-97c6c08b0a4f.jpeg\",\"LongDescription\":\"listing_12.jpg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.705Z\",\"MediaKey\":\"NST125667036\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/a3150fd3-2ed9-42fe-a0fd-52112d872e98.jpeg\",\"LongDescription\":\"listing_10.jpg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.721Z\",\"MediaKey\":\"NST125667038\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/57cea812-6d36-4ae1-87c1-dfef3d1de799.jpeg\",\"LongDescription\":\"listing_13.jpg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.782Z\",\"MediaKey\":\"NST125667035\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/31d46c11-2dae-4d59-a6bf-ef7591e13548.jpeg\",\"LongDescription\":\"listing_14.jpg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.7Z\",\"MediaKey\":\"NST125667034\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/bbfa6463-4a78-49a0-bd9c-8fc1972cba18.jpeg\",\"LongDescription\":\"listing_5.jpg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.695Z\",\"MediaKey\":\"NST125667043\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/6282d4eb-f14e-4420-bc7d-b611106aa55b.jpeg\",\"LongDescription\":\"listing_3.jpg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.71Z\",\"MediaKey\":\"NST125667045\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/e2a559bd-953b-4c37-8f51-4a519031194b.jpeg\",\"LongDescription\":\"listing_9.jpg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.686Z\",\"MediaKey\":\"NST125667039\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/189b263f-a168-4a5e-a898-ca32630ced50.jpeg\",\"LongDescription\":\"listing_4.jpg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.717Z\",\"MediaKey\":\"NST125667044\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/1c09b0f2-d51a-413f-bde2-e0dcc9a4f174.jpeg\",\"LongDescription\":\"listing_2.jpg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.714Z\",\"MediaKey\":\"NST125667046\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/4ebd4163-87a0-4ce5-aba0-70b7a8880f95.jpeg\",\"LongDescription\":\"listing_6.jpg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.699Z\",\"MediaKey\":\"NST125667042\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/edb9912d-3088-4670-80ab-25b4f9bbbc04.jpeg\",\"LongDescription\":\"listing_8.jpg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.714Z\",\"MediaKey\":\"NST125667040\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/b4f26ffc-6a6c-4e64-80e6-3c625a34f08e.jpeg\",\"LongDescription\":\"listing_11.jpg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.72Z\",\"MediaKey\":\"NST125667037\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/f8831471-0309-4d7a-9d8a-6713c3a42b7e.jpeg\",\"LongDescription\":\"listing_7.jpg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.707Z\",\"MediaKey\":\"NST125667041\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/a6ba27aa-e2ad-4f69-833f-5a3c50488911.jpeg\",\"LongDescription\":\"listing_0.jpg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.747Z\",\"MediaKey\":\"NST125667048\"},{\"MediaURL\":\"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/80bf70b3-08aa-47a4-8859-0d840d9ca48f.jpeg\",\"LongDescription\":\"listing_1.jpg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7992117\",\"ImageWidth\":2080,\"ImageHeight\":1557,\"ImageSizeDescription\":\"2080x1557\",\"MediaModificationTimestamp\":\"2026-10-29T21:20:07.727Z\",\"MediaKey\":\"NST125667047\"}]","Media__MediaURL":"https://media.mlsgrid.com/token=toG4omYzvdcNQvs3k9M_BDKe04NvU_jwI3tNxogawuY&expires=1793313572&id=5d6fc86794c5224544394849/images/NST7992117/f3a4dd54-8067-4cc9-b84f-97c6c08b0a4f.jpeg","Media__LongDescription":"listing_12.jpg","Media__Order":"13","Media__MediaObjectID":"NST13","Media__ResourceRecordKey":"NST7992117","Media__ImageWidth":"2080","Media__ImageHeight":"1557","Media__ImageSizeDescription":"2080x1557","Media__MediaModificationTimestamp":"10/29/2026 9:20:07 PM","Media__MediaKey":"NST125667036","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"listing_1.jpg\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"listing_3.jpg\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}