Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":1406611,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6786686","MLSAGENTID":"NST502048231","MLSOFFICEID":"NST5237","ADDRESS":"12737 Farnham Lane","ACRES":0.24,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Rogers","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Shake Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":454990.0,"LASTPRICEDATE":"2025-09-10T16:31:03.83","LATITUDE":45.18722094,"LENDEROWNED":"No","LISTDATE":"2025-09-10T05:00:00","LISTPRICE":454990.0,"LIVINGAREA":2606.0,"LONGITUDE":-93.56213585,"MODIFICATIONTIMESTAMP":"2025-09-10T16:37:03.886","OFFICE_OFFICENAME":"Pulte Homes Of Minnesota, LLC","PHOTOCOUNT":14,"POSTALCODE":"55374","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"The soon to be move in ready Hampton floor plan is an open-concept layout with an additional flex room on the main level that would work great for an office or Den. This Hampton plan includes 4 Bedrooms and large loft plus a laundry room all on the upper-level! Anchored by great schools, plentiful dining and retail options, and recreation, Rogers is a fast growing city in Hennepin County. All of this within District #728 and only 25 minutes from downtown! Please note that this home is under construction and photos are of model properties. Model is open from 11am-6pm. Move in fall 2025!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"728-Elk River","SCHOOLDISTRICTPHONE":"763-241-3400","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-10T16:31:03.83","LASTSTATUS":"Active","STREETNAME":"Farnham","STREETNUMBER":"12737","STREETSUFFIX":"Lane","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-10T16:37:03.886","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Pictures are of actual home for sale. Available for October closing!\"},{\"Order\":2,\"Remarks\":\"IMG_2423.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2424.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_2425.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_2426.jpg\"},{\"Order\":6,\"Remarks\":\"IMG_2427.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_2428.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_2429.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_2430.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_2431.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_2432.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_2433.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_2434.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_2435.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7800656","LotSizeArea":"0.24","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Ethernet Wired,Kitchen Center Island,Primary Bedroom Walk-In Closet,In-Ground Sprinkler,Vaulted Ceiling(s),Washer/Dryer Hookup","Appliances":"Dishwasher,Microwave,Range,Tankless Water Heater","NST_AssessmentPending":"No","AssociationFeeIncludes":"Trash","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"32","AssociationName":"First Service Residential","AssociationPhone":"952-277-2716","PropertyAttachedYN":"False","Basement":"None","BasementYN":"False","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BuilderLicense":"627273","BuilderName":"PULTE HOMES","City":"Rogers","PropertyType":"Residential","NST_CommunityName":"Aster Mill","NST_CompletionDate":"2025-09-30","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Hennepin","NST_DiningRoomDescription":"Kitchen/Dining Room,Living/Dining Room,Separate/Formal Dining Room","Directions":"Please put Aster Mill in Google Maps! 94 west to 101 south. go to Main Street take a right then go to Industrial Blvd take a right. Follow to Pulte Homes on the Left.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Brick/Stone,Shake Siding,Vinyl Siding","FireplacesTotal":"0","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"2606","FoundationArea":"1303","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageDimensions":"19x24","NST_GarageSquareFeet":"480","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-10T16:26:30Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-10","Latitude":"45.1872209393","NST_LenderOwned":"No","ListAgentKey":"NST110263","ListAgentMlsId":"NST502048231","ListingContractDate":"2025-09-10T05:00:00Z","ListOfficeKey":"NST15595","ListOfficeName":"Pulte Homes Of Minnesota, LLC","ListOfficeMlsId":"NST5237","ListPrice":"454990","LivingArea":"2606","Longitude":"-93.5621358473","LotSizeDimensions":"W61X132X60X132","LotSizeSquareFeet":"10454.4","LotSizeUnits":"Acres","ListingId":"NST6786686","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","NST_ModelHours":"11-6 (7 days per week)","NST_ModelLocation":"12861 Weber Lane","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"tbd","GarageSpaces":"2","NST_PatioPorchType":"Covered,Front Porch","PhotosCount":"14","PoolFeatures":"None","PostalCity":"Rogers","PostalCode":"55374","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","NST_PropertySubTypeDesc":"Patio Home","PublicRemarks":"The soon to be move in ready Hampton floor plan is an open-concept layout with an additional flex room on the main level that would work great for an office or Den. This Hampton plan includes 4 Bedrooms and large loft plus a laundry room all on the upper-level! Anchored by great schools, plentiful dining and retail options, and recreation, Rogers is a fast growing city in Hennepin County. All of this within District #728 and only 25 minutes from downtown! Please note that this home is under construction and photos are of model properties. Model is open from 11am-6pm. Move in fall 2025!","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less","RoomType":"Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Loft,Flex Room,Informal Dining Room","NST_AboveGradeSqFtTotal":"2606.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1303.0000","BuildingAreaTotal":"2606","HighSchoolDistrict":"Elk River","NST_SchoolDistrictNumber":"728","NST_SchoolDistrictPhone":"763-241-3400","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,4 BR on One Level","AboveGradeFinishedArea":"2606","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Farnham","StreetNumber":"12737","StreetNumberNumeric":"12737","StreetSuffix":"Lane","PropertySubType":"Single Family Residence","SubdivisionName":"Aster Mill","NST_TaxWithAssessments":"0.0000","TaxYear":"2025","TaxAnnualAmount":"0","NST_TotalUnitsSold":"46","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-10T16:37:03.886Z","PhotosChangeTimestamp":"2025-09-10T16:37:03.886Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7800656\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Pictures are of actual home for sale. Available for October closing!\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/e3dc0fc3-1cc3-4dca-ba7b-c3208ab489f9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:33:34.407Z\",\"MediaKey\":\"68c1a85e7c1b5f351fda2592\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_2423.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/352f8b47-f67f-4573-a5b6-637c29000f3d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.744Z\",\"MediaKey\":\"68c1a90ae099d71796fa6668\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_2424.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/4c6c7e89-6638-4606-b9a6-236009382171.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.783Z\",\"MediaKey\":\"68c1a90ae099d71796fa6669\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"IMG_2425.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/1a21aa57-e6b5-4dc1-8c63-4f58cd9e7d94.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.744Z\",\"MediaKey\":\"68c1a90ae099d71796fa666a\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"IMG_2426.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/83bf8297-aa40-4357-9d3a-ea7f93e14b13.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.744Z\",\"MediaKey\":\"68c1a90ae099d71796fa666b\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"IMG_2427.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/b1c42125-9e87-41a5-9205-b7d52e92c01d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.869Z\",\"MediaKey\":\"68c1a90ae099d71796fa666c\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"IMG_2428.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/440c4d42-ee95-4a9b-b716-ee3e067f208f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.718Z\",\"MediaKey\":\"68c1a90ae099d71796fa666d\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"IMG_2429.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/5c8c60fd-04d7-421a-9dc7-dbf16f55dba7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.759Z\",\"MediaKey\":\"68c1a90ae099d71796fa666e\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"IMG_2430.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/ca770080-1b40-4fef-b1ea-b45f52102ba6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.744Z\",\"MediaKey\":\"68c1a90ae099d71796fa666f\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"IMG_2431.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/111dd3f1-c56e-4e8f-a840-297dd9ec6592.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.828Z\",\"MediaKey\":\"68c1a90ae099d71796fa6670\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"IMG_2432.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/e97f9fee-3acf-4dcf-aa3f-77b70215be3a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.744Z\",\"MediaKey\":\"68c1a90ae099d71796fa6671\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"IMG_2433.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/7a465aea-f2d5-4f25-972c-c850ed07bf07.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.817Z\",\"MediaKey\":\"68c1a90ae099d71796fa6672\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"IMG_2434.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/210736d5-997e-448e-98e0-b53ca4acb2c9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.839Z\",\"MediaKey\":\"68c1a90ae099d71796fa6673\"},{\"ResourceRecordKey\":\"NST7800656\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"IMG_2435.jpg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7800656/e5711d21-3bac-41e2-b486-22454e3c307d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-10T16:36:26.79Z\",\"MediaKey\":\"68c1a90ae099d71796fa6674\"}]","Rooms":"[{\"RoomKey\":\"NST115600893\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x4\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115600894\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115600895\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"18x13\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115600896\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115600897\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x9\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115600898\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115600899\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115600900\",\"RoomType\":\"Flex Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x12\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115600901\",\"RoomType\":\"Flex Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115600902\",\"RoomType\":\"Informal Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Pictures are of actual home for sale. Available for October closing!\"},{\"Order\":2,\"Remarks\":\"IMG_2423.jpg\"},{\"Order\":3,\"Remarks\":\"IMG_2424.jpg\"},{\"Order\":4,\"Remarks\":\"IMG_2425.jpg\"},{\"Order\":5,\"Remarks\":\"IMG_2426.jpg\"},{\"Order\":6,\"Remarks\":\"IMG_2427.jpg\"},{\"Order\":7,\"Remarks\":\"IMG_2428.jpg\"},{\"Order\":8,\"Remarks\":\"IMG_2429.jpg\"},{\"Order\":9,\"Remarks\":\"IMG_2430.jpg\"},{\"Order\":10,\"Remarks\":\"IMG_2431.jpg\"},{\"Order\":11,\"Remarks\":\"IMG_2432.jpg\"},{\"Order\":12,\"Remarks\":\"IMG_2433.jpg\"},{\"Order\":13,\"Remarks\":\"IMG_2434.jpg\"},{\"Order\":14,\"Remarks\":\"IMG_2435.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}