Investor Special! This 2-bedroom, 1-bath bungalow with a 1-car detached garage is being sold as-is and offers a fantastic opportunity to add value. Whether you’re looking to renovate and flip or add to your rental portfolio, this property is full of potential. Great layout, solid structure, and located in an area with strong rental demand. Don’t miss this affordable investment opportunity—bring your vision and turn this diamond in the rough into a cash-flowing asset!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "25589" +post_author: 1 +"ListingKey": "MIS203994968" +"ListingId": "25052333" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-30T00:59:38Z" +"RFModificationTimestamp": "2025-07-30T01:04:44Z" +"ListPrice": 49900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63136" +"UnparsedAddress": "5935 Garesche Avenue, St Louis, Missouri 63136" +"Coordinates": array:2 [ 0 => -90.255154 1 => 38.703221 ] +"Latitude": 38.703221 +"Longitude": -90.255154 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Samona Washington" +"ListOfficeName": "The Hermann London Group LLC" +"ListAgentMlsId": "SAWASHIN" +"ListOfficeMlsId": "HRLG01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Investor Special! This 2-bedroom, 1-bath bungalow with a 1-car detached garage is being sold as-is and offers a fantastic opportunity to add value. Whether you're looking to renovate and flip or add to your rental portfolio, this property is full of potential. Great layout, solid structure, and located in an area with strong rental demand. Don’t miss this affordable investment opportunity—bring your vision and turn this diamond in the rough into a cash-flowing asset!" +"AboveGradeFinishedArea": 672 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Other" ] +"Cooling": array:1 [ 0 => "None" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-30T01:04:26.544308+00:00" +"Directions": "GPS Friendly" +"Disclosures": array:1 [ 0 => "Lead Paint" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-07-30T00:59:38Z" +"DocumentsCount": 2 +"ElementarySchool": "Herzog Elem." +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ 0 => "Other" ] +"HighSchool": "Vashon High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "19048" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "4748574" +"ListOfficePhone": "314-802-0797" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,Other" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.0717 +"LotSizeDimensions": "25x125" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "5 - North" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-07-30T00:58:33Z" +"MiddleOrJuniorSchool": "Yeatman-Liddell Middle School" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-29" +"OriginalEntryTimestamp": "2025-07-30T00:58:33Z" +"OriginalListPrice": 49900 +"OwnershipType": "Private" +"ParcelNumber": "5356-00-0250-0" +"ParkingFeatures": array:2 [ 0 => "Detached" 1 => "Off Street" ] +"PatioAndPorchFeatures": array:1 [ 0 => "Covered" ] +"PhotosChangeTimestamp": "2025-07-30T00:59:38Z" +"PhotosCount": 18 +"Possession": array:1 [ 0 => "Negotiable" ] +"PostalCodePlus4": "4701" +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "314-800-7063" +"ShowingContactType": array:1 [ 0 => "Showing Service" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Vacant" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-30T00:58:33Z" +"StreetName": "Garesche" +"StreetNumber": "5935" +"StreetNumberNumeric": "5935" +"StreetSuffix": "Avenue" +"SubdivisionName": "Walnut Park Add" +"TaxAnnualAmount": "142" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "49900.00" +"MIS_EfficiencyYN": "0" +"MIS_Neighborhood": "Walnut Park West" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203994968')" +"provider_name": "MARIS" +"short_address": "St Louis, Missouri 63136, USA" +"Media": array:18 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "68896e43477e61574b154efd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/342343523dd7d73f3eaa45c951a6750d.webp" "MediaSize" => 76081 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-342343523dd7d73f3eaa45c951a6750d.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of front facade with covered porch and a front yard" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.370Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "68896e43477e61574b154efe" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/c3e85a1668830f0887515f5fa68be035.webp" "MediaSize" => 49077 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-c3e85a1668830f0887515f5fa68be035.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished room featuring dark wood-style floors and baseboards" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.354Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "68896e43477e61574b154eff" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/e9d6244eac47202c167a5cd235f5bbb2.webp" "MediaSize" => 49980 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-e9d6244eac47202c167a5cd235f5bbb2.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.347Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "68896e43477e61574b154f00" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/ab62fdc912167c02b833a123083b06fa.webp" "MediaSize" => 48972 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-ab62fdc912167c02b833a123083b06fa.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring hardwood / wood-style floors, a ceiling fan, and a closet" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.369Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "68896e43477e61574b154f01" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/da57fdcc8e2a3a982960b62cfead9971.webp" "MediaSize" => 35239 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-da57fdcc8e2a3a982960b62cfead9971.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Bathroom with a shower with curtain and tile walls" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "68896e43477e61574b154f02" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/534b5ed563ffad722c96e4efda1bcd33.webp" "MediaSize" => 28524 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-534b5ed563ffad722c96e4efda1bcd33.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Half bath featuring vanity and toilet" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "68896e43477e61574b154f03" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/208865220230fd067fe2573b37c4c8e3.webp" "MediaSize" => 57303 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-208865220230fd067fe2573b37c4c8e3.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring blue cabinets, range, light countertops, and tile patterned floors" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "68896e43477e61574b154f04" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/88434616dc72b59c693623b92958871c.webp" "MediaSize" => 54283 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-88434616dc72b59c693623b92958871c.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring blue cabinetry, light floors, stove, and light countertops" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.377Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "68896e43477e61574b154f05" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/b34a1adf07971707326d1191728cbd61.webp" "MediaSize" => 57902 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-b34a1adf07971707326d1191728cbd61.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "68896e43477e61574b154f06" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/231bae53cace60b5dd4e4f40cbbbbc6b.webp" "MediaSize" => 46484 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-231bae53cace60b5dd4e4f40cbbbbc6b.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Spare room featuring plenty of natural light and wood finished floors" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.341Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "68896e43477e61574b154f07" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/241e886e086179f7910740803b1a841c.webp" "MediaSize" => 45816 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-241e886e086179f7910740803b1a841c.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.323Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "68896e43477e61574b154f08" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/0e6ac0cb5cd3d72f2893adf3aaaf5bf6.webp" "MediaSize" => 28584 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-0e6ac0cb5cd3d72f2893adf3aaaf5bf6.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Basement with heating unit" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "68896e43477e61574b154f09" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/905bfd60b92e5d3ba7e19065bed64a11.webp" "MediaSize" => 22224 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-905bfd60b92e5d3ba7e19065bed64a11.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Unfinished below grade area featuring water heater" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "68896e43477e61574b154f0a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/85b360102df3758f0b7a647bdc35d438.webp" "MediaSize" => 29349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-85b360102df3758f0b7a647bdc35d438.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Basement with electric panel" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.320Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "68896e43477e61574b154f0b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/7c428cbcb9d15a95c4d2d12890cc0e5d.webp" "MediaSize" => 33185 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-7c428cbcb9d15a95c4d2d12890cc0e5d.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of misc room" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.341Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "68896e43477e61574b154f0c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/8f9d491590ff85b6c8b924f3dd4e9d8e.webp" "MediaSize" => 38490 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-8f9d491590ff85b6c8b924f3dd4e9d8e.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of basement" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.345Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "68896e43477e61574b154f0d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/a7f3ae2eb2a66592a608aabfc03b08f4.webp" "MediaSize" => 71789 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-a7f3ae2eb2a66592a608aabfc03b08f4.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of side of home" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.370Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "68896e43477e61574b154f0e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/9c4572cd63f6edaf6bea2e5ead2023f2.webp" "MediaSize" => 68378 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-9c4572cd63f6edaf6bea2e5ead2023f2.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Rear view of property with a yard and a chimney" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.370Z" ] ] +"ID": "25589" }
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 'MIS203994968'/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 'MIS203994968'&$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 'MIS203994968'/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 'MIS203994968'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2836 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "25589" +post_author: 1 +"ListingKey": "MIS203994968" +"ListingId": "25052333" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-30T00:59:38Z" +"RFModificationTimestamp": "2025-07-30T01:04:44Z" +"ListPrice": 49900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63136" +"UnparsedAddress": "5935 Garesche Avenue, St Louis, Missouri 63136" +"Coordinates": array:2 [ 0 => -90.255154 1 => 38.703221 ] +"Latitude": 38.703221 +"Longitude": -90.255154 +"YearBuilt": 1928 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Samona Washington" +"ListOfficeName": "The Hermann London Group LLC" +"ListAgentMlsId": "SAWASHIN" +"ListOfficeMlsId": "HRLG01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Investor Special! This 2-bedroom, 1-bath bungalow with a 1-car detached garage is being sold as-is and offers a fantastic opportunity to add value. Whether you're looking to renovate and flip or add to your rental portfolio, this property is full of potential. Great layout, solid structure, and located in an area with strong rental demand. Don’t miss this affordable investment opportunity—bring your vision and turn this diamond in the rough into a cash-flowing asset!" +"AboveGradeFinishedArea": 672 +"AboveGradeFinishedAreaSource": "Public Records" +"ArchitecturalStyle": array:1 [ 0 => "Bungalow" ] +"Basement": array:1 [ 0 => "Full" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Other" ] +"Cooling": array:1 [ 0 => "None" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-30T01:04:26.544308+00:00" +"Directions": "GPS Friendly" +"Disclosures": array:1 [ 0 => "Lead Paint" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-07-30T00:59:38Z" +"DocumentsCount": 2 +"ElementarySchool": "Herzog Elem." +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ 0 => "Other" ] +"HighSchool": "Vashon High" +"HighSchoolDistrict": "St. Louis City" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "19048" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "4748574" +"ListOfficePhone": "314-802-0797" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,Other" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.0717 +"LotSizeDimensions": "25x125" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "5 - North" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-07-30T00:58:33Z" +"MiddleOrJuniorSchool": "Yeatman-Liddell Middle School" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-29" +"OriginalEntryTimestamp": "2025-07-30T00:58:33Z" +"OriginalListPrice": 49900 +"OwnershipType": "Private" +"ParcelNumber": "5356-00-0250-0" +"ParkingFeatures": array:2 [ 0 => "Detached" 1 => "Off Street" ] +"PatioAndPorchFeatures": array:1 [ 0 => "Covered" ] +"PhotosChangeTimestamp": "2025-07-30T00:59:38Z" +"PhotosCount": 18 +"Possession": array:1 [ 0 => "Negotiable" ] +"PostalCodePlus4": "4701" +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingContactPhone": "314-800-7063" +"ShowingContactType": array:1 [ 0 => "Showing Service" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Vacant" ] +"SpecialListingConditions": array:1 [ 0 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-30T00:58:33Z" +"StreetName": "Garesche" +"StreetNumber": "5935" +"StreetNumberNumeric": "5935" +"StreetSuffix": "Avenue" +"SubdivisionName": "Walnut Park Add" +"TaxAnnualAmount": "142" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "49900.00" +"MIS_EfficiencyYN": "0" +"MIS_Neighborhood": "Walnut Park West" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "2" +"MIS_MainAndUpperLevelBathrooms": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203994968')" +"provider_name": "MARIS" +"short_address": "St Louis, Missouri 63136, USA" +"Media": array:18 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "68896e43477e61574b154efd" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/342343523dd7d73f3eaa45c951a6750d.webp" "MediaSize" => 76081 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-342343523dd7d73f3eaa45c951a6750d.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of front facade with covered porch and a front yard" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.370Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "68896e43477e61574b154efe" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/c3e85a1668830f0887515f5fa68be035.webp" "MediaSize" => 49077 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-c3e85a1668830f0887515f5fa68be035.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished room featuring dark wood-style floors and baseboards" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.354Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "68896e43477e61574b154eff" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/e9d6244eac47202c167a5cd235f5bbb2.webp" "MediaSize" => 49980 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-e9d6244eac47202c167a5cd235f5bbb2.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.347Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "68896e43477e61574b154f00" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/ab62fdc912167c02b833a123083b06fa.webp" "MediaSize" => 48972 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-ab62fdc912167c02b833a123083b06fa.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished bedroom featuring hardwood / wood-style floors, a ceiling fan, and a closet" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.369Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "68896e43477e61574b154f01" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/da57fdcc8e2a3a982960b62cfead9971.webp" "MediaSize" => 35239 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-da57fdcc8e2a3a982960b62cfead9971.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Bathroom with a shower with curtain and tile walls" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "68896e43477e61574b154f02" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/534b5ed563ffad722c96e4efda1bcd33.webp" "MediaSize" => 28524 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-534b5ed563ffad722c96e4efda1bcd33.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Half bath featuring vanity and toilet" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "68896e43477e61574b154f03" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/208865220230fd067fe2573b37c4c8e3.webp" "MediaSize" => 57303 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-208865220230fd067fe2573b37c4c8e3.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring blue cabinets, range, light countertops, and tile patterned floors" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "68896e43477e61574b154f04" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/88434616dc72b59c693623b92958871c.webp" "MediaSize" => 54283 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-88434616dc72b59c693623b92958871c.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring blue cabinetry, light floors, stove, and light countertops" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.377Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "68896e43477e61574b154f05" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/b34a1adf07971707326d1191728cbd61.webp" "MediaSize" => 57902 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-b34a1adf07971707326d1191728cbd61.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "68896e43477e61574b154f06" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/231bae53cace60b5dd4e4f40cbbbbc6b.webp" "MediaSize" => 46484 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-231bae53cace60b5dd4e4f40cbbbbc6b.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Spare room featuring plenty of natural light and wood finished floors" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.341Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "68896e43477e61574b154f07" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/241e886e086179f7910740803b1a841c.webp" "MediaSize" => 45816 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-241e886e086179f7910740803b1a841c.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.323Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "68896e43477e61574b154f08" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/0e6ac0cb5cd3d72f2893adf3aaaf5bf6.webp" "MediaSize" => 28584 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-0e6ac0cb5cd3d72f2893adf3aaaf5bf6.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Basement with heating unit" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "68896e43477e61574b154f09" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/905bfd60b92e5d3ba7e19065bed64a11.webp" "MediaSize" => 22224 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-905bfd60b92e5d3ba7e19065bed64a11.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Unfinished below grade area featuring water heater" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.344Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "68896e43477e61574b154f0a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/85b360102df3758f0b7a647bdc35d438.webp" "MediaSize" => 29349 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-85b360102df3758f0b7a647bdc35d438.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Basement with electric panel" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.320Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "68896e43477e61574b154f0b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/7c428cbcb9d15a95c4d2d12890cc0e5d.webp" "MediaSize" => 33185 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-7c428cbcb9d15a95c4d2d12890cc0e5d.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of misc room" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.341Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "68896e43477e61574b154f0c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/8f9d491590ff85b6c8b924f3dd4e9d8e.webp" "MediaSize" => 38490 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-8f9d491590ff85b6c8b924f3dd4e9d8e.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of basement" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.345Z" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "68896e43477e61574b154f0d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/a7f3ae2eb2a66592a608aabfc03b08f4.webp" "MediaSize" => 71789 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-a7f3ae2eb2a66592a608aabfc03b08f4.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "View of side of home" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.370Z" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "68896e43477e61574b154f0e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/9c4572cd63f6edaf6bea2e5ead2023f2.webp" "MediaSize" => 68378 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203994968/thumbnail-9c4572cd63f6edaf6bea2e5ead2023f2.webp" "ImageWidth" => 480 "ImageHeight" => 640 "MediaCategory" => "Photo" "LongDescription" => "Rear view of property with a yard and a chimney" "ImageSizeDescription" => "480x640" "MediaModificationTimestamp" => "2025-07-30T00:58:43.370Z" ] ] +"ID": "25589" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.14 seconds" ] ]