{"Id":1410823,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6792070","MLSAGENTID":"NST506069571","MLSOFFICEID":"NST5917","ADDRESS":"1081 Hague Avenue","ACRES":0.16,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Storage Space","BATHSTOTAL":3.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":false,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Engineered Wood","FORECLOSURE":"No","LASTPRICE":3500.0,"LASTPRICEDATE":"2025-09-19T22:57:03.847","LATITUDE":44.946042,"LENDEROWNED":"No","LISTDATE":"2025-09-19T05:00:00","LISTPRICE":3500.0,"LIVINGAREA":2400.0,"LONGITUDE":-93.145705,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Some Trees","MODIFICATIONTIMESTAMP":"2025-09-19T22:57:03.845","NEIGHBORHOOD":"Summit-University","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":1,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"POSSESSION AVAILABLE August 1st- \n\n\n\n\nLuxury Furnished Home for Short-Term Lease. Possible long term with furniture removed if needed. Suitable for Temporary Housing During Home Search or New Construction delays. Flexible Lease Options possible. \n\nThis Stunning 1910 Victorian Embodies the Charm of Crocus Hill with High-End Kitchen and Bath. The Residence Offers 4 Bedrooms, 3 Baths, the 4th Bedroom is Converted into a Large Walk-in Closet. Notable Features Include 2 Gas Fireplaces, One in the Living Room and a Double-Sided Fireplace in the Family Room Connecting to the Deck. An Electric Fireplace is Also Present in the 2nd Bedroom. The Neighborhood is Ideal for Walking. Easy Access to Downtown Minneapolis or St. Paul via Highway 9. Close Proximity to Grand Avenue and Selby Restaurants. The Property Occupies a Lot and a Half with a Private Fenced-In Backyard.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-19T22:57:03.847","LASTSTATUS":"Active","STREETNAME":"Hague","STREETNUMBER":"1081","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1910,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-19T22:57:03.845","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Family room with 1/2 bath to deck and covered porch\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7805294","LotSizeArea":"0.16","NST_AgeOfProperty":"115","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","Appliances":"Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_ApplicationFee":"50.0000","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","NST_AttributionContact":"651-222-1007","NST_AttributionName":"Queschen Moet","AvailabilityDate":"2025-11-01T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"Storage Space","BasementYN":"False","NST_BathDesc":"3/4 Basement,Basement,Main Floor 1/2 Bath,Upper Level Full Bath,Jetted Tub","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"2","CarportSpaces":"1","City":"Saint Paul","PropertyType":"Residential Lease","NST_ConstructionMaterialsDesc":"Stone","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Breakfast Bar,Eat In Kitchen,Separate/Formal Dining Room","Directions":"94 to Lexington, south to Hague, east to property (median must to a U-turn at Laurel or use Selby to Oxford to Hague","InternetAddressDisplayYN":"False","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Engineered Wood","Fencing":"Partial,Privacy,Wood","FireplaceFeatures":"Two Sided,Decorative,Electric,Family Room,Free Standing,Gas,Living Room","FireplacesTotal":"3","NST_ForeclosureStatus":"No","FoundationArea":"1092","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","NST_Fuel":"Electric,Natural Gas","Furnished":"Furnished","ParkingFeatures":"Covered","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2025-09-19T22:55:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-19","Latitude":"44.946042","NST_LeasePrice":"3500.0000","NST_LenderOwned":"No","ListAgentKey":"NST54623","ListAgentMlsId":"NST506069571","ListingContractDate":"2025-09-19T05:00:00Z","ListOfficeKey":"NST16645","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST5917","LivingArea":"2400","Longitude":"-93.145705","LotFeatures":"Public Transit (w/in 6 blks),Some Trees","LotSizeDimensions":"irregular","LotSizeUnits":"Acres","ListingId":"NST6792070","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Summit-University","NST_OfficeBoard":"MAAR","OwnerPays":"Water","ParcelNumber":"022823220122","GarageSpaces":"1","NST_ParkingOpen":"2","NST_PatioPorchType":"Covered,Deck,Front Porch,Patio,Porch,Rear Porch,Side Porch","PhotosCount":"1","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55104","NST_PrePaidRent":"No","NST_PresentUse":"Yearly","PublicRemarks":"POSSESSION AVAILABLE August 1st- \n\n\n\n\nLuxury Furnished Home for Short-Term Lease. Possible long term with furniture removed if needed. Suitable for Temporary Housing During Home Search or New Construction delays. Flexible Lease Options possible. \n\nThis Stunning 1910 Victorian Embodies the Charm of Crocus Hill with High-End Kitchen and Bath. The Residence Offers 4 Bedrooms, 3 Baths, the 4th Bedroom is Converted into a Large Walk-in Closet. Notable Features Include 2 Gas Fireplaces, One in the Living Room and a Double-Sided Fireplace in the Family Room Connecting to the Deck. An Electric Fireplace is Also Present in the 2nd Bedroom. The Neighborhood is Ideal for Walking. Easy Access to Downtown Minneapolis or St. Paul via Highway 9. Close Proximity to Grand Avenue and Selby Restaurants. The Property Occupies a Lot and a Half with a Private Fenced-In Backyard.","PublicSurveyRange":"23","PublicSurveySection":"02","PublicSurveyTownship":"28","ListPrice":"3500","NST_RentalLicenseType":"Other","NST_RentalLicenseYN":"Yes","Roof":"Age 8 Years or Less","RoomType":"Kitchen,Living Room,Dining Room,Family Room,Office,Bedroom 1,Bedroom 2,Other Room,Porch,Deck,Laundry","NST_AboveGradeSqFtTotal":"1092.0000","NST_BelowGradeSqFtTotal":"200.0000","NST_MainLevelFinishedArea":"1092.0000","BuildingAreaTotal":"1292","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","NST_SecurityDeposit":"3500.0000","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"No","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"2200","BelowGradeFinishedArea":"200","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Hague","StreetNumber":"1081","StreetNumberNumeric":"1081","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Rogers Add To, St Paul","WaterSource":"City Water/Connected","YearBuilt":"1910","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-19T22:57:03.845Z","PhotosChangeTimestamp":"2025-09-19T22:57:03.845Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7805294\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Family room with 1/2 bath to deck and covered porch\",\"ImageWidth\":957,\"ImageHeight\":2080,\"ImageSizeDescription\":\"957x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7805294/1c4bbb7e-d615-4e5d-8408-4149de50dc40.png\",\"MediaModificationTimestamp\":\"2025-09-19T22:56:45.333Z\",\"MediaKey\":\"68cddfad9cfeda29d1bebf7a\"}]","Rooms":"[{\"RoomKey\":\"NST115632705\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115632706\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115632707\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115632708\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115632709\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115632710\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115632711\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115632712\",\"RoomType\":\"Other Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115632713\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115632714\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115632715\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115632716\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"12\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Family room with 1/2 bath to deck and covered porch\"}]","PhotoOrder":"1","CustomVTourURL":""}