Beautiful fully leased investment with a 1,350 SF retail/office space for YOUR Business on Historic Downtown Walking District. Tenants are Riverside Sweets (1999) on 1st floor and lower level and two newer renovated apartments which have stayed occupied since 1999. The 1,350 sf has nice open wrap around deck facing Kister Park & you can watch the fireworks overlooking the MO River/Katie Trail/Frontier Park, 3 walls of windows, private alley access to Main, 3 egress doors, 2 restrooms. Close to County/City municipal buildings, OPO Tech Center, Hospital and 30+/- restaurants. Great spot on the Street! Location: Downtown, High Traffic
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "17072" +post_author: 1 +"ListingKey": "MIS96760996" +"ListingId": "MIS25026827" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-29T14:44:47Z" +"RFModificationTimestamp": "2025-05-27T06:39:34.669194+00:00" +"ListPrice": 1325000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.1 +"LivingArea": 5462.0 +"BuildingAreaTotal": 5462.0 +"City": "St Charles" +"PostalCode": "63301" +"UnparsedAddress": "416 S Main Street, St Charles, Missouri 63301" +"Coordinates": array:2 [ 0 => -90.48266 1 => 38.778152 ] +"Latitude": 38.778152 +"Longitude": -90.48266 +"YearBuilt": 1870 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brenda S Lowder" +"ListOfficeName": "Thomas Realty Group LLC" +"ListAgentMlsId": "MISCBRLOWDE" +"ListOfficeMlsId": "MISTHRG01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Beautiful fully leased investment with a 1,350 SF retail/office space for YOUR Business on Historic Downtown Walking District. Tenants are Riverside Sweets (1999) on 1st floor and lower level and two newer renovated apartments which have stayed occupied since 1999. The 1,350 sf has nice open wrap around deck facing Kister Park & you can watch the fireworks overlooking the MO River/Katie Trail/Frontier Park, 3 walls of windows, private alley access to Main, 3 egress doors, 2 restrooms. Close to County/City municipal buildings, OPO Tech Center, Hospital and 30+/- restaurants. Great spot on the Street! Location: Downtown, High Traffic" +"AboveGradeFinishedArea": 5462 +"AboveGradeFinishedAreaSource": "Owner" +"AboveGradeFinishedAreaUnits": "Square Feet" +"BuildingAreaUnits": "Square Feet" +"BuildingFeatures": array:1 [ 0 => "Bathrooms" ] +"BuyerOfficeAOR": "St. Charles County Association of REALTORS" +"ConstructionMaterials": array:3 [ 0 => "Brick" 1 => "Other" 2 => "Wood Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Charles" +"CreationDate": "2025-04-24T17:37:47.544434+00:00" +"CrossStreet": "Tompkins" +"CumulativeDaysOnMarket": 175 +"CurrentUse": array:2 [ 0 => "Office" 1 => "Services" ] +"DaysOnMarket": 79 +"Disclosures": array:2 [ 0 => "Unknown" 1 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-04-29T14:44:47Z" +"Electric": "220 Volts" +"ExistingLeaseType": array:1 [ 0 => "NNN" ] +"Heating": array:3 [ 0 => "Electric" 1 => "Natural Gas" 2 => "Forced Air" ] +"Inclusions": "Building, Land" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "MIS26212" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "MIS1549" +"ListOfficePhone": "314-2981234" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Owner" +"LotSizeAcres": 0.1 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 4356 +"MLSAreaMajor": "403 - St. Charles" +"MajorChangeTimestamp": "2025-04-24T17:34:00Z" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"OffMarketDate": "2025-12-31" +"OnMarketDate": "2025-04-24" +"OperatingExpenseIncludes": array:6 [ 0 => "Maintenance Grounds" 1 => "Utilities" 2 => "Maintenance Structure" 3 => "Insurance" 4 => "Taxes" 5 => "Water/Sewer" ] +"OriginalEntryTimestamp": "2025-04-24T17:32:56Z" +"OriginalListPrice": 1325000 +"ParcelNumber": "6-014A-B015-00-0005.1000000" +"ParkingFeatures": array:3 [ 0 => "Lighted" 1 => "Open" 2 => "Parking Lot" ] +"PhotosChangeTimestamp": "2025-04-29T14:44:47Z" +"PhotosCount": 8 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PossibleUse": "Professional/Office,Retail" +"PropertyCondition": array:1 [ 0 => "Updated/Remodeled" ] +"RoadFrontageType": array:1 [ 0 => "City Street" ] +"Roof": array:2 [ 0 => "Asphalt" 1 => "Shingle" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Call Listing Agent" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-04-24T17:32:56Z" +"StoriesTotal": "3" +"StreetDirPrefix": "S" +"StreetName": "Main" +"StreetNumber": "416" +"StreetNumberNumeric": "416" +"StreetSuffix": "Street" +"SubdivisionName": "Main St." +"TaxAnnualAmount": "14002" +"TaxYear": "2023" +"Township": "St. Charles" +"Utilities": array:5 [ 0 => "Cable Available" 1 => "Electricity Available" 2 => "Water Available" 3 => "Sewer Available" 4 => "Phone Available" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_price_per_sf": "242.59" +"MAR_Age": "155" +"MAR_Listing_Agent_Nickname": "Brenda" +"MAR_MISC": "2+ Lavatories" +"MAR_Office_Area_Code": "314" +"MAR_LOCA": "Downtown,High Traffic" +"MAR_PROP": "Retail" +"MAR_Building_Square_Footage": "5462.00" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "Thomas Realty Group LLC" +"MIS_OpenHousePublicCount": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"MIS_PropertySubTypeAdditional": "Retail/Shopping Center" +"MIS_SaleConsideredYN": "1" +"MIS_CurrentPrice": "1325000.00" +"MIS_RetailArea": "1350.00" +"MIS_OpenHouseCount": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96760996')" +"MIS_RoomCount": "0" +"MIS_UnitCount": "0" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"provider_name": "Stellar" +"Media": array:8 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6810579a045efc5c7207922b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/d77c414cdf308b49b9beb524afb8fb07.webp" "MediaSize" => 144283 "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.469Z" "ImageWidth" => 940 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-d77c414cdf308b49b9beb524afb8fb07.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "940x768" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6810579a045efc5c7207922c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/bc857abb871695467209c48d38617f41.webp" "MediaSize" => 43524 "LongDescription" => "Suite C" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.367Z" "ImageWidth" => 554 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-bc857abb871695467209c48d38617f41.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "554x768" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6810579a045efc5c7207922d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/44d93e55329c6cf08f247833a75f213f.webp" "MediaSize" => 40271 "LongDescription" => "Suite C" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.401Z" "ImageWidth" => 515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-44d93e55329c6cf08f247833a75f213f.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "515x768" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6810579a045efc5c7207922e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/8012736041d6ee1f821380fed85689a7.webp" "MediaSize" => 62376 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.437Z" "ImageWidth" => 1003 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-8012736041d6ee1f821380fed85689a7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1003x768" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6810579a045efc5c7207922f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/02dd92e51edeb641787a5849090f8153.webp" "MediaSize" => 78152 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.391Z" "ImageWidth" => 971 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-02dd92e51edeb641787a5849090f8153.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "971x768" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6810579a045efc5c72079230" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/d4d27306d138517266f15bdb193301eb.webp" "MediaSize" => 77366 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.367Z" "ImageWidth" => 1000 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-d4d27306d138517266f15bdb193301eb.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1000x768" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6810579a045efc5c72079231" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/0d82265768fbf71f36d39c904cdbbd23.webp" "MediaSize" => 56022 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.379Z" "ImageWidth" => 1004 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-0d82265768fbf71f36d39c904cdbbd23.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1004x768" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6810579a045efc5c72079232" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/30bb037fa8e3b18c53af1c9fe973780b.webp" "MediaSize" => 58638 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.383Z" "ImageWidth" => 986 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-30bb037fa8e3b18c53af1c9fe973780b.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "986x768" ] ] +"ID": "17072" }
array:1 [ "RF Query: /Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS96760996'/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS96760996'&$expand=Media/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS96760996'/Property?$select=ALL&$top=20&$filter=((StandardStatus in ('Active','Active Under Contract') and PropertyType in ('Residential','Residential Income','Commercial Sale','Land') and City in ('Eureka','Ballwin','Bridgeton','Maplewood','Edmundson','Uplands Park','Richmond Heights','Clayton','Clarkson Valley','LeMay','St Charles','Rosewood Heights','Ladue','Pacific','Brentwood','Rock Hill','Pasadena Park','Bella Villa','Town and Country','Woodson Terrace','Black Jack','Oakland','Oakville','Flordell Hills','St Louis','Webster Groves','Marlborough','Spanish Lake','Baldwin','Marquette Heigh','Riverview','Crystal Lake Park','Frontenac','Hillsdale','Calverton Park','Glasg','Greendale','Creve Coeur','Bellefontaine Nghbrs','Cool Valley','Winchester','Velda Ci','Florissant','Crestwood','Pasadena Hills','Warson Woods','Hanley Hills','Moline Acr','Glencoe','Kirkwood','Olivette','Bel Ridge','Pagedale','Wildwood','Unincorporated','Shrewsbury','Bel-nor','Charlack','Chesterfield','St John','Normandy','Hancock','Ellis Grove','Hazelwood','St Albans','Oakville','Brighton','Twin Oaks','St Ann','Ferguson','Mehlville','Northwoods','Bellerive','Manchester','Lakeshire','Breckenridge Hills','Velda Village Hills','Pine Lawn','Valley Park','Affton','Earth City','Dellwood','Hanover Park','Maryland Heights','Sunset Hills','Huntleigh','Green Park','Velda Village','Grover','Fenton','Glendale','Wellston','St Libory','Berkeley','High Ridge','Concord Village','Sappington','Berdell Hills','University City','Overland','Westwood','Vinita Park','Crystal Lake','Ellisville','Des Peres','Jennings','Sycamore Hills','Cedar Hill')) or ListAgentMlsId in ('MEATHERT','SMWILSON','AVELAZQU','MARTCARR','SJYOUNG1','LABENNET','FRANMASE','ABENOIST','MISULJAK','JOLUZECK','DANEJOH','SCOAKLEY','ALEXERBS','JFECHTER','JASAHURI')) and ListingKey eq 'MIS96760996'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2834 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "17072" +post_author: 1 +"ListingKey": "MIS96760996" +"ListingId": "MIS25026827" +"PropertyType": "Commercial Sale" +"PropertySubType": "Retail" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-29T14:44:47Z" +"RFModificationTimestamp": "2025-05-27T06:39:34.669194+00:00" +"ListPrice": 1325000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0.1 +"LivingArea": 5462.0 +"BuildingAreaTotal": 5462.0 +"City": "St Charles" +"PostalCode": "63301" +"UnparsedAddress": "416 S Main Street, St Charles, Missouri 63301" +"Coordinates": array:2 [ 0 => -90.48266 1 => 38.778152 ] +"Latitude": 38.778152 +"Longitude": -90.48266 +"YearBuilt": 1870 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Brenda S Lowder" +"ListOfficeName": "Thomas Realty Group LLC" +"ListAgentMlsId": "MISCBRLOWDE" +"ListOfficeMlsId": "MISTHRG01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Beautiful fully leased investment with a 1,350 SF retail/office space for YOUR Business on Historic Downtown Walking District. Tenants are Riverside Sweets (1999) on 1st floor and lower level and two newer renovated apartments which have stayed occupied since 1999. The 1,350 sf has nice open wrap around deck facing Kister Park & you can watch the fireworks overlooking the MO River/Katie Trail/Frontier Park, 3 walls of windows, private alley access to Main, 3 egress doors, 2 restrooms. Close to County/City municipal buildings, OPO Tech Center, Hospital and 30+/- restaurants. Great spot on the Street! Location: Downtown, High Traffic" +"AboveGradeFinishedArea": 5462 +"AboveGradeFinishedAreaSource": "Owner" +"AboveGradeFinishedAreaUnits": "Square Feet" +"BuildingAreaUnits": "Square Feet" +"BuildingFeatures": array:1 [ 0 => "Bathrooms" ] +"BuyerOfficeAOR": "St. Charles County Association of REALTORS" +"ConstructionMaterials": array:3 [ 0 => "Brick" 1 => "Other" 2 => "Wood Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Charles" +"CreationDate": "2025-04-24T17:37:47.544434+00:00" +"CrossStreet": "Tompkins" +"CumulativeDaysOnMarket": 175 +"CurrentUse": array:2 [ 0 => "Office" 1 => "Services" ] +"DaysOnMarket": 79 +"Disclosures": array:2 [ 0 => "Unknown" 1 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-04-29T14:44:47Z" +"Electric": "220 Volts" +"ExistingLeaseType": array:1 [ 0 => "NNN" ] +"Heating": array:3 [ 0 => "Electric" 1 => "Natural Gas" 2 => "Forced Air" ] +"Inclusions": "Building, Land" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "MIS26212" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "MIS1549" +"ListOfficePhone": "314-2981234" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Owner" +"LotSizeAcres": 0.1 +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 4356 +"MLSAreaMajor": "403 - St. Charles" +"MajorChangeTimestamp": "2025-04-24T17:34:00Z" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"OffMarketDate": "2025-12-31" +"OnMarketDate": "2025-04-24" +"OperatingExpenseIncludes": array:6 [ 0 => "Maintenance Grounds" 1 => "Utilities" 2 => "Maintenance Structure" 3 => "Insurance" 4 => "Taxes" 5 => "Water/Sewer" ] +"OriginalEntryTimestamp": "2025-04-24T17:32:56Z" +"OriginalListPrice": 1325000 +"ParcelNumber": "6-014A-B015-00-0005.1000000" +"ParkingFeatures": array:3 [ 0 => "Lighted" 1 => "Open" 2 => "Parking Lot" ] +"PhotosChangeTimestamp": "2025-04-29T14:44:47Z" +"PhotosCount": 8 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PossibleUse": "Professional/Office,Retail" +"PropertyCondition": array:1 [ 0 => "Updated/Remodeled" ] +"RoadFrontageType": array:1 [ 0 => "City Street" ] +"Roof": array:2 [ 0 => "Asphalt" 1 => "Shingle" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Call Listing Agent" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-04-24T17:32:56Z" +"StoriesTotal": "3" +"StreetDirPrefix": "S" +"StreetName": "Main" +"StreetNumber": "416" +"StreetNumberNumeric": "416" +"StreetSuffix": "Street" +"SubdivisionName": "Main St." +"TaxAnnualAmount": "14002" +"TaxYear": "2023" +"Township": "St. Charles" +"Utilities": array:5 [ 0 => "Cable Available" 1 => "Electricity Available" 2 => "Water Available" 3 => "Sewer Available" 4 => "Phone Available" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_price_per_sf": "242.59" +"MAR_Age": "155" +"MAR_Listing_Agent_Nickname": "Brenda" +"MAR_MISC": "2+ Lavatories" +"MAR_Office_Area_Code": "314" +"MAR_LOCA": "Downtown,High Traffic" +"MAR_PROP": "Retail" +"MAR_Building_Square_Footage": "5462.00" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "Thomas Realty Group LLC" +"MIS_OpenHousePublicCount": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"MIS_PropertySubTypeAdditional": "Retail/Shopping Center" +"MIS_SaleConsideredYN": "1" +"MIS_CurrentPrice": "1325000.00" +"MIS_RetailArea": "1350.00" +"MIS_OpenHouseCount": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96760996')" +"MIS_RoomCount": "0" +"MIS_UnitCount": "0" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"provider_name": "Stellar" +"Media": array:8 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "6810579a045efc5c7207922b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/d77c414cdf308b49b9beb524afb8fb07.webp" "MediaSize" => 144283 "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.469Z" "ImageWidth" => 940 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-d77c414cdf308b49b9beb524afb8fb07.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "940x768" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6810579a045efc5c7207922c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/bc857abb871695467209c48d38617f41.webp" "MediaSize" => 43524 "LongDescription" => "Suite C" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.367Z" "ImageWidth" => 554 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-bc857abb871695467209c48d38617f41.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "554x768" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6810579a045efc5c7207922d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/44d93e55329c6cf08f247833a75f213f.webp" "MediaSize" => 40271 "LongDescription" => "Suite C" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.401Z" "ImageWidth" => 515 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-44d93e55329c6cf08f247833a75f213f.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "515x768" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6810579a045efc5c7207922e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/8012736041d6ee1f821380fed85689a7.webp" "MediaSize" => 62376 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.437Z" "ImageWidth" => 1003 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-8012736041d6ee1f821380fed85689a7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1003x768" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6810579a045efc5c7207922f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/02dd92e51edeb641787a5849090f8153.webp" "MediaSize" => 78152 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.391Z" "ImageWidth" => 971 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-02dd92e51edeb641787a5849090f8153.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "971x768" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6810579a045efc5c72079230" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/d4d27306d138517266f15bdb193301eb.webp" "MediaSize" => 77366 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.367Z" "ImageWidth" => 1000 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-d4d27306d138517266f15bdb193301eb.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1000x768" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6810579a045efc5c72079231" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/0d82265768fbf71f36d39c904cdbbd23.webp" "MediaSize" => 56022 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.379Z" "ImageWidth" => 1004 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-0d82265768fbf71f36d39c904cdbbd23.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1004x768" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6810579a045efc5c72079232" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/30bb037fa8e3b18c53af1c9fe973780b.webp" "MediaSize" => 58638 "LongDescription" => "Suite D" "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:37:46.383Z" "ImageWidth" => 986 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96760996/thumbnail-30bb037fa8e3b18c53af1c9fe973780b.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "986x768" ] ] +"ID": "17072" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.21 seconds" ] ]