{"Id":616814,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7148300","MLSAGENTID":"NST506006881","MLSOFFICEID":"NST27354","ADDRESS":"6812 Fairview Avenue N","ACRES":0.18,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partial","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Crystal","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":245000.0,"LASTPRICEDATE":"2026-10-20T14:41:07.59","LATITUDE":45.044031,"LENDEROWNED":"No","LISTDATE":"2026-09-23T05:00:00","LISTPRICE":239000.0,"LIVINGAREA":1388.0,"LONGITUDE":-93.367107,"LOTDESCRIPTION":"Irregular Lot","MODIFICATIONTIMESTAMP":"2026-10-20T14:41:07.59","OFFICE_OFFICENAME":"Homefield Realty","PHOTOCOUNT":13,"POSTALCODE":"55428","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"PRICE REDUCTION: Seller reduced price to help off set current interest rates: Welcome to this single-family home in Crystal offering convenient main-floor living. Features include hardwood floors, fresh paint throughout, a fenced backyard, and a detached two-car garage.   Large lower level amusement room that offers a ton of potential. The home is priced to reflect its current condition and offers an opportunity for buyers looking to add their own updates and personal touches. Move-in and then add your personal touches!  A little TLC could go a long way in making this home your own!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"281-Robbinsdale","SCHOOLDISTRICTPHONE":"7635048000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-09-24T16:25:07.65","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Fairview","STREETNUMBER":"6812","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1953,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-09-24T16:10:08.211","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"20260923_124935.jpg\"},{\"Order\":2,\"Remarks\":\"07-007.jpg\"},{\"Order\":3,\"Remarks\":\"08-008.jpg\"},{\"Order\":4,\"Remarks\":\"09-009.jpg\"},{\"Order\":5,\"Remarks\":\"10-010.jpg\"},{\"Order\":6,\"Remarks\":\"11-011.jpg\"},{\"Order\":7,\"Remarks\":\"12-012.jpg\"},{\"Order\":8,\"Remarks\":\"13-013.jpg\"},{\"Order\":9,\"Remarks\":\"14-014.jpg\"},{\"Order\":10,\"Remarks\":\"15-015.jpg\"},{\"Order\":11,\"Remarks\":\"20260923_125125.jpg\"},{\"Order\":12,\"Remarks\":\"17-017.jpg\"},{\"Order\":13,\"Remarks\":\"06-006.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7973094","NST_AboveGradeSqFtTotal":"925","AboveGradeFinishedArea":"925","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Partial","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"925","BelowGradeFinishedArea":"463","CumulativeDaysOnMarket":"1","City":"Crystal","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Hennepin","NST_DPResource":"Yes","Directions":"100 to N 42nd Avenue. East on 42nd to Douglas Drive N. East Fairview Ave N. Home on right.","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-09-24T16:25:07.651Z","DaysOnMarket":"1","NST_DomIncrementTimestamp":"2026-09-24","NST_DomIncrementYN":"true","Electric":"Circuit Breakers","ExteriorFeatures":"Cement Board","Fencing":"Chain Link,Wood","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"925","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"484","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Robbinsdale","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.044031","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One","ListPrice":"239000","ListingContractDate":"2026-09-23T05:00:00Z","ListingId":"NST7148300","LivingArea":"1388","LockBoxType":"Combo","Longitude":"-93.367107","LotFeatures":"Irregular Lot","LotSizeArea":"0.18","LotSizeDimensions":"60x130x60x130","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"925","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-09-24T10:53:50Z","ParcelNumber":"0811821130087","ParkingFeatures":"Detached Garage","PhotosCount":"13","PhotosChangeTimestamp":"2026-09-24T16:10:08.211Z","PostalCity":"Crystal","PostalCode":"55428","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"PRICE REDUCTION: Seller reduced price to help off set current interest rates: Welcome to this single-family home in Crystal offering convenient main-floor living. Features include hardwood floors, fresh paint throughout, a fenced backyard, and a detached two-car garage.   Large lower level amusement room that offers a ton of potential. The home is priced to reflect its current condition and offers an opportunity for buyers looking to add their own updates and personal touches. Move-in and then add your personal touches!  A little TLC could go a long way in making this home your own!","PublicSurveyRange":"21","PublicSurveySection":"08","PublicSurveyTownship":"118","NST_SchoolDistrictFullName":"281 - Robbinsdale","NST_SchoolDistrictNumber":"281","NST_SchoolDistrictPhone":"7635048000","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Fairview","StreetNumber":"6812","StreetNumberNumeric":"6812","StreetSuffix":"Avenue","SubdivisionName":"Russ 4th Add","TaxAnnualAmount":"4313","NST_TaxWithAssessments":"4313","TaxYear":"2026","NST_TotalArea":"1850","BuildingAreaTotal":"1850","Township":"Crystal","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1953","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST94166","ListAgentMlsId":"NST506006881","ListOfficeMlsId":"NST27354","ListOfficeName":"Homefield Realty","ListOfficeKey":"NST27354","ModificationTimestamp":"2026-10-20T14:41:07.59Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"15-015.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/ed1839e6-b528-41f1-89cb-1250ecf9aca1.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.405Z\",\"MediaKey\":\"NST125060706\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"14-014.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/4448ddb5-c34f-439d-a834-acfe1c60810d.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":801,\"ImageSizeDescription\":\"1200x801\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.406Z\",\"MediaKey\":\"NST125060707\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"12-012.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/2ff70e54-0836-4d15-bf13-fb6d7088614d.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":800,\"ImageSizeDescription\":\"1200x800\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.404Z\",\"MediaKey\":\"NST125060709\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"09-009.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/01523648-21ee-4451-bdc4-6a432cfffc70.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":810,\"ImageSizeDescription\":\"1200x810\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.428Z\",\"MediaKey\":\"NST125060712\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"11-011.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/7769f715-d419-481f-8db0-d5030880ceca.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":813,\"ImageSizeDescription\":\"1200x813\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.401Z\",\"MediaKey\":\"NST125060710\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"13-013.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/8e31afc1-a96d-4d0f-84fd-0522f728ad3f.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":801,\"ImageSizeDescription\":\"1200x801\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.402Z\",\"MediaKey\":\"NST125060708\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"17-017.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/a78e2d1f-92de-44c7-ace3-bddcf5ade720.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":807,\"ImageSizeDescription\":\"1200x807\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.401Z\",\"MediaKey\":\"NST125060704\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"06-006.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/6aa41d01-d50b-41b4-844b-f2e7a2ddfa61.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":799,\"ImageSizeDescription\":\"1200x799\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.404Z\",\"MediaKey\":\"NST125060715\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"07-007.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/93f2ecef-3253-456c-a83c-79a07afb84a6.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":799,\"ImageSizeDescription\":\"1200x799\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.42Z\",\"MediaKey\":\"NST125060714\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"10-010.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/43fc0cf3-fc82-4378-91ff-ecca69bcebcd.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":807,\"ImageSizeDescription\":\"1200x807\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.401Z\",\"MediaKey\":\"NST125060711\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"08-008.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/84e23300-98c8-4f6c-9759-6d6e92c4d368.jpeg\",\"ImageWidth\":1200,\"ImageHeight\":806,\"ImageSizeDescription\":\"1200x806\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.442Z\",\"MediaKey\":\"NST125060713\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"20260923_125125.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/aa5c844e-0b20-4f78-b1ae-bed792b57572.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.537Z\",\"MediaKey\":\"NST125061576\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7973094\",\"LongDescription\":\"20260923_124935.jpg\",\"MediaURL\":\"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/d080486e-3933-46fa-8304-5a8c21ead1ea.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-09-24T16:09:17.457Z\",\"MediaKey\":\"NST125061622\"}]","Media__Order":"10","Media__MediaObjectID":"NST10","Media__ResourceRecordKey":"NST7973094","Media__LongDescription":"15-015.jpg","Media__MediaURL":"https://media.mlsgrid.com/token=DpSZE5J-ldlhfFAK1Uw7e3FIlUgBtMtlPrCnviaQ9d0&expires=1792511471&id=5d6fc86794c5224544394849/images/NST7973094/ed1839e6-b528-41f1-89cb-1250ecf9aca1.jpeg","Media__ImageWidth":"1200","Media__ImageHeight":"800","Media__ImageSizeDescription":"1200x800","Media__MediaModificationTimestamp":"9/24/2026 4:09:17 PM","Media__MediaKey":"NST125060706","Rooms":"[{\"RoomDimensions\":\"11x32\",\"RoomKey\":\"NST116702069\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Amusement Room\"},{\"RoomDimensions\":\"10x12\",\"RoomKey\":\"NST116702066\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\"},{\"RoomDimensions\":\"21x22\",\"RoomKey\":\"NST116702071\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Garage\"},{\"RoomDimensions\":\"8x8\",\"RoomKey\":\"NST116702064\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Informal Dining Room\"},{\"RoomDimensions\":\"9x12\",\"RoomKey\":\"NST116702065\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\"},{\"RoomDimensions\":\"19x11\",\"RoomKey\":\"NST116702063\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\"},{\"RoomDimensions\":\"10x10\",\"RoomKey\":\"NST116702070\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Patio\"},{\"RoomDimensions\":\"10x10\",\"RoomKey\":\"NST116702067\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\"},{\"RoomDimensions\":\"10x12\",\"RoomKey\":\"NST116702068\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomDimensions":"11x32","Rooms__RoomKey":"NST116702069","Rooms__NST_RoomSortOrder":"7","Rooms__RoomType":"Amusement Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"20260923_124935.jpg\"},{\"Order\":2,\"Remarks\":\"07-007.jpg\"},{\"Order\":3,\"Remarks\":\"08-008.jpg\"},{\"Order\":4,\"Remarks\":\"09-009.jpg\"},{\"Order\":5,\"Remarks\":\"10-010.jpg\"},{\"Order\":6,\"Remarks\":\"11-011.jpg\"},{\"Order\":7,\"Remarks\":\"12-012.jpg\"},{\"Order\":8,\"Remarks\":\"13-013.jpg\"},{\"Order\":9,\"Remarks\":\"14-014.jpg\"},{\"Order\":10,\"Remarks\":\"15-015.jpg\"},{\"Order\":11,\"Remarks\":\"20260923_125125.jpg\"},{\"Order\":12,\"Remarks\":\"17-017.jpg\"},{\"Order\":13,\"Remarks\":\"06-006.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}