FIXER UPPER WITH GREAT POTENTIAL! Opportunity knocks in a prime Maplewood location! This 2-bedroom, 1-bath home is a true fixer-upper with endless potential—perfect for investors, rehabbers, or anyone looking to create their dream home. Just steps from the heart of downtown Maplewood, you can stroll to shops, restaurants, breweries and all the charm this vibrant community offers. The home needs work but could be a real gem with the right vision and updates. Don’t miss your chance to get into this sought-after area at an affordable price. Property to be sold as-is—seller will do no repairs or inspections.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "24201" +post_author: 1 +"ListingKey": "MIS203736125" +"ListingId": "25046919" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T22:27:38Z" +"RFModificationTimestamp": "2025-07-11T22:28:54.446596+00:00" +"ListPrice": 175000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Maplewood" +"PostalCode": "63143" +"UnparsedAddress": "2622 Lyle Avenue, None, Missouri 63143" +"Coordinates": array:2 [ 0 => -90.321443 1 => 38.613933 ] +"Latitude": 38.613933 +"Longitude": -90.321443 +"YearBuilt": 1912 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jane Spooner" +"ListOfficeName": "RedKey Realty Leaders" +"ListAgentMlsId": "JSPOONER" +"ListOfficeMlsId": "RDKY02" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "FIXER UPPER WITH GREAT POTENTIAL! Opportunity knocks in a prime Maplewood location! This 2-bedroom, 1-bath home is a true fixer-upper with endless potential—perfect for investors, rehabbers, or anyone looking to create their dream home. Just steps from the heart of downtown Maplewood, you can stroll to shops, restaurants, breweries and all the charm this vibrant community offers. The home needs work but could be a real gem with the right vision and updates. Don’t miss your chance to get into this sought-after area at an affordable price. Property to be sold as-is—seller will do no repairs or inspections." +"AboveGradeFinishedArea": 1092 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:3 [ 0 => "Portable Dishwasher" 1 => "Built-In Electric Range" 2 => "Refrigerator" ] +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"Basement": array:5 [ 0 => "Full" 1 => "Interior Entry" 2 => "Storage Space" 3 => "Unfinished" 4 => "Walk-Up Access" ] +"BasementYN": true +"BathroomsFull": 1 +"Cooling": array:3 [ 0 => "Ceiling Fan(s)" 1 => "Central Air" 2 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-08T16:28:34.502682+00:00" +"CrossStreet": "Manchester" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 6 +"Directions": "Manchester Rd to north on Lyle" +"Disclosures": array:2 [ 0 => "Flood Plain No" 1 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-07-11T22:27:38Z" +"ElementarySchool": "Mrh Elementary" +"ExteriorFeatures": array:1 [ 0 => "Private Yard" ] +"Fencing": array:1 [ 0 => "Partial" ] +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Maplewood-Richmond Hgts. High" +"HighSchoolDistrict": "Maplewood-Richmond Heights" +"InteriorFeatures": array:4 [ 0 => "Ceiling Fan(s)" 1 => "High Ceilings" 2 => "Laminate Counters" 3 => "Soaking Tub" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "8529" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "24861430" +"ListOfficePhone": "314-692-7200" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LotSizeAcres": 0.0689 +"LotSizeDimensions": "40 X 70" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "241 - Maplewood-Rchmnd Hts" +"MajorChangeTimestamp": "2025-07-09T06:30:57Z" +"MiddleOrJuniorSchool": "Mrh Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-09" +"OriginalEntryTimestamp": "2025-07-08T16:27:22Z" +"OriginalListPrice": 175000 +"OwnershipType": "Private" +"ParcelNumber": "21J-23-1152" +"ParkingFeatures": array:2 [ 0 => "Driveway" 1 => "Off Street" ] +"PatioAndPorchFeatures": array:3 [ 0 => "Covered" 1 => "Rear Porch" 2 => "Screened" ] +"PhotosChangeTimestamp": "2025-07-08T16:29:39Z" +"PhotosCount": 17 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PropertyCondition": array:1 [ 0 => "Fixer" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Combination Lock Box" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-09T06:30:57Z" +"StreetName": "Lyle" +"StreetNumber": "2622" +"StreetNumberNumeric": "2622" +"StreetSuffix": "Avenue" +"StructureType": array:1 [ 0 => "House" ] +"SubdivisionName": "Floria Place" +"TaxAnnualAmount": "2922" +"TaxYear": "2024" +"Township": "Maplewood" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_PoolYN": "0" +"MIS_Section": "MAPLEWOOD" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "175000.00" +"MIS_PreviousStatus": "Coming Soon" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "2" +"MIS_MainLevelBathroomsFull": "0" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203736125')" +"provider_name": "MARIS" +"Media": array:17 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "686d46ffb4079c6f2ee66c62" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/7fe7742f320faac10725ccc0eb3983b1.webp" "MediaSize" => 71360 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-7fe7742f320faac10725ccc0eb3983b1.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-08T16:27:42.895Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "686d46ffb4079c6f2ee66c63" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/0e224d44dc93c41e4ef3c86cbc341c1f.webp" "MediaSize" => 86028 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-0e224d44dc93c41e4ef3c86cbc341c1f.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.895Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "686d46ffb4079c6f2ee66c64" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/e372a06bacb7dfe96bd4d91cdf380838.webp" "MediaSize" => 57769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-e372a06bacb7dfe96bd4d91cdf380838.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.896Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "686d46ffb4079c6f2ee66c65" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/ff2234487ac8f49c0f062b9bdd85b3dd.webp" "MediaSize" => 57769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-ff2234487ac8f49c0f062b9bdd85b3dd.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.864Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "686d46ffb4079c6f2ee66c67" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/3dceb404967539ef44b887cca81725ce.webp" "MediaSize" => 39591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-3dceb404967539ef44b887cca81725ce.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:43.297Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "686d46ffb4079c6f2ee66c68" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/81aaf6bba9cd4c997e089dab3578a838.webp" "MediaSize" => 41330 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-81aaf6bba9cd4c997e089dab3578a838.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "686d46ffb4079c6f2ee66c69" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/38e1e982aff228d80584a7ae3c08c271.webp" "MediaSize" => 37690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-38e1e982aff228d80584a7ae3c08c271.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "686d46ffb4079c6f2ee66c6a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/18385398ff28c068c74ccc9c4723c4eb.webp" "MediaSize" => 38380 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-18385398ff28c068c74ccc9c4723c4eb.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.868Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "686d46ffb4079c6f2ee66c6c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/c9d2ac75823033c97ad49a764ab5a50b.webp" "MediaSize" => 39591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-c9d2ac75823033c97ad49a764ab5a50b.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "686d46ffb4079c6f2ee66c6d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/5f08d694c53ca3de825d8629c0774137.webp" "MediaSize" => 69412 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-5f08d694c53ca3de825d8629c0774137.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "686d46ffb4079c6f2ee66c6e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/731339191b29f382d7c1d0082c82b65f.webp" "MediaSize" => 46431 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-731339191b29f382d7c1d0082c82b65f.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.851Z" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "686d46ffb4079c6f2ee66c6f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/3f1b5eee8fc9b9ea3b7574a1e17af4fa.webp" "MediaSize" => 29128 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-3f1b5eee8fc9b9ea3b7574a1e17af4fa.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "686d46ffb4079c6f2ee66c70" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/03f7ddcbcd7a152c8be17c9977044537.webp" "MediaSize" => 27920 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-03f7ddcbcd7a152c8be17c9977044537.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "686d46ffb4079c6f2ee66c71" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/0bb9ad6b1731361bd947780110a26a34.webp" "MediaSize" => 37057 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-0bb9ad6b1731361bd947780110a26a34.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.856Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "686d46ffb4079c6f2ee66c72" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/8b7cabbe477f48023748796cbccbf659.webp" "MediaSize" => 26649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-8b7cabbe477f48023748796cbccbf659.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "686d46ffb4079c6f2ee66c73" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/07a84fc19402c95db32566f2764f2fdc.webp" "MediaSize" => 29330 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-07a84fc19402c95db32566f2764f2fdc.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.851Z" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "686d46ffb4079c6f2ee66c74" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/3cbafff052b865593d2eb8991ff4c2c8.webp" "MediaSize" => 40712 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-3cbafff052b865593d2eb8991ff4c2c8.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.889Z" ] ] +"ID": "24201" }
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 'MIS203736125'/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 'MIS203736125'&$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 'MIS203736125'/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 'MIS203736125'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2834 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "24201" +post_author: 1 +"ListingKey": "MIS203736125" +"ListingId": "25046919" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-11T22:27:38Z" +"RFModificationTimestamp": "2025-07-11T22:28:54.446596+00:00" +"ListPrice": 175000.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Maplewood" +"PostalCode": "63143" +"UnparsedAddress": "2622 Lyle Avenue, None, Missouri 63143" +"Coordinates": array:2 [ 0 => -90.321443 1 => 38.613933 ] +"Latitude": 38.613933 +"Longitude": -90.321443 +"YearBuilt": 1912 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Jane Spooner" +"ListOfficeName": "RedKey Realty Leaders" +"ListAgentMlsId": "JSPOONER" +"ListOfficeMlsId": "RDKY02" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "FIXER UPPER WITH GREAT POTENTIAL! Opportunity knocks in a prime Maplewood location! This 2-bedroom, 1-bath home is a true fixer-upper with endless potential—perfect for investors, rehabbers, or anyone looking to create their dream home. Just steps from the heart of downtown Maplewood, you can stroll to shops, restaurants, breweries and all the charm this vibrant community offers. The home needs work but could be a real gem with the right vision and updates. Don’t miss your chance to get into this sought-after area at an affordable price. Property to be sold as-is—seller will do no repairs or inspections." +"AboveGradeFinishedArea": 1092 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:3 [ 0 => "Portable Dishwasher" 1 => "Built-In Electric Range" 2 => "Refrigerator" ] +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"Basement": array:5 [ 0 => "Full" 1 => "Interior Entry" 2 => "Storage Space" 3 => "Unfinished" 4 => "Walk-Up Access" ] +"BasementYN": true +"BathroomsFull": 1 +"Cooling": array:3 [ 0 => "Ceiling Fan(s)" 1 => "Central Air" 2 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-07-08T16:28:34.502682+00:00" +"CrossStreet": "Manchester" +"CumulativeDaysOnMarket": 2 +"DaysOnMarket": 6 +"Directions": "Manchester Rd to north on Lyle" +"Disclosures": array:2 [ 0 => "Flood Plain No" 1 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-07-11T22:27:38Z" +"ElementarySchool": "Mrh Elementary" +"ExteriorFeatures": array:1 [ 0 => "Private Yard" ] +"Fencing": array:1 [ 0 => "Partial" ] +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Maplewood-Richmond Hgts. High" +"HighSchoolDistrict": "Maplewood-Richmond Heights" +"InteriorFeatures": array:4 [ 0 => "Ceiling Fan(s)" 1 => "High Ceilings" 2 => "Laminate Counters" 3 => "Soaking Tub" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "In Basement" ] +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "8529" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "24861430" +"ListOfficePhone": "314-692-7200" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LotSizeAcres": 0.0689 +"LotSizeDimensions": "40 X 70" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "241 - Maplewood-Rchmnd Hts" +"MajorChangeTimestamp": "2025-07-09T06:30:57Z" +"MiddleOrJuniorSchool": "Mrh Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-09" +"OriginalEntryTimestamp": "2025-07-08T16:27:22Z" +"OriginalListPrice": 175000 +"OwnershipType": "Private" +"ParcelNumber": "21J-23-1152" +"ParkingFeatures": array:2 [ 0 => "Driveway" 1 => "Off Street" ] +"PatioAndPorchFeatures": array:3 [ 0 => "Covered" 1 => "Rear Porch" 2 => "Screened" ] +"PhotosChangeTimestamp": "2025-07-08T16:29:39Z" +"PhotosCount": 17 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PropertyCondition": array:1 [ 0 => "Fixer" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Combination Lock Box" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-09T06:30:57Z" +"StreetName": "Lyle" +"StreetNumber": "2622" +"StreetNumberNumeric": "2622" +"StreetSuffix": "Avenue" +"StructureType": array:1 [ 0 => "House" ] +"SubdivisionName": "Floria Place" +"TaxAnnualAmount": "2922" +"TaxYear": "2024" +"Township": "Maplewood" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_PoolYN": "0" +"MIS_Section": "MAPLEWOOD" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "175000.00" +"MIS_PreviousStatus": "Coming Soon" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "2" +"MIS_MainLevelBathroomsFull": "0" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203736125')" +"provider_name": "MARIS" +"Media": array:17 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "686d46ffb4079c6f2ee66c62" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/7fe7742f320faac10725ccc0eb3983b1.webp" "MediaSize" => 71360 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-7fe7742f320faac10725ccc0eb3983b1.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-08T16:27:42.895Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "686d46ffb4079c6f2ee66c63" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/0e224d44dc93c41e4ef3c86cbc341c1f.webp" "MediaSize" => 86028 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-0e224d44dc93c41e4ef3c86cbc341c1f.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.895Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "686d46ffb4079c6f2ee66c64" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/e372a06bacb7dfe96bd4d91cdf380838.webp" "MediaSize" => 57769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-e372a06bacb7dfe96bd4d91cdf380838.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.896Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "686d46ffb4079c6f2ee66c65" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/ff2234487ac8f49c0f062b9bdd85b3dd.webp" "MediaSize" => 57769 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-ff2234487ac8f49c0f062b9bdd85b3dd.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.864Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "686d46ffb4079c6f2ee66c67" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/3dceb404967539ef44b887cca81725ce.webp" "MediaSize" => 39591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-3dceb404967539ef44b887cca81725ce.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:43.297Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "686d46ffb4079c6f2ee66c68" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/81aaf6bba9cd4c997e089dab3578a838.webp" "MediaSize" => 41330 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-81aaf6bba9cd4c997e089dab3578a838.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "686d46ffb4079c6f2ee66c69" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/38e1e982aff228d80584a7ae3c08c271.webp" "MediaSize" => 37690 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-38e1e982aff228d80584a7ae3c08c271.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "686d46ffb4079c6f2ee66c6a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/18385398ff28c068c74ccc9c4723c4eb.webp" "MediaSize" => 38380 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-18385398ff28c068c74ccc9c4723c4eb.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.868Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "686d46ffb4079c6f2ee66c6c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/c9d2ac75823033c97ad49a764ab5a50b.webp" "MediaSize" => 39591 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-c9d2ac75823033c97ad49a764ab5a50b.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "686d46ffb4079c6f2ee66c6d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/5f08d694c53ca3de825d8629c0774137.webp" "MediaSize" => 69412 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-5f08d694c53ca3de825d8629c0774137.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "686d46ffb4079c6f2ee66c6e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/731339191b29f382d7c1d0082c82b65f.webp" "MediaSize" => 46431 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-731339191b29f382d7c1d0082c82b65f.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.851Z" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "686d46ffb4079c6f2ee66c6f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/3f1b5eee8fc9b9ea3b7574a1e17af4fa.webp" "MediaSize" => 29128 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-3f1b5eee8fc9b9ea3b7574a1e17af4fa.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "686d46ffb4079c6f2ee66c70" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/03f7ddcbcd7a152c8be17c9977044537.webp" "MediaSize" => 27920 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-03f7ddcbcd7a152c8be17c9977044537.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "686d46ffb4079c6f2ee66c71" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/0bb9ad6b1731361bd947780110a26a34.webp" "MediaSize" => 37057 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-0bb9ad6b1731361bd947780110a26a34.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.856Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "686d46ffb4079c6f2ee66c72" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/8b7cabbe477f48023748796cbccbf659.webp" "MediaSize" => 26649 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-8b7cabbe477f48023748796cbccbf659.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.849Z" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "686d46ffb4079c6f2ee66c73" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/07a84fc19402c95db32566f2764f2fdc.webp" "MediaSize" => 29330 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-07a84fc19402c95db32566f2764f2fdc.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.851Z" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "686d46ffb4079c6f2ee66c74" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/3cbafff052b865593d2eb8991ff4c2c8.webp" "MediaSize" => 40712 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203736125/thumbnail-3cbafff052b865593d2eb8991ff4c2c8.webp" "ImageWidth" => 640 "ImageHeight" => 480 "MediaCategory" => "Photo" "ImageSizeDescription" => "640x480" "MediaModificationTimestamp" => "2025-07-08T16:27:42.889Z" ] ] +"ID": "24201" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.25 seconds" ] ]