Great opportunity! Brick home, level lot, spacious rooms and so much more! This property is offered in its current AS IS condition; all utilities are turned off.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "21163" +post_author: 1 +"ListingKey": "MIS203332937" +"ListingId": "25038572" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-03T17:06:38Z" +"RFModificationTimestamp": "2025-06-03T17:13:11.345788+00:00" +"ListPrice": 33000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Northwoods" +"PostalCode": "63121" +"UnparsedAddress": "3832 Avondale Avenue, Northwoods, Missouri 63121" +"Coordinates": array:2 [ 0 => -90.281145 1 => 38.699356 ] +"Latitude": 38.699356 +"Longitude": -90.281145 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joseph LoPiccolo" +"ListOfficeName": "American Realty Group" +"ListAgentMlsId": "JLOPICCO" +"ListOfficeMlsId": "AMRG01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Great opportunity! Brick home, level lot, spacious rooms and so much more! This property is offered in its current AS IS condition; all utilities are turned off." +"AboveGradeFinishedArea": 1560 +"AboveGradeFinishedAreaSource": "Appraiser" +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "None" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-03T17:12:45.192833+00:00" +"DevelopmentStatus": array:1 [ 0 => "Other" ] +"Disclosures": array:1 [ 0 => "Lead Paint" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-03T17:06:38Z" +"DocumentsCount": 5 +"ElementarySchool": "Barack Obama Elementary School" +"FireplaceFeatures": array:1 [ 0 => "None" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ 0 => "None" ] +"HighSchool": "Normandy High" +"HighSchoolDistrict": "Normandy" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "17678" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "2070" +"ListOfficePhone": "314-416-4288" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA" +"LotFeatures": array:1 [ 0 => "Back Yard" ] +"LotSizeAcres": 0.1267 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "106 - Normandy" +"MajorChangeTimestamp": "2025-06-03T17:05:37Z" +"MiddleOrJuniorSchool": "Barack Obama Middle School" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-06-03" +"OriginalEntryTimestamp": "2025-06-03T17:05:37Z" +"OriginalListPrice": 33000 +"OwnershipType": "Government" +"ParcelNumber": "15H-62-1452" +"PhotosChangeTimestamp": "2025-06-03T17:06:38Z" +"PhotosCount": 20 +"RoomsTotal": "7" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Combination Lock Box" 1 => "Show at Will" 2 => "Showing Service" ] +"SpecialListingConditions": array:2 [ 0 => "HUD Owned" 1 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-06-03T17:05:37Z" +"StreetName": "Avondale" +"StreetNumber": "3832" +"StreetNumberNumeric": "3832" +"StreetSuffix": "Avenue" +"SubdivisionName": "Kenwood Park" +"TaxAnnualAmount": "1433" +"TaxYear": "2024" +"Township": "Northwoods" +"MIS_PoolYN": "0" +"MIS_Section": "NORTHWOODS" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "33000.00" +"MIS_EfficiencyYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "4" +"MIS_MainLevelBathroomsFull": "0" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "1" +"MIS_MainAndUpperLevelBedrooms": "4" +"MIS_MainAndUpperLevelBathrooms": "2" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203332937')" +"provider_name": "MARIS" +"short_address": "Northwoods, Missouri 63121, USA" +"Media": array:20 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "683f2b6890b95007c6d7177a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/594aaafa032358db2c7383634905ce77.webp" "MediaSize" => 135471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-594aaafa032358db2c7383634905ce77.webp" "ImageWidth" => 1024 "ImageHeight" => 733 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x733" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "683f2b6890b95007c6d7177b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/093cef8f5bbb1e6bb470f79de9003fd2.webp" "MediaSize" => 148913 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-093cef8f5bbb1e6bb470f79de9003fd2.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.838Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "683f2b6890b95007c6d7177c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/ed1d70936116579cc0828e7c8fbd3afc.webp" "MediaSize" => 219257 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-ed1d70936116579cc0828e7c8fbd3afc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.847Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "683f2b6890b95007c6d7177d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/a1f7ce60f7c2c252383c2b0d897c9553.webp" "MediaSize" => 227850 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-a1f7ce60f7c2c252383c2b0d897c9553.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "683f2b6890b95007c6d7177e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/fd615bf9a93fe784b72bd89a3cc4d784.webp" "MediaSize" => 172612 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-fd615bf9a93fe784b72bd89a3cc4d784.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.905Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "683f2b6890b95007c6d7177f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/6114eeff6b73dd7353f2d51737c9dc86.webp" "MediaSize" => 78280 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-6114eeff6b73dd7353f2d51737c9dc86.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.834Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "683f2b6890b95007c6d71780" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/c537944a8242fda5a130712b18801959.webp" "MediaSize" => 69532 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-c537944a8242fda5a130712b18801959.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.798Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "683f2b6890b95007c6d71781" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/a4a4af22e860dc5890d6568e18595972.webp" "MediaSize" => 106847 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-a4a4af22e860dc5890d6568e18595972.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "683f2b6890b95007c6d71782" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/21e2f52ac1557f5c9efd4d326aeea113.webp" "MediaSize" => 95059 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-21e2f52ac1557f5c9efd4d326aeea113.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "683f2b6890b95007c6d71783" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/de8a88eb28ab93fa1204f6692712babd.webp" "MediaSize" => 138487 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-de8a88eb28ab93fa1204f6692712babd.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "683f2b6890b95007c6d71784" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/b73414640cdf785b890c94f9194af998.webp" "MediaSize" => 69313 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-b73414640cdf785b890c94f9194af998.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.815Z" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "683f2b6890b95007c6d71785" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/ce794d7b10d0d345f12a5cd9294fdc2b.webp" "MediaSize" => 83956 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-ce794d7b10d0d345f12a5cd9294fdc2b.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.778Z" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "683f2b6890b95007c6d71786" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/d8038ef88d7f75a63fa5319e329863a9.webp" "MediaSize" => 59836 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-d8038ef88d7f75a63fa5319e329863a9.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "683f2b6890b95007c6d71787" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/87aefce4380cbb4f663263e620e59e83.webp" "MediaSize" => 59288 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-87aefce4380cbb4f663263e620e59e83.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.842Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "683f2b6890b95007c6d71788" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/11ce064555c2127c35f9cb59b97127be.webp" "MediaSize" => 73328 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-11ce064555c2127c35f9cb59b97127be.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "683f2b6890b95007c6d71789" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/8b0ba9963da586a61e99fe604bb4956e.webp" "MediaSize" => 66699 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-8b0ba9963da586a61e99fe604bb4956e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "683f2b6890b95007c6d7178a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/f0a506522b47c7e32fba2039cdb6639e.webp" "MediaSize" => 44594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-f0a506522b47c7e32fba2039cdb6639e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "683f2b6890b95007c6d7178b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/f9e484702284c7a0248f7771a72bfb7d.webp" "MediaSize" => 65626 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-f9e484702284c7a0248f7771a72bfb7d.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.842Z" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "683f2b6890b95007c6d7178c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/59b14d30f1a052c963ef90e56c97e876.webp" "MediaSize" => 99530 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-59b14d30f1a052c963ef90e56c97e876.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.829Z" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "683f2b6890b95007c6d7178d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/dfb2e19925dfc3bc92b548c8f72d13d6.webp" "MediaSize" => 105614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-dfb2e19925dfc3bc92b548c8f72d13d6.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.799Z" ] ] +"ID": "21163" }
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 'MIS203332937'/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 'MIS203332937'&$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 'MIS203332937'/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 'MIS203332937'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2833 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "21163" +post_author: 1 +"ListingKey": "MIS203332937" +"ListingId": "25038572" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-06-03T17:06:38Z" +"RFModificationTimestamp": "2025-06-03T17:13:11.345788+00:00" +"ListPrice": 33000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0 +"LivingArea": 0 +"BuildingAreaTotal": 0 +"City": "Northwoods" +"PostalCode": "63121" +"UnparsedAddress": "3832 Avondale Avenue, Northwoods, Missouri 63121" +"Coordinates": array:2 [ 0 => -90.281145 1 => 38.699356 ] +"Latitude": 38.699356 +"Longitude": -90.281145 +"YearBuilt": 1927 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Joseph LoPiccolo" +"ListOfficeName": "American Realty Group" +"ListAgentMlsId": "JLOPICCO" +"ListOfficeMlsId": "AMRG01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Great opportunity! Brick home, level lot, spacious rooms and so much more! This property is offered in its current AS IS condition; all utilities are turned off." +"AboveGradeFinishedArea": 1560 +"AboveGradeFinishedAreaSource": "Appraiser" +"ArchitecturalStyle": array:1 [ 0 => "Other" ] +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:1 [ 0 => "None" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-03T17:12:45.192833+00:00" +"DevelopmentStatus": array:1 [ 0 => "Other" ] +"Disclosures": array:1 [ 0 => "Lead Paint" ] +"DocumentsAvailable": array:1 [ 0 => "Lead Based Paint" ] +"DocumentsChangeTimestamp": "2025-06-03T17:06:38Z" +"DocumentsCount": 5 +"ElementarySchool": "Barack Obama Elementary School" +"FireplaceFeatures": array:1 [ 0 => "None" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:1 [ 0 => "None" ] +"HighSchool": "Normandy High" +"HighSchoolDistrict": "Normandy" +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "17678" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "2070" +"ListOfficePhone": "314-416-4288" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA" +"LotFeatures": array:1 [ 0 => "Back Yard" ] +"LotSizeAcres": 0.1267 +"LotSizeSource": "Public Records" +"MLSAreaMajor": "106 - Normandy" +"MajorChangeTimestamp": "2025-06-03T17:05:37Z" +"MiddleOrJuniorSchool": "Barack Obama Middle School" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-06-03" +"OriginalEntryTimestamp": "2025-06-03T17:05:37Z" +"OriginalListPrice": 33000 +"OwnershipType": "Government" +"ParcelNumber": "15H-62-1452" +"PhotosChangeTimestamp": "2025-06-03T17:06:38Z" +"PhotosCount": 20 +"RoomsTotal": "7" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Combination Lock Box" 1 => "Show at Will" 2 => "Showing Service" ] +"SpecialListingConditions": array:2 [ 0 => "HUD Owned" 1 => "Listing As Is" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-06-03T17:05:37Z" +"StreetName": "Avondale" +"StreetNumber": "3832" +"StreetNumberNumeric": "3832" +"StreetSuffix": "Avenue" +"SubdivisionName": "Kenwood Park" +"TaxAnnualAmount": "1433" +"TaxYear": "2024" +"Township": "Northwoods" +"MIS_PoolYN": "0" +"MIS_Section": "NORTHWOODS" +"MIS_AuctionYN": "0" +"MIS_RoomCount": "0" +"MIS_CurrentPrice": "33000.00" +"MIS_EfficiencyYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "4" +"MIS_MainLevelBathroomsFull": "0" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "1" +"MIS_MainAndUpperLevelBedrooms": "4" +"MIS_MainAndUpperLevelBathrooms": "2" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203332937')" +"provider_name": "MARIS" +"short_address": "Northwoods, Missouri 63121, USA" +"Media": array:20 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "683f2b6890b95007c6d7177a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/594aaafa032358db2c7383634905ce77.webp" "MediaSize" => 135471 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-594aaafa032358db2c7383634905ce77.webp" "ImageWidth" => 1024 "ImageHeight" => 733 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x733" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "683f2b6890b95007c6d7177b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/093cef8f5bbb1e6bb470f79de9003fd2.webp" "MediaSize" => 148913 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-093cef8f5bbb1e6bb470f79de9003fd2.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.838Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "683f2b6890b95007c6d7177c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/ed1d70936116579cc0828e7c8fbd3afc.webp" "MediaSize" => 219257 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-ed1d70936116579cc0828e7c8fbd3afc.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.847Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "683f2b6890b95007c6d7177d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/a1f7ce60f7c2c252383c2b0d897c9553.webp" "MediaSize" => 227850 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-a1f7ce60f7c2c252383c2b0d897c9553.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "683f2b6890b95007c6d7177e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/fd615bf9a93fe784b72bd89a3cc4d784.webp" "MediaSize" => 172612 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-fd615bf9a93fe784b72bd89a3cc4d784.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.905Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "683f2b6890b95007c6d7177f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/6114eeff6b73dd7353f2d51737c9dc86.webp" "MediaSize" => 78280 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-6114eeff6b73dd7353f2d51737c9dc86.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.834Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "683f2b6890b95007c6d71780" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/c537944a8242fda5a130712b18801959.webp" "MediaSize" => 69532 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-c537944a8242fda5a130712b18801959.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.798Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "683f2b6890b95007c6d71781" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/a4a4af22e860dc5890d6568e18595972.webp" "MediaSize" => 106847 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-a4a4af22e860dc5890d6568e18595972.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "683f2b6890b95007c6d71782" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/21e2f52ac1557f5c9efd4d326aeea113.webp" "MediaSize" => 95059 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-21e2f52ac1557f5c9efd4d326aeea113.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "683f2b6890b95007c6d71783" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/de8a88eb28ab93fa1204f6692712babd.webp" "MediaSize" => 138487 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-de8a88eb28ab93fa1204f6692712babd.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "683f2b6890b95007c6d71784" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/b73414640cdf785b890c94f9194af998.webp" "MediaSize" => 69313 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-b73414640cdf785b890c94f9194af998.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.815Z" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "683f2b6890b95007c6d71785" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/ce794d7b10d0d345f12a5cd9294fdc2b.webp" "MediaSize" => 83956 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-ce794d7b10d0d345f12a5cd9294fdc2b.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.778Z" ] 12 => array:11 [ "Order" => 12 "MediaKey" => "683f2b6890b95007c6d71786" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/d8038ef88d7f75a63fa5319e329863a9.webp" "MediaSize" => 59836 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-d8038ef88d7f75a63fa5319e329863a9.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 13 => array:11 [ "Order" => 13 "MediaKey" => "683f2b6890b95007c6d71787" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/87aefce4380cbb4f663263e620e59e83.webp" "MediaSize" => 59288 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-87aefce4380cbb4f663263e620e59e83.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.842Z" ] 14 => array:11 [ "Order" => 14 "MediaKey" => "683f2b6890b95007c6d71788" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/11ce064555c2127c35f9cb59b97127be.webp" "MediaSize" => 73328 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-11ce064555c2127c35f9cb59b97127be.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 15 => array:11 [ "Order" => 15 "MediaKey" => "683f2b6890b95007c6d71789" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/8b0ba9963da586a61e99fe604bb4956e.webp" "MediaSize" => 66699 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-8b0ba9963da586a61e99fe604bb4956e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 16 => array:11 [ "Order" => 16 "MediaKey" => "683f2b6890b95007c6d7178a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/f0a506522b47c7e32fba2039cdb6639e.webp" "MediaSize" => 44594 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-f0a506522b47c7e32fba2039cdb6639e.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.797Z" ] 17 => array:11 [ "Order" => 17 "MediaKey" => "683f2b6890b95007c6d7178b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/f9e484702284c7a0248f7771a72bfb7d.webp" "MediaSize" => 65626 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-f9e484702284c7a0248f7771a72bfb7d.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.842Z" ] 18 => array:11 [ "Order" => 18 "MediaKey" => "683f2b6890b95007c6d7178c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/59b14d30f1a052c963ef90e56c97e876.webp" "MediaSize" => 99530 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-59b14d30f1a052c963ef90e56c97e876.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.829Z" ] 19 => array:11 [ "Order" => 19 "MediaKey" => "683f2b6890b95007c6d7178d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/dfb2e19925dfc3bc92b548c8f72d13d6.webp" "MediaSize" => 105614 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203332937/thumbnail-dfb2e19925dfc3bc92b548c8f72d13d6.webp" "ImageWidth" => 1024 "ImageHeight" => 768 "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x768" "MediaModificationTimestamp" => "2025-06-03T17:05:44.799Z" ] ] +"ID": "21163" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.14 seconds" ] ]