array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29998188 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23447
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23449
+post_id: "1602306"
+post_author: 1
+"ListingKey": "29998188"
+"ListingId": "40845586"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T13:55:11Z"
+"RFModificationTimestamp": "2026-07-07T17:58:04Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1549.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L8"
+"UnparsedAddress": "108 CLEARWATER Crescent, Waterloo, Ontario N2V1L8"
+"Coordinates": array:2 [
0 => -80.5635421
1 => 43.4922983
]
+"Latitude": 43.4922983
+"Longitude": -80.5635421
+"YearBuilt": 1984
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort, functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growing families, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamless walk-through kitchen design, every detail has been curated to enhance the natural flow of the home—making everyday living and hosting effortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and truly worry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo’s most desirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, while the fully finished basement offers endless versatility—whether you envision a yoga studio, recreation room, home gym, workshop, or additional entertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace. Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience in an area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantastic layout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore North neighbourhood. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Central Vacuum"
5 => "Gas stove(s)"
6 => "Dryer"
7 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Ductless"
]
+"CreationDate": "2026-07-07T17:57:52.057126+00:00"
+"Directions": "Wintergreen Dr. Northlake and Highpoint Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Other"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2129938"
+"ListOfficeKey": "292877"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T13:48:23Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T13:48:23Z"
+"Stories": "2.0"
+"StreetName": "CLEARWATER"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "4711"
+"View": "City view"
+"VirtualTourURLUnbranded": "https://youriguide.com/108_clearwater_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [
"RoomKey" => "1677305423"
"RoomType" => "Recreation room"
"ListingId" => "40845586"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "13'7'' x 21'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.08Z"
]
1 => array:11 [
"RoomKey" => "1677305424"
"RoomType" => "Laundry room"
"ListingId" => "40845586"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 12'8''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.08Z"
]
2 => array:11 [
"RoomKey" => "1677305425"
"RoomType" => "Family room"
"ListingId" => "40845586"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "10'11'' x 15'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
3 => array:11 [
"RoomKey" => "1677305426"
"RoomType" => "Primary Bedroom"
"ListingId" => "40845586"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "16'4'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
4 => array:11 [
"RoomKey" => "1677305427"
"RoomType" => "Bedroom"
"ListingId" => "40845586"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "12'5'' x 10'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
5 => array:11 [
"RoomKey" => "1677305428"
"RoomType" => "Bedroom"
"ListingId" => "40845586"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
6 => array:11 [
"RoomKey" => "1677305429"
"RoomType" => "3pc Bathroom"
"ListingId" => "40845586"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 6'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
7 => array:11 [
"RoomKey" => "1677305430"
"RoomType" => "Living room"
"ListingId" => "40845586"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "11'4'' x 16'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
8 => array:11 [
"RoomKey" => "1677305431"
"RoomType" => "Kitchen"
"ListingId" => "40845586"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
9 => array:11 [
"RoomKey" => "1677305432"
"RoomType" => "Dining room"
"ListingId" => "40845586"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
10 => array:11 [
"RoomKey" => "1677305433"
"RoomType" => "Breakfast"
"ListingId" => "40845586"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "8'1'' x 8'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
11 => array:11 [
"RoomKey" => "1677305434"
"RoomType" => "2pc Bathroom"
"ListingId" => "40845586"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29998188"
"RoomLength" => null
"RoomDimensions" => "4'7'' x 4'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-07-07T13:48:23.09Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29998188/108-clearwater-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1941951"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "292877"
+"GeocodeManualYN": true
+"ZoningDescription": "R3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 53.0
+"AboveGradeFinishedArea": 1549
+"OriginalEntryTimestamp": "2026-07-07T13:48:23.04Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1382907"
+"ListOfficeNationalAssociationId": "1418791"
+"CoListAgentNationalAssociationId": "1238606"
+"CoListOfficeNationalAssociationId": "1418791"
+"Media": array:50 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29998188_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/ae0738cec3920fe81fbb61b3449b762c.webp"
"MediaSize" => 125896
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-ae0738cec3920fe81fbb61b3449b762c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring a brick and siding exterior with dark shutters"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29998188_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/df32915eeb86a61d23d3c67299e10497.webp"
"MediaSize" => 105444
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-df32915eeb86a61d23d3c67299e10497.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring a covered front porch, an attached garage with a panel door, and a paver driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29998188_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/aab86cc6759e47cffcdf6fd85c89249b.webp"
"MediaSize" => 111781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-aab86cc6759e47cffcdf6fd85c89249b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residential exterior featuring a brick and siding facade, a dark garage door, and a paver driveway"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29998188_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/40dd663598d8d9e5105b8703a0b5db45.webp"
"MediaSize" => 135295
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-40dd663598d8d9e5105b8703a0b5db45.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a covered porch with a gravel patio area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29998188_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/3ae7b121849f1d3156cedb53372e70eb.webp"
"MediaSize" => 160674
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-3ae7b121849f1d3156cedb53372e70eb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick and siding exterior featuring dark shutters and a covered entry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29998188_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/5a9c3a451c491879c68ff59cc37f96a9.webp"
"MediaSize" => 131002
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-5a9c3a451c491879c68ff59cc37f96a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29998188_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/170e9cdfea8a4505abbd800015275dc2.webp"
"MediaSize" => 67136
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-170e9cdfea8a4505abbd800015275dc2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway with wood-finish flooring and a black front door featuring a full-length glass insert and transom window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29998188_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/69c1437696162beb314e0ba40dfe5c15.webp"
"MediaSize" => 63037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-69c1437696162beb314e0ba40dfe5c15.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hardwood flooring extends through the hallway, featuring recessed lighting and white walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29998188_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/d6dc54b8eb49e0db86f2ce6552cb88fe.webp"
"MediaSize" => 77793
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-d6dc54b8eb49e0db86f2ce6552cb88fe.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bay window with a dark accent wall and track lighting, complemented by wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29998188_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/c2b1857a95b3e787ee76033f811d5825.webp"
"MediaSize" => 75168
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-c2b1857a95b3e787ee76033f811d5825.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Galley kitchen featuring white cabinetry, stainless steel appliances, dark wood-finish flooring, undermount lighting, and a textured metallic backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29998188_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/4aa8990c6c64a234175954baa51a766b.webp"
"MediaSize" => 70372
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-4aa8990c6c64a234175954baa51a766b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living space with vaulted ceilings"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29998188_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/85ed8d9f250a055f3a8e51c2bf3f52cb.webp"
"MediaSize" => 83037
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-85ed8d9f250a055f3a8e51c2bf3f52cb.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Galley kitchen featuring hardwood-finish flooring, stainless steel countertops, paneled cabinetry, and a bay window dining area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29998188_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/00b9feda76801a832fff39fa0478e6ea.webp"
"MediaSize" => 88112
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-00b9feda76801a832fff39fa0478e6ea.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Galley kitchen featuring wood-finish flooring, light cabinetry, stainless steel appliances, and a double basin sink"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29998188_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/42c8422ad0958565e3153c6be833e162.webp"
"MediaSize" => 82712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-42c8422ad0958565e3153c6be833e162.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light-toned cabinetry, stainless steel appliances, dark countertops, wood-finish flooring, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29998188_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/86507b143c0eb97d2d2d2259e3c5caee.webp"
"MediaSize" => 84084
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-86507b143c0eb97d2d2d2259e3c5caee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring a stainless steel backsplash and dark wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29998188_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/9d964f8053bb9f42ec97256253c44009.webp"
"MediaSize" => 80934
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-9d964f8053bb9f42ec97256253c44009.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring a contemporary drum pendant light, wood-finish flooring, and a large window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29998188_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/d5cb05b7c72be79e1b76ef46921b0b76.webp"
"MediaSize" => 79092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-d5cb05b7c72be79e1b76ef46921b0b76.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area with wood-finish flooring and a contemporary drum pendant light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29998188_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/e0f95500364b0e69d4926dfc0808517f.webp"
"MediaSize" => 74963
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-e0f95500364b0e69d4926dfc0808517f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer with carpeted staircase featuring dark wood balusters and handrail, complemented by wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29998188_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/bbcc835be9d18d0e25551f84d99202fd.webp"
"MediaSize" => 71421
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-bbcc835be9d18d0e25551f84d99202fd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29998188_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/88b67edf8fd528aa34caf70ac3b43efd.webp"
"MediaSize" => 67488
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-88b67edf8fd528aa34caf70ac3b43efd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29998188_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/e32617f2e04a893766bcbcd16692fed9.webp"
"MediaSize" => 69407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-e32617f2e04a893766bcbcd16692fed9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Vaulted ceilings with an open concept design"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29998188_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/8492a4b48684c5306fc35c08421d0f09.webp"
"MediaSize" => 51207
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-8492a4b48684c5306fc35c08421d0f09.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a sleek vanity with a white rectangular sink, a contemporary chrome faucet, and a wall-mounted mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29998188_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/fbbc42b66ec4db7cc1d270ab32cfb947.webp"
"MediaSize" => 63175
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-fbbc42b66ec4db7cc1d270ab32cfb947.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29998188_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/ea5061ec8bdb564ace2de48fa24c4b9d.webp"
"MediaSize" => 53456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-ea5061ec8bdb564ace2de48fa24c4b9d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Hallway featuring light carpeting, recessed lighting, white walls, and a dark paneled door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29998188_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/15f2c11bd7768febd667c049711354d8.webp"
"MediaSize" => 72781
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-15f2c11bd7768febd667c049711354d8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring wood-finish flooring, a ceiling fan with integrated lighting, a single window, and baseboard heating"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29998188_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/ea66a12d051f7deeadda6079c5e0c374.webp"
"MediaSize" => 60763
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-ea66a12d051f7deeadda6079c5e0c374.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern bathroom featuring a single vanity with integrated sink, glass-enclosed shower with mosaic tile floor, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29998188_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/7d3b702b5cd27e66e0f21263d6db216e.webp"
"MediaSize" => 91249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-7d3b702b5cd27e66e0f21263d6db216e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring wood-finish flooring, recessed lighting, and a ceiling fan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29998188_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/0f94ed875e6a8ea5e23b5d4d2cfc2d21.webp"
"MediaSize" => 67230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-0f94ed875e6a8ea5e23b5d4d2cfc2d21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral toned bedroom with soft carpeting, featuring a ceiling fan with integrated lighting, a wall-mounted air conditioning unit, and a window with white window treatments"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29998188_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/d8cad0373114f09de3f4e57b8f9e6ea8.webp"
"MediaSize" => 67635
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-d8cad0373114f09de3f4e57b8f9e6ea8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring multiple windows with white window treatments, light neutral wall paint, and a textured ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29998188_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/6933cbe527962c1f0ec416e59427dfe3.webp"
"MediaSize" => 59216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-6933cbe527962c1f0ec416e59427dfe3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light-toned carpeting and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29998188_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/bc5135a5e933d207c2a7ae7a365da3c4.webp"
"MediaSize" => 83035
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-bc5135a5e933d207c2a7ae7a365da3c4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Wood-finish flooring with light gray walls and white wainscoting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29998188_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/1dd501867d36c7283ebf0b3ad603ee74.webp"
"MediaSize" => 73978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-1dd501867d36c7283ebf0b3ad603ee74.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living area featuring wood-finish flooring, sliding panel doors, and a window with blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29998188_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/3f8b3cf0aa57ef8ed11a0499c7f61dfc.webp"
"MediaSize" => 73948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-3f8b3cf0aa57ef8ed11a0499c7f61dfc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring wood-finish flooring, light gray walls, and white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29998188_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/4376d9e233d6e5eae3d612fe21ccc471.webp"
"MediaSize" => 59823
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-4376d9e233d6e5eae3d612fe21ccc471.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29998188_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/38a465731cfe95c85b39418915adf225.webp"
"MediaSize" => 67225
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-38a465731cfe95c85b39418915adf225.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated fitness area featuring light-toned wall finishes, recessed ceiling lighting, and a window for natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29998188_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/906ed78ce78d9c57018dcb0e2cf2e82f.webp"
"MediaSize" => 60311
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-906ed78ce78d9c57018dcb0e2cf2e82f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Flexible room featuring recessed lighting and light-toned walls"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29998188_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/5d398b020f045a8f8cd7d70461f8ec75.webp"
"MediaSize" => 63776
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-5d398b020f045a8f8cd7d70461f8ec75.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Versatile utility space featuring wood-finish flooring, white cabinetry, and track lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29998188_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/afefcdb6f35d29d4b9830ca987fad915.webp"
"MediaSize" => 81803
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-afefcdb6f35d29d4b9830ca987fad915.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Utility room featuring wood-finish flooring, track lighting, and white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29998188_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/553b785de243544abb639202e1afbb02.webp"
"MediaSize" => 143869
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-553b785de243544abb639202e1afbb02.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with a wooden walkway, garden bed, and wall-mounted hanging planters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29998188_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/3ac453b046a0934d23f6ac06924dd0d9.webp"
"MediaSize" => 163200
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-3ac453b046a0934d23f6ac06924dd0d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior with a side patio featuring a paver stone surface, an outdoor pergola structure, and mature landscaping"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29998188_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/5e7b8357aaac1fe3e9977840e73d48c1.webp"
"MediaSize" => 164505
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-5e7b8357aaac1fe3e9977840e73d48c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Brick exterior featuring a wood pergola with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29998188_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/6774d2062a7cb3e22a5f445da11cfbee.webp"
"MediaSize" => 159585
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-6774d2062a7cb3e22a5f445da11cfbee.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Paved side yard featuring a dark-stained wooden pergola with established climbing greenery, a herringbone pattern paver pathway, and a brick exterior wall"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29998188_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/74ef11a91d3f84f6cdfd464090a1c8db.webp"
"MediaSize" => 179064
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-74ef11a91d3f84f6cdfd464090a1c8db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a wood-finish deck, manicured lawn, established perimeter fencing, mature trees, and varied garden beds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29998188_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/c112db48c2e71f4c94e069995a5eec98.webp"
"MediaSize" => 161399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-c112db48c2e71f4c94e069995a5eec98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive green lawn with a wooden deck featuring a built-in bench"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29998188_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/ddf471cc00c06fdcc1f8dbe2d86e46cd.webp"
"MediaSize" => 154092
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-ddf471cc00c06fdcc1f8dbe2d86e46cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29998188_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/2ea2fe810c92ef9bcc8cc1240d864efa.webp"
"MediaSize" => 165860
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-2ea2fe810c92ef9bcc8cc1240d864efa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a large lawn area, mature trees, and a wooden deck with a small set of steps"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29998188_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/c0206009df09437fa67204ce80d94e92.webp"
"MediaSize" => 43706
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-c0206009df09437fa67204ce80d94e92.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40845586"
"ResourceRecordKey" => "29998188"
"ModificationTimestamp" => "2026-07-07T13:48:23.05Z"
]
47 => array:13 [
"Order" => 48
"MediaKey" => "29998188_4890_48"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29998188/14839262e0a9b804c089d7a6001e624a.webp"
"MediaSize" => 44646
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29998188/thumbnail-14839262e0a9b804c089d7a6001e624a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Floor plan"
…4
]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998188')"
+"ID": "1602306"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.12 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 292877" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24928
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2129938" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24897
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29998188'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25298
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /OpenHouse?$select=ALL&$top=10&$filter=ListingKey eq '29998188'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25316
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25314
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31843339"
+"ListingKey": "29998188"
+"ListingId": "40845586"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-12"
+"OpenHouseStartTime": "2026-07-12T14:00:00Z"
+"OpenHouseEndTime": "2026-07-12T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-07T23:38:37Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31843339')"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29998188' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5635421 43.4922983)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25406
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25383
+post_id: "1602047"
+post_author: 1
+"ListingKey": "30001669"
+"ListingId": "40845281"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T20:35:24Z"
+"RFModificationTimestamp": "2026-07-07T23:05:36Z"
+"ListPrice": 1150000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 3716.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2K2"
+"UnparsedAddress": "538 SANDBANKS Crescent, Waterloo, Ontario N2V2K2"
+"Coordinates": array:2 [
0 => -80.5798863
1 => 43.4958737
]
+"Latitude": 43.4958737
+"Longitude": -80.5798863
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 538 Sandbanks Crescent, a stunning and beautifully updated home nestled in the highly sought-after Laurelwood neighbourhood in Waterloo. From the moment you arrive it is clear this home has been cared for with exceptional pride of ownership and thoughtful attention to detail throughout. Backing onto protected green space and filled with an abundance of natural light, this home offers the perfect blend of comfort, flexibility and modern living. The layout is incredibly versatile featuring two flexible main floor rooms that can be used as a home office, den or additional bedrooms depending on your family's needs, along with a full bathroom on the main level, making it ideal for multigenerational living or aging parents. With a generous above grade footprint plus a finished walkout basement, there is no shortage of space for everyone to enjoy. Located just steps from Laurel Creek Conservation Area, 6 minutes from the charming village of St. Jacobs, and within the catchment of top ranked schools including Laurelwood Public School and Laurel Heights Secondary School. The Stork Family YMCA, Waterloo Public Library and The Boardwalk shopping district are all just minutes away. This truly is a neighbourhood people fall in love with and never want to leave. Updates include a new air conditioner (2022), quartz countertops in the kitchen (2024), new water softener (2025), updated paint throughout various areas, professionally painted entry, main and upstairs hallways and updated vanity taps in the upstairs bathroom (2026). Truly move in ready. Do not miss your opportunity to call this incredible home yours! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-07T23:05:29.635886+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103569"
+"ListOfficeKey": "156376"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T20:29:28Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T20:29:27Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "538"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "7891.76"
+"VirtualTourURLUnbranded": "https://youriguide.com/538_sandbanks_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:18 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/30001669/538-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2492
+"BelowGradeFinishedArea": 1224
+"OriginalEntryTimestamp": "2026-07-07T20:29:27.96Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1373130"
+"ListOfficeNationalAssociationId": "1003925"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('30001669')"
+"ID": "1602047"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25385
+post_id: "1602307"
+post_author: 1
+"ListingKey": "29998680"
+"ListingId": "X13531268"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-07T14:50:06Z"
+"RFModificationTimestamp": "2026-07-07T17:26:37Z"
+"ListPrice": 785000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1L8"
+"UnparsedAddress": "108 CLEARWATER CRESCENT, Waterloo, Ontario N2V1L8"
+"Coordinates": array:2 [
0 => -80.563513
1 => 43.49232
]
+"Latitude": 43.49232
+"Longitude": -80.563513
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Nestled in the highly sought-after Lakeshore North community, this beautifully maintained 2-storey home offers the perfect blend of comfort,functionality, and lifestyle. Featuring 3 spacious bedrooms, 2 bathrooms, and a thoughtfully designed layout, this home is ideal for growingfamilies, professionals, and those who love to entertain. From the upgraded vinyl flooring throughout portions of the main floor to the seamlesswalk-through kitchen design, every detail has been curated to enhance the natural flow of the home-making everyday living and hostingeffortless. Beyond the cosmetic upgrades, this home has also been mechanically updated over the years, offering buyers peace of mind and trulyworry-free ownership. The pride of ownership is evident throughout, making this a move-in-ready opportunity in one of Waterloo's mostdesirable neighbourhoods. The heart of the home opens into inviting living and dining spaces perfect for gatherings with family and friends, whilethe fully finished basement offers endless versatility-whether you envision a yoga studio, recreation room, home gym, workshop, or additionalentertaining space. Step outside to enjoy a beautifully private backyard retreat, ideal for summer evenings, barbecues, or relaxing in peace.Located just minutes from the highway, top-rated dining, gyms, shopping, and both universities, this home delivers unbeatable convenience inan area known for its strong community feel, mature surroundings, and exceptional accessibility. Complete with a double-car garage, fantasticlayout for entertaining, and extensive updates throughout, this is a rare opportunity to own a turn-key home in the coveted Lakeshore Northneighbourhood. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dryer"
5 => "Freezer"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"CreationDate": "2026-07-07T17:26:22.569712+00:00"
+"Directions": "Cross Streets: Wintergreen Dr. Northlake and Highpoint Ave. ** Directions: Northfield > Highpoint > Wintergreen."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Baseboard heaters"
1 => "Electric"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2237937"
+"ListOfficeKey": "285286"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "52.9 x 108 FT ; 52.89x107.97x36.9x120.33"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-07T14:42:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-07T14:42:20Z"
+"Stories": "2.0"
+"StreetName": "Clearwater"
+"StreetNumber": "108"
+"StreetSuffix": "Crescent"
+"TaxAnnualAmount": "4711"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/108_clearwater_crescent_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29998680/108-clearwater-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2235642"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "285286"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 52.1
+"OriginalEntryTimestamp": "2026-07-07T14:42:20.06Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1475924"
+"ListOfficeNationalAssociationId": "1349912"
+"CoListAgentNationalAssociationId": "1473542"
+"CoListOfficeNationalAssociationId": "1349912"
+"Media": array:50 [
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]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29998680')"
+"ID": "1602307"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25382
+post_id: "1590741"
+post_author: 1
+"ListingKey": "29986386"
+"ListingId": "40844884"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-03T18:55:15Z"
+"RFModificationTimestamp": "2026-07-03T19:40:13Z"
+"ListPrice": 649900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1618.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1P6"
+"UnparsedAddress": "315 MAYVIEW Crescent Unit# B, Waterloo, Ontario N2V1P6"
+"Coordinates": array:2 [
0 => -80.5558434
1 => 43.499126
]
+"Latitude": 43.499126
+"Longitude": -80.5558434
+"YearBuilt": 1987
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 315B Mayview Crescent! This beautifully maintained 3-bedroom, 2-bathroom home offers the perfect blend of modern updates, functional living space, and an incredible backyard retreat. Whether you're a first-time buyer, growing family, or looking to downsize, this move-in-ready home is sure to impress. Step inside to a bright, open-concept main floor featuring a spacious living and dining area that flows effortlessly into the beautifully renovated kitchen (2024), complete with contemporary finishes, ample cabinetry, and plenty of workspace. Upstairs, you'll find three generously sized bedrooms and a full bathroom, while the finished basement extends your living space with a large recreation room and an updated 3-piece bathroom (2021)—perfect for movie nights, overnight guests, or a home office. Outside, you'll discover your own private backyard oasis. The fully fenced yard is beautifully landscaped and offers mature trees for added privacy, an expansive lawn for children and pets to enjoy, and a covered gazebo that creates the perfect setting for summer entertaining or relaxing with family and friends. Additional updates include a new roof (2020) and a new furnace and central air conditioning system (2024), providing added peace of mind for years to come. Situated in a desirable, family-friendly neighbourhood close to schools, parks, shopping, trails, and everyday amenities, this home combines comfort, style, and convenience in one exceptional package. Don't miss your opportunity to make this beautifully updated property your next home! (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Window Coverings"
5 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-03T19:40:00.148172+00:00"
+"Directions": "Northlake Drive & Mayview Cres"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1951940"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Country residential"
2 => "Sump Pump"
]
+"PhotosChangeTimestamp": "2026-07-03T18:48:32Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-03T18:48:32Z"
+"Stories": "2.0"
+"StreetName": "MAYVIEW"
+"StreetNumber": "315"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3523"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/315-B-Mayview-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29986386/315-mayview-crescent-unit-b-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1113
+"BelowGradeFinishedArea": 505
+"OriginalEntryTimestamp": "2026-07-03T18:48:32.63Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1245634"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:40 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29986386')"
+"ID": "1590741"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25403
+post_id: "1585264"
+post_author: 1
+"ListingKey": "29979277"
+"ListingId": "X13513406"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T12:20:32Z"
+"RFModificationTimestamp": "2026-07-06T12:43:02Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S1"
+"UnparsedAddress": "430 KELSO DRIVE, Waterloo, Ontario N2V2S1"
+"Coordinates": array:2 [
0 => -80.583859
1 => 43.490424
]
+"Latitude": 43.490424
+"Longitude": -80.583859
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
8 => "Garage door opener remote(s)"
9 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T19:09:35.541665+00:00"
+"Directions": "Cross Streets: LakeLouise Blvd. ** Directions: Kelso Dr To LakeLouise Blvd."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2130557"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "44.8 x 139.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T19:29:47Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T12:14:37Z"
+"Stories": "2.0"
+"StreetName": "Kelso"
+"StreetNumber": "430"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "6672"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/c95ms_430_kelso_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29979277/430-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 44.9
+"OriginalEntryTimestamp": "2026-07-02T17:00:50.97Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1389915"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:50 [
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]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29979277')"
+"ID": "1585264"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25384
+post_id: "1584362"
+post_author: 1
+"ListingKey": "29977664"
+"ListingId": "40842487"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T13:40:08Z"
+"RFModificationTimestamp": "2026-07-06T13:53:56Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2733.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER Street, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5790234
1 => 43.4957774
]
+"Latitude": 43.4957774
+"Longitude": -80.5790234
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 500 Glacier Street in Waterloo-your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bedroom, 3-bathroom home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage.. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers’ Market, quick highway access & more. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T17:41:40.814366+00:00"
+"Directions": "Conservation Drive to Lake Louise to Glacier"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564122"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Corner Site"
1 => "Backs on greenbelt"
2 => "Conservation/green belt"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T13:31:14Z"
+"PhotosCount": 49
+"PoolFeatures": array:1 [
0 => "Above ground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T13:31:14Z"
+"Stories": "2.0"
+"StreetName": "GLACIER"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "5653"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977664/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 63.0
+"AboveGradeFinishedArea": 1854
+"BelowGradeFinishedArea": 879
+"OriginalEntryTimestamp": "2026-07-02T14:33:21.61Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Measurement follows RMS"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1142829"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:49 [
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]
48 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977664')"
+"ID": "1584362"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25379
+post_id: "1583779"
+post_author: 1
+"ListingKey": "29977455"
+"ListingId": "40841745"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:25:17Z"
+"RFModificationTimestamp": "2026-07-05T20:31:51Z"
+"ListPrice": 849900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0.144
+"LivingArea": 3238.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2S5"
+"UnparsedAddress": "430 KELSO Drive, Waterloo, Ontario N2V2S5"
+"Coordinates": array:2 [
0 => -80.5838742
1 => 43.4904493
]
+"Latitude": 43.4904493
+"Longitude": -80.5838742
+"YearBuilt": 2009
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 430 Kelso Drive, Waterloo: a beautifully maintained family home nestled in the highly sought-after Lakeshore North community. Situated on an impressive 44 x 139 ft. lot and just steps from the scenic Laurel Creek Conservation Area, this exceptional property offers fantastic curb appeal and parking for up to 4 vehicles, including a 2-car garage and 2-car private driveway. Step inside to a bright, carpet-free interior featuring soaring 9-foot ceilings, an open-concept layout and abundant natural light throughout. The kitchen comes complete with updated appliances, ample cabinetry, and generous counter space, making meal preparation effortless. The adjoining dining and living areas, anchored by a cozy electric fireplace create a warm, inviting atmosphere. Main floor laundry adds everyday convenience. Upstairs, you'll find 4 generously sized bedrooms and two full bathrooms, including a primary retreat with a walk-in closet and private ensuite. Designed with growing families in mind, the upper level offers both comfort and functionality. The fully finished basement adds tremendous versatility with a large recreation room, an additional bedroom and 3pc bathroom, ideal for extended family, guests, an in-law suite or mortgage-helper potential. This home has been thoughtfully upgraded for comfort and efficiency: a new heat pump (2024, doubling as central air), a two-stage furnace and refreshed R-60 attic insulation (2022) keep utility costs down year-round. Step outside to a huge, fully fenced, pool-sized backyard with a concrete patio, perfect for summer bbq's, family gatherings or simply relaxing. Set on a quiet street in one of Waterloo's most desirable neighbourhoods, this home is close to top-rated schools, parks, trails, universities, the YMCA, Conestoga Mall, shopping, restaurants, public transit, and major highways. A premium lot in an outstanding location, this house truly checks all the boxes. Don't miss your chance, book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Gas stove(s)"
4 => "Dishwasher"
5 => "Dryer"
6 => "Hood Fan"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T16:19:31.551916+00:00"
+"Directions": "Kelso Dr/LakeLouise Blvd"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564507"
+"ListOfficeKey": "289722"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Automatic Garage Door Opener"
]
+"LotSizeDimensions": "0.144"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T18:34:06Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:19:21Z"
+"Stories": "2.0"
+"StreetName": "KELSO"
+"StreetNumber": "430"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "6672"
+"VirtualTourURLUnbranded": "https://youriguide.com/c95ms_430_kelso_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29977455/430-kelso-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 45.0
+"AboveGradeFinishedArea": 2250
+"BelowGradeFinishedArea": 988
+"OriginalEntryTimestamp": "2026-07-02T14:12:03.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1123254"
+"ListOfficeNationalAssociationId": "1380559"
+"Media": array:50 [
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]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977455')"
+"ID": "1583779"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23461
+post_id: "1584541"
+post_author: 1
+"ListingKey": "29977329"
+"ListingId": "X13511442"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-06T14:20:04Z"
+"RFModificationTimestamp": "2026-07-06T14:32:43Z"
+"ListPrice": 949900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "500 GLACIER STREET, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.578434
1 => 43.495943
]
+"Latitude": 43.495943
+"Longitude": -80.578434
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 500 Glacier Street in Waterloo - your dream home with a spectacular backyard retreat, including a heated above-ground saltwater pool, backing onto greenspace & trails. Situated on an oversized corner lot in the highly desirable & family-oriented neighbourhood of Conservation Meadows, this lovely 4-bed, 3-bath home offers over 2,700 sq. ft. of finished living space, many recent updates & a bright, spacious open-concept layout perfect for entertaining or relaxing with family. The recently renovated gourmet kitchen features stainless steel appliances, a beautiful backsplash & a convenient centre island for casual dining, while the oversized dining area offers plenty of space for more formal gatherings. Relax & unwind in the sophisticated family room, complete with a gas fireplace, oversized windows & sliding door access to the expansive deck & pool area. A 2-piece bathroom & main floor laundry complete the main level. Upstairs, the stunning primary suite features vaulted ceilings, custom built-ins, two walk-in closets & a newly updated spa-like 3-piece ensuite with tiled glass shower, rain shower fixture, heated floors & heated towel rack. Two additional spacious bedrooms & a 4-piece main bathroom complete this level. The fully finished basement offers a large recreation room, a potential 4th bedroom & the added convenience of a walk-up directly into the garage. Notable updates include furnace & air conditioning in 2017, shingles in 2015 & above-ground saltwater pool in 2018. Additional features include a carpet-free main & lower level with luxury vinyl flooring, custom blinds & more. Backing onto greenspace & walking trails, surrounded by mature trees & lush perennial gardens, this lovely home is located on a quiet, tree-lined street in a premium location close to schools, parks, Laurel Creek Conservation Area, shopping, restaurants, Starbucks, Sobeys, St. Jacobs Farmers' Market, quick highway access & more. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Water Treatment"
7 => "Window Coverings"
8 => "Garage door opener"
9 => "Garage door opener remote(s)"
10 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-07-02T15:52:13.449772+00:00"
+"Directions": "Cross Streets: Lake Louise Blvd. ** Directions: Conservation Drive to Lake Louise to Glacier."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2099842"
+"ListOfficeKey": "288578"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Wooded area"
1 => "Conservation/green belt"
2 => "Sump Pump"
]
+"LotSizeDimensions": "63.1 x 124.7 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-07-06T13:38:20Z"
+"PhotosCount": 45
+"PoolFeatures": array:2 [
0 => "Above ground pool"
1 => "Salt Water Pool"
]
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-06T14:10:35Z"
+"Stories": "2.0"
+"StreetName": "Glacier"
+"StreetNumber": "500"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "5653"
+"View": "View"
+"VirtualTourURLUnbranded": "https://youriguide.com/500_glacier_street_waterloo_on/doc/floorplan_imperial.pdf"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29977329/500-glacier-street-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2000
+"LivingAreaMinimum": 1500
+"ZoningDescription": "R"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 63.1
+"OriginalEntryTimestamp": "2026-07-02T13:47:07.33Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1370032"
+"ListOfficeNationalAssociationId": "1369645"
+"Media": array:45 [
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]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29977329')"
+"ID": "1584541"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25404
+post_id: "1576593"
+post_author: 1
+"ListingKey": "29966567"
+"ListingId": "40843841"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-05T20:25:15Z"
+"RFModificationTimestamp": "2026-07-05T20:32:14Z"
+"ListPrice": 1049900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 2937.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L5R5"
+"UnparsedAddress": "292 THORNCREST Drive, Waterloo, Ontario N2L5R5"
+"Coordinates": array:2 [
0 => -80.5558838
1 => 43.4837447
]
+"Latitude": 43.4837447
+"Longitude": -80.5558838
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Set on a premium 66' x 114' lot, Welcome to an exceptional family home in Waterloo's prestigious Lakeshore neighbourhood, offering approx 3,000 sqft of finished living space and the perfect blend of luxury, functionality, & income potential. This beautifully updated property features 3+2 bedrooms, 4 bathrooms, & over $150,000 in recent upgrades, making it ideal for growing families, multigenerational living. A charming double-door entry leads to a bright & inviting interior featuring new ceramic tile flooring in the foyer and kitchen, hardwood floors throughout the living room, dining room, and office, elegant pot lights, and a cozy gas fireplace. The stunning brand-new kitchen, just completed in June 2026, offers modern cabinetry, a brand new stove, and a functional layout designed for everyday living and entertaining. Walk out to the huge deck overlooking a private, mature treed backyard with a peaceful trail-like setting. The second floor offers a massive primary bedroom with an ensuite bathroom and two additional spacious bedrooms sharing a full bath. The professionally finished legal second dwelling, completed in 2023 with over $100,000 invested, features two bedrooms, a full kitchen, living area, separate entrance, and private laundry, providing excellent mortgage support or space for extended family. Additional improvements include a newly constructed walkway to the basement entrance in 2023, beautifully landscaped front gardens with an irrigation system featuring 6 sprinklers, a double-car garage, and parking for 4 more vehicles, totaling 6 parkings. Ideally located just minutes from the University of Waterloo, Wilfrid Laurier University, Conestoga Mall, top-rated schools, parks, trails, and transit. This property offers unmatched convenience and long-term value in terms of a spacious family home, an income-generating investment property, or a home that allows your university-bound children to live close to campus while building equity. RSA (id:62650)"
+"Appliances": array:2 [
0 => "Water softener"
1 => "Central Vacuum"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T18:57:56.523096+00:00"
+"Directions": "Bearinger Road to Glen Forrest Blvd to Thorncrest Drive"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1524224"
+"ListOfficeKey": "275989"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Southern exposure"
1 => "Sump Pump"
2 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T17:51:15Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-05T20:18:46Z"
+"Stories": "2.0"
+"StreetName": "THORNCREST"
+"StreetNumber": "292"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "7920.4"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youtu.be/B__MMicHLgQ"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29966567/292-thorncrest-drive-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "SR2A"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 66.0
+"AboveGradeFinishedArea": 1989
+"BelowGradeFinishedArea": 948
+"OriginalEntryTimestamp": "2026-06-29T17:51:14.88Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1064132"
+"ListOfficeNationalAssociationId": "1269881"
+"Media": array:50 [
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]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29966567')"
+"ID": "1576593"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25405
+post_id: "1570523"
+post_author: 1
+"ListingKey": "29956597"
+"ListingId": "40842544"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-07-02T21:20:20Z"
+"RFModificationTimestamp": "2026-07-02T21:26:44Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.152
+"LivingArea": 1111.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4K6"
+"UnparsedAddress": "682 GLEN FORREST Boulevard, Waterloo, Ontario N2L4K6"
+"Coordinates": array:2 [
0 => -80.5523978
1 => 43.4928288
]
+"Latitude": 43.4928288
+"Longitude": -80.5523978
+"YearBuilt": 1969
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Accepting Offers Anytime - You're not going to want to miss this one! This fully updated raised bungalow offers a clean, move-in ready setup with 3 bedrooms, 2 bathrooms, as well as a single car garage. The main level features a bright, modern feel with California shutters and hardwood floors throughout. The updated kitchen complete with stainless steel appliances offers ample counter and cabinet space and overlooks the rear yard. Down the hall are the 3 bedrooms and renovated spa like family bath! Enjoy summer days outside on the elevated deck with a gazebo overlooking the private, heated in-ground pool. The lower level adds real flexibility with a separate office space that has direct outdoor access, as well as a large family room with a gas fireplace, and a second 3-piece bathroom, making it ideal for work-from-home or multi-use living. Book your private showing today and make this home your own! (id:62650)"
+"Appliances": array:1 [
0 => "Water softener"
]
+"ArchitecturalStyle": array:1 [
0 => "Raised bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T17:29:58.640281+00:00"
+"Directions": "Weber St N"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1600707"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0.152"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-07-02T21:11:33Z"
+"PhotosCount": 30
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-07-02T21:11:33Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "682"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "5069"
+"VirtualTourURLUnbranded": "https://youriguide.com/682_glen_forest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29956597/682-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1926813"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 56.0
+"AboveGradeFinishedArea": 1111
+"OriginalEntryTimestamp": "2026-06-26T11:50:24.26Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1149297"
+"ListOfficeNationalAssociationId": "1473831"
+"CoListAgentNationalAssociationId": "1229829"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:30 [
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]
]
+"DaysOnMarket": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29956597')"
+"ID": "1570523"
}
]
+success: true
+page_size: 9
+page_count: 8
+count: 72
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]