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 'MIS95342208'/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 'MIS95342208'&$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 'MIS95342208'/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 'MIS95342208'&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2833
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835
+post_id: "16552"
+post_author: 1
+"ListingKey": "MIS95342208"
+"ListingId": "MIS24071321"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Retail"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2025-04-29T00:54:31Z"
+"RFModificationTimestamp": "2025-05-27T06:40:35.166695+00:00"
+"ListPrice": 350000.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 5081.0
+"BuildingAreaTotal": 0
+"City": "St Louis"
+"PostalCode": "63114"
+"UnparsedAddress": "8814 St. Charles Rock Road, St Louis, Missouri 63114"
+"Coordinates": array:2 [
0 => -90.348584
1 => 38.709334
]
+"Latitude": 38.709334
+"Longitude": -90.348584
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Benjamin L Gruender"
+"ListOfficeName": "Salient Realty Group, LLC"
+"ListAgentMlsId": "MISBGRUENDE"
+"ListOfficeMlsId": "MISSLRG01"
+"OriginatingSystemName": "MARIS"
+"PublicRemarks": """
8814 St. Charles Rock Road offers a prime opportunity to both owner-users and investors. The property consists of two (2) apartments on the 2nd floor and a retail storefront on the 1st floor. The storefront offers owner-users the ability to move their business into a building with rental income from the fully leased apartments. Investors can fill the vacant space and add a fantastic building to their portfolio. Existing rents are well below market which offers further upside.\r\n
\r\n
+/- 5,081 SF Building with 3 Units\r\n
2 Apartments & 1 Storefront\r\n
Perfect for an Owner-User or Investor\r\n
Significant Value Add by Raising Rents to Market\r\n
Prime Location in St. John\r\n
Charming Backyard Balcony\r\n
Abundant Off Street Parking Location: City, High Traffic
"""
+"AboveGradeFinishedArea": 5081
+"AboveGradeFinishedAreaSource": "Assessor"
+"AboveGradeFinishedAreaUnits": "Square Feet"
+"BusinessType": "Restaurant"
+"BuyerOfficeAOR": "St. Louis Association of REALTORS"
+"CoBuyerAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentAOR": "St. Louis Association of REALTORS"
+"CoListAgentFullName": "Garen F Lafser"
+"CoListAgentKey": "MIS38719055"
+"CoListAgentMlsId": "MISGALAFSER"
+"CoListOfficeKey": "MIS55486798"
+"CoListOfficeMlsId": "MISSLRG01"
+"CoListOfficeName": "Salient Realty Group, LLC"
+"CoListOfficePhone": "314-374-3687"
+"ConstructionMaterials": array:1 [
0 => "Brick"
]
+"Cooling": array:2 [
0 => "Central Air"
1 => "Electric"
]
+"CountyOrParish": "St. Louis"
+"CreationDate": "2024-11-14T18:15:29.534725+00:00"
+"CumulativeDaysOnMarket": 159
+"CurrentUse": array:4 [
0 => "Mixed Use"
1 => "Office"
2 => "Residential"
3 => "Retail"
]
+"DaysOnMarket": 211
+"Directions": "8814 St. Charles Rock Road"
+"Disclosures": array:3 [
0 => "Unknown"
1 => "No Other Known Restrictions"
2 => "Year Built Unknown"
]
+"DocumentsChangeTimestamp": "2025-04-29T00:54:31Z"
+"Electric": "Ameren"
+"Heating": array:1 [
0 => "Forced Air"
]
+"Inclusions": "Building"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAOR": "St. Louis Association of REALTORS"
+"ListAgentKey": "MIS92035467"
+"ListOfficeAOR": "St. Louis Association of REALTORS"
+"ListOfficeKey": "MIS55486798"
+"ListOfficePhone": "314-374-3687"
+"ListingService": "Full Service"
+"ListingTerms": "Cash,Conventional,Lease Back"
+"LivingAreaSource": "Assessor"
+"MLSAreaMajor": "31 - Riverview Gardens"
+"MajorChangeTimestamp": "2024-11-15T07:32:01Z"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NumberOfBuildings": 1
+"OffMarketDate": "2025-10-31"
+"OnMarketDate": "2024-11-15"
+"OriginalEntryTimestamp": "2024-11-15T07:30:20Z"
+"OriginalListPrice": 350000
+"ParkingFeatures": array:2 [
0 => "Concrete"
1 => "Driveway"
]
+"PhotosChangeTimestamp": "2025-04-29T00:54:31Z"
+"PhotosCount": 7
+"PossibleUse": "Convenience Store,Grocery,Restaurant,Professional/Office,Residential,Retail"
+"RoadFrontageType": array:1 [
0 => "City Street"
]
+"ShowingRequirements": array:4 [
0 => "Appointment Only"
1 => "Call Listing Agent"
2 => "Call Listing Office"
3 => "Text Listing Agent"
]
+"SpecialListingConditions": array:1 [
0 => "Standard"
]
+"StateOrProvince": "MO"
+"StatusChangeTimestamp": "2024-11-15T07:30:20Z"
+"StoriesTotal": "2"
+"StreetName": "St. Charles Rock Road"
+"StreetNumber": "8814"
+"StreetNumberNumeric": "8814"
+"SubdivisionName": "St. John"
+"TaxYear": "2024"
+"Township": "St. John"
+"Utilities": array:4 [
0 => "Electricity Available"
1 => "Natural Gas Available"
2 => "Water Available"
3 => "Sewer Available"
]
+"MAR_LOCA": "City,High Traffic"
+"MAR_PROP": "Retail"
+"MAR_IsDeleted": "0"
+"MAR_LastStatus": "Coming Soon"
+"MAR_price_per_sf": "68.88"
+"MAR_MatrixTesting": "0"
+"MAR_Office_Area_Code": "314"
+"MAR_Office_Long_Name": "Salient Realty Group, LLC"
+"MAR_Transaction_Type": "Sale"
+"MAR_Co_Agent_Nickname": "Garen"
+"MAR_ExpectedActiveDate": "2024-11-15"
+"MAR_Listing_Agent_Nickname": "Ben"
+"MAR_Co_Office_Phone_Area_Code": "314"
+"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS95342208')"
+"MIS_PoolYN": "0"
+"MIS_RoomCount": "0"
+"MIS_UnitCount": "0"
+"provider_name": "Stellar"
+"MIS_CurrentPrice": "350000.00"
+"MIS_OpenHouseCount": "0"
+"MIS_PreviousStatus": "Coming Soon"
+"MIS_ActiveOpenHouseCount": "0"
+"MIS_OpenHousePublicCount": "0"
+"MIS_OpenHousePublicUpcoming": "0"
+"MIS_MainAndUpperLevelBedrooms": "0"
+"MIS_PropertySubTypeAdditional": "Retail/Shopping Center"
+"MIS_MainAndUpperLevelBathrooms": "0"
+"Media": array:7 [
0 => array:12 [
"Order" => 0
"MediaKey" => "67363b23c0bdab6809cdff81"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/607137f38a260a2be6bd07c5841d812a.webp"
"MediaSize" => 458585
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-607137f38a260a2be6bd07c5841d812a.webp"
"ImageWidth" => 1600
"ImageHeight" => 1199
"LongDescription" => "View of property"
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1199"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.390Z"
]
1 => array:12 [
"Order" => 1
"MediaKey" => "67363b23c0bdab6809cdff82"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/0b78d7931391aed013dcdefee3554ee5.webp"
"MediaSize" => 346322
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-0b78d7931391aed013dcdefee3554ee5.webp"
"ImageWidth" => 1600
"ImageHeight" => 1200
"LongDescription" => "Unfurnished living room featuring ceiling fan, hardwood / wood-style floors, and a textured ceiling"
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1200"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.366Z"
]
2 => array:12 [
"Order" => 2
"MediaKey" => "67363b23c0bdab6809cdff83"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/83d1ef0512dc384be2231bbbbb666ae8.webp"
"MediaSize" => 311425
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-83d1ef0512dc384be2231bbbbb666ae8.webp"
"ImageWidth" => 1600
"ImageHeight" => 1200
"LongDescription" => "Misc room featuring light hardwood / wood-style flooring and ceiling fan"
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1200"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.307Z"
]
3 => array:12 [
"Order" => 3
"MediaKey" => "67363b23c0bdab6809cdff84"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/655a43db104f9d8c04e75d2bd49bafb2.webp"
"MediaSize" => 413261
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-655a43db104f9d8c04e75d2bd49bafb2.webp"
"ImageWidth" => 1600
"ImageHeight" => 1200
"LongDescription" => "Misc room featuring ceiling fan, beamed ceiling, brick wall, wood-type flooring, and a textured ceiling"
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1200"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.342Z"
]
4 => array:11 [
"Order" => 4
"MediaKey" => "67363b23c0bdab6809cdff85"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/80404cbcac5641f6f40bb909a9586911.webp"
"MediaSize" => 395724
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-80404cbcac5641f6f40bb909a9586911.webp"
"ImageWidth" => 1600
"ImageHeight" => 1200
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1200"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.364Z"
]
5 => array:12 [
"Order" => 5
"MediaKey" => "67363b23c0bdab6809cdff86"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/fbf9baca1fa97ed83ea23102c1ad004e.webp"
"MediaSize" => 399384
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-fbf9baca1fa97ed83ea23102c1ad004e.webp"
"ImageWidth" => 1600
"ImageHeight" => 1200
"LongDescription" => "View of front of home"
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1200"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.445Z"
]
6 => array:12 [
"Order" => 6
"MediaKey" => "67363b23c0bdab6809cdff87"
"MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/20763f9fbd9dbb3ed89c4d8d4f650b8a.webp"
"MediaSize" => 417269
"MediaType" => "webp"
"Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR95342208/thumbnail-20763f9fbd9dbb3ed89c4d8d4f650b8a.webp"
"ImageWidth" => 1600
"ImageHeight" => 1200
"LongDescription" => "View of wooden deck"
"ResourceRecordKey" => "MAR95342208"
"ImageSizeDescription" => "1600x1200"
"MediaModificationTimestamp" => "2024-11-14T18:02:11.382Z"
]
]
+"ID": "16552"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.15 seconds"
]
]
