MLS# NST7158867 - 500 Constance Boulevard NE Ham Lake, MN 55304

RE/MAX Advantage Plus 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. Bob Albrecht Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Bob Albrecht Real Estate, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":625447,"ORGTABLE":"RAW_Property","MLSCLASS":"LND","MLSNUMBER":"NST7158867","MLSAGENTID":"NST505002586","MLSOFFICEID":"NST3726","ADDRESS":"500 Constance Boulevard NE","ACRES":104.0,"AGENTOWNER":false,"AUCTIONYN":false,"CITY":"Ham Lake","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FARMTYPE":"Horse,Livestock","FORECLOSURE":"No","LASTPRICE":3250000.0,"LASTPRICEDATE":"2026-10-16T20:41:06.827","LATITUDE":45.264758,"LENDEROWNED":"No","LISTDATE":"2026-10-16T05:00:00","LISTPRICE":3250000.0,"LIVINGAREA":0.0,"LONGITUDE":-93.258897,"LOTDESCRIPTION":"Corner Lot,Green Acres,Irregular Lot,Suitable for Horses,Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-10-16T20:41:06.826","OFFICE_OFFICENAME":"RE/MAX Advantage Plus","OUTBUILDINGS":"Barn(s),Storage Shed","PHOTOCOUNT":27,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"An exceptional opportunity awaits in Ham Lake! Featuring 104 acres of land with development potential, this expansive property offers a beautiful combination of open agricultural fields, established hay ground, mature woods, and scenic countryside surroundings. With frontage along Constance Boulevard NE and University Avenue NE, the property offers a versatile setting with possibilities for future development or continued agricultural use. An established homesite is tucked among mature trees and includes a 3-bedroom, 2.5-bath residence with approximately 1,790 finished square feet, along with numerous agricultural improvements. The property features four barns, two sheds, fencing, and pasture areas well-suited for horses and livestock. A spacious 40x130 horse barn includes multiple stalls, a large pen, and an insulated tack room, while the 35x60 shop/storage building offers a spray-foam-insulated workshop heated by a wood stove. Additional outbuildings provide space for small animals, equipment, and storage. Existing well, septic, and utility connections serve the homesite. Whether you're exploring development opportunities, agricultural investment, or a large acreage property with established improvements, this unique offering presents tremendous potential. Don't miss this unique opportunity to explore all that this expansive property has to offer!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SALEINCLUDES":"Other","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-10-16T20:41:06.827","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"Constance","STREETNUMBER":"500","STREETSUFFIX":"Boulevard","TRANSACTIONTYPE":"For Sale","WATERFRONTPRESENT":false,"YEARBUILT":1971,"ZONING":"Other,Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-10-16T20:41:06.826","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 500 Constance Boulevard NE in Ham Lake! An incredible opportunity featuring 104 acres of land with development potential in a beautiful countryside setting\"},{\"Order\":2,\"Remarks\":\"A picturesque landscape featuring expansive green fields, mature trees, and vibrant wooded areas that provide a beautiful natural backdrop\"},{\"Order\":3,\"Remarks\":\"Wide-open agricultural land with convenient frontage along Constance Boulevard NE, offering excellent visibility and accessibility\"},{\"Order\":4,\"Remarks\":\"Aerial view outlining the property boundaries, showcasing the impressive size and layout of this expansive parcel\"},{\"Order\":5,\"Remarks\":\"With generous stretches of open land and wooded areas, this property offers flexibility for a variety of future possibilities\"},{\"Order\":6,\"Remarks\":\"Established hay fields and open farmland offer opportunities for continued agricultural use while exploring future possibilities\"},{\"Order\":7,\"Remarks\":\"The existing homesite is tucked among mature trees and includes a residence, multiple barns, and additional outbuildings\"},{\"Order\":8,\"Remarks\":\"An established equestrian setup with fenced pastures, spacious horse facilities, and room for livestock to roam\"},{\"Order\":9,\"Remarks\":\"Spacious fenced pastures provide plenty of room for horses and livestock to graze and enjoy the open countryside\"},{\"Order\":10,\"Remarks\":\"A closer look at the established agricultural fields, offering productive land for hay production and farming activities\"},{\"Order\":11,\"Remarks\":\"A tree-lined paved driveway with white fencing provides an attractive entrance to the existing homesite and surrounding acreage\"},{\"Order\":12,\"Remarks\":\"Mature trees and established landscaping line the driveway, providing convenient access to the property's residential and agricultural improvements\"},{\"Order\":13,\"Remarks\":\"The property includes an existing residence with an attached two-car garage, adding value and flexibility to this expansive land opportunity\"},{\"Order\":14,\"Remarks\":\"An aerial perspective of the existing home, one of several improvements located on the 104-acre property\"},{\"Order\":15,\"Remarks\":\"The established homesite offers a spacious yard surrounded by mature trees, providing a peaceful setting within the larger acreage\"},{\"Order\":16,\"Remarks\":\"A bird's-eye view of the residential portion of the property, showcasing its wooded surroundings and separation from the agricultural fields\"},{\"Order\":17,\"Remarks\":\"White fencing and established pasture areas surround the agricultural outbuildings, providing a functional setup for horses and livestock\"},{\"Order\":18,\"Remarks\":\"Mature trees offer a scenic backdrop to the existing barns and livestock facilities, adding to the property's rural character\"},{\"Order\":19,\"Remarks\":\"An overhead view of the property's collection of agricultural buildings, offering extensive space for horses, equipment, workshop use, and storage\"},{\"Order\":20,\"Remarks\":\"The spacious 40x130 horse barn features multiple stalls, a large 40x40 pen, and an insulated tack room, providing an established equestrian setup\"},{\"Order\":21,\"Remarks\":\"A bird's-eye view of the existing homesite and outbuildings, situated among mature trees with convenient access to the surrounding acreage\"},{\"Order\":22,\"Remarks\":\"A sweeping aerial view highlights the property's road frontage, open fields, and wooded areas, offering an excellent perspective of the land's layout\"},{\"Order\":23,\"Remarks\":\"A diverse landscape of open meadows, scattered trees, and natural wooded areas provides a variety of possibilities for future land use\"},{\"Order\":24,\"Remarks\":\"Expansive green fields stretch toward the existing agricultural improvements, showcasing the property's substantial open acreage and established farming setting\"},{\"Order\":25,\"Remarks\":\"A picturesque entrance to the established homesite off Constance Boulevard NE, with a tree-lined driveway surrounded by mature trees and scenic countryside\"},{\"Order\":26,\"Remarks\":\"The existing farmstead is surrounded by generous open acreage, creating a versatile setting with plenty of possibilities for the future\"},{\"Order\":27,\"Remarks\":\"An exceptional opportunity to own 104 acres in Ham Lake! Whether exploring future development possibilities or continuing its agricultural use, this expansive property offers incredible potential for its next chapter\"}]","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","SOURCE":"MG_NST"}
{"ListingKey":"NST7982202","AdditionalParcelsDescription":"183223240001,183223130001,183223230003","AdditionalParcelsYN":"True","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","BasementYN":"False","CumulativeDaysOnMarket":"0","City":"Ham Lake","Contingency":"None","CountyOrParish":"Anoka","NST_CropType":"Hay/Alfalfa","DevelopmentStatus":"Raw Land","NST_DevelopmentAmenityType":"No","Directions":"From Hwy 65, head west on Constance Blvd NE. Continue to 500 Constance Blvd NE.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-10-16T20:30:08.28Z","DaysOnMarket":"0","NST_DomIncrementTimestamp":"2026-10-16","NST_DomIncrementYN":"true","NST_FarmType":"Horse,Livestock","Fencing":"Partial","NST_FractionalOwnershipYN":"No","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","Inclusions":"Other","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","NST_Improvements":"Fence","LandLeaseYN":"False","NST_SaleOptions":"Sell Entirely","Latitude":"45.264758","NST_LenderOwned":"No","ListPrice":"3250000","ListingContractDate":"2026-10-16T05:00:00Z","ListingId":"NST7158867","Longitude":"-93.258897","LotFeatures":"Corner Lot,Green Acres,Irregular Lot,Suitable for Horses,Tree Coverage - Medium","LotSizeArea":"104","LotSizeDimensions":"Irregular","LotSizeUnits":"Acres","OriginalEntryTimestamp":"2026-10-16T15:29:43Z","OtherStructures":"Barn(s),Storage Shed","ParcelNumber":"183223240002","PhotosCount":"27","PhotosChangeTimestamp":"2026-10-16T20:41:06.826Z","PostalCity":"Ham Lake","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","NST_ProgramAcresTotal":"0","PropertyType":"Land","PublicRemarks":"An exceptional opportunity awaits in Ham Lake! Featuring 104 acres of land with development potential, this expansive property offers a beautiful combination of open agricultural fields, established hay ground, mature woods, and scenic countryside surroundings. With frontage along Constance Boulevard NE and University Avenue NE, the property offers a versatile setting with possibilities for future development or continued agricultural use. An established homesite is tucked among mature trees and includes a 3-bedroom, 2.5-bath residence with approximately 1,790 finished square feet, along with numerous agricultural improvements. The property features four barns, two sheds, fencing, and pasture areas well-suited for horses and livestock. A spacious 40x130 horse barn includes multiple stalls, a large pen, and an insulated tack room, while the 35x60 shop/storage building offers a spray-foam-insulated workshop heated by a wood stove. Additional outbuildings provide space for small animals, equipment, and storage. Existing well, septic, and utility connections serve the homesite. Whether you're exploring development opportunities, agricultural investment, or a large acreage property with established improvements, this unique offering presents tremendous potential. Don't miss this unique opportunity to explore all that this expansive property has to offer!","PublicSurveyRange":"23","PublicSurveySection":"18","PublicSurveyTownship":"32","NST_Restrictions":"Open","RoadFrontageType":"City Street,Paved Streets","RoadResponsibility":"Public Maintained Road","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"Constance","StreetNumber":"500","StreetNumberNumeric":"500","StreetSuffix":"Boulevard","TaxAnnualAmount":"4308","NST_TaxWithAssessments":"4308","TaxYear":"2026","Topography":"Gently Rolling,Level,Pasture,Wooded","Township":"Ham Lake","Utilities":"Electricity Available,Electricity Connected,Natural Gas Available,Natural Gas Connected,Private Septic Available,Private Septic Connected,Private Well Available,Private Well Connected","VideosCount":"0","WaterfrontYN":"False","YearBuilt":"1971","ZoningDescription":"Other,Residential-Single Family","ListAgentKey":"NST48049","ListAgentMlsId":"NST505002586","ListOfficeMlsId":"NST3726","ListOfficeName":"RE/MAX Advantage Plus","ListOfficeKey":"NST16024","ModificationTimestamp":"2026-10-16T20:41:06.826Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/b4daceaa-e1e6-4d43-8b68-00a13fef03d1.jpeg\",\"LongDescription\":\"A tree-lined paved driveway with white fencing provides an attractive entrance to the existing homesite and surrounding acreage\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:08:05.724Z\",\"MediaKey\":\"NST125470951\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/4915d2c6-ebc0-46fb-a570-b717e08ffb42.jpeg\",\"LongDescription\":\"Spacious fenced pastures provide plenty of room for horses and livestock to graze and enjoy the open countryside\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-16T20:07:06.844Z\",\"MediaKey\":\"NST125470939\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/dcfa12e0-f20e-4a79-a0b6-d3adbc4e7710.jpeg\",\"LongDescription\":\"Mature trees and established landscaping line the driveway, providing convenient access to the property's residential and agricultural improvements\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:08:05.732Z\",\"MediaKey\":\"NST125470953\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/3d688a10-2d73-4376-94a0-6e487a127939.jpeg\",\"LongDescription\":\"The spacious 40x130 horse barn features multiple stalls, a large 40x40 pen, and an insulated tack room, providing an established equestrian setup\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.469Z\",\"MediaKey\":\"NST125470935\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/d9b88413-a8ed-487f-a8aa-a6e0fbb66661.jpeg\",\"LongDescription\":\"Aerial view outlining the property boundaries, showcasing the impressive size and layout of this expansive parcel\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1158,\"ImageSizeDescription\":\"2048x1158\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.814Z\",\"MediaKey\":\"NST125470954\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/88ca5ab6-4933-4c9d-bbb5-c9efbe6af2a7.jpeg\",\"LongDescription\":\"An established equestrian setup with fenced pastures, spacious horse facilities, and room for livestock to roam\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:07:06.828Z\",\"MediaKey\":\"NST125470927\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/9d6e9466-0363-41b2-b6a5-27576b739ace.jpeg\",\"LongDescription\":\"With generous stretches of open land and wooded areas, this property offers flexibility for a variety of future possibilities\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.805Z\",\"MediaKey\":\"NST125470952\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/eb479ce4-682f-4c3f-9fa6-fd60c6eaa64a.jpeg\",\"LongDescription\":\"The existing homesite is tucked among mature trees and includes a residence, multiple barns, and additional outbuildings\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.833Z\",\"MediaKey\":\"NST125470922\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/5fa87dd4-186d-440d-9bb6-1c1621f6dfae.jpeg\",\"LongDescription\":\"An aerial perspective of the existing home, one of several improvements located on the 104-acre property\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:08:05.68Z\",\"MediaKey\":\"NST125470929\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/b618f9f0-7d34-49bf-82e7-077f94e8c687.jpeg\",\"LongDescription\":\"An overhead view of the property's collection of agricultural buildings, offering extensive space for horses, equipment, workshop use, and storage\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.476Z\",\"MediaKey\":\"NST125470928\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/3dc817bc-a42e-408a-b33a-f627eb8e9865.jpeg\",\"LongDescription\":\"A picturesque landscape featuring expansive green fields, mature trees, and vibrant wooded areas that provide a beautiful natural backdrop\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.841Z\",\"MediaKey\":\"NST125470905\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/07219de7-21d5-4f7c-bdeb-81fcc41817c4.jpeg\",\"LongDescription\":\"A sweeping aerial view highlights the property's road frontage, open fields, and wooded areas, offering an excellent perspective of the land's layout\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.461Z\",\"MediaKey\":\"NST125470915\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/7f105e24-4b3d-4f91-9c7e-adef8af490f7.jpeg\",\"LongDescription\":\"The property includes an existing residence with an attached two-car garage, adding value and flexibility to this expansive land opportunity\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:08:05.673Z\",\"MediaKey\":\"NST125470948\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/832fe8e5-4441-47e7-b481-4bd62df2abfe.jpeg\",\"LongDescription\":\"A diverse landscape of open meadows, scattered trees, and natural wooded areas provides a variety of possibilities for future land use\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.466Z\",\"MediaKey\":\"NST125470918\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/8113d02d-892e-44ce-b744-2f1719e9e914.jpeg\",\"LongDescription\":\"Established hay fields and open farmland offer opportunities for continued agricultural use while exploring future possibilities\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.809Z\",\"MediaKey\":\"NST125470924\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/72342c8f-516e-444c-b5d4-1f77785eb945.jpeg\",\"LongDescription\":\"Mature trees offer a scenic backdrop to the existing barns and livestock facilities, adding to the property's rural character\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.465Z\",\"MediaKey\":\"NST125470938\"},{\"Order\":24,\"MediaObjectID\":\"NST24\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/6d0894ea-fb2a-42e3-a9a1-f866daebd253.jpeg\",\"LongDescription\":\"Expansive green fields stretch toward the existing agricultural improvements, showcasing the property's substantial open acreage and established farming setting\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.459Z\",\"MediaKey\":\"NST125470916\"},{\"Order\":25,\"MediaObjectID\":\"NST25\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/25ff32c1-b911-40ca-ba1d-fe9e14fbde8f.jpeg\",\"LongDescription\":\"A picturesque entrance to the established homesite off Constance Boulevard NE, with a tree-lined driveway surrounded by mature trees and scenic countryside\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.5Z\",\"MediaKey\":\"NST125470914\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/38a8c576-7276-42ae-8628-9a85ea97c383.jpeg\",\"LongDescription\":\"Welcome to 500 Constance Boulevard NE in Ham Lake! An incredible opportunity featuring 104 acres of land with development potential in a beautiful countryside setting\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.864Z\",\"MediaKey\":\"NST125470906\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/9cad4e95-6e9e-4f0d-8630-83f3f833ebd8.jpeg\",\"LongDescription\":\"A closer look at the established agricultural fields, offering productive land for hay production and farming activities\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:07:06.811Z\",\"MediaKey\":\"NST125470926\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/3d04ee5e-55fa-480f-bb15-211a8a99d8bd.jpeg\",\"LongDescription\":\"Wide-open agricultural land with convenient frontage along Constance Boulevard NE, offering excellent visibility and accessibility\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:05:05.847Z\",\"MediaKey\":\"NST125470921\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/9afb43bc-a760-4396-98a8-0c0240a5cdd0.jpeg\",\"LongDescription\":\"White fencing and established pasture areas surround the agricultural outbuildings, providing a functional setup for horses and livestock\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.477Z\",\"MediaKey\":\"NST125470940\"},{\"Order\":26,\"MediaObjectID\":\"NST26\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/e5688ce3-e131-446a-89f2-85fe5d830392.jpeg\",\"LongDescription\":\"The existing farmstead is surrounded by generous open acreage, creating a versatile setting with plenty of possibilities for the future\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.502Z\",\"MediaKey\":\"NST125470911\"},{\"Order\":27,\"MediaObjectID\":\"NST27\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/72bc44e4-c122-40f9-9460-38d4d460385c.jpeg\",\"LongDescription\":\"An exceptional opportunity to own 104 acres in Ham Lake! Whether exploring future development possibilities or continuing its agricultural use, this expansive property offers incredible potential for its next chapter\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.47Z\",\"MediaKey\":\"NST125470910\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/bde68c7e-e9c0-48cb-b902-4b5c3b62bae7.jpeg\",\"LongDescription\":\"A bird's-eye view of the existing homesite and outbuildings, situated among mature trees with convenient access to the surrounding acreage\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.498Z\",\"MediaKey\":\"NST125470897\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/2f9b97c6-9e64-45c3-be81-59464185e41c.jpeg\",\"LongDescription\":\"A bird's-eye view of the residential portion of the property, showcasing its wooded surroundings and separation from the agricultural fields\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1152,\"ImageSizeDescription\":\"2048x1152\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.483Z\",\"MediaKey\":\"NST125470909\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/5671abb5-7b6a-4792-a741-2ee70cac5f3a.jpeg\",\"LongDescription\":\"The established homesite offers a spacious yard surrounded by mature trees, providing a peaceful setting within the larger acreage\",\"ResourceRecordKey\":\"NST7982202\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-16T20:40:08.513Z\",\"MediaKey\":\"NST125470942\"}]","Media__Order":"11","Media__MediaObjectID":"NST11","Media__MediaURL":"https://media.mlsgrid.com/token=7uZ8qpuGbZVVDOuXehWLErkfHEYd-S0NSDk1-k4zuNo&expires=1792188565&id=5d6fc86794c5224544394849/images/NST7982202/b4daceaa-e1e6-4d43-8b68-00a13fef03d1.jpeg","Media__LongDescription":"A tree-lined paved driveway with white fencing provides an attractive entrance to the existing homesite and surrounding acreage","Media__ResourceRecordKey":"NST7982202","Media__ImageWidth":"2048","Media__ImageHeight":"1152","Media__ImageSizeDescription":"2048x1152","Media__MediaModificationTimestamp":"10/16/2026 8:08:05 PM","Media__MediaKey":"NST125470951","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 500 Constance Boulevard NE in Ham Lake! An incredible opportunity featuring 104 acres of land with development potential in a beautiful countryside setting\"},{\"Order\":2,\"Remarks\":\"A picturesque landscape featuring expansive green fields, mature trees, and vibrant wooded areas that provide a beautiful natural backdrop\"},{\"Order\":3,\"Remarks\":\"Wide-open agricultural land with convenient frontage along Constance Boulevard NE, offering excellent visibility and accessibility\"},{\"Order\":4,\"Remarks\":\"Aerial view outlining the property boundaries, showcasing the impressive size and layout of this expansive parcel\"},{\"Order\":5,\"Remarks\":\"With generous stretches of open land and wooded areas, this property offers flexibility for a variety of future possibilities\"},{\"Order\":6,\"Remarks\":\"Established hay fields and open farmland offer opportunities for continued agricultural use while exploring future possibilities\"},{\"Order\":7,\"Remarks\":\"The existing homesite is tucked among mature trees and includes a residence, multiple barns, and additional outbuildings\"},{\"Order\":8,\"Remarks\":\"An established equestrian setup with fenced pastures, spacious horse facilities, and room for livestock to roam\"},{\"Order\":9,\"Remarks\":\"Spacious fenced pastures provide plenty of room for horses and livestock to graze and enjoy the open countryside\"},{\"Order\":10,\"Remarks\":\"A closer look at the established agricultural fields, offering productive land for hay production and farming activities\"},{\"Order\":11,\"Remarks\":\"A tree-lined paved driveway with white fencing provides an attractive entrance to the existing homesite and surrounding acreage\"},{\"Order\":12,\"Remarks\":\"Mature trees and established landscaping line the driveway, providing convenient access to the property's residential and agricultural improvements\"},{\"Order\":13,\"Remarks\":\"The property includes an existing residence with an attached two-car garage, adding value and flexibility to this expansive land opportunity\"},{\"Order\":14,\"Remarks\":\"An aerial perspective of the existing home, one of several improvements located on the 104-acre property\"},{\"Order\":15,\"Remarks\":\"The established homesite offers a spacious yard surrounded by mature trees, providing a peaceful setting within the larger acreage\"},{\"Order\":16,\"Remarks\":\"A bird's-eye view of the residential portion of the property, showcasing its wooded surroundings and separation from the agricultural fields\"},{\"Order\":17,\"Remarks\":\"White fencing and established pasture areas surround the agricultural outbuildings, providing a functional setup for horses and livestock\"},{\"Order\":18,\"Remarks\":\"Mature trees offer a scenic backdrop to the existing barns and livestock facilities, adding to the property's rural character\"},{\"Order\":19,\"Remarks\":\"An overhead view of the property's collection of agricultural buildings, offering extensive space for horses, equipment, workshop use, and storage\"},{\"Order\":20,\"Remarks\":\"The spacious 40x130 horse barn features multiple stalls, a large 40x40 pen, and an insulated tack room, providing an established equestrian setup\"},{\"Order\":21,\"Remarks\":\"A bird's-eye view of the existing homesite and outbuildings, situated among mature trees with convenient access to the surrounding acreage\"},{\"Order\":22,\"Remarks\":\"A sweeping aerial view highlights the property's road frontage, open fields, and wooded areas, offering an excellent perspective of the land's layout\"},{\"Order\":23,\"Remarks\":\"A diverse landscape of open meadows, scattered trees, and natural wooded areas provides a variety of possibilities for future land use\"},{\"Order\":24,\"Remarks\":\"Expansive green fields stretch toward the existing agricultural improvements, showcasing the property's substantial open acreage and established farming setting\"},{\"Order\":25,\"Remarks\":\"A picturesque entrance to the established homesite off Constance Boulevard NE, with a tree-lined driveway surrounded by mature trees and scenic countryside\"},{\"Order\":26,\"Remarks\":\"The existing farmstead is surrounded by generous open acreage, creating a versatile setting with plenty of possibilities for the future\"},{\"Order\":27,\"Remarks\":\"An exceptional opportunity to own 104 acres in Ham Lake! Whether exploring future development possibilities or continuing its agricultural use, this expansive property offers incredible potential for its next chapter\"}]","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","CustomVTourURL":""}