Buyers can customize ALL selections including floor plan, finishes, ECT* Pictures shown are the home TTB. New construction Custom Home in desirable Kirkwood, located in Kirkwood Estates a beautiful tree lined maintenance free private eight home New subdivision featuring a Center Island w/water features, Private lit walkway’s w/seating area, irrigated Private pet park just to name a few! This 1 story home offers a huge open floor plan w/over 5,000SqFt of Total livable space, 4 beds, 4 1/2 baths, 3 car garage, main floor master, REAL hardwood floors, top-of-the-line appliances, large center island, gas fireplaces, This luxury home will be loaded with all the best! Build your dream home today!
COPY & PASTE SUBDIVISION & HOME TBB VIRTUAL TOUR LINKS –
https://youtu.be/nCq8ARHrAc
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "19627" +post_author: 1 +"ListingKey": "MIS88090251" +"ListingId": "MIS22062753" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-28T23:34:22Z" +"RFModificationTimestamp": "2025-05-27T06:41:58.813785+00:00" +"ListPrice": 1399900.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.27 +"LivingArea": 5114.0 +"BuildingAreaTotal": 0 +"City": "Kirkwood" +"PostalCode": "63122" +"UnparsedAddress": " , Kirkwood, Saint Louis County, Missouri 63122, USA " +"Coordinates": array:2 [ 0 => -90.443721 1 => 38.575837 ] +"Latitude": 38.575837 +"Longitude": -90.443721 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Amber J Schlottach" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "MISASCHLOTT" +"ListOfficeMlsId": "MISCBG15" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Buyers can customize ALL selections including floor plan, finishes, ECT* Pictures shown are the home TTB. New construction Custom Home in desirable Kirkwood, located in Kirkwood Estates a beautiful tree lined maintenance free private eight home New subdivision featuring a Center Island w/water features, Private lit walkway's w/seating area, irrigated Private pet park just to name a few! This 1 story home offers a huge open floor plan w/over 5,000SqFt of Total livable space, 4 beds, 4 1/2 baths, 3 car garage, main floor master, REAL hardwood floors, top-of-the-line appliances, large center island, gas fireplaces, This luxury home will be loaded with all the best! Build your dream home today!\r\n COPY & PASTE SUBDIVISION & HOME TBB VIRTUAL TOUR LINKS - \r\n https://youtu.be/c-hsw4_dGGE\r\n https://youtu.be/nCq8ARHrAc \r\n https://youtu.be/fWL1qrbpA80 """ +"AboveGradeFinishedArea": 2836 +"AboveGradeFinishedAreaSource": "Builder" +"AboveGradeFinishedAreaUnits": "Square Feet" +"AccessibilityFeatures": array:2 [ 0 => "Accessible Bedroom" 1 => "Accessible Central Living Area" ] +"Appliances": array:9 [ 0 => "Dishwasher" 1 => "Disposal" 2 => "Double Oven" 3 => "Microwave" 4 => "Range Hood" 5 => "Gas Range" 6 => "Gas Oven" 7 => "Refrigerator" 8 => "Gas Water Heater" ] +"ArchitecturalStyle": array:2 [ 0 => "Ranch" 1 => "Other" ] +"AssociationAmenities": "Common Ground" +"AssociationFeeFrequency": "Monthly" +"AttachedGarageYN": true +"Basement": array:7 [ 0 => "9 ft + Pour" 1 => "Bathroom" 2 => "Cellar" 3 => "Other" 4 => "Partially Finished" 5 => "Concrete" 6 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 4 +"BelowGradeFinishedArea": 1914 +"BelowGradeFinishedAreaSource": "Builder" +"BelowGradeFinishedAreaUnits": "Square Feet" +"BuilderName": "Build STL" +"BuyerOfficeAOR": "St. Louis Association of REALTORS" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Other" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Zoned" ] +"Country": "US" +"CountyOrParish": "St. Louis" +"CreationDate": "2023-08-18T12:29:28.433598+00:00" +"CrossStreet": "Emerson Ave" +"CumulativeDaysOnMarket": 938 +"DaysOnMarket": 1014 +"Disclosures": array:4 [ 0 => "Other" 1 => "Code Compliance Required" 2 => "Flood Plain No" 3 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-04-28T23:34:22Z" +"DoorFeatures": array:1 [ 0 => "Pocket Door(s)" ] +"ElementarySchool": "George R. Robinson Elem." +"FireplaceFeatures": array:4 [ 0 => "Basement" 1 => "Great Room" 2 => "Recreation Room" 3 => "Kitchen" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": array:2 [ 0 => "Carpet" 1 => "Hardwood" ] +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:2 [ 0 => "Natural Gas" 1 => "Zoned" ] +"HighSchool": "Kirkwood Sr. High" +"HighSchoolDistrict": "Kirkwood R-VII" +"InteriorFeatures": array:14 [ 0 => "Entrance Foyer" 1 => "Open Floorplan" 2 => "Vaulted Ceiling(s)" 3 => "Bar" 4 => "Walk-In Closet(s)" 5 => "Double Vanity" 6 => "Tub" 7 => "Ceiling Fan(s)" 8 => "Separate Dining" 9 => "Butler Pantry" 10 => "Kitchen Island" 11 => "Custom Cabinetry" 12 => "Eat-in Kitchen" 13 => "Walk-In Pantry" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Main Level" ] +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "MIS82852147" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "MIS827" +"ListOfficePhone": "314-965-3030" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Builder" +"LotFeatures": array:2 [ 0 => "Adjoins Wooded Area" 1 => "Level" ] +"LotSizeAcres": 0.27 +"LotSizeDimensions": "11,741 SQFT" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 11739 +"MLSAreaMajor": "196 - Kirkwood" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2022-09-28T23:58:16Z" +"MiddleOrJuniorSchool": "Nipher Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NewConstructionYN": true +"OnMarketDate": "2022-09-28" +"OriginalEntryTimestamp": "2022-09-28T23:58:16Z" +"OriginalListPrice": 1399900 +"ParcelNumber": "24O-61-0605" +"ParkingFeatures": array:5 [ 0 => "Attached" 1 => "Garage" 2 => "Garage Door Opener" 3 => "Off Street" 4 => "Oversized" ] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:3 [ 0 => "Porch" 1 => "Covered" 2 => "Deck" ] +"PhotosChangeTimestamp": "2025-04-28T23:34:22Z" +"PhotosCount": 12 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "3425" +"PropertyCondition": array:2 [ 0 => "To Be Built" 1 => "New Construction" ] +"RoadSurfaceType": array:1 [ 0 => "Concrete" ] +"RoomsTotal": "15" +"SecurityFeatures": array:1 [ 0 => "Smoke Detector(s)" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2022-09-28T23:58:16Z" +"StreetName": "Lily" +"StreetNumber": "2025" +"StreetNumberNumeric": "2025" +"StreetSuffix": "Avenue" +"SubdivisionName": "Kirkwood Estates" +"TaxAnnualAmount": "2488" +"TaxYear": "2021" +"Township": "Kirkwood" +"Utilities": array:1 [ 0 => "Natural Gas Available" ] +"WaterSource": array:1 [ 0 => "Public" ] +"WindowFeatures": array:1 [ 0 => "Insulated Windows" ] +"MAR_UPPR": "0" +"MAR_price_per_sf": "493.62" +"MAR_BASE": "Over 1 Million" +"MAR_LOWR": "1" +"MAR_UPHF": "0" +"MAR_LWFL": "1" +"MAR_SQRG": "5000 - 6000" +"MAR_MSTB": "Double Sink,Full Bath,Tub & Separate Shwr" +"MAR_LastStatus": "Withheld" +"MAR_FRPL": "Basement,Great Room" +"MAR_LWHF": "0" +"MAR_BEDD": "Possible Extra Lw Lv,Main Floor Master,Master Bdr. Suite" +"MAR_BELL": "3" +"MAR_KITC": "Butler Pantry,Center Island,Custom Cabinetry,Eat-In Kitchen,Hearth Room,Walk-In Pantry" +"MAR_BALL": "4" +"MAR_Office_Area_Code": "314" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "Coldwell Banker Realty - Gundaker" +"MAR_PRPL": "To Be Built" +"MAR_SPEC": "Bonus Room,Entry Foyer,Family Room,Great Room,Library/Den,Living Room,Main Floor Laundry,Utility Room" +"MAR_TYPE": "Single Family" +"MAR_DING": "Separate Dining" +"MAR_MNFL": "3" +"MAR_Listing_Agent_Nickname": "Amber" +"MAR_MISC": "Smoke Alarm/Detec,Some Carpeting,Some Wood Floors,Walk-In Closets" +"MAR_StyleDescription": "Ranch" +"MAR_PROS": "Call Listing Agent" +"MAR_MNHF": "1" +"MAR_Driveway": "Concrete" +"MAR_UPFL": "0" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MIS_MainAndUpperLevelBathrooms": "4" +"MIS_CurrentPrice": "1399900.00" +"MIS_LowerLevelBedrooms": "1" +"MIS_MainLevelBathroomsFull": "3" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_OpenHouseCount": "0" +"MIS_LowerLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsFull": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS88090251')" +"MIS_RoomCount": "6" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_UnitCount": "0" +"MIS_PreviousStatus": "Withdrawn" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_FloorPlan": "Possible Extra Lower Bed,Primary Bed on Main,Primary Bed Suite" +"MIS_MainAndUpperLevelBedrooms": "3" +"provider_name": "Stellar" +"Media": array:12 [ 0 => array:10 [ "Order" => 0 "MediaKey" => "6334dc858fc2c5227db1c3e6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/cffe34c8717fe01b3a0523f9c065ca8f.jpeg" "MediaSize" => 89999 "ImageHeight" => 513 "MediaModificationTimestamp" => "2022-09-28T23:45:09.676Z" "ImageWidth" => 851 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-cffe34c8717fe01b3a0523f9c065ca8f.jpeg" "ImageSizeDescription" => "851x513" ] 1 => array:10 [ "Order" => 1 "MediaKey" => "6334dc858fc2c5227db1c3e7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/0f3682623807df880b65339f239d2947.jpeg" "MediaSize" => 53094 "ImageHeight" => 431 "MediaModificationTimestamp" => "2022-09-28T23:45:09.669Z" "ImageWidth" => 693 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-0f3682623807df880b65339f239d2947.jpeg" "ImageSizeDescription" => "693x431" ] 2 => array:10 [ "Order" => 2 "MediaKey" => "6334dc858fc2c5227db1c3e8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/7e2872b566659c429e632205df77157d.jpeg" "MediaSize" => 101527 "ImageHeight" => 509 "MediaModificationTimestamp" => "2022-09-28T23:45:09.648Z" "ImageWidth" => 850 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-7e2872b566659c429e632205df77157d.jpeg" "ImageSizeDescription" => "850x509" ] 3 => array:10 [ "Order" => 3 "MediaKey" => "633df7a9781bef1417a6b05e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/2009f011d9c7873583492e6b93702ef0.jpeg" "MediaSize" => 190427 "ImageHeight" => 824 "MediaModificationTimestamp" => "2022-10-05T21:31:21.767Z" "ImageWidth" => 1426 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-2009f011d9c7873583492e6b93702ef0.jpeg" "ImageSizeDescription" => "1426x824" ] 4 => array:10 [ "Order" => 4 "MediaKey" => "633df7a9781bef1417a6b05f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/8a26ae4f5d7ed2379ba7cee87d8d540a.jpeg" "MediaSize" => 79927 "ImageHeight" => 523 "MediaModificationTimestamp" => "2022-10-05T21:31:21.756Z" "ImageWidth" => 774 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-8a26ae4f5d7ed2379ba7cee87d8d540a.jpeg" "ImageSizeDescription" => "774x523" ] 5 => array:10 [ "Order" => 5 "MediaKey" => "633df7618bf93853f28b10c9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/ac0a00669aa07923140bb09cdc012cec.jpeg" "MediaSize" => 21090 "ImageHeight" => 262 "MediaModificationTimestamp" => "2022-10-05T21:30:09.154Z" "ImageWidth" => 443 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-ac0a00669aa07923140bb09cdc012cec.jpeg" "ImageSizeDescription" => "443x262" ] 6 => array:10 [ "Order" => 6 "MediaKey" => "6334e38f238931331c5c50e7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/4d26d9964fb9ed3bf2e28090e906ebd0.jpeg" "MediaSize" => 227281 "ImageHeight" => 888 "MediaModificationTimestamp" => "2022-09-29T00:15:11.179Z" "ImageWidth" => 1436 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-4d26d9964fb9ed3bf2e28090e906ebd0.jpeg" "ImageSizeDescription" => "1436x888" ] 7 => array:10 [ "Order" => 7 "MediaKey" => "6334e38f238931331c5c50e6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/f8f634686267c56158744eb19c3bceb1.jpeg" "MediaSize" => 223924 "ImageHeight" => 794 "MediaModificationTimestamp" => "2022-09-29T00:15:11.230Z" "ImageWidth" => 1176 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-f8f634686267c56158744eb19c3bceb1.jpeg" "ImageSizeDescription" => "1176x794" ] 8 => array:10 [ "Order" => 8 "MediaKey" => "64015ebe2a68dc0ebb345114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/ea7987c56bc91c24d47c40f2c401dbe5.jpeg" "MediaSize" => 272077 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.090Z" "ImageWidth" => 1564 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-ea7987c56bc91c24d47c40f2c401dbe5.jpeg" "ImageSizeDescription" => "1564x1200" ] 9 => array:10 [ "Order" => 9 "MediaKey" => "64015ebe2a68dc0ebb345115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/3641f9c9c17198e8b3f847458af5f8d0.jpeg" "MediaSize" => 215910 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.050Z" "ImageWidth" => 1508 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-3641f9c9c17198e8b3f847458af5f8d0.jpeg" "ImageSizeDescription" => "1508x1200" ] 10 => array:10 [ "Order" => 10 "MediaKey" => "64015ebe2a68dc0ebb345116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/26c34e38169fb54b933cca066980cc33.jpeg" "MediaSize" => 292684 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.115Z" "ImageWidth" => 1587 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-26c34e38169fb54b933cca066980cc33.jpeg" "ImageSizeDescription" => "1587x1200" ] 11 => array:10 [ "Order" => 11 "MediaKey" => "64015ebe2a68dc0ebb345117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/712ed63a337f874565ba38948bfb420f.jpeg" "MediaSize" => 275613 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.090Z" "ImageWidth" => 1483 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-712ed63a337f874565ba38948bfb420f.jpeg" "ImageSizeDescription" => "1483x1200" ] ] +"ID": "19627" }
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 'MIS88090251'/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 'MIS88090251'&$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 'MIS88090251'/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 'MIS88090251'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2834 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "19627" +post_author: 1 +"ListingKey": "MIS88090251" +"ListingId": "MIS22062753" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-28T23:34:22Z" +"RFModificationTimestamp": "2025-05-27T06:41:58.813785+00:00" +"ListPrice": 1399900.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.27 +"LivingArea": 5114.0 +"BuildingAreaTotal": 0 +"City": "Kirkwood" +"PostalCode": "63122" +"UnparsedAddress": " , Kirkwood, Saint Louis County, Missouri 63122, USA " +"Coordinates": array:2 [ 0 => -90.443721 1 => 38.575837 ] +"Latitude": 38.575837 +"Longitude": -90.443721 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Amber J Schlottach" +"ListOfficeName": "Coldwell Banker Realty - Gundaker" +"ListAgentMlsId": "MISASCHLOTT" +"ListOfficeMlsId": "MISCBG15" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Buyers can customize ALL selections including floor plan, finishes, ECT* Pictures shown are the home TTB. New construction Custom Home in desirable Kirkwood, located in Kirkwood Estates a beautiful tree lined maintenance free private eight home New subdivision featuring a Center Island w/water features, Private lit walkway's w/seating area, irrigated Private pet park just to name a few! This 1 story home offers a huge open floor plan w/over 5,000SqFt of Total livable space, 4 beds, 4 1/2 baths, 3 car garage, main floor master, REAL hardwood floors, top-of-the-line appliances, large center island, gas fireplaces, This luxury home will be loaded with all the best! Build your dream home today!\r\n COPY & PASTE SUBDIVISION & HOME TBB VIRTUAL TOUR LINKS - \r\n https://youtu.be/c-hsw4_dGGE\r\n https://youtu.be/nCq8ARHrAc \r\n https://youtu.be/fWL1qrbpA80 """ +"AboveGradeFinishedArea": 2836 +"AboveGradeFinishedAreaSource": "Builder" +"AboveGradeFinishedAreaUnits": "Square Feet" +"AccessibilityFeatures": array:2 [ 0 => "Accessible Bedroom" 1 => "Accessible Central Living Area" ] +"Appliances": array:9 [ 0 => "Dishwasher" 1 => "Disposal" 2 => "Double Oven" 3 => "Microwave" 4 => "Range Hood" 5 => "Gas Range" 6 => "Gas Oven" 7 => "Refrigerator" 8 => "Gas Water Heater" ] +"ArchitecturalStyle": array:2 [ 0 => "Ranch" 1 => "Other" ] +"AssociationAmenities": "Common Ground" +"AssociationFeeFrequency": "Monthly" +"AttachedGarageYN": true +"Basement": array:7 [ 0 => "9 ft + Pour" 1 => "Bathroom" 2 => "Cellar" 3 => "Other" 4 => "Partially Finished" 5 => "Concrete" 6 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 4 +"BelowGradeFinishedArea": 1914 +"BelowGradeFinishedAreaSource": "Builder" +"BelowGradeFinishedAreaUnits": "Square Feet" +"BuilderName": "Build STL" +"BuyerOfficeAOR": "St. Louis Association of REALTORS" +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Other" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Zoned" ] +"Country": "US" +"CountyOrParish": "St. Louis" +"CreationDate": "2023-08-18T12:29:28.433598+00:00" +"CrossStreet": "Emerson Ave" +"CumulativeDaysOnMarket": 938 +"DaysOnMarket": 1014 +"Disclosures": array:4 [ 0 => "Other" 1 => "Code Compliance Required" 2 => "Flood Plain No" 3 => "Occupancy Permit Required" ] +"DocumentsChangeTimestamp": "2025-04-28T23:34:22Z" +"DoorFeatures": array:1 [ 0 => "Pocket Door(s)" ] +"ElementarySchool": "George R. Robinson Elem." +"FireplaceFeatures": array:4 [ 0 => "Basement" 1 => "Great Room" 2 => "Recreation Room" 3 => "Kitchen" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": array:2 [ 0 => "Carpet" 1 => "Hardwood" ] +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:2 [ 0 => "Natural Gas" 1 => "Zoned" ] +"HighSchool": "Kirkwood Sr. High" +"HighSchoolDistrict": "Kirkwood R-VII" +"InteriorFeatures": array:14 [ 0 => "Entrance Foyer" 1 => "Open Floorplan" 2 => "Vaulted Ceiling(s)" 3 => "Bar" 4 => "Walk-In Closet(s)" 5 => "Double Vanity" 6 => "Tub" 7 => "Ceiling Fan(s)" 8 => "Separate Dining" 9 => "Butler Pantry" 10 => "Kitchen Island" 11 => "Custom Cabinetry" 12 => "Eat-in Kitchen" 13 => "Walk-In Pantry" ] +"RFTransactionType": "For Sale" +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Main Level" ] +"Levels": array:1 [ 0 => "One" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "MIS82852147" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "MIS827" +"ListOfficePhone": "314-965-3030" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional" +"LivingAreaSource": "Builder" +"LotFeatures": array:2 [ 0 => "Adjoins Wooded Area" 1 => "Level" ] +"LotSizeAcres": 0.27 +"LotSizeDimensions": "11,741 SQFT" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 11739 +"MLSAreaMajor": "196 - Kirkwood" +"MainLevelBedrooms": 3 +"MajorChangeTimestamp": "2022-09-28T23:58:16Z" +"MiddleOrJuniorSchool": "Nipher Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NewConstructionYN": true +"OnMarketDate": "2022-09-28" +"OriginalEntryTimestamp": "2022-09-28T23:58:16Z" +"OriginalListPrice": 1399900 +"ParcelNumber": "24O-61-0605" +"ParkingFeatures": array:5 [ 0 => "Attached" 1 => "Garage" 2 => "Garage Door Opener" 3 => "Off Street" 4 => "Oversized" ] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:3 [ 0 => "Porch" 1 => "Covered" 2 => "Deck" ] +"PhotosChangeTimestamp": "2025-04-28T23:34:22Z" +"PhotosCount": 12 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PostalCodePlus4": "3425" +"PropertyCondition": array:2 [ 0 => "To Be Built" 1 => "New Construction" ] +"RoadSurfaceType": array:1 [ 0 => "Concrete" ] +"RoomsTotal": "15" +"SecurityFeatures": array:1 [ 0 => "Smoke Detector(s)" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:1 [ 0 => "Appointment Only" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2022-09-28T23:58:16Z" +"StreetName": "Lily" +"StreetNumber": "2025" +"StreetNumberNumeric": "2025" +"StreetSuffix": "Avenue" +"SubdivisionName": "Kirkwood Estates" +"TaxAnnualAmount": "2488" +"TaxYear": "2021" +"Township": "Kirkwood" +"Utilities": array:1 [ 0 => "Natural Gas Available" ] +"WaterSource": array:1 [ 0 => "Public" ] +"WindowFeatures": array:1 [ 0 => "Insulated Windows" ] +"MAR_UPPR": "0" +"MAR_price_per_sf": "493.62" +"MAR_BASE": "Over 1 Million" +"MAR_LOWR": "1" +"MAR_UPHF": "0" +"MAR_LWFL": "1" +"MAR_SQRG": "5000 - 6000" +"MAR_MSTB": "Double Sink,Full Bath,Tub & Separate Shwr" +"MAR_LastStatus": "Withheld" +"MAR_FRPL": "Basement,Great Room" +"MAR_LWHF": "0" +"MAR_BEDD": "Possible Extra Lw Lv,Main Floor Master,Master Bdr. Suite" +"MAR_BELL": "3" +"MAR_KITC": "Butler Pantry,Center Island,Custom Cabinetry,Eat-In Kitchen,Hearth Room,Walk-In Pantry" +"MAR_BALL": "4" +"MAR_Office_Area_Code": "314" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "Coldwell Banker Realty - Gundaker" +"MAR_PRPL": "To Be Built" +"MAR_SPEC": "Bonus Room,Entry Foyer,Family Room,Great Room,Library/Den,Living Room,Main Floor Laundry,Utility Room" +"MAR_TYPE": "Single Family" +"MAR_DING": "Separate Dining" +"MAR_MNFL": "3" +"MAR_Listing_Agent_Nickname": "Amber" +"MAR_MISC": "Smoke Alarm/Detec,Some Carpeting,Some Wood Floors,Walk-In Closets" +"MAR_StyleDescription": "Ranch" +"MAR_PROS": "Call Listing Agent" +"MAR_MNHF": "1" +"MAR_Driveway": "Concrete" +"MAR_UPFL": "0" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MIS_MainAndUpperLevelBathrooms": "4" +"MIS_CurrentPrice": "1399900.00" +"MIS_LowerLevelBedrooms": "1" +"MIS_MainLevelBathroomsFull": "3" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_OpenHouseCount": "0" +"MIS_LowerLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsFull": "0" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS88090251')" +"MIS_RoomCount": "6" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_UpperLevelBedrooms": "0" +"MIS_UnitCount": "0" +"MIS_PreviousStatus": "Withdrawn" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_FloorPlan": "Possible Extra Lower Bed,Primary Bed on Main,Primary Bed Suite" +"MIS_MainAndUpperLevelBedrooms": "3" +"provider_name": "Stellar" +"Media": array:12 [ 0 => array:10 [ "Order" => 0 "MediaKey" => "6334dc858fc2c5227db1c3e6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/cffe34c8717fe01b3a0523f9c065ca8f.jpeg" "MediaSize" => 89999 "ImageHeight" => 513 "MediaModificationTimestamp" => "2022-09-28T23:45:09.676Z" "ImageWidth" => 851 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-cffe34c8717fe01b3a0523f9c065ca8f.jpeg" "ImageSizeDescription" => "851x513" ] 1 => array:10 [ "Order" => 1 "MediaKey" => "6334dc858fc2c5227db1c3e7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/0f3682623807df880b65339f239d2947.jpeg" "MediaSize" => 53094 "ImageHeight" => 431 "MediaModificationTimestamp" => "2022-09-28T23:45:09.669Z" "ImageWidth" => 693 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-0f3682623807df880b65339f239d2947.jpeg" "ImageSizeDescription" => "693x431" ] 2 => array:10 [ "Order" => 2 "MediaKey" => "6334dc858fc2c5227db1c3e8" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/7e2872b566659c429e632205df77157d.jpeg" "MediaSize" => 101527 "ImageHeight" => 509 "MediaModificationTimestamp" => "2022-09-28T23:45:09.648Z" "ImageWidth" => 850 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-7e2872b566659c429e632205df77157d.jpeg" "ImageSizeDescription" => "850x509" ] 3 => array:10 [ "Order" => 3 "MediaKey" => "633df7a9781bef1417a6b05e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/2009f011d9c7873583492e6b93702ef0.jpeg" "MediaSize" => 190427 "ImageHeight" => 824 "MediaModificationTimestamp" => "2022-10-05T21:31:21.767Z" "ImageWidth" => 1426 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-2009f011d9c7873583492e6b93702ef0.jpeg" "ImageSizeDescription" => "1426x824" ] 4 => array:10 [ "Order" => 4 "MediaKey" => "633df7a9781bef1417a6b05f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/8a26ae4f5d7ed2379ba7cee87d8d540a.jpeg" "MediaSize" => 79927 "ImageHeight" => 523 "MediaModificationTimestamp" => "2022-10-05T21:31:21.756Z" "ImageWidth" => 774 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-8a26ae4f5d7ed2379ba7cee87d8d540a.jpeg" "ImageSizeDescription" => "774x523" ] 5 => array:10 [ "Order" => 5 "MediaKey" => "633df7618bf93853f28b10c9" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/ac0a00669aa07923140bb09cdc012cec.jpeg" "MediaSize" => 21090 "ImageHeight" => 262 "MediaModificationTimestamp" => "2022-10-05T21:30:09.154Z" "ImageWidth" => 443 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-ac0a00669aa07923140bb09cdc012cec.jpeg" "ImageSizeDescription" => "443x262" ] 6 => array:10 [ "Order" => 6 "MediaKey" => "6334e38f238931331c5c50e7" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/4d26d9964fb9ed3bf2e28090e906ebd0.jpeg" "MediaSize" => 227281 "ImageHeight" => 888 "MediaModificationTimestamp" => "2022-09-29T00:15:11.179Z" "ImageWidth" => 1436 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-4d26d9964fb9ed3bf2e28090e906ebd0.jpeg" "ImageSizeDescription" => "1436x888" ] 7 => array:10 [ "Order" => 7 "MediaKey" => "6334e38f238931331c5c50e6" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/f8f634686267c56158744eb19c3bceb1.jpeg" "MediaSize" => 223924 "ImageHeight" => 794 "MediaModificationTimestamp" => "2022-09-29T00:15:11.230Z" "ImageWidth" => 1176 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-f8f634686267c56158744eb19c3bceb1.jpeg" "ImageSizeDescription" => "1176x794" ] 8 => array:10 [ "Order" => 8 "MediaKey" => "64015ebe2a68dc0ebb345114" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/ea7987c56bc91c24d47c40f2c401dbe5.jpeg" "MediaSize" => 272077 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.090Z" "ImageWidth" => 1564 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-ea7987c56bc91c24d47c40f2c401dbe5.jpeg" "ImageSizeDescription" => "1564x1200" ] 9 => array:10 [ "Order" => 9 "MediaKey" => "64015ebe2a68dc0ebb345115" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/3641f9c9c17198e8b3f847458af5f8d0.jpeg" "MediaSize" => 215910 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.050Z" "ImageWidth" => 1508 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-3641f9c9c17198e8b3f847458af5f8d0.jpeg" "ImageSizeDescription" => "1508x1200" ] 10 => array:10 [ "Order" => 10 "MediaKey" => "64015ebe2a68dc0ebb345116" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/26c34e38169fb54b933cca066980cc33.jpeg" "MediaSize" => 292684 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.115Z" "ImageWidth" => 1587 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-26c34e38169fb54b933cca066980cc33.jpeg" "ImageSizeDescription" => "1587x1200" ] 11 => array:10 [ "Order" => 11 "MediaKey" => "64015ebe2a68dc0ebb345117" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/712ed63a337f874565ba38948bfb420f.jpeg" "MediaSize" => 275613 "ImageHeight" => 1200 "MediaModificationTimestamp" => "2023-03-03T02:43:10.090Z" "ImageWidth" => 1483 "MediaType" => "Image" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MAR88090251/thumbnail-712ed63a337f874565ba38948bfb420f.jpeg" "ImageSizeDescription" => "1483x1200" ] ] +"ID": "19627" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.18 seconds" ] ]