{"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":""}