array:1 [
"RF Query: /Property?$select=ALL&$orderby=ListPrice ASC&$top=12&$skip=57600&$filter=((StandardStatus ne 'Closed' and StandardStatus ne 'Expired' and StandardStatus ne 'Canceled') or ListAgentMlsId eq '250887')&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#3007
+items: array:12 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3003
+post_id: "100763"
+post_author: 1
+"ListingKey": "MRD12656747"
+"ListingId": "12656747"
+"PropertyType": "Residential"
+"StandardStatus": "Active Under Contract"
+"ModificationTimestamp": "2026-07-14T12:48:02Z"
+"RFModificationTimestamp": "2026-07-14T12:50:53Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2496.0
+"BuildingAreaTotal": 0
+"City": "Naperville"
+"PostalCode": "60565"
+"UnparsedAddress": "421 Russet Avenue, Naperville, Illinois 60565"
+"Coordinates": array:2 [
0 => -88.1492399
1 => 41.7412566
]
+"Latitude": 41.7412566
+"Longitude": -88.1492399
+"YearBuilt": 1979
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Daniel Carney"
+"ListOfficeName": "GC Realty and Development"
+"ListAgentMlsId": "257936"
+"ListOfficeMlsId": "1166"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Completely renovated and move-in ready, this stunning 5-bedroom, 2.5-bath home offers nearly 3,000 square feet of finished living space in highly sought-after Naperville School District 204, served by acclaimed Waubonsie Valley High School. The thoughtfully redesigned main level features luxury vinyl plank flooring, abundant natural light, spacious living and dining areas, a cozy fireplace, and a beautifully updated kitchen complete with quartz countertops, stainless steel appliances, and ample cabinet and prep space. A convenient first-floor laundry room adds everyday functionality. Upstairs, you'll find five generously sized bedrooms, including a spacious primary suite featuring a large walk-in closet and a luxurious private bath with a double vanity and oversized walk-in shower. New carpeting throughout the second floor provides comfort and warmth. The finished basement adds approximately 500 square feet of additional living space, perfect for a recreation room, home office, fitness area, media room, or playroom. Enjoy peace of mind with extensive recent updates, including a new roof, new windows, new driveway, new HVAC system, and new water heater. The attached 2-car garage features a durable epoxy-coated floor for a clean, polished finish. Step outside to a large backyard with an expansive deck, providing the perfect setting for entertaining, relaxing, or enjoying outdoor activities. Ideally located near parks, shopping, dining, transportation, and top-rated schools, this turnkey home offers the rare combination of modern finishes, functional living space, and an exceptional Naperville location."
+"ActivationDate": "2026-07-07"
+"Appliances": array:7 [
0 => "Range"
1 => "Microwave"
2 => "Dishwasher"
3 => "High End Refrigerator"
4 => "Washer"
5 => "Dryer"
6 => "Wine Refrigerator"
]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [
0 => "None"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Partial"
]
+"BathroomsFull": 2
+"BedroomsPossible": 5
+"BuyerAgentEmail": "[email protected]"
+"BuyerAgentFirstName": "Joan"
+"BuyerAgentFullName": "Joan Walters"
+"BuyerAgentKey": "261174"
+"BuyerAgentLastName": "Walters"
+"BuyerAgentMlsId": "261174"
+"BuyerAgentMobilePhone": "630-788-8593"
+"BuyerOfficeFax": "(630) 820-7240"
+"BuyerOfficeKey": "23120"
+"BuyerOfficeMlsId": "23120"
+"BuyerOfficeName": "john greene, Realtor"
+"BuyerOfficePhone": "630-820-6500"
+"BuyerOfficeURL": "http://www.johngreenerealtor.com"
+"CoListAgentEmail": "[email protected];[email protected]"
+"CoListAgentFirstName": "Peter"
+"CoListAgentFullName": "Peter Rodriguez"
+"CoListAgentKey": "265937"
+"CoListAgentLastName": "Rodriguez"
+"CoListAgentMiddleName": "J"
+"CoListAgentMlsId": "265937"
+"CoListAgentMobilePhone": "(708) 990-4964"
+"CoListAgentStateLicense": "475200160"
+"CoListOfficeEmail": "[email protected]"
+"CoListOfficeFax": "(630) 587-7301"
+"CoListOfficeKey": "1166"
+"CoListOfficeMlsId": "1166"
+"CoListOfficeName": "GC Realty and Development"
+"CoListOfficePhone": "(630) 587-7400"
+"CoListOfficeURL": "http://www.gcrealtyinc.com"
+"ConstructionMaterials": array:2 [
0 => "Aluminum Siding"
1 => "Brick"
]
+"Contingency": "Attorney/Inspection"
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Du Page"
+"CreationDate": "2026-07-07T17:50:59.142313+00:00"
+"DaysOnMarket": 9
+"Directions": "South of 75th - West of Modaff Rd - Culdesac"
+"ElementarySchool": "Owen Elementary School"
+"ElementarySchoolDistrict": "204"
+"FireplaceFeatures": array:1 [
0 => "Wood Burning"
]
+"FireplacesTotal": "1"
+"Flooring": array:2 [
0 => "Laminate"
1 => "Carpet"
]
+"FoundationDetails": array:1 [
0 => "Concrete Perimeter"
]
+"GarageSpaces": "2"
+"HabitableResidenceYN": true
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Waubonsie Valley High School"
+"HighSchoolDistrict": "204"
+"InteriorFeatures": array:4 [
0 => "Walk-In Closet(s)"
1 => "Open Floorplan"
2 => "Dining Combo"
3 => "Quartz Counters"
]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:1 [
0 => "Main Level"
]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Daniel"
+"ListAgentKey": "257936"
+"ListAgentLastName": "Carney"
+"ListAgentMobilePhone": "518-368-1487"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "(630) 587-7301"
+"ListOfficeKey": "1166"
+"ListOfficePhone": "630-587-7400"
+"ListOfficeURL": "http://www.gcrealtyinc.com"
+"ListingContractDate": "2026-07-07"
+"LivingAreaSource": "Estimated"
+"LockBoxType": array:1 [
0 => "SentriLock"
]
+"LotFeatures": array:1 [
0 => "Cul-De-Sac"
]
+"LotSizeAcres": 0.3
+"LotSizeDimensions": "0.3"
+"LotSizeSource": "County Records"
+"MLSAreaMajor": "Naperville"
+"MiddleOrJuniorSchool": "Still Middle School"
+"MiddleOrJuniorSchoolDistrict": "204"
+"MlgCanUse": array:1 [
0 => "IDX"
]
+"MlgCanView": true
+"MlsStatus": "Contingent"
+"OriginalEntryTimestamp": "2026-07-07T17:47:53Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-07-14T12:47:15Z"
+"OwnerName": "TOP SHELF BOSA GROUP LLC"
+"Ownership": "Fee Simple"
+"ParcelNumber": "0725402019"
+"ParkingFeatures": array:7 [
0 => "Asphalt"
1 => "Garage Door Opener"
2 => "Yes"
3 => "Garage Owned"
4 => "Attached"
5 => "Owned"
6 => "Garage"
]
+"ParkingTotal": "4"
+"PatioAndPorchFeatures": array:1 [
0 => "Deck"
]
+"PhotosChangeTimestamp": "2026-07-07T17:12:05Z"
+"PhotosCount": 48
+"Possession": array:1 [
0 => "Closing"
]
+"PurchaseContractDate": "2026-07-13"
+"Roof": array:1 [
0 => "Asphalt"
]
+"RoomType": array:4 [
0 => "Bedroom 5"
1 => "Recreation Room"
2 => "Walk In Closet"
3 => "Utility Room-Lower Level"
]
+"RoomsTotal": "10"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-07-14T12:47:15Z"
+"StreetName": "Russet"
+"StreetNumber": "421"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "Westglen"
+"TaxAnnualAmount": "10357.32"
+"TaxYear": "2025"
+"Township": "Naperville"
+"WaterSource": array:1 [
0 => "Public"
]
+"MRD_BB": "No"
+"MRD_MC": "Active"
+"MRD_RR": "Yes"
+"MRD_UD": "2026-07-14T12:47:15"
+"MRD_VT": "None"
+"MRD_AGE": "41-50 Years"
+"MRD_AON": "Yes"
+"MRD_B78": "No"
+"MRD_CRP": "Naperville"
+"MRD_DIN": "Combined w/ LivRm"
+"MRD_HEM": "Yes"
+"MRD_IDX": "Y"
+"MRD_INF": "School Bus Service,Commuter Bus,Commuter Train"
+"MRD_LSZ": ".25-.49 Acre"
+"MRD_OMT": "0"
+"MRD_SAS": "N"
+"MRD_TPE": "2 Stories"
+"MRD_TXC": "Homeowner,Senior"
+"MRD_TYP": "Detached Single"
+"MRD_LAZIP": "60137"
+"MRD_LOZIP": "60172"
+"MRD_SAZIP": "60565"
+"MRD_SOZIP": "60564"
+"MRD_LACITY": "Glen Ellyn"
+"MRD_LOCITY": "Roselle"
+"MRD_MAX_LP": "699900"
+"MRD_MIN_LP": "699900"
+"MRD_SACITY": "Naperville"
+"MRD_SOCITY": "Naperville"
+"MRD_BRBELOW": "0"
+"MRD_DOCDATE": "2026-07-07T17:24:50"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_SASTATE": "IL"
+"MRD_SOSTATE": "IL"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "3"
+"MRD_FloodZone": "No"
+"MRD_BSMNT_SQFT": "700"
+"MRD_CONTTOSHOW": "No - has seller written direction"
+"MRD_REHAB_YEAR": "2026"
+"MRD_TOTAL_SQFT": "2496"
+"MRD_UPPER_SQFT": "2496"
+"MRD_LB_LOCATION": "C"
+"MRD_LO_LOCATION": "1166"
+"MRD_SO_LOCATION": "23120"
+"MRD_ACTUALSTATUS": "Contingent"
+"MRD_LASTREETNAME": "Stratford Rd."
+"MRD_LOSTREETNAME": "E. Irving Park Rd."
+"MRD_SALE_OR_RENT": "No"
+"MRD_SASTREETNAME": "Swift Lane N"
+"MRD_SOSTREETNAME": "S. Route 59"
+"MRD_ASSESSOR_SQFT": "2496"
+"MRD_RECORDMODDATE": "2026-07-14T12:47:15.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LASTREETNUMBER": "2S037"
+"MRD_LOSTREETNUMBER": "219"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "No"
+"MRD_OpenHouseCount": "0"
+"MRD_SASTREETNUMBER": "69"
+"MRD_SOSTREETNUMBER": "1311"
+"MRD_BuyerTeamCredit": "0"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_AVMOnIDXDisplayYN": "No"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Family Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "2496"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "No"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "3196"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_SHARE_WITH_CLIENTS_YN": "Yes"
+"MRD_ListBrokerMainOfficeID": "1166"
+"MRD_BuyerBrokerMainOfficeID": "23120"
+"MRD_CoListBrokerMainOfficeID": "1166"
+"MRD_MarketTimeOnIDXDisplayYN": "Yes"
+"MRD_SomePhotosVirtuallyStaged": "Yes"
+"MRD_PriceHistoryOnIDXDisplayYN": "Yes"
+"MRD_CoListBrokerOfficeLocationID": "1166"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12656747')"
+"provider_name": "MRED"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"ID": "100763"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2999
+post_id: "4298"
+post_author: 1
+"ListingKey": "MRD11909367"
+"ListingId": "11909367"
+"PropertyType": "Residential"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2023-10-22T15:30:02Z"
+"RFModificationTimestamp": "2023-10-22T15:31:17Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 7000.0
+"BuildingAreaTotal": 0
+"City": "Hickory Hills"
+"PostalCode": "60457"
+"UnparsedAddress": " , Palos Township, Cook County, Illinois 60457, USA "
+"Coordinates": array:2 [
0 => -87.825055
1 => 41.7255879
]
+"Latitude": 41.7255879
+"Longitude": -87.825055
+"YearBuilt": 1952
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Bernadeta Szczech"
+"ListOfficeName": "RE/MAX 10"
+"ListAgentMlsId": "228162"
+"ListOfficeMlsId": "60321"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "WELCOME INVESTORS ,REHABERS, NEW BUYER MUST SEE THIS OPORTUNITY. With your personalized taste, now is the chance to finish this 5-bedroom 4-bathroom dream home!!!!! This beautiful 2 story sits on a 1/2 acre corner lot and features an indoor pool, in-home theater/flex space, 16ft patio sliders open to the huge backyard which is all perfect for entertaining. It has not one but two master suites, one on the 2nd floor and one in the basement!!!!! The 2nd floor Master Suite has a separate loft/living area with an overlook to the entire first floor. The basement master suite has 10ft ceilings with a new foundation and drain tile that will prevent any flooding. The garage has so much space that can be used for either 6 cars or 4 cars and an exercise room. The builder installed the black/black European windows, and the exterior Hardie Board finishes. All framing, drywall , plumbing and electric has been fully completed. Permits and plans are on hand for The City of Hickory Hills.**Kitchen Cabinets, Toilets, Tubs, and Delta/Brizo Faucets for the entire house are available for additional $$$. A Seller willing to work with any future buyer. Must see this before it is gone. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!"
+"Appliances": array:1 [
0 => "Double Oven"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [
0 => "None"
]
+"Basement": array:1 [
0 => "Partial"
]
+"BathroomsFull": 4
+"BedroomsPossible": 5
+"CommunityFeatures": array:2 [
0 => "Street Lights"
1 => "Street Paved"
]
+"Cooling": array:1 [
0 => "Central Air"
]
+"CountyOrParish": "Cook"
+"CreationDate": "2023-10-16T04:23:12.613756+00:00"
+"DaysOnMarket": 9
+"Directions": "87th St. to 84th Ct. N to 85st E to 84th Ave. to address on your left"
+"ElementarySchoolDistrict": "109"
+"GarageSpaces": "6"
+"Heating": array:1 [
0 => "Natural Gas"
]
+"HighSchool": "Argo Community High School"
+"HighSchoolDistrict": "217"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAgentEmail": "[email protected]"
+"ListAgentFax": "708-233-9181"
+"ListAgentFirstName": "Bernadeta"
+"ListAgentKey": "228162"
+"ListAgentLastName": "Szczech"
+"ListAgentOfficePhone": "708-857-1021"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "(708) 857-1518"
+"ListOfficeKey": "60321"
+"ListOfficePhone": "708-857-1500"
+"ListingContractDate": "2023-10-14"
+"LivingAreaSource": "Estimated"
+"LockBoxType": array:1 [
0 => "None"
]
+"LotFeatures": array:1 [
0 => "Corner Lot"
]
+"LotSizeAcres": 0.5047
+"LotSizeDimensions": "21986"
+"MLSAreaMajor": "Hickory Hills"
+"MiddleOrJuniorSchoolDistrict": "109"
+"MlsStatus": "Temporarily No Showings"
+"OffMarketDate": "2023-10-22"
+"OriginalEntryTimestamp": "2023-10-16T04:20:44Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2023-10-22T15:29:12Z"
+"OwnerName": "OOR"
+"Ownership": "Fee Simple"
+"ParcelNumber": "18354110010000"
+"ParkingFeatures": array:1 [
0 => "Driveway"
]
+"ParkingTotal": "6"
+"PhotosChangeTimestamp": "2023-10-16T04:22:02Z"
+"PhotosCount": 3
+"Possession": array:1 [
0 => "Closing"
]
+"RoomType": array:4 [
0 => "Bedroom 5"
1 => "Loft"
2 => "Theatre Room"
3 => "Other Room"
]
+"RoomsTotal": "11"
+"Sewer": array:1 [
0 => "Public Sewer"
]
+"SpecialListingConditions": array:1 [
0 => "None"
]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2023-10-22T15:29:12Z"
+"StreetDirPrefix": "S"
+"StreetName": "84th"
+"StreetNumber": "8501"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "10815.9"
+"TaxYear": "2021"
+"Township": "Lyons"
+"WaterSource": array:2 [
0 => "Lake Michigan"
1 => "Public"
]
+"MRD_LOCITY": "Oak Lawn"
+"MRD_UD": "2023-10-22T15:29:12"
+"MRD_REHAB_YEAR": "2022"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_IDX": "Y"
+"MRD_LOSTREETNUMBER": "9909"
+"MRD_PARKING_OWNERSHIP": "Owned"
+"MRD_EXT": "Shakes"
+"MRD_LASTATE": "IL"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "0"
+"MRD_SALE_OR_RENT": "No"
+"MRD_MC": "Active"
+"MRD_DRV": "Asphalt"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LOSTATE": "IL"
+"MRD_OMT": "0"
+"MRD_GARAGE_ONSITE": "Yes"
+"MRD_LSZ": ".50-.99 Acre"
+"MRD_PKN": "Garage,Space/s"
+"MRD_LOSTREETNAME": "Southwest Hwy."
+"MRD_TXC": "None"
+"MRD_LAZIP": "60453"
+"MRD_LB_LOCATION": "N"
+"MRD_GAR": "Garage Door Opener(s),Transmitter(s)"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_B78": "Yes"
+"MRD_VT": "None"
+"MRD_LASTREETNAME": "Southwest Hwy."
+"MRD_APRX_TOTAL_FIN_SQFT": "0"
+"MRD_TOTAL_SQFT": "0"
+"MRD_GARAGE_TYPE": "Attached"
+"MRD_CARS": "12"
+"MRD_LACITY": "Oak Lawn"
+"MRD_AGE": "71-80 Years"
+"MRD_BB": "Yes"
+"MRD_RR": "Yes"
+"MRD_DOCCOUNT": "0"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_LOZIP": "60453"
+"MRD_SAS": "N"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_LASTREETNUMBER": "9926"
+"MRD_CRP": "Hickory Hills"
+"MRD_INF": "School Bus Service,Commuter Bus,Commuter Train,Interstate Access"
+"MRD_GARAGE_OWNERSHIP": "Owned"
+"MRD_BRBELOW": "1"
+"MRD_LO_LOCATION": "60321"
+"MRD_TPE": "1 Story"
+"MRD_REBUILT": "Yes"
+"MRD_BOARDNUM": "10"
+"MRD_ACTUALSTATUS": "Temporarily No Showings"
+"MRD_REBUILT_YEAR": "2022"
+"MRD_BAS": "Partially Finished"
+"MRD_HEM": "Yes"
+"MRD_EXP": "North,West"
+"MRD_SCI": "None"
+"MRD_RECORDMODDATE": "2023-10-22T15:29:12.000Z"
+"MRD_PARKING_ONSITE": "Yes"
+"MRD_AON": "No"
+"MRD_MANAGINGBROKER": "No"
+"MRD_TYP": "Detached Single"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_DIN": "Separate"
+"MRD_SomePhotosVirtuallyStaged": "Yes"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD11909367')"
+"provider_name": "MRED"
+"Media": array:3 [
0 => array:9 [ …9]
1 => array:9 [ …9]
2 => array:9 [ …9]
]
+"ID": "4298"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3002
+post_id: "7925"
+post_author: 1
+"ListingKey": "MRD11822545"
+"ListingId": "11822545"
+"PropertyType": "Residential"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2024-01-02T22:32:02Z"
+"RFModificationTimestamp": "2024-01-02T22:35:46Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3198.0
+"BuildingAreaTotal": 0
+"City": "North Barrington"
+"PostalCode": "60010"
+"UnparsedAddress": " , North Barrington, Lake County, Illinois 60010, USA "
+"Coordinates": array:2 [
0 => -88.1406349
1 => 42.207802
]
+"Latitude": 42.207802
+"Longitude": -88.1406349
+"YearBuilt": 1998
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Maria Wildoer"
+"ListOfficeName": "Realty Executives Advance"
+"ListAgentMlsId": "81614"
+"ListOfficeMlsId": "26715"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "IF YOU ARE SERIOUSLY LOOKING FOR A HOME WITH NO YARDWORK NEEDED, THEN THIS ONE IS FOR YOU! Walk into this recently rehabbed 4 BR 4 bath brick custom home & feel your spirits soar with the dramatic effect of the cathedral ceilings as the foyer opens up to the magnificent space & layout of this beautiful home. The Master Suite & second bedrooms are BOTH on the main level, including the office or den. The living room has a full brick FP and overlooks the dining room & kitchen. All of the hardwood flooring is brand new, the newly remodeled eat-in kitchen has a waterfall quartz counter, SS appliances & 42 inch cabinets w all new lighting, hardware, appliances & faucet, along w the laundry & mud rooms w the new washer dryer. The Master BR has new custom wood shelving in the walk-in closet, & a brand new remodeled bath w quartz counters, double sink & deluxe step-in shower. (Some photos have been virtually staged).The remodeled hall bath with a brand new shower adjoins the 2nd BR. The second floor has a loft w 2 extra BRs w a fully remodeled bath & new hardwood floors. The finished basement has its own full remodeled bath, den & rec room and the owners just installed a new sump pump. Off the kitchen's French doors is a covered patio, and a brand new driveway leads into a roomy 2 car garage. The home conveniently parks 4 vehicles, & landscaping is all new as well. Nothing to do but move into this gorgeous home inside this wonderful gated community with its signature Jack Nicklaus designed golf course, along w a clubhouse that has world class amenities. Landscape maintenance & water is included in the HOA. NOTES: Lot extends from the covered patio past the stones to the TREE LINE IN THE BACK. If your buyer wants a big backyard, this will not check their box, so please let them know before making the appointment so as NOT to DISRUPT seller's schedule. Original architectural shaker roof (seller open to negotiate) main level A/C and furnace approximately 7 years old, second floor A/C & furnace approx 15 years ( info given to seller from original owner )"
+"Appliances": array:9 [
0 => "Range"
1 => "Microwave"
2 => "Dishwasher"
3 => "Refrigerator"
4 => "Washer"
5 => "Dryer"
6 => "Disposal"
…2
]
+"AssociationFee": "309"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [ …4]
+"Basement": array:1 [ …1]
+"BathroomsFull": 4
+"BedroomsPossible": 4
+"CommunityFeatures": array:10 [ …10]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Lake"
+"CreationDate": "2023-08-09T11:22:59.163669+00:00"
+"DaysOnMarket": 184
+"Directions": "Take 12 N of Route 22 to Wynstone Main Entrance"
+"ElementarySchool": "Seth Paine Elementary School"
+"ElementarySchoolDistrict": "95"
+"ExteriorFeatures": array:3 [ …3]
+"FireplaceFeatures": array:2 [ …2]
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "2"
+"Heating": array:2 [ …2]
+"HighSchool": "Lake Zurich High School"
+"HighSchoolDistrict": "95"
+"InteriorFeatures": array:10 [ …10]
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Maria"
+"ListAgentKey": "81614"
+"ListAgentLastName": "Wildoer"
+"ListAgentOfficePhone": "847-912-3997"
+"ListOfficeFax": "(847) 960-4243"
+"ListOfficeKey": "26715"
+"ListOfficePhone": "847-737-7155"
+"ListingContractDate": "2023-07-03"
+"LivingAreaSource": "Assessor"
+"LockBoxType": array:1 [ …1]
+"LotFeatures": array:2 [ …2]
+"LotSizeDimensions": "160X113X102X98"
+"MLSAreaMajor": "Barrington Area"
+"MiddleOrJuniorSchool": "Lake Zurich Middle - N Campus"
+"MiddleOrJuniorSchoolDistrict": "95"
+"MlsStatus": "Temporarily No Showings"
+"Model": "CUSTOM"
+"OffMarketDate": "2024-01-02"
+"OriginalEntryTimestamp": "2023-07-04T05:37:54Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2024-01-02T22:31:42Z"
+"OwnerName": "OOR"
+"Ownership": "Fee Simple"
+"ParcelNumber": "14071010900000"
+"ParkingTotal": "2"
+"PhotosChangeTimestamp": "2023-07-04T05:39:02Z"
+"PhotosCount": 30
+"Possession": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomType": array:3 [ …3]
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2024-01-02T22:31:42Z"
+"StreetName": "Graystone"
+"StreetNumber": "37"
+"StreetSuffix": "Lane"
+"SubdivisionName": "Wynstone"
+"TaxAnnualAmount": "15828.54"
+"TaxYear": "2022"
+"Township": "Ela"
+"VirtualTourURLUnbranded": "https://perfectview3d.com/3d-model/37-graystone/fullscreen/"
+"WaterSource": array:1 [ …1]
+"MRD_LOCITY": "Schaumburg"
+"MRD_UD": "2024-01-02T22:31:42"
+"MRD_REHAB_YEAR": "2022"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_IDX": "Y"
+"MRD_LOSTREETNUMBER": "1236"
+"MRD_DOCDATE": "2023-07-05T20:51:18"
+"MRD_EXT": "Brick,Cedar"
+"MRD_LASTATE": "IL"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "4518"
+"MRD_SALE_OR_RENT": "No"
+"MRD_MC": "Active"
+"MRD_DRV": "Asphalt,Concrete"
+"MRD_SPEC_SVC_AREA": "T"
+"MRD_LOSTATE": "IL"
+"MRD_OMT": "0"
+"MRD_GARAGE_ONSITE": "Yes"
+"MRD_LSZ": ".25-.49 Acre"
+"MRD_PKN": "Garage"
+"MRD_LOSTREETNAME": "N. Roselle Road"
+"MRD_MAF": "Yes"
+"MRD_OpenHouseCount": "0"
+"MRD_LAZIP": "60107"
+"MRD_N": "24"
+"MRD_VTDATE": "2023-07-04T05:37:54"
+"MRD_GAR": "Garage Door Opener(s),Transmitter(s)"
+"MRD_LOT_SIZE_SOURCE": "Appraisal"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_FIREPLACE_LOCATION": "Living Room"
+"MRD_W": "26"
+"MRD_B78": "No"
+"MRD_VT": "None"
+"MRD_LASTREETNAME": "CRANBERRY CT"
+"MRD_APRX_TOTAL_FIN_SQFT": "4518"
+"MRD_TOTAL_SQFT": "4518"
+"MRD_GARAGE_TYPE": "Attached"
+"MRD_LOWER_SQFT": "1320"
+"MRD_ADDLMEDIATYPE1": "Virtual Tour"
+"MRD_LACITY": "STREAMWOOD"
+"MRD_AGE": "21-25 Years"
+"MRD_BB": "Yes"
+"MRD_RR": "Yes"
+"MRD_DOCCOUNT": "1"
+"MRD_MAST_ASS_FEE_FREQ": "Yearly"
+"MRD_LOZIP": "60195"
+"MRD_SAS": "N"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_LASTREETNUMBER": "8"
+"MRD_CRP": "North Barrington"
+"MRD_INF": "School Bus Service"
+"MRD_GARAGE_OWNERSHIP": "Owned"
+"MRD_BRBELOW": "0"
+"MRD_LO_LOCATION": "26715"
+"MRD_TPE": "2 Stories"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "10"
+"MRD_ACTUALSTATUS": "Temporarily No Showings"
+"MRD_ADDLMEDIAURL1": "https://perfectview3d.com/3d-model/37-graystone/fullscreen/"
+"MRD_BAT": "Separate Shower,Double Sink,No Tub"
+"MRD_BAS": "Finished"
+"MRD_MASTER_ASSOC_FEE": "6303"
+"MRD_ASSESSOR_SQFT": "5064"
+"MRD_HEM": "Yes"
+"MRD_SCI": "None"
+"MRD_OpenHouseUpdate": "2023-07-10T21:32:25"
+"MRD_RECORDMODDATE": "2024-01-02T22:31:42.000Z"
+"MRD_UPPER_SQFT": "3198"
+"MRD_AON": "No"
+"MRD_MANAGINGBROKER": "No"
+"MRD_TYP": "Detached Single"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_DIN": "Separate"
+"MRD_SomePhotosVirtuallyStaged": "Yes"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD11822545')"
+"provider_name": "MRED"
+"Media": array:30 [ …30]
+"ID": "7925"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2993
+post_id: "100773"
+post_author: 1
+"ListingKey": "MRD12671266"
+"ListingId": "12671266"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T05:06:23Z"
+"RFModificationTimestamp": "2026-07-07T05:11:18Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 3456.0
+"BuildingAreaTotal": 0
+"City": "Lockport"
+"PostalCode": "60441"
+"UnparsedAddress": "1328 Lacoma Court, Lockport, Illinois 60441"
+"Coordinates": array:2 [ …2]
+"Latitude": 41.5953217
+"Longitude": -88.029059
+"YearBuilt": 2022
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kelsey Domina"
+"ListOfficeName": "Crosstown Realtors, Inc."
+"ListAgentMlsId": "264104"
+"ListOfficeMlsId": "25888"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Built in 2023, this custom-designed 4-bedroom, 3-bath home blends modern style, everyday comfort, and flexible living. Whether you're working from home, entertaining friends/family, or simply enjoying a low-maintenance lifestyle, this home is designed to fit the way you live. Step inside to soaring 12-foot ceilings in the entry and family room, luxury vinyl plank flooring, custom trim work, recessed lighting, and an impressive open staircase. The open-concept kitchen features dual-tone cabinetry, granite countertops, a large center island, pantry, under-cabinet lighting, and stainless steel appliances, flowing seamlessly into the spacious family room with a gas fireplace and built-in beverage station. Need a home office? This home offers a dedicated main-floor office with custom built-in bookshelves, plus additional finished space in the basement that's perfect for a second office, gym, or media room. The finished basement also includes a custom beverage station with a sink, microwave, and built-in beverage refrigerator-ideal for entertaining. The private primary suite features a tray ceiling and a spa-like bath with a custom tile shower, built-in bench, and upgraded finishes. Additional highlights include main-floor laundry, dual-zone HVAC, central humidifier, water softener, irrigation system, an insulated garage with hot and cold water, and a covered patio with a gas hookup for grilling. Located within walking distance to parks, shopping, restaurants, and daycare, this move-in-ready home offers the perfect combination of modern design, flexible living, and everyday convenience!"
+"ActivationDate": "2026-07-01"
+"Appliances": array:8 [ …8]
+"AssociationFee": "235"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:3 [ …3]
+"AttributionContact": "(708) 942-8297"
+"Basement": array:2 [ …2]
+"BathroomsFull": 3
+"BedroomsPossible": 4
+"BelowGradeFinishedArea": 1700
+"CommunityFeatures": array:1 [ …1]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:3 [ …3]
+"CountyOrParish": "Will"
+"CreationDate": "2026-07-01T15:42:53.124370+00:00"
+"DaysOnMarket": 15
+"Directions": "159th to Clover Ridge South to Lacoma East"
+"DoorFeatures": array:1 [ …1]
+"Electric": "Circuit Breakers,200+ Amp Service"
+"ElementarySchoolDistrict": "91"
+"EntryLevel": 1
+"FireplaceFeatures": array:2 [ …2]
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "2"
+"Heating": array:2 [ …2]
+"HighSchool": "Lockport Township High School"
+"HighSchoolDistrict": "205"
+"InteriorFeatures": array:10 [ …10]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Kelsey"
+"ListAgentKey": "264104"
+"ListAgentLastName": "Domina"
+"ListAgentMobilePhone": "708-942-8297"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "(708) 887-5502"
+"ListOfficeKey": "25888"
+"ListOfficePhone": "708-949-4374"
+"ListingContractDate": "2026-07-01"
+"LivingAreaSource": "Estimated"
+"LockBoxType": array:1 [ …1]
+"LotFeatures": array:1 [ …1]
+"LotSizeDimensions": "40X56"
+"MLSAreaMajor": "Homer / Lockport"
+"MiddleOrJuniorSchoolDistrict": "91"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OriginalEntryTimestamp": "2026-07-01T15:38:11Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-07-07T05:05:34Z"
+"OtherEquipment": array:6 [ …6]
+"OwnerName": "OOR"
+"Ownership": "Fee Simple w/ HO Assn."
+"ParcelNumber": "1104242110360000"
+"ParkingFeatures": array:6 [ …6]
+"ParkingTotal": "2"
+"PatioAndPorchFeatures": array:2 [ …2]
+"PetsAllowed": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-06-08T14:46:04Z"
+"PhotosCount": 16
+"Possession": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomType": array:2 [ …2]
+"RoomsTotal": "9"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-07-07T05:05:34Z"
+"StoriesTotal": "1"
+"StreetName": "Lacoma"
+"StreetNumber": "1328"
+"StreetSuffix": "Court"
+"SubdivisionName": "Villas of Clover Ridge"
+"TaxAnnualAmount": "15910.48"
+"TaxYear": "2025"
+"Township": "Lockport"
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"MRD_BB": "Yes"
+"MRD_MC": "Active"
+"MRD_RR": "No"
+"MRD_UD": "2026-07-07T05:05:34"
+"MRD_VT": "None"
+"MRD_AGE": "1-5 Years"
+"MRD_AON": "No"
+"MRD_B78": "No"
+"MRD_BAT": "Double Sink"
+"MRD_CRP": "Lockport"
+"MRD_DAY": "0"
+"MRD_DIN": "Separate"
+"MRD_HEM": "No"
+"MRD_INF": "School Bus Service,Commuter Bus,Commuter Train,Interstate Access"
+"MRD_MAF": "No"
+"MRD_MPW": "999"
+"MRD_OMT": "0"
+"MRD_PTA": "Yes"
+"MRD_SAS": "N"
+"MRD_TNU": "2"
+"MRD_TPC": "1/2 Duplex,Townhouse-Ranch"
+"MRD_TXC": "Homeowner"
+"MRD_TYP": "Attached Single"
+"MRD_LAZIP": "60491"
+"MRD_LOZIP": "60491"
+"MRD_RURAL": "N"
+"MRD_LACITY": "Homer Glen"
+"MRD_LOCITY": "Homer Glen"
+"MRD_BRBELOW": "2"
+"MRD_DOCDATE": "2026-06-08T14:44:54"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "1"
+"MRD_MAIN_SQFT": "1756"
+"MRD_TOTAL_SQFT": "1756"
+"MRD_LB_LOCATION": "C"
+"MRD_LO_LOCATION": "25888"
+"MRD_MANAGEPHONE": "000-000-0000"
+"MRD_ACTUALSTATUS": "Active"
+"MRD_LASTREETNAME": "S Elm St"
+"MRD_LOSTREETNAME": "W. 143rd Street"
+"MRD_SALE_OR_RENT": "No"
+"MRD_MANAGECOMPANY": "Bay Property Services"
+"MRD_MANAGECONTACT": "Manager"
+"MRD_NEW_CONSTR_YN": "No"
+"MRD_RECORDMODDATE": "2026-07-07T05:05:34.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LASTREETNUMBER": "14112"
+"MRD_LOSTREETNUMBER": "15252"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "No"
+"MRD_OpenHouseCount": "0"
+"MRD_BuyerTeamCredit": "0"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_AVMOnIDXDisplayYN": "No"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Family Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "3456"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "No"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "1756"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_SHARE_WITH_CLIENTS_YN": "Yes"
+"MRD_ListBrokerMainOfficeID": "25888"
+"MRD_MarketTimeOnIDXDisplayYN": "No"
+"MRD_SomePhotosVirtuallyStaged": "No"
+"MRD_PriceHistoryOnIDXDisplayYN": "No"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12671266')"
+"provider_name": "MRED"
+"Media": array:16 [ …16]
+"ID": "100773"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3001
+post_id: "92820"
+post_author: 1
+"ListingKey": "MRD12646757"
+"ListingId": "12646757"
+"PropertyType": "Residential"
+"StandardStatus": "Active Under Contract"
+"ModificationTimestamp": "2026-05-19T08:02:27Z"
+"RFModificationTimestamp": "2026-05-19T08:03:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3200.0
+"BuildingAreaTotal": 0
+"City": "Manhattan"
+"PostalCode": "60442"
+"UnparsedAddress": "24035 Bay To Bay Boulevard, Manhattan, Illinois 60442"
+"Coordinates": array:2 [ …2]
+"Latitude": 41.451179
+"Longitude": -87.947307
+"YearBuilt": 2016
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kimberly Wirtz"
+"ListOfficeName": "Wirtz Real Estate Group Inc."
+"ListAgentMlsId": "215584"
+"ListOfficeMlsId": "28881"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Experience extraordinary lakefront living in this stunning custom home, perfectly positioned to overlook a scenic lake with its own private sand beach, retaining wall, fire pit, and coveted lake rights. One of only a few properties in Sunset Lakes to include an exclusive boat license (worth 30k), allowing you to water-ski right from your backyard-a rare and remarkable lifestyle opportunity. Inside, elegance unfolds at every turn. The impressive family room is a showstopper, featuring a beautiful fireplace with gas logs, rich crown molding, and an inviting atmosphere ideal for both entertaining and quiet evenings in. The main-level laundry room adds convenience with its utility sink plus a custom bench with hooks. The heart of the home is the stunning chef's kitchen, appointed with white staggered cabinets, crisp subway tile backsplash, stainless-steel appliances, chef's-grade appliances, a walk-in pantry, and an additional butler's pantry for seamless hosting. The adjoining breakfast area opens through glass doors to an expansive deck overlooking the fenced yard and your own private beach-where every sunrise and sunset becomes a moment to savor. A striking living room with coffered ceiling and wainscoting offers further sophistication, while double doors lead to the main-level office, perfect for remote work or quiet study. Gorgeous hardwood plank flooring flows throughout the home, enhancing its custom craftsmanship. Upstairs, retreat to the luxurious master suite, featuring a walk-in closet with custom organizers and a private upscale bath with a double raised granite vanity, oversized shower, and relaxing soaker tub. The vaulted second bedroom is exceptionally spacious, and the hall bath offers another double granite vanity. The full English lookout basement features 9-foot ceilings and rough-in plumbing, providing endless possibilities for future customization-whether you dream of a home theater, gym, recreation room, or additional living space. A rare offering of luxury, design, and true lakefront living on the East lake-this home delivers an unparalleled lifestyle both inside and out. Welcome to Sunset Lakes, where every day feels like a getaway."
+"Appliances": array:10 [ …10]
+"AssociationFee": "1000"
+"AssociationFeeFrequency": "Annually"
+"AssociationFeeIncludes": array:3 [ …3]
+"Basement": array:5 [ …5]
+"BathroomsFull": 2
+"BedroomsPossible": 4
+"BuyerAgentEmail": "[email protected];[email protected]"
+"BuyerAgentFirstName": "Mary"
+"BuyerAgentFullName": "Mary Pettenon"
+"BuyerAgentKey": "215783"
+"BuyerAgentLastName": "Pettenon"
+"BuyerAgentMlsId": "215783"
+"BuyerAgentMobilePhone": "708-945-7808"
+"BuyerAgentOfficePhone": "708-945-7808"
+"BuyerOfficeEmail": "[email protected]"
+"BuyerOfficeFax": "(708) 310-4373"
+"BuyerOfficeKey": "23641"
+"BuyerOfficeMlsId": "23641"
+"BuyerOfficeName": "Village Realty, Inc."
+"BuyerOfficePhone": "708-478-1212"
+"BuyerOfficeURL": "http://www.vrsrealty.com"
+"CommunityFeatures": array:6 [ …6]
+"ConstructionMaterials": array:2 [ …2]
+"Contingency": "Attorney/Inspection"
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Will"
+"CreationDate": "2026-05-13T13:24:21.644589+00:00"
+"DaysOnMarket": 64
+"Directions": "Cedar Road to Baker E or Schoolhouse Road to Baker W to Bay to Bay Boulevard south"
+"Electric": "Circuit Breakers,200+ Amp Service"
+"ElementarySchool": "Wilson Creek School"
+"ElementarySchoolDistrict": "114"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:3 [ …3]
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "3"
+"Heating": array:2 [ …2]
+"HighSchool": "Lincoln-Way West High School"
+"HighSchoolDistrict": "210"
+"InteriorFeatures": array:4 [ …4]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Kimberly"
+"ListAgentKey": "215584"
+"ListAgentLastName": "Wirtz"
+"ListAgentMobilePhone": "708-516-3050"
+"ListAgentOfficePhone": "708-516-3050"
+"ListOfficeKey": "28881"
+"ListOfficePhone": "708-516-3050"
+"ListOfficeURL": "http://www.wirtzrealestategroup.com"
+"ListingContractDate": "2026-05-13"
+"LivingAreaSource": "Builder"
+"LockBoxType": array:1 [ …1]
+"LotFeatures": array:2 [ …2]
+"LotSizeAcres": 0.43
+"LotSizeDimensions": "129.72X213.26X54.35X188.85"
+"MLSAreaMajor": "Manhattan/Wilton Center"
+"MiddleOrJuniorSchool": "Manhattan Junior High School"
+"MiddleOrJuniorSchoolDistrict": "114"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Contingent"
+"OriginalEntryTimestamp": "2026-05-13T13:19:20Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-05-18T22:07:01Z"
+"OtherEquipment": array:3 [ …3]
+"OwnerName": "Owner of Record"
+"Ownership": "Fee Simple w/ HO Assn."
+"ParcelNumber": "1412102020240000"
+"ParkingFeatures": array:6 [ …6]
+"ParkingTotal": "3"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-13T13:20:04Z"
+"PhotosCount": 34
+"Possession": array:1 [ …1]
+"PurchaseContractDate": "2026-05-18"
+"Roof": array:1 [ …1]
+"RoomType": array:6 [ …6]
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-05-18T22:07:01Z"
+"StreetName": "Bay To Bay"
+"StreetNumber": "24035"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "Sunset Lakes"
+"TaxAnnualAmount": "17848"
+"TaxYear": "2024"
+"Township": "Manhattan"
+"View": "Water"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:4 [ …4]
+"WaterfrontYN": true
+"WindowFeatures": array:1 [ …1]
+"MRD_BB": "No"
+"MRD_MC": "Active"
+"MRD_RR": "No"
+"MRD_UD": "2026-05-18T22:07:01"
+"MRD_VT": "None"
+"MRD_AGE": "6-10 Years"
+"MRD_AON": "No"
+"MRD_B78": "No"
+"MRD_BAT": "Separate Shower,Double Sink,Soaking Tub"
+"MRD_CRP": "Manhattan"
+"MRD_DIN": "Separate"
+"MRD_EXP": "Lake/Water"
+"MRD_HEM": "No"
+"MRD_IDX": "Y"
+"MRD_INF": "School Bus Service"
+"MRD_LSZ": ".25-.49 Acre"
+"MRD_MAF": "No"
+"MRD_OMT": "94"
+"MRD_SAS": "N"
+"MRD_TPE": "2 Stories"
+"MRD_TXC": "Homeowner"
+"MRD_TYP": "Detached Single"
+"MRD_LOZIP": "60441"
+"MRD_SAZIP": "60449"
+"MRD_SOZIP": "60423"
+"MRD_LOCITY": "Lockport"
+"MRD_SACITY": "Monee"
+"MRD_SOCITY": "Frankfort"
+"MRD_BRBELOW": "0"
+"MRD_DOCDATE": "2026-05-13T13:16:09"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_SASTATE": "IL"
+"MRD_SOSTATE": "IL"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "1"
+"MRD_WaterView": "Back of Property"
+"MRD_CONTTOSHOW": "Yes"
+"MRD_TOTAL_SQFT": "0"
+"MRD_LB_LOCATION": "A"
+"MRD_LO_LOCATION": "28881"
+"MRD_MANAGEPHONE": "708-532-4444"
+"MRD_SO_LOCATION": "23641"
+"MRD_ACTUALSTATUS": "Contingent"
+"MRD_LOSTREETNAME": "E. 9th St."
+"MRD_SALE_OR_RENT": "No"
+"MRD_SASTREETNAME": "Sweetgrass Circle"
+"MRD_SOSTREETNAME": "S. Frankfort Sq Rd # C"
+"MRD_WaterTouches": "Lot Boundary"
+"MRD_MANAGECOMPANY": "Cardinal Property Management"
+"MRD_MANAGECONTACT": "manager"
+"MRD_RECORDMODDATE": "2026-05-18T22:07:01.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LOSTREETNUMBER": "122"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "Yes"
+"MRD_OpenHouseCount": "0"
+"MRD_SASTREETNUMBER": "10027"
+"MRD_SOSTREETNUMBER": "20950"
+"MRD_BuyerTeamCredit": "0"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_AVMOnIDXDisplayYN": "Yes"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Family Room"
+"MRD_ALT_ELEMENTARY_NAME": "ANNA MCDONALD ELEMENTARY SCHOOL"
+"MRD_APRX_TOTAL_FIN_SQFT": "0"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "Yes"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "0"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "28881"
+"MRD_BuyerBrokerMainOfficeID": "23641"
+"MRD_MarketTimeOnIDXDisplayYN": "No"
+"MRD_SomePhotosVirtuallyStaged": "Yes"
+"MRD_PriceHistoryOnIDXDisplayYN": "No"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12646757')"
+"provider_name": "MRED"
+"Media": array:34 [ …34]
+"ID": "92820"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3000
+post_id: "100774"
+post_author: 1
+"ListingKey": "MRD12693253"
+"ListingId": "12693253"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-08T05:06:38Z"
+"RFModificationTimestamp": "2026-07-08T05:11:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2935.0
+"BuildingAreaTotal": 0
+"City": "Buffalo Grove"
+"PostalCode": "60089"
+"UnparsedAddress": "1002 Hobson Drive, Buffalo Grove, Illinois 60089"
+"Coordinates": array:2 [ …2]
+"Latitude": 42.1712296
+"Longitude": -87.9584357
+"YearBuilt": 1986
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Paresh Shah"
+"ListOfficeName": "Provident Realty, Inc."
+"ListAgentMlsId": "82934"
+"ListOfficeMlsId": "8068"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "PRICED TO SELL. WELCOME TO THIS FANTASTIC CONDITION, FRESHLY PAINTED SINGLE-FAMILY HOME IN THE HEART OF BUFFALO GROVE. FEATURING 4 GENEROUSLY SIZED BEDROOMS AND 3 FULL AND 1 HALF BATHROOMS, THIS HOME OFFERS SPACE AND VERSATILITY FOR TODAY'S LIFESTYLE. MAJOR UPDATES INCLUDE A BRAND NEW ROOF AND WINDOWS COMPLETED IN 2026. THE SPACIOUS KITCHEN IS EQUIPPED WITH STAINLESS STEEL APPLIANCES, NEWER CABINETRY, AND SLEEK GRANITE COUNTERTOPS. A FULL FINISHED BASEMENT PROVIDES ADDITIONAL LIVING SPACE, COMPLETE WITH A FULL WASHROOM AND PRIVATE OFFICE ROOM. RETREAT TO THE MASTER BEDROOM WITH ITS OWN FULL BATHROOM FOR ADDED COMFORT. ALL BATHROOMS HAVE BEEN COMPLETELY UPDATED WITH MODERN FINISHES. ENJOY NEW WOOD LAMINATE FLOORING AND NEWER LED CAN LIGHTING THROUGHOUT. LOCATED IN AN EXCELLENT AREA WITH CONVENIENT ACCESS TO SHOPPING, DINING, AND MORE."
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:2 [ …2]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:2 [ …2]
+"BathroomsFull": 3
+"BedroomsPossible": 4
+"BelowGradeFinishedArea": 858
+"CoListAgentEmail": "[email protected]"
+"CoListAgentFirstName": "Punit"
+"CoListAgentFullName": "Punit Patel"
+"CoListAgentKey": "272024"
+"CoListAgentLastName": "Patel"
+"CoListAgentMlsId": "272024"
+"CoListAgentMobilePhone": "(224) 600-0003"
+"CoListAgentOfficePhone": "(224) 600-0003"
+"CoListAgentStateLicense": "475215358"
+"CoListOfficeEmail": "[email protected]"
+"CoListOfficeFax": "(847) 995-0008"
+"CoListOfficeKey": "8068"
+"CoListOfficeMlsId": "8068"
+"CoListOfficeName": "Provident Realty, Inc."
+"CoListOfficePhone": "(847) 995-0007"
+"CommunityFeatures": array:2 [ …2]
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Lake"
+"CreationDate": "2026-07-02T14:02:25.399673+00:00"
+"DaysOnMarket": 14
+"Directions": "DEERFLD PWY W OF WEILAND/E OF BG RD TO HGHLD GRV TO HOBSON RIGHT TO HOME"
+"Electric": "Circuit Breakers"
+"ElementarySchool": "Tripp School"
+"ElementarySchoolDistrict": "102"
+"FireplaceFeatures": array:1 [ …1]
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "2"
+"HabitableResidenceYN": true
+"Heating": array:3 [ …3]
+"HighSchool": "Adlai E Stevenson High School"
+"HighSchoolDistrict": "125"
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:4 [ …4]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Paresh"
+"ListAgentKey": "82934"
+"ListAgentLastName": "Shah"
+"ListAgentMobilePhone": "847-363-8854"
+"ListAgentOfficePhone": "847-363-8854"
+"ListOfficeEmail": "[email protected]"
+"ListOfficeFax": "(847) 995-0008"
+"ListOfficeKey": "8068"
+"ListOfficePhone": "847-995-0007"
+"ListingContractDate": "2026-07-02"
+"LivingAreaSource": "Assessor"
+"LockBoxType": array:1 [ …1]
+"LotSizeAcres": 0.1567
+"LotSizeDimensions": "6825"
+"LotSizeSource": "County Records"
+"MLSAreaMajor": "Buffalo Grove"
+"MiddleOrJuniorSchool": "Aptakisic Junior High School"
+"MiddleOrJuniorSchoolDistrict": "102"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"OriginalEntryTimestamp": "2026-07-02T13:58:09Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-07-08T05:05:35Z"
+"OtherEquipment": array:1 [ …1]
+"OwnerName": "OOR"
+"Ownership": "Fee Simple"
+"ParcelNumber": "15283030940000"
+"ParkingFeatures": array:6 [ …6]
+"ParkingTotal": "2"
+"PhotosChangeTimestamp": "2026-07-01T18:27:04Z"
+"PhotosCount": 36
+"Possession": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomType": array:4 [ …4]
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-07-08T05:05:35Z"
+"StreetName": "HOBSON"
+"StreetNumber": "1002"
+"StreetSuffix": "Drive"
+"SubdivisionName": "Astor Place"
+"TaxAnnualAmount": "17264"
+"TaxYear": "2024"
+"Township": "Vernon"
+"View": "Water"
+"VirtualTourURLUnbranded": "https://my.matterport.com/show/?m=uWVp7uu4srh&brand=0&mls=1&"
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"MRD_BB": "Yes"
+"MRD_MC": "Active"
+"MRD_RR": "Yes"
+"MRD_UD": "2026-07-08T05:05:35"
+"MRD_VT": "None"
+"MRD_AGE": "31-40 Years"
+"MRD_AON": "No"
+"MRD_ATC": "Unfinished"
+"MRD_B78": "No"
+"MRD_BAT": "Separate Shower"
+"MRD_CRP": "Buffalo Grove"
+"MRD_DIN": "Combined w/ LivRm"
+"MRD_EXP": "East"
+"MRD_HEM": "Yes"
+"MRD_IDX": "Y"
+"MRD_INF": "School Bus Service"
+"MRD_LSZ": "Less Than .25 Acre"
+"MRD_MAF": "No"
+"MRD_OMT": "57"
+"MRD_SAS": "N"
+"MRD_TPE": "2 Stories"
+"MRD_TXC": "Homeowner"
+"MRD_TYP": "Detached Single"
+"MRD_LAZIP": "60010"
+"MRD_LOZIP": "60173"
+"MRD_RURAL": "N"
+"MRD_LACITY": "South Barrington"
+"MRD_LOCITY": "Schaumburg"
+"MRD_VTDATE": "2026-07-02T13:58:09"
+"MRD_BRBELOW": "0"
+"MRD_DOCDATE": "2026-07-01T18:29:07"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "1"
+"MRD_MAIN_SQFT": "950"
+"MRD_BSMNT_SQFT": "1059"
+"MRD_REHAB_YEAR": "2023"
+"MRD_TOTAL_SQFT": "1900"
+"MRD_UPPER_SQFT": "950"
+"MRD_LB_LOCATION": "A"
+"MRD_LO_LOCATION": "8068"
+"MRD_ACTUALSTATUS": "Active"
+"MRD_LASTREETNAME": "Tiffany Circle"
+"MRD_LOSTREETNAME": "Woodfield Rd. Ste. 105"
+"MRD_SALE_OR_RENT": "No"
+"MRD_ADDLMEDIAURL1": "https://order.repropix.com/videos/019de99d-1d44-73a2-92e6-baee65f057e9"
+"MRD_ADDLMEDIAURL2": "https://order.repropix.com/sites/ezqazaaq/unbranded"
+"MRD_RECORDMODDATE": "2026-07-08T05:05:35.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_ADDLMEDIATYPE1": "Video"
+"MRD_ADDLMEDIATYPE2": "Other Media"
+"MRD_LASTREETNUMBER": "5"
+"MRD_LOSTREETNUMBER": "800"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "Yes"
+"MRD_OpenHouseCount": "0"
+"MRD_BuyerTeamCredit": "0"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_UNFIN_BSMNT_SQFT": "201"
+"MRD_AVMOnIDXDisplayYN": "Yes"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_MainPlusUpperSqFt": "1900"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Family Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "2758"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "Yes"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "2959"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "8068"
+"MRD_CoListBrokerMainOfficeID": "8068"
+"MRD_MarketTimeOnIDXDisplayYN": "Yes"
+"MRD_SomePhotosVirtuallyStaged": "No"
+"MRD_PriceHistoryOnIDXDisplayYN": "Yes"
+"MRD_CoListBrokerOfficeLocationID": "8068"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12693253')"
+"provider_name": "MRED"
+"Media": array:36 [ …36]
+"ID": "100774"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2994
+post_id: "90156"
+post_author: 1
+"ListingKey": "MRD12645507"
+"ListingId": "12645507"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:06:08Z"
+"RFModificationTimestamp": "2026-07-14T05:10:07Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2990.0
+"BuildingAreaTotal": 0
+"City": "Leland"
+"PostalCode": "60531"
+"UnparsedAddress": "2151 E Us Highway 34, Leland, Illinois 60531"
+"Coordinates": array:2 [ …2]
+"Latitude": 41.6115741
+"Longitude": -88.758696
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Cindy Heckelsberg"
+"ListOfficeName": "Coldwell Banker Real Estate Group"
+"ListAgentMlsId": "233155"
+"ListOfficeMlsId": "23196"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Welcome to your own private countryside retreat! This is an exceptional custom built 1.5 story home featuring a 1st floor Master Bedroom, set on nearly 3 scenic acres surrounded by majestic mature oak trees, spacious lawns, fabulous creek views, and even a wildflower meadow! This beautifully designed 4 bedroom 3.5 bath residence blends rustic warmth with modern comfort and now includes a NEW outbuilding, constructed in 2025 offering endless possibilities for workshop space, recreational vehicles or that vintage car collection! Inside, you'll find over 2,900 square feet of thoughtfully designed living space featuring four generous bedrooms, three full baths and one half bath, with even more living space in the partially finished basement that includes a 2nd family room, a kitchenette, a full bath, and more! The inviting main floor family room is anchored by a stunning wood burning brick fireplace, while expansive Andersen windows fill the home with natural light and frame picturesque views of the surrounding landscape and the meandering Little Indian Creek! The spacious kitchen offers granite countertops, stainless steel appliances, abundant cabinetry, and an spacious breakfast area with large windows overlooking the creek and nature beyond. Sliding glass doors lead to a generous elevated patio and lower entertaining space complete with a built-in gas grill, perfect for relaxing evenings or hosting guests. Just inside the two story foyer is the large formal dining room with an view of the creek, and the first floor home office or den featuring build-in bookcases and crown moldings! The spacious first floor Master Bedroom provides a comfortable peaceful escape with large windows, vaulted ceiling, and a private bath featuring a beautifully updated 4' x 4' roll-in tile shower with dual shower heads, a large modern lighted mirror which open to reveal more storage over a large 5' vanity with an under mount sink set into a beautiful solid surface countertop, auxiliary heating from the bath fan/light combo and an oversized soaking tub with a view! Not to mention a well designed walk-in closet with built-in shelving! The conveniently located first floor laundry room is just off the Master Bath and includes a hidden laundry chute from the second floor for everyday ease and a lot less mess! The large, partially finished basement expands the living space with a generous recreation room, a full bath with a shower, a hidden 'Murphy' bed for guests, and an exercise room that doubles as kitchenette with a beautiful cabinetry, a large Kohler sink, a nook for a refrigerator and an escape window, ideal for related living, entertaining, or extended stays. Additionally the unfinished basement space offers exceptional storage with attached shelving and there is even more space to finish however you choose! Additional highlights zoned heating and cooling with dual furnaces, one furnace new in 2024 and dual central air units, one replaced in 2025, two hot water heaters, and a newer water softener. The new roof was added in 2025. The new pole building has a concrete floor and will hold 6 cars and the 10' overhead door is ideal for those larger trucks! The attached 2.5 car garage, which currently holds 3 cars, even has a EV charger! Tucked way back off the road is where you will find this hidden gem! This is a rare combination of privacy, nature, and modern functionality. Whether you're into shade gardening or vegetables, hiking your own wooded paths and listening for the hoot owls, exploring the creek for tadpoles, or looking for fireflies in the meadow after dark, being outdoors will never be the same! Simply enjoying the peaceful morning sunrise from your own front porch, with a cup of coffee in hand, this one-of-a-kind property offers the lifestyle you've been searching for. Easy access to everything and yet far enough away to be private. Don't wait! Call today! This home is does not require flood insurance! We have the LOMA on file."
+"ActivationDate": "2026-05-19"
+"Appliances": array:9 [ …9]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:4 [ …4]
+"BathroomsFull": 3
+"BedroomsPossible": 4
+"CoListAgentEmail": "[email protected]"
+"CoListAgentFax": "(630) 385-8961"
+"CoListAgentFirstName": "Lara"
+"CoListAgentFullName": "Lara Heckelsberg Gawrych"
+"CoListAgentKey": "221629"
+"CoListAgentLastName": "Heckelsberg Gawrych"
+"CoListAgentMiddleName": "A"
+"CoListAgentMlsId": "221629"
+"CoListAgentMobilePhone": "(630) 253-2995"
+"CoListAgentOfficePhone": "(630) 253-2995"
+"CoListAgentStateLicense": "475142184"
+"CoListAgentURL": "cbprimus.com/laraheckelsberg"
+"CoListOfficeFax": "(630) 896-3357"
+"CoListOfficeKey": "23196"
+"CoListOfficeMlsId": "23196"
+"CoListOfficeName": "Coldwell Banker Real Estate Group"
+"CoListOfficePhone": "(630) 896-3100"
+"CommunityFeatures": array:2 [ …2]
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "La Salle"
+"CreationDate": "2026-05-19T01:37:39.244448+00:00"
+"DaysOnMarket": 59
+"Directions": "From Ottawa, North on Rt 23 and East on Rt 34. From DeKalb, South on Rt. 23, West on US HWY 34. From Sandwich or Somonauk go west on Rt 34, pass Rt 23 and the creek. Take the 2nd drive back to the house."
+"Electric": "Circuit Breakers,200+ Amp Service"
+"ElementarySchool": "Leland Elementary School"
+"ElementarySchoolDistrict": "1"
+"ExteriorFeatures": array:1 [ …1]
+"FireplaceFeatures": array:2 [ …2]
+"FireplacesTotal": "1"
+"Flooring": array:2 [ …2]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "9"
+"Heating": array:4 [ …4]
+"HighSchool": "Leland High School"
+"HighSchoolDistrict": "1"
+"InteriorFeatures": array:8 [ …8]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Cindy"
+"ListAgentKey": "233155"
+"ListAgentLastName": "Heckelsberg"
+"ListAgentMobilePhone": "630-253-2997"
+"ListAgentOfficePhone": "630-253-2997"
+"ListOfficeFax": "(630) 896-3357"
+"ListOfficeKey": "23196"
+"ListOfficePhone": "630-896-3100"
+"ListTeamKey": "T14100"
+"ListTeamName": "The Heckelsberg Team"
+"ListingContractDate": "2026-05-18"
+"LivingAreaSource": "Estimated"
+"LockBoxType": array:1 [ …1]
+"LotFeatures": array:5 [ …5]
+"LotSizeAcres": 2.97
+"LotSizeDimensions": "2.97"
+"LotSizeSource": "Survey"
+"MLSAreaMajor": "Baker / Leland"
+"MiddleOrJuniorSchoolDistrict": "1"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"Model": "Custom 1.5 Story w/ 1st Floor Master on the Creek!"
+"OriginalEntryTimestamp": "2026-05-19T01:32:00Z"
+"OriginalListPrice": 750000
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-07-14T05:05:37Z"
+"OtherEquipment": array:6 [ …6]
+"OtherStructures": array:6 [ …6]
+"OwnerName": "Of Record"
+"Ownership": "Fee Simple"
+"ParcelNumber": "0410228000"
+"ParkingFeatures": array:8 [ …8]
+"ParkingTotal": "9"
+"PatioAndPorchFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-07-08T17:47:05Z"
+"PhotosCount": 66
+"Possession": array:1 [ …1]
+"PossibleUse": "Horses"
+"PreviousListPrice": 750000
+"Roof": array:1 [ …1]
+"RoomType": array:7 [ …7]
+"RoomsTotal": "10"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-07-14T05:05:37Z"
+"StreetDirPrefix": "E"
+"StreetName": "US Highway 34"
+"StreetNumber": "2151"
+"TaxAnnualAmount": "11452.04"
+"TaxYear": "2024"
+"Township": "Adams"
+"View": "Water"
+"WaterBodyName": "LITTLE INDIAN CREEK"
+"WaterSource": array:1 [ …1]
+"WaterfrontFeatures": array:3 [ …3]
+"MRD_BB": "Yes"
+"MRD_MC": "Active"
+"MRD_RR": "No"
+"MRD_UD": "2026-07-14T05:05:37"
+"MRD_VT": "None"
+"MRD_AGE": "21-25 Years"
+"MRD_AON": "No"
+"MRD_ATC": "Unfinished"
+"MRD_B78": "No"
+"MRD_BAT": "Separate Shower,Accessible Shower,Double Sink,Soaking Tub"
+"MRD_CRP": "Unincorporated"
+"MRD_DIN": "Separate"
+"MRD_EXP": "South"
+"MRD_HEM": "Yes"
+"MRD_IDX": "Y"
+"MRD_INF": "School Bus Service"
+"MRD_LSZ": "2.0-2.99 Acres"
+"MRD_MAF": "No"
+"MRD_OMT": "0"
+"MRD_SAS": "N"
+"MRD_TPE": "2 Stories"
+"MRD_TXC": "Homeowner"
+"MRD_TYP": "Detached Single"
+"MRD_LAZIP": "60536"
+"MRD_LOZIP": "60543"
+"MRD_LACITY": "Millbrook"
+"MRD_LOCITY": "Oswego"
+"MRD_BRBELOW": "0"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "0"
+"MRD_MAIN_SQFT": "1600"
+"MRD_GREENDISCL": "N"
+"MRD_LOWER_SQFT": "790"
+"MRD_TOTAL_SQFT": "2990"
+"MRD_UPPER_SQFT": "600"
+"MRD_LB_LOCATION": "A,D"
+"MRD_LO_LOCATION": "23196"
+"MRD_ACTUALSTATUS": "Active"
+"MRD_LASTREETNAME": "Box 309"
+"MRD_LOSTREETNAME": "Route 34"
+"MRD_SALE_OR_RENT": "No"
+"MRD_ASSESSOR_SQFT": "2499"
+"MRD_RECORDMODDATE": "2026-07-14T05:05:37.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_SQFT_COMMENTS": "All measurements are approximate and buyer or buyer's agent to verify. The basement has approx. 790 sq ft of living space now but there is more unfinished area that could be finished if need be."
+"MRD_LASTREETNUMBER": "PO"
+"MRD_LOSTREETNUMBER": "2725"
+"MRD_ListTeamCredit": "100"
+"MRD_MANAGINGBROKER": "No"
+"MRD_OpenHouseCount": "0"
+"MRD_BuyerTeamCredit": "0"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "0"
+"MRD_AVMOnIDXDisplayYN": "No"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_MainPlusUpperSqFt": "2200"
+"MRD_CoListBrokerCredit": "0"
+"MRD_CoListBrokerTeamID": "T14100"
+"MRD_FIREPLACE_LOCATION": "Living Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "2990"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "No"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "2990"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_SHARE_WITH_CLIENTS_YN": "Yes"
+"MRD_ListBrokerMainOfficeID": "28624"
+"MRD_ListBrokerTeamOfficeID": "23196"
+"MRD_CoListBrokerMainOfficeID": "28624"
+"MRD_CoListBrokerTeamOfficeID": "23196"
+"MRD_MarketTimeOnIDXDisplayYN": "No"
+"MRD_SomePhotosVirtuallyStaged": "No"
+"MRD_ListBrokerTeamMainOfficeID": "24871"
+"MRD_PriceHistoryOnIDXDisplayYN": "No"
+"MRD_CoListBrokerOfficeLocationID": "23196"
+"MRD_CoListBrokerTeamMainOfficeID": "24871"
+"MRD_ListBrokerTeamOfficeLocationID": "23196"
+"MRD_ListingTransactionCoordinatorId": "233155"
+"MRD_CoListBrokerTeamOfficeLocationID": "23196"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12645507')"
+"provider_name": "MRED"
+"Media": array:66 [ …66]
+"ID": "90156"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2956
+post_id: "82559"
+post_author: 1
+"ListingKey": "MRD12603647"
+"ListingId": "12603647"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T05:06:17Z"
+"RFModificationTimestamp": "2026-07-14T05:10:26Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2218.0
+"BuildingAreaTotal": 0
+"City": "Urbana"
+"PostalCode": "61802"
+"UnparsedAddress": "3020 Beringer Circle, Urbana, Illinois 61802"
+"Coordinates": array:2 [ …2]
+"Latitude": 40.1171651
+"Longitude": -88.1646162
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Bill Peifer"
+"ListOfficeName": "Champaign County Realty"
+"ListAgentMlsId": "952568"
+"ListOfficeMlsId": "95007"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "You found it: a beautiful one-story home in the sought-after Beringer Commons on not only one, but TWO waterfront lots! This custom home features an all brick and stone front elevation, a covered front porch, a covered rear porch, a four seasons room, and 6 bedrooms, 3-1/2 baths. You'll find 3 of these bedrooms (including the Primary suite with a whirlpool tub) on the main floor with a split floor plan, but also the chef's kitchen open to the Great room. The finished basement boasts a spacious rec room with full kitchenette including a range, range hood, and dishwasher. You'll also find the remaining 3 bedrooms and a large unfinished area for storage. This home backs up to the water with an amazing view and you just cannot beat the large yard that it sits upon. Also qualified for the Think Urbana tax abatement plan. Broker-owned."
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:2 [ …2]
+"BathroomsFull": 3
+"BedroomsPossible": 6
+"BelowGradeFinishedArea": 1702
+"ConstructionMaterials": array:3 [ …3]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Champaign"
+"CreationDate": "2026-03-27T19:38:29.976768+00:00"
+"DaysOnMarket": 111
+"Directions": "FROM UNIVERSITY AVE, TURN NORTH ONTO HIGH CROSS RD/MYRA STATION RD, TURN LEFT ONTO BERINGER CIRCLE, HOME WILL BE ON YOUR RIGHT"
+"Electric": "200+ Amp Service"
+"ElementarySchool": "Dr. Preston L. Williams Jr. Elem"
+"ElementarySchoolDistrict": "116"
+"FireplaceFeatures": array:1 [ …1]
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "3"
+"Heating": array:1 [ …1]
+"HighSchool": "Urbana High School"
+"HighSchoolDistrict": "116"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Bill"
+"ListAgentKey": "952568"
+"ListAgentLastName": "Peifer"
+"ListAgentMobilePhone": "217-202-0463"
+"ListAgentOfficePhone": "217-352-1234"
+"ListAgentPager": "(217) 202-0463x"
+"ListOfficeFax": "(217) 352-2626"
+"ListOfficeKey": "95007"
+"ListOfficePhone": "217-352-1234"
+"ListingContractDate": "2026-03-27"
+"LivingAreaSource": "Builder"
+"LotSizeAcres": 0.59
+"LotSizeDimensions": "25899"
+"LotSizeSource": "Builder"
+"MLSAreaMajor": "Urbana"
+"MiddleOrJuniorSchool": "Urbana Middle School"
+"MiddleOrJuniorSchoolDistrict": "116"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Active"
+"NewConstructionYN": true
+"OriginalEntryTimestamp": "2026-03-27T19:34:15Z"
+"OriginalListPrice": 769000
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-07-14T05:05:27Z"
+"OwnerName": "OWNER OF RECORD"
+"Ownership": "Fee Simple"
+"ParcelNumber": "912110409029"
+"ParkingFeatures": array:5 [ …5]
+"ParkingTotal": "3"
+"PhotosChangeTimestamp": "2026-07-09T15:58:05Z"
+"PhotosCount": 49
+"Possession": array:1 [ …1]
+"PreviousListPrice": 769000
+"Roof": array:1 [ …1]
+"RoomType": array:4 [ …4]
+"RoomsTotal": "11"
+"Sewer": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-07-14T05:05:27Z"
+"StreetName": "Beringer"
+"StreetNumber": "3020"
+"StreetSuffix": "Circle"
+"TaxAnnualAmount": "27"
+"TaxYear": "2024"
+"Township": "Cunningham"
+"WaterSource": array:1 [ …1]
+"WaterfrontYN": true
+"MRD_BB": "Yes"
+"MRD_MC": "Active"
+"MRD_OD": "2026-04-01T05:00:00"
+"MRD_RR": "No"
+"MRD_UD": "2026-07-14T05:05:27"
+"MRD_VT": "None"
+"MRD_AGE": "NEW Ready for Occupancy"
+"MRD_AON": "Yes"
+"MRD_B78": "No"
+"MRD_CRP": "Urbana"
+"MRD_HEM": "Yes"
+"MRD_IDX": "Y"
+"MRD_INF": "Interstate Access"
+"MRD_LSZ": ".50-.99 Acre"
+"MRD_OMT": "0"
+"MRD_SAS": "N"
+"MRD_TPE": "1 Story"
+"MRD_TYP": "Detached Single"
+"MRD_LAZIP": "61822"
+"MRD_LOZIP": "61822"
+"MRD_LACITY": "Champaign"
+"MRD_LOCITY": "Champaign"
+"MRD_BRBELOW": "3"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "22"
+"MRD_DOCCOUNT": "0"
+"MRD_LEGALDESC": "LOTS 405 AND 406 BERINGER COMMONS SUB IV"
+"MRD_MAIN_SQFT": "2218"
+"MRD_WaterView": "Back of Property"
+"MRD_BSMNT_SQFT": "2218"
+"MRD_LOWER_SQFT": "0"
+"MRD_TOTAL_SQFT": "2218"
+"MRD_UPPER_SQFT": "0"
+"MRD_LO_LOCATION": "95007"
+"MRD_ACTUALSTATUS": "Active"
+"MRD_LASTREETNAME": "S Duncan Rd"
+"MRD_LOSTREETNAME": "S Duncan Rd"
+"MRD_SALE_OR_RENT": "No"
+"MRD_WaterTouches": "Easement Between Lot and Water"
+"MRD_RECORDMODDATE": "2026-07-14T05:05:27.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LASTREETNUMBER": "1712"
+"MRD_LOSTREETNUMBER": "1712"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "No"
+"MRD_OpenHouseCount": "0"
+"MRD_BuyerTeamCredit": "0"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_UNFIN_BSMNT_SQFT": "516"
+"MRD_UNFIN_LOWER_SQFT": "0"
+"MRD_AVMOnIDXDisplayYN": "Yes"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_MainPlusUpperSqFt": "2218"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Great Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "3920"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "Yes"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "4436"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "95007"
+"MRD_MarketTimeOnIDXDisplayYN": "Yes"
+"MRD_SomePhotosVirtuallyStaged": "Yes"
+"MRD_PriceHistoryOnIDXDisplayYN": "Yes"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12603647')"
+"provider_name": "MRED"
+"Media": array:49 [ …49]
+"ID": "82559"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#2955
+post_id: "100775"
+post_author: 1
+"ListingKey": "MRD12629713"
+"ListingId": "12629713"
+"PropertyType": "Residential"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-14T11:51:02Z"
+"RFModificationTimestamp": "2026-07-14T11:56:06Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2444.0
+"BuildingAreaTotal": 0
+"City": "Mokena"
+"PostalCode": "60448"
+"UnparsedAddress": "21337 Prestancia Drive, Mokena, Illinois 60448"
+"Coordinates": array:2 [ …2]
+"Latitude": 41.500992
+"Longitude": -87.905944
+"YearBuilt": 1995
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Kimberly Wirtz"
+"ListOfficeName": "Wirtz Real Estate Group Inc."
+"ListAgentMlsId": "215584"
+"ListOfficeMlsId": "28881"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Welcome to this absolutely stunning brick ranch, perfectly situated on a picturesque one-acre homesite backing to serene open space with direct access to the scenic Hickory Creek Trail, seamlessly connecting to the beloved Old Plank Trail. From the moment you step inside, you are greeted by a sun-drenched open floor plan designed for both elegance and comfort, highlighted by a grand great room with soaring vaulted ceilings, a cozy gas fireplace, and dual sliding glass doors that frame breathtaking views and lead to a sprawling concrete patio-perfect for indoor-outdoor entertaining. The beautifully refreshed kitchen is a true showpiece, featuring a vaulted and beamed ceiling, 42-inch oak cabinetry, stainless steel appliances including a newer refrigerator (2025), reverse osmosis to kitchen sink and ice maker, and a charming built-in planning desk, all flowing effortlessly into a bright dining area accented by a lovely bay window. The master suite offers a private retreat with a spacious walk-in closet and a private bath complete with a whirlpool tub, separate shower, and double vanity, while the additional 3 bedrooms on the main level provide generous space, including one with double closets; hardwood flooring extends throughout the living room and all bedrooms, adding warmth and sophistication. The expansive finished basement elevates the home even further with an impressive recreation room featuring a stunning stacked stone bar with beverage fridge, a fifth bedroom with a walk-in closet, and a full bath-ideal for related living or guest accommodations. Additional highlights include a three-car side-load garage with convenient service door access to the yard, a separately fenced dog run, and a fully fenced backyard. Major mechanical updates include furnace and A/C (2014), water heater (2017), and windows and doors approximately eight years old, ensuring peace of mind. This exceptional residence effortlessly combines upscale living, thoughtful design, and an unbeatable setting for a truly one-of-a-kind lifestyle."
+"AccessibilityFeatures": array:2 [ …2]
+"Appliances": array:8 [ …8]
+"ArchitecturalStyle": array:1 [ …1]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:2 [ …2]
+"BathroomsFull": 3
+"BedroomsPossible": 5
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Will"
+"CreationDate": "2026-07-13T01:21:26.341617+00:00"
+"DaysOnMarket": 4
+"Directions": "Route 30 (west of Wolf Road) to Prestancia Drive south"
+"Electric": "Circuit Breakers"
+"ElementarySchool": "Mokena Elementary School"
+"ElementarySchoolDistrict": "159"
+"ExteriorFeatures": array:1 [ …1]
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "3"
+"Heating": array:2 [ …2]
+"HighSchoolDistrict": "210"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Kimberly"
+"ListAgentKey": "215584"
+"ListAgentLastName": "Wirtz"
+"ListAgentMobilePhone": "708-516-3050"
+"ListAgentOfficePhone": "708-516-3050"
+"ListOfficeKey": "28881"
+"ListOfficePhone": "708-516-3050"
+"ListOfficeURL": "http://www.wirtzrealestategroup.com"
+"ListingContractDate": "2026-07-12"
+"LivingAreaSource": "Assessor"
+"LockBoxType": array:1 [ …1]
+"LotFeatures": array:1 [ …1]
+"LotSizeDimensions": "120 X354"
+"MLSAreaMajor": "Mokena"
+"MiddleOrJuniorSchool": "Mokena Intermediate School"
+"MiddleOrJuniorSchoolDistrict": "159"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "New"
+"OriginalEntryTimestamp": "2026-07-13T01:17:15Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-07-14T11:50:18Z"
+"OwnerName": "Owner of Record"
+"Ownership": "Fee Simple"
+"ParcelNumber": "1909193020200000"
+"ParkingFeatures": array:5 [ …5]
+"ParkingTotal": "3"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-07-13T01:17:03Z"
+"PhotosCount": 56
+"Possession": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomType": array:1 [ …1]
+"RoomsTotal": "9"
+"Sewer": array:2 [ …2]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-07-13T01:17:15Z"
+"StreetName": "PRESTANCIA"
+"StreetNumber": "21337"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "12169"
+"TaxYear": "2024"
+"Township": "Frankfort"
+"WaterSource": array:1 [ …1]
+"WindowFeatures": array:1 [ …1]
+"MRD_BB": "Yes"
+"MRD_MC": "Active"
+"MRD_RR": "Yes"
+"MRD_UD": "2026-07-14T11:50:18"
+"MRD_VT": "None"
+"MRD_AGE": "31-40 Years"
+"MRD_AON": "No"
+"MRD_B78": "No"
+"MRD_BAT": "Whirlpool,Separate Shower,Double Sink"
+"MRD_CRP": "Unincorporated"
+"MRD_DIN": "Kitchen/Dining Combo"
+"MRD_HEM": "No"
+"MRD_IDX": "Y"
+"MRD_INF": "School Bus Service,Commuter Bus,Commuter Train,Interstate Access"
+"MRD_LSZ": "1.0-1.99 Acres"
+"MRD_MAF": "No"
+"MRD_OMT": "0"
+"MRD_SAS": "N"
+"MRD_TPE": "1 Story"
+"MRD_TXC": "Homeowner"
+"MRD_TYP": "Detached Single"
+"MRD_LOZIP": "60441"
+"MRD_LOCITY": "Lockport"
+"MRD_BRBELOW": "1"
+"MRD_DOCDATE": "2026-07-07T00:04:29"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "1"
+"MRD_LOWER_SQFT": "2000"
+"MRD_REHAB_YEAR": "2014"
+"MRD_TOTAL_SQFT": "4444"
+"MRD_UPPER_SQFT": "2444"
+"MRD_LB_LOCATION": "A"
+"MRD_LO_LOCATION": "28881"
+"MRD_ACTUALSTATUS": "New"
+"MRD_LOSTREETNAME": "E. 9th St."
+"MRD_SALE_OR_RENT": "No"
+"MRD_RECORDMODDATE": "2026-07-14T11:50:18.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LOSTREETNUMBER": "122"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "Yes"
+"MRD_OpenHouseCount": "0"
+"MRD_BuyerTeamCredit": "0"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_AVMOnIDXDisplayYN": "Yes"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "Yes"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Family Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "4444"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "Yes"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "4444"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "28881"
+"MRD_MarketTimeOnIDXDisplayYN": "Yes"
+"MRD_SomePhotosVirtuallyStaged": "Yes"
+"MRD_PriceHistoryOnIDXDisplayYN": "Yes"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12629713')"
+"provider_name": "MRED"
+"Media": array:56 [ …56]
+"ID": "100775"
}
9 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3006
+post_id: "14049"
+post_author: 1
+"ListingKey": "MRD12353740"
+"ListingId": "12353740"
+"PropertyType": "Commercial Sale"
+"PropertySubType": "Mixed Use"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2025-12-10T13:22:01Z"
+"RFModificationTimestamp": "2025-12-10T13:24:17Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 0
+"BathroomsHalf": 0
+"BedroomsTotal": 0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Chicago"
+"PostalCode": "60608"
+"UnparsedAddress": "2259 S Western Avenue, Chicago, Illinois 60608"
+"Coordinates": array:2 [ …2]
+"Latitude": 41.8503463
+"Longitude": -87.6852413
+"YearBuilt": 1913
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Jorge Armand Luna"
+"ListOfficeName": "Luna Realty Group"
+"ListAgentMlsId": "177528"
+"ListOfficeMlsId": "86857"
+"OriginatingSystemName": "MRED"
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Cook"
+"CreationDate": "2025-05-01T18:29:03.468848+00:00"
+"DaysOnMarket": 224
+"Directions": "South on Western Ave. to address, North East corner of 23rd and Western Ave"
+"Electric": "Service - 0 to 100 Amps"
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Jorge Armand"
+"ListAgentKey": "177528"
+"ListAgentLastName": "Luna"
+"ListAgentOfficePhone": "708-268-3349"
+"ListOfficeKey": "86857"
+"ListOfficePhone": "708-797-3027"
+"ListingContractDate": "2025-05-01"
+"LotSizeDimensions": "24X100"
+"LotSizeSquareFeet": 3960
+"MLSAreaMajor": "CHI - Lower West Side"
+"MlsStatus": "Temporarily No Showings"
+"NumberOfUnitsTotal": "4"
+"OffMarketDate": "2025-12-10"
+"OriginalEntryTimestamp": "2025-05-01T18:24:24Z"
+"OriginalListPrice": 749900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2025-12-10T13:20:16Z"
+"ParcelNumber": "17301010030000"
+"PhotosChangeTimestamp": "2025-05-01T18:26:01Z"
+"PhotosCount": 10
+"PreviousListPrice": 749900
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2025-12-10T13:20:16Z"
+"Stories": "2"
+"StreetDirPrefix": "S"
+"StreetName": "Western"
+"StreetNumber": "2259"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "6962.68"
+"TaxYear": "2023"
+"MRD_MC": "Active"
+"MRD_RP": "0"
+"MRD_UD": "2025-12-10T13:20:16"
+"MRD_VT": "None"
+"MRD_AAG": "Older"
+"MRD_AON": "No"
+"MRD_APT": "3"
+"MRD_B78": "Yes"
+"MRD_FPR": "None"
+"MRD_GEO": "Chicago West"
+"MRD_GRM": "0"
+"MRD_HVT": "Forced Air"
+"MRD_IDX": "Y"
+"MRD_OFC": "1"
+"MRD_ORP": "0"
+"MRD_SMI": "0"
+"MRD_STO": "2"
+"MRD_TEN": "2"
+"MRD_TYP": "Mixed Use"
+"MRD_INFO": "None"
+"MRD_LAZIP": "60804"
+"MRD_LOZIP": "60402"
+"MRD_LACITY": "Cicero"
+"MRD_LOCITY": "Berwyn"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_BOARDNUM": "8"
+"MRD_DOCCOUNT": "0"
+"MRD_LO_LOCATION": "86857"
+"MRD_ACTUALSTATUS": "Temporarily No Showings"
+"MRD_LASTREETNAME": "S 58th Ave"
+"MRD_LOSTREETNAME": "Cermak Rd."
+"MRD_RECORDMODDATE": "2025-12-10T13:20:16.000Z"
+"MRD_LASTREETNUMBER": "3614"
+"MRD_LOSTREETNUMBER": "6426"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "Yes"
+"MRD_BuyerTeamCredit": "0"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_CoListBrokerCredit": "0"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "86857"
+"MRD_SomePhotosVirtuallyStaged": "No"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12353740')"
+"provider_name": "MRED"
+"Media": array:10 [ …10]
+"ID": "14049"
}
10 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3008
+post_id: "86617"
+post_author: 1
+"ListingKey": "MRD12636716"
+"ListingId": "12636716"
+"PropertyType": "Residential"
+"StandardStatus": "Hold"
+"ModificationTimestamp": "2026-05-11T18:09:18Z"
+"RFModificationTimestamp": "2026-05-11T18:16:15Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 6.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 5727.0
+"BuildingAreaTotal": 0
+"City": "Gurnee"
+"PostalCode": "60031"
+"UnparsedAddress": "5495 Chapel Hill, Gurnee, Illinois 60031"
+"Coordinates": array:2 [ …2]
+"Latitude": 42.3942983
+"Longitude": -87.9363229
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Prentiss Grant"
+"ListOfficeName": "RE/MAX Plaza"
+"ListAgentMlsId": "251187"
+"ListOfficeMlsId": "29225"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Experience refined living in this stunning estate nestled in the desirable Chapel Hill subdivision, where space, elegance, and natural light come together beautifully. Boasting an immense number of windows and soaring cathedral ceilings throughout the main level, this home is designed to impress from the moment you step into the grand foyer. The main level offers a perfect blend of sophistication and functionality, featuring formal living and dining rooms ideal for entertaining, a private den for work or relaxation, a convenient half bath, and a dedicated laundry room. The gourmet eat-in kitchen is truly a chef's dream, complete with a center island, abundant cabinetry, and expansive counter space. Sliding doors lead to the backyard and the kitchen flows effortlessly into a breathtaking two-story family room with a fireplace and a secondary staircase to the upper level. Upstairs, the luxurious primary suite serves as a private retreat, featuring a spa-like bath with a soaking tub, separate stand-in shower, double vanity, and storage closet. Three additional king-sized bedrooms, all with walk-in closets, and two more full bathrooms-including a private en-suite-complete the second level. The finished lower level expands your living space even further, offering two generously sized bedrooms, each with its own private bath and walk-in closet, along with a large recreation room and abundant storage. Step outside to your own backyard oasis, complete with a spacious deck, basketball court, and expansive yard-perfect for entertaining or simply enjoying the outdoors. Located in the vibrant community of Gurnee, residents enjoy access to top-rated schools such as Warren Township High School, beautiful parks, shopping, dining, and attractions like Gurnee Mills and Six Flags Great America. With convenient access to major interstates, commuting is a breeze while still enjoying all the benefits of this exceptional location."
+"Appliances": array:5 [ …5]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [ …1]
+"Basement": array:2 [ …2]
+"BathroomsFull": 5
+"BedroomsPossible": 6
+"BelowGradeFinishedArea": 2266
+"ConstructionMaterials": array:2 [ …2]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Lake"
+"CreationDate": "2026-05-03T01:46:04.293321+00:00"
+"DaysOnMarket": 10
+"Directions": "Dilleys & Stearns School Rd E 2 Nottingham, Left to Chapel Hill, L 2 #"
+"ElementarySchool": "Woodland Elementary School"
+"ElementarySchoolDistrict": "50"
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:2 [ …2]
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "2.5"
+"Heating": array:2 [ …2]
+"HighSchool": "Warren Township High School"
+"HighSchoolDistrict": "121"
+"InteriorFeatures": array:1 [ …1]
+"RFTransactionType": "For Sale"
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:3 [ …3]
+"LeaseExpiration": "2026-05-31"
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Prentiss"
+"ListAgentKey": "251187"
+"ListAgentLastName": "Grant"
+"ListAgentMobilePhone": "224-627-4290"
+"ListOfficeFax": "(847) 360-9226"
+"ListOfficeKey": "29225"
+"ListOfficePhone": "847-596-6100"
+"ListingContractDate": "2026-05-02"
+"LivingAreaSource": "Assessor"
+"LockBoxType": array:1 [ …1]
+"LotFeatures": array:1 [ …1]
+"LotSizeDimensions": "85X192X29X142"
+"MLSAreaMajor": "Gurnee"
+"MiddleOrJuniorSchoolDistrict": "50"
+"MlgCanUse": array:4 [ …4]
+"MlsStatus": "Temporarily No Showings"
+"OffMarketDate": "2026-05-11"
+"OriginalEntryTimestamp": "2026-05-03T01:43:29Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-05-11T18:08:43Z"
+"OtherEquipment": array:1 [ …1]
+"OwnerName": "Owner of Record"
+"Ownership": "Fee Simple"
+"ParcelNumber": "07101030250000"
+"ParkingFeatures": array:6 [ …6]
+"ParkingTotal": "2.5"
+"PatioAndPorchFeatures": array:1 [ …1]
+"PhotosChangeTimestamp": "2026-05-03T01:44:03Z"
+"PhotosCount": 59
+"Possession": array:1 [ …1]
+"Roof": array:1 [ …1]
+"RoomType": array:4 [ …4]
+"RoomsTotal": "12"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IL"
+"StatusChangeTimestamp": "2026-05-11T18:08:43Z"
+"StreetName": "Chapel Hill"
+"StreetNumber": "5495"
+"TaxAnnualAmount": "17903.66"
+"TaxYear": "2025"
+"Township": "Warren"
+"WaterSource": array:1 [ …1]
+"MRD_BB": "Yes"
+"MRD_MC": "Active"
+"MRD_RR": "No"
+"MRD_UD": "2026-05-11T18:08:43"
+"MRD_VT": "None"
+"MRD_AGE": "26-30 Years"
+"MRD_AON": "No"
+"MRD_B78": "No"
+"MRD_BAT": "Whirlpool,Separate Shower,Double Sink"
+"MRD_CRP": "Gurnee"
+"MRD_DIN": "Combined w/ LivRm"
+"MRD_HEM": "Yes"
+"MRD_IDX": "Y"
+"MRD_INF": "School Bus Service,Commuter Bus,Commuter Train,Interstate Access"
+"MRD_LSZ": ".25-.49 Acre"
+"MRD_OMT": "54"
+"MRD_SAS": "N"
+"MRD_TPE": "2 Stories"
+"MRD_TXC": "None"
+"MRD_TYP": "Detached Single"
+"MRD_LAZIP": "60030"
+"MRD_LOZIP": "60031"
+"MRD_LACITY": "Grayslake"
+"MRD_LOCITY": "Gurnee"
+"MRD_BRBELOW": "2"
+"MRD_LASTATE": "IL"
+"MRD_LOSTATE": "IL"
+"MRD_REBUILT": "No"
+"MRD_BOARDNUM": "10"
+"MRD_DOCCOUNT": "0"
+"MRD_BSMNT_SQFT": "2266"
+"MRD_TOTAL_SQFT": "3461"
+"MRD_UPPER_SQFT": "3461"
+"MRD_LB_LOCATION": "N"
+"MRD_LO_LOCATION": "29225"
+"MRD_ACTUALSTATUS": "Temporarily No Showings"
+"MRD_LASTREETNAME": "Lionel Drive"
+"MRD_LOSTREETNAME": "Grand Avenue Ste. 200"
+"MRD_SALE_OR_RENT": "Yes"
+"MRD_ASSESSOR_SQFT": "4796"
+"MRD_RECORDMODDATE": "2026-05-11T18:08:43.000Z"
+"MRD_SPEC_SVC_AREA": "N"
+"MRD_LASTREETNUMBER": "275"
+"MRD_LOSTREETNUMBER": "5445"
+"MRD_ListTeamCredit": "0"
+"MRD_MANAGINGBROKER": "No"
+"MRD_OpenHouseCount": "0"
+"MRD_BuyerTeamCredit": "0"
+"MRD_CURRENTLYLEASED": "Yes"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "100"
+"MRD_AVMOnIDXDisplayYN": "No"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_CoListBrokerCredit": "0"
+"MRD_FIREPLACE_LOCATION": "Family Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "5727"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "No"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "5727"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "5366"
+"MRD_MarketTimeOnIDXDisplayYN": "Yes"
+"MRD_SomePhotosVirtuallyStaged": "No"
+"MRD_PriceHistoryOnIDXDisplayYN": "Yes"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12636716')"
+"provider_name": "MRED"
+"Media": array:59 [ …59]
+"ID": "86617"
}
11 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#3009
+post_id: "92824"
+post_author: 1
+"ListingKey": "MRD12651934"
+"ListingId": "12651934"
+"PropertyType": "Residential"
+"StandardStatus": "Pending"
+"ModificationTimestamp": "2026-06-12T15:19:02Z"
+"RFModificationTimestamp": "2026-06-12T15:22:45Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3800.0
+"BuildingAreaTotal": 0
+"City": "Bettendorf"
+"PostalCode": "52722"
+"UnparsedAddress": "262 Ann Avenue, Bettendorf, Iowa 52722"
+"Coordinates": array:2 [ …2]
+"Latitude": 41.5401689
+"Longitude": -90.4683296
+"YearBuilt": 2021
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"ListAgentFullName": "Megan Stopulos"
+"ListOfficeName": "Ruhl&Ruhl REALTORS Davenport"
+"ListAgentMlsId": "1082307"
+"ListOfficeMlsId": "108032"
+"OriginatingSystemName": "MRED"
+"PublicRemarks": "Prepare to be captivated by this incredible 5-6 bedroom, 3.5-bath home in the highly desirable Pleasant Valley School District. Originally built by Ingleby Properties in 2022, this home perfectly blends everyday functionality with high-end luxury. Stepping inside from the beautiful front porch, the open-concept living, dining, and kitchen area are anchored by gorgeous hardwood floors. The chef's kitchen is an absolute showstopper, with custom Amish cabinetry, stainless steel appliances, and a pantry. A dedicated home office (or optional 6th bedroom), a stylized powder room, and a highly functional mudroom complete the main floor. Upstairs, you'll find four generously sized bedrooms, including a spectacular primary suite. This private retreat features a walk-in closet and a spa-like en suite complete with a custom tile-surround shower, soaking tub, and a private water closet. Convenience is key with a massive second-floor laundry room (with sink), a double vanity bath for privacy, and a versatile bonus room currently utilized as a home gym space. The fully finished basement is the ultimate entertainment hub, featuring a massive rec room, a bar, a legal bedroom, and a full bath. Outside, your private paradise awaits on a sprawling, nearly half-acre lot. Enjoy summer nights on the maintenance-free composite deck or patio, overlooking a fully fenced backyard complete with thriving apple and pear trees and garden. Also, this home has a 3-car heated garage, a pre-installed radon mitigation system, and unbeatable curb appeal!"
+"Appliances": array:5 [ …5]
+"AssociationFeeFrequency": "Not Applicable"
+"AssociationFeeIncludes": array:1 [ …1]
+"AttributionContact": "(563) 650-7918"
+"Basement": array:3 [ …3]
+"BathroomsFull": 3
+"BedroomsPossible": 5
+"BelowGradeFinishedArea": 1000
+"BuyerAgentEmail": "[email protected]"
+"BuyerAgentFirstName": "Kurt"
+"BuyerAgentFullName": "Kurt Johnson"
+"BuyerAgentKey": "1081966"
+"BuyerAgentLastName": "Johnson"
+"BuyerAgentMlsId": "1081966"
+"BuyerAgentMobilePhone": "563-343-0675"
+"BuyerAgentOfficePhone": "563-343-0675"
+"BuyerOfficeFax": "(563) 359-0014"
+"BuyerOfficeKey": "108029"
+"BuyerOfficeMlsId": "108029"
+"BuyerOfficeName": "Ruhl&Ruhl REALTORS Bettendorf"
+"BuyerOfficePhone": "563-441-5000"
+"CoListAgentEmail": "[email protected]"
+"CoListAgentFirstName": "Erica"
+"CoListAgentFullName": "Erica Ellerbach"
+"CoListAgentKey": "1081098"
+"CoListAgentLastName": "Ellerbach"
+"CoListAgentMlsId": "1081098"
+"CoListAgentMobilePhone": "(563) 508-2420"
+"CoListAgentOfficePhone": "(563) 508-2420"
+"CoListAgentStateLicense": "S69303000/475199886"
+"CoListOfficeFax": "(563) 388-8171"
+"CoListOfficeKey": "108032"
+"CoListOfficeMlsId": "108032"
+"CoListOfficeName": "Ruhl&Ruhl REALTORS Davenport"
+"CoListOfficePhone": "(563) 441-5100"
+"ConstructionMaterials": array:1 [ …1]
+"Cooling": array:1 [ …1]
+"CountyOrParish": "Scott"
+"CreationDate": "2026-05-21T14:06:26.219788+00:00"
+"DaysOnMarket": 22
+"Directions": "From State Street, north on Madison Drive, east on Smith Street and south on Ann Ave to property"
+"ElementarySchoolDistrict": "5250"
+"Fencing": array:1 [ …1]
+"FireplaceFeatures": array:1 [ …1]
+"FireplacesTotal": "1"
+"Flooring": array:1 [ …1]
+"FoundationDetails": array:1 [ …1]
+"GarageSpaces": "3"
+"HabitableResidenceYN": true
+"Heating": array:1 [ …1]
+"HighSchoolDistrict": "5250"
+"InteriorFeatures": array:7 [ …7]
+"RFTransactionType": "For Sale"
+"InternetAutomatedValuationDisplayYN": true
+"InternetConsumerCommentYN": true
+"InternetEntireListingDisplayYN": true
+"LaundryFeatures": array:2 [ …2]
+"ListAgentEmail": "[email protected]"
+"ListAgentFirstName": "Megan"
+"ListAgentKey": "1082307"
+"ListAgentLastName": "Stopulos"
+"ListAgentMobilePhone": "563-650-7918"
+"ListAgentOfficePhone": "563-650-7918"
+"ListOfficeFax": "(563) 388-8171"
+"ListOfficeKey": "108032"
+"ListOfficePhone": "563-441-5100"
+"ListTeamKey": "T36708"
+"ListTeamName": "The Stopulos Team"
+"ListingContractDate": "2026-05-21"
+"LivingAreaSource": "Assessor"
+"LotFeatures": array:1 [ …1]
+"LotSizeAcres": 0.45
+"LotSizeDimensions": "0 x 0"
+"LotSizeSource": "County Records"
+"MLSAreaMajor": "Bettendorf"
+"MiddleOrJuniorSchoolDistrict": "5250"
+"MlgCanUse": array:1 [ …1]
+"MlgCanView": true
+"MlsStatus": "Pending"
+"OffMarketDate": "2026-06-11"
+"OriginalEntryTimestamp": "2026-05-21T13:57:48Z"
+"OriginalListPrice": 699900
+"OriginatingSystemID": "MRED"
+"OriginatingSystemModificationTimestamp": "2026-06-12T15:18:50Z"
+"OtherStructures": array:1 [ …1]
+"OwnerName": "Weichert Relocation"
+"ParcelNumber": "842349219"
+"ParkingFeatures": array:4 [ …4]
+"ParkingTotal": "3"
+"PatioAndPorchFeatures": array:2 [ …2]
+"PhotosChangeTimestamp": "2026-05-19T23:03:03Z"
+"PhotosCount": 34
+"Possession": array:1 [ …1]
+"PurchaseContractDate": "2026-06-11"
+"Roof": array:1 [ …1]
+"RoomType": array:5 [ …5]
+"RoomsTotal": "11"
+"Sewer": array:1 [ …1]
+"SpecialListingConditions": array:1 [ …1]
+"StateOrProvince": "IA"
+"StatusChangeTimestamp": "2026-06-12T15:18:50Z"
+"StreetName": "Ann"
+"StreetNumber": "262"
+"StreetSuffix": "Avenue"
+"SubdivisionName": "Woods Estates of Riverdale"
+"TaxAnnualAmount": "8760"
+"TaxYear": "2024"
+"Township": "N/A"
+"WaterSource": array:1 [ …1]
+"MRD_BB": "Yes"
+"MRD_MC": "Off-Market"
+"MRD_RR": "No"
+"MRD_UD": "2026-06-12T15:18:50"
+"MRD_VT": "None"
+"MRD_AGE": "1-5 Years"
+"MRD_AON": "No"
+"MRD_B78": "No"
+"MRD_BAT": "Double Sink,Garden Tub"
+"MRD_CRP": "N/A"
+"MRD_DIN": "Combined w/ LivRm,Kitchen/Dining Combo"
+"MRD_HEM": "Yes"
+"MRD_IDX": "Y"
+"MRD_INF": "None"
+"MRD_LSZ": ".25-.49 Acre"
+"MRD_OMT": "0"
+"MRD_SAS": "N"
+"MRD_TPE": "2 Stories"
+"MRD_TXC": "Homeowner"
+"MRD_TYP": "Detached Single"
+"MRD_LAZIP": "52806"
+"MRD_LOZIP": "52806"
+"MRD_RURAL": "N"
+"MRD_SAZIP": "52722"
+"MRD_SOZIP": "52722-3604"
+"MRD_LACITY": "Davenport"
+"MRD_LOCITY": "Davenport"
+"MRD_SACITY": "Bettendorf"
+"MRD_SOCITY": "Bettendorf"
+"MRD_BRBELOW": "1"
+"MRD_DOCDATE": "2026-05-21T13:54:10"
+"MRD_LASTATE": "IA"
+"MRD_LOSTATE": "IA"
+"MRD_REBUILT": "No"
+"MRD_SASTATE": "IA"
+"MRD_SOSTATE": "IA"
+"MRD_BOARDNUM": "30"
+"MRD_DOCCOUNT": "1"
+"MRD_FloodZone": "No"
+"MRD_MAIN_SQFT": "1148"
+"MRD_BSMNT_SQFT": "1148"
+"MRD_LOWER_SQFT": "0"
+"MRD_TOTAL_SQFT": "2800"
+"MRD_UPPER_SQFT": "1652"
+"MRD_LB_LOCATION": "D"
+"MRD_LO_LOCATION": "108032"
+"MRD_SO_LOCATION": "108029"
+"MRD_ACTUALSTATUS": "Pending"
+"MRD_LASTREETNAME": "Welcome Way"
+"MRD_LOSTREETNAME": "Welcome Way"
+"MRD_SALE_OR_RENT": "No"
+"MRD_SASTREETNAME": "Middle Road"
+"MRD_SOSTREETNAME": "Middle Road"
+"MRD_ASSESSOR_SQFT": "3800"
+"MRD_RECORDMODDATE": "2026-06-12T15:18:50.000Z"
+"MRD_LASTREETNUMBER": "4545"
+"MRD_LOSTREETNUMBER": "4545"
+"MRD_ListTeamCredit": "100"
+"MRD_MANAGINGBROKER": "No"
+"MRD_OpenHouseCount": "0"
+"MRD_SASTREETNUMBER": "1228"
+"MRD_SOSTREETNUMBER": "1228"
+"MRD_BuyerTeamCredit": "0"
+"MRD_CURRENTLYLEASED": "No"
+"MRD_REMARKSINTERNET": "Yes"
+"MRD_SP_INCL_PARKING": "Yes"
+"MRD_CoListTeamCredit": "0"
+"MRD_ListBrokerCredit": "0"
+"MRD_UNFIN_BSMNT_SQFT": "148"
+"MRD_UNFIN_LOWER_SQFT": "0"
+"MRD_AVMOnIDXDisplayYN": "Yes"
+"MRD_BuyerBrokerCredit": "0"
+"MRD_CoBuyerTeamCredit": "0"
+"MRD_DISABILITY_ACCESS": "No"
+"MRD_MAST_ASS_FEE_FREQ": "Not Required"
+"MRD_MainPlusUpperSqFt": "2800"
+"MRD_CoListBrokerCredit": "0"
+"MRD_CoListBrokerTeamID": "T36708"
+"MRD_FIREPLACE_LOCATION": "Living Room"
+"MRD_APRX_TOTAL_FIN_SQFT": "3800"
+"MRD_CoBuyerBrokerCredit": "0"
+"MRD_IDXCommentsReviewsYN": "Yes"
+"MRD_TOTAL_FIN_UNFIN_SQFT": "3948"
+"MRD_AddressOnVOWDisplayYN": "Yes"
+"MRD_ListingOnIDXDisplayYN": "Yes"
+"MRD_RemarksOnVOWDisplayYN": "Yes"
+"MRD_ListBrokerMainOfficeID": "108035"
+"MRD_ListBrokerTeamOfficeID": "108032"
+"MRD_BuyerBrokerMainOfficeID": "108035"
+"MRD_CoListBrokerMainOfficeID": "108035"
+"MRD_CoListBrokerTeamOfficeID": "108032"
+"MRD_MarketTimeOnIDXDisplayYN": "Yes"
+"MRD_SomePhotosVirtuallyStaged": "No"
+"MRD_ListBrokerTeamMainOfficeID": "108035"
+"MRD_PriceHistoryOnIDXDisplayYN": "Yes"
+"MRD_CoListBrokerOfficeLocationID": "108032"
+"MRD_CoListBrokerTeamMainOfficeID": "108035"
+"MRD_ListBrokerTeamOfficeLocationID": "108032"
+"MRD_ListingTransactionCoordinatorId": "1082307"
+"MRD_CoListBrokerTeamOfficeLocationID": "108032"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('MRD12651934')"
+"provider_name": "MRED"
+"Media": array:34 [ …34]
+"ID": "92824"
}
]
+success: true
+page_size: 12
+page_count: 5488
+count: 65855
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
]