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 'MIS96926852'/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 'MIS96926852'&$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 'MIS96926852'/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 'MIS96926852'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2829
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2831
+post_id: "21582"
+post_author: 1
+"ListingKey": "MIS96926852"
+"ListingId": "25030274"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Business"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-06-06T15:36:38Z"
+"RFModificationTimestamp": "2025-06-06T15:40:16.173884+00:00"
+"ListPrice": 175000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0.37
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "St Charles"
+"PostalCode": "63301"
+"UnparsedAddress": "800 1st Capitol Drive, St Charles, Missouri 63301"
+"Coordinates": array:2 [
0 => -90.491449
1 => 38.782885
]
+"Latitude": 38.782885
+"Longitude": -90.491449
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Troy Robertson"
+"ListOfficeName": "Coldwell Banker Realty - Gundaker"
+"ListAgentMlsId": "TROBERTS"
+"ListOfficeMlsId": "CBG11"
+"OriginatingSystemName": "MARIS"
+"PublicRemarks": "Prime Commercial lot on 1st Capitol! Zoned General Commercial. Great visibility with 118 ft of frontage. Vacant. Approx .37 acres in total. Lots of end user possibilities. Located between PNC Bank and Animal Hospital. Close to Historic Main Street and Lindenwood University. Rare opportunity to build/design on visible lot in heart of St.Charles. Location: High Traffic"
+"Appliances": array:1 [
0 => "Other"
]
+"BuyerOfficeAOR": "St. Louis Association of REALTORS"
+"CoBuyerAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentFullName": "Darby Seymour"
+"CoListAgentKey": "12608"
+"CoListAgentMlsId": "DSEYMOUR"
+"CoListOfficeKey": "822"
+"CoListOfficeMlsId": "CBG11"
+"CoListOfficeName": "Coldwell Banker Realty - Gunda"
+"CoListOfficePhone": "-3949300"
+"ConstructionMaterials": array:1 [
0 => "Other"
]
+"Cooling": array:1 [
0 => "None"
]
+"CountyOrParish": "St. Charles"
+"CreationDate": "2025-06-06T15:39:59.184677+00:00"
+"Directions": "GPS Friendly"
+"Disclosures": array:3 [
0 => "Unknown"
1 => "Flood Plain No"
2 => "Year Built Unknown"
]
+"DocumentsChangeTimestamp": "2025-06-06T15:36:38Z"
+"Electric": "Single Phase"
+"Inclusions": "Land"
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"ListAOR": "St. Charles County Association of REALTORS"
+"ListAgentKey": "7098"
+"ListOfficeAOR": "St. Louis Association of REALTORS"
+"ListOfficeKey": "822"
+"ListOfficePhone": "636-3949300"
+"ListingService": "Full Service"
+"ListingTerms": "Cash,Conventional"
+"LotSizeAcres": 0.3664
+"LotSizeSource": "Public Records"
+"LotSizeSquareFeet": 15960
+"MLSAreaMajor": "403 - St. Charles"
+"MajorChangeTimestamp": "2025-05-08T23:10:00Z"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OffMarketDate": "2025-05-08"
+"OnMarketDate": "2025-06-06"
+"ParcelNumber": "6-009D-B225-00-0011.0000000"
+"ParkingFeatures": array:1 [
0 => "None"
]
+"PhotosChangeTimestamp": "2025-06-06T15:36:38Z"
+"PhotosCount": 5
+"Possession": array:1 [
0 => "Close Of Escrow"
]
+"PostalCodePlus4": "2732"
+"RoadFrontageType": array:1 [
0 => "City Street"
]
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"ShowingRequirements": array:1 [
0 => "Call Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "Standard"
]
+"StateOrProvince": "MO"
+"StatusChangeTimestamp": "2025-05-08T23:10:00Z"
+"StreetName": "1st Capitol"
+"StreetNumber": "800"
+"StreetNumberNumeric": "800"
+"StreetSuffix": "Drive"
+"SubdivisionName": "Flair Forest 04"
+"TaxAnnualAmount": "2901"
+"TaxYear": "2024"
+"Township": "St. Charles"
+"Utilities": array:4 [
0 => "Electricity Available"
1 => "Natural Gas Available"
2 => "Water Available"
3 => "Sewer Available"
]
+"WaterSource": array:1 [
0 => "Public"
]
+"MIS_PoolYN": "0"
+"MIS_Section": "ST CHARLES"
+"MIS_RoomCount": "0"
+"MIS_UnitCount": "0"
+"MIS_TaxExemptYN": "0"
+"MIS_CurrentPrice": "175000.00"
+"MIS_OpenHouseCount": "0"
+"MIS_PreviousStatus": "Incomplete"
+"MIS_TransactionType": "Sale"
+"MIS_ActiveOpenHouseCount": "0"
+"MIS_OpenHousePublicCount": "0"
+"MIS_MainAndUpperLevelBedrooms": "0"
+"MIS_PropertySubTypeAdditional": "Commercial Lot"
+"MIS_MainAndUpperLevelBathrooms": "0"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96926852')"
+"provider_name": "MARIS"
+"short_address": "St Charles, Missouri 63301, USA"
+"Media": array:5 [
0 => array:12 [
"Order" => 0
"MediaKey" => "68430acd8a15a02057caa460"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/71daacff6c6ab250a032d4580280cd1f.webp"
"MediaSize" => 196116
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/thumbnail-71daacff6c6ab250a032d4580280cd1f.webp"
"ImageWidth" => 1024
"ImageHeight" => 768
"MediaCategory" => "Photo"
"LongDescription" => "Bird's eye view"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-06-06T15:35:41.484Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "68430acd8a15a02057caa461"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/2ba56490ba6236811fe5b8a572ab6718.webp"
"MediaSize" => 200347
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/thumbnail-2ba56490ba6236811fe5b8a572ab6718.webp"
"ImageWidth" => 1024
"ImageHeight" => 768
"MediaCategory" => "Photo"
"LongDescription" => "Bird's eye view"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-06-06T15:35:41.487Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "68430acd8a15a02057caa462"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/d929424bb1531fe634785ad60c918f5d.webp"
"MediaSize" => 230731
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/thumbnail-d929424bb1531fe634785ad60c918f5d.webp"
"ImageWidth" => 1024
"ImageHeight" => 768
"MediaCategory" => "Photo"
"LongDescription" => "Aerial view"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-06-06T15:35:41.564Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "68430acd8a15a02057caa463"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/42fa88cc0fbab13135112818abe66086.webp"
"MediaSize" => 215980
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/thumbnail-42fa88cc0fbab13135112818abe66086.webp"
"ImageWidth" => 1024
"ImageHeight" => 768
"MediaCategory" => "Photo"
"LongDescription" => "View of subject property"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-06-06T15:35:41.478Z"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "68430acd8a15a02057caa464"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/c98007d224ff0a3759ef7605f700a86d.webp"
"MediaSize" => 150634
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS96926852/thumbnail-c98007d224ff0a3759ef7605f700a86d.webp"
"ImageWidth" => 1024
"ImageHeight" => 768
"MediaCategory" => "Photo"
"ImageSizeDescription" => "1024x768"
"MediaModificationTimestamp" => "2025-06-06T15:35:41.421Z"
]
]
+"ID": "21582"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]
