Exceptional Living in Chesterfield’s Twin Estates
Experience refined living at 2259 Sycamore, a beautifully appointed residence in the prestigious Twin Estates neighborhood, served by the acclaimed Rockwood School District. This expansive home blends timeless elegance with everyday comfort, offering the perfect balance of space, privacy, and functionality. A dramatic two-story entry welcomes you inside, where dual staircases provide seamless access to both the front and back of the home. The thoughtfully designed layout features two spacious family rooms, a private primary suite with an ensuite bath, and a sun-drenched sunroom that opens to an inviting deck and walk-out patio—perfect for entertaining or quiet moments outdoors. Car collectors and adventurers alike will appreciate the 1,300 sq ft garage with a commercial-grade door, ideal for an RV, boat, or large vehicle, along with a parking pad that accommodates up to 7 cars. A dedicated wine cellar adds a refined touch for elegant entertaining. This is more than a home—it’s a lifestyle. VA buyers have the rare opportunity to assume an existing low-interest VA loan, offering exceptional value in today’s market.
Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "23633" +post_author: 1 +"ListingKey": "MIS203448845" +"ListingId": "25041121" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-03T16:44:38Z" +"RFModificationTimestamp": "2025-07-03T16:49:50Z" +"ListPrice": 815000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3952.0 +"BuildingAreaTotal": 0 +"City": "Chesterfield" +"PostalCode": "63017" +"UnparsedAddress": "2259 Sycamore Drive, Chesterfield, Missouri 63017" +"Coordinates": array:2 [ 0 => -90.56984 1 => 38.619293 ] +"Latitude": 38.619293 +"Longitude": -90.56984 +"YearBuilt": 1995 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shantelle Harris" +"ListOfficeName": "RE/MAX Results" +"ListAgentMlsId": "SHAHARRI" +"ListOfficeMlsId": "RMXR01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Exceptional Living in Chesterfield’s Twin Estates\n Experience refined living at 2259 Sycamore, a beautifully appointed residence in the prestigious Twin Estates neighborhood, served by the acclaimed Rockwood School District. This expansive home blends timeless elegance with everyday comfort, offering the perfect balance of space, privacy, and functionality. A dramatic two-story entry welcomes you inside, where dual staircases provide seamless access to both the front and back of the home. The thoughtfully designed layout features two spacious family rooms, a private primary suite with an ensuite bath, and a sun-drenched sunroom that opens to an inviting deck and walk-out patio—perfect for entertaining or quiet moments outdoors. Car collectors and adventurers alike will appreciate the 1,300 sq ft garage with a commercial-grade door, ideal for an RV, boat, or large vehicle, along with a parking pad that accommodates up to 7 cars. A dedicated wine cellar adds a refined touch for elegant entertaining. This is more than a home—it’s a lifestyle. VA buyers have the rare opportunity to assume an existing low-interest VA loan, offering exceptional value in today’s market. """ +"AboveGradeFinishedArea": 2952 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:12 [ 0 => "Electric Cooktop" 1 => "Dishwasher" 2 => "Disposal" 3 => "Dryer" 4 => "Exhaust Fan" 5 => "Microwave" 6 => "Electric Oven" 7 => "Built-In Electric Range" 8 => "Refrigerator" 9 => "Washer" 10 => "Water Heater" 11 => "Bar Fridge" ] +"ArchitecturalStyle": array:1 [ 0 => "Traditional" ] +"AssociationAmenities": "Other" +"AssociationFee": "30" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ 0 => "Other" ] +"AssociationYN": true +"AttachedGarageYN": true +"Basement": array:6 [ 0 => "9 ft + Pour" 1 => "Egress Window" 2 => "Exterior Entry" 3 => "Finished" 4 => "Sleeping Area" 5 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 3 +"BelowGradeFinishedArea": 1000 +"BelowGradeFinishedAreaSource": "Public Records" +"BuildingFeatures": array:5 [ 0 => "Basement" 1 => "Bathrooms" 2 => "Patio" 3 => "Security System" 4 => "Storage" ] +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-13T03:56:47.641876+00:00" +"CrossStreet": "Engelwood" +"Disclosures": array:1 [ 0 => "Code Compliance Required" ] +"DocumentsAvailable": array:1 [ 0 => "Other" ] +"DocumentsChangeTimestamp": "2025-07-03T16:44:38Z" +"DocumentsCount": 3 +"DoorFeatures": array:2 [ 0 => "French Door(s)" 1 => "Storm Door(s)" ] +"ElementarySchool": "Kehrs Mill Elem." +"ExteriorFeatures": array:2 [ 0 => "Entry Steps/Stairs" 1 => "Storage" ] +"Fencing": array:1 [ 0 => "None" ] +"FireplaceFeatures": array:2 [ 0 => "Basement" 1 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": array:3 [ 0 => "Carpet" 1 => "Hardwood" 2 => "Vinyl" ] +"FoundationDetails": array:1 [ 0 => "Concrete Perimeter" ] +"GarageSpaces": "6" +"GarageYN": true +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Marquette Sr. High" +"HighSchoolDistrict": "Rockwood R-VI" +"HomeWarrantyYN": true +"InteriorFeatures": array:16 [ 0 => "Bar" 1 => "Bookcases" 2 => "Breakfast Room" 3 => "Double Vanity" 4 => "Granite Counters" 5 => "High Ceilings" 6 => "Kitchen Island" 7 => "Open Floorplan" 8 => "Pantry" 9 => "Separate Dining" 10 => "Separate Shower" 11 => "Storage" 12 => "Tub" 13 => "Two Story Entrance Foyer" 14 => "Walk-In Closet(s)" 15 => "Workshop/Hobby Area" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Laundry Room" 1 => "Main Level" ] +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "78242332" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "2828" +"ListOfficePhone": "314-781-7777" +"ListingService": "Full Service" +"ListingTerms": "Assumable,Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Public Records" +"LotFeatures": array:4 [ 0 => "Back Yard" 1 => "Corner Lot" 2 => "Few Trees" 3 => "Front Yard" ] +"LotSizeAcres": 0.35 +"LotSizeDimensions": "152 X 100" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "348 - Marquette" +"MajorChangeTimestamp": "2025-07-03T06:31:05Z" +"MiddleOrJuniorSchool": "Crestview Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-03" +"OriginalEntryTimestamp": "2025-06-13T03:55:56Z" +"OriginalListPrice": 815000 +"OwnershipType": "Private" +"ParcelNumber": "21S-43-0910" +"ParkingFeatures": array:11 [ 0 => "Additional Parking" 1 => "Attached" 2 => "Boat" 3 => "Covered" 4 => "Driveway" 5 => "Garage" 6 => "Garage Door Opener" 7 => "Garage Faces Side" 8 => "Inside Entrance" 9 => "Oversized" 10 => "RV Garage" ] +"PhotosChangeTimestamp": "2025-07-03T16:43:38Z" +"PhotosCount": 32 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"RoadSurfaceType": array:1 [ 0 => "Concrete" ] +"Roof": array:1 [ 0 => "Shingle" ] +"RoomsTotal": "9" +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detector(s)" 1 => "Smoke Detector(s)" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Occupied" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-03T06:31:05Z" +"StreetName": "Sycamore" +"StreetNumber": "2259" +"StreetNumberNumeric": "2259" +"StreetSuffix": "Drive" +"StructureType": array:1 [ 0 => "House" ] +"SubdivisionName": "Twin Estates At Sycamore Ridge" +"TaxAnnualAmount": "8172" +"TaxLegalDescription": "TWIN ESTATES AT SYCAMORE RIDGE LOT 11" +"TaxYear": "2024" +"Township": "Chesterfield" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_EfficiencyYN": "0" +"MIS_MainAndUpperLevelBathrooms": "3" +"MIS_CurrentPrice": "815000.00" +"MIS_LowerLevelBedrooms": "1" +"MIS_AuctionYN": "0" +"MIS_MainLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_LowerLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsFull": "2" +"MIS_RoomCount": "16" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_UpperLevelBedrooms": "4" +"MIS_PreviousStatus": "Coming Soon" +"MIS_SecondMortgageYN": "0" +"MIS_PoolYN": "0" +"MIS_MainAndUpperLevelBedrooms": "4" +"MIS_Section": "CHESTERFIELD" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203448845')" +"provider_name": "MARIS" +"Media": array:32 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6866b30ba4c9157ea0e76614" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/025346c0026bbc9165a0aa64e922cbd8.webp" "MediaSize" => 186430 "LongDescription" => "Greek revival inspired property with a front yard and brick siding" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.187Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-025346c0026bbc9165a0aa64e922cbd8.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6866b30ba4c9157ea0e76615" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/25f99f4d481d8d9564512dcb6690ac98.webp" "MediaSize" => 187888 "LongDescription" => "Neoclassical / greek revival house with brick siding, a front yard, and roof with shingles" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.201Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-25f99f4d481d8d9564512dcb6690ac98.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6866b30ba4c9157ea0e76616" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/ef655ed272084152185feb5eed1eddea.webp" "MediaSize" => 214896 "LongDescription" => "View of front of home with brick siding, a front yard, and a shingled roof" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.200Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-ef655ed272084152185feb5eed1eddea.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6866b30ba4c9157ea0e76617" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/08d4b51d2353c214ade2d73cabc70073.webp" "MediaSize" => 119239 "LongDescription" => "Entryway featuring stairs, healthy amount of natural light, and wood finished floors" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.090Z" "ImageWidth" => 1023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-08d4b51d2353c214ade2d73cabc70073.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1023x682" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6866b30ba4c9157ea0e76618" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/3d50e22368d8c08457e8529a0029a153.webp" "MediaSize" => 96959 "LongDescription" => "Stairs with a towering ceiling and wood finished floors" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.111Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-3d50e22368d8c08457e8529a0029a153.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6866b30ba4c9157ea0e76619" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/367f047e0fea392a1e3e844f8c770f3f.webp" "MediaSize" => 105114 "LongDescription" => "Living area with light colored carpet and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.148Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-367f047e0fea392a1e3e844f8c770f3f.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6866b30ba4c9157ea0e7661a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/52ae3afe673bc6c2275fb23ffe9f4d04.webp" "MediaSize" => 95928 "LongDescription" => "Dining room featuring a chandelier, stairs, wood finished floors, and carpet" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.152Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-52ae3afe673bc6c2275fb23ffe9f4d04.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6866b30ba4c9157ea0e7661b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/279915cb02ff27baaede6a3287c68fb0.webp" "MediaSize" => 115869 "LongDescription" => "Living room with a fireplace with flush hearth, a ceiling fan, and dark wood-type flooring" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.149Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-279915cb02ff27baaede6a3287c68fb0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6866b30ba4c9157ea0e7661c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/67d6e07f593ecaf5a349b3bab6d6eaf7.webp" "MediaSize" => 120642 "LongDescription" => "Dining space with wood finished floors and a ceiling fan" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.100Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-67d6e07f593ecaf5a349b3bab6d6eaf7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6866b30ba4c9157ea0e7661d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/0d7514c311831d9990a4c3cc79d85227.webp" "MediaSize" => 106120 "LongDescription" => "Kitchen featuring black appliances, dark wood-style floors, a center island, and a kitchen breakfast bar" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.178Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-0d7514c311831d9990a4c3cc79d85227.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6866b30ba4c9157ea0e7661e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/d47244fbbad2470beabf11053c269f11.webp" "MediaSize" => 83361 "LongDescription" => "Half bath featuring toilet and vanity" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.168Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-d47244fbbad2470beabf11053c269f11.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6866b30ba4c9157ea0e7661f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/d0d560053d1a8a1ba816a4175ca11f92.webp" "MediaSize" => 104939 "LongDescription" => "Sunroom / solarium with a wooden deck and a decorative wall" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.120Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-d0d560053d1a8a1ba816a4175ca11f92.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6866b30ba4c9157ea0e76620" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/c926c440b6b35836e138e01196196c63.webp" "MediaSize" => 89908 "LongDescription" => "Corridor featuring an upstairs landing and carpet floors" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.087Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-c926c440b6b35836e138e01196196c63.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6866b30ba4c9157ea0e76621" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/fb015c1bf550a03978efc14aadd88f62.webp" "MediaSize" => 80185 "LongDescription" => "Bedroom with light colored carpet and ceiling fan" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.097Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-fb015c1bf550a03978efc14aadd88f62.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "6866b30ba4c9157ea0e76622" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/99a2805b86ec438e118e52c950f6598b.webp" "MediaSize" => 95053 "LongDescription" => "Bedroom with carpet flooring and ceiling fan" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.117Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-99a2805b86ec438e118e52c950f6598b.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "6866b30ba4c9157ea0e76623" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/7d70043f0f37ac6682b5e39bd018bc4d.webp" "MediaSize" => 85561 "LongDescription" => "Full bath with a stall shower, vanity, and a bath" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.094Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-7d70043f0f37ac6682b5e39bd018bc4d.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "6866b30ba4c9157ea0e76624" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/e3b19696ebc20cd33be3fedd5456a72e.webp" "MediaSize" => 87857 "LongDescription" => "Office space featuring light carpet and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.103Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-e3b19696ebc20cd33be3fedd5456a72e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "6866b30ba4c9157ea0e76625" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/7d82a3a851928d7fbc826b3b6395e223.webp" "MediaSize" => 97516 "LongDescription" => "Bedroom featuring carpet" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.149Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-7d82a3a851928d7fbc826b3b6395e223.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 18 => array:12 [ "Order" => 18 "MediaKey" => "6866b30ba4c9157ea0e76626" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/be5eb59831dbbe5d7c9ca0d7e36d1bcc.webp" "MediaSize" => 88112 "LongDescription" => "Bedroom with carpet flooring" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.169Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-be5eb59831dbbe5d7c9ca0d7e36d1bcc.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 19 => array:12 [ "Order" => 19 "MediaKey" => "6866b30ba4c9157ea0e76627" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/5a3b366d63cdbc40eb9b6ee661f013b0.webp" "MediaSize" => 87070 "LongDescription" => "Bathroom featuring plenty of natural light, vanity, and a shower with shower curtain" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.149Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-5a3b366d63cdbc40eb9b6ee661f013b0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 20 => array:12 [ "Order" => 20 "MediaKey" => "6866b30ba4c9157ea0e76628" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/4ce0af47f9aa2d3ee319c557f29d9d73.webp" "MediaSize" => 92720 "LongDescription" => "Bedroom featuring carpet flooring and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.134Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-4ce0af47f9aa2d3ee319c557f29d9d73.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 21 => array:12 [ "Order" => 21 "MediaKey" => "6866b30ba4c9157ea0e76629" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/1485dd454d137aa98fcdd613b9e701a8.webp" "MediaSize" => 61579 "LongDescription" => "Indoor dry bar with light wood-style floors, stainless steel microwave, and recessed lighting" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.112Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-1485dd454d137aa98fcdd613b9e701a8.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 22 => array:12 [ "Order" => 22 "MediaKey" => "6866b30ba4c9157ea0e7662a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/607d3391e559d5606043e350c9abd725.webp" "MediaSize" => 110322 "LongDescription" => "Living room with ceiling fan, light wood-style flooring, a fireplace, and recessed lighting" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.092Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-607d3391e559d5606043e350c9abd725.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 23 => array:12 [ "Order" => 23 "MediaKey" => "6866b30ba4c9157ea0e7662b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/37abf9ae59d4d9e8977fa2908b0deac7.webp" "MediaSize" => 76025 "LongDescription" => "Living area with wood finished floors and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.095Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-37abf9ae59d4d9e8977fa2908b0deac7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 24 => array:12 [ "Order" => 24 "MediaKey" => "6866b30ba4c9157ea0e7662c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/876843a05dfc9a1814f03bd00e210ed6.webp" "MediaSize" => 76897 "LongDescription" => "Bedroom featuring wood finished floors and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.165Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-876843a05dfc9a1814f03bd00e210ed6.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 25 => array:12 [ "Order" => 25 "MediaKey" => "6866b30ba4c9157ea0e7662d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/c3953a2fc0e4086e61a2499403a66268.webp" "MediaSize" => 91631 "LongDescription" => "Full bathroom with tile patterned flooring, vanity, and curtained shower" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.117Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-c3953a2fc0e4086e61a2499403a66268.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 26 => array:12 [ "Order" => 26 "MediaKey" => "6866b30ba4c9157ea0e7662e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/31c1a45422132f56c83f5e52cffb568b.webp" "MediaSize" => 138604 "LongDescription" => "View of patio / terrace with outdoor dining area" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.151Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-31c1a45422132f56c83f5e52cffb568b.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 27 => array:12 [ "Order" => 27 "MediaKey" => "6866b30ba4c9157ea0e7662f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/79c06895b54054991ea591151e33951c.webp" "MediaSize" => 183236 "LongDescription" => "View of grassy yard with a deck" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.121Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-79c06895b54054991ea591151e33951c.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 28 => array:12 [ "Order" => 28 "MediaKey" => "6866b30ba4c9157ea0e76630" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/33417d71c439785c9e45a9a98d3b655a.webp" "MediaSize" => 201092 "LongDescription" => "Aerial view of property and surrounding area" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.168Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-33417d71c439785c9e45a9a98d3b655a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 29 => array:12 [ "Order" => 29 "MediaKey" => "6866b30ba4c9157ea0e76631" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/1dfb64ecce16b50fd62228ffb9d7946a.webp" "MediaSize" => 193703 "LongDescription" => "Aerial view of residential area" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.117Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-1dfb64ecce16b50fd62228ffb9d7946a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 30 => array:12 [ "Order" => 30 "MediaKey" => "6866b30ba4c9157ea0e76632" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/e3ec9d1a3709faab2d2d1c9b33975b23.webp" "MediaSize" => 166732 "LongDescription" => "Drone / aerial view" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.185Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-e3ec9d1a3709faab2d2d1c9b33975b23.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 31 => array:12 [ "Order" => 31 "MediaKey" => "6866b30ba4c9157ea0e76633" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/ec92f14fb926836acbbd200b8b98cc46.webp" "MediaSize" => 119464 "LongDescription" => "Garage featuring concrete driveway" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.109Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-ec92f14fb926836acbbd200b8b98cc46.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] ] +"ID": "23633" }
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 'MIS203448845'/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 'MIS203448845'&$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 'MIS203448845'/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 'MIS203448845'&$expand=Media&$count=true" => array:2 [ "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#2835 +items: array:1 [ 0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2837 +post_id: "23633" +post_author: 1 +"ListingKey": "MIS203448845" +"ListingId": "25041121" +"PropertyType": "Residential" +"PropertySubType": "Single Family Residence" +"StandardStatus": "Active" +"ModificationTimestamp": "2025-07-03T16:44:38Z" +"RFModificationTimestamp": "2025-07-03T16:49:50Z" +"ListPrice": 815000.0 +"BathroomsTotalInteger": 4.0 +"BathroomsHalf": 1 +"BedroomsTotal": 5.0 +"LotSizeArea": 0 +"LivingArea": 3952.0 +"BuildingAreaTotal": 0 +"City": "Chesterfield" +"PostalCode": "63017" +"UnparsedAddress": "2259 Sycamore Drive, Chesterfield, Missouri 63017" +"Coordinates": array:2 [ 0 => -90.56984 1 => 38.619293 ] +"Latitude": 38.619293 +"Longitude": -90.56984 +"YearBuilt": 1995 +"InternetAddressDisplayYN": true +"FeedTypes": "IDX" +"ListAgentFullName": "Shantelle Harris" +"ListOfficeName": "RE/MAX Results" +"ListAgentMlsId": "SHAHARRI" +"ListOfficeMlsId": "RMXR01" +"OriginatingSystemName": "MARIS" +"PublicRemarks": """ Exceptional Living in Chesterfield’s Twin Estates\n Experience refined living at 2259 Sycamore, a beautifully appointed residence in the prestigious Twin Estates neighborhood, served by the acclaimed Rockwood School District. This expansive home blends timeless elegance with everyday comfort, offering the perfect balance of space, privacy, and functionality. A dramatic two-story entry welcomes you inside, where dual staircases provide seamless access to both the front and back of the home. The thoughtfully designed layout features two spacious family rooms, a private primary suite with an ensuite bath, and a sun-drenched sunroom that opens to an inviting deck and walk-out patio—perfect for entertaining or quiet moments outdoors. Car collectors and adventurers alike will appreciate the 1,300 sq ft garage with a commercial-grade door, ideal for an RV, boat, or large vehicle, along with a parking pad that accommodates up to 7 cars. A dedicated wine cellar adds a refined touch for elegant entertaining. This is more than a home—it’s a lifestyle. VA buyers have the rare opportunity to assume an existing low-interest VA loan, offering exceptional value in today’s market. """ +"AboveGradeFinishedArea": 2952 +"AboveGradeFinishedAreaSource": "Public Records" +"Appliances": array:12 [ 0 => "Electric Cooktop" 1 => "Dishwasher" 2 => "Disposal" 3 => "Dryer" 4 => "Exhaust Fan" 5 => "Microwave" 6 => "Electric Oven" 7 => "Built-In Electric Range" 8 => "Refrigerator" 9 => "Washer" 10 => "Water Heater" 11 => "Bar Fridge" ] +"ArchitecturalStyle": array:1 [ 0 => "Traditional" ] +"AssociationAmenities": "Other" +"AssociationFee": "30" +"AssociationFeeFrequency": "Monthly" +"AssociationFeeIncludes": array:1 [ 0 => "Other" ] +"AssociationYN": true +"AttachedGarageYN": true +"Basement": array:6 [ 0 => "9 ft + Pour" 1 => "Egress Window" 2 => "Exterior Entry" 3 => "Finished" 4 => "Sleeping Area" 5 => "Walk-Out Access" ] +"BasementYN": true +"BathroomsFull": 3 +"BelowGradeFinishedArea": 1000 +"BelowGradeFinishedAreaSource": "Public Records" +"BuildingFeatures": array:5 [ 0 => "Basement" 1 => "Bathrooms" 2 => "Patio" 3 => "Security System" 4 => "Storage" ] +"ConstructionMaterials": array:2 [ 0 => "Brick" 1 => "Vinyl Siding" ] +"Cooling": array:1 [ 0 => "Central Air" ] +"CountyOrParish": "St. Louis" +"CreationDate": "2025-06-13T03:56:47.641876+00:00" +"CrossStreet": "Engelwood" +"Disclosures": array:1 [ 0 => "Code Compliance Required" ] +"DocumentsAvailable": array:1 [ 0 => "Other" ] +"DocumentsChangeTimestamp": "2025-07-03T16:44:38Z" +"DocumentsCount": 3 +"DoorFeatures": array:2 [ 0 => "French Door(s)" 1 => "Storm Door(s)" ] +"ElementarySchool": "Kehrs Mill Elem." +"ExteriorFeatures": array:2 [ 0 => "Entry Steps/Stairs" 1 => "Storage" ] +"Fencing": array:1 [ 0 => "None" ] +"FireplaceFeatures": array:2 [ 0 => "Basement" 1 => "Family Room" ] +"FireplaceYN": true +"FireplacesTotal": "2" +"Flooring": array:3 [ 0 => "Carpet" 1 => "Hardwood" 2 => "Vinyl" ] +"FoundationDetails": array:1 [ 0 => "Concrete Perimeter" ] +"GarageSpaces": "6" +"GarageYN": true +"Heating": array:1 [ 0 => "Forced Air" ] +"HighSchool": "Marquette Sr. High" +"HighSchoolDistrict": "Rockwood R-VI" +"HomeWarrantyYN": true +"InteriorFeatures": array:16 [ 0 => "Bar" 1 => "Bookcases" 2 => "Breakfast Room" 3 => "Double Vanity" 4 => "Granite Counters" 5 => "High Ceilings" 6 => "Kitchen Island" 7 => "Open Floorplan" 8 => "Pantry" 9 => "Separate Dining" 10 => "Separate Shower" 11 => "Storage" 12 => "Tub" 13 => "Two Story Entrance Foyer" 14 => "Walk-In Closet(s)" 15 => "Workshop/Hobby Area" ] +"RFTransactionType": "For Sale" +"InternetAutomatedValuationDisplayYN": true +"InternetEntireListingDisplayYN": true +"LaundryFeatures": array:2 [ 0 => "Laundry Room" 1 => "Main Level" ] +"Levels": array:1 [ 0 => "Two" ] +"ListAOR": "St. Louis Association of REALTORS" +"ListAgentAOR": "St. Louis Association of REALTORS" +"ListAgentKey": "78242332" +"ListOfficeAOR": "St. Louis Association of REALTORS" +"ListOfficeKey": "2828" +"ListOfficePhone": "314-781-7777" +"ListingService": "Full Service" +"ListingTerms": "Assumable,Cash,Conventional,FHA,VA Loan" +"LivingAreaSource": "Public Records" +"LotFeatures": array:4 [ 0 => "Back Yard" 1 => "Corner Lot" 2 => "Few Trees" 3 => "Front Yard" ] +"LotSizeAcres": 0.35 +"LotSizeDimensions": "152 X 100" +"LotSizeSource": "Public Records" +"MLSAreaMajor": "348 - Marquette" +"MajorChangeTimestamp": "2025-07-03T06:31:05Z" +"MiddleOrJuniorSchool": "Crestview Middle" +"MlgCanUse": array:1 [ 0 => "IDX" ] +"MlgCanView": true +"MlsStatus": "Active" +"OnMarketDate": "2025-07-03" +"OriginalEntryTimestamp": "2025-06-13T03:55:56Z" +"OriginalListPrice": 815000 +"OwnershipType": "Private" +"ParcelNumber": "21S-43-0910" +"ParkingFeatures": array:11 [ 0 => "Additional Parking" 1 => "Attached" 2 => "Boat" 3 => "Covered" 4 => "Driveway" 5 => "Garage" 6 => "Garage Door Opener" 7 => "Garage Faces Side" 8 => "Inside Entrance" 9 => "Oversized" 10 => "RV Garage" ] +"PhotosChangeTimestamp": "2025-07-03T16:43:38Z" +"PhotosCount": 32 +"Possession": array:1 [ 0 => "Close Of Escrow" ] +"RoadSurfaceType": array:1 [ 0 => "Concrete" ] +"Roof": array:1 [ 0 => "Shingle" ] +"RoomsTotal": "9" +"SecurityFeatures": array:2 [ 0 => "Carbon Monoxide Detector(s)" 1 => "Smoke Detector(s)" ] +"Sewer": array:1 [ 0 => "Public Sewer" ] +"ShowingRequirements": array:2 [ 0 => "Appointment Only" 1 => "Occupied" ] +"SpecialListingConditions": array:1 [ 0 => "Standard" ] +"StateOrProvince": "MO" +"StatusChangeTimestamp": "2025-07-03T06:31:05Z" +"StreetName": "Sycamore" +"StreetNumber": "2259" +"StreetNumberNumeric": "2259" +"StreetSuffix": "Drive" +"StructureType": array:1 [ 0 => "House" ] +"SubdivisionName": "Twin Estates At Sycamore Ridge" +"TaxAnnualAmount": "8172" +"TaxLegalDescription": "TWIN ESTATES AT SYCAMORE RIDGE LOT 11" +"TaxYear": "2024" +"Township": "Chesterfield" +"WaterSource": array:1 [ 0 => "Public" ] +"YearBuiltSource": "Public Records" +"MIS_EfficiencyYN": "0" +"MIS_MainAndUpperLevelBathrooms": "3" +"MIS_CurrentPrice": "815000.00" +"MIS_LowerLevelBedrooms": "1" +"MIS_AuctionYN": "0" +"MIS_MainLevelBathroomsFull": "0" +"MIS_LowerLevelBathroomsHalf": "0" +"MIS_MainLevelBathroomsHalf": "1" +"MIS_LowerLevelBathroomsFull": "1" +"MIS_UpperLevelBathroomsFull": "2" +"MIS_RoomCount": "16" +"MIS_UpperLevelBathroomsHalf": "0" +"MIS_UpperLevelBedrooms": "4" +"MIS_PreviousStatus": "Coming Soon" +"MIS_SecondMortgageYN": "0" +"MIS_PoolYN": "0" +"MIS_MainAndUpperLevelBedrooms": "4" +"MIS_Section": "CHESTERFIELD" +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('MIS203448845')" +"provider_name": "MARIS" +"Media": array:32 [ 0 => array:12 [ "Order" => 0 "MediaKey" => "6866b30ba4c9157ea0e76614" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/025346c0026bbc9165a0aa64e922cbd8.webp" "MediaSize" => 186430 "LongDescription" => "Greek revival inspired property with a front yard and brick siding" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.187Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-025346c0026bbc9165a0aa64e922cbd8.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 1 => array:12 [ "Order" => 1 "MediaKey" => "6866b30ba4c9157ea0e76615" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/25f99f4d481d8d9564512dcb6690ac98.webp" "MediaSize" => 187888 "LongDescription" => "Neoclassical / greek revival house with brick siding, a front yard, and roof with shingles" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.201Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-25f99f4d481d8d9564512dcb6690ac98.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 2 => array:12 [ "Order" => 2 "MediaKey" => "6866b30ba4c9157ea0e76616" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/ef655ed272084152185feb5eed1eddea.webp" "MediaSize" => 214896 "LongDescription" => "View of front of home with brick siding, a front yard, and a shingled roof" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.200Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-ef655ed272084152185feb5eed1eddea.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 3 => array:12 [ "Order" => 3 "MediaKey" => "6866b30ba4c9157ea0e76617" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/08d4b51d2353c214ade2d73cabc70073.webp" "MediaSize" => 119239 "LongDescription" => "Entryway featuring stairs, healthy amount of natural light, and wood finished floors" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.090Z" "ImageWidth" => 1023 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-08d4b51d2353c214ade2d73cabc70073.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1023x682" ] 4 => array:12 [ "Order" => 4 "MediaKey" => "6866b30ba4c9157ea0e76618" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/3d50e22368d8c08457e8529a0029a153.webp" "MediaSize" => 96959 "LongDescription" => "Stairs with a towering ceiling and wood finished floors" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.111Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-3d50e22368d8c08457e8529a0029a153.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 5 => array:12 [ "Order" => 5 "MediaKey" => "6866b30ba4c9157ea0e76619" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/367f047e0fea392a1e3e844f8c770f3f.webp" "MediaSize" => 105114 "LongDescription" => "Living area with light colored carpet and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.148Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-367f047e0fea392a1e3e844f8c770f3f.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 6 => array:12 [ "Order" => 6 "MediaKey" => "6866b30ba4c9157ea0e7661a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/52ae3afe673bc6c2275fb23ffe9f4d04.webp" "MediaSize" => 95928 "LongDescription" => "Dining room featuring a chandelier, stairs, wood finished floors, and carpet" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.152Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-52ae3afe673bc6c2275fb23ffe9f4d04.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 7 => array:12 [ "Order" => 7 "MediaKey" => "6866b30ba4c9157ea0e7661b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/279915cb02ff27baaede6a3287c68fb0.webp" "MediaSize" => 115869 "LongDescription" => "Living room with a fireplace with flush hearth, a ceiling fan, and dark wood-type flooring" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.149Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-279915cb02ff27baaede6a3287c68fb0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 8 => array:12 [ "Order" => 8 "MediaKey" => "6866b30ba4c9157ea0e7661c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/67d6e07f593ecaf5a349b3bab6d6eaf7.webp" "MediaSize" => 120642 "LongDescription" => "Dining space with wood finished floors and a ceiling fan" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.100Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-67d6e07f593ecaf5a349b3bab6d6eaf7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 9 => array:12 [ "Order" => 9 "MediaKey" => "6866b30ba4c9157ea0e7661d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/0d7514c311831d9990a4c3cc79d85227.webp" "MediaSize" => 106120 "LongDescription" => "Kitchen featuring black appliances, dark wood-style floors, a center island, and a kitchen breakfast bar" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.178Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-0d7514c311831d9990a4c3cc79d85227.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 10 => array:12 [ "Order" => 10 "MediaKey" => "6866b30ba4c9157ea0e7661e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/d47244fbbad2470beabf11053c269f11.webp" "MediaSize" => 83361 "LongDescription" => "Half bath featuring toilet and vanity" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.168Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-d47244fbbad2470beabf11053c269f11.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 11 => array:12 [ "Order" => 11 "MediaKey" => "6866b30ba4c9157ea0e7661f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/d0d560053d1a8a1ba816a4175ca11f92.webp" "MediaSize" => 104939 "LongDescription" => "Sunroom / solarium with a wooden deck and a decorative wall" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.120Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-d0d560053d1a8a1ba816a4175ca11f92.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 12 => array:12 [ "Order" => 12 "MediaKey" => "6866b30ba4c9157ea0e76620" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/c926c440b6b35836e138e01196196c63.webp" "MediaSize" => 89908 "LongDescription" => "Corridor featuring an upstairs landing and carpet floors" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.087Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-c926c440b6b35836e138e01196196c63.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 13 => array:12 [ "Order" => 13 "MediaKey" => "6866b30ba4c9157ea0e76621" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/fb015c1bf550a03978efc14aadd88f62.webp" "MediaSize" => 80185 "LongDescription" => "Bedroom with light colored carpet and ceiling fan" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.097Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-fb015c1bf550a03978efc14aadd88f62.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 14 => array:12 [ "Order" => 14 "MediaKey" => "6866b30ba4c9157ea0e76622" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/99a2805b86ec438e118e52c950f6598b.webp" "MediaSize" => 95053 "LongDescription" => "Bedroom with carpet flooring and ceiling fan" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.117Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-99a2805b86ec438e118e52c950f6598b.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 15 => array:12 [ "Order" => 15 "MediaKey" => "6866b30ba4c9157ea0e76623" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/7d70043f0f37ac6682b5e39bd018bc4d.webp" "MediaSize" => 85561 "LongDescription" => "Full bath with a stall shower, vanity, and a bath" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.094Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-7d70043f0f37ac6682b5e39bd018bc4d.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 16 => array:12 [ "Order" => 16 "MediaKey" => "6866b30ba4c9157ea0e76624" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/e3b19696ebc20cd33be3fedd5456a72e.webp" "MediaSize" => 87857 "LongDescription" => "Office space featuring light carpet and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.103Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-e3b19696ebc20cd33be3fedd5456a72e.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 17 => array:12 [ "Order" => 17 "MediaKey" => "6866b30ba4c9157ea0e76625" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/7d82a3a851928d7fbc826b3b6395e223.webp" "MediaSize" => 97516 "LongDescription" => "Bedroom featuring carpet" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.149Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-7d82a3a851928d7fbc826b3b6395e223.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 18 => array:12 [ "Order" => 18 "MediaKey" => "6866b30ba4c9157ea0e76626" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/be5eb59831dbbe5d7c9ca0d7e36d1bcc.webp" "MediaSize" => 88112 "LongDescription" => "Bedroom with carpet flooring" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.169Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-be5eb59831dbbe5d7c9ca0d7e36d1bcc.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 19 => array:12 [ "Order" => 19 "MediaKey" => "6866b30ba4c9157ea0e76627" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/5a3b366d63cdbc40eb9b6ee661f013b0.webp" "MediaSize" => 87070 "LongDescription" => "Bathroom featuring plenty of natural light, vanity, and a shower with shower curtain" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.149Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-5a3b366d63cdbc40eb9b6ee661f013b0.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 20 => array:12 [ "Order" => 20 "MediaKey" => "6866b30ba4c9157ea0e76628" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/4ce0af47f9aa2d3ee319c557f29d9d73.webp" "MediaSize" => 92720 "LongDescription" => "Bedroom featuring carpet flooring and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.134Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-4ce0af47f9aa2d3ee319c557f29d9d73.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 21 => array:12 [ "Order" => 21 "MediaKey" => "6866b30ba4c9157ea0e76629" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/1485dd454d137aa98fcdd613b9e701a8.webp" "MediaSize" => 61579 "LongDescription" => "Indoor dry bar with light wood-style floors, stainless steel microwave, and recessed lighting" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.112Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-1485dd454d137aa98fcdd613b9e701a8.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 22 => array:12 [ "Order" => 22 "MediaKey" => "6866b30ba4c9157ea0e7662a" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/607d3391e559d5606043e350c9abd725.webp" "MediaSize" => 110322 "LongDescription" => "Living room with ceiling fan, light wood-style flooring, a fireplace, and recessed lighting" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.092Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-607d3391e559d5606043e350c9abd725.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 23 => array:12 [ "Order" => 23 "MediaKey" => "6866b30ba4c9157ea0e7662b" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/37abf9ae59d4d9e8977fa2908b0deac7.webp" "MediaSize" => 76025 "LongDescription" => "Living area with wood finished floors and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.095Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-37abf9ae59d4d9e8977fa2908b0deac7.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 24 => array:12 [ "Order" => 24 "MediaKey" => "6866b30ba4c9157ea0e7662c" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/876843a05dfc9a1814f03bd00e210ed6.webp" "MediaSize" => 76897 "LongDescription" => "Bedroom featuring wood finished floors and baseboards" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.165Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-876843a05dfc9a1814f03bd00e210ed6.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 25 => array:12 [ "Order" => 25 "MediaKey" => "6866b30ba4c9157ea0e7662d" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/c3953a2fc0e4086e61a2499403a66268.webp" "MediaSize" => 91631 "LongDescription" => "Full bathroom with tile patterned flooring, vanity, and curtained shower" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.117Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-c3953a2fc0e4086e61a2499403a66268.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 26 => array:12 [ "Order" => 26 "MediaKey" => "6866b30ba4c9157ea0e7662e" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/31c1a45422132f56c83f5e52cffb568b.webp" "MediaSize" => 138604 "LongDescription" => "View of patio / terrace with outdoor dining area" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.151Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-31c1a45422132f56c83f5e52cffb568b.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 27 => array:12 [ "Order" => 27 "MediaKey" => "6866b30ba4c9157ea0e7662f" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/79c06895b54054991ea591151e33951c.webp" "MediaSize" => 183236 "LongDescription" => "View of grassy yard with a deck" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.121Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-79c06895b54054991ea591151e33951c.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] 28 => array:12 [ "Order" => 28 "MediaKey" => "6866b30ba4c9157ea0e76630" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/33417d71c439785c9e45a9a98d3b655a.webp" "MediaSize" => 201092 "LongDescription" => "Aerial view of property and surrounding area" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.168Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-33417d71c439785c9e45a9a98d3b655a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 29 => array:12 [ "Order" => 29 "MediaKey" => "6866b30ba4c9157ea0e76631" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/1dfb64ecce16b50fd62228ffb9d7946a.webp" "MediaSize" => 193703 "LongDescription" => "Aerial view of residential area" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.117Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-1dfb64ecce16b50fd62228ffb9d7946a.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 30 => array:12 [ "Order" => 30 "MediaKey" => "6866b30ba4c9157ea0e76632" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/e3ec9d1a3709faab2d2d1c9b33975b23.webp" "MediaSize" => 166732 "LongDescription" => "Drone / aerial view" "ImageHeight" => 575 "MediaModificationTimestamp" => "2025-07-03T16:42:51.185Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-e3ec9d1a3709faab2d2d1c9b33975b23.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x575" ] 31 => array:12 [ "Order" => 31 "MediaKey" => "6866b30ba4c9157ea0e76633" "MediaURL" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/ec92f14fb926836acbbd200b8b98cc46.webp" "MediaSize" => 119464 "LongDescription" => "Garage featuring concrete driveway" "ImageHeight" => 682 "MediaModificationTimestamp" => "2025-07-03T16:42:51.109Z" "ImageWidth" => 1024 "MediaType" => "webp" "Thumbnail" => "https://cdn.realtyfeed.com/cdn/43/MIS203448845/thumbnail-ec92f14fb926836acbbd200b8b98cc46.webp" "MediaCategory" => "Photo" "ImageSizeDescription" => "1024x682" ] ] +"ID": "23633" } ] +success: true +page_size: 1 +page_count: 1 +count: 1 +after_key: "" } "RF Response Time" => "0.14 seconds" ] ]