Welcome to this custom luxury home in the highly desired Ladue school district, offering 3000+ square feet of unparalleled design & construction! Upon entering, you’ll be greeted by an open floor plan with natural light flooding the home, highlighting the gleaming hardwood floors and sleek design elements throughout. The chef’s kitchen is a dream come true, featuring custom cabinetry, quartz countertops, and an oversized island perfect for gathering around. Cozy up by the gas fireplace surrounded by custom built-ins in the inviting living area, or retreat to the well-appointed home office for quiet productivity. The spacious primary suite, along with three additional bedroom suites upstairs, ensures ample space for relaxation and privacy. The 9ft pour basement offers endless possibilities for customization and expansion to suit your lifestyle needs. Outside, you’ll find plenty of outdoor entertaining space, ideal for hosting gatherings or simply enjoying the beautiful surroundings.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2836 +post_id: "16320" +post_author: 1 +"ListingKey": "MIS92920258" +"ListingId": "MIS24019421" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-29T14:44:35Z" +"RFModificationTimestamp": "2025-05-27T06:39:37.111578+00:00" +"ListPrice": 1099990.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.42 +"LivingArea": 3000.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63141" +"UnparsedAddress": "817 Larkin Avenue, St Louis, Missouri 63141" +"Coordinates": array:2 [ 0 => -90.416894 1 => 38.670705 ] +"Latitude": 38.670705 +"Longitude": -90.416894 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelsi Geuns" +"ListOfficeName": "SCHNEIDER Real Estate" +"ListAgentMlsId": "MISKELGEUNS" +"ListOfficeMlsId": "MISJSRE01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Welcome to this custom luxury home in the highly desired Ladue school district, offering 3000+ square feet of unparalleled design & construction! Upon entering, you'll be greeted by an open floor plan with natural light flooding the home, highlighting the gleaming hardwood floors and sleek design elements throughout. The chef's kitchen is a dream come true, featuring custom cabinetry, quartz countertops, and an oversized island perfect for gathering around. Cozy up by the gas fireplace surrounded by custom built-ins in the inviting living area, or retreat to the well-appointed home office for quiet productivity. The spacious primary suite, along with three additional bedroom suites upstairs, ensures ample space for relaxation and privacy. The 9ft pour basement offers endless possibilities for customization and expansion to suit your lifestyle needs. Outside, you'll find plenty of outdoor entertaining space, ideal for hosting gatherings or simply enjoying the beautiful surroundings." +"AboveGradeFinishedArea": 3000 +"AboveGradeFinishedAreaSource": "Builder" +"AboveGradeFinishedAreaUnits": "Square Feet" +"Appliances": array:8 [ 0 => "Dishwasher" 1 => "Disposal" 2 => "Microwave" 3 => "Range Hood" 4 => "Gas Range" 5 => "Gas Oven" 6 => "Refrigerator" 7 => "Gas Water Heater" ] +"ArchitecturalStyle": array:4 [ 0 => "Other" 1 => "Contemporary" 2 => "Rustic" 3 => "Traditional" ] +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "9 ft + Pour" ] +"BasementYN": true +"BathroomsFull": 4 +"BuyerOfficeAOR": "St. Charles County Association of REALTORS" +"ConstructionMaterials": array:3 [ 0 => "Brick" 1 => "Other" 2 => "Vinyl Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Zoned" ] +"Country": "US" +"CountyOrParish": "St. Louis" +"CreationDate": "2024-04-03T20:40:39.688021+00:00" +"CumulativeDaysOnMarket": 385 +"DaysOnMarket": 460 +"Disclosures": array:1 [ 0 => "Unknown" ] +"DocumentsChangeTimestamp": "2025-04-29T14:44:35Z" +"DocumentsCount": 2 +"ElementarySchool": "Spoede Elem." +"FireplaceFeatures": array:1 [ 0 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:1 [ 0 => "Natural Gas" ] +"HighSchool": "Ladue Horton Watkins High" +"HighSchoolDistrict": "Ladue" +"HomeWarrantyYN": true +"InteriorFeatures": array:14 [ 0 => "Ceiling Fan(s)" 1 => "Kitchen/Dining Room Combo" 2 => "Separate Dining" 3 => "Bookcases" 4 => "Open Floorplan" 5 => "Vaulted Ceiling(s)" 6 => "Walk-In Closet(s)" 7 => "Breakfast Bar" 8 => "Butler Pantry" 9 => "Kitchen Island" 10 => "Custom Cabinetry" 11 => "Eat-in Kitchen" 12 => "Double Vanity" 13 => "Tub" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Main Level" ] +"Levels": array:1 [ 0 => "One and One Half" ] +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "MIS45186099" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "MIS56796368" +"ListOfficePhone": "636-3455323" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,VA Loan" +"LivingAreaSource": "Builder" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.4154 +"LotSizeDimensions": "77/77x241/229" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 18095 +"MLSAreaMajor": "151 - Ladue" +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2024-04-03T20:09:51Z" +"MiddleOrJuniorSchool": "Ladue Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NewConstructionYN": true +"NumberOfUnitsInCommunity": 1 +"OffMarketDate": "2025-12-31" +"OnMarketDate": "2024-04-03" +"OriginalEntryTimestamp": "2024-04-03T20:09:51Z" +"OriginalListPrice": 1099990 +"ParcelNumber": "17N-62-0269" +"ParkingFeatures": array:2 [ 0 => "Attached" 1 => "Garage" ] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:4 [ 0 => "Porch" 1 => "Covered" 2 => "Deck" 3 => "Patio" ] +"PhotosChangeTimestamp": "2025-04-29T14:44:35Z" +"PhotosCount": 4 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PropertyCondition": array:2 [ 0 => "To Be Built" 1 => "New Construction" ] +"RoadSurfaceType": array:1 [ 0 => "Concrete" ] +"RoomsTotal": "10" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Appointment Only" 1 => "Call Listing Office" 2 => "Do Not Show" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2024-04-03T20:09:51Z" +"StreetName": "Larkin" +"StreetNumber": "817" +"StreetNumberNumeric": "817" +"StreetSuffix": "Avenue" +"SubdivisionName": "Olive Crest" +"TaxAnnualAmount": "2807" +"TaxLegalDescription": "OLIVE CREST LOT PT 18 S PT" +"TaxYear": "2023" +"Township": "Creve Coeur" +"Utilities": array:1 [ 0 => "Natural Gas Available" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_UPPR": "3" +"MAR_CBLA": "1" +"MAR_price_per_sf": "366.66" +"MAR_BASE": "Over 1 Million" +"MAR_LOWR": "0" +"MAR_UPHF": "0" +"MAR_LWFL": "0" +"MAR_SQRG": "3000 - 4000" +"MAR_MSTB": "Double Sink,Full Bath,Tub & Separate Shwr" +"MAR_LastStatus": "Office Exclusive" +"MAR_FRPL": "Family Room" +"MAR_LWHF": "0" +"MAR_BEDD": "Divided Bdr Flr Plan,Possible Extra Lw Lv,Main Floor Primary,Primary Bdr. Suite" +"MAR_BELL": "4" +"MAR_KITC": "Breakfast Bar,Butler Pantry,Center Island,Custom Cabinetry,Eat-In Kitchen" +"MAR_BALL": "5" +"MAR_Office_Area_Code": "636" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "SCHNEIDER Real Estate" +"MAR_PRPL": "To Be Built" +"MAR_SPEC": "Main Floor Laundry" +"MAR_TYPE": "Single Family" +"MAR_Sub_Lease": "0" +"MAR_DING": "Kitchen/Dining Combo,Separate Dining" +"MAR_MNFL": "1" +"MAR_Listing_Agent_Nickname": "Kelsi" +"MAR_MISC": "Builders Warranty" +"MAR_StyleDescription": "Other" +"MAR_PROS": "Call Listing Agent" +"MAR_MNHF": "1" +"MAR_Driveway": "Concrete" +"MAR_UPFL": "3" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_MainAndUpperLevelBathrooms": "5" +"MIS_CurrentPrice": "1099990.00" +"MIS_LowerLevelBedrooms": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_OpenHouseCount": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsFull": "3" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS92920258')" +"MIS_RoomCount": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_UpperLevelBedrooms": "3" +"MIS_UnitCount": "0" +"MIS_PreviousStatus": "Withdrawn" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_FloorPlan": "Divided Bdr Flr Plan,Possible Extra Lower Bed,Primary Bed on Main,Primary Bed Suite" +"MIS_MainAndUpperLevelBedrooms": "4" +"provider_name": "Stellar" +"Media": array:4 [ 0 => array:12 [ "Order" => 1 "MediaKey" => "68105a6b1dc246724897370c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/55f9aceb67c071429c23383269adae3c.webp" "MediaSize" => 95470 "LongDescription" => "View of front facade featuring a shingled roof and driveway" "ImageHeight" => 400 "MediaModificationTimestamp" => "2025-04-29T04:49:47.791Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-55f9aceb67c071429c23383269adae3c.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x400" ] 1 => array:11 [ "Order" => 2 "MediaKey" => "68105a6b1dc246724897370d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/7e9f19e221edf39c9f83c5b91cfed8ad.webp" "MediaSize" => 75940 "ImageHeight" => 767 "MediaModificationTimestamp" => "2025-04-29T04:49:47.814Z" "ImageWidth" => 943 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-7e9f19e221edf39c9f83c5b91cfed8ad.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "943x767" ] 2 => array:11 [ "Order" => 3 "MediaKey" => "68105a6b1dc246724897370e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/6b6415cede2386aba10e8f0deb9745b7.webp" "MediaSize" => 87203 "ImageHeight" => 605 "MediaModificationTimestamp" => "2025-04-29T04:49:47.780Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-6b6415cede2386aba10e8f0deb9745b7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x605" ] 3 => array:11 [ "Order" => 4 "MediaKey" => "68105a6b1dc246724897370f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/e56fbbf4874067995d83b814b5badb1c.webp" "MediaSize" => 79021 "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:49:47.784Z" "ImageWidth" => 948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-e56fbbf4874067995d83b814b5badb1c.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "948x768" ] ] +"ID": "16320" }
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 'MIS92920258'/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 'MIS92920258'&$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 'MIS92920258'/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 'MIS92920258'&$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: "16320" +post_author: 1 +"ListingKey": "MIS92920258" +"ListingId": "MIS24019421" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-04-29T14:44:35Z" +"RFModificationTimestamp": "2025-05-27T06:39:37.111578+00:00" +"ListPrice": 1099990.0 +"BathroomsTotalInteger": 5.0 +"BathroomsHalf": 1 +"BedroomsTotal": 4.0 +"LotSizeArea": 0.42 +"LivingArea": 3000.0 +"BuildingAreaTotal": 0 +"City": "St Louis" +"PostalCode": "63141" +"UnparsedAddress": "817 Larkin Avenue, St Louis, Missouri 63141" +"Coordinates": array:2 [ 0 => -90.416894 1 => 38.670705 ] +"Latitude": 38.670705 +"Longitude": -90.416894 +"YearBuilt": 0 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Kelsi Geuns" +"ListOfficeName": "SCHNEIDER Real Estate" +"ListAgentMlsId": "MISKELGEUNS" +"ListOfficeMlsId": "MISJSRE01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": "Welcome to this custom luxury home in the highly desired Ladue school district, offering 3000+ square feet of unparalleled design & construction! Upon entering, you'll be greeted by an open floor plan with natural light flooding the home, highlighting the gleaming hardwood floors and sleek design elements throughout. The chef's kitchen is a dream come true, featuring custom cabinetry, quartz countertops, and an oversized island perfect for gathering around. Cozy up by the gas fireplace surrounded by custom built-ins in the inviting living area, or retreat to the well-appointed home office for quiet productivity. The spacious primary suite, along with three additional bedroom suites upstairs, ensures ample space for relaxation and privacy. The 9ft pour basement offers endless possibilities for customization and expansion to suit your lifestyle needs. Outside, you'll find plenty of outdoor entertaining space, ideal for hosting gatherings or simply enjoying the beautiful surroundings." +"AboveGradeFinishedArea": 3000 +"AboveGradeFinishedAreaSource": "Builder" +"AboveGradeFinishedAreaUnits": "Square Feet" +"Appliances": array:8 [ 0 => "Dishwasher" 1 => "Disposal" 2 => "Microwave" 3 => "Range Hood" 4 => "Gas Range" 5 => "Gas Oven" 6 => "Refrigerator" 7 => "Gas Water Heater" ] +"ArchitecturalStyle": array:4 [ 0 => "Other" 1 => "Contemporary" 2 => "Rustic" 3 => "Traditional" ] +"AttachedGarageYN": true +"Basement": array:1 [ 0 => "9 ft + Pour" ] +"BasementYN": true +"BathroomsFull": 4 +"BuyerOfficeAOR": "St. Charles County Association of REALTORS" +"ConstructionMaterials": array:3 [ 0 => "Brick" 1 => "Other" 2 => "Vinyl Siding" ] +"Cooling": array:2 [ 0 => "Central Air" 1 => "Zoned" ] +"Country": "US" +"CountyOrParish": "St. Louis" +"CreationDate": "2024-04-03T20:40:39.688021+00:00" +"CumulativeDaysOnMarket": 385 +"DaysOnMarket": 460 +"Disclosures": array:1 [ 0 => "Unknown" ] +"DocumentsChangeTimestamp": "2025-04-29T14:44:35Z" +"DocumentsCount": 2 +"ElementarySchool": "Spoede Elem." +"FireplaceFeatures": array:1 [ 0 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "1" +"GarageSpaces": "3" +"GarageYN": true +"Heating": array:1 [ 0 => "Natural Gas" ] +"HighSchool": "Ladue Horton Watkins High" +"HighSchoolDistrict": "Ladue" +"HomeWarrantyYN": true +"InteriorFeatures": array:14 [ 0 => "Ceiling Fan(s)" 1 => "Kitchen/Dining Room Combo" 2 => "Separate Dining" 3 => "Bookcases" 4 => "Open Floorplan" 5 => "Vaulted Ceiling(s)" 6 => "Walk-In Closet(s)" 7 => "Breakfast Bar" 8 => "Butler Pantry" 9 => "Kitchen Island" 10 => "Custom Cabinetry" 11 => "Eat-in Kitchen" 12 => "Double Vanity" 13 => "Tub" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetConsumerCommentYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:1 [ 0 => "Main Level" ] +"Levels": array:1 [ 0 => "One and One Half" ] +"ListAOR": "St. Charles County Association of REALTORS" +"ListAgentAOR": "St. Charles County Association of REALTORS" +"ListAgentKey": "MIS45186099" +"ListOfficeAOR": "St. Charles County Association of REALTORS" +"ListOfficeKey": "MIS56796368" +"ListOfficePhone": "636-3455323" +"ListingService": "Full Service" +"ListingTerms": "Cash,Conventional,VA Loan" +"LivingAreaSource": "Builder" +"LotFeatures": array:1 [ 0 => "Level" ] +"LotSizeAcres": 0.4154 +"LotSizeDimensions": "77/77x241/229" +"LotSizeSource": "Public Records" +"LotSizeSquareFeet": 18095 +"MLSAreaMajor": "151 - Ladue" +"MainLevelBedrooms": 1 +"MajorChangeTimestamp": "2024-04-03T20:09:51Z" +"MiddleOrJuniorSchool": "Ladue Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"NewConstructionYN": true +"NumberOfUnitsInCommunity": 1 +"OffMarketDate": "2025-12-31" +"OnMarketDate": "2024-04-03" +"OriginalEntryTimestamp": "2024-04-03T20:09:51Z" +"OriginalListPrice": 1099990 +"ParcelNumber": "17N-62-0269" +"ParkingFeatures": array:2 [ 0 => "Attached" 1 => "Garage" ] +"ParkingTotal": "3" +"PatioAndPorchFeatures": array:4 [ 0 => "Porch" 1 => "Covered" 2 => "Deck" 3 => "Patio" ] +"PhotosChangeTimestamp": "2025-04-29T14:44:35Z" +"PhotosCount": 4 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"PropertyCondition": array:2 [ 0 => "To Be Built" 1 => "New Construction" ] +"RoadSurfaceType": array:1 [ 0 => "Concrete" ] +"RoomsTotal": "10" +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:3 [ 0 => "Appointment Only" 1 => "Call Listing Office" 2 => "Do Not Show" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2024-04-03T20:09:51Z" +"StreetName": "Larkin" +"StreetNumber": "817" +"StreetNumberNumeric": "817" +"StreetSuffix": "Avenue" +"SubdivisionName": "Olive Crest" +"TaxAnnualAmount": "2807" +"TaxLegalDescription": "OLIVE CREST LOT PT 18 S PT" +"TaxYear": "2023" +"Township": "Creve Coeur" +"Utilities": array:1 [ 0 => "Natural Gas Available" ] +"WaterSource": array:1 [ 0 => "Public" ] +"MAR_UPPR": "3" +"MAR_CBLA": "1" +"MAR_price_per_sf": "366.66" +"MAR_BASE": "Over 1 Million" +"MAR_LOWR": "0" +"MAR_UPHF": "0" +"MAR_LWFL": "0" +"MAR_SQRG": "3000 - 4000" +"MAR_MSTB": "Double Sink,Full Bath,Tub & Separate Shwr" +"MAR_LastStatus": "Office Exclusive" +"MAR_FRPL": "Family Room" +"MAR_LWHF": "0" +"MAR_BEDD": "Divided Bdr Flr Plan,Possible Extra Lw Lv,Main Floor Primary,Primary Bdr. Suite" +"MAR_BELL": "4" +"MAR_KITC": "Breakfast Bar,Butler Pantry,Center Island,Custom Cabinetry,Eat-In Kitchen" +"MAR_BALL": "5" +"MAR_Office_Area_Code": "636" +"MAR_Transaction_Type": "Sale" +"MAR_Office_Long_Name": "SCHNEIDER Real Estate" +"MAR_PRPL": "To Be Built" +"MAR_SPEC": "Main Floor Laundry" +"MAR_TYPE": "Single Family" +"MAR_Sub_Lease": "0" +"MAR_DING": "Kitchen/Dining Combo,Separate Dining" +"MAR_MNFL": "1" +"MAR_Listing_Agent_Nickname": "Kelsi" +"MAR_MISC": "Builders Warranty" +"MAR_StyleDescription": "Other" +"MAR_PROS": "Call Listing Agent" +"MAR_MNHF": "1" +"MAR_Driveway": "Concrete" +"MAR_UPFL": "3" +"MAR_IsDeleted": "0" +"MAR_MatrixTesting": "0" +"MIS_OpenHousePublicCount": "0" +"MIS_OpenHousePublicUpcoming": "0" +"MIS_MainAndUpperLevelBathrooms": "5" +"MIS_CurrentPrice": "1099990.00" +"MIS_LowerLevelBedrooms": "0" +"MIS_MainLevelBathroomsFull": "1" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_OpenHouseCount": "0" +"MIS_LowerLevelBathroomsFull": "0" +"MIS_UpperLevelBathroomsFull": "3" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS92920258')" +"MIS_RoomCount": "0" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_UpperLevelBedrooms": "3" +"MIS_UnitCount": "0" +"MIS_PreviousStatus": "Withdrawn" +"MIS_ActiveOpenHouseCount": "0" +"MIS_PoolYN": "0" +"MIS_FloorPlan": "Divided Bdr Flr Plan,Possible Extra Lower Bed,Primary Bed on Main,Primary Bed Suite" +"MIS_MainAndUpperLevelBedrooms": "4" +"provider_name": "Stellar" +"Media": array:4 [ 0 => array:12 [ "Order" => 1 "MediaKey" => "68105a6b1dc246724897370c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/55f9aceb67c071429c23383269adae3c.webp" "MediaSize" => 95470 "LongDescription" => "View of front facade featuring a shingled roof and driveway" "ImageHeight" => 400 "MediaModificationTimestamp" => "2025-04-29T04:49:47.791Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-55f9aceb67c071429c23383269adae3c.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x400" ] 1 => array:11 [ "Order" => 2 "MediaKey" => "68105a6b1dc246724897370d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/7e9f19e221edf39c9f83c5b91cfed8ad.webp" "MediaSize" => 75940 "ImageHeight" => 767 "MediaModificationTimestamp" => "2025-04-29T04:49:47.814Z" "ImageWidth" => 943 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-7e9f19e221edf39c9f83c5b91cfed8ad.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "943x767" ] 2 => array:11 [ "Order" => 3 "MediaKey" => "68105a6b1dc246724897370e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/6b6415cede2386aba10e8f0deb9745b7.webp" "MediaSize" => 87203 "ImageHeight" => 605 "MediaModificationTimestamp" => "2025-04-29T04:49:47.780Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-6b6415cede2386aba10e8f0deb9745b7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x605" ] 3 => array:11 [ "Order" => 4 "MediaKey" => "68105a6b1dc246724897370f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/e56fbbf4874067995d83b814b5badb1c.webp" "MediaSize" => 79021 "ImageHeight" => 768 "MediaModificationTimestamp" => "2025-04-29T04:49:47.784Z" "ImageWidth" => 948 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS92920258/thumbnail-e56fbbf4874067995d83b814b5badb1c.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "948x768" ] ] +"ID": "16320" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.26 seconds" ] ]