{"Id":573340,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7091720","MLSAGENTID":"NST502040255","MLSOFFICEID":"NST251767","ADDRESS":"5949 Quail Avenue N","ACRES":0.23,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Crystal","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":270000.0,"LASTPRICEDATE":"2026-06-16T18:00:06.587","LATITUDE":45.061504,"LENDEROWNED":"No","LISTDATE":"2026-06-16T05:00:00","LISTPRICE":270000.0,"LIVINGAREA":1284.0,"LONGITUDE":-93.343881,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-06-17T09:18:11.87","OFFICE_OFFICENAME":"Julie Hubbell Real Estate","PHOTOCOUNT":18,"POSTALCODE":"55429","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This 3-bedroom rambler offers the perfect chance to build equity while making this home your own or as an investment opportunity. This affordable, Crystal home features 3 bedrooms on 1 level w/ new carpet & fresh neutral paint, a new dishwasher, washer & dryer, a detached 2-car garage & addtl finished space in the lower-level w/ a family room & a non-conforming potential 4th bedroom. This home provides a strong framework for your vision w/ plenty of potential. Situated on a spacious lot w/ mature trees near the Crystal MC Wildlife Area, you'll enjoy a peaceful setting w/ convenient access to parks, shopping, dining & highway access. If you are looking for a home w/ room for your personal touch w/ an opportunity to build equity, this property should be at the top of your list! Come see all this this home has to offer!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"281-Robbinsdale","SCHOOLDISTRICTPHONE":"7635048000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-16T18:00:06.587","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Quail","STREETNUMBER":"5949","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected,Well","WATERFRONTPRESENT":false,"YEARBUILT":1958,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-16T18:00:06.587","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 5949 Quail Ave N.\"},{\"Order\":2,\"Remarks\":\"Kitchen w/ brand new dishwasher & newer gas stove\"},{\"Order\":3,\"Remarks\":\"Kitchen & Dining room\"},{\"Order\":4,\"Remarks\":\"Spacious living room features a large bay window\"},{\"Order\":5,\"Remarks\":\"Living room\"},{\"Order\":6,\"Remarks\":\"Bedroom 1 of 3\"},{\"Order\":7,\"Remarks\":\"Main floor full bathroom\"},{\"Order\":8,\"Remarks\":\"Bedroom 2 of 3\"},{\"Order\":9,\"Remarks\":\"Bedroom 3 of 3 located off the kitchen\"},{\"Order\":10,\"Remarks\":\"Lower-level family room\"},{\"Order\":11,\"Remarks\":\"4th room (non-conforming) w/ new carpet\"},{\"Order\":12,\"Remarks\":\"Laundry room w/ newer washer & dryer\"},{\"Order\":13,\"Remarks\":\"2nd Toilet & shower in laundry room\"},{\"Order\":14,\"Remarks\":\"Utility/storage area\"},{\"Order\":15,\"Remarks\":\"Spacious 2 car garage\"},{\"Order\":16,\"Remarks\":\"Nice sized backyard\"},{\"Order\":17,\"Remarks\":\"Rear of home\"},{\"Order\":18,\"Remarks\":\"Thank you for visiting 5949 Quail Ave N.\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7917110","NST_AboveGradeSqFtTotal":"789","AboveGradeFinishedArea":"789","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dishwasher,Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Full","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"874","BelowGradeFinishedArea":"495","CumulativeDaysOnMarket":"0","City":"Crystal","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Hennepin","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room","Directions":"94E/694E To Cty Road 81N to 58th Ave to Quail Ave to home on left","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-06-16T17:59:08.964Z","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","Fencing":"Partial","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"874","FoundationDetails":"Block","NST_FoundationDimensions":"22.6x34.8x21.5x37.51","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"254","NST_GarageDimensions":"16.4x15.6","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Robbinsdale","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.061504","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One","ListPrice":"270000","ListingContractDate":"2026-06-16T05:00:00Z","ListingId":"NST7091720","LivingArea":"1284","LockBoxType":"Combo","Longitude":"-93.343881","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"0.23","LotSizeDimensions":"75x135","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"789","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-16T12:58:53Z","ParcelNumber":"0411821140092","ParkingFeatures":"Detached Garage","PhotosCount":"18","PhotosChangeTimestamp":"2026-06-16T18:00:06.587Z","PostalCity":"Crystal","PostalCode":"55429","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"This 3-bedroom rambler offers the perfect chance to build equity while making this home your own or as an investment opportunity. This affordable, Crystal home features 3 bedrooms on 1 level w/ new carpet & fresh neutral paint, a new dishwasher, washer & dryer, a detached 2-car garage & addtl finished space in the lower-level w/ a family room & a non-conforming potential 4th bedroom. This home provides a strong framework for your vision w/ plenty of potential. Situated on a spacious lot w/ mature trees near the Crystal MC Wildlife Area, you'll enjoy a peaceful setting w/ convenient access to parks, shopping, dining & highway access. If you are looking for a home w/ room for your personal touch w/ an opportunity to build equity, this property should be at the top of your list! Come see all this this home has to offer!","PublicSurveyRange":"21","PublicSurveySection":"04","PublicSurveyTownship":"118","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt","NST_SchoolDistrictFullName":"281 - Robbinsdale","NST_SchoolDistrictNumber":"281","NST_SchoolDistrictPhone":"7635048000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Quail","StreetNumber":"5949","StreetNumberNumeric":"5949","StreetSuffix":"Avenue","SubdivisionName":"F","TaxAnnualAmount":"4269","NST_TaxWithAssessments":"4269","TaxYear":"2025","NST_TotalArea":"1663","BuildingAreaTotal":"1663","Township":"Crystal","VideosCount":"0","WaterSource":"City Water/Connected,Well","WaterfrontYN":"False","YearBuilt":"1958","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST94994","ListAgentMlsId":"NST502040255","ListOfficeMlsId":"NST251767","ListOfficeName":"Julie Hubbell Real Estate","ListOfficeKey":"NST1000424","ModificationTimestamp":"2026-06-17T09:18:11.87Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"4th room (non-conforming) w/ new carpet\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/eb86a853-4424-424d-a619-a6771e3656f9.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.988Z\",\"MediaKey\":\"NST122991080\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"Bedroom 3 of 3 located off the kitchen\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/d567ba90-f361-432d-bc81-dccff43354bf.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.991Z\",\"MediaKey\":\"NST122991090\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"Bedroom 2 of 3\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/47077476-e3ac-4466-9854-129791bd5835.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:16.002Z\",\"MediaKey\":\"NST122991093\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Kitchen & Dining room\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/522b31e9-704c-42a4-92a5-b8609a292dea.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.99Z\",\"MediaKey\":\"NST122991088\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Lower-level family room\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/08b1f510-7b96-4174-ac75-aa82c2300c97.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":661,\"ImageSizeDescription\":\"1024x661\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:16.012Z\",\"MediaKey\":\"NST122991083\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Kitchen w/ brand new dishwasher & newer gas stove\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/3ec6a59b-3f69-48cd-9f56-b6e82ca577af.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.994Z\",\"MediaKey\":\"NST122991087\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"Main floor full bathroom\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/928d9fed-2180-43fa-b1fd-327f694d83fa.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":706,\"ImageSizeDescription\":\"1024x706\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.989Z\",\"MediaKey\":\"NST122991095\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"Bedroom 1 of 3\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/dddd8ecb-e74b-4ca2-a72e-f6b5224cc9b3.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.985Z\",\"MediaKey\":\"NST122991092\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"Spacious 2 car garage\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/478a1055-e9ef-4e62-8f74-d4a126716422.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.996Z\",\"MediaKey\":\"NST122991073\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"2nd Toilet & shower in laundry room\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/23d53381-cb0a-4868-be62-2c85b43987bb.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.985Z\",\"MediaKey\":\"NST122991078\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Living room\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/3e54cb4c-52fc-4cca-84c5-f8f7458d809b.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.998Z\",\"MediaKey\":\"NST122991086\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"Spacious living room features a large bay window\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/e6f1406a-4980-412c-a579-199077e2ab77.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":668,\"ImageSizeDescription\":\"1024x668\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.99Z\",\"MediaKey\":\"NST122991085\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"Utility/storage area\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/ee31ebba-c925-4685-b978-1bd75d27e96a.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:16.029Z\",\"MediaKey\":\"NST122991082\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"Laundry room w/ newer washer & dryer\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/3c6cdfdf-e2ff-4d13-88f1-5d5d16c10b00.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":668,\"ImageSizeDescription\":\"1024x668\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.985Z\",\"MediaKey\":\"NST122991081\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Welcome to 5949 Quail Ave N.\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/fe08c15e-7f7e-439c-8a9b-72c4e9d5991d.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.989Z\",\"MediaKey\":\"NST122991072\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"Nice sized backyard\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/b47868b7-5fc1-4282-ae67-f5d11eadd230.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:15.998Z\",\"MediaKey\":\"NST122991075\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"Thank you for visiting 5949 Quail Ave N.\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/3de737ef-9651-4067-bb2d-69c96d875c70.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":650,\"ImageSizeDescription\":\"1024x650\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:16.004Z\",\"MediaKey\":\"NST122992789\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"Rear of home\",\"ResourceRecordKey\":\"NST7917110\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7917110/f7227481-afb9-48d1-9660-5e2624270ae6.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":683,\"ImageSizeDescription\":\"1024x683\",\"MediaModificationTimestamp\":\"2026-06-16T17:59:16.037Z\",\"MediaKey\":\"NST122992960\"}]","Media__Order":"11","Media__MediaObjectID":"NST11","Media__LongDescription":"4th room (non-conforming) w/ new carpet","Media__ResourceRecordKey":"NST7917110","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7917110/eb86a853-4424-424d-a619-a6771e3656f9.jpeg","Media__ImageWidth":"1024","Media__ImageHeight":"683","Media__ImageSizeDescription":"1024x683","Media__MediaModificationTimestamp":"6/16/2026 5:59:15 PM","Media__MediaKey":"NST122991080","Rooms":"[{\"RoomLevel\":\"Basement\",\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116345752\",\"RoomDimensions\":\"19x11\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116345731\",\"RoomDimensions\":\"12x11\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116345729\",\"RoomDimensions\":\"9x8\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116345730\",\"RoomDimensions\":\"17x11\"},{\"RoomLevel\":\"Basement\",\"RoomType\":\"Office\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116345753\",\"RoomDimensions\":\"12x11\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116345732\",\"RoomDimensions\":\"12x8\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116345733\",\"RoomDimensions\":\"9x11\"},{\"RoomLevel\":\"Basement\",\"RoomType\":\"Utility Room\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116345754\",\"RoomDimensions\":\"15.5x11\"}]","Rooms__RoomLevel":"Basement","Rooms__RoomType":"Family Room","Rooms__NST_RoomSortOrder":"6","Rooms__RoomKey":"NST116345752","Rooms__RoomDimensions":"19x11","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 5949 Quail Ave N.\"},{\"Order\":2,\"Remarks\":\"Kitchen w/ brand new dishwasher & newer gas stove\"},{\"Order\":3,\"Remarks\":\"Kitchen & Dining room\"},{\"Order\":4,\"Remarks\":\"Spacious living room features a large bay window\"},{\"Order\":5,\"Remarks\":\"Living room\"},{\"Order\":6,\"Remarks\":\"Bedroom 1 of 3\"},{\"Order\":7,\"Remarks\":\"Main floor full bathroom\"},{\"Order\":8,\"Remarks\":\"Bedroom 2 of 3\"},{\"Order\":9,\"Remarks\":\"Bedroom 3 of 3 located off the kitchen\"},{\"Order\":10,\"Remarks\":\"Lower-level family room\"},{\"Order\":11,\"Remarks\":\"4th room (non-conforming) w/ new carpet\"},{\"Order\":12,\"Remarks\":\"Laundry room w/ newer washer & dryer\"},{\"Order\":13,\"Remarks\":\"2nd Toilet & shower in laundry room\"},{\"Order\":14,\"Remarks\":\"Utility/storage area\"},{\"Order\":15,\"Remarks\":\"Spacious 2 car garage\"},{\"Order\":16,\"Remarks\":\"Nice sized backyard\"},{\"Order\":17,\"Remarks\":\"Rear of home\"},{\"Order\":18,\"Remarks\":\"Thank you for visiting 5949 Quail Ave N.\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}