This one has it all for your small business – Location, Live, Work, Play. Office space plus living space upstairs and down, 3 sheds, parking for assorted vehicles and more. Enjoy the tiki hut out back with pool, hot tub and TV’s. First floor could be office space. Finished lower level with sleeping area, laundry and bathroom. Zoned C3 mixed commercial services. High traffic area. Property to be sold as-is.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "25645" +post_author: 1 +"ListingKey": "MIS203910543" +"ListingId": "25050627" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-31T14:51:38Z" +"RFModificationTimestamp": "2025-07-31T14:59:51Z" +"ListPrice": 227000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1874.0 +"City": "St Louis" +"PostalCode": "63125" +"UnparsedAddress": "2025 Lemay Ferry Road, Unincorporated, Missouri 63125" +"Coordinates": array:2 [ 0 => -90.297474 1 => 38.525018 ] +"Latitude": 38.525018 +"Longitude": -90.297474 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Patrice TenBroek" +"ListOfficeName": "RE/MAX Results" +"ListAgentMlsId": "PTENBROK" +"ListOfficeMlsId": "RMXR01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "This one has it all for your small business - Location, Live, Work, Play. Office space plus living space upstairs and down, 3 sheds, parking for assorted vehicles and more. Enjoy the tiki hut out back with pool, hot tub and TV's. First floor could be office space. Finished lower level with sleeping area, laundry and bathroom. Zoned C3 mixed commercial services. High traffic area. Property to be sold as-is." +"Appliances": array:3 [ 0 => "Electric Cooktop" 1 => "Dishwasher" 2 => "Electric Oven" ] +"BuildingName": "Built Wright Construction and Electric" +"BusinessType": "Construction/Contractor" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-30T21:43:20.985489+00:00" +"CrossStreet": "Reavis Barracks" +"CumulativeDaysOnMarket": 1 +"CurrentUse": array:4 [ 0 => "Commercial" 1 => "Mixed Use" 2 => "Office" 3 => "Residential" ] +"DaysOnMarket": 18 +"Disclosures": array:2 [ 0 => "Code Compliance Required" 1 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-07-30T21:41:38Z" +"Electric": "Ameren" +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "10425" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "2828" +"ListOfficePhone": "314-781-7777" +"ListingService": "Full Service" +"ListingTerms": "1031 Exchange,Cash,Conventional" +"LotSizeAcres": 0.14 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "331 - Mehlville" +"MajorChangeTimestamp": "2025-07-30T21:39:57Z" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"OnMarketDate": "2025-07-30" +"OriginalEntryTimestamp": "2025-07-30T21:39:57Z" +"OriginalListPrice": 227000 +"ParcelNumber": "27H-21-0965" +"PhotosChangeTimestamp": "2025-07-30T21:41:38Z" +"PhotosCount": 18 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"ShowingContactPhone": "314-614-0247" +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:5 [ 0 => "24 Hour Notice" 1 => "Appointment Only" 2 => "Call Listing Agent" 3 => "Occupied" 4 => "Pet(s) on Premises" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-30T21:39:57Z" +"StoriesTotal": "1" +"StreetName": "Lemay Ferry" +"StreetNumber": "2025" +"StreetNumberNumeric": "2025" +"StreetSuffix": "Road" +"SubdivisionName": "Carondelet Commons" +"TaxAnnualAmount": "3636" +"TaxYear": "2024" +"Township": "Unincorporated" +"Utilities": array:4 [ 0 => "Cable Available" 1 => "Electricity Connected" 2 => "Sewer Connected" 3 => "Water Connected" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_Section": "UNINCORPORATED" +"MIS_AuctionYN": "0" +"MIS_TaxExemptYN": "0" +"MIS_CurrentPrice": "227000.00" +"MIS_SecondMortgageYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203910543')" +"provider_name": "MARIS" +"Media": array:18 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "688a915ccf562209f02e8741" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/89b6e8925d839af017b5130f630b5198.webp" "MediaSize" => 136394 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-89b6e8925d839af017b5130f630b5198.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front facade featuring a chimney, roof with shingles, and uncovered parking" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.698Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "688a915ccf562209f02e8742" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/1bbaaa3eeeca6e2c96059d41bc1629ab.webp" "MediaSize" => 157527 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-1bbaaa3eeeca6e2c96059d41bc1629ab.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Aerial view of property's location featuring property parcel outlined" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.774Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "688a915ccf562209f02e8743" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/5b97d9585e2574ebe30b550046e58feb.webp" "MediaSize" => 149345 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-5b97d9585e2574ebe30b550046e58feb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.723Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "688a915ccf562209f02e8744" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/9ca82c1d22ef3ce10001d69803f9fd7c.webp" "MediaSize" => 128311 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-9ca82c1d22ef3ce10001d69803f9fd7c.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of parking / parking lot" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.687Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "688a915ccf562209f02e8745" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/1569027bb63415893940b102f3f199e4.webp" "MediaSize" => 187903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-1569027bb63415893940b102f3f199e4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Rear view of house with brick siding, a deck, and a chimney" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.671Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "688a915ccf562209f02e8746" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/54b409bac8a8bbd99db468f2dcaab3bc.webp" "MediaSize" => 173275 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-54b409bac8a8bbd99db468f2dcaab3bc.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of patio featuring outdoor dining area, a wooden deck, and grilling area" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.716Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "688a915ccf562209f02e8747" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/600465cd2256edbaebab7ce1aa97116e.webp" "MediaSize" => 199055 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-600465cd2256edbaebab7ce1aa97116e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Wooden terrace with a ceiling fan and an outdoor living space" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.800Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "688a915ccf562209f02e8748" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/c67006a47e12f5eda0134a493bbe7e60.webp" "MediaSize" => 183488 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-c67006a47e12f5eda0134a493bbe7e60.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Wooden deck featuring ceiling fan and outdoor dining space" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.731Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "688a915ccf562209f02e8749" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/76c79085e192672c159dda0366fe90c0.webp" "MediaSize" => 188160 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-76c79085e192672c159dda0366fe90c0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.731Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "688a915ccf562209f02e874a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/1e7635ea958e06362c7f508ecb29acb2.webp" "MediaSize" => 127496 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-1e7635ea958e06362c7f508ecb29acb2.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living room with ceiling fan, an office area, and carpet floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.675Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "688a915ccf562209f02e874b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/f7e48728c2347c7b85ad7c509440f8ba.webp" "MediaSize" => 114648 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-f7e48728c2347c7b85ad7c509440f8ba.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of home office" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.701Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "688a915ccf562209f02e874c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/f5169e7fd01319521596173506a8c03a.webp" "MediaSize" => 155585 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-f5169e7fd01319521596173506a8c03a.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Office with ceiling fan and light colored carpet" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.712Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "688a915ccf562209f02e874d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/94bfefdd5862508d2dca7fa8547b6a99.webp" "MediaSize" => 136129 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-94bfefdd5862508d2dca7fa8547b6a99.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Carpeted bedroom with baseboards and ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.693Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "688a915ccf562209f02e874e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/0d57488d117c8e689d161c6cb6f31414.webp" "MediaSize" => 149132 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-0d57488d117c8e689d161c6cb6f31414.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with dishwashing machine, stainless steel microwave, a textured ceiling, a ceiling fan, and light countertops" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.672Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "688a915ccf562209f02e874f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/40cb70abb9f06bd8f581095d5862a4f8.webp" "MediaSize" => 135947 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-40cb70abb9f06bd8f581095d5862a4f8.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring carpet, white appliances, and ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.678Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "688a915ccf562209f02e8750" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/e46fa71a2105f4f30d232f09c1863439.webp" "MediaSize" => 127753 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-e46fa71a2105f4f30d232f09c1863439.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Game room featuring billiards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.668Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "688a915ccf562209f02e8751" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/327fdbae4699fb94fa21cf80792b79fe.webp" "MediaSize" => 149489 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-327fdbae4699fb94fa21cf80792b79fe.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Aerial view of property and surrounding area featuring property boundaries highlighted" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.725Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "688a915ccf562209f02e8752" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/3bbd9f9fd7dd03ddf93c01fafd46e9ba.webp" "MediaSize" => 151140 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-3bbd9f9fd7dd03ddf93c01fafd46e9ba.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Aerial overview of property's location featuring property boundaries highlighted" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.740Z" ] ] +"ID": "25645" }
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 'MIS203910543'/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 'MIS203910543'&$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 'MIS203910543'/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 'MIS203910543'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2836 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "25645" +post_author: 1 +"ListingKey": "MIS203910543" +"ListingId": "25050627" +"PropertyType": "Commercial Sale" +"PropertySubType": "Mixed Use" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-31T14:51:38Z" +"RFModificationTimestamp": "2025-07-31T14:59:51Z" +"ListPrice": 227000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 1874.0 +"City": "St Louis" +"PostalCode": "63125" +"UnparsedAddress": "2025 Lemay Ferry Road, Unincorporated, Missouri 63125" +"Coordinates": array:2 [ 0 => -90.297474 1 => 38.525018 ] +"Latitude": 38.525018 +"Longitude": -90.297474 +"YearBuilt": 1950 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Patrice TenBroek" +"ListOfficeName": "RE/MAX Results" +"ListAgentMlsId": "PTENBROK" +"ListOfficeMlsId": "RMXR01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "This one has it all for your small business - Location, Live, Work, Play. Office space plus living space upstairs and down, 3 sheds, parking for assorted vehicles and more. Enjoy the tiki hut out back with pool, hot tub and TV's. First floor could be office space. Finished lower level with sleeping area, laundry and bathroom. Zoned C3 mixed commercial services. High traffic area. Property to be sold as-is." +"Appliances": array:3 [ 0 => "Electric Cooktop" 1 => "Dishwasher" 2 => "Electric Oven" ] +"BuildingName": "Built Wright Construction and Electric" +"BusinessType": "Construction/Contractor" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-30T21:43:20.985489+00:00" +"CrossStreet": "Reavis Barracks" +"CumulativeDaysOnMarket": 1 +"CurrentUse": array:4 [ 0 => "Commercial" 1 => "Mixed Use" 2 => "Office" 3 => "Residential" ] +"DaysOnMarket": 18 +"Disclosures": array:2 [ 0 => "Code Compliance Required" 1 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-07-30T21:41:38Z" +"Electric": "Ameren" +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "10425" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "2828" +"ListOfficePhone": "314-781-7777" +"ListingService": "Full Service" +"ListingTerms": "1031 Exchange,Cash,Conventional" +"LotSizeAcres": 0.14 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "331 - Mehlville" +"MajorChangeTimestamp": "2025-07-30T21:39:57Z" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NumberOfBuildings": 1 +"OnMarketDate": "2025-07-30" +"OriginalEntryTimestamp": "2025-07-30T21:39:57Z" +"OriginalListPrice": 227000 +"ParcelNumber": "27H-21-0965" +"PhotosChangeTimestamp": "2025-07-30T21:41:38Z" +"PhotosCount": 18 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"ShowingContactPhone": "314-614-0247" +"ShowingContactType": array:1 [ 0 => "Listing Agent" ] +"ShowingRequirements": array:5 [ 0 => "24 Hour Notice" 1 => "Appointment Only" 2 => "Call Listing Agent" 3 => "Occupied" 4 => "Pet(s) on Premises" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-30T21:39:57Z" +"StoriesTotal": "1" +"StreetName": "Lemay Ferry" +"StreetNumber": "2025" +"StreetNumberNumeric": "2025" +"StreetSuffix": "Road" +"SubdivisionName": "Carondelet Commons" +"TaxAnnualAmount": "3636" +"TaxYear": "2024" +"Township": "Unincorporated" +"Utilities": array:4 [ 0 => "Cable Available" 1 => "Electricity Connected" 2 => "Sewer Connected" 3 => "Water Connected" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_Section": "UNINCORPORATED" +"MIS_AuctionYN": "0" +"MIS_TaxExemptYN": "0" +"MIS_CurrentPrice": "227000.00" +"MIS_SecondMortgageYN": "0" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203910543')" +"provider_name": "MARIS" +"Media": array:18 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "688a915ccf562209f02e8741" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/89b6e8925d839af017b5130f630b5198.webp" "MediaSize" => 136394 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-89b6e8925d839af017b5130f630b5198.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front facade featuring a chimney, roof with shingles, and uncovered parking" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.698Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "688a915ccf562209f02e8742" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/1bbaaa3eeeca6e2c96059d41bc1629ab.webp" "MediaSize" => 157527 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-1bbaaa3eeeca6e2c96059d41bc1629ab.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Aerial view of property's location featuring property parcel outlined" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.774Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "688a915ccf562209f02e8743" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/5b97d9585e2574ebe30b550046e58feb.webp" "MediaSize" => 149345 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-5b97d9585e2574ebe30b550046e58feb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.723Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "688a915ccf562209f02e8744" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/9ca82c1d22ef3ce10001d69803f9fd7c.webp" "MediaSize" => 128311 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-9ca82c1d22ef3ce10001d69803f9fd7c.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of parking / parking lot" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.687Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "688a915ccf562209f02e8745" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/1569027bb63415893940b102f3f199e4.webp" "MediaSize" => 187903 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-1569027bb63415893940b102f3f199e4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Rear view of house with brick siding, a deck, and a chimney" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.671Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "688a915ccf562209f02e8746" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/54b409bac8a8bbd99db468f2dcaab3bc.webp" "MediaSize" => 173275 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-54b409bac8a8bbd99db468f2dcaab3bc.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of patio featuring outdoor dining area, a wooden deck, and grilling area" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.716Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "688a915ccf562209f02e8747" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/600465cd2256edbaebab7ce1aa97116e.webp" "MediaSize" => 199055 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-600465cd2256edbaebab7ce1aa97116e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Wooden terrace with a ceiling fan and an outdoor living space" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.800Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "688a915ccf562209f02e8748" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/c67006a47e12f5eda0134a493bbe7e60.webp" "MediaSize" => 183488 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-c67006a47e12f5eda0134a493bbe7e60.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Wooden deck featuring ceiling fan and outdoor dining space" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.731Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "688a915ccf562209f02e8749" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/76c79085e192672c159dda0366fe90c0.webp" "MediaSize" => 188160 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-76c79085e192672c159dda0366fe90c0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.731Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "688a915ccf562209f02e874a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/1e7635ea958e06362c7f508ecb29acb2.webp" "MediaSize" => 127496 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-1e7635ea958e06362c7f508ecb29acb2.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Living room with ceiling fan, an office area, and carpet floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.675Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "688a915ccf562209f02e874b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/f7e48728c2347c7b85ad7c509440f8ba.webp" "MediaSize" => 114648 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-f7e48728c2347c7b85ad7c509440f8ba.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of home office" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.701Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "688a915ccf562209f02e874c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/f5169e7fd01319521596173506a8c03a.webp" "MediaSize" => 155585 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-f5169e7fd01319521596173506a8c03a.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Office with ceiling fan and light colored carpet" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.712Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "688a915ccf562209f02e874d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/94bfefdd5862508d2dca7fa8547b6a99.webp" "MediaSize" => 136129 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-94bfefdd5862508d2dca7fa8547b6a99.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Carpeted bedroom with baseboards and ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.693Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "688a915ccf562209f02e874e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/0d57488d117c8e689d161c6cb6f31414.webp" "MediaSize" => 149132 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-0d57488d117c8e689d161c6cb6f31414.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with dishwashing machine, stainless steel microwave, a textured ceiling, a ceiling fan, and light countertops" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.672Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "688a915ccf562209f02e874f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/40cb70abb9f06bd8f581095d5862a4f8.webp" "MediaSize" => 135947 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-40cb70abb9f06bd8f581095d5862a4f8.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring carpet, white appliances, and ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.678Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "688a915ccf562209f02e8750" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/e46fa71a2105f4f30d232f09c1863439.webp" "MediaSize" => 127753 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-e46fa71a2105f4f30d232f09c1863439.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Game room featuring billiards" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.668Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "688a915ccf562209f02e8751" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/327fdbae4699fb94fa21cf80792b79fe.webp" "MediaSize" => 149489 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-327fdbae4699fb94fa21cf80792b79fe.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Aerial view of property and surrounding area featuring property boundaries highlighted" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.725Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "688a915ccf562209f02e8752" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/3bbd9f9fd7dd03ddf93c01fafd46e9ba.webp" "MediaSize" => 151140 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203910543/thumbnail-3bbd9f9fd7dd03ddf93c01fafd46e9ba.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Aerial overview of property's location featuring property boundaries highlighted" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-30T21:40:44.740Z" ] ] +"ID": "25645" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.17 seconds" ] ]