{"Id":1429740,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6814995","MLSAGENTID":"NST496500106","MLSOFFICEID":"NST1062","ADDRESS":"733 152nd Avenue NW","ACRES":0.3,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Finished,Full","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":635000.0,"LASTPRICEDATE":"2025-11-07T13:41:04.263","LATITUDE":45.246692,"LENDEROWNED":"No","LISTDATE":"2025-11-07T06:00:00","LISTPRICE":635000.0,"LIVINGAREA":3264.0,"LONGITUDE":-93.283537,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-11-07T13:41:04.264","OFFICE_OFFICENAME":"Sundial Realty","PHOTOCOUNT":20,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"One level living with finished lower level! Don't miss this Gorgeous Clearwater floor plan! 3 bedrooms on main level and 4th in lower level. Entertainers Dream Home on massive homesite! Beautiful fenced in backyard with patio and grilling area!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-07T13:41:04.263","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"152nd","STREETNUMBER":"733","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2024,"ZONING":"Residential-Single Family","VIRTUALTOUR_URL1":"https://tours.spacecrafting.com/n-cqn299","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-07T13:41:04.264","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7824983","LotSizeArea":"0.3","NST_AgeOfProperty":"1","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Patio,In-Ground Sprinkler,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Microwave,Range,Refrigerator,Stainless Steel Appliances,Tankless Water Heater,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Trash","AssociationFeeFrequency":"Quarterly","AssociationYN":"True","AssociationFee":"90","AssociationName":"Compass Management","AssociationPhone":"612-888-4710","PropertyAttachedYN":"False","Basement":"Drain Tiled,Finished,Full","BasementYN":"True","NST_BathDesc":"Full Basement,Main Floor Full Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"3","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","CarportSpaces":"0","City":"Andover","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DiningRoomDescription":"Breakfast Bar,Eat In Kitchen","Directions":"Hwy 65 to Andover Blvd-West to Prairie Rd.-north to 151st-east to Norway-north to 152nd.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Vinyl Siding","Fencing":"Chain Link,Full","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1920","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Paved Streets,Street Lights,Storm Sewer","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_GarageDimensions":"21x26","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"546","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-07T13:38:21Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-07","Latitude":"45.246692","NST_LenderOwned":"No","ListAgentKey":"NST48774","ListAgentMlsId":"NST496500106","ListingContractDate":"2025-11-07T06:00:00Z","ListOfficeKey":"NST15292","ListOfficeName":"Sundial Realty","ListOfficeMlsId":"NST1062","ListPrice":"635000","LivingArea":"3264","Longitude":"-93.283537","LotFeatures":"Some Trees","LotSizeDimensions":"50x171x138x131","LotSizeSquareFeet":"13068","LotSizeUnits":"Square Feet","ListingId":"NST6814995","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"243224320012","GarageSpaces":"3","NST_ParkingOpen":"2","NST_PatioPorchType":"Patio","PhotosCount":"20","PoolFeatures":"None","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"One level living with finished lower level! Don't miss this Gorgeous Clearwater floor plan! 3 bedrooms on main level and 4th in lower level. Entertainers Dream Home on massive homesite! Beautiful fenced in backyard with patio and grilling area!","PublicSurveyRange":"24","PublicSurveySection":"24","PublicSurveyTownship":"32","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Recreation Room","NST_AboveGradeSqFtTotal":"1920.0000","NST_BelowGradeSqFtTotal":"1290.0000","NST_MainLevelFinishedArea":"1920.0000","BuildingAreaTotal":"3210","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom,Main Floor Laundry,Primary Bdr Suite","AboveGradeFinishedArea":"1920","BelowGradeFinishedArea":"1344","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NW","StreetName":"152nd","StreetNumber":"733","StreetNumberNumeric":"733","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Fields of Winslow Cove","NST_TaxWithAssessments":"817.0000","TaxYear":"2025","TaxAnnualAmount":"817","VirtualTourURLUnbranded":"https://tours.spacecrafting.com/n-cqn299","WaterSource":"City Water/Connected","YearBuilt":"2024","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-07T13:41:04.264Z","PhotosChangeTimestamp":"2025-11-07T13:41:04.264Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7824983\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/04e5e208-195c-4467-95fc-8d17644d28df.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.543Z\",\"MediaKey\":\"690df6d0ec03070e8fea8395\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1280,\"ImageHeight\":1920,\"ImageSizeDescription\":\"1280x1920\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/5fa56c43-ac36-4617-9291-82f28fcc2ad0.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.63Z\",\"MediaKey\":\"690df6d0ec03070e8fea8396\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/5cbd340b-2076-4961-ae95-9c6f15441cd1.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.545Z\",\"MediaKey\":\"690df6d0ec03070e8fea8397\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1280,\"ImageHeight\":1920,\"ImageSizeDescription\":\"1280x1920\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/0509c71b-cf5c-4512-841d-0c3174c0a42d.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.543Z\",\"MediaKey\":\"690df6d0ec03070e8fea8398\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/b5e97a88-5b71-4cca-b831-37b66bc2e4ff.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.585Z\",\"MediaKey\":\"690df6d0ec03070e8fea8399\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/edf720f7-6081-45a3-a4fb-92dafd22c16c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.506Z\",\"MediaKey\":\"690df6d0ec03070e8fea839a\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/59a43664-721c-4f7d-9567-aede7a0d4fa9.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.534Z\",\"MediaKey\":\"690df6d0ec03070e8fea839b\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/0d3f6b8b-c2e4-4f09-a458-2c76c877f174.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.538Z\",\"MediaKey\":\"690df6d0ec03070e8fea839c\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/9d5c3b92-e570-46a2-a211-79b5a88e4b97.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.534Z\",\"MediaKey\":\"690df6d0ec03070e8fea839d\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/29b53d9b-611d-4d60-94a5-ddb91fbc3236.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.525Z\",\"MediaKey\":\"690df6d0ec03070e8fea839e\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/18f55b8e-85b1-48ba-b2ca-929031342118.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.505Z\",\"MediaKey\":\"690df6d0ec03070e8fea839f\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/38381ccf-856b-4a89-9c1b-af8c1f107bf9.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.521Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a0\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/60d089fe-3f5a-434e-b2b2-cea876c5395c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.521Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a1\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/e293c03b-32c5-4d57-89ac-c9df4642a834.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.493Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a2\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/667c5e08-db27-48a9-9754-715441458db8.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.493Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a3\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/b6568f08-a2d4-4f76-95d0-8cc739c6b3d2.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.518Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a4\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/f6561e50-c134-41ec-992c-07423b18998a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.534Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a5\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/bf52f4e3-671e-4b89-a557-d9d0e01d9103.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.521Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a6\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/2168de68-49d6-441a-adc1-4b1dccc146d0.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.832Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a7\"},{\"ResourceRecordKey\":\"NST7824983\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7824983/44070cd4-2ed4-42f7-b7b5-9de4efeade43.jpeg\",\"MediaModificationTimestamp\":\"2025-11-07T13:40:32.547Z\",\"MediaKey\":\"690df6d0ec03070e8fea83a8\"}]","Rooms":"[{\"RoomKey\":\"NST115761020\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x15\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115761021\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115761022\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115761023\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115761024\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x14\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115761025\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115761026\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115761027\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115761028\",\"RoomType\":\"Recreation Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"36x30\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}