Renovated home in Kirkwood. Newly refinished hardwood floors (2024). New carpet (2025). Fresh paint (2024). Luxury master suite with two walk-in closets and reading nooks. Updated gourmet kitchen with new quartz countertops (2025) and new stainless steel appliances (2024). Updated bathrooms (2024). New finished lower level (2025). New light fixtures and ceiling fans (2024). Recessed lighting. Swept and inspected wood-burning fireplace. New gutters (2024). All-brick exterior with new tuckpointing (2024). New landscaping (2024). New metal window wrapping (2024). New electrical panel (2024). New plumbing stack (2024). New HVAC (2024). New water heater (2024). Three-seasons room. Deck. Level fenced backyard. Large detatched garage. Walkable neighborhood. Quick access to 44, 270, and 64.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2835 +post_id: "18641" +post_author: 1 +"ListingKey": "MIS96297303" +"ListingId": "MIS25015794" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-29T00:53:26Z" +"RFModificationTimestamp": "2025-05-27T06:40:40.835533+00:00" +"ListPrice": 400000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.14 +"LivingArea": 2085.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63122" +"UnparsedAddress": "554 S Clay Avenue, St Louis, Missouri 63122" +"Coordinates": array:2 [ 0 => -90.40857 1 => 38.571925 ] +"Latitude": 38.571925 +"Longitude": -90.40857 +"YearBuilt": 1938 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shayne Sowers" +"ListOfficeName": "EXP Realty, LLC" +"ListAgentMlsId": "MISSSOWERS" +"ListOfficeMlsId": "MISEXRT01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Renovated home in Kirkwood. Newly refinished hardwood floors (2024). New carpet (2025). Fresh paint (2024). Luxury master suite with two walk-in closets and reading nooks. Updated gourmet kitchen with new quartz countertops (2025) and new stainless steel appliances (2024). Updated bathrooms (2024). New finished lower level (2025). New light fixtures and ceiling fans (2024). Recessed lighting. Swept and inspected wood-burning fireplace. New gutters (2024). All-brick exterior with new tuckpointing (2024). New landscaping (2024). New metal window wrapping (2024). New electrical panel (2024). New plumbing stack (2024). New HVAC (2024). New water heater (2024). Three-seasons room. Deck. Level fenced backyard. Large detatched garage. Walkable neighborhood. Quick access to 44, 270, and 64." +"AboveGradeFinishedArea": 1385 +"AboveGradeFinishedAreaSource": "Assessor" +"AboveGradeFinishedAreaUnits": "Square Feet" +"Appliances": array:1 [ 0 => "Gas Water Heater" ] +"ArchitecturalStyle": array:2 [ 0 => "Traditional" 1 => "Other" ] +"AssociationFeeFrequency": "None" +"Basement": array:3 [ 0 => "Full" 1 => "Partially Finished" 2 => "Sleeping Area" ] +"BasementYN": true +"BathroomsFull": 2 +"BelowGradeFinishedArea": 700 +"BelowGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaUnits": "Square Feet" +"BuyerOfficeAOR": "St. Louis Association of REALTORS" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-03-19T10:51:19.572912+00:00" +"CumulativeDaysOnMarket": 124 +"DaysOnMarket": 88 +"Disclosures": array:1 [ 0 => "Unknown" ] +"DocumentsChangeTimestamp": "2025-04-29T00:53:26Z" +"ElementarySchool": "W. W. Keysor Elem." +"FireplaceFeatures": array:3 [ 0 => "Recreation Room" 1 => "Wood Burning" 2 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ 0 => "Hardwood" ] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Kirkwood Sr. High" +"HighSchoolDistrict": "Kirkwood R-VII" +"InteriorFeatures": array:1 [ 0 => "Solid Surface Countertop(s)" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One and One Half" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "MIS12687" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "MIS54401897" +"ListOfficePhone": "866-2241761" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.14 +"LotSizeDimensions": "122x50" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 6098 +"MLSAreaMajor": "196 - Kirkwood" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-03-31T16:52:00Z" +"MiddleOrJuniorSchool": "North Kirkwood Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OffMarketDate": "2025-09-22" +"OnMarketDate": "2025-03-18" +"OriginalEntryTimestamp": "2025-03-19T02:47:57Z" +"OriginalListPrice": 425000 +"OtherStructures": array:1 [ 0 => "Garage(s)" ] +"OwnershipType": "Private" +"ParcelNumber": "24M-13-0738" +"ParkingFeatures": array:1 [ 0 => "Detached" ] +"ParkingTotal": "1" +"PhotosChangeTimestamp": "2025-04-29T00:53:26Z" +"PhotosCount": 12 +"Possession": array:1 [ 0 => "Negotiable" ] +"PostalCodePlus4": "5946" +"PreviousListPrice": 425000 +"RoadSurfaceType": array:1 [ 0 => "Asphalt" ] +"RoomsTotal": "8" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Appointment Only" 1 => "Showing Service" 2 => "Combination Lock Box" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-03-19T02:47:57Z" +"StreetDirPrefix": "S" +"StreetName": "Clay" +"StreetNumber": "554" +"StreetNumberNumeric": "554" +"StreetSuffix": "Avenue" +"SubdivisionName": "Zephyr Heights" +"TaxAnnualAmount": "3587" +"TaxLegalDescription": "ZEPHYR HEIGHTS LOT PT 12 N PT" +"TaxYear": "2024" +"Township": "Kirkwood" +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_Age": "87" +"MAR_BALL": "2" +"MAR_BEDD": "Main Floor Primary" +"MAR_BELL": "3" +"MAR_FRPL": "Living Room" +"MAR_HETS": "Gas" +"MAR_KITC": "Solid Surface Counter" +"MAR_LOWR": "0" +"MAR_LWFL": "0" +"MAR_LWHF": "0" +"MAR_MNFL": "1" +"MAR_MNHF": "0" +"MAR_MSTB": "Full Bath" +"MAR_UPFL": "1" +"MAR_UPHF": "0" +"MAR_UPPR": "1" +"MAR_LOT_No": "12" +"MAR_Driveway": "Asphalt" +"MAR_IsDeleted": "0" +"MAR_Sub_Lease": "0" +"MAR_LastStatus": "Incomplete" +"MAR_price_per_sf": "288.81" +"MAR_MatrixTesting": "0" +"MAR_PropAssesCtyTx": "0" +"MAR_Office_Area_Code": "866" +"MAR_Office_Long_Name": "EXP Realty, LLC" +"MAR_StyleDescription": "Other" +"MAR_Transaction_Type": "Sale" +"MAR_Listing_Agent_Nickname": "Shayne" +"MAR_SellerConsiderConcessionYN": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96297303')" +"MIS_PoolYN": "0" +"MIS_Section": "KIRKWOOD" +"MIS_FloorPlan": "Primary Bed on Main" +"MIS_RoomCount": "0" +"MIS_UnitCount": "0" +"provider_name": "Stellar" +"MIS_CurrentPrice": "400000.00" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Incomplete" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "1" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "2" +"Media": array:12 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "67da2ec955697f5a53d013de" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/6a327d1ba4576f6177495b201f4dc6e7.webp" "MediaSize" => 426635 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-6a327d1ba4576f6177495b201f4dc6e7.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.551Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "67da2ec955697f5a53d013df" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/e3dcadf07a8a1bd92c349862f713d8d1.webp" "MediaSize" => 193179 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-e3dcadf07a8a1bd92c349862f713d8d1.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.581Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "67da2ec955697f5a53d013e0" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/6050bfb96728cd53a467adc9586cadb1.webp" "MediaSize" => 163843 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-6050bfb96728cd53a467adc9586cadb1.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.586Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "67da2ec955697f5a53d013e1" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/c4eb580642ba83070f37c12aa507d0e3.webp" "MediaSize" => 150531 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-c4eb580642ba83070f37c12aa507d0e3.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.638Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "67da2ec955697f5a53d013e2" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/82a43912e685134ca6d3bde3381202b6.webp" "MediaSize" => 174283 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-82a43912e685134ca6d3bde3381202b6.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.581Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "67da2ec955697f5a53d013e3" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/07a357137428d1e813865a27f60beb57.webp" "MediaSize" => 122594 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-07a357137428d1e813865a27f60beb57.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.507Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "67da2ec955697f5a53d013e4" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/a45740ea200996580fce7517d2445f7e.webp" "MediaSize" => 158537 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-a45740ea200996580fce7517d2445f7e.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.606Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "67da2ec955697f5a53d013e5" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/74aaccb073af0b85dca1a0d3dd4c92b7.webp" "MediaSize" => 161196 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-74aaccb073af0b85dca1a0d3dd4c92b7.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.544Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "67da2ec955697f5a53d013e6" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/4c7e449a0bbed2a835c167839c6a3183.webp" "MediaSize" => 73844 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-4c7e449a0bbed2a835c167839c6a3183.webp" "ImageWidth" => 800 "ImageHeight" => 1200 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "800x1200" "MediaModificationTimestamp" => "2025-03-19T02:41:13.539Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "67da2ec955697f5a53d013e7" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/3fa13b59163f4339de2fdce0ee9893d9.webp" "MediaSize" => 182433 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-3fa13b59163f4339de2fdce0ee9893d9.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.523Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "67da2ec955697f5a53d013e8" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/6ff04a740c444b3c9f74dcf98fc340ab.webp" "MediaSize" => 272462 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-6ff04a740c444b3c9f74dcf98fc340ab.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.597Z" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "67da2ec955697f5a53d013e9" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/794150ecdaf9a9e9c69674ff7b3d9a8d.webp" "MediaSize" => 470156 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-794150ecdaf9a9e9c69674ff7b3d9a8d.webp" "ImageWidth" => 1600 "ImageHeight" => 1065 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1065" "MediaModificationTimestamp" => "2025-03-19T02:41:13.588Z" ] ] +"ID": "18641" }
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 'MIS96297303'/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 'MIS96297303'&$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 'MIS96297303'/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 'MIS96297303'&$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: "18641" +post_author: 1 +"ListingKey": "MIS96297303" +"ListingId": "MIS25015794" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-29T00:53:26Z" +"RFModificationTimestamp": "2025-05-27T06:40:40.835533+00:00" +"ListPrice": 400000.0 +"BathroomsTotalInteger": 2.0 +"BathroomsHalf": 0 +"BedroomsTotal": 3.0 +"LotSizeArea": 0.14 +"LivingArea": 2085.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63122" +"UnparsedAddress": "554 S Clay Avenue, St Louis, Missouri 63122" +"Coordinates": array:2 [ 0 => -90.40857 1 => 38.571925 ] +"Latitude": 38.571925 +"Longitude": -90.40857 +"YearBuilt": 1938 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shayne Sowers" +"ListOfficeName": "EXP Realty, LLC" +"ListAgentMlsId": "MISSSOWERS" +"ListOfficeMlsId": "MISEXRT01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Renovated home in Kirkwood. Newly refinished hardwood floors (2024). New carpet (2025). Fresh paint (2024). Luxury master suite with two walk-in closets and reading nooks. Updated gourmet kitchen with new quartz countertops (2025) and new stainless steel appliances (2024). Updated bathrooms (2024). New finished lower level (2025). New light fixtures and ceiling fans (2024). Recessed lighting. Swept and inspected wood-burning fireplace. New gutters (2024). All-brick exterior with new tuckpointing (2024). New landscaping (2024). New metal window wrapping (2024). New electrical panel (2024). New plumbing stack (2024). New HVAC (2024). New water heater (2024). Three-seasons room. Deck. Level fenced backyard. Large detatched garage. Walkable neighborhood. Quick access to 44, 270, and 64." +"AboveGradeFinishedArea": 1385 +"AboveGradeFinishedAreaSource": "Assessor" +"AboveGradeFinishedAreaUnits": "Square Feet" +"Appliances": array:1 [ 0 => "Gas Water Heater" ] +"ArchitecturalStyle": array:2 [ 0 => "Traditional" 1 => "Other" ] +"AssociationFeeFrequency": "None" +"Basement": array:3 [ 0 => "Full" 1 => "Partially Finished" 2 => "Sleeping Area" ] +"BasementYN": true +"BathroomsFull": 2 +"BelowGradeFinishedArea": 700 +"BelowGradeFinishedAreaSource": "Other" +"BelowGradeFinishedAreaUnits": "Square Feet" +"BuyerOfficeAOR": "St. Louis Association of REALTORS" +"ConstructionMaterials": array:1 [ 0 => "Brick" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Electric" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-03-19T10:51:19.572912+00:00" +"CumulativeDaysOnMarket": 124 +"DaysOnMarket": 88 +"Disclosures": array:1 [ 0 => "Unknown" ] +"DocumentsChangeTimestamp": "2025-04-29T00:53:26Z" +"ElementarySchool": "W. W. Keysor Elem." +"FireplaceFeatures": array:3 [ 0 => "Recreation Room" 1 => "Wood Burning" 2 => "Living Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"Flooring": array:1 [ 0 => "Hardwood" ] +"GarageSpaces": "1" +"GarageYN": true +"Heating": array:2 [ 0 => "Forced Air" 1 => "Natural Gas" ] +"HighSchool": "Kirkwood Sr. High" +"HighSchoolDistrict": "Kirkwood R-VII" +"InteriorFeatures": array:1 [ 0 => "Solid Surface Countertop(s)" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"Levels": array:1 [ 0 => "One and One Half" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "MIS12687" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "MIS54401897" +"ListOfficePhone": "866-2241761" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Assessor" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.14 +"LotSizeDimensions": "122x50" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 6098 +"MLSAreaMajor": "196 - Kirkwood" +"MainLevelBedrooms": 2 +"MajorChangeTimestamp": "2025-03-31T16:52:00Z" +"MiddleOrJuniorSchool": "North Kirkwood Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OffMarketDate": "2025-09-22" +"OnMarketDate": "2025-03-18" +"OriginalEntryTimestamp": "2025-03-19T02:47:57Z" +"OriginalListPrice": 425000 +"OtherStructures": array:1 [ 0 => "Garage(s)" ] +"OwnershipType": "Private" +"ParcelNumber": "24M-13-0738" +"ParkingFeatures": array:1 [ 0 => "Detached" ] +"ParkingTotal": "1" +"PhotosChangeTimestamp": "2025-04-29T00:53:26Z" +"PhotosCount": 12 +"Possession": array:1 [ 0 => "Negotiable" ] +"PostalCodePlus4": "5946" +"PreviousListPrice": 425000 +"RoadSurfaceType": array:1 [ 0 => "Asphalt" ] +"RoomsTotal": "8" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Appointment Only" 1 => "Showing Service" 2 => "Combination Lock Box" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-03-19T02:47:57Z" +"StreetDirPrefix": "S" +"StreetName": "Clay" +"StreetNumber": "554" +"StreetNumberNumeric": "554" +"StreetSuffix": "Avenue" +"SubdivisionName": "Zephyr Heights" +"TaxAnnualAmount": "3587" +"TaxLegalDescription": "ZEPHYR HEIGHTS LOT PT 12 N PT" +"TaxYear": "2024" +"Township": "Kirkwood" +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_Age": "87" +"MAR_BALL": "2" +"MAR_BEDD": "Main Floor Primary" +"MAR_BELL": "3" +"MAR_FRPL": "Living Room" +"MAR_HETS": "Gas" +"MAR_KITC": "Solid Surface Counter" +"MAR_LOWR": "0" +"MAR_LWFL": "0" +"MAR_LWHF": "0" +"MAR_MNFL": "1" +"MAR_MNHF": "0" +"MAR_MSTB": "Full Bath" +"MAR_UPFL": "1" +"MAR_UPHF": "0" +"MAR_UPPR": "1" +"MAR_LOT_No": "12" +"MAR_Driveway": "Asphalt" +"MAR_IsDeleted": "0" +"MAR_Sub_Lease": "0" +"MAR_LastStatus": "Incomplete" +"MAR_price_per_sf": "288.81" +"MAR_MatrixTesting": "0" +"MAR_PropAssesCtyTx": "0" +"MAR_Office_Area_Code": "866" +"MAR_Office_Long_Name": "EXP Realty, LLC" +"MAR_StyleDescription": "Other" +"MAR_Transaction_Type": "Sale" +"MAR_Listing_Agent_Nickname": "Shayne" +"MAR_SellerConsiderConcessionYN": "1" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS96297303')" +"MIS_PoolYN": "0" +"MIS_Section": "KIRKWOOD" +"MIS_FloorPlan": "Primary Bed on Main" +"MIS_RoomCount": "0" +"MIS_UnitCount": "0" +"provider_name": "Stellar" +"MIS_CurrentPrice": "400000.00" +"MIS_OpenHouseCount": "0" +"MIS_PreviousStatus": "Incomplete" +"MIS_LowerLevelBedrooms": "0" +"MIS_UpperLevelBedrooms": "1" +"MIS_ActiveOpenHouseCount": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_MainLevelBathroomsHalf": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_UpperLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_MainAndUpperLevelBedrooms": "3" +"MIS_MainAndUpperLevelBathrooms": "2" +"Media": array:12 [ 0 => array:11 [ "Order" => 0 "MediaKey" => "67da2ec955697f5a53d013de" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/6a327d1ba4576f6177495b201f4dc6e7.webp" "MediaSize" => 426635 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-6a327d1ba4576f6177495b201f4dc6e7.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.551Z" ] 1 => array:11 [ "Order" => 1 "MediaKey" => "67da2ec955697f5a53d013df" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/e3dcadf07a8a1bd92c349862f713d8d1.webp" "MediaSize" => 193179 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-e3dcadf07a8a1bd92c349862f713d8d1.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.581Z" ] 2 => array:11 [ "Order" => 2 "MediaKey" => "67da2ec955697f5a53d013e0" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/6050bfb96728cd53a467adc9586cadb1.webp" "MediaSize" => 163843 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-6050bfb96728cd53a467adc9586cadb1.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.586Z" ] 3 => array:11 [ "Order" => 3 "MediaKey" => "67da2ec955697f5a53d013e1" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/c4eb580642ba83070f37c12aa507d0e3.webp" "MediaSize" => 150531 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-c4eb580642ba83070f37c12aa507d0e3.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.638Z" ] 4 => array:11 [ "Order" => 4 "MediaKey" => "67da2ec955697f5a53d013e2" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/82a43912e685134ca6d3bde3381202b6.webp" "MediaSize" => 174283 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-82a43912e685134ca6d3bde3381202b6.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.581Z" ] 5 => array:11 [ "Order" => 5 "MediaKey" => "67da2ec955697f5a53d013e3" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/07a357137428d1e813865a27f60beb57.webp" "MediaSize" => 122594 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-07a357137428d1e813865a27f60beb57.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.507Z" ] 6 => array:11 [ "Order" => 6 "MediaKey" => "67da2ec955697f5a53d013e4" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/a45740ea200996580fce7517d2445f7e.webp" "MediaSize" => 158537 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-a45740ea200996580fce7517d2445f7e.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.606Z" ] 7 => array:11 [ "Order" => 7 "MediaKey" => "67da2ec955697f5a53d013e5" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/74aaccb073af0b85dca1a0d3dd4c92b7.webp" "MediaSize" => 161196 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-74aaccb073af0b85dca1a0d3dd4c92b7.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.544Z" ] 8 => array:11 [ "Order" => 8 "MediaKey" => "67da2ec955697f5a53d013e6" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/4c7e449a0bbed2a835c167839c6a3183.webp" "MediaSize" => 73844 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-4c7e449a0bbed2a835c167839c6a3183.webp" "ImageWidth" => 800 "ImageHeight" => 1200 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "800x1200" "MediaModificationTimestamp" => "2025-03-19T02:41:13.539Z" ] 9 => array:11 [ "Order" => 9 "MediaKey" => "67da2ec955697f5a53d013e7" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/3fa13b59163f4339de2fdce0ee9893d9.webp" "MediaSize" => 182433 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-3fa13b59163f4339de2fdce0ee9893d9.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.523Z" ] 10 => array:11 [ "Order" => 10 "MediaKey" => "67da2ec955697f5a53d013e8" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/6ff04a740c444b3c9f74dcf98fc340ab.webp" "MediaSize" => 272462 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-6ff04a740c444b3c9f74dcf98fc340ab.webp" "ImageWidth" => 1600 "ImageHeight" => 1066 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1066" "MediaModificationTimestamp" => "2025-03-19T02:41:13.597Z" ] 11 => array:11 [ "Order" => 11 "MediaKey" => "67da2ec955697f5a53d013e9" "MediaURL" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/794150ecdaf9a9e9c69674ff7b3d9a8d.webp" "MediaSize" => 470156 "MediaType" => "webp" "Thumbnail" => "https://dx41nk9nsacii.cloudfront.net/cdn/43/MAR96297303/thumbnail-794150ecdaf9a9e9c69674ff7b3d9a8d.webp" "ImageWidth" => 1600 "ImageHeight" => 1065 "ResourceRecordKey" => "MAR96297303" "ImageSizeDescription" => "1600x1065" "MediaModificationTimestamp" => "2025-03-19T02:41:13.588Z" ] ] +"ID": "18641" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.21 seconds" ] ]