{"Id":541830,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7050273","MLSAGENTID":"NST582502004","MLSOFFICEID":"NST252632","ADDRESS":"300 Main Avenue","ACRES":2.481,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Concrete","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Fargo","CONTINGENCY":"None","COUNTY":"Cass","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":995500.0,"LASTPRICEDATE":"2026-04-14T20:20:06.887","LATITUDE":46.873221,"LENDEROWNED":"No","LISTDATE":"2026-04-08T05:00:00","LISTPRICE":995500.0,"LIVINGAREA":2557.0,"LONGITUDE":-96.783785,"MODIFICATIONTIMESTAMP":"2026-04-14T20:31:06.786","OFFICE_OFFICENAME":"Raboin Realty","PHOTOCOUNT":3,"POSTALCODE":"58103","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This beautifully designed 3-bedroom, 2-bathroom corner condo showcases exceptional craftsmanship and high-end finishes throughout. The kitchen is a true masterpiece, featuring rich alder cabinetry, a fluted wood island, and an expansive quartz island with waterfall detailing. Full-height cabinetry is paired with sleek LG white appliances, while a large walk-in pantry with built-in storage offers both style and functionality.\n\nThe primary suite includes a spacious walk-in closet with a custom organization system. The spa-like bathroom features a large tiled walk-in shower and a stunning vanity wall with double sinks and tile extending to the ceiling. Both bathrooms feature elegant Marazzi tile flooring.\n\nAnother standout feature is the flex room with moody green cabinetry, wet bar, and fridge—perfect for entertaining. The main living space is completed by a statement tile fireplace and incredible views of Island Park and downtown.\n\nResidents of The Arch Building enjoy premium amenities including a fitness center, community room, heated underground parking, car wash station, elevators, and secure access—all just steps from downtown Fargo’s best dining, shopping, and entertainment","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"469-Fargo","SEWER":"City Sewer/Connected","STATEORPROVINCE":"ND","STATUS":"Active","STATUSDATE":"2026-04-14T20:20:06.887","LASTSTATUS":"Active","STREETNAME":"Main","STREETNUMBER":"300","STREETSUFFIX":"Avenue","STYLE":"(CC) High Rise (4+ Levels)","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2023,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-04-14T20:20:06.885","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Kitchen\"},{\"Order\":2,\"Remarks\":\"Fireplace\"},{\"Order\":3,\"Remarks\":\"Primary\"}]","PHOTOORDER":"1,2,3","SOURCE":"MG_NST"}
{"ListingKey":"NST7880926","NST_AboveGradeSqFtTotal":"2557","AboveGradeFinishedArea":"2557","AccessibilityFeatures":"Accessible Elevator Installed","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Balcony,City View,Kitchen Center Island,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Panoramic View,Tile Floors,Washer/Dryer Hookup,Wet Bar,Walk-In Closet","Appliances":"Cooktop,Dishwasher,Exhaust Fan,Microwave,Refrigerator,Wall Oven","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationAmenities":"Car Wash,Elevator(s),Fire Sprinkler System,Lobby Entrance","AssociationFee":"279","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Controlled Access,Hazard Insurance,Lawn Care,Other,Maintenance Grounds,Professional Mgmt,Sewer,Snow Removal,Water","AssociationName":"Oxford Realty","AssociationPhone":"7013503366","AvailabilityDate":"2026-05-15T05:00:00Z","Basement":"Concrete","BasementYN":"True","NST_BathDesc":"3/4 Primary,Double Sink,Private Primary,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","NST_BuilderAssociationID":"Home Builders Association of Fargo-Moorhead","BuilderName":"Upscale Companies LLC","CumulativeDaysOnMarket":"6","City":"Fargo","NST_CompletionDate":"2026-05-01","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Cass","Directions":"Take 4th St. to Main Ave - 300 Block","DocumentsCount":"0","DaysOnMarket":"6","FireplaceFeatures":"Electric,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"2557","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Fargo","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"46.873221","LaundryFeatures":"Electric Dryer Hookup,Laundry Closet,Other,Washer Hookup","NST_LenderOwned":"No","Levels":"One","ListPrice":"995500","ListingContractDate":"2026-04-08T05:00:00Z","ListingId":"NST7050273","LivingArea":"2557","Longitude":"-96.783785","LotSizeArea":"2.481","LotSizeDimensions":"2.48","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"2557","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-14T15:18:05Z","ParcelNumber":"01875200200702","NST_SchoolDistrictNumber":"469","ParkingFeatures":"Underground","NST_PatioPorchType":"Covered","PhotosCount":"3","PhotosChangeTimestamp":"2026-04-14T20:20:06.885Z","PostalCity":"Fargo","PostalCode":"58103","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) High Rise (4+ Levels)","PropertyType":"Residential","PublicRemarks":"This beautifully designed 3-bedroom, 2-bathroom corner condo showcases exceptional craftsmanship and high-end finishes throughout. The kitchen is a true masterpiece, featuring rich alder cabinetry, a fluted wood island, and an expansive quartz island with waterfall detailing. Full-height cabinetry is paired with sleek LG white appliances, while a large walk-in pantry with built-in storage offers both style and functionality.\n\nThe primary suite includes a spacious walk-in closet with a custom organization system. The spa-like bathroom features a large tiled walk-in shower and a stunning vanity wall with double sinks and tile extending to the ceiling. Both bathrooms feature elegant Marazzi tile flooring.\n\nAnother standout feature is the flex room with moody green cabinetry, wet bar, and fridge—perfect for entertaining. The main living space is completed by a statement tile fireplace and incredible views of Island Park and downtown.\n\nResidents of The Arch Building enjoy premium amenities including a fitness center, community room, heated underground parking, car wash station, elevators, and secure access—all just steps from downtown Fargo’s best dining, shopping, and entertainment","Sewer":"City Sewer/Connected","NST_SharedRooms":"Amusement/Party Room,Community Room,Exercise Room","StandardStatus":"Active","StateOrProvince":"ND","StreetName":"Main","StreetNumber":"300","StreetNumberNumeric":"300","StreetSuffix":"Avenue","SubdivisionName":"Epic Gateway Add","TaxAnnualAmount":"8973","NST_TaxWithAssessments":"8973","TaxYear":"2025","BuildingAreaTotal":"2557","Township":"Fargo","UnitNumber":"702","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2023","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST517044","ListAgentMlsId":"NST582502004","ListOfficeMlsId":"NST252632","ListOfficeName":"Raboin Realty","ListOfficeKey":"NST1001374","ModificationTimestamp":"2026-04-14T20:31:06.786Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"Kitchen\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7880926\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7880926/ec433887-533d-40b5-9207-0023f4270440.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2026-04-14T20:19:17.386Z\",\"MediaKey\":\"NST121373904\"},{\"LongDescription\":\"Primary\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7880926\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7880926/4a129864-7be5-4c02-998d-f31367dceaca.jpeg\",\"ImageWidth\":853,\"ImageHeight\":1280,\"ImageSizeDescription\":\"853x1280\",\"MediaModificationTimestamp\":\"2026-04-14T20:19:17.399Z\",\"MediaKey\":\"NST121373966\"},{\"LongDescription\":\"Fireplace\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7880926\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7880926/39a45dbc-1943-4077-be01-0e440b69cb95.jpeg\",\"ImageWidth\":1024,\"ImageHeight\":1536,\"ImageSizeDescription\":\"1024x1536\",\"MediaModificationTimestamp\":\"2026-04-14T20:19:17.417Z\",\"MediaKey\":\"NST121373903\"}]","Media__LongDescription":"Kitchen","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ResourceRecordKey":"NST7880926","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7880926/ec433887-533d-40b5-9207-0023f4270440.jpeg","Media__ImageWidth":"1536","Media__ImageHeight":"1024","Media__ImageSizeDescription":"1536x1024","Media__MediaModificationTimestamp":"4/14/2026 8:19:17 PM","Media__MediaKey":"NST121373904","DocumentsChangeTimestamp":"2026-04-14T20:19:06.522Z","Rooms":"[{\"NST_RoomSortOrder\":7,\"RoomType\":\"Bar/Wet Bar Room\",\"RoomKey\":\"NST116092580\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":8,\"RoomType\":\"Bathroom\",\"RoomKey\":\"NST116092581\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":17,\"RoomType\":\"Bonus Room\",\"RoomKey\":\"NST116092590\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":9,\"RoomType\":\"Deck\",\"RoomKey\":\"NST116092582\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST116092575\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST116092577\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":10,\"RoomType\":\"Foyer\",\"RoomKey\":\"NST116092583\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":16,\"RoomType\":\"Garage\",\"RoomKey\":\"NST116092589\",\"RoomLevel\":\"Lower\"},{\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST116092576\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":12,\"RoomType\":\"Laundry\",\"RoomKey\":\"NST116092585\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomKey\":\"NST116092574\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":14,\"RoomType\":\"Primary Bathroom\",\"RoomKey\":\"NST116092587\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":13,\"RoomType\":\"Pantry (Walk-In)\",\"RoomKey\":\"NST116092586\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST116092578\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST116092579\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":11,\"RoomType\":\"Utility Room\",\"RoomKey\":\"NST116092584\",\"RoomLevel\":\"Main\"},{\"NST_RoomSortOrder\":15,\"RoomType\":\"Walk-In Closet\",\"RoomKey\":\"NST116092588\",\"RoomLevel\":\"Main\"}]","Rooms__NST_RoomSortOrder":"7","Rooms__RoomType":"Bar/Wet Bar Room","Rooms__RoomKey":"NST116092580","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Kitchen\"},{\"Order\":2,\"Remarks\":\"Fireplace\"},{\"Order\":3,\"Remarks\":\"Primary\"}]","PhotoOrder":"1,2,3","CustomVTourURL":""}