« go back
    • Home
    • Our Agents
    • Our Listings
    • Testimonials
  • Estimate Request
  • Map Search
    • Daily Hotlist
    • Advanced Search
    • Featured Listings
    • Open Houses
    • Our Listings
    • Lost Lake Lodge
    • Good Ol' Days Resort
  • Contact Us
    • Client Login
    • Saved Listings

MLS# NST6814995 - 733 152nd Avenue NW Andover, MN 55304

Neighborhoods

Sundial Realty 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. Lakeshore Properties, LLC is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Lakeshore Properties, LLC, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"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":""}
  • Phone
  • Email
©2025 Lakeshore Properties LLC, all rights reserved. · Privacy ·
Created with REC by Shawn Hyde.