{"Id":1412013,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6793913","MLSAGENTID":"NST506096317","MLSOFFICEID":"NST9419","ADDRESS":"2477 Grenadier Avenue N","ACRES":1.06,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Oakdale","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":244900.0,"LASTPRICEDATE":"2025-09-24T14:16:03.92","LATITUDE":44.984391,"LENDEROWNED":"No","LISTDATE":"2025-09-24T05:00:00","LISTPRICE":244900.0,"LIVINGAREA":1044.0,"LONGITUDE":-92.969153,"MODIFICATIONTIMESTAMP":"2025-09-25T10:06:03.913","OFFICE_OFFICENAME":"Offsite Realty Inc","PHOTOCOUNT":19,"POSTALCODE":"55128","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"WELCOME HOME. Fully renovated single level townhome in the heart of Oakdale. Large main floor bedroom with huge walk-in closet, 2nd bedroom with large closet, attached 1 car oversized garage with shelving, eat in kitchen design w/pantry, walkout patio, tons of green space and guest parking. Monthly association fee of $290 includes - lawn/snow/water/sewer/trash/recycling/exterior maintenance/hazard insurance. Book your appointment today!!!!!!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-24T14:16:03.92","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Grenadier","STREETNUMBER":"2477","STREETSUFFIX":"Avenue","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1987,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-24T14:18:05.023","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"DSCN1568.JPG\"},{\"Order\":2,\"Remarks\":\"DSCN1565.JPG\"},{\"Order\":3,\"Remarks\":\"DSCN1557.JPG\"},{\"Order\":4,\"Remarks\":\"DSCN1556.JPG\"},{\"Order\":5,\"Remarks\":\"DSCN1543.JPG\"},{\"Order\":6,\"Remarks\":\"DSCN1544.JPG\"},{\"Order\":7,\"Remarks\":\"DSCN1548.JPG\"},{\"Order\":8,\"Remarks\":\"DSCN1564.JPG\"},{\"Order\":9,\"Remarks\":\"DSCN1549.JPG\"},{\"Order\":10,\"Remarks\":\"DSCN1550.JPG\"},{\"Order\":11,\"Remarks\":\"DSCN1551.JPG\"},{\"Order\":12,\"Remarks\":\"DSCN1552.JPG\"},{\"Order\":13,\"Remarks\":\"DSCN1554.JPG\"},{\"Order\":14,\"Remarks\":\"DSCN1555.JPG\"},{\"Order\":15,\"Remarks\":\"DSCN1542.JPG\"},{\"Order\":16,\"Remarks\":\"DSCN1566.JPG\"},{\"Order\":17,\"Remarks\":\"DSCN1567.JPG\"},{\"Order\":18,\"Remarks\":\"DSCN1569.JPG\"},{\"Order\":19,\"Remarks\":\"DSCN1570.JPG\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7806842","LotSizeArea":"1.06","NST_AgeOfProperty":"38","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","Appliances":"Cooktop,Dishwasher,Dryer,Microwave,Refrigerator,Washer,Water Softener Owned","NST_AssessmentPending":"No","AssociationFeeIncludes":"Hazard Insurance,Lawn Care,Maintenance Grounds,Professional Mgmt,Trash,Sewer,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"290","AssociationName":"Spire","AssociationPhone":"651-564-4323","PropertyAttachedYN":"True","Basement":"None","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Oakdale","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Stillwater to Grenadier","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1044","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"0","AccessibilityFeatures":"Doors 36\"+,Hallways 42\"+,No Stairs External,No Stairs Internal","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-24T14:12:28Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-25","Latitude":"44.984391","NST_LenderOwned":"No","ListAgentKey":"NST64135","ListAgentMlsId":"NST506096317","ListingContractDate":"2025-09-24T05:00:00Z","ListOfficeKey":"NST15165","ListOfficeName":"Offsite Realty Inc","ListOfficeMlsId":"NST9419","ListPrice":"244900","LivingArea":"1044","Longitude":"-92.969153","LotSizeDimensions":"0","LotSizeSquareFeet":"46086.48","LotSizeUnits":"Acres","ListingId":"NST6793913","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"1902921410016","GarageSpaces":"1","PhotosCount":"19","PostalCity":"Saint Paul","PostalCode":"55128","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"WELCOME HOME. Fully renovated single level townhome in the heart of Oakdale. Large main floor bedroom with huge walk-in closet, 2nd bedroom with large closet, attached 1 car oversized garage with shelving, eat in kitchen design w/pantry, walkout patio, tons of green space and guest parking. Monthly association fee of $290 includes - lawn/snow/water/sewer/trash/recycling/exterior maintenance/hazard insurance. Book your appointment today!!!!!!","PublicSurveyRange":"21","PublicSurveySection":"19","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_Restrictions":"Rentals not Permitted,Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Weight/Height Limit,Rental Restrictions May Apply","Roof":"Age 8 Years or Less","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"1044.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1044.0000","BuildingAreaTotal":"1044","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Bedroom,Main Floor Laundry,Renovated","AboveGradeFinishedArea":"1044","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"Grenadier","StreetNumber":"2477","StreetNumberNumeric":"2477","StreetSuffix":"Avenue","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Condo 57 Estate Sunview","NST_TaxWithAssessments":"1826.0000","TaxYear":"2025","TaxAnnualAmount":"1823","WaterSource":"City Water/Connected","YearBuilt":"1987","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-25T10:06:03.913Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7806842\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"DSCN1568.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/030df83c-335e-4041-97b8-52dc2a82572c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:17:44.156Z\",\"MediaKey\":\"68d3fd881ae1f80e8a7e2f23\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"DSCN1565.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/f0bac519-4e38-4e5e-8cd2-852dc9882ec6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:43.044Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e32\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"DSCN1557.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/c0ceeed8-b719-457f-b6ee-fc763909fa47.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.982Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e33\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"DSCN1556.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/e7f0e751-0ec9-4350-b81c-df1d69e9aa78.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.956Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e34\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"DSCN1543.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/b8660104-89d0-4932-9ef6-5fe1b4ad9722.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.975Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e35\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"DSCN1544.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/4663164d-7320-4cc2-83b3-1edc2fb1c659.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.939Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e36\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"DSCN1548.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/e3a5e87f-5c2c-4192-a8d8-0ab27c6d9fe0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.981Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e37\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"DSCN1564.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/a1d886ac-cc56-4638-892d-f169549f673b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:16:28.557Z\",\"MediaKey\":\"68d3fd3c47c92462d05fac33\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"DSCN1549.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/61a04700-5653-4be9-9e1f-7ab93410d02e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.938Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e38\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"DSCN1550.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/1174d41d-7421-4efa-bbee-d5d0f1d6d570.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.956Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e39\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"DSCN1551.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/41cf8b94-8b52-4396-b920-bd20d07f6d5b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.979Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e3a\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"DSCN1552.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/67b8032a-e9e3-44a1-92e8-bfaf3911e1cb.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.948Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e3b\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"DSCN1554.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/7dc6858c-5bf9-4ba4-849f-2590629297aa.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.989Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e3c\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"DSCN1555.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/f8cbf4f6-9904-45a0-8bcf-db1a904199f9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:15:42.995Z\",\"MediaKey\":\"68d3fd0f1ae1f80e8a7e2e3d\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"DSCN1542.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/a2ebcce0-0059-4b84-a213-7adf11733da0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:14:46.353Z\",\"MediaKey\":\"68d3fcd6c54bc87045a01f6c\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"DSCN1566.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/6a1be269-1fa7-45b1-a262-01db25f76068.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:17:44.14Z\",\"MediaKey\":\"68d3fd881ae1f80e8a7e2f24\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"DSCN1567.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/d7b58877-ea41-44e3-9ad0-95064e34d84a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:17:44.166Z\",\"MediaKey\":\"68d3fd881ae1f80e8a7e2f25\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"DSCN1569.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/ebdd6165-61e3-4b45-a7de-a0e0a25b5233.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:17:44.23Z\",\"MediaKey\":\"68d3fd881ae1f80e8a7e2f26\"},{\"ResourceRecordKey\":\"NST7806842\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"DSCN1570.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7806842/bef7f8c2-c91e-4994-865d-ae6653fb8aa6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-24T14:17:44.167Z\",\"MediaKey\":\"68d3fd881ae1f80e8a7e2f27\"}]","PhotosChangeTimestamp":"2025-09-24T14:18:05.023Z","Rooms":"[{\"RoomKey\":\"NST115642303\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115642304\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115642305\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115642306\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115642307\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"DSCN1568.JPG\"},{\"Order\":2,\"Remarks\":\"DSCN1565.JPG\"},{\"Order\":3,\"Remarks\":\"DSCN1557.JPG\"},{\"Order\":4,\"Remarks\":\"DSCN1556.JPG\"},{\"Order\":5,\"Remarks\":\"DSCN1543.JPG\"},{\"Order\":6,\"Remarks\":\"DSCN1544.JPG\"},{\"Order\":7,\"Remarks\":\"DSCN1548.JPG\"},{\"Order\":8,\"Remarks\":\"DSCN1564.JPG\"},{\"Order\":9,\"Remarks\":\"DSCN1549.JPG\"},{\"Order\":10,\"Remarks\":\"DSCN1550.JPG\"},{\"Order\":11,\"Remarks\":\"DSCN1551.JPG\"},{\"Order\":12,\"Remarks\":\"DSCN1552.JPG\"},{\"Order\":13,\"Remarks\":\"DSCN1554.JPG\"},{\"Order\":14,\"Remarks\":\"DSCN1555.JPG\"},{\"Order\":15,\"Remarks\":\"DSCN1542.JPG\"},{\"Order\":16,\"Remarks\":\"DSCN1566.JPG\"},{\"Order\":17,\"Remarks\":\"DSCN1567.JPG\"},{\"Order\":18,\"Remarks\":\"DSCN1569.JPG\"},{\"Order\":19,\"Remarks\":\"DSCN1570.JPG\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}