{"Id":528005,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7034174","MLSAGENTID":"NST502046203","MLSOFFICEID":"NST41150","ADDRESS":"1447 Hague Avenue","ACRES":0.109,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partial","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":274900.0,"LASTPRICEDATE":"2026-03-12T17:23:07.027","LATITUDE":44.946036,"LENDEROWNED":"No","LISTDATE":"2026-03-12T05:00:00","LISTPRICE":274900.0,"LIVINGAREA":909.0,"LONGITUDE":-93.161226,"MODIFICATIONTIMESTAMP":"2026-03-13T10:05:10.411","NEIGHBORHOOD":"96","OFFICE_OFFICENAME":"HOMESTEAD ROAD","PHOTOCOUNT":19,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Professionally remodeled by a licensed construction company, this home features a brand-new kitchen with cabinetry, quartz countertops, and appliances. The bathroom has been fully updated, and new carpet throughout gives the home a fresh, move-in-ready feel.\n\nLocated in Saint Paul’s Hamline-Midway, the home is just minutes from downtown Saint Paul and Minneapolis. Enjoy nearby parks, neighborhood shops, and restaurants, with easy access to Hamline University and major transit routes.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-12T17:23:07.027","LASTSTATUS":"Active","STREETNAME":"Hague","STREETNUMBER":"1447","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1909,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-12T17:46:05.928","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Main level: living room\"},{\"Order\":2,\"Remarks\":\"Main level: dining room looking into the kitchen\"},{\"Order\":3,\"Remarks\":\"Main level: dining room looking into the living room\"},{\"Order\":4,\"Remarks\":\"Main level: kitchen\"},{\"Order\":5,\"Remarks\":\"Main level: kitchen\"},{\"Order\":6,\"Remarks\":\"Main level: kitchen\"},{\"Order\":7,\"Remarks\":\"Main level: kitchen\"},{\"Order\":8,\"Remarks\":\"Main level: kitchen\"},{\"Order\":9,\"Remarks\":\"Main level: bedroom 1\"},{\"Order\":10,\"Remarks\":\"Upper level: bedroom 2\"},{\"Order\":11,\"Remarks\":\"Upper level: bedroom 3\"},{\"Order\":12,\"Remarks\":\"Upper level: full bathroom\"},{\"Order\":13,\"Remarks\":\"Exterior with large flat backyard\"},{\"Order\":14,\"Remarks\":\"Exterior with large flat backyard\"},{\"Order\":15,\"Remarks\":\"Exterior with with large flat backyard\"},{\"Order\":16,\"Remarks\":\"Main level floor plan\"},{\"Order\":17,\"Remarks\":\"Upper level floor plan\"},{\"Order\":18,\"Remarks\":\"Basement floor plan\"},{\"Order\":19,\"Remarks\":\"All levels floor plan\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7866254","NST_AboveGradeSqFtTotal":"909","AboveGradeFinishedArea":"909","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Partial","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"342","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"52","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room","Directions":"NORTH OF SUMMIT, EAST OF SNELLING","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-03-12T17:52:06.248Z","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"511","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.946036","NST_LenderOwned":"No","Levels":"Two","ListPrice":"274900","ListingContractDate":"2026-03-12T05:00:00Z","ListingId":"NST7034174","LivingArea":"909","Longitude":"-93.161226","LotSizeArea":"0.109","LotSizeDimensions":"40'x114'x40'x114'","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"511","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"96","OriginalEntryTimestamp":"2026-03-12T12:21:45Z","ParcelNumber":"032823210041","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"None","PhotosCount":"19","PhotosChangeTimestamp":"2026-03-12T17:46:05.928Z","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Professionally remodeled by a licensed construction company, this home features a brand-new kitchen with cabinetry, quartz countertops, and appliances. The bathroom has been fully updated, and new carpet throughout gives the home a fresh, move-in-ready feel.\n\nLocated in Saint Paul’s Hamline-Midway, the home is just minutes from downtown Saint Paul and Minneapolis. Enjoy nearby parks, neighborhood shops, and restaurants, with easy access to Hamline University and major transit routes.","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"28","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,Main Floor Bedroom,Rehabbed,Renovated","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Hague","StreetNumber":"1447","StreetNumberNumeric":"1447","StreetSuffix":"Avenue","SubdivisionName":"Boulevard Add","TaxAnnualAmount":"3494","NST_TaxWithAssessments":"3494","TaxYear":"2025","BuildingAreaTotal":"1251","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1909","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST106141","ListAgentMlsId":"NST502046203","ListOfficeMlsId":"NST41150","ListOfficeName":"HOMESTEAD ROAD","ListOfficeKey":"NST21187","ModificationTimestamp":"2026-03-13T10:05:10.411Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/20f1bfb7-b7e8-4d6c-be29-fce356b709ca.jpeg\",\"LongDescription\":\"Main level: kitchen\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.424Z\",\"MediaKey\":\"NST120906513\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/b15ca722-fc04-4eab-8ca7-ffa334751f57.jpeg\",\"LongDescription\":\"Upper level floor plan\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.424Z\",\"MediaKey\":\"NST120906576\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/aaabd5ac-c774-41f1-9aad-e4b8063e6759.jpeg\",\"LongDescription\":\"Main level: dining room looking into the kitchen\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.414Z\",\"MediaKey\":\"NST120906525\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/64b809d9-15fa-46ce-86f6-7ac8c9e8db47.jpeg\",\"LongDescription\":\"Upper level: bedroom 3\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.451Z\",\"MediaKey\":\"NST120906510\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/c4619abe-c928-4d92-86fa-4b48632236c2.jpeg\",\"LongDescription\":\"Main level: dining room looking into the living room\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.401Z\",\"MediaKey\":\"NST120906524\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/ed170911-bd38-42da-815c-57d4998722fc.jpeg\",\"LongDescription\":\"Upper level: full bathroom\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.425Z\",\"MediaKey\":\"NST120906506\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/77e1dac6-1226-46c9-af5d-f582b98e3246.jpeg\",\"LongDescription\":\"Upper level: bedroom 2\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.451Z\",\"MediaKey\":\"NST120906512\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/1007d6a5-0d30-42a2-b60a-8cc885566bfd.jpeg\",\"LongDescription\":\"Main level: kitchen\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.402Z\",\"MediaKey\":\"NST120906515\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/9ceb8bb0-9b89-4d9e-8eec-f99e00b3d794.jpeg\",\"LongDescription\":\"Main level: kitchen\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.427Z\",\"MediaKey\":\"NST120906517\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/c4259362-d3f6-4a0b-865e-9d13c616a222.jpeg\",\"LongDescription\":\"Main level: living room\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.451Z\",\"MediaKey\":\"NST120906527\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/0ea72aca-5f99-4c77-97a0-ceb9c40db5e8.jpeg\",\"LongDescription\":\"Main level: kitchen\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.484Z\",\"MediaKey\":\"NST120906514\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/0daf1232-6dfb-4f2c-8aeb-491d87431b82.jpeg\",\"LongDescription\":\"Basement floor plan\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.405Z\",\"MediaKey\":\"NST120906578\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/33ca103a-8f2e-46ba-8f63-9f1bf3c9937c.jpeg\",\"LongDescription\":\"Main level floor plan\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.401Z\",\"MediaKey\":\"NST120906577\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/99dafa00-14c0-4c68-a6e7-15920f1f8d88.jpeg\",\"LongDescription\":\"All levels floor plan\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.4Z\",\"MediaKey\":\"NST120906575\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/31fefca3-c958-4e20-ace3-9c5577286a71.jpeg\",\"LongDescription\":\"Main level: bedroom 1\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.401Z\",\"MediaKey\":\"NST120906522\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/e81260c0-d19f-47ac-8d14-cc9f304d14bd.jpeg\",\"LongDescription\":\"Main level: kitchen\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.401Z\",\"MediaKey\":\"NST120906518\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/4661c897-1d72-41fe-baca-bf391fd14538.jpeg\",\"LongDescription\":\"Exterior with with large flat backyard\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.437Z\",\"MediaKey\":\"NST120906530\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/f2a737b3-8103-4664-9d6d-caf0c750ad83.jpeg\",\"LongDescription\":\"Exterior with large flat backyard\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.44Z\",\"MediaKey\":\"NST120906533\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7866254/0e188c1a-63a4-49c3-b08c-c92ac8b50e6f.jpeg\",\"LongDescription\":\"Exterior with large flat backyard\",\"ResourceRecordKey\":\"NST7866254\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-03-12T17:45:16.443Z\",\"MediaKey\":\"NST120906529\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7866254/20f1bfb7-b7e8-4d6c-be29-fce356b709ca.jpeg","Media__LongDescription":"Main level: kitchen","Media__ResourceRecordKey":"NST7866254","Media__Order":"8","Media__MediaObjectID":"NST8","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"3/12/2026 5:45:16 PM","Media__MediaKey":"NST120906513","Rooms":"[{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116010348\",\"RoomDimensions\":\"12x8\",\"RoomType\":\"Bathroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116010343\",\"RoomDimensions\":\"12x09\",\"RoomType\":\"Dining Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116010345\",\"RoomDimensions\":\"12x9\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116010344\",\"RoomDimensions\":\"12x8\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116010342\",\"RoomDimensions\":\"15x13\",\"RoomType\":\"Living Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116010346\",\"RoomDimensions\":\"12x9\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116010347\",\"RoomDimensions\":\"10x9\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomLevel":"Upper","Rooms__NST_RoomSortOrder":"7","Rooms__RoomKey":"NST116010348","Rooms__RoomDimensions":"12x8","Rooms__RoomType":"Bathroom","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Main level: living room\"},{\"Order\":2,\"Remarks\":\"Main level: dining room looking into the kitchen\"},{\"Order\":3,\"Remarks\":\"Main level: dining room looking into the living room\"},{\"Order\":4,\"Remarks\":\"Main level: kitchen\"},{\"Order\":5,\"Remarks\":\"Main level: kitchen\"},{\"Order\":6,\"Remarks\":\"Main level: kitchen\"},{\"Order\":7,\"Remarks\":\"Main level: kitchen\"},{\"Order\":8,\"Remarks\":\"Main level: kitchen\"},{\"Order\":9,\"Remarks\":\"Main level: bedroom 1\"},{\"Order\":10,\"Remarks\":\"Upper level: bedroom 2\"},{\"Order\":11,\"Remarks\":\"Upper level: bedroom 3\"},{\"Order\":12,\"Remarks\":\"Upper level: full bathroom\"},{\"Order\":13,\"Remarks\":\"Exterior with large flat backyard\"},{\"Order\":14,\"Remarks\":\"Exterior with large flat backyard\"},{\"Order\":15,\"Remarks\":\"Exterior with with large flat backyard\"},{\"Order\":16,\"Remarks\":\"Main level floor plan\"},{\"Order\":17,\"Remarks\":\"Upper level floor plan\"},{\"Order\":18,\"Remarks\":\"Basement floor plan\"},{\"Order\":19,\"Remarks\":\"All levels floor plan\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}