{"Id":1397411,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6773959","MLSAGENTID":"NST506017404","MLSOFFICEID":"NST10590","ADDRESS":"1685 Fremont Avenue","ACRES":0.14,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partially Finished","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":289900.0,"LASTPRICEDATE":"2025-09-22T19:40:03.903","LATITUDE":44.95793,"LENDEROWNED":"No","LISTDATE":"2025-08-17T05:00:00","LISTPRICE":279900.0,"LIVINGAREA":1475.0,"LONGITUDE":-93.029203999999993,"MODIFICATIONTIMESTAMP":"2025-09-22T19:40:03.903","NEIGHBORHOOD":"Battle Creek-Highwood","OFFICE_OFFICENAME":"Empire Realty LLC","PHOTOCOUNT":11,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Move-In Ready 3-Bedroom Charmer in East St. Paul! \nStep inside this freshly updated home that’s full of character and comfort. You’ll love the bright, open feel with brand-new vinyl flooring, newly installed windows, and a fresh coat of paint throughout. The bathroom has been classically redone, giving the space a modern touch you’ll appreciate every day. Enjoy worry-free living with major updates already done for you—including a new furnace, water heater, and central A/C installed in 2022. Plus, the washer and dryer are included, making this home truly move-in ready. Perfectly located on St. Paul’s East Side, this home is close to parks, shops, and local favorites—everything you need is just minutes away. Don’t miss your chance—schedule your showing today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-19T14:19:05.297","LASTSTATUS":"Active","STREETNAME":"Fremont","STREETNUMBER":"1685","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1955,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-18T00:35:03.721","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Easter25-1.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_0503.JPG\"},{\"Order\":3,\"Remarks\":\"IMG_0493.JPG\"},{\"Order\":4,\"Remarks\":\"IMG_0497.JPG\"},{\"Order\":5,\"Remarks\":\"IMG_0489.JPG\"},{\"Order\":6,\"Remarks\":\"IMG_0479.JPG\"},{\"Order\":7,\"Remarks\":\"IMG_0476.JPG\"},{\"Order\":8,\"Remarks\":\"IMG_0483.JPG\"},{\"Order\":9,\"Remarks\":\"IMG_0486.JPG\"},{\"Order\":10,\"Remarks\":\"IMG_0501.JPG\"},{\"Order\":11,\"Remarks\":\"IMG_0502.JPG\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7789526","LotSizeArea":"0.14","NST_AgeOfProperty":"70","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Partially Finished","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","NST_DPResource":"Y","DaysOnMarket":"36","CumulativeDaysOnMarket":"36","Directions":"From 94, North on White Bear Ave\nMake a left at Fremont Ave\nHome on right 2 blocks down","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Stucco","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1475","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric","ParkingFeatures":"Detached,Asphalt","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-18T00:31:01Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-22","Latitude":"44.95793","NST_LenderOwned":"No","ListAgentKey":"NST227034","ListAgentMlsId":"NST506017404","ListingContractDate":"2025-08-17T05:00:00Z","ListOfficeKey":"NST17562","ListOfficeName":"Empire Realty LLC","ListOfficeMlsId":"NST10590","ListPrice":"279900","LivingArea":"1475","Longitude":"-93.029204","LotSizeDimensions":"6300","LotSizeSquareFeet":"6272.64","LotSizeUnits":"Acres","ListingId":"NST6773959","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Battle Creek-Highwood","NST_OfficeBoard":"SPAAR","ParcelNumber":"342922140084","GarageSpaces":"1","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Move-In Ready 3-Bedroom Charmer in East St. Paul! \nStep inside this freshly updated home that’s full of character and comfort. You’ll love the bright, open feel with brand-new vinyl flooring, newly installed windows, and a fresh coat of paint throughout. The bathroom has been classically redone, giving the space a modern touch you’ll appreciate every day. Enjoy worry-free living with major updates already done for you—including a new furnace, water heater, and central A/C installed in 2022. Plus, the washer and dryer are included, making this home truly move-in ready. Perfectly located on St. Paul’s East Side, this home is close to parks, shops, and local favorites—everything you need is just minutes away. Don’t miss your chance—schedule your showing today!","PublicSurveyRange":"22","PublicSurveySection":"34","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_AboveGradeSqFtTotal":"1475.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1475.0000","BuildingAreaTotal":"1475","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer - In Street","AboveGradeFinishedArea":"1475","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Fremont","StreetNumber":"1685","StreetNumberNumeric":"1685","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Stiepans Add","NST_TaxWithAssessments":"4262.0000","TaxYear":"2025","TaxAnnualAmount":"4262","WaterSource":"City Water - In Street","YearBuilt":"1955","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-22T19:40:03.903Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7789526\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Easter25-1.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/c1ac3e8d-a972-482b-8274-7609e43fcb37.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.317Z\",\"MediaKey\":\"68a27516829577348727ec14\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_0503.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/58cab2e6-23b8-4d27-b2a4-8fb067eb4fcc.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.317Z\",\"MediaKey\":\"68a27516829577348727ec15\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_0493.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/3654984a-45c7-4717-9eb8-5b2395d01392.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.39Z\",\"MediaKey\":\"68a27516829577348727ec16\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"IMG_0497.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/13c2451c-1203-424e-8435-b2b58c13ed39.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.355Z\",\"MediaKey\":\"68a27516829577348727ec17\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"IMG_0489.JPG\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/2bc5e2a8-da04-45de-b015-ffcc355d36c5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.309Z\",\"MediaKey\":\"68a27516829577348727ec18\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"IMG_0479.JPG\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/b0523d29-355d-48d4-b8c6-220a1022bf0f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.296Z\",\"MediaKey\":\"68a27516829577348727ec19\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"IMG_0476.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/487dd677-30cc-4241-8454-6d475fa29c1d.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.295Z\",\"MediaKey\":\"68a27516829577348727ec1a\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"IMG_0483.JPG\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/cc28db18-cdaf-407a-9c84-e8364eec4bec.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.357Z\",\"MediaKey\":\"68a27516829577348727ec1b\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"IMG_0486.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/3c20707c-5534-4c96-9a9b-fee6d2bb1a66.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.351Z\",\"MediaKey\":\"68a27516829577348727ec1c\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"IMG_0501.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/7792110e-414d-4bf6-a153-ecb73dead9df.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.369Z\",\"MediaKey\":\"68a27516829577348727ec1d\"},{\"ResourceRecordKey\":\"NST7789526\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"IMG_0502.JPG\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789526/401be87c-13cb-4e59-84b1-6cf2789c1655.jpeg\",\"MediaModificationTimestamp\":\"2025-08-18T00:34:30.398Z\",\"MediaKey\":\"68a27516829577348727ec1e\"}]","PhotosChangeTimestamp":"2025-08-18T00:35:03.721Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Easter25-1.jpg\"},{\"Order\":2,\"Remarks\":\"IMG_0503.JPG\"},{\"Order\":3,\"Remarks\":\"IMG_0493.JPG\"},{\"Order\":4,\"Remarks\":\"IMG_0497.JPG\"},{\"Order\":5,\"Remarks\":\"IMG_0489.JPG\"},{\"Order\":6,\"Remarks\":\"IMG_0479.JPG\"},{\"Order\":7,\"Remarks\":\"IMG_0476.JPG\"},{\"Order\":8,\"Remarks\":\"IMG_0483.JPG\"},{\"Order\":9,\"Remarks\":\"IMG_0486.JPG\"},{\"Order\":10,\"Remarks\":\"IMG_0501.JPG\"},{\"Order\":11,\"Remarks\":\"IMG_0502.JPG\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}