{"Id":1406113,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6785117","MLSAGENTID":"NST502046203","MLSOFFICEID":"NST41150","ADDRESS":"1447 Hague Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partial","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":194900.0,"LASTPRICEDATE":"2025-09-09T18:02:03.837","LATITUDE":44.946036,"LENDEROWNED":"No","LISTDATE":"2025-09-09T05:00:00","LISTPRICE":194900.0,"LIVINGAREA":904.0,"LONGITUDE":-93.161226,"MODIFICATIONTIMESTAMP":"2025-09-09T18:03:03.664","NEIGHBORHOOD":"Merriam Park/Lexington-Hamline","OFFICE_OFFICENAME":"HOMESTEAD ROAD","PHOTOCOUNT":12,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This property is listed as-is. \nOpportunity awaits with this 3-bedroom, 1-bath property in a prime St. Paul location. The home requires a full rehab, ideal for investors looking for their next project. Solid layout and strong potential to add value. Conveniently located near schools, parks, and major roadways. Newer furnace and updated electrical.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-09T18:02:03.837","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":"2025-09-09T18:03:03.664","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"2 story investment opportunity\"},{\"Order\":2,\"Remarks\":\"8_08.jpg\"},{\"Order\":3,\"Remarks\":\"Main level\"},{\"Order\":4,\"Remarks\":\"Main level dining, looking into living room\"},{\"Order\":5,\"Remarks\":\"Main level dining\"},{\"Order\":6,\"Remarks\":\"Main level kitchen\"},{\"Order\":7,\"Remarks\":\"Main level living room\"},{\"Order\":8,\"Remarks\":\"Flat backyard\"},{\"Order\":9,\"Remarks\":\"Main level floorplan\"},{\"Order\":10,\"Remarks\":\"Upper level floorplan\"},{\"Order\":11,\"Remarks\":\"Lower level floorplan\"},{\"Order\":12,\"Remarks\":\"All levels floorplan\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7799288","LotSizeArea":"0.11","NST_AgeOfProperty":"116","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Partial","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"NORTH OF SUMMIT, EAST OF SNELLING","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"600","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"None","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-09T18:00:10Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-09","Latitude":"44.946036","NST_LenderOwned":"No","ListAgentKey":"NST106141","ListAgentMlsId":"NST502046203","ListingContractDate":"2025-09-09T05:00:00Z","ListOfficeKey":"NST21187","ListOfficeName":"HOMESTEAD ROAD","ListOfficeMlsId":"NST41150","ListPrice":"194900","LivingArea":"904","Longitude":"-93.161226","LotSizeDimensions":"40'x114'x40'x114'","LotSizeSquareFeet":"4748.04","LotSizeUnits":"Acres","ListingId":"NST6785117","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Merriam Park/Lexington-Hamline","NST_OfficeBoard":"MAAR","ParcelNumber":"032823210041","GarageSpaces":"0","PhotosCount":"12","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"This property is listed as-is. \nOpportunity awaits with this 3-bedroom, 1-bath property in a prime St. Paul location. The home requires a full rehab, ideal for investors looking for their next project. Solid layout and strong potential to add value. Conveniently located near schools, parks, and major roadways. Newer furnace and updated electrical.","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"28","NST_RentalLicenseYN":"No","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bathroom","NST_AboveGradeSqFtTotal":"856.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"572.0000","BuildingAreaTotal":"856","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Divided Bdr Flr Plan,Main Floor Bedroom","AboveGradeFinishedArea":"904","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Hague","StreetNumber":"1447","StreetNumberNumeric":"1447","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Boulevard Add","NST_TaxWithAssessments":"3494.0000","TaxYear":"2025","TaxAnnualAmount":"3494","WaterSource":"City Water/Connected","YearBuilt":"1909","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-09T18:03:03.664Z","PhotosChangeTimestamp":"2025-09-09T18:03:03.664Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7799288\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"2 story investment opportunity\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/1cc929a3-df3a-4c33-a7c9-e8a431024963.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.777Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab26\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"8_08.jpg\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/8f63718d-ccfa-4a7e-882b-4da550c14b14.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.718Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab27\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Main level\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/2f11f91c-a552-4399-8e24-12447ad8c5a7.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.708Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab28\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Main level dining, looking into living room\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/31fad765-b8fb-478e-8db0-7a1d63cc1a3a.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.659Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab29\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Main level dining\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/088571fc-9009-4381-b4f4-8275b97c6e14.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.685Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab2a\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Main level kitchen\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/c3ff5a9d-64ec-4b64-a052-db7c49f472f5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.663Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab2b\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Main level living room\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/5b224779-3460-4c96-9d70-a09e7af28eb3.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.708Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab2c\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Flat backyard\",\"ImageWidth\":2044,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2044x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/02ba4ec3-4f35-4bd6-b945-2ee4b0ef0caa.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.725Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab2d\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Main level floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/196b70e3-6617-4edb-8460-f486bd26fd10.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.685Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab2e\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Upper level floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/766150a2-2a88-4b57-acc0-ebcf409b7c77.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.691Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab2f\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Lower level floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/1a0fc923-706c-44a7-8e3a-77c41735bb21.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.726Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab30\"},{\"ResourceRecordKey\":\"NST7799288\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"All levels floorplan\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799288/85ed2b99-8898-47a2-b688-fa9121de837b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T18:02:26.711Z\",\"MediaKey\":\"68c06bb265bea451b9f1ab31\"}]","Rooms":"[{\"RoomKey\":\"NST115592490\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13 x 11.5\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115592491\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9 x 12.5\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115592492\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8.5 x 12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115592493\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11.5 x 9.5\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115592494\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9 x 12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115592495\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10 x 10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115592496\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"2 story investment opportunity\"},{\"Order\":2,\"Remarks\":\"8_08.jpg\"},{\"Order\":3,\"Remarks\":\"Main level\"},{\"Order\":4,\"Remarks\":\"Main level dining, looking into living room\"},{\"Order\":5,\"Remarks\":\"Main level dining\"},{\"Order\":6,\"Remarks\":\"Main level kitchen\"},{\"Order\":7,\"Remarks\":\"Main level living room\"},{\"Order\":8,\"Remarks\":\"Flat backyard\"},{\"Order\":9,\"Remarks\":\"Main level floorplan\"},{\"Order\":10,\"Remarks\":\"Upper level floorplan\"},{\"Order\":11,\"Remarks\":\"Lower level floorplan\"},{\"Order\":12,\"Remarks\":\"All levels floorplan\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}