mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About
- Pelican Lake
- Ossawinnamakee Lake
- Horseshoe Lake
- Advanced Search
- Daily Hotsheets
- Buyers
- Sellers
- Estimate Request
- Popular Listings
- Favorite Listings
- Pelican Lakes Association
- Conservation Club
- DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
RES 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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, 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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":561913,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7079109","MLSAGENTID":"NST880502323","MLSOFFICEID":"NST12127","ADDRESS":"512 138th Avenue NE","ACRES":1.01,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Storage Space,Walkout","BATHSTOTAL":4.0,"BEDROOMS":4.0,"CITY":"Ham Lake","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Stone","FORECLOSURE":"No","LASTPRICE":775000.0,"LASTPRICEDATE":"2026-05-23T01:07:06.263","LATITUDE":45.21941486,"LENDEROWNED":"No","LISTDATE":"2026-05-22T05:00:00","LISTPRICE":775000.0,"LIVINGAREA":4038.0,"LONGITUDE":-93.25727511,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-05-23T01:07:06.263","OFFICE_OFFICENAME":"RES Realty","PHOTOCOUNT":37,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This exceptional 4-bedroom, 4-bath residence offers refined living on a private, wooded lot in the prestigious Majestic Oaks Golf Course community. Thoughtfully updated throughout, the home showcases a designer kitchen, an elegant sunroom, and a spa-inspired primary suite with a custom walk-in closet. Outdoor living is unparalleled with a wraparound porch, inground pool, and hot tub. A 3-car attached garage is complemented by a heated and air-conditioned detached garage ideal for a fitness studio or collector’s space. A rare opportunity to own a beautifully upgraded home in a premier golf community.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"Holding Tank,Private Sewer","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-23T01:07:06.263","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"138th","STREETNUMBER":"512","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"Well","WATERFRONTPRESENT":false,"YEARBUILT":1997,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-23T01:06:06.46","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"7.jpg\"},{\"Order\":7,\"Remarks\":\"9.jpg\"},{\"Order\":8,\"Remarks\":\"10.jpg\"},{\"Order\":9,\"Remarks\":\"11.jpg\"},{\"Order\":10,\"Remarks\":\"12.jpg\"},{\"Order\":11,\"Remarks\":\"13.jpg\"},{\"Order\":12,\"Remarks\":\"14.jpg\"},{\"Order\":13,\"Remarks\":\"18.jpg\"},{\"Order\":14,\"Remarks\":\"19.jpg\"},{\"Order\":15,\"Remarks\":\"21.jpg\"},{\"Order\":16,\"Remarks\":\"22.jpg\"},{\"Order\":17,\"Remarks\":\"24.jpg\"},{\"Order\":18,\"Remarks\":\"29.jpg\"},{\"Order\":19,\"Remarks\":\"31.jpg\"},{\"Order\":20,\"Remarks\":\"32.jpg\"},{\"Order\":21,\"Remarks\":\"33.jpg\"},{\"Order\":22,\"Remarks\":\"36.jpg\"},{\"Order\":23,\"Remarks\":\"38.jpg\"},{\"Order\":24,\"Remarks\":\"41.jpg\"},{\"Order\":25,\"Remarks\":\"45.jpg\"},{\"Order\":26,\"Remarks\":\"47.jpg\"},{\"Order\":27,\"Remarks\":\"49.jpg\"},{\"Order\":28,\"Remarks\":\"51.jpg\"},{\"Order\":29,\"Remarks\":\"52.jpg\"},{\"Order\":30,\"Remarks\":\"54.jpg\"},{\"Order\":31,\"Remarks\":\"55.jpg\"},{\"Order\":32,\"Remarks\":\"57.jpg\"},{\"Order\":33,\"Remarks\":\"59.jpg\"},{\"Order\":34,\"Remarks\":\"60.jpg\"},{\"Order\":35,\"Remarks\":\"61.jpg\"},{\"Order\":36,\"Remarks\":\"64.jpg\"},{\"Order\":37,\"Remarks\":\"68.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37","SOURCE":"MG_NST"}
{"ListingKey":"NST7906084","NST_AboveGradeSqFtTotal":"3331","AboveGradeFinishedArea":"3070","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Cable,Ceiling Fan(s),Deck,Exercise Room,French Doors,Hardwood Floors,Hot Tub,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Patio,Porch,Skylight,In-Ground Sprinkler,Sun Room,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup","Appliances":"Cooktop,Dishwasher,Dryer,Exhaust Fan,Freezer,Gas Water Heater,Water Filtration System,Microwave,Range,Refrigerator,Washer,Water Softener Owned","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AssociationFeeFrequency":"N/A","Basement":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Storage Space,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Bathroom Ensuite,Main Floor 1/2 Bath,Upper Level 3/4 Bath,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"1","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"4","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1031","BelowGradeFinishedArea":"968","CumulativeDaysOnMarket":"0","City":"Ham Lake","ConstructionMaterials":"Block,Stone","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DiningRoomDescription":"Breakfast Area,Informal Dining Room,Kitchen/Dining Room","Directions":"Hwy 65 N to W on Bunker Hill Blvd to N on 138th to the home on left.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Circuit Breakers","Fencing":"Other,Partial","FireplaceFeatures":"Brick,Family Room,Gas,Living Room,Stone","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1282","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"768","NST_GarageDimensions":"32x24","GarageSpaces":"4","Heating":"Forced Air,Fireplace(s),In-Floor Heating","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.2194148609","NST_LenderOwned":"No","Levels":"Two","ListPrice":"775000","ListingContractDate":"2026-05-22T05:00:00Z","ListingId":"NST7079109","LivingArea":"4038","Longitude":"-93.2572751084","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"1.01","LotSizeDimensions":"-","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1550","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-05-22T20:04:35Z","ParcelNumber":"313223240027","ParkingFeatures":"Attached Garage,Detached Garage,Asphalt,Heated Garage","PhotosCount":"37","PhotosChangeTimestamp":"2026-05-23T01:06:06.46Z","PoolFeatures":"Below Ground,Heated,Outdoor","PostalCity":"Ham Lake","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"This exceptional 4-bedroom, 4-bath residence offers refined living on a private, wooded lot in the prestigious Majestic Oaks Golf Course community. Thoughtfully updated throughout, the home showcases a designer kitchen, an elegant sunroom, and a spa-inspired primary suite with a custom walk-in closet. Outdoor living is unparalleled with a wraparound porch, inground pool, and hot tub. A 3-car attached garage is complemented by a heated and air-conditioned detached garage ideal for a fitness studio or collector’s space. A rare opportunity to own a beautifully upgraded home in a premier golf community.","PublicSurveyRange":"23","PublicSurveySection":"31","PublicSurveyTownship":"32","RoadFrontageType":"City Street,Curbs,Street Lights","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt,Pitched","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"Holding Tank,Private Sewer","NST_SpecialSearch":"Main Floor Laundry","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"138th","StreetNumber":"512","StreetNumberNumeric":"512","StreetSuffix":"Avenue","SubdivisionName":"Majestic Oaks West","TaxAnnualAmount":"6059.82","NST_TaxWithAssessments":"6059.82","TaxYear":"2026","BuildingAreaTotal":"4362","Township":"Ham Lake","VideosCount":"0","WaterSource":"Well","YearBuilt":"1997","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST94114","ListAgentMlsId":"NST880502323","ListOfficeMlsId":"NST12127","ListOfficeName":"RES Realty","ListOfficeKey":"NST17084","ModificationTimestamp":"2026-05-23T01:07:06.263Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":27,\"MediaObjectID\":\"NST27\",\"LongDescription\":\"49.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/caedcd4d-cbd8-4f52-b0d1-3fb901d72800.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":400,\"ImageHeight\":600,\"ImageSizeDescription\":\"400x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.589Z\",\"MediaKey\":\"NST122445213\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"10.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/f2202ca2-8b52-47c7-b4d8-3d9a2eee24a8.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":400,\"ImageHeight\":600,\"ImageSizeDescription\":\"400x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.611Z\",\"MediaKey\":\"NST122445232\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"21.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/dd8d9b6c-9a7b-4b87-a406-905c19e29ce3.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":400,\"ImageHeight\":600,\"ImageSizeDescription\":\"400x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.609Z\",\"MediaKey\":\"NST122445225\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"18.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/9307499f-0b4d-4fa5-b8f8-742220b87c47.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.58Z\",\"MediaKey\":\"NST122445227\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"11.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/c1948d7f-8f60-46d4-b316-d351599f8017.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":400,\"ImageHeight\":600,\"ImageSizeDescription\":\"400x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.586Z\",\"MediaKey\":\"NST122445231\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"5.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/59234958-b5ec-438d-ad1d-f957955e0469.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.606Z\",\"MediaKey\":\"NST122445235\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"24.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/c30a480e-0ae6-4ccf-a09f-a32f0c2b9218.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.6Z\",\"MediaKey\":\"NST122445223\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"9.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/cede67f9-5a9d-472b-a08a-c3ea24a2fb13.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.606Z\",\"MediaKey\":\"NST122445233\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"7.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/3682eacc-ef49-4e0f-b6d5-fe983fc3fd5a.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.642Z\",\"MediaKey\":\"NST122445234\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"LongDescription\":\"36.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/01d5abc4-63aa-4d71-b371-b852e8d8e645.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.639Z\",\"MediaKey\":\"NST122445218\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"LongDescription\":\"38.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/c55903a4-45b6-4f4b-9dc7-4b2384b6ea62.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.604Z\",\"MediaKey\":\"NST122445217\"},{\"Order\":26,\"MediaObjectID\":\"NST26\",\"LongDescription\":\"47.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/9fca99eb-418c-45aa-bd9c-a13558074f09.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.578Z\",\"MediaKey\":\"NST122445214\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"29.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/82a7decb-8776-4215-a41a-5647e37d9423.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.647Z\",\"MediaKey\":\"NST122445222\"},{\"Order\":28,\"MediaObjectID\":\"NST28\",\"LongDescription\":\"51.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/ef466120-2fe5-456f-8f44-1cf5b92be92e.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.665Z\",\"MediaKey\":\"NST122445212\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"LongDescription\":\"32.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/247babf8-0581-40b3-9ec7-7b6dd081345a.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.604Z\",\"MediaKey\":\"NST122445220\"},{\"Order\":31,\"MediaObjectID\":\"NST31\",\"LongDescription\":\"55.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/2d52b1c9-f272-41ef-829e-66be78dac2bc.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.584Z\",\"MediaKey\":\"NST122445209\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"14.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/a4f58b86-6d6c-4557-8bf3-c53bd3834f7b.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.702Z\",\"MediaKey\":\"NST122445228\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"13.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/546b47b7-34f1-4625-99de-0b3153737664.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.586Z\",\"MediaKey\":\"NST122445229\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"31.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/e7db3d81-e401-475c-a69d-a5b926d5a26f.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:08.331Z\",\"MediaKey\":\"NST122445221\"},{\"Order\":35,\"MediaObjectID\":\"NST35\",\"LongDescription\":\"61.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/440b72e2-3589-49b8-958f-11276fd08479.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.634Z\",\"MediaKey\":\"NST122445205\"},{\"Order\":32,\"MediaObjectID\":\"NST32\",\"LongDescription\":\"57.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/a85d307a-0504-4b66-88e7-1752947d8ead.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.575Z\",\"MediaKey\":\"NST122445208\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"12.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/c4eec5e0-c846-482b-a467-459f8f27f509.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.6Z\",\"MediaKey\":\"NST122445230\"},{\"Order\":33,\"MediaObjectID\":\"NST33\",\"LongDescription\":\"59.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/eb81a319-4867-485f-b5fb-e7108a0330cd.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.604Z\",\"MediaKey\":\"NST122445207\"},{\"Order\":29,\"MediaObjectID\":\"NST29\",\"LongDescription\":\"52.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/59e0a61b-5f8b-496b-b1f6-2f52e35102ec.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.62Z\",\"MediaKey\":\"NST122445211\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"19.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/6c0a654a-d4a0-4db6-a616-58b87737e7ab.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.603Z\",\"MediaKey\":\"NST122445226\"},{\"Order\":34,\"MediaObjectID\":\"NST34\",\"LongDescription\":\"60.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/a6729eec-4342-488e-9276-bbd2722593a8.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.641Z\",\"MediaKey\":\"NST122445206\"},{\"Order\":25,\"MediaObjectID\":\"NST25\",\"LongDescription\":\"45.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/829c01da-4ffd-49be-a9e0-606a53d45852.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.604Z\",\"MediaKey\":\"NST122445215\"},{\"Order\":24,\"MediaObjectID\":\"NST24\",\"LongDescription\":\"41.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/b2c962a6-2d13-425f-baa8-c8b3acc0673d.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.589Z\",\"MediaKey\":\"NST122445216\"},{\"Order\":30,\"MediaObjectID\":\"NST30\",\"LongDescription\":\"54.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/456a24b8-703e-4079-9b1a-047eeed5250d.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.61Z\",\"MediaKey\":\"NST122445210\"},{\"Order\":36,\"MediaObjectID\":\"NST36\",\"LongDescription\":\"64.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/60cca9f9-48c6-41a8-a5f4-f1125c5b9f9e.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.608Z\",\"MediaKey\":\"NST122445204\"},{\"Order\":37,\"MediaObjectID\":\"NST37\",\"LongDescription\":\"68.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/690359d9-17db-4f40-8097-ccb1b3a43f70.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.582Z\",\"MediaKey\":\"NST122445203\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"22.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/6a70db1c-58bd-45aa-994b-0c29475bd8b9.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.632Z\",\"MediaKey\":\"NST122445224\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"1.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/4b02041b-980b-498e-8ce0-89ffdc29f409.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.631Z\",\"MediaKey\":\"NST122445239\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"LongDescription\":\"33.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/11a5eb26-e9fd-439a-ad36-758a0378dbaa.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.606Z\",\"MediaKey\":\"NST122445219\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"4.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/b5b24aaf-6611-4c50-ab87-04f564f1c890.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.573Z\",\"MediaKey\":\"NST122445236\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"2.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/2db4246c-efea-4fa7-959e-c2a5e4a48262.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.62Z\",\"MediaKey\":\"NST122445238\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"3.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906084/3f3d4ddb-3142-4ae4-97ea-7881eebbede3.jpeg\",\"ResourceRecordKey\":\"NST7906084\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-05-23T01:05:06.627Z\",\"MediaKey\":\"NST122445237\"}]","Media__Order":"27","Media__MediaObjectID":"NST27","Media__LongDescription":"49.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7906084/caedcd4d-cbd8-4f52-b0d1-3fb901d72800.jpeg","Media__ResourceRecordKey":"NST7906084","Media__ImageWidth":"400","Media__ImageHeight":"600","Media__ImageSizeDescription":"400x600","Media__MediaModificationTimestamp":"5/23/2026 1:05:06 AM","Media__MediaKey":"NST122445213","DocumentsChangeTimestamp":"2026-05-23T01:05:06.861Z","Rooms":"[{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"11x16\",\"RoomKey\":\"NST116267172\",\"RoomType\":\"Dining Room\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"31x21\",\"RoomKey\":\"NST116267173\",\"RoomType\":\"Family Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"21x15\",\"RoomKey\":\"NST116267175\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST116267178\",\"RoomType\":\"Bedroom 4\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"17x9\",\"RoomKey\":\"NST116267180\",\"RoomType\":\"Foyer\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"12x23\",\"RoomKey\":\"NST116267174\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"11x7\",\"RoomKey\":\"NST116267179\",\"RoomType\":\"Laundry\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"18x16\",\"RoomKey\":\"NST116267171\",\"RoomType\":\"Living Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":12,\"RoomDimensions\":\"65x10\",\"RoomKey\":\"NST116267182\",\"RoomType\":\"Porch\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"13x12\",\"RoomKey\":\"NST116267176\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"15x19\",\"RoomKey\":\"NST116267181\",\"RoomType\":\"Sun Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":14,\"RoomDimensions\":\"9x7\",\"RoomKey\":\"NST116267184\",\"RoomType\":\"Sun Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"13x12\",\"RoomKey\":\"NST116267177\",\"RoomType\":\"Bedroom 3\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":13,\"RoomDimensions\":\"16x8\",\"RoomKey\":\"NST116267183\",\"RoomType\":\"Walk-In Closet\"}]","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"11x16","Rooms__RoomKey":"NST116267172","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"7.jpg\"},{\"Order\":7,\"Remarks\":\"9.jpg\"},{\"Order\":8,\"Remarks\":\"10.jpg\"},{\"Order\":9,\"Remarks\":\"11.jpg\"},{\"Order\":10,\"Remarks\":\"12.jpg\"},{\"Order\":11,\"Remarks\":\"13.jpg\"},{\"Order\":12,\"Remarks\":\"14.jpg\"},{\"Order\":13,\"Remarks\":\"18.jpg\"},{\"Order\":14,\"Remarks\":\"19.jpg\"},{\"Order\":15,\"Remarks\":\"21.jpg\"},{\"Order\":16,\"Remarks\":\"22.jpg\"},{\"Order\":17,\"Remarks\":\"24.jpg\"},{\"Order\":18,\"Remarks\":\"29.jpg\"},{\"Order\":19,\"Remarks\":\"31.jpg\"},{\"Order\":20,\"Remarks\":\"32.jpg\"},{\"Order\":21,\"Remarks\":\"33.jpg\"},{\"Order\":22,\"Remarks\":\"36.jpg\"},{\"Order\":23,\"Remarks\":\"38.jpg\"},{\"Order\":24,\"Remarks\":\"41.jpg\"},{\"Order\":25,\"Remarks\":\"45.jpg\"},{\"Order\":26,\"Remarks\":\"47.jpg\"},{\"Order\":27,\"Remarks\":\"49.jpg\"},{\"Order\":28,\"Remarks\":\"51.jpg\"},{\"Order\":29,\"Remarks\":\"52.jpg\"},{\"Order\":30,\"Remarks\":\"54.jpg\"},{\"Order\":31,\"Remarks\":\"55.jpg\"},{\"Order\":32,\"Remarks\":\"57.jpg\"},{\"Order\":33,\"Remarks\":\"59.jpg\"},{\"Order\":34,\"Remarks\":\"60.jpg\"},{\"Order\":35,\"Remarks\":\"61.jpg\"},{\"Order\":36,\"Remarks\":\"64.jpg\"},{\"Order\":37,\"Remarks\":\"68.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37","CustomVTourURL":""}
$MLSDESCRIPTION$
512 138th Avenue NE Ham Lake, MN 55304
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
512 138th Avenue NE Ham Lake, MN 55304
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$