Investor Special – Fully Gutted 3 Bed / 1 Bath on Slab
This is a clean slate ready for your next flip, rental, or personal vision! Located in a quiet neighborhood, this 3 bedroom, 1 bathroom home has been fully gutted down to the studs and sits on a solid concrete slab foundation.
Demo is already complete
Framing layout in place for 3/1
All utilities available at the property
No interior systems or finishes – ready for full customization
Perfect for experienced investors or contractors looking to take on a high-potential rehab project. Bring your crew and your creativity!
Cash or hard money preferred. Sold AS-IS
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "23339" +post_author: 1 +"ListingKey": "MIS203618570" +"ListingId": "25044605" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-07-09T16:00:38Z" +"RFModificationTimestamp": "2025-07-09T16:06:07Z" +"ListPrice": 59000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63135" +"UnparsedAddress": "317 Mueller Avenue, St Louis, Missouri 63135" +"Coordinates": array:2 [ 0 => -90.318012 1 => 38.737967 ] +"Latitude": 38.737967 +"Longitude": -90.318012 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Meg Colyer" +"ListOfficeName": "Vancil Brothers Realty" +"ListAgentMlsId": "MECOLYER" +"ListOfficeMlsId": "VNCL01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Investor Special – Fully Gutted 3 Bed / 1 Bath on Slab \n This is a clean slate ready for your next flip, rental, or personal vision! Located in a quiet neighborhood, this 3 bedroom, 1 bathroom home has been fully gutted down to the studs and sits on a solid concrete slab foundation.\n \n Demo is already complete\n Framing layout in place for 3/1\n All utilities available at the property\n No interior systems or finishes – ready for full customization\n \n Perfect for experienced investors or contractors looking to take on a high-potential rehab project. Bring your crew and your creativity!\n \n Cash or hard money preferred. Sold AS-IS """ +"AboveGradeFinishedArea": 1113 +"AboveGradeFinishedAreaSource": "Appraiser" +"ArchitecturalStyle": array:1 [ 0 => "Ranch" ] +"BathroomsFull": 1 +"CoListAgentAOR": "St. Louis Association of REALTORS" +"CoListAgentFullName": "Catherine Pfeiffer" +"CoListAgentKey": "36244969" +"CoListAgentMlsId": "CPFEIFFE" +"CoListOfficeKey": "59175526" +"CoListOfficeMlsId": "VNCL01" +"CoListOfficeName": "Vancil Brothers Realty" +"CoListOfficePhone": "314-971-7077" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-27T02:06:18.132414+00:00" +"CumulativeDaysOnMarket": 13 +"DaysOnMarket": 24 +"Disclosures": array:1 [ 0 => "None" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-07-09T16:00:38Z" +"Electric": "Other" +"ElementarySchool": "Central Elem." +"Heating": array:1 [ 0 => "Other" ] +"HighSchool": "Mccluer High" +"HighSchoolDistrict": "Ferguson-Florissant R-II" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "92189237" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "59175526" +"ListOfficePhone": "314-971-7077" +"ListingService": "Full Service" +"ListingTerms": "Cash,Other,Private" +"LotFeatures": array:1 [ 0 => "City Lot" ] +"LotSizeAcres": 0.1412 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "5 - North" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-07-09T15:59:06Z" +"MiddleOrJuniorSchool": "Ferguson Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active Under Contract" +"OnMarketDate": "2025-06-26" +"OriginalEntryTimestamp": "2025-06-27T02:01:17Z" +"OriginalListPrice": 59000 +"ParcelNumber": "12J-52-0070" +"PhotosChangeTimestamp": "2025-06-27T02:02:39Z" +"PhotosCount": 18 +"PriceChangeTimestamp": "2025-06-27T02:01:17Z" +"RoomsTotal": "6" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-09T15:59:06Z" +"StreetName": "Mueller" +"StreetNumber": "317" +"StreetNumberNumeric": "317" +"StreetSuffix": "Avenue" +"SubdivisionName": "Plaza Heights" +"TaxAnnualAmount": "878" +"TaxYear": "2024" +"Township": "Ferguson" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_Section": "FERGUSON" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "59000.00" +"MIS_PreviousStatus": "Active" +"MIS_SecondMortgageYN": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203618570')" +"provider_name": "MARIS" +"Media": array:18 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "685dfb8e575af10a97a1dc92" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/bb2fd6b26cafd2cc3ccf3925c86fb428.webp" "MediaSize" => 185759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-bb2fd6b26cafd2cc3ccf3925c86fb428.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of side of home" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.204Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "685dfb8e575af10a97a1dc93" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/d12bf6a0056b76dd57f88a9d0ed04ebb.webp" "MediaSize" => 183099 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-d12bf6a0056b76dd57f88a9d0ed04ebb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.253Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "685dfb8e575af10a97a1dc94" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/e651f75daf3fc58ca59b0a935c993237.webp" "MediaSize" => 181535 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-e651f75daf3fc58ca59b0a935c993237.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.220Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "685dfb8e575af10a97a1dc95" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/7ef41abefe201c438f6daf3371b32a97.webp" "MediaSize" => 128497 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-7ef41abefe201c438f6daf3371b32a97.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of miscellaneous room" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.232Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "685dfb8e575af10a97a1dc96" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/56905a213d256d7e5fd96951d5fa0d8e.webp" "MediaSize" => 123814 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-56905a213d256d7e5fd96951d5fa0d8e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.160Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "685dfb8e575af10a97a1dc97" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/06eadc64b61dffb920e30ba62313e9e4.webp" "MediaSize" => 120188 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-06eadc64b61dffb920e30ba62313e9e4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Misc room featuring tile patterned floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.168Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "685dfb8e575af10a97a1dc98" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/cf590bb6765a91ecf7903e5000d726a4.webp" "MediaSize" => 115408 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-cf590bb6765a91ecf7903e5000d726a4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.168Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "685dfb8e575af10a97a1dc99" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/0f056480fa6eae0d7b663eaa5c6d3820.webp" "MediaSize" => 94785 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-0f056480fa6eae0d7b663eaa5c6d3820.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom with lofted ceiling, multiple closets, and cooling unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.158Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "685dfb8e575af10a97a1dc9a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/d04eee8575a828488d212eb05cc99a03.webp" "MediaSize" => 125961 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-d04eee8575a828488d212eb05cc99a03.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of miscellaneous room" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.170Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "685dfb8e575af10a97a1dc9b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/af1209a5b555b5cc1e5adbb6da13cfb4.webp" "MediaSize" => 105349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-af1209a5b555b5cc1e5adbb6da13cfb4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.167Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "685dfb8e575af10a97a1dc9c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/1d88ee8dc02818eadc829a2c4d38d066.webp" "MediaSize" => 107222 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-1d88ee8dc02818eadc829a2c4d38d066.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Miscellaneous room featuring electric panel" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.167Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "685dfb8e575af10a97a1dc9d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/67f108db66ba6d168bc2ea38bed9083b.webp" "MediaSize" => 90633 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-67f108db66ba6d168bc2ea38bed9083b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom with a closet and ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.157Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "685dfb8e575af10a97a1dc9e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/3f6b4fd29b1b12c665cf5578d72dab03.webp" "MediaSize" => 124027 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-3f6b4fd29b1b12c665cf5578d72dab03.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Utilities featuring gas water heater and electric panel" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.151Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "685dfb8e575af10a97a1dc9f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/ac8b6f7ebd213356fb76d0463a68eab6.webp" "MediaSize" => 103081 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-ac8b6f7ebd213356fb76d0463a68eab6.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Half bathroom with toilet and tile patterned flooring" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.148Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "685dfb8e575af10a97a1dca0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/39c5f29bfe22eaae5b53a9349556f92b.webp" "MediaSize" => 164590 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-39c5f29bfe22eaae5b53a9349556f92b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of property exterior" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.223Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "685dfb8e575af10a97a1dca1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/62e5a92040d4161fafa0716ee6418e69.webp" "MediaSize" => 185823 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-62e5a92040d4161fafa0716ee6418e69.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Back of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.208Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "685dfb8e575af10a97a1dca2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/8ac07070f00e0e7f0317e6b921835ce2.webp" "MediaSize" => 168001 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-8ac07070f00e0e7f0317e6b921835ce2.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of side of home" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.228Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "685dfb8e575af10a97a1dca3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/24b4912a242eb0dd645bdc73c0dc5323.webp" "MediaSize" => 227604 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-24b4912a242eb0dd645bdc73c0dc5323.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.215Z" ] ] +"ID": "23339" }
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 'MIS203618570'/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 'MIS203618570'&$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 'MIS203618570'/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 'MIS203618570'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2835 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "23339" +post_author: 1 +"ListingKey": "MIS203618570" +"ListingId": "25044605" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active Under Contract" +"ModificationTimestamp": "2025-07-09T16:00:38Z" +"RFModificationTimestamp": "2025-07-09T16:06:07Z" +"ListPrice": 59000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63135" +"UnparsedAddress": "317 Mueller Avenue, St Louis, Missouri 63135" +"Coordinates": array:2 [ 0 => -90.318012 1 => 38.737967 ] +"Latitude": 38.737967 +"Longitude": -90.318012 +"YearBuilt": 1949 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Meg Colyer" +"ListOfficeName": "Vancil Brothers Realty" +"ListAgentMlsId": "MECOLYER" +"ListOfficeMlsId": "VNCL01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Investor Special – Fully Gutted 3 Bed / 1 Bath on Slab \n This is a clean slate ready for your next flip, rental, or personal vision! Located in a quiet neighborhood, this 3 bedroom, 1 bathroom home has been fully gutted down to the studs and sits on a solid concrete slab foundation.\n \n Demo is already complete\n Framing layout in place for 3/1\n All utilities available at the property\n No interior systems or finishes – ready for full customization\n \n Perfect for experienced investors or contractors looking to take on a high-potential rehab project. Bring your crew and your creativity!\n \n Cash or hard money preferred. Sold AS-IS """ +"AboveGradeFinishedArea": 1113 +"AboveGradeFinishedAreaSource": "Appraiser" +"ArchitecturalStyle": array:1 [ 0 => "Ranch" ] +"BathroomsFull": 1 +"CoListAgentAOR": "St. Louis Association of REALTORS" +"CoListAgentFullName": "Catherine Pfeiffer" +"CoListAgentKey": "36244969" +"CoListAgentMlsId": "CPFEIFFE" +"CoListOfficeKey": "59175526" +"CoListOfficeMlsId": "VNCL01" +"CoListOfficeName": "Vancil Brothers Realty" +"CoListOfficePhone": "314-971-7077" +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-27T02:06:18.132414+00:00" +"CumulativeDaysOnMarket": 13 +"DaysOnMarket": 24 +"Disclosures": array:1 [ 0 => "None" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-07-09T16:00:38Z" +"Electric": "Other" +"ElementarySchool": "Central Elem." +"Heating": array:1 [ 0 => "Other" ] +"HighSchool": "Mccluer High" +"HighSchoolDistrict": "Ferguson-Florissant R-II" +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "92189237" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "59175526" +"ListOfficePhone": "314-971-7077" +"ListingService": "Full Service" +"ListingTerms": "Cash,Other,Private" +"LotFeatures": array:1 [ 0 => "City Lot" ] +"LotSizeAcres": 0.1412 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "5 - North" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2025-07-09T15:59:06Z" +"MiddleOrJuniorSchool": "Ferguson Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active Under Contract" +"OnMarketDate": "2025-06-26" +"OriginalEntryTimestamp": "2025-06-27T02:01:17Z" +"OriginalListPrice": 59000 +"ParcelNumber": "12J-52-0070" +"PhotosChangeTimestamp": "2025-06-27T02:02:39Z" +"PhotosCount": 18 +"PriceChangeTimestamp": "2025-06-27T02:01:17Z" +"RoomsTotal": "6" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Lockbox" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-09T15:59:06Z" +"StreetName": "Mueller" +"StreetNumber": "317" +"StreetNumberNumeric": "317" +"StreetSuffix": "Avenue" +"SubdivisionName": "Plaza Heights" +"TaxAnnualAmount": "878" +"TaxYear": "2024" +"Township": "Ferguson" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_Section": "FERGUSON" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "59000.00" +"MIS_PreviousStatus": "Active" +"MIS_SecondMortgageYN": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203618570')" +"provider_name": "MARIS" +"Media": array:18 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "685dfb8e575af10a97a1dc92" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/bb2fd6b26cafd2cc3ccf3925c86fb428.webp" "MediaSize" => 185759 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-bb2fd6b26cafd2cc3ccf3925c86fb428.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of side of home" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.204Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "685dfb8e575af10a97a1dc93" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/d12bf6a0056b76dd57f88a9d0ed04ebb.webp" "MediaSize" => 183099 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-d12bf6a0056b76dd57f88a9d0ed04ebb.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.253Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "685dfb8e575af10a97a1dc94" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/e651f75daf3fc58ca59b0a935c993237.webp" "MediaSize" => 181535 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-e651f75daf3fc58ca59b0a935c993237.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.220Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "685dfb8e575af10a97a1dc95" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/7ef41abefe201c438f6daf3371b32a97.webp" "MediaSize" => 128497 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-7ef41abefe201c438f6daf3371b32a97.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of miscellaneous room" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.232Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "685dfb8e575af10a97a1dc96" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/56905a213d256d7e5fd96951d5fa0d8e.webp" "MediaSize" => 123814 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-56905a213d256d7e5fd96951d5fa0d8e.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.160Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "685dfb8e575af10a97a1dc97" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/06eadc64b61dffb920e30ba62313e9e4.webp" "MediaSize" => 120188 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-06eadc64b61dffb920e30ba62313e9e4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Misc room featuring tile patterned floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.168Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "685dfb8e575af10a97a1dc98" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/cf590bb6765a91ecf7903e5000d726a4.webp" "MediaSize" => 115408 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-cf590bb6765a91ecf7903e5000d726a4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.168Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "685dfb8e575af10a97a1dc99" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/0f056480fa6eae0d7b663eaa5c6d3820.webp" "MediaSize" => 94785 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-0f056480fa6eae0d7b663eaa5c6d3820.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom with lofted ceiling, multiple closets, and cooling unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.158Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "685dfb8e575af10a97a1dc9a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/d04eee8575a828488d212eb05cc99a03.webp" "MediaSize" => 125961 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-d04eee8575a828488d212eb05cc99a03.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of miscellaneous room" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.170Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "685dfb8e575af10a97a1dc9b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/af1209a5b555b5cc1e5adbb6da13cfb4.webp" "MediaSize" => 105349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-af1209a5b555b5cc1e5adbb6da13cfb4.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.167Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "685dfb8e575af10a97a1dc9c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/1d88ee8dc02818eadc829a2c4d38d066.webp" "MediaSize" => 107222 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-1d88ee8dc02818eadc829a2c4d38d066.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Miscellaneous room featuring electric panel" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.167Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "685dfb8e575af10a97a1dc9d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/67f108db66ba6d168bc2ea38bed9083b.webp" "MediaSize" => 90633 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-67f108db66ba6d168bc2ea38bed9083b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom with a closet and ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.157Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "685dfb8e575af10a97a1dc9e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/3f6b4fd29b1b12c665cf5578d72dab03.webp" "MediaSize" => 124027 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-3f6b4fd29b1b12c665cf5578d72dab03.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Utilities featuring gas water heater and electric panel" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.151Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "685dfb8e575af10a97a1dc9f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/ac8b6f7ebd213356fb76d0463a68eab6.webp" "MediaSize" => 103081 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-ac8b6f7ebd213356fb76d0463a68eab6.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Half bathroom with toilet and tile patterned flooring" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.148Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "685dfb8e575af10a97a1dca0" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/39c5f29bfe22eaae5b53a9349556f92b.webp" "MediaSize" => 164590 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-39c5f29bfe22eaae5b53a9349556f92b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of property exterior" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.223Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "685dfb8e575af10a97a1dca1" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/62e5a92040d4161fafa0716ee6418e69.webp" "MediaSize" => 185823 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-62e5a92040d4161fafa0716ee6418e69.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Back of property" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.208Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "685dfb8e575af10a97a1dca2" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/8ac07070f00e0e7f0317e6b921835ce2.webp" "MediaSize" => 168001 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-8ac07070f00e0e7f0317e6b921835ce2.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of side of home" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.228Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "685dfb8e575af10a97a1dca3" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/24b4912a242eb0dd645bdc73c0dc5323.webp" "MediaSize" => 227604 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203618570/thumbnail-24b4912a242eb0dd645bdc73c0dc5323.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-06-27T02:01:50.215Z" ] ] +"ID": "23339" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.41 seconds" ] ]