$LABEL$$CONTENT$
$DESC$
MLS# 6788869 - 1243 Majestic Avenue Maplewood, MN 55109
BuySelf, Inc 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. Cummings Janzen Realty, Inc. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Cummings Janzen Realty, Inc., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"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-30T21:32:04.67","LATITUDE":45.03258,"LENDEROWNED":"No","LISTDATE":"2025-09-18T05:00:00","LISTPRICE":289900.0,"LIVINGAREA":1233.0,"LONGITUDE":-93.048386,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-09-30T21:32:04.669","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_DPResource":"Y","DaysOnMarket":"12","CumulativeDaysOnMarket":"12","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-30","Latitude":"45.03258","NST_LenderOwned":"No","ListAgentKey":"NST55473","ListAgentMlsId":"NST502004159","ListingContractDate":"2025-09-18T05:00:00Z","ListOfficeKey":"NST15440","ListOfficeName":"BuySelf, Inc","ListOfficeMlsId":"NST4811","ListPrice":"289900","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-30T21:32:04.669Z","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\"}]","PhotosChangeTimestamp":"2025-09-18T13:49:03.552Z","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":""}