{"Id":548350,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7060391","MLSAGENTID":"NST506099074","MLSOFFICEID":"NST8237","ADDRESS":"1896 Grand Avenue","ACRES":0.137,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":475000.0,"LASTPRICEDATE":"2026-04-28T16:16:59.787","LATITUDE":44.939784,"LENDEROWNED":"No","LISTDATE":"2026-04-28T05:00:00","LISTPRICE":475000.0,"LIVINGAREA":1506.0,"LONGITUDE":-93.180586,"MODIFICATIONTIMESTAMP":"2026-04-28T16:33:10.745","NEIGHBORHOOD":"95","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":10,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Classic Mac-Groveland bungalow with flexibility and upside. This 1.5-story home offers 4 bedrooms, 2 baths, and a functional layout. Two main-level bedrooms & a 3/4 main floor bath—highly desirable for today’s buyers.\nBright, open kitchen with granite counters, natural woodwork, and hardwood floors throughout.\nLicensed 4-bedroom rental near the University of St. Thomas with consistent demand.\nKey updates include newer roof (2021/22), front retaining wall (2024), and new sidewalk + backyard patio (2025). Furnace inspected annually.\nSolid home in a premier location—ideal for owner-occupants or investors ready to unlock value.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-28T16:16:59.787","LASTSTATUS":"Active","STREETNAME":"Grand","STREETNUMBER":"1896","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1914,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-28T16:33:10.745","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"New retaining wall\"},{\"Order\":2,\"Remarks\":\"Charming 1.5 Story Bungalow. New retaining wall 2024\"},{\"Order\":3,\"Remarks\":\"New concrete patio\"},{\"Order\":4,\"Remarks\":\"3 steps up and new retaining wall 2024\"},{\"Order\":5,\"Remarks\":\"Private yard with new sidewalk, retaining wall and patio\"},{\"Order\":6,\"Remarks\":\"Lovely birch for shade. Nice quiet entertaining yard\"},{\"Order\":7,\"Remarks\":\"Charming home\"},{\"Order\":8,\"Remarks\":\"3 car parking pad. Storage shed. Flat backyard.\"},{\"Order\":9,\"Remarks\":\"New Roof 2024/25\"},{\"Order\":10,\"Remarks\":\"Lot view from Grand\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7889727","NST_AboveGradeSqFtTotal":"1506","AboveGradeFinishedArea":"1506","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Kitchen Window,Main Floor Primary Bedroom,Natural Woodwork,Porch","Appliances":"Dishwasher,Disposal,Dryer,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AttributionContact":"6517556669","NST_AttributionName":"TJ Pierret","Basement":"Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor 3/4 Bath,Upper Level 3/4 Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room","Directions":"Fairview Avenue to Grand. West to 1896. Home on the South side.","DocumentsCount":"0","DaysOnMarket":"0","FireplaceFeatures":"Brick,Living Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"936","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Boiler","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.939784","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"475000","ListingContractDate":"2026-04-28T05:00:00Z","ListingId":"NST7060391","LivingArea":"1506","Longitude":"-93.180586","LotSizeArea":"0.137","LotSizeDimensions":"40 x 160","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"936","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"95","OriginalEntryTimestamp":"2026-04-28T10:05:02Z","ParcelNumber":"042823310056","ParkingFeatures":"Asphalt,Parking Lot","NST_PatioPorchType":"Front Porch,Patio","PhotosCount":"10","PhotosChangeTimestamp":"2026-04-28T16:33:10.745Z","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Classic Mac-Groveland bungalow with flexibility and upside. This 1.5-story home offers 4 bedrooms, 2 baths, and a functional layout. Two main-level bedrooms & a 3/4 main floor bath—highly desirable for today’s buyers.\nBright, open kitchen with granite counters, natural woodwork, and hardwood floors throughout.\nLicensed 4-bedroom rental near the University of St. Thomas with consistent demand.\nKey updates include newer roof (2021/22), front retaining wall (2024), and new sidewalk + backyard patio (2025). Furnace inspected annually.\nSolid home in a premier location—ideal for owner-occupants or investors ready to unlock value.","PublicSurveyRange":"23","PublicSurveySection":"04","PublicSurveyTownship":"28","NST_RentalLicenseType":"Standard,Other","NST_RentalLicenseYN":"Y","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Grand","StreetNumber":"1896","StreetNumberNumeric":"1896","StreetSuffix":"Avenue","SubdivisionName":"Rosedale Park","TaxAnnualAmount":"6994","NST_TaxWithAssessments":"6994","TaxYear":"2025","BuildingAreaTotal":"1506","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1914","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST75769","ListAgentMlsId":"NST506099074","ListOfficeMlsId":"NST8237","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16731","ModificationTimestamp":"2026-04-28T16:33:10.745Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"3 steps up and new retaining wall 2024\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/533a3c52-d838-4cb1-bc96-8b1e713c307a.jpeg\",\"ImageWidth\":1511,\"ImageHeight\":1041,\"ImageSizeDescription\":\"1511x1041\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.895Z\",\"MediaKey\":\"NST121749428\"},{\"LongDescription\":\"New concrete patio\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/d15f4813-700b-484c-9c5e-2180078fd944.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.854Z\",\"MediaKey\":\"NST121749429\"},{\"LongDescription\":\"Charming home\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/31758d32-6d1f-45a9-8830-8b5a6c8820d4.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.863Z\",\"MediaKey\":\"NST121749419\"},{\"LongDescription\":\"Lot view from Grand\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/bfc49716-3252-43b4-b8b6-510d211ab529.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.941Z\",\"MediaKey\":\"NST121749427\"},{\"LongDescription\":\"Private yard with new sidewalk, retaining wall and patio\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/2373751b-ae6d-4009-a350-02097ca09496.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.868Z\",\"MediaKey\":\"NST121749423\"},{\"LongDescription\":\"Lovely birch for shade. Nice quiet entertaining yard\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/c2719df1-8d36-4a29-873e-6d504cbb0e5f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.868Z\",\"MediaKey\":\"NST121749421\"},{\"LongDescription\":\"New retaining wall\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/8eb4f83c-9064-4fb8-b057-c6f1bb6da3e6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.879Z\",\"MediaKey\":\"NST121749420\"},{\"LongDescription\":\"Charming 1.5 Story Bungalow. New retaining wall 2024\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/f22d4f37-42dd-41a4-8b25-e3f659c8cb65.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.913Z\",\"MediaKey\":\"NST121749425\"},{\"LongDescription\":\"3 car parking pad. Storage shed. Flat backyard.\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/e73a6a4d-4e52-44e5-9929-d954212b163f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.883Z\",\"MediaKey\":\"NST121749418\"},{\"LongDescription\":\"New Roof 2024/25\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7889727\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7889727/a055dea2-c217-4334-b1c8-9f6e33198b69.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-04-28T16:32:16.89Z\",\"MediaKey\":\"NST121749426\"}]","Media__LongDescription":"3 steps up and new retaining wall 2024","Media__Order":"4","Media__MediaObjectID":"NST4","Media__ResourceRecordKey":"NST7889727","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7889727/533a3c52-d838-4cb1-bc96-8b1e713c307a.jpeg","Media__ImageWidth":"1511","Media__ImageHeight":"1041","Media__ImageSizeDescription":"1511x1041","Media__MediaModificationTimestamp":"4/28/2026 4:32:16 PM","Media__MediaKey":"NST121749428","DocumentsChangeTimestamp":"2026-04-28T16:16:59.788Z","Rooms":"[{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"25 x 7\",\"RoomKey\":\"NST116156315\",\"RoomType\":\"Three Season Porch\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"13 x 14\",\"RoomKey\":\"NST116156309\",\"RoomType\":\"Dining Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"12 x 11\",\"RoomKey\":\"NST116156311\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"15 x 13\",\"RoomKey\":\"NST116156314\",\"RoomType\":\"Bedroom 4\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"12 x 6\",\"RoomKey\":\"NST116156310\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"14 x 12\",\"RoomKey\":\"NST116156308\",\"RoomType\":\"Living Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116156316\",\"RoomType\":\"Patio\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"12 x 11\",\"RoomKey\":\"NST116156312\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"15 x 13\",\"RoomKey\":\"NST116156313\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"8","Rooms__RoomDimensions":"25 x 7","Rooms__RoomKey":"NST116156315","Rooms__RoomType":"Three Season Porch","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"New retaining wall\"},{\"Order\":2,\"Remarks\":\"Charming 1.5 Story Bungalow. New retaining wall 2024\"},{\"Order\":3,\"Remarks\":\"New concrete patio\"},{\"Order\":4,\"Remarks\":\"3 steps up and new retaining wall 2024\"},{\"Order\":5,\"Remarks\":\"Private yard with new sidewalk, retaining wall and patio\"},{\"Order\":6,\"Remarks\":\"Lovely birch for shade. Nice quiet entertaining yard\"},{\"Order\":7,\"Remarks\":\"Charming home\"},{\"Order\":8,\"Remarks\":\"3 car parking pad. Storage shed. Flat backyard.\"},{\"Order\":9,\"Remarks\":\"New Roof 2024/25\"},{\"Order\":10,\"Remarks\":\"Lot view from Grand\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}