{"Id":1378656,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6749292","MLSAGENTID":"NST506019542","MLSOFFICEID":"NST10956","ADDRESS":"1607 Hoyt Avenue E","ACRES":0.14,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Crawl Space,Finished,Full,Storage Space","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Stucco","FORECLOSURE":"No","LASTPRICE":305000.0,"LASTPRICEDATE":"2025-08-13T15:58:04.117","LATITUDE":44.9886186,"LENDEROWNED":"No","LISTDATE":"2025-07-07T05:00:00","LISTPRICE":299900.0,"LIVINGAREA":1313.0,"LONGITUDE":-93.03249039,"MODIFICATIONTIMESTAMP":"2025-08-13T15:58:04.117","NEIGHBORHOOD":"Greater East Side","OFFICE_OFFICENAME":"Creative Results","PHOTOCOUNT":17,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Move in ready! This cozy rambler located in a quiet neighborhood features three bedrooms on main level, sit in kitchen, 2 bathrooms, stainless steel appliances with a finished basement featuring an additional large family room. Fenced backyard with 16x12 patio and a detached two car garage with additional parking. New AC unit just installed.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-07T05:10:03.62","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Hoyt","STREETNUMBER":"1607","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1953,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-07T23:21:03.606","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"Front2\"},{\"Order\":3,\"Remarks\":\"livingroom2\"},{\"Order\":4,\"Remarks\":\"livingroom\"},{\"Order\":5,\"Remarks\":\"Kitchen\"},{\"Order\":6,\"Remarks\":\"Dining - sit in kitchen\"},{\"Order\":7,\"Remarks\":\"Bed 1.jpg\"},{\"Order\":8,\"Remarks\":\"Bed 2\"},{\"Order\":9,\"Remarks\":\"Bed 3\"},{\"Order\":10,\"Remarks\":\"Main Bathroom\"},{\"Order\":11,\"Remarks\":\"Additional Family Room\"},{\"Order\":12,\"Remarks\":\"3/4 Bathroom\"},{\"Order\":13,\"Remarks\":\"Laundry\"},{\"Order\":14,\"Remarks\":\"Maintenance room\"},{\"Order\":15,\"Remarks\":\"Backyard with patio\"},{\"Order\":16,\"Remarks\":\"Backyard\"},{\"Order\":17,\"Remarks\":\"Garage with additional parking\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7768015","LotSizeArea":"0.14","NST_AgeOfProperty":"72","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Kitchen Window,Patio,Washer/Dryer Hookup","Appliances":"Dishwasher,Disposal,Dryer,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block,Crawl Space,Finished,Full,Storage Space","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"37","CumulativeDaysOnMarket":"37","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"White Bear to Larpenteur, West to Kennard, South to Hoyt, West to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers,200+ Amp Service","ConstructionMaterials":"Brick/Stone,Stucco","Fencing":"Chain Link,Full","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"990","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageDimensions":"23 x 22","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"506","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-07-07T05:05:02Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-13","Latitude":"44.9886186044","NST_LenderOwned":"No","ListAgentKey":"NST507546","ListAgentMlsId":"NST506019542","ListingContractDate":"2025-07-07T05:00:00Z","ListOfficeKey":"NST18608","ListOfficeName":"Creative Results","ListOfficeMlsId":"NST10956","ListPrice":"299900","LivingArea":"1313","LockBoxType":"Combo","Longitude":"-93.0324903914","LotSizeDimensions":"124x50","LotSizeSquareFeet":"6185.52","LotSizeUnits":"Acres","ListingId":"NST6749292","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Greater East Side","NST_OfficeBoard":"SPAAR","ParcelNumber":"222922120056","GarageSpaces":"2","PastureArea":"0","PhotosCount":"17","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Move in ready! This cozy rambler located in a quiet neighborhood features three bedrooms on main level, sit in kitchen, 2 bathrooms, stainless steel appliances with a finished basement featuring an additional large family room. Fenced backyard with 16x12 patio and a detached two car garage with additional parking. New AC unit just installed.","PublicSurveyRange":"22","PublicSurveySection":"22","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Age Over 8 Years,Asphalt,Pitched","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Laundry,Patio","NST_AboveGradeSqFtTotal":"990.0000","NST_BelowGradeSqFtTotal":"323.0000","NST_MainLevelFinishedArea":"990.0000","BuildingAreaTotal":"1313","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"990","BelowGradeFinishedArea":"323","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"E","StreetName":"Hoyt","StreetNumber":"1607","StreetNumberNumeric":"1607","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Fred S Herrings 4","NST_TaxWithAssessments":"4024.0000","TaxYear":"2025","TaxAnnualAmount":"3808","CultivatedArea":"0","WaterSource":"City Water/Connected","WoodedArea":"0","YearBuilt":"1953","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-13T15:58:04.117Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7768015\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front\",\"ImageWidth\":1851,\"ImageHeight\":1256,\"ImageSizeDescription\":\"1851x1256\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/539fb787-141b-4177-b08d-8ae4e7efab05.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.252Z\",\"MediaKey\":\"686b567d30c330124997aa71\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Front2\",\"ImageWidth\":1516,\"ImageHeight\":1034,\"ImageSizeDescription\":\"1516x1034\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/e0eac2c0-2b08-4953-8b10-074563f351be.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.267Z\",\"MediaKey\":\"686b567d30c330124997aa72\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"livingroom2\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/726e7623-6d2e-4db2-a5c2-7da9673b4cab.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.249Z\",\"MediaKey\":\"686b567d30c330124997aa74\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"livingroom\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/f7abf668-6df9-4745-85b8-8fbaa724adc0.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.215Z\",\"MediaKey\":\"686b567d30c330124997aa73\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/0ffaf935-3e27-4725-a723-967b96e0faad.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.2Z\",\"MediaKey\":\"686b567d30c330124997aa75\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Dining - sit in kitchen\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/446162b9-5b31-4fd3-9396-6c4d0e968b18.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.215Z\",\"MediaKey\":\"686b567d30c330124997aa76\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Bed 1.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/175c396b-a304-4fd4-a15e-f543e66b175a.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.218Z\",\"MediaKey\":\"686b567d30c330124997aa77\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Bed 2\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/b46e5cbb-0613-4b60-a03d-a319a5c69ff6.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.239Z\",\"MediaKey\":\"686b567d30c330124997aa78\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Bed 3\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/35d04295-526b-45c0-aa94-17da98d5818b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.187Z\",\"MediaKey\":\"686b567d30c330124997aa79\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Main Bathroom\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/d5c5d847-3974-4c9c-89e5-b16956dbc95b.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.228Z\",\"MediaKey\":\"686b567d30c330124997aa7a\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Additional Family Room\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/5558ace5-9f0e-4c79-987c-d435f1f8c7d2.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.185Z\",\"MediaKey\":\"686b567d30c330124997aa7b\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"3/4 Bathroom\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/399e9e61-f78d-4e94-8205-04b4065da9e8.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.183Z\",\"MediaKey\":\"686b567d30c330124997aa7c\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Laundry\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/182e7247-46c4-490c-9052-ea86bf102c5a.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.186Z\",\"MediaKey\":\"686b567d30c330124997aa7d\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Maintenance room\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/c1e0e99a-f856-4b36-a5a6-a90dcdb3532d.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.209Z\",\"MediaKey\":\"686b567d30c330124997aa7e\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Backyard with patio\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/b9e300f6-c4eb-4b79-8a6a-87c4a61046bc.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T23:15:19.375Z\",\"MediaKey\":\"686c550720616d12ffb67460\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Backyard\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/9b9ad1f0-3ff7-4a00-ac0b-f06de2009365.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T05:09:17.205Z\",\"MediaKey\":\"686b567d30c330124997aa7f\"},{\"ResourceRecordKey\":\"NST7768015\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Garage with additional parking\",\"ImageWidth\":2080,\"ImageHeight\":1171,\"ImageSizeDescription\":\"2080x1171\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7768015/717e66ba-8c02-485a-a845-5fcd9a1bdd95.jpeg\",\"MediaModificationTimestamp\":\"2025-07-07T23:15:19.412Z\",\"MediaKey\":\"686c550720616d12ffb67461\"}]","PhotosChangeTimestamp":"2025-07-07T23:21:03.606Z","Rooms":"[{\"RoomKey\":\"NST115382200\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18x11\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115382201\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115382202\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"25x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115382203\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115382204\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x8\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115382205\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115382206\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115382207\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115382208\",\"RoomType\":\"Patio\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16 x 12\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"Front2\"},{\"Order\":3,\"Remarks\":\"livingroom2\"},{\"Order\":4,\"Remarks\":\"livingroom\"},{\"Order\":5,\"Remarks\":\"Kitchen\"},{\"Order\":6,\"Remarks\":\"Dining - sit in kitchen\"},{\"Order\":7,\"Remarks\":\"Bed 1.jpg\"},{\"Order\":8,\"Remarks\":\"Bed 2\"},{\"Order\":9,\"Remarks\":\"Bed 3\"},{\"Order\":10,\"Remarks\":\"Main Bathroom\"},{\"Order\":11,\"Remarks\":\"Additional Family Room\"},{\"Order\":12,\"Remarks\":\"3/4 Bathroom\"},{\"Order\":13,\"Remarks\":\"Laundry\"},{\"Order\":14,\"Remarks\":\"Maintenance room\"},{\"Order\":15,\"Remarks\":\"Backyard with patio\"},{\"Order\":16,\"Remarks\":\"Backyard\"},{\"Order\":17,\"Remarks\":\"Garage with additional parking\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}