Whether you’re looking for the perfect addition to your rental portfolio or a charming first home, this move-in-ready property checks all the boxes. Recent updates completed in 2024 include a new roof, expanded front porch, brand-new back deck, and a fresh privacy fence—ideal for relaxing or entertaining outdoors.
Inside, you’ll find fresh paint throughout, new kitchen cabinets, new laminate flooring, and a completely remodeled bathroom, offering a modern and stylish living space.
Located within walking distance to Joseph R. Leisure Park, plus nearby shops and restaurants, this home combines comfort, convenience, and value.
Don’t miss this opportunity—schedule your showing today!
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2838 +post_id: "25593" +post_author: 1 +"ListingKey": "MIS203957382" +"ListingId": "25051420" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-04T05:31:55Z" +"RFModificationTimestamp": "2025-08-04T05:33:50Z" +"ListPrice": 179900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 907.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63116" +"UnparsedAddress": "4712 Sigel Ave, St Louis, Missouri 63116" +"Coordinates": array:2 [ 0 => -90.278476 1 => 38.575693 ] +"Latitude": 38.575693 +"Longitude": -90.278476 +"YearBuilt": 1914 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alicia Metzger" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "AMETZGER" +"ListOfficeMlsId": "CBG11" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Whether you're looking for the perfect addition to your rental portfolio or a charming first home, this move-in-ready property checks all the boxes. Recent updates completed in 2024 include a new roof, expanded front porch, brand-new back deck, and a fresh privacy fence—ideal for relaxing or entertaining outdoors.\n Inside, you'll find fresh paint throughout, new kitchen cabinets, new laminate flooring, and a completely remodeled bathroom, offering a modern and stylish living space.\n Located within walking distance to Joseph R. Leisure Park, plus nearby shops and restaurants, this home combines comfort, convenience, and value.\n Don’t miss this opportunity—schedule your showing today! """ +"AboveGradeFinishedArea": 907 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:1 [ 0 => "Gas Cooktop" ] +"ArchitecturalStyle": array:2 [ 0 => "Bungalow" 1 => "Cottage" ] +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-25T20:46:56.046917+00:00" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 18 +"Disclosures": array:3 [ 0 => "Lead Paint" 1 => "Occupancy Permit Required" 2 => "See Seller's Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Other" ] +"DocumentsChangeTimestamp": "2025-07-25T21:06:38Z" +"DocumentsCount": 4 +"Electric": "Ameren" +"ElementarySchool": "Oak Hill Elem." +"ExteriorFeatures": array:2 [ 0 => "Other" 1 => "Private Yard" ] +"Fencing": array:2 [ 0 => "Back Yard" 1 => "Wood" ] +"FireplaceFeatures": array:1 [ 0 => "Decorative" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ 0 => "Vinyl" ] +"FoundationDetails": array:1 [ 0 => "Combination" ] +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Roosevelt High" +"HighSchoolDistrict": "St. Louis City" +"InteriorFeatures": array:1 [ 0 => "Eat-in Kitchen" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "85956407" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "822" +"ListOfficePhone": "636-394-9300" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ 0 => "Corner Lot" 1 => "Level" ] +"LotSizeAcres": 0.091 +"LotSizeDimensions": "30 x 125" +"MLSAreaMajor": "3 - South City" +"MajorChangeTimestamp": "2025-07-30T06:30:40Z" +"MiddleOrJuniorSchool": "Long Middle Community Ed. Center" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-30" +"OriginalEntryTimestamp": "2025-07-25T20:43:03Z" +"OriginalListPrice": 179900 +"ParcelNumber": "5537-00-0310-0" +"ParkingFeatures": array:1 [ 0 => "Parking Pad" ] +"PatioAndPorchFeatures": array:1 [ 0 => "Deck" ] +"PhotosChangeTimestamp": "2025-07-25T21:04:38Z" +"PhotosCount": 16 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"Roof": array:1 [ 0 => "Shingle" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-30T06:30:40Z" +"StreetName": "Sigel Ave" +"StreetNumber": "4712" +"StreetNumberNumeric": "4712" +"SubdivisionName": "Goethe" +"TaxAnnualAmount": "1404" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_RoomCount": "6" +"MIS_CurrentPrice": "179900.00" +"MIS_Neighborhood": "Bevo Mill" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Coming Soon" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "2" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"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('MIS203957382')" +"provider_name": "MARIS" +"Media": array:16 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6883f1302340c22d29df9a8d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/389774d9dd8273e3faf016ed276a74f8.webp" "MediaSize" => 129283 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-389774d9dd8273e3faf016ed276a74f8.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Colonial inspired home featuring stairway, a gambrel roof, covered porch, and a front yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.577Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6883f1302340c22d29df9a8e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/6487b509950819fea812221a0bebb707.webp" "MediaSize" => 102526 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-6487b509950819fea812221a0bebb707.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of wooden deck" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.348Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6883f1302340c22d29df9a8f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/b0f179c924022f8d7170b69d9fe1bf72.webp" "MediaSize" => 69697 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-b0f179c924022f8d7170b69d9fe1bf72.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Entrance foyer with arched walkways, ceiling fan, wood finished floors, recessed lighting, and stairs" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.369Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6883f1302340c22d29df9a90" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/add415fa3adf51fb2048d233ee6a6df0.webp" "MediaSize" => 71002 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-add415fa3adf51fb2048d233ee6a6df0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished living room with wood finished floors, recessed lighting, ceiling fan, arched walkways, and stairs" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.348Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6883f1302340c22d29df9a91" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/fec0ef769fa4f7ef20b6de447bac01aa.webp" "MediaSize" => 59607 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-fec0ef769fa4f7ef20b6de447bac01aa.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished living room with arched walkways, ceiling fan, recessed lighting, wood finished floors, and a lit fireplace" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.343Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6883f1302340c22d29df9a92" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/0c5f63c83e8c59c3b3cc898949989045.webp" "MediaSize" => 62517 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-0c5f63c83e8c59c3b3cc898949989045.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring white appliances, a wainscoted wall, arched walkways, white cabinets, and light wood-style floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.369Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6883f1302340c22d29df9a93" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/87e4b645a3c998ab9e3632a8afea56e7.webp" "MediaSize" => 62410 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-87e4b645a3c998ab9e3632a8afea56e7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished dining area with wainscoting, wood finished floors, and recessed lighting" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.371Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6883f1302340c22d29df9a94" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/a8898f07744816f77c1e0d42b1182f2a.webp" "MediaSize" => 82677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-a8898f07744816f77c1e0d42b1182f2a.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with white appliances, healthy amount of natural light, wood finished floors, white cabinetry, and recessed lighting" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.427Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6883f1302340c22d29df9a95" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/699130673f3863f314546d5236deaae0.webp" "MediaSize" => 48255 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-699130673f3863f314546d5236deaae0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Empty room featuring wood finished floors and a ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.425Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6883f1302340c22d29df9a96" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/1d792340c2df43fd4bc9b071e0fbd7b7.webp" "MediaSize" => 50933 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-1d792340c2df43fd4bc9b071e0fbd7b7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring vanity and a shower stall" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.379Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6883f1302340c22d29df9a97" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/c870ed5b94110ab45961a0de2cd82ab3.webp" "MediaSize" => 47108 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-c870ed5b94110ab45961a0de2cd82ab3.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Empty room with wood finished floors and a ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.345Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6883f1302340c22d29df9a98" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/2a2bd1faf1302fc95bf07780d7e7ae51.webp" "MediaSize" => 101548 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-2a2bd1faf1302fc95bf07780d7e7ae51.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Basement with stairs, gas water heater, and heating unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.347Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6883f1302340c22d29df9a99" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/1b53078a42cc8a2ad3763a30752ebb69.webp" "MediaSize" => 208608 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-1b53078a42cc8a2ad3763a30752ebb69.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Fenced backyard with a wooden deck" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.429Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6883f1302340c22d29df9a9a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/4036611c2ac2a4cd497cc2c5f758128f.webp" "MediaSize" => 156916 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-4036611c2ac2a4cd497cc2c5f758128f.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Wooden deck with a fenced backyard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.430Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "6883f1302340c22d29df9a9b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/d47c1f1ceb824300627faa4b80a4c1f2.webp" "MediaSize" => 165877 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-d47c1f1ceb824300627faa4b80a4c1f2.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Rear view of property featuring a fenced backyard and a deck" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.418Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "6883f1302340c22d29df9a9c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/575aac120d6980b410137a2c4c57d20b.webp" "MediaSize" => 117325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-575aac120d6980b410137a2c4c57d20b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front facade featuring stairway, a gambrel roof, covered porch, and a front yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.340Z" ] ] +"ID": "25593" }
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 'MIS203957382'/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 'MIS203957382'&$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 'MIS203957382'/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 'MIS203957382'&$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: "25593" +post_author: 1 +"ListingKey": "MIS203957382" +"ListingId": "25051420" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-08-04T05:31:55Z" +"RFModificationTimestamp": "2025-08-04T05:33:50Z" +"ListPrice": 179900.0 +"BathroomsTotalInteger": 1.0 +"BathroomsHalf": 0 +"BedroomsTotal": 2.0 +"LotSizeArea": 0 +"LivingArea": 907.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63116" +"UnparsedAddress": "4712 Sigel Ave, St Louis, Missouri 63116" +"Coordinates": array:2 [ 0 => -90.278476 1 => 38.575693 ] +"Latitude": 38.575693 +"Longitude": -90.278476 +"YearBuilt": 1914 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Alicia Metzger" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "AMETZGER" +"ListOfficeMlsId": "CBG11" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Whether you're looking for the perfect addition to your rental portfolio or a charming first home, this move-in-ready property checks all the boxes. Recent updates completed in 2024 include a new roof, expanded front porch, brand-new back deck, and a fresh privacy fence—ideal for relaxing or entertaining outdoors.\n Inside, you'll find fresh paint throughout, new kitchen cabinets, new laminate flooring, and a completely remodeled bathroom, offering a modern and stylish living space.\n Located within walking distance to Joseph R. Leisure Park, plus nearby shops and restaurants, this home combines comfort, convenience, and value.\n Don’t miss this opportunity—schedule your showing today! """ +"AboveGradeFinishedArea": 907 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:1 [ 0 => "Gas Cooktop" ] +"ArchitecturalStyle": array:2 [ 0 => "Bungalow" 1 => "Cottage" ] +"BathroomsFull": 1 +"ConstructionMaterials": array:1 [ 0 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St Louis City" +"CreationDate": "2025-07-25T20:46:56.046917+00:00" +"CumulativeDaysOnMarket": 5 +"DaysOnMarket": 18 +"Disclosures": array:3 [ 0 => "Lead Paint" 1 => "Occupancy Permit Required" 2 => "See Seller's Disclosure" ] +"DocumentsAvailable": array:1 [ 0 => "Other" ] +"DocumentsChangeTimestamp": "2025-07-25T21:06:38Z" +"DocumentsCount": 4 +"Electric": "Ameren" +"ElementarySchool": "Oak Hill Elem." +"ExteriorFeatures": array:2 [ 0 => "Other" 1 => "Private Yard" ] +"Fencing": array:2 [ 0 => "Back Yard" 1 => "Wood" ] +"FireplaceFeatures": array:1 [ 0 => "Decorative" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ 0 => "Vinyl" ] +"FoundationDetails": array:1 [ 0 => "Combination" ] +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Roosevelt High" +"HighSchoolDistrict": "St. Louis City" +"InteriorFeatures": array:1 [ 0 => "Eat-in Kitchen" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "85956407" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "822" +"ListOfficePhone": "636-394-9300" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Public Records" +"LotFeatures": array:2 [ 0 => "Corner Lot" 1 => "Level" ] +"LotSizeAcres": 0.091 +"LotSizeDimensions": "30 x 125" +"MLSAreaMajor": "3 - South City" +"MajorChangeTimestamp": "2025-07-30T06:30:40Z" +"MiddleOrJuniorSchool": "Long Middle Community Ed. Center" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-30" +"OriginalEntryTimestamp": "2025-07-25T20:43:03Z" +"OriginalListPrice": 179900 +"ParcelNumber": "5537-00-0310-0" +"ParkingFeatures": array:1 [ 0 => "Parking Pad" ] +"PatioAndPorchFeatures": array:1 [ 0 => "Deck" ] +"PhotosChangeTimestamp": "2025-07-25T21:04:38Z" +"PhotosCount": 16 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"Roof": array:1 [ 0 => "Shingle" ] +"RoomsTotal": "5" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-30T06:30:40Z" +"StreetName": "Sigel Ave" +"StreetNumber": "4712" +"StreetNumberNumeric": "4712" +"SubdivisionName": "Goethe" +"TaxAnnualAmount": "1404" +"TaxYear": "2024" +"Township": "St. Louis City" +"WaterSource": array:1 [ 0 => "Public" ] +"MIS_PoolYN": "0" +"MIS_RoomCount": "6" +"MIS_CurrentPrice": "179900.00" +"MIS_Neighborhood": "Bevo Mill" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Coming Soon" +"MIS_SecondMortgageYN": "0" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "2" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"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('MIS203957382')" +"provider_name": "MARIS" +"Media": array:16 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6883f1302340c22d29df9a8d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/389774d9dd8273e3faf016ed276a74f8.webp" "MediaSize" => 129283 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-389774d9dd8273e3faf016ed276a74f8.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Colonial inspired home featuring stairway, a gambrel roof, covered porch, and a front yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.577Z" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6883f1302340c22d29df9a8e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/6487b509950819fea812221a0bebb707.webp" "MediaSize" => 102526 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-6487b509950819fea812221a0bebb707.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of wooden deck" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.348Z" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6883f1302340c22d29df9a8f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/b0f179c924022f8d7170b69d9fe1bf72.webp" "MediaSize" => 69697 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-b0f179c924022f8d7170b69d9fe1bf72.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Entrance foyer with arched walkways, ceiling fan, wood finished floors, recessed lighting, and stairs" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.369Z" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6883f1302340c22d29df9a90" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/add415fa3adf51fb2048d233ee6a6df0.webp" "MediaSize" => 71002 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-add415fa3adf51fb2048d233ee6a6df0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished living room with wood finished floors, recessed lighting, ceiling fan, arched walkways, and stairs" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.348Z" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6883f1302340c22d29df9a91" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/fec0ef769fa4f7ef20b6de447bac01aa.webp" "MediaSize" => 59607 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-fec0ef769fa4f7ef20b6de447bac01aa.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished living room with arched walkways, ceiling fan, recessed lighting, wood finished floors, and a lit fireplace" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.343Z" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6883f1302340c22d29df9a92" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/0c5f63c83e8c59c3b3cc898949989045.webp" "MediaSize" => 62517 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-0c5f63c83e8c59c3b3cc898949989045.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen featuring white appliances, a wainscoted wall, arched walkways, white cabinets, and light wood-style floors" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.369Z" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6883f1302340c22d29df9a93" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/87e4b645a3c998ab9e3632a8afea56e7.webp" "MediaSize" => 62410 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-87e4b645a3c998ab9e3632a8afea56e7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Unfurnished dining area with wainscoting, wood finished floors, and recessed lighting" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.371Z" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6883f1302340c22d29df9a94" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/a8898f07744816f77c1e0d42b1182f2a.webp" "MediaSize" => 82677 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-a8898f07744816f77c1e0d42b1182f2a.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Kitchen with white appliances, healthy amount of natural light, wood finished floors, white cabinetry, and recessed lighting" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.427Z" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6883f1302340c22d29df9a95" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/699130673f3863f314546d5236deaae0.webp" "MediaSize" => 48255 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-699130673f3863f314546d5236deaae0.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Empty room featuring wood finished floors and a ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.425Z" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6883f1302340c22d29df9a96" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/1d792340c2df43fd4bc9b071e0fbd7b7.webp" "MediaSize" => 50933 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-1d792340c2df43fd4bc9b071e0fbd7b7.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Full bath featuring vanity and a shower stall" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.379Z" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6883f1302340c22d29df9a97" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/c870ed5b94110ab45961a0de2cd82ab3.webp" "MediaSize" => 47108 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-c870ed5b94110ab45961a0de2cd82ab3.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Empty room with wood finished floors and a ceiling fan" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.345Z" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6883f1302340c22d29df9a98" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/2a2bd1faf1302fc95bf07780d7e7ae51.webp" "MediaSize" => 101548 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-2a2bd1faf1302fc95bf07780d7e7ae51.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Basement with stairs, gas water heater, and heating unit" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.347Z" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6883f1302340c22d29df9a99" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/1b53078a42cc8a2ad3763a30752ebb69.webp" "MediaSize" => 208608 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-1b53078a42cc8a2ad3763a30752ebb69.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Fenced backyard with a wooden deck" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.429Z" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6883f1302340c22d29df9a9a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/4036611c2ac2a4cd497cc2c5f758128f.webp" "MediaSize" => 156916 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-4036611c2ac2a4cd497cc2c5f758128f.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Wooden deck with a fenced backyard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.430Z" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "6883f1302340c22d29df9a9b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/d47c1f1ceb824300627faa4b80a4c1f2.webp" "MediaSize" => 165877 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-d47c1f1ceb824300627faa4b80a4c1f2.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "Rear view of property featuring a fenced backyard and a deck" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.418Z" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "6883f1302340c22d29df9a9c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/575aac120d6980b410137a2c4c57d20b.webp" "MediaSize" => 117325 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203957382/thumbnail-575aac120d6980b410137a2c4c57d20b.webp" "ImageWidth" => 1024 "ImageHeight" => 682 "MediaCategory" => "Photo" "LongDescription" => "View of front facade featuring stairway, a gambrel roof, covered porch, and a front yard" "ImageSizeDescription" => "1024x682" "MediaModificationTimestamp" => "2025-07-25T21:03:44.340Z" ] ] +"ID": "25593" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.12 seconds" ] ]