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":604727,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7127500","MLSAGENTID":"NST506014470","MLSCOAGENTID":"NST892010107","MLSOFFICEID":"NST49086","ADDRESS":"1240 County Road D E","ACRES":0.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Other","BATHSTOTAL":2.0,"BEDROOMS":2.0,"CITY":"Maplewood","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":289900.0,"LASTPRICEDATE":"2026-08-26T12:46:06.45","LATITUDE":45.034975,"LENDEROWNED":"No","LISTDATE":"2026-08-26T05:00:00","LISTPRICE":289900.0,"LIVINGAREA":1620.0,"LONGITUDE":-93.047962,"MODIFICATIONTIMESTAMP":"2026-08-27T10:52:15.335","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":21,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome home to this beautifully updated townhome featuring modern finishes and an inviting open-concept layout. The kitchen includes granite countertops, stainless steel appliances, and plenty of space for cooking and entertaining. The spacious living room and kitchen is highlighted by a shiplap accent wall, creating a warm and welcoming atmosphere.\n\nEnjoy new flooring throughout the home, adding both durability and contemporary appeal. The generous floor plan offers large bedrooms with ample closet space, providing comfort and flexibility for everyday living.\n\nConveniently located near shopping, dining, and major highways, this home offers an easy commute while keeping you close to everything you need. Combining modern updates, scenic surroundings, and an unbeatable location, this move-in-ready townhome is one you won't want to miss!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"6517487410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-27T05:04:07.107","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"E","STREETNAME":"County Road D","STREETNUMBER":"1240","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-08-26T12:43:06.404","PHOTOREMARKS":"[{\"Order\":3,\"Remarks\":\"open entry to the living room\"},{\"Order\":4,\"Remarks\":\"extra space off the living room makes a great office area\"},{\"Order\":5,\"Remarks\":\"large living room\"},{\"Order\":7,\"Remarks\":\"updated kitchen\"},{\"Order\":11,\"Remarks\":\"cute sitting/storage area at top of stairs\"},{\"Order\":12,\"Remarks\":\"laundry with lots of storage\"},{\"Order\":16,\"Remarks\":\"walk-in closet in primary suite\"},{\"Order\":19,\"Remarks\":\"private garage in underground heated garage\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","SOURCE":"MG_NST"}
{"ListingKey":"NST7951227","NST_AboveGradeSqFtTotal":"1620","AboveGradeFinishedArea":"1620","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Primary Bedroom Walk-In Closet,Porch,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Cooktop,Dishwasher,Dryer,Microwave,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"381","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Sanitation,Sewer,Snow Removal,Water","AssociationName":"Sharper Management Company","AssociationPhone":"9522244777","AttributionContact":"6122451773","NST_AttributionName":"Sarah Hartstein","Basement":"Other","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath,Primary Walk-Thru","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Maplewood","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"I 694 TO HWY 61, South to County Rd D, units on Left","DocumentsCount":"0","DaysOnMarket":"0","NST_ExpectedMarketDate":"2026-08-27","ExteriorFeatures":"Aluminum Siding,Block,Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"810","FoundationDetails":"Poured Concrete","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"441","NST_GarageDimensions":"21x21","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"North St Paul-Maplewood","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.034975","NST_LenderOwned":"No","Levels":"Two","ListPrice":"289900","ListingContractDate":"2026-08-26T05:00:00Z","ListingId":"NST7127500","LivingArea":"1620","Longitude":"-93.047962","LotSizeArea":"0","LotSizeDimensions":"0","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"810","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-27T00:00:20Z","ParcelNumber":"042922110098","ParkingFeatures":"Attached Garage,Garage Door Opener,Guest Parking,Heated Garage,Parking Garage,Parking Lot,Underground","PhotosCount":"21","PhotosChangeTimestamp":"2026-08-26T12:43:06.404Z","PostalCity":"Maplewood","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Welcome home to this beautifully updated townhome featuring modern finishes and an inviting open-concept layout. The kitchen includes granite countertops, stainless steel appliances, and plenty of space for cooking and entertaining. The spacious living room and kitchen is highlighted by a shiplap accent wall, creating a warm and welcoming atmosphere.\n\nEnjoy new flooring throughout the home, adding both durability and contemporary appeal. The generous floor plan offers large bedrooms with ample closet space, providing comfort and flexibility for everyday living.\n\nConveniently located near shopping, dining, and major highways, this home offers an easy commute while keeping you close to everything you need. Combining modern updates, scenic surroundings, and an unbeatable location, this move-in-ready townhome is one you won't want to miss!","PublicSurveyRange":"22","PublicSurveySection":"04","PublicSurveyTownship":"29","Roof":"Age 8 Years or Less","NST_SchoolDistrictFullName":"622 - North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"6517487410","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Single-Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"E","StreetName":"County Road D","StreetNumber":"1240","StreetNumberNumeric":"1240","SubdivisionName":"Cic 668 Heritage Square 4th Add","TaxAnnualAmount":"4000","NST_TaxWithAssessments":"4000","TaxYear":"2025","NST_TotalArea":"1620","BuildingAreaTotal":"1620","Township":"Maplewood","UnitNumber":"3","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2006","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST101467","CoListAgentMlsId":"NST892010107","CoListOfficeName":"Coldwell Banker Realty","ListAgentKey":"NST107870","ListAgentMlsId":"NST506014470","ListOfficeMlsId":"NST49086","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST49086","ModificationTimestamp":"2026-08-27T10:52:15.335Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/7c5cd99c-9815-4b5a-8d1d-fe51495bf231.jpeg\",\"LongDescription\":\"laundry with lots of storage\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.199Z\",\"MediaKey\":\"NST124476047\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/05a6215a-9cab-4966-9383-c8dc53833c11.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.203Z\",\"MediaKey\":\"NST124476040\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/9eedd776-4cc4-4d5a-bd17-d977e11d351f.jpeg\",\"LongDescription\":\"extra space off the living room makes a great office area\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.22Z\",\"MediaKey\":\"NST124476037\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/77d8e774-b261-4f07-9ec2-8b83d859541e.jpeg\",\"LongDescription\":\"open entry to the living room\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.229Z\",\"MediaKey\":\"NST124476054\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/e2180fff-5fa5-4572-98b1-75b44888625c.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.191Z\",\"MediaKey\":\"NST124476052\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/469fa556-cf50-4c70-bb00-1cacbd278650.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.238Z\",\"MediaKey\":\"NST124476050\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/ec39806e-9728-4973-b55e-7db77e1e3cff.jpeg\",\"LongDescription\":\"cute sitting/storage area at top of stairs\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.202Z\",\"MediaKey\":\"NST124476048\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/97a75c99-9759-49df-91c3-06b2c314ea27.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:19:07.878Z\",\"MediaKey\":\"NST124476055\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/33436ce6-00b0-477e-8a22-e7d07286ce9d.jpeg\",\"LongDescription\":\"private garage in underground heated garage\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-26T00:59:03.854Z\",\"MediaKey\":\"NST124476036\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/12532f0b-e8a0-4687-a854-75ab97a55cd7.jpeg\",\"LongDescription\":\"large living room\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.229Z\",\"MediaKey\":\"NST124476053\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/cf92ce5f-1fdb-463d-9acc-e3ec45feb082.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.201Z\",\"MediaKey\":\"NST124476049\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/13353d1e-e633-4b34-bd34-9e520bba131b.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.22Z\",\"MediaKey\":\"NST124476044\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/23414e64-28e5-4005-b1f6-d947b6b71d01.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.205Z\",\"MediaKey\":\"NST124476041\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/2dde8aaf-2329-44f5-bc0b-20edfcd8b5a2.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.222Z\",\"MediaKey\":\"NST124476046\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/7c603bff-3387-4642-8d6a-95db63cbb413.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-26T00:59:03.804Z\",\"MediaKey\":\"NST124476035\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/6398e680-de54-4c03-bc8d-e996a8aa651c.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.24Z\",\"MediaKey\":\"NST124476043\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/67c8e28d-1909-4f45-932a-3db9cff4da17.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":2048,\"ImageHeight\":1364,\"ImageSizeDescription\":\"2048x1364\",\"MediaModificationTimestamp\":\"2026-08-26T00:59:03.819Z\",\"MediaKey\":\"NST124476034\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/8c778a60-e9ee-4dc7-8e1a-263d269372b0.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:19:07.906Z\",\"MediaKey\":\"NST124476056\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/c03eb011-24c2-4c7b-9ebf-4a3b97cc96a7.jpeg\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.248Z\",\"MediaKey\":\"NST124476045\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/554e6db2-6ed5-4691-9e46-50adc5a1c350.jpeg\",\"LongDescription\":\"walk-in closet in primary suite\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.195Z\",\"MediaKey\":\"NST124476042\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7951227/66cf40cf-17a6-4b53-a3e6-ac4a330b4473.jpeg\",\"LongDescription\":\"updated kitchen\",\"ResourceRecordKey\":\"NST7951227\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-25T22:53:09.204Z\",\"MediaKey\":\"NST124476051\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7951227/7c5cd99c-9815-4b5a-8d1d-fe51495bf231.jpeg","Media__LongDescription":"laundry with lots of storage","Media__ResourceRecordKey":"NST7951227","Media__Order":"12","Media__MediaObjectID":"NST12","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"8/25/2026 10:53:09 PM","Media__MediaKey":"NST124476047","DocumentsChangeTimestamp":"2026-08-26T12:43:06.404Z","Rooms":"[{\"RoomDimensions\":\"9x15\",\"RoomKey\":\"NST116606735\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bathroom\"},{\"RoomDimensions\":\"15x11\",\"RoomKey\":\"NST116606730\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\"},{\"RoomDimensions\":\"20x12\",\"RoomKey\":\"NST116606732\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\"},{\"RoomDimensions\":\"15x13.5\",\"RoomKey\":\"NST116606731\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\"},{\"RoomDimensions\":\"8.5x8.5\",\"RoomKey\":\"NST116606734\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Laundry\"},{\"RoomDimensions\":\"15x18\",\"RoomKey\":\"NST116606729\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\"},{\"RoomDimensions\":\"12x10.5\",\"RoomKey\":\"NST116606733\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\"}]","Rooms__RoomDimensions":"9x15","Rooms__RoomKey":"NST116606735","Rooms__RoomLevel":"Upper","Rooms__NST_RoomSortOrder":"7","Rooms__RoomType":"Bathroom","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":3,\"Remarks\":\"open entry to the living room\"},{\"Order\":4,\"Remarks\":\"extra space off the living room makes a great office area\"},{\"Order\":5,\"Remarks\":\"large living room\"},{\"Order\":7,\"Remarks\":\"updated kitchen\"},{\"Order\":11,\"Remarks\":\"cute sitting/storage area at top of stairs\"},{\"Order\":12,\"Remarks\":\"laundry with lots of storage\"},{\"Order\":16,\"Remarks\":\"walk-in closet in primary suite\"},{\"Order\":19,\"Remarks\":\"private garage in underground heated garage\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21","CustomVTourURL":""}