MLS# 6765174
4002 Flamingo Drive NE Ham Lake, MN 55304
eXp Realty is the brokerage office representing the seller for this listing.
Copyright 2025, 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. Jim Christensen is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Jim Christensen, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":1392140,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6765174","MLSAGENTID":"NST502023731","MLSOFFICEID":"NST25792","ADDRESS":"4002 Flamingo Drive NE","ACRES":0.18,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Ham Lake","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":108900.0,"LASTPRICEDATE":"2025-08-06T02:29:04.463","LATITUDE":45.27917771,"LENDEROWNED":"No","LISTDATE":"2025-07-31T05:00:00","LISTPRICE":108900.0,"LIVINGAREA":1456.0,"LONGITUDE":-93.23764369,"LOTDESCRIPTION":"Corner Lot","MODIFICATIONTIMESTAMP":"2025-08-06T10:05:10.793","OFFICE_OFFICENAME":"eXp Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":17,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Oversized corner lot in Flamingo Terrace off highway 65 in Ham Lake, MN. This home features 3 bedrooms, 2 baths, an informal dining area and spacious kitchen! The master bedroom has an attached walk thru bath, with a large soaking tub and separate shower. The kitchen has plenty of countertops and cabinets, with a breakfast bar, updated appliances and double sink. The home has been decorated with modern wallpapers and paint colors making it a warm inviting space with a modern feel. Outside the home is situated on a desirable corner lot with an over sized yard boasting around 8000 square feet, with a built in patio and storage shed. The buyer will own the home and lease the land at $575 a month. This rent includes garbage, recycling and water. The park allows cats and one small dog. All buyers must be approved by the park. Mobile Home financing is available, inquire with the listing agent. Set up your showing today and claim the best spot in the park!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-06T02:29:04.463","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"Flamingo Drive","STREETNUMBER":"4002","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1999,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-06T03:07:03.707","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"received_651898267237446.jpeg\"},{\"Order\":2,\"Remarks\":\"received_1125670022952282.jpeg\"},{\"Order\":3,\"Remarks\":\"received_603863919462778.jpeg\"},{\"Order\":4,\"Remarks\":\"received_711483798544537.jpeg\"},{\"Order\":5,\"Remarks\":\"received_1087107396248878.jpeg\"},{\"Order\":6,\"Remarks\":\"received_1108300764532798.jpeg\"},{\"Order\":7,\"Remarks\":\"received_1252261889774152.jpeg\"},{\"Order\":8,\"Remarks\":\"received_1285824913188650.jpeg\"},{\"Order\":9,\"Remarks\":\"received_1902752143837058.jpeg\"},{\"Order\":10,\"Remarks\":\"received_1304126177945793.jpeg\"},{\"Order\":11,\"Remarks\":\"received_1059267169263330.jpeg\"},{\"Order\":12,\"Remarks\":\"received_778178988066722.jpeg\"},{\"Order\":13,\"Remarks\":\"received_1059267169263330.jpeg\"},{\"Order\":14,\"Remarks\":\"received_1200800415183158.jpeg\"},{\"Order\":15,\"Remarks\":\"received_1668462030524908.jpeg\"},{\"Order\":16,\"Remarks\":\"received_1847832422741950.jpeg\"},{\"Order\":17,\"Remarks\":\"received_2165556277257972.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7781797","LotSizeArea":"0.18","NST_AgeOfProperty":"26","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","Appliances":"Dishwasher,Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Water Softener Owned","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor Full Bath,Separate Tub & Shower,Primary Walk-Thru","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Ham Lake","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"6","CumulativeDaysOnMarket":"6","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Hwy 65 to Flamingo Dr","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1456","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Concrete","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-06T02:27:01Z","LandLeaseAmount":"575","LandLeaseYN":"True","NST_LastUpdateDate":"2025-08-06","Latitude":"45.2791777126","NST_LenderOwned":"No","ListAgentKey":"NST62222","ListAgentMlsId":"NST502023731","ListingContractDate":"2025-07-31T05:00:00Z","ListOfficeKey":"NST25792","ListOfficeName":"eXp Realty","ListOfficeMlsId":"NST25792","ListPrice":"108900","LivingArea":"1456","LockBoxType":"Combo","Longitude":"-93.2376436888","LotFeatures":"Corner Lot","LotSizeDimensions":"irregular","LotSizeSquareFeet":"8000","LotSizeUnits":"Square Feet","ListingId":"NST6765174","SourceSystemName":"RMLS","NST_ManufacturedHome":"Yes","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"99918053002","GarageSpaces":"0","NST_PatioPorchType":"Patio","PhotosCount":"17","PostalCity":"Ham Lake","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Oversized corner lot in Flamingo Terrace off highway 65 in Ham Lake, MN. This home features 3 bedrooms, 2 baths, an informal dining area and spacious kitchen! The master bedroom has an attached walk thru bath, with a large soaking tub and separate shower. The kitchen has plenty of countertops and cabinets, with a breakfast bar, updated appliances and double sink. The home has been decorated with modern wallpapers and paint colors making it a warm inviting space with a modern feel. Outside the home is situated on a desirable corner lot with an over sized yard boasting around 8000 square feet, with a built in patio and storage shed. The buyer will own the home and lease the land at $575 a month. This rent includes garbage, recycling and water. The park allows cats and one small dog. All buyers must be approved by the park. Mobile Home financing is available, inquire with the listing agent. Set up your showing today and claim the best spot in the park!","NST_RentalLicenseYN":"No","Roof":"Age Over 8 Years","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"1456.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1456.0000","BuildingAreaTotal":"1456","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 Bedroom,Main Floor Laundry","AboveGradeFinishedArea":"1456","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NE","StreetName":"Flamingo Drive","StreetNumber":"4002","StreetNumberNumeric":"4002","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"361.9400","TaxYear":"2025","TaxAnnualAmount":"362","WaterSource":"City Water/Connected","YearBuilt":"1999","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-06T10:05:10.793Z","PhotosChangeTimestamp":"2025-08-06T03:07:03.707Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7781797\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"received_651898267237446.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/2d5445f1-b747-4c04-8ded-ea896321d4fb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.55Z\",\"MediaKey\":\"6892c6caa5eafa764219a4b4\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"received_1125670022952282.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/b1c70968-0c41-4081-8195-12e0e45f97c5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.587Z\",\"MediaKey\":\"6892c6caa5eafa764219a4b5\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"received_603863919462778.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/9167127b-cd08-4b90-92d8-c7c66f11d251.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.657Z\",\"MediaKey\":\"6892c6caa5eafa764219a4b6\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"received_711483798544537.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/18cedf02-0ea0-4a11-acce-111019796fb2.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.561Z\",\"MediaKey\":\"6892c6caa5eafa764219a4b7\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"received_1087107396248878.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/3e4f329f-3755-44ba-8cca-977b05242121.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.505Z\",\"MediaKey\":\"6892c6caa5eafa764219a4b8\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"received_1108300764532798.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2047,\"ImageSizeDescription\":\"1536x2047\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/49bf8584-757c-4416-876d-4210c46f2424.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.553Z\",\"MediaKey\":\"6892c6caa5eafa764219a4b9\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"received_1252261889774152.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/1da62917-ae78-460d-bc3f-1239c6ca13d1.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.539Z\",\"MediaKey\":\"6892c6caa5eafa764219a4ba\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"received_1285824913188650.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/f010c811-9626-4d04-bd2a-e3a49bf5a1ba.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.556Z\",\"MediaKey\":\"6892c6caa5eafa764219a4bb\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"received_1902752143837058.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/1218de99-e6da-45b5-b147-9b176afb8214.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.529Z\",\"MediaKey\":\"6892c6caa5eafa764219a4bc\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"received_1304126177945793.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/886d2fc0-ebae-4621-bf2f-0607d676b08a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.518Z\",\"MediaKey\":\"6892c6caa5eafa764219a4bd\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"received_1059267169263330.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/fa20c380-201a-4a70-9af5-a89706a466b7.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.534Z\",\"MediaKey\":\"6892c6caa5eafa764219a4be\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"received_778178988066722.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/77ad67dd-49e4-4f70-a7a4-380cdfb40c1f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.529Z\",\"MediaKey\":\"6892c6caa5eafa764219a4bf\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"received_1059267169263330.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/599d9f8f-915b-46d1-b60e-630c64684849.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.534Z\",\"MediaKey\":\"6892c6caa5eafa764219a4c0\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"received_1200800415183158.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/9355d8e5-4f28-4acb-8da2-3f80cd4460a3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.556Z\",\"MediaKey\":\"6892c6caa5eafa764219a4c1\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"received_1668462030524908.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/fd0296b4-d095-4df3-b9b2-a09fbfd0cbb3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.505Z\",\"MediaKey\":\"6892c6caa5eafa764219a4c2\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"received_1847832422741950.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/240586ce-0cee-4082-8ce2-e86f710d4415.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.597Z\",\"MediaKey\":\"6892c6caa5eafa764219a4c3\"},{\"ResourceRecordKey\":\"NST7781797\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"received_2165556277257972.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7781797/fc471486-954b-4ab9-90d4-f31af7a3cf3a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-06T03:06:50.686Z\",\"MediaKey\":\"6892c6caa5eafa764219a4c4\"}]","Rooms":"[{\"RoomKey\":\"NST115475264\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115475265\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x8\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115475266\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115475267\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115475268\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x12\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"received_651898267237446.jpeg\"},{\"Order\":2,\"Remarks\":\"received_1125670022952282.jpeg\"},{\"Order\":3,\"Remarks\":\"received_603863919462778.jpeg\"},{\"Order\":4,\"Remarks\":\"received_711483798544537.jpeg\"},{\"Order\":5,\"Remarks\":\"received_1087107396248878.jpeg\"},{\"Order\":6,\"Remarks\":\"received_1108300764532798.jpeg\"},{\"Order\":7,\"Remarks\":\"received_1252261889774152.jpeg\"},{\"Order\":8,\"Remarks\":\"received_1285824913188650.jpeg\"},{\"Order\":9,\"Remarks\":\"received_1902752143837058.jpeg\"},{\"Order\":10,\"Remarks\":\"received_1304126177945793.jpeg\"},{\"Order\":11,\"Remarks\":\"received_1059267169263330.jpeg\"},{\"Order\":12,\"Remarks\":\"received_778178988066722.jpeg\"},{\"Order\":13,\"Remarks\":\"received_1059267169263330.jpeg\"},{\"Order\":14,\"Remarks\":\"received_1200800415183158.jpeg\"},{\"Order\":15,\"Remarks\":\"received_1668462030524908.jpeg\"},{\"Order\":16,\"Remarks\":\"received_1847832422741950.jpeg\"},{\"Order\":17,\"Remarks\":\"received_2165556277257972.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}
$LABEL$
$CONTENT$
$DESC$
