HOT LOT Alert! .45 acre with lots of features. Original home was torn down so the hard part is done. Some have referred to this as a “triple lot”. This area is going through a revitalization and now is the perfect time to become a part of it. World class coffee shops, breakfast/brunch spots, brewery, boxing gym, tattoo shop and some antique stores. This area also hosts free local festivals and events throughout the year. Come check out the Frenchtown Historic District aka Historic Main St. 2.0!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "22550" +post_author: 1 +"ListingKey": "MIS203532210" +"ListingId": "25042854" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-20T00:37:38Z" +"RFModificationTimestamp": "2025-06-20T00:40:04.477098+00:00" +"ListPrice": 145000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Charles" +"PostalCode": "63301" +"UnparsedAddress": "1219 N 4th Street, St Charles, Missouri 63301" +"Coordinates": array:2 [ 0 => -90.48000772 1 => 38.79227986 ] +"Latitude": 38.79227986 +"Longitude": -90.48000772 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Benjamin Giessman" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "BGIESSMA" +"ListOfficeMlsId": "CBG21" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "HOT LOT Alert! .45 acre with lots of features. Original home was torn down so the hard part is done. Some have referred to this as a "triple lot". This area is going through a revitalization and now is the perfect time to become a part of it. World class coffee shops, breakfast/brunch spots, brewery, boxing gym, tattoo shop and some antique stores. This area also hosts free local festivals and events throughout the year. Come check out the Frenchtown Historic District aka Historic Main St. 2.0!" +"CoListAgentAOR": "St. Louis Association of REALTORS" +"CoListAgentFullName": "Denise Hanmore" +"CoListAgentKey": "52955799" +"CoListAgentMlsId": "DHANMORE" +"CoListOfficeKey": "452" +"CoListOfficeMlsId": "CBG21" +"CoListOfficeName": "Coldwell Banker Realty - Gundaker" +"CoListOfficePhone": "636-561-1000" +"CountyOrParish": "St. Charles" +"CreationDate": "2025-06-19T19:32:18.257074+00:00" +"DevelopmentStatus": array:1 [ 0 => "Surveyed" ] +"Disclosures": array:1 [ 0 => "Unknown" ] +"DocumentsAvailable": array:2 [ 0 => "Aerial Photos" 1 => "Feasibility Study" ] +"DocumentsChangeTimestamp": "2025-06-20T00:37:38Z" +"ElementarySchool": "Coverdell Elem." +"HighSchool": "St. Charles High" +"HighSchoolDistrict": "St. Charles R-VI" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "31082004" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "452" +"ListOfficePhone": "636-561-1000" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LotFeatures": array:6 [ 0 => "Cleared" 1 => "Corner Lot" 2 => "Corners Marked" 3 => "Front Yard" 4 => "Gentle Sloping" 5 => "Infill Lot" ] +"LotSizeAcres": 0.4555 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "403 - St. Charles" +"MajorChangeTimestamp": "2025-06-19T19:28:10Z" +"MiddleOrJuniorSchool": "Jefferson / Hardin" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-06-19" +"OriginalEntryTimestamp": "2025-06-19T19:28:10Z" +"OriginalListPrice": 145000 +"ParcelNumber": "6-009A-B116-00-0001.0000000" +"PhotosChangeTimestamp": "2025-06-19T19:29:38Z" +"PhotosCount": 19 +"PossibleUse": "Commercial,Residential,Residential Lots" +"PriceChangeTimestamp": "2025-06-19T19:28:10Z" +"ShowingRequirements": array:1 [ 0 => "Register and Show" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-06-19T19:28:10Z" +"StreetDirPrefix": "N" +"StreetName": "4th" +"StreetNumber": "1219" +"StreetNumberNumeric": "1219" +"StreetSuffix": "Street" +"SubdivisionName": "City/St Charles" +"TaxAnnualAmount": "1142" +"TaxYear": "2024" +"Township": "St. Charles" +"Zoning": "Residential" +"MIS_Section": "ST CHARLES" +"MIS_CurrentPrice": "145000.00" +"MIS_Restrictions": "Other Building Restrictions" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203532210')" +"provider_name": "MARIS" +"Media": array:19 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "685464ef02d77576f5113920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/ac9e6d7152de674b8ba45fd7d6638e06.webp" "MediaSize" => 193894 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-ac9e6d7152de674b8ba45fd7d6638e06.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.700Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "685464ef02d77576f5113921" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/25ec7a51648004e745eeb0a910482009.webp" "MediaSize" => 212396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-25ec7a51648004e745eeb0a910482009.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.748Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "685464ef02d77576f5113922" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/e49b0efbeecc00988a6a4e5e25ad31d5.webp" "MediaSize" => 236670 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-e49b0efbeecc00988a6a4e5e25ad31d5.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.729Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "685464ef02d77576f5113923" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/e896e40b451f652d45272937d9213239.webp" "MediaSize" => 233411 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-e896e40b451f652d45272937d9213239.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.741Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "685464ef02d77576f5113924" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/b807cc0ce7fa69cc20a33b4a69f2caab.webp" "MediaSize" => 198313 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-b807cc0ce7fa69cc20a33b4a69f2caab.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.784Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "685464ef02d77576f5113925" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/696794aa4cbe449b5ae4fcd1d4d6ec44.webp" "MediaSize" => 166337 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-696794aa4cbe449b5ae4fcd1d4d6ec44.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of building exterior" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.678Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "685464ef02d77576f5113926" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/d2a015345a17ab90aa65b92566097730.webp" "MediaSize" => 171665 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-d2a015345a17ab90aa65b92566097730.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.731Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "685464ef02d77576f5113927" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/45850db0c0cc533d3c8b7567a77442f5.webp" "MediaSize" => 176872 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-45850db0c0cc533d3c8b7567a77442f5.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.686Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "685464ef02d77576f5113928" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/f18e507fa85599833a7c10a6c90d9250.webp" "MediaSize" => 164700 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-f18e507fa85599833a7c10a6c90d9250.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.728Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "685464ef02d77576f5113929" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/acb2c938d83ae5fab74b69c7c38b326e.webp" "MediaSize" => 158191 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-acb2c938d83ae5fab74b69c7c38b326e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of asphalt street featuring street lighting, sidewalks, curbs, and a residential view" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.744Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "685464ef02d77576f511392a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/8779de9deb2707e61550d7b0a110e31c.webp" "MediaSize" => 233588 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-8779de9deb2707e61550d7b0a110e31c.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.704Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "685464ef02d77576f511392b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/39741048c8d1063f67e23bc2bb9ca005.webp" "MediaSize" => 232445 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-39741048c8d1063f67e23bc2bb9ca005.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Bird's eye view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.732Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "685464ef02d77576f511392c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/183bd99baf29886a24518873d9f7c759.webp" "MediaSize" => 206318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-183bd99baf29886a24518873d9f7c759.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Aerial view of residential area featuring a tree filled landscape" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.731Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "685464ef02d77576f511392d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/2ba304e0615584ff4dd735b279c5386e.webp" "MediaSize" => 216690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-2ba304e0615584ff4dd735b279c5386e.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Drone / aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.740Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "685464ef02d77576f511392e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/85e3052c87c9eaebc2429d8596499ad5.webp" "MediaSize" => 216637 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-85e3052c87c9eaebc2429d8596499ad5.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Drone / aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.724Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "685464ef02d77576f511392f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/d853b0a4489196d35e5784e142e09387.webp" "MediaSize" => 180965 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-d853b0a4489196d35e5784e142e09387.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Bird's eye view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.712Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "685464ef02d77576f5113930" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/6522a6d0757701ce56306ab98c975990.webp" "MediaSize" => 197598 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-6522a6d0757701ce56306ab98c975990.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Aerial perspective of suburban area" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.701Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "685464ef02d77576f5113931" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/d5e2068e693cb939ac4bbfd0884a3bf2.webp" "MediaSize" => 182722 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-d5e2068e693cb939ac4bbfd0884a3bf2.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.693Z" ] 18 => array:12 [ "Order" => 18 "MediaKey" => "685464ef02d77576f5113932" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/2a1283edbde49493c35890f16c2a5413.webp" "MediaSize" => 185136 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-2a1283edbde49493c35890f16c2a5413.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Drone / aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.731Z" ] ] +"ID": "22550" }
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 'MIS203532210'/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 'MIS203532210'&$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 'MIS203532210'/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 'MIS203532210'&$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: "22550" +post_author: 1 +"ListingKey": "MIS203532210" +"ListingId": "25042854" +"PropertyType": "Land" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-20T00:37:38Z" +"RFModificationTimestamp": "2025-06-20T00:40:04.477098+00:00" +"ListPrice": 145000.0 +"BathroomsTotalInteger": 0 +"BathroomsHalf": 0 +"BedroomsTotal": 0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Charles" +"PostalCode": "63301" +"UnparsedAddress": "1219 N 4th Street, St Charles, Missouri 63301" +"Coordinates": array:2 [ 0 => -90.48000772 1 => 38.79227986 ] +"Latitude": 38.79227986 +"Longitude": -90.48000772 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Benjamin Giessman" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "BGIESSMA" +"ListOfficeMlsId": "CBG21" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "HOT LOT Alert! .45 acre with lots of features. Original home was torn down so the hard part is done. Some have referred to this as a "triple lot". This area is going through a revitalization and now is the perfect time to become a part of it. World class coffee shops, breakfast/brunch spots, brewery, boxing gym, tattoo shop and some antique stores. This area also hosts free local festivals and events throughout the year. Come check out the Frenchtown Historic District aka Historic Main St. 2.0!" +"CoListAgentAOR": "St. Louis Association of REALTORS" +"CoListAgentFullName": "Denise Hanmore" +"CoListAgentKey": "52955799" +"CoListAgentMlsId": "DHANMORE" +"CoListOfficeKey": "452" +"CoListOfficeMlsId": "CBG21" +"CoListOfficeName": "Coldwell Banker Realty - Gundaker" +"CoListOfficePhone": "636-561-1000" +"CountyOrParish": "St. Charles" +"CreationDate": "2025-06-19T19:32:18.257074+00:00" +"DevelopmentStatus": array:1 [ 0 => "Surveyed" ] +"Disclosures": array:1 [ 0 => "Unknown" ] +"DocumentsAvailable": array:2 [ 0 => "Aerial Photos" 1 => "Feasibility Study" ] +"DocumentsChangeTimestamp": "2025-06-20T00:37:38Z" +"ElementarySchool": "Coverdell Elem." +"HighSchool": "St. Charles High" +"HighSchoolDistrict": "St. Charles R-VI" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "31082004" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "452" +"ListOfficePhone": "636-561-1000" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LotFeatures": array:6 [ 0 => "Cleared" 1 => "Corner Lot" 2 => "Corners Marked" 3 => "Front Yard" 4 => "Gentle Sloping" 5 => "Infill Lot" ] +"LotSizeAcres": 0.4555 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "403 - St. Charles" +"MajorChangeTimestamp": "2025-06-19T19:28:10Z" +"MiddleOrJuniorSchool": "Jefferson / Hardin" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-06-19" +"OriginalEntryTimestamp": "2025-06-19T19:28:10Z" +"OriginalListPrice": 145000 +"ParcelNumber": "6-009A-B116-00-0001.0000000" +"PhotosChangeTimestamp": "2025-06-19T19:29:38Z" +"PhotosCount": 19 +"PossibleUse": "Commercial,Residential,Residential Lots" +"PriceChangeTimestamp": "2025-06-19T19:28:10Z" +"ShowingRequirements": array:1 [ 0 => "Register and Show" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-06-19T19:28:10Z" +"StreetDirPrefix": "N" +"StreetName": "4th" +"StreetNumber": "1219" +"StreetNumberNumeric": "1219" +"StreetSuffix": "Street" +"SubdivisionName": "City/St Charles" +"TaxAnnualAmount": "1142" +"TaxYear": "2024" +"Township": "St. Charles" +"Zoning": "Residential" +"MIS_Section": "ST CHARLES" +"MIS_CurrentPrice": "145000.00" +"MIS_Restrictions": "Other Building Restrictions" +"MIS_MainAndUpperLevelBedrooms": "0" +"MIS_MainAndUpperLevelBathrooms": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203532210')" +"provider_name": "MARIS" +"Media": array:19 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "685464ef02d77576f5113920" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/ac9e6d7152de674b8ba45fd7d6638e06.webp" "MediaSize" => 193894 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-ac9e6d7152de674b8ba45fd7d6638e06.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.700Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "685464ef02d77576f5113921" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/25ec7a51648004e745eeb0a910482009.webp" "MediaSize" => 212396 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-25ec7a51648004e745eeb0a910482009.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.748Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "685464ef02d77576f5113922" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/e49b0efbeecc00988a6a4e5e25ad31d5.webp" "MediaSize" => 236670 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-e49b0efbeecc00988a6a4e5e25ad31d5.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.729Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "685464ef02d77576f5113923" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/e896e40b451f652d45272937d9213239.webp" "MediaSize" => 233411 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-e896e40b451f652d45272937d9213239.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.741Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "685464ef02d77576f5113924" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/b807cc0ce7fa69cc20a33b4a69f2caab.webp" "MediaSize" => 198313 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-b807cc0ce7fa69cc20a33b4a69f2caab.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.784Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "685464ef02d77576f5113925" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/696794aa4cbe449b5ae4fcd1d4d6ec44.webp" "MediaSize" => 166337 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-696794aa4cbe449b5ae4fcd1d4d6ec44.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of building exterior" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.678Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "685464ef02d77576f5113926" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/d2a015345a17ab90aa65b92566097730.webp" "MediaSize" => 171665 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-d2a015345a17ab90aa65b92566097730.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.731Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "685464ef02d77576f5113927" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/45850db0c0cc533d3c8b7567a77442f5.webp" "MediaSize" => 176872 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-45850db0c0cc533d3c8b7567a77442f5.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.686Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "685464ef02d77576f5113928" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/f18e507fa85599833a7c10a6c90d9250.webp" "MediaSize" => 164700 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-f18e507fa85599833a7c10a6c90d9250.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.728Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "685464ef02d77576f5113929" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/acb2c938d83ae5fab74b69c7c38b326e.webp" "MediaSize" => 158191 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-acb2c938d83ae5fab74b69c7c38b326e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of asphalt street featuring street lighting, sidewalks, curbs, and a residential view" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-19T19:28:47.744Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "685464ef02d77576f511392a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/8779de9deb2707e61550d7b0a110e31c.webp" "MediaSize" => 233588 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-8779de9deb2707e61550d7b0a110e31c.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.704Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "685464ef02d77576f511392b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/39741048c8d1063f67e23bc2bb9ca005.webp" "MediaSize" => 232445 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-39741048c8d1063f67e23bc2bb9ca005.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Bird's eye view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.732Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "685464ef02d77576f511392c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/183bd99baf29886a24518873d9f7c759.webp" "MediaSize" => 206318 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-183bd99baf29886a24518873d9f7c759.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Aerial view of residential area featuring a tree filled landscape" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.731Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "685464ef02d77576f511392d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/2ba304e0615584ff4dd735b279c5386e.webp" "MediaSize" => 216690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-2ba304e0615584ff4dd735b279c5386e.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Drone / aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.740Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "685464ef02d77576f511392e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/85e3052c87c9eaebc2429d8596499ad5.webp" "MediaSize" => 216637 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-85e3052c87c9eaebc2429d8596499ad5.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Drone / aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.724Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "685464ef02d77576f511392f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/d853b0a4489196d35e5784e142e09387.webp" "MediaSize" => 180965 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-d853b0a4489196d35e5784e142e09387.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Bird's eye view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.712Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "685464ef02d77576f5113930" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/6522a6d0757701ce56306ab98c975990.webp" "MediaSize" => 197598 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-6522a6d0757701ce56306ab98c975990.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Aerial perspective of suburban area" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.701Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "685464ef02d77576f5113931" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/d5e2068e693cb939ac4bbfd0884a3bf2.webp" "MediaSize" => 182722 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-d5e2068e693cb939ac4bbfd0884a3bf2.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.693Z" ] 18 => array:12 [ "Order" => 18 "MediaKey" => "685464ef02d77576f5113932" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/2a1283edbde49493c35890f16c2a5413.webp" "MediaSize" => 185136 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203532210/thumbnail-2a1283edbde49493c35890f16c2a5413.webp" "ImageWidth" => 1024 "ImageHeight" => 766 "MediaCategory" => "Photo" "LongDescription" => "Drone / aerial view" "ImageSizeDescription" => "1024x766" "MediaModificationTimestamp" => "2025-06-19T19:28:47.731Z" ] ] +"ID": "22550" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.2 seconds" ] ]