$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
RE/MAX Results 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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1378309,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6749904","MLSAGENTID":"NST502048660","MLSOFFICEID":"NST7855","ADDRESS":"TBD Gladiola Street NW","ACRES":2.4,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Fiber Cement,Vinyl Siding","FORECLOSURE":"No","LAKEACRES":88.0,"LAKEDEPTH":"26","LAKEWATERFRONT":"Lake Front,Shared","LASTPRICE":775000.0,"LASTPRICEDATE":"2025-07-04T00:34:03.633","LATITUDE":45.218826,"LENDEROWNED":"No","LISTDATE":"2025-07-03T05:00:00","LISTPRICE":775000.0,"LIVINGAREA":1950.0,"LONGITUDE":-93.340867,"LOTDESCRIPTION":"Accessible Shoreline","MODIFICATIONTIMESTAMP":"2025-07-04T10:06:07.411","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":10,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to Lakeview at Sloth Farm! This highly exlusive developement offers five lots with individual boat slips on Crooked Lake in Andover! These new construction detached townhomes by Grandemoore Homes will offer two floorplans ranging from 1,700-2,000 square feet and will allow for you to chose your finishes, customizations, and upgrades. The model home will showcase many upgraded features which may include in-floor heat, open-concept gourmet kitchen, vaulted ceilings, primary bedroom with private bath, second bedroom and second full bath, flex/office room, covered patio, and a huge 3 stall garage with an additional 12ft of depth on the 3rd stall for easy boat storage, epoxy floors, and drains. This opportunity will not last long! Please reach out for more information or to join the interest list.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-04T00:34:03.633","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Gladiola","STREETNUMBER":"TBD","STREETSUFFIX":"Street","STYLE":"Townhouse Detached","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTNAME":"Crooked","WATERFRONTNUM":"02008400","WATERFRONTPRESENT":true,"WATERFRONTVIEW":"Lake Front,Shared","YEARBUILT":1954,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-04T03:14:05.471","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Lakeview 2 Front elevation render.png\"},{\"Order\":2,\"Remarks\":\"Lakeview 2 Front elevation.JPG\"},{\"Order\":3,\"Remarks\":\"Sloth Farm - Developement Site Plan Render.jpg\"},{\"Order\":4,\"Remarks\":\"13624 Gladiola Street NW-1.jpg\"},{\"Order\":5,\"Remarks\":\"13624 Gladiola Street NW-2.jpg\"},{\"Order\":6,\"Remarks\":\"13624 Gladiola Street NW-3.jpg\"},{\"Order\":7,\"Remarks\":\"13624 Gladiola Street NW-4.jpg\"},{\"Order\":8,\"Remarks\":\"13624 Gladiola Street NW-5.jpg\"},{\"Order\":9,\"Remarks\":\"13624 Gladiola Street NW-6.jpg\"},{\"Order\":10,\"Remarks\":\"13624 Gladiola Street NW-8.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7768540","LotSizeArea":"2.4","NST_AgeOfProperty":"71","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","AssociationAmenities":"Boat Slip,Dock","Appliances":"Air-To-Air Exchanger,Cooktop,Dishwasher,Exhaust Fan,Microwave,Range,Refrigerator","NST_AssessmentPending":"No","AssociationFeeIncludes":"Dock,Lawn Care,Snow Removal","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"None","BasementYN":"False","NST_BathDesc":"Full Primary,Private Primary,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BuilderLicense":"684522","BuilderName":"GRANDEMOORE HOMES INC","City":"Andover","PropertyType":"Residential","NST_CommunityName":"Lakeview At Sloth Farm","NST_ConstructionMaterialsDesc":"Concrete,Stone","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Hwy 10 to Round Lake Blvd NW, North on Round Lake Blvd NW to Bunker Lake Blvd, East on Bunker Lake Blvd NW to Gladiola St NW, S on Gladiola to property on right.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Fiber Cement,Vinyl Siding","FireplaceFeatures":"Gas","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"42x46","FoundationArea":"1950","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"889","AccessibilityFeatures":"No Stairs Internal","Heating":"Forced Air,Radiant Floor","OriginalEntryTimestamp":"2025-07-04T00:31:40Z","NST_LakeAcres":"88","NST_LakeChain":"N","NST_LakeDepth":"26","WaterfrontFeatures":"Lake Front,Shared","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-04","Latitude":"45.218826","NST_LenderOwned":"No","ListAgentKey":"NST113694","ListAgentMlsId":"NST502048660","ListingContractDate":"2025-07-03T05:00:00Z","ListOfficeKey":"NST17994","ListOfficeName":"RE/MAX Results","ListOfficeMlsId":"NST7855","ListPrice":"775000","LivingArea":"1950","Longitude":"-93.340867","LotFeatures":"Accessible Shoreline","LotSizeDimensions":"78x254x78x254","LotSizeSquareFeet":"104544","LotSizeUnits":"Acres","ListingId":"NST6749904","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"TBD","GarageSpaces":"3","NST_PatioPorchType":"Covered","PhotosCount":"10","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome to Lakeview at Sloth Farm! This highly exlusive developement offers five lots with individual boat slips on Crooked Lake in Andover! These new construction detached townhomes by Grandemoore Homes will offer two floorplans ranging from 1,700-2,000 square feet and will allow for you to chose your finishes, customizations, and upgrades. The model home will showcase many upgraded features which may include in-floor heat, open-concept gourmet kitchen, vaulted ceilings, primary bedroom with private bath, second bedroom and second full bath, flex/office room, covered patio, and a huge 3 stall garage with an additional 12ft of depth on the 3rd stall for easy boat storage, epoxy floors, and drains. This opportunity will not last long! Please reach out for more information or to join the interest list.","NST_RentalLicenseYN":"No","NST_Restrictions":"Builder Restriction,Mandatory Owners Assoc","NST_RoadBetweenWaterfrontAndHomeYN":"No","NST_AboveGradeSqFtTotal":"1950.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1950.0000","BuildingAreaTotal":"1950","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Primary,Main Floor Laundry","AboveGradeFinishedArea":"1950","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NW","StreetName":"Gladiola","StreetNumber":"TBD","StreetSuffix":"Street","PropertySubType":"Townhouse Detached","SubdivisionName":"Lakeview Terrace","NST_TaxWithAssessments":"0.0000","TaxYear":"2025","TaxAnnualAmount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"True","WaterBodyName":"Crooked","NST_WaterfrontNum":"02008400","View":"Lake","YearBuilt":"1954","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-04T10:06:07.411Z","PhotosChangeTimestamp":"2025-07-04T03:14:05.471Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7768540\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Lakeview 2 Front elevation render.png\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/21c2d85b-930c-48b9-b2ff-423bd9334a09.png\",\"MediaModificationTimestamp\":\"2025-07-04T00:33:21.999Z\",\"MediaKey\":\"68672152a4c9157ea0e79e3e\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Lakeview 2 Front elevation.JPG\",\"ImageWidth\":1091,\"ImageHeight\":535,\"ImageSizeDescription\":\"1091x535\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/22a4051c-ff59-41cf-b56a-b7abd71821ff.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.442Z\",\"MediaKey\":\"686746da4959f00ebacda668\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Sloth Farm - Developement Site Plan Render.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1470,\"ImageSizeDescription\":\"2080x1470\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/1c0a2252-60a9-44e9-9f8e-91e3318c37d7.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.468Z\",\"MediaKey\":\"686746da4959f00ebacda669\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"13624 Gladiola Street NW-1.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/ceba96f0-4c20-48fa-8d9d-388996140657.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.47Z\",\"MediaKey\":\"686746da4959f00ebacda66a\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"13624 Gladiola Street NW-2.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/3d2268b8-ea55-4769-951a-3b51450c0090.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.538Z\",\"MediaKey\":\"686746da4959f00ebacda66b\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"13624 Gladiola Street NW-3.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/28789025-ece6-4211-b210-32ffe45e3197.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.521Z\",\"MediaKey\":\"686746da4959f00ebacda66c\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"13624 Gladiola Street NW-4.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/0a4db0eb-04b4-4cd6-b968-d411933c5f21.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.528Z\",\"MediaKey\":\"686746da4959f00ebacda66d\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"13624 Gladiola Street NW-5.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/b68a6aac-35cd-4a42-bcd4-e6a6d61a6ac4.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.508Z\",\"MediaKey\":\"686746da4959f00ebacda66e\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"13624 Gladiola Street NW-6.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/24ed5fdb-6aef-4e73-ac26-f4f75cc32abb.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.498Z\",\"MediaKey\":\"686746da4959f00ebacda66f\"},{\"ResourceRecordKey\":\"NST7768540\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"13624 Gladiola Street NW-8.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768540/a096985d-d1d0-45b4-8423-1bf9c24b8672.jpeg\",\"MediaModificationTimestamp\":\"2025-07-04T03:13:30.552Z\",\"MediaKey\":\"686746da4959f00ebacda670\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Lakeview 2 Front elevation render.png\"},{\"Order\":2,\"Remarks\":\"Lakeview 2 Front elevation.JPG\"},{\"Order\":3,\"Remarks\":\"Sloth Farm - Developement Site Plan Render.jpg\"},{\"Order\":4,\"Remarks\":\"13624 Gladiola Street NW-1.jpg\"},{\"Order\":5,\"Remarks\":\"13624 Gladiola Street NW-2.jpg\"},{\"Order\":6,\"Remarks\":\"13624 Gladiola Street NW-3.jpg\"},{\"Order\":7,\"Remarks\":\"13624 Gladiola Street NW-4.jpg\"},{\"Order\":8,\"Remarks\":\"13624 Gladiola Street NW-5.jpg\"},{\"Order\":9,\"Remarks\":\"13624 Gladiola Street NW-6.jpg\"},{\"Order\":10,\"Remarks\":\"13624 Gladiola Street NW-8.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}