{"Id":1405827,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6784858","MLSAGENTID":"NST502005053","MLSOFFICEID":"NST10871","ADDRESS":"1145 Hague Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":2200.0,"LASTPRICEDATE":"2025-09-08T23:29:03.92","LATITUDE":44.946048,"LENDEROWNED":"No","LISTDATE":"2025-09-07T05:00:00","LISTPRICE":2200.0,"LIVINGAREA":1651.0,"LONGITUDE":-93.148441,"MODIFICATIONTIMESTAMP":"2025-09-09T23:27:04.056","NEIGHBORHOOD":"Merriam Park/Lexington-Hamline","OFFICE_OFFICENAME":"Tangletown Realty","PHOTOCOUNT":1,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"3+ bedrooms,1 bath,single family home centrally located for easy access to both downtowns & multiple universities & shopping. The main floor features an enclosed front porch,foyer,living room, formal dining room & a newer kitchen. The kitchen island includes a breakfast bar, a dishwasher & the kitchen sink. Newer cabinets, quartz countertops, stainless French door refrigerator & gas stove with center griddle complete the kitchen. Lots of light enhances the beauty of the natural hardwood floors on the main & second story. The second story includes 3 bedrooms, den & a recently updated bathroom. The carpeted third floor has alcoves useful for many purposes. The private back yard is fully fenced with a large deck. A washer & dryer are provided in the full basement. Property is pet friendly. On street parking. $2200/month. Tenant pays all utilities including snow and lawn maintenance. $2200 deposit. Online applications processed with code from listing agent through Tenant Check.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-08T23:29:03.92","LASTSTATUS":"Active","STREETNAME":"Hague","STREETNUMBER":"1145","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1905,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-09T02:02:04.286","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_20250907_140917376_HDR.jpg\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7799052","LotSizeArea":"0.11","NST_AgeOfProperty":"120","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","Appliances":"Dishwasher,Dryer,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_ApplicationFee":"61.0000","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","AvailabilityDate":"2025-10-01T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"Full,Unfinished","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"4","CarportSpaces":"0","City":"Saint Paul","PropertyType":"Residential Lease","NST_ConstructionMaterialsDesc":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","DaysOnMarket":"2","CumulativeDaysOnMarket":"2","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"South of 94 on Lexington Avenue to west on Hague Avenue.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","Fencing":"Partial","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"688","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights,Storm Sewer","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","ParkingFeatures":"On-Street Parking Only","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2025-09-08T23:26:01Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-09","Latitude":"44.946048","NST_LeasePrice":"2200.0000","NST_LenderOwned":"No","ListAgentKey":"NST56825","ListAgentMlsId":"NST502005053","ListingContractDate":"2025-09-07T05:00:00Z","ListOfficeKey":"NST18262","ListOfficeName":"Tangletown Realty","ListOfficeMlsId":"NST10871","LivingArea":"1651","LockBoxType":"Combo","Longitude":"-93.148441","LotSizeDimensions":"40x119","LotSizeUnits":"Acres","ListingId":"NST6784858","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Merriam Park/Lexington-Hamline","NST_OfficeBoard":"SPAAR","ParcelNumber":"032823110122","GarageSpaces":"0","NST_PatioPorchType":"Deck,Enclosed,Front Porch","PhotosCount":"1","PostalCity":"Saint Paul","PostalCode":"55104","NST_PrePaidRent":"No","NST_PresentUse":"Yearly","PublicRemarks":"3+ bedrooms,1 bath,single family home centrally located for easy access to both downtowns & multiple universities & shopping. The main floor features an enclosed front porch,foyer,living room, formal dining room & a newer kitchen. The kitchen island includes a breakfast bar, a dishwasher & the kitchen sink. Newer cabinets, quartz countertops, stainless French door refrigerator & gas stove with center griddle complete the kitchen. Lots of light enhances the beauty of the natural hardwood floors on the main & second story. The second story includes 3 bedrooms, den & a recently updated bathroom. The carpeted third floor has alcoves useful for many purposes. The private back yard is fully fenced with a large deck. A washer & dryer are provided in the full basement. Property is pet friendly. On street parking. $2200/month. Tenant pays all utilities including snow and lawn maintenance. $2200 deposit. Online applications processed with code from listing agent through Tenant Check.","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"28","ListPrice":"2200","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Yes","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Den","NST_AboveGradeSqFtTotal":"1651.0000","NST_BelowGradeSqFtTotal":"688.0000","NST_MainLevelFinishedArea":"688.0000","BuildingAreaTotal":"2339","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","NST_SecurityDeposit":"2200.0000","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"No","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1651","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"More Than 2 Stories","StreetName":"Hague","StreetNumber":"1145","StreetNumberNumeric":"1145","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Anna E Ramsey Add","TenantPays":"Cable TV,Gas,Heat,Trash Collection,Water","WaterSource":"City Water/Connected","YearBuilt":"1905","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-09T23:27:04.056Z","PhotosChangeTimestamp":"2025-09-09T02:02:04.286Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7799052\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_20250907_140917376_HDR.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1815,\"ImageSizeDescription\":\"2080x1815\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7799052/f732945f-5a77-4558-9f63-3f8280f75292.jpeg\",\"MediaModificationTimestamp\":\"2025-09-09T02:01:30.305Z\",\"MediaKey\":\"68bf8a7a94797850a59b2896\"}]","Rooms":"[{\"RoomKey\":\"NST115590557\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115590558\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115590559\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115590560\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115590561\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115590562\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"11x9\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115590563\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Third\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115590564\",\"RoomType\":\"Den\",\"RoomLevel\":\"Second\",\"RoomDimensions\":\"8x6\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_20250907_140917376_HDR.jpg\"}]","PhotoOrder":"1","CustomVTourURL":""}