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":1409853,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6788869","MLSAGENTID":"NST502004159","MLSOFFICEID":"NST4811","ADDRESS":"1243 Majestic Avenue","ACRES":0.03,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Maplewood","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Aluminum Siding","FORECLOSURE":"No","LASTPRICE":299900.0,"LASTPRICEDATE":"2025-09-18T13:49:03.553","LATITUDE":45.03258,"LENDEROWNED":"No","LISTDATE":"2025-09-18T05:00:00","LISTPRICE":299900.0,"LIVINGAREA":1233.0,"LONGITUDE":-93.048386,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-09-18T15:08:03.67","OFFICE_OFFICENAME":"BuySelf, Inc","PHOTOCOUNT":20,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Come home!! Beautiful Maplewood townhome lightly lived in and meticulously maintained by original owner. Open and airy family room with two-story ceilings and expansive windows. Cozy fireplace for winter nights. Kitchen with stainless steel appliances and a half bath are also on the main level. Spacious Owner’s suite on the upper level with walk-in closet and connecting bath. Second bedroom and laundry on the upper level for added convenience. A small loft is perfectly suited for your office needs. This home has an attached two car garage and a small patio to enjoy the outdoors. Many updates including water heater and washing machine in 2022; new roof, furnace and air conditioner in 2023; new dishwasher and new carpet throughout in 2025. This home is conveniently located near restaurants and shops with quick freeway access. Make your move now and settle in before winter","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected,City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-18T13:49:03.553","LASTSTATUS":"Active","STREETNAME":"Majestic","STREETNUMBER":"1243","STREETSUFFIX":"Avenue","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2009,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-18T13:49:03.552","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7802571","LotSizeArea":"0.03","NST_AgeOfProperty":"16","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Ceiling Fan(s),Indoor Sprinklers,Primary Bedroom Walk-In Closet,Patio,In-Ground Sprinkler,Washer/Dryer Hookup","Appliances":"Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Water Filtration System,Water Osmosis System,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Maintenance Structure,Hazard Insurance,Lawn Care,Maintenance Grounds,Parking,Professional Mgmt,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"245","AssociationName":"Sharper Management","AssociationPhone":"952-224-4777","PropertyAttachedYN":"True","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","CarportSpaces":"0","City":"Maplewood","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Informal Dining Room,Living/Dining Room","Directions":"From south, take 35E north to Hwy 36 east, then north on Hwy 61. Left on County Rd D, left on Gulden, right on Regency Ln, Majestic Ave on left. From north, take 35E south to Hwy 694 east, then south on Hwy 61. Right on County Rd D, left on Gulden, right on Regency Ln, Majestic Ave on left.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Aluminum Siding","FireplaceFeatures":"Brick,Gas,Living Room,Stone","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"61 x 22","FoundationArea":"1342","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights,Storm Sewer","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Shared Driveway,Garage Door Opener,Guest Parking","NST_GarageDimensions":"19 x 21","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"399","AccessibilityFeatures":"None","Heating":"Forced Air,Fireplace(s)","OriginalEntryTimestamp":"2025-09-18T13:47:19Z","NST_InternetOptions":"Cable,Satellite","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-18","Latitude":"45.03258","NST_LenderOwned":"No","ListAgentKey":"NST55473","ListAgentMlsId":"NST502004159","ListingContractDate":"2025-09-18T05:00:00Z","ListOfficeKey":"NST15440","ListOfficeName":"BuySelf, Inc","ListOfficeMlsId":"NST4811","ListPrice":"299900","LivingArea":"1233","Longitude":"-93.048386","LotFeatures":"Some Trees","LotSizeDimensions":"61 x 21.5 x 61 x 21.5","LotSizeSquareFeet":"1306.8","LotSizeUnits":"Acres","ListingId":"NST6788869","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"042922110166","GarageSpaces":"2","NST_ParkingOpen":"0","NST_PatioPorchType":"Patio","PhotosCount":"20","PostalCity":"Saint Paul","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PublicRemarks":"Come home!! Beautiful Maplewood townhome lightly lived in and meticulously maintained by original owner. Open and airy family room with two-story ceilings and expansive windows. Cozy fireplace for winter nights. Kitchen with stainless steel appliances and a half bath are also on the main level. Spacious Owner’s suite on the upper level with walk-in closet and connecting bath. Second bedroom and laundry on the upper level for added convenience. A small loft is perfectly suited for your office needs. This home has an attached two car garage and a small patio to enjoy the outdoors. Many updates including water heater and washing machine in 2022; new roof, furnace and air conditioner in 2023; new dishwasher and new carpet throughout in 2025. This home is conveniently located near restaurants and shops with quick freeway access. Make your move now and settle in before winter","PublicSurveyRange":"22","PublicSurveySection":"04","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc,Other Covenants,Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit,Pets - Weight/Height Limit,Rental Restrictions May Apply","RoadResponsibility":"Association Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Loft,Laundry,Garage","NST_AboveGradeSqFtTotal":"1233.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"943.0000","BuildingAreaTotal":"1233","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected,City Sewer - In Street","NST_SpecialSearch":"2nd Floor Laundry,Primary Bdr Suite","AboveGradeFinishedArea":"1233","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Majestic","StreetNumber":"1243","StreetNumberNumeric":"1243","StreetSuffix":"Avenue","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Cic 668 Heritage Square 4th Add","NST_TaxWithAssessments":"3958.0000","TaxYear":"2025","TaxAnnualAmount":"3958","UnitNumber":"313","WaterSource":"City Water/Connected","YearBuilt":"2009","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-18T15:08:03.67Z","PhotosChangeTimestamp":"2025-09-18T13:49:03.552Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7802571\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/68820345-5181-4af5-ac78-e6502ba9ce1e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.89Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c732\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/ef10e6f6-1d7c-4936-85dd-601314ae86ee.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.893Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c733\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/7fecdb43-9ae4-4896-b706-099607f2f3c5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.873Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c734\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/cf6bb8c8-5478-4bc7-ba74-ee8e7e3bf0e0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.892Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c735\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/3629c5b6-862d-4a96-ac44-c5e0bc2b4223.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.897Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c736\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/916d19c7-588b-4c6f-a0cc-557a35b5dcc5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.872Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c737\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/00958f99-6ba8-4520-9f62-e573160ee539.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.871Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c738\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/73b1005d-c2bb-463a-9b54-37c688985b13.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.874Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c739\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/0951032a-6605-4dfe-b601-cd731a5b0ee8.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.871Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c73a\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/453ed00e-2ad2-43f6-9909-9938fb011a65.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.873Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c73b\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/c69fb58a-7e7a-4d8e-bb5f-bbf6473b3744.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.863Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c73c\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/13753061-72fc-4d36-a279-91814a3d3597.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.88Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c73d\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/dbea5fae-9210-4f08-a279-851d875d4184.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.871Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c73e\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/24287a25-c454-40b2-b379-890d57a1a56f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.859Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c73f\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/920545d6-a533-4030-a857-a117aef6726a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.872Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c740\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/048f51d6-12c1-42bd-9fc1-18cb46e12dd4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.858Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c741\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1280,\"ImageHeight\":1920,\"ImageSizeDescription\":\"1280x1920\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/b81a6b25-8d2d-4a7b-991c-b77f7b22217d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.868Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c742\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/6c7ccd1e-06a5-4b69-adc6-137c07cb4de6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.877Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c743\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/9ba2ba1b-77f5-4ecc-b909-83df1f64efd3.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.88Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c744\"},{\"ResourceRecordKey\":\"NST7802571\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7802571/416e3362-e5ab-42f9-b693-0f8092e9ddcf.jpeg\",\"MediaModificationTimestamp\":\"2025-09-18T13:48:47.88Z\",\"MediaKey\":\"68cc0dbf6bab7b056bc3c745\"}]","Rooms":"[{\"RoomKey\":\"NST115624789\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11 x 11\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115624790\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15 x 13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115624791\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9 x 8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115624792\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"11 x 14\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115624793\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"10 x 12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115624794\",\"RoomType\":\"Loft\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"5 x 9\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115624795\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"5 x 9\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115624796\",\"RoomType\":\"Garage\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19 x 21\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}