{"Id":1404317,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6773189","MLSAGENTID":"NST502000910","MLSOFFICEID":"NST21589","ADDRESS":"3540 Fremont Avenue S","ACRES":0.12,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3,"CITY":"Minneapolis","CONTINGENCY":"None","COUNTY":"Hennepin","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding,Wood Siding","FORECLOSURE":"No","LASTPRICE":275000.0,"LASTPRICEDATE":"2025-09-04T21:12:03.617","LATITUDE":44.938189,"LENDEROWNED":"No","LISTDATE":"2025-09-04T05:00:00","LISTPRICE":275000.0,"LIVINGAREA":1643.0,"LONGITUDE":-93.296207,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Some Trees","MODIFICATIONTIMESTAMP":"2025-09-05T10:06:12.009","NEIGHBORHOOD":"South Uptown","OFFICE_OFFICENAME":"Engel & Volkers Minneapolis Downtown","PHOTOCOUNT":12,"POSTALCODE":"55408","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Major Renovation Opportunity in Superb Uptown location. New boiler fall of 2024. Third story unfinished - great potential for adding additional living spaces. \nCash terms only.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"1-Minneapolis","SCHOOLDISTRICTPHONE":"612-668-0000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-04T21:12:03.617","LASTSTATUS":"Active","STREETDIRSUFFIX":"S","STREETNAME":"Fremont","STREETNUMBER":"3540","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1913,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-05T02:47:05.223","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front of Home - East Exposure\"},{\"Order\":2,\"Remarks\":\"Living Room area\"},{\"Order\":3,\"Remarks\":\"Main Floor East Exposure Sun Room\"},{\"Order\":4,\"Remarks\":\"Formal DR\"},{\"Order\":5,\"Remarks\":\"Kitchen Area\"},{\"Order\":6,\"Remarks\":\"Kitchen Area\"},{\"Order\":7,\"Remarks\":\"Upper Staircase\"},{\"Order\":8,\"Remarks\":\"Upper Staircase\"},{\"Order\":9,\"Remarks\":\"Bedroom #1\"},{\"Order\":10,\"Remarks\":\"Bedroom #2\"},{\"Order\":11,\"Remarks\":\"Bedroom #3\"},{\"Order\":12,\"Remarks\":\"Upper Level West Exposure Sunroom\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7788850","LotSizeArea":"0.12","NST_AgeOfProperty":"112","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Deck,Hardwood Floors,Porch,Sun Room,Tile Floors,Washer/Dryer Hookup","Appliances":"Gas Water Heater,Range,Refrigerator","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full,Unfinished","BasementYN":"True","NST_BathDesc":"Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","CarportSpaces":"0","City":"Minneapolis","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Hennepin","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"West 36th St to Fremont Av S - Go north to property","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Service - 60 Amp","ConstructionMaterials":"Vinyl Siding,Wood Siding","Fencing":"Partial","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"36 x 24","FoundationArea":"895","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","NST_Fuel":"Natural Gas","ParkingFeatures":"None","AccessibilityFeatures":"None","Heating":"Boiler,Hot Water,Radiator(s)","OriginalEntryTimestamp":"2025-09-04T21:09:01Z","NST_InternetOptions":"Cable,DSL","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-05","Latitude":"44.938189","NST_LenderOwned":"No","ListAgentKey":"NST49132","ListAgentMlsId":"NST502000910","ListingContractDate":"2025-09-04T05:00:00Z","ListOfficeKey":"NST21589","ListOfficeName":"Engel & Volkers Minneapolis Downtown","ListOfficeMlsId":"NST21589","ListPrice":"275000","LivingArea":"1643","NST_LockBoxSource":"MAAR","Longitude":"-93.296207","LotFeatures":"Public Transit (w/in 6 blks),Some Trees","LotSizeDimensions":"42 x 129","LotSizeSquareFeet":"5227.2","LotSizeUnits":"Acres","ListingId":"NST6773189","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"South Uptown","NST_OfficeBoard":"MAAR","ParcelNumber":"0402824420168","GarageSpaces":"0","NST_PatioPorchType":"Deck,Front Porch","PhotosCount":"12","PoolFeatures":"None","PostalCity":"Minneapolis","PostalCode":"55408","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PublicRemarks":"Major Renovation Opportunity in Superb Uptown location. New boiler fall of 2024. Third story unfinished - great potential for adding additional living spaces. \nCash terms only.","PublicSurveyRange":"24","PublicSurveySection":"04","PublicSurveyTownship":"28","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt,Pitched","RoomType":"Living Room,Dining Room,Kitchen,Sun Room,Bedroom 1,Bedroom 2,Bedroom 3,Unfinished","NST_AboveGradeSqFtTotal":"1643.0000","NST_BelowGradeSqFtTotal":"895.0000","NST_MainLevelFinishedArea":"959.0000","BuildingAreaTotal":"2538","HighSchoolDistrict":"Minneapolis","NST_SchoolDistrictNumber":"1","NST_SchoolDistrictPhone":"612-668-0000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1643","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"More Than 2 Stories","StreetDirSuffix":"S","StreetName":"Fremont","StreetNumber":"3540","StreetNumberNumeric":"3540","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Remingtons 2nd Add","NST_TaxWithAssessments":"6482.0000","TaxYear":"2025","TaxAnnualAmount":"6482","WaterSource":"City Water/Connected","YearBuilt":"1913","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-05T10:06:12.009Z","PhotosChangeTimestamp":"2025-09-05T02:47:05.223Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7788850\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front of Home - East Exposure\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/a213de4b-75fa-4521-a48e-8aaeaed67499.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.717Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf7e\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Living Room area\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/3f9e5a63-0f91-4283-bd0a-6fe908f788e1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.698Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf7f\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Main Floor East Exposure Sun Room\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/f92619fc-9ef0-4844-9cee-368c8fd89477.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.712Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf80\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Formal DR\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/cbe5f356-ba7d-4df9-a4b2-e0156e8655d2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.723Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf81\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Kitchen Area\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/826b0b26-45a3-4fbf-9f0c-dc5655894c10.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.698Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf82\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Kitchen Area\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/949a839f-5fcb-49d8-8ca9-4b71220f9df2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.7Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf83\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Upper Staircase\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/a3539f36-ffce-431e-8df9-0fa2ee331e34.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.698Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf84\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Upper Staircase\",\"ImageWidth\":1362,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1362x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/6214dd3f-0f0d-4b45-833b-f9641fbac25b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.753Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf85\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Bedroom #1\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/0cf55ebf-d6f0-4f85-b034-54a137396377.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.732Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf86\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Bedroom #2\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/6b5b2bba-de91-4da4-8447-eeaa79e5697d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.741Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf87\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Bedroom #3\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/a761ba3a-6b15-4040-b9e9-ddb9a910eaa4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.736Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf88\"},{\"ResourceRecordKey\":\"NST7788850\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Upper Level West Exposure Sunroom\",\"ImageWidth\":2048,\"ImageHeight\":1362,\"ImageSizeDescription\":\"2048x1362\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7788850/2a7f4713-6607-41f2-95d6-860758e0abd4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T02:46:23.813Z\",\"MediaKey\":\"68ba4eff5b792a18f9b7cf89\"}]","Rooms":"[{\"RoomKey\":\"NST115582311\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115582312\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115582313\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115582314\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115582315\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Second\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115582316\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Second\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115582317\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Second\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115582318\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Second\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115582319\",\"RoomType\":\"Unfinished\",\"RoomLevel\":\"Third\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front of Home - East Exposure\"},{\"Order\":2,\"Remarks\":\"Living Room area\"},{\"Order\":3,\"Remarks\":\"Main Floor East Exposure Sun Room\"},{\"Order\":4,\"Remarks\":\"Formal DR\"},{\"Order\":5,\"Remarks\":\"Kitchen Area\"},{\"Order\":6,\"Remarks\":\"Kitchen Area\"},{\"Order\":7,\"Remarks\":\"Upper Staircase\"},{\"Order\":8,\"Remarks\":\"Upper Staircase\"},{\"Order\":9,\"Remarks\":\"Bedroom #1\"},{\"Order\":10,\"Remarks\":\"Bedroom #2\"},{\"Order\":11,\"Remarks\":\"Bedroom #3\"},{\"Order\":12,\"Remarks\":\"Upper Level West Exposure Sunroom\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}