array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29848600 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23331
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23333
+post_id: "1490975"
+post_author: 1
+"ListingKey": "29848600"
+"ListingId": "40835766"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T17:40:33Z"
+"RFModificationTimestamp": "2026-06-04T17:57:39Z"
+"ListPrice": 1169000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 2824.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B3"
+"UnparsedAddress": "121 OAK PARK Drive, Waterloo, Ontario N2K0B3"
+"Coordinates": array:2 [
0 => -80.4977677
1 => 43.5205425
]
+"Latitude": 43.5205425
+"Longitude": -80.4977677
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Ideally situated in sought-after Carriage Crossing, this exceptional former model home freehold end unit townhouse offers sophisticated living with an impressive two-storey foyer and elegant split-entry staircase. The sun-filled great room features a cozy gas fireplace and flows seamlessly into the dining area and beautifully appointed kitchen, creating the perfect space for everyday living and entertaining. A charming second-storey loft-style den overlooks the foyer below, adding architectural interest and flexible living space. The luxurious primary suite serves as a private retreat, complete with a spa-inspired ensuite and walk-in closet. Premium finishes throughout include California shutters, granite countertops, bleached engineered hardwood flooring, porcelain tile, and numerous quality upgrades. The professionally finished lower level extends the living space with a versatile recreation room, custom Murphy bed for overnight guests, and a stylish 3 piece bathroom, ideal for visitors, or a private home office setup. Outside, enjoy a gorgeous picturesque backyard featuring a covered porch, maintenance free deck and beautiful stone patio, irrigation system, perfect for relaxing or entertaining. A rare opportunity to own a beautifully upgraded home in one of the area's most desirable neighbourhoods. Easy access to Rim Park, Walter Bean walking trails, Grey Silo Golf Course, East Waterloo Branch Library and shopping at Conestoga Mall. (id:62650)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Partially finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T20:27:53.831555+00:00"
+"Directions": "University Ave E to Millennium Blvd to Oak Park Dr"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Backs on greenbelt"
1 => "Conservation/green belt"
2 => "Recreational"
3 => "Sump Pump"
4 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T19:31:10Z"
+"PhotosCount": 47
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T17:31:07Z"
+"Stories": "2.0"
+"StreetName": "OAK PARK"
+"StreetNumber": "121"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "6103.89"
+"VirtualTourURLUnbranded": "https://youriguide.com/121_oak_park_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [
"RoomKey" => "1651669169"
"RoomType" => "Utility room"
"ListingId" => "40835766"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "12'10'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.37Z"
]
1 => array:11 [
"RoomKey" => "1651669170"
"RoomType" => "3pc Bathroom"
"ListingId" => "40835766"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.37Z"
]
2 => array:11 [
"RoomKey" => "1651669171"
"RoomType" => "Recreation room"
"ListingId" => "40835766"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "23'5'' x 23'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
3 => array:11 [
"RoomKey" => "1651669172"
"RoomType" => "4pc Bathroom"
"ListingId" => "40835766"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "7'5'' x 10'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
4 => array:11 [
"RoomKey" => "1651669173"
"RoomType" => "Family room"
"ListingId" => "40835766"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "11'11'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
5 => array:11 [
"RoomKey" => "1651669174"
"RoomType" => "Bedroom"
"ListingId" => "40835766"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
6 => array:11 [
"RoomKey" => "1651669175"
"RoomType" => "Full bathroom"
"ListingId" => "40835766"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "10'5'' x 13'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
7 => array:11 [
"RoomKey" => "1651669176"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835766"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "11'3'' x 14'1''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
8 => array:11 [
"RoomKey" => "1651669177"
"RoomType" => "Foyer"
"ListingId" => "40835766"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "6'7'' x 11'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
9 => array:11 [
"RoomKey" => "1651669178"
"RoomType" => "Laundry room"
"ListingId" => "40835766"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "6'4'' x 10'5''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.38Z"
]
10 => array:11 [
"RoomKey" => "1651669179"
"RoomType" => "2pc Bathroom"
"ListingId" => "40835766"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.39Z"
]
11 => array:11 [
"RoomKey" => "1651669180"
"RoomType" => "Kitchen"
"ListingId" => "40835766"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "10'7'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.39Z"
]
12 => array:11 [
"RoomKey" => "1651669181"
"RoomType" => "Dining room"
"ListingId" => "40835766"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "10'8'' x 16'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.39Z"
]
13 => array:11 [
"RoomKey" => "1651669182"
"RoomType" => "Living room"
"ListingId" => "40835766"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29848600"
"RoomLength" => null
"RoomDimensions" => "14'7'' x 20'11''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-04T17:31:07.39Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29848600/121-oak-park-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MR-4"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 28.0
+"AboveGradeFinishedArea": 2028
+"BelowGradeFinishedArea": 796
+"OriginalEntryTimestamp": "2026-06-03T19:31:10.18Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"Media": array:47 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29848600_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/d77f2f5f45b65eb4a25e2a0eef3afa4b.webp"
"MediaSize" => 99135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-d77f2f5f45b65eb4a25e2a0eef3afa4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone and stucco facade featuring a covered front entry"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29848600_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/438ad2b6decf9350305fdf5468cf73d9.webp"
"MediaSize" => 103456
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-438ad2b6decf9350305fdf5468cf73d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone and stucco exterior featuring a portico entry, arched windows, and an integrated garage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29848600_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/f34decf2b41622261f2e209ea1b8479a.webp"
"MediaSize" => 121580
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-f34decf2b41622261f2e209ea1b8479a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone facade townhouse featuring a prominent front entrance with columns, a paved driveway, an attached garage, landscaped garden beds, and a manicured lawn"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29848600_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/91216e0cc8a06a93e2d4bb5bd94fd396.webp"
"MediaSize" => 99797
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-91216e0cc8a06a93e2d4bb5bd94fd396.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone facade residence featuring a black front entry door with decorative glass, sidelights, and a transom window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29848600_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/437eaf5fc322bbf2da61104ec43dcdd3.webp"
"MediaSize" => 163131
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-437eaf5fc322bbf2da61104ec43dcdd3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a manicured lawn, stone patio, brick exterior, and a black wrought iron fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29848600_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/59d30f4de25a0a9b93f2dda85a9211db.webp"
"MediaSize" => 82376
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-59d30f4de25a0a9b93f2dda85a9211db.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29848600_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/10ebd75c6cda71ab77f709b012ceb93f.webp"
"MediaSize" => 168254
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-10ebd75c6cda71ab77f709b012ceb93f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious stamped concrete patio with curved stone planter beds, a manicured lawn, and mature perimeter trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29848600_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/655e4f53f4a700bed28de1dc4c21dbe1.webp"
"MediaSize" => 106877
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-655e4f53f4a700bed28de1dc4c21dbe1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered outdoor patio featuring brick exterior, a paneled ceiling, and a sliding glass door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29848600_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/e828cedd284e0010ae318966fa6443d6.webp"
"MediaSize" => 75774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-e828cedd284e0010ae318966fa6443d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a black and white staircase with dark treads and white risers, black and white balusters, and a black handrail"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29848600_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/2b529c7f9fef46b0db20afc14a94345a.webp"
"MediaSize" => 72769
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-2b529c7f9fef46b0db20afc14a94345a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept kitchen featuring an island with seating, stainless steel appliances, a decorative range hood, recessed lighting, and mixed flooring materials"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29848600_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/6e2d0ed56e386985b53d920f0e5014ed.webp"
"MediaSize" => 71341
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-6e2d0ed56e386985b53d920f0e5014ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring a substantial island with granite countertop, stainless steel appliances, custom cabinetry, recessed lighting, and tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29848600_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/5030b73b4905534b33405bb962dd00e2.webp"
"MediaSize" => 79710
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-5030b73b4905534b33405bb962dd00e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light-toned cabinetry, stainless steel appliances, granite countertops, and a herringbone-patterned backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29848600_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/b8508971b571f66e571c5ade74082790.webp"
"MediaSize" => 80900
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-b8508971b571f66e571c5ade74082790.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen island featuring a granite countertop, undermount sink, and dark wood cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29848600_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/6a5e4cf6d5ecec8e1dd53c58f4d0e61e.webp"
"MediaSize" => 78620
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-6a5e4cf6d5ecec8e1dd53c58f4d0e61e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29848600_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/250b42e718cc3222f2d2832bce95365c.webp"
"MediaSize" => 69001
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-250b42e718cc3222f2d2832bce95365c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious living room featuring light wood-finish flooring, recessed lighting, and a prominent fireplace with a substantial mantel"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29848600_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/1975c22b2923e42bb19b43859236f4e6.webp"
"MediaSize" => 70240
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-1975c22b2923e42bb19b43859236f4e6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring a stone fireplace with a built-in television niche, light wood-finish flooring, recessed lighting, multiple windows with plantation shutters, and integrated wall shelving"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29848600_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/bcd85a3299e22eec9f3bd97457fc0a72.webp"
"MediaSize" => 72794
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-bcd85a3299e22eec9f3bd97457fc0a72.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Light wood-finish flooring throughout the main living area, complemented by a stone-surround fireplace with an integrated television niche"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29848600_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/bdf2056dc3c275d5bc2d9dbf7da99a7b.webp"
"MediaSize" => 69842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-bdf2056dc3c275d5bc2d9dbf7da99a7b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Gourmet kitchen featuring a central island with countertop seating, stainless steel appliances, extensive cabinetry, and a pantry with additional storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29848600_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/151241a14490726fdc17d00d42cb92b2.webp"
"MediaSize" => 59606
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-151241a14490726fdc17d00d42cb92b2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining space featuring decorative wall paneling, light wood-finish flooring, and a contemporary chandelier"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29848600_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/0acb2f13be7d289b0deb8d958429fb58.webp"
"MediaSize" => 77967
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-0acb2f13be7d289b0deb8d958429fb58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept dining area featuring light wood-finish flooring, a contemporary chandelier, multiple windows with plantation shutters, a sliding glass door, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29848600_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/93f03dc98372b488f95f86d6ad0dfd1c.webp"
"MediaSize" => 78218
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-93f03dc98372b488f95f86d6ad0dfd1c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring a central kitchen island with a built-in dishwasher, stainless steel appliances, a fireplace with a mantel, and light wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29848600_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/56d59d525912405851ef5d7b7d0612d2.webp"
"MediaSize" => 51387
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-56d59d525912405851ef5d7b7d0612d2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Powder room featuring a vessel sink, dark stone countertop, and light wood-finish vanity with clear hardware"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29848600_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/8d00df8358faff1020eadd7c53eaeda1.webp"
"MediaSize" => 60059
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-8d00df8358faff1020eadd7c53eaeda1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dedicated laundry area featuring a utility sink with a chrome faucet, light blue cabinetry with white knobs, and a patterned tile backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29848600_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/03a1b72d03dc87729d869e994ac5a1ab.webp"
"MediaSize" => 67398
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-03a1b72d03dc87729d869e994ac5a1ab.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a large arched window with plantation shutters, recessed lighting, and a wall-mounted built-in television with a soundbar"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29848600_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/99c9ae8d4392ae7893e006b3c7f9e6a8.webp"
"MediaSize" => 73506
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-99c9ae8d4392ae7893e006b3c7f9e6a8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted landing area featuring a staircase with painted newel posts and spindles, recessed lighting, and a wall-mounted light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29848600_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/9206145a80cc936166b5e1e37405a288.webp"
"MediaSize" => 66555
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-9206145a80cc936166b5e1e37405a288.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring carpet flooring, a tray ceiling, and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29848600_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/fe332728df11d34746bc4be08f89f68e.webp"
"MediaSize" => 68158
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-fe332728df11d34746bc4be08f89f68e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring a tray ceiling with a ceiling fan, neutral wall tones, and carpet flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29848600_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/66bd6849ed0a21a0cd2df3a63f6cf03c.webp"
"MediaSize" => 77140
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-66bd6849ed0a21a0cd2df3a63f6cf03c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Double vanity with dark wood cabinetry, white stone countertop, and an integrated backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29848600_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/6ad8d930ea74c877482bc69c77b5bfe7.webp"
"MediaSize" => 69892
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-6ad8d930ea74c877482bc69c77b5bfe7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a soaking tub, glass-enclosed shower, tile flooring, built-in shelving, and a custom closet system"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29848600_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/ad8d7fced3946888c15088c221f8e01a.webp"
"MediaSize" => 63944
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-ad8d7fced3946888c15088c221f8e01a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious bathroom featuring a built-in jetted tub, a glass-enclosed shower with tile surround, and a dark wood vanity with a light-colored countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29848600_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/6e7618e8bb26e3fab84383d60bb444a5.webp"
"MediaSize" => 64170
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-6e7618e8bb26e3fab84383d60bb444a5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bedroom featuring light gray wall paint, plush carpeting, white baseboards, and a window with white trim"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29848600_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/c8a8d7a2a781565f88968faaed36804f.webp"
"MediaSize" => 84787
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-c8a8d7a2a781565f88968faaed36804f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a vanity with a dark countertop and undermount sink, a framed mirror, a tub-shower combination with white subway tile surround, and dark tile flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29848600_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/cb674286d7ea45e6ae1d139ff73025a9.webp"
"MediaSize" => 64742
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-cb674286d7ea45e6ae1d139ff73025a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Finished lower level featuring a built-in media center with an electric fireplace, recessed lighting, and a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29848600_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/507f4f34018fe124c1fd9de3e9740d98.webp"
"MediaSize" => 66303
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-507f4f34018fe124c1fd9de3e9740d98.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted recreation area with light-toned walls, recessed lighting, and a drop ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29848600_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/37caaf249190ff7e14aac58b809e1be7.webp"
"MediaSize" => 45272
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-37caaf249190ff7e14aac58b809e1be7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open room featuring light-colored carpeting, recessed lighting, and a built-in wall bed with integrated cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29848600_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/d95e62d0e96bac4104c67d875b00379d.webp"
"MediaSize" => 68992
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-d95e62d0e96bac4104c67d875b00379d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary bathroom featuring a spacious glass-enclosed shower with full-height tile surround, a white vanity with integrated sink, and an ornamental framed mirror"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29848600_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/98ead482dffe4496b34750114499e8a9.webp"
"MediaSize" => 164798
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-98ead482dffe4496b34750114499e8a9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Stone paver patio featuring a landscaped garden bed and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29848600_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/66e78c585a953f6999051b0e8bea952c.webp"
"MediaSize" => 121184
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-66e78c585a953f6999051b0e8bea952c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious paver patio with a covered porch area"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29848600_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/f0e043cb57cae57664a8edb293607323.webp"
"MediaSize" => 156914
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-f0e043cb57cae57664a8edb293607323.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious backyard featuring a large lawn area, a circular stone patio, and a stone-retained garden bed"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29848600_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/b5a88cb3cb4b44565044b9d9064b2954.webp"
"MediaSize" => 155617
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-b5a88cb3cb4b44565044b9d9064b2954.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a stone retaining wall, layered landscaping, a concrete patio, and a covered porch with a red brick exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29848600_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/71307ee3b0d24c3b398c4785405d2606.webp"
"MediaSize" => 150902
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-71307ee3b0d24c3b398c4785405d2606.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive patio featuring large format pavers and a private wood fence"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29848600_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/b04fe23382ff456e670e0acf51481638.webp"
"MediaSize" => 140846
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-b04fe23382ff456e670e0acf51481638.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Covered porch featuring composite decking and a white soffit ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29848600_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/8fa261909461a2337bb00a555f579991.webp"
"MediaSize" => 133948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-8fa261909461a2337bb00a555f579991.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a stone retaining wall, manicured lawn, and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29848600_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/eb42b85478efdc6245c07f2b8e3ffccf.webp"
"MediaSize" => 214671
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-eb42b85478efdc6245c07f2b8e3ffccf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive backyard featuring a stone patio, manicured lawn, and mature trees"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
44 => array:13 [
"Order" => 45
"MediaKey" => "29848600_4890_45"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/f259b62e6f156975ee3876cb901de91b.webp"
"MediaSize" => 155783
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-f259b62e6f156975ee3876cb901de91b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Expansive landscape featuring a meandering waterway, mature trees, and multiple golf course greens"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
45 => array:13 [
"Order" => 46
"MediaKey" => "29848600_4890_46"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/3f0776bbde1314dabbbea3f389fa83f5.webp"
"MediaSize" => 136370
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-3f0776bbde1314dabbbea3f389fa83f5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial representation featuring a sports complex with a fenced turf soccer field, a secondary grass field, and paved walking paths"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
46 => array:13 [
"Order" => 47
"MediaKey" => "29848600_4890_47"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29848600/1f3a03097577364666fe2a78d1635dd2.webp"
"MediaSize" => 155523
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29848600/thumbnail-1f3a03097577364666fe2a78d1635dd2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Aerial perspective showcasing a residential street with homes featuring brick and siding exteriors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835766"
"ResourceRecordKey" => "29848600"
"ModificationTimestamp" => "2026-06-03T19:31:10.19Z"
]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29848600')"
+"ID": "1490975"
}
]
+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 283125" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24702
+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 1564233" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24787
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /PropertyAdditionalInfo?$select=ALL&$top=1&$filter=ListingKey eq '29848600'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25114
+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 '29848600'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25130
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29848600' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4977677 43.5205425)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25203
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25197
+post_id: "1499289"
+post_author: 1
+"ListingKey": "29860637"
+"ListingId": "X13248204"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T13:20:33Z"
+"RFModificationTimestamp": "2026-06-06T13:24:11Z"
+"ListPrice": 565000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G7"
+"UnparsedAddress": "102 - 247 GREY SILO ROAD, Waterloo, Ontario N2K0G7"
+"Coordinates": array:2 [
0 => -80.497131
1 => 43.522269
]
+"Latitude": 43.522269
+"Longitude": -80.497131
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Unit 102 at 247 Grey Silo Road - one of Waterloo's most sought-after addresses. This beautifully appointed 2-bed, 2-bath ground-floor condo features luxury vinyl plank flooring, oversized windows, and brushed nickel hardware throughout. The open concept kitchen is a true highlight, featuring a large island, quartz countertops, KitchenAid stainless steel appliances, and an upgraded range hood - perfect for both cooking and entertaining. Just off the kitchen, step onto an enormous balcony with three distinct seating areas where BBQs are permitted - an entertainer's delight for gatherings or quiet evenings outdoors. The generously sized primary suite comfortably fits a king-size bed with room to spare, includes a double closet, and features a private ensuite with walk-in shower - perfect for downsizers. Modern bathrooms feature quartz vanities and comfort-height toilets, while additional upgrades include in-suite washer and dryer, a high efficiency water heater, water softener, and an HRV system for fresh air circulation year-round. Ground-floor entry keeps daily life effortless, and the rooftop terrace offers even more outdoor space to enjoy. Two owned parking spots included.Steps from Grey Silo Golf Course, the Walter Bean Trail, St. Jacobs Farmers' Market, RIM Park, and local restaurants - with easy access to Uptown Waterloo, both universities, and the expressway. Low-maintenance luxury living in one of Waterloo's most prestigious pockets (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Dishwasher"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
6 => "Window Coverings"
7 => "Water Heater"
]
+"AssociationFee": "625.57"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:2 [
0 => "Common Area Maintenance"
1 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:2 [
0 => "Central air conditioning"
1 => "Ventilation system"
]
+"CreationDate": "2026-06-05T17:29:16.857062+00:00"
+"Directions": "Cross Streets: University & Millennium. ** Directions: University to Millennium Blvd."
+"ExteriorFeatures": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2235403"
+"ListOfficeKey": "294121"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Elevator"
1 => "In suite Laundry"
]
+"ParkingFeatures": array:2 [
0 => "Garage"
1 => "Underground"
]
+"PhotosChangeTimestamp": "2026-06-06T13:12:35Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T13:12:35Z"
+"StreetName": "Grey Silo"
+"StreetNumber": "247"
+"StreetSuffix": "Road"
+"TaxAnnualAmount": "4233.13"
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1653127302"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13248204"
"RoomLevel" => "Main level"
"RoomWidth" => 4.72
"ListingKey" => "29860637"
"RoomLength" => 3.78
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T13:12:35.07Z"
]
1 => array:11 [
"RoomKey" => "1653127303"
"RoomType" => "Bathroom"
"ListingId" => "X13248204"
"RoomLevel" => "Main level"
"RoomWidth" => 2.39
"ListingKey" => "29860637"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T13:12:35.07Z"
]
2 => array:11 [
"RoomKey" => "1653127304"
"RoomType" => "Bathroom"
"ListingId" => "X13248204"
"RoomLevel" => "Main level"
"RoomWidth" => 2.72
"ListingKey" => "29860637"
"RoomLength" => 2.29
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-06T13:12:35.07Z"
]
3 => array:11 [
"RoomKey" => "1653127305"
"RoomType" => "Bedroom"
"ListingId" => "X13248204"
"RoomLevel" => "Main level"
"RoomWidth" => 3.96
"ListingKey" => "29860637"
"RoomLength" => 3.96
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
…1
]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29860637/102-247-grey-silo-road-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "King Management"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Visitor Parking"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1199
+"LivingAreaMinimum": 1000
+"ZoningDescription": "MR4-MD3"
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-05T16:33:05.88Z"
+"ListAgentNationalAssociationId": "1473266"
+"ListOfficeNationalAssociationId": "1435796"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860637')"
+"ID": "1499289"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25199
+post_id: "1498881"
+post_author: 1
+"ListingKey": "29860224"
+"ListingId": "40835057"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T13:10:14Z"
+"RFModificationTimestamp": "2026-06-06T13:19:35Z"
+"ListPrice": 565000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 1100.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G7"
+"UnparsedAddress": "247 GREY SILO Road Unit# 102, Waterloo, Ontario N2K0G7"
+"Coordinates": array:2 [
0 => -80.4970393
1 => 43.5221163
]
+"Latitude": 43.5221163
+"Longitude": -80.4970393
+"YearBuilt": 2020
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Unit 102 at 247 Grey Silo Road — one of Waterloo's most sought-after addresses. This beautifully appointed 2-bed, 2-bath ground-floor condo features luxury vinyl plank flooring, oversized windows, and brushed nickel hardware throughout. The open concept kitchen is a true highlight, featuring a large island, quartz countertops, KitchenAid stainless steel appliances, and an upgraded range hood — perfect for both cooking and entertaining. Just off the kitchen, step onto an enormous balcony with three distinct seating areas where BBQs are permitted — an entertainer's delight for gatherings or quiet evenings outdoors. The generously sized primary suite comfortably fits a king-size bed with room to spare, includes a double closet, and features a private ensuite with walk-in shower — perfect for downsizers. Modern bathrooms feature quartz vanities and comfort-height toilets, while additional upgrades include in-suite washer and dryer, a high efficiency water heater, water softener, and an HRV system for fresh air circulation year-round. Ground-floor entry keeps daily life effortless, and the rooftop terrace offers even more outdoor space to enjoy. Two owned parking spots included.Steps from Grey Silo Golf Course, the Walter Bean Trail, St. Jacobs Farmers' Market, RIM Park, and local restaurants — with easy access to Uptown Waterloo, both universities, and the expressway. Low-maintenance luxury living in one of Waterloo's most prestigious pockets (id:62650)"
+"Appliances": array:8 [
0 => "Refrigerator"
1 => "Water softener"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"AssociationFee": "625"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:3 [
0 => "Quiet Area"
1 => "School Bus"
2 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-05T16:45:09.784991+00:00"
+"Directions": "University to Millenium to Crossgate Blvd to Grey Silo"
+"ExteriorFeatures": array:1 [
0 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:1 [
0 => "Forced air"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2159234"
+"ListOfficeKey": "294047"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Southern exposure"
1 => "Balcony"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-06T13:02:09Z"
+"PhotosCount": 26
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T13:02:09Z"
+"Stories": "1.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "247"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4247"
+"VirtualTourURLUnbranded": "https://sites.ground2airmedia.com/videos/019e9811-fbef-734e-b539-fe9abba772b9"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:7 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29860224/247-grey-silo-road-unit-102-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"ZoningDescription": "MR-4/MD3"
+"BedroomsAboveGrade": 2
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1100
+"OriginalEntryTimestamp": "2026-06-05T15:51:47.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1410495"
+"ListOfficeNationalAssociationId": "1435346"
+"Media": array:26 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29860224')"
+"ID": "1498881"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25196
+post_id: "1494487"
+post_author: 1
+"ListingKey": "29852179"
+"ListingId": "40834591"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:52Z"
+"RFModificationTimestamp": "2026-06-06T20:47:37Z"
+"ListPrice": 774900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2789.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B9"
+"UnparsedAddress": "243 GREY SILO Road Unit# 11, Waterloo, Ontario N2K0B9"
+"Coordinates": array:2 [
0 => -80.495655
1 => 43.521308
]
+"Latitude": 43.521308
+"Longitude": -80.495655
+"YearBuilt": 2017
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 11 - 243 Grey Silo Road, located in a luxury executive townhouse community! **This home has 3 Large bright bedrooms and 3 bathrooms in an open-concept layout, with an unfinished basement ready for your ideas. **Entry leads to a spacious foyer, main floor laundry, and convenient access to the powder room. **Kitchen features upgraded appliances, an island with a breakfast bar and pantry. **The living area's focal point is an upgraded mantle with a Tru-View Bespoke Electric Fireplace and features a double glass door that leads to the composite deck and gas barbecue. **Solid staircase with a runner leads to an upper-level reading nook or open den. **Primary bedroom features a luxury ensuite with a glass shower, double sink and separate toilet room, plus a massive 7'5 x 7'1 walk in closet. **Other features include maple hardwood flooring, updated lighting fixtures, numerous extra windows allowing for natural light, wrought iron railings, fresh paint, a mudroom, and all appliances. **This property has barely been lived in and feels like new! Located just minutes from RIM Park, Grey Silo Golf Course, Waterloo Public Library - Eastside Branch, and the Grand River Trail. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "Other"
]
+"AssociationFee": "594.44"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-04T17:37:46.206137+00:00"
+"Directions": "Millennium Blvd. to Oak Park Dr."
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Stucco"
]
+"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": "1563803"
+"ListOfficeKey": "76775"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Paved driveway"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T14:00:50Z"
+"PhotosCount": 37
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:21:51Z"
+"Stories": "2.0"
+"StreetName": "GREY SILO"
+"StreetNumber": "243"
+"StreetSuffix": "Road"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "7083"
+"VirtualTourURLUnbranded": "https://youriguide.com/11_243_grey_silo_rd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29852179/243-grey-silo-road-unit-11-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R9"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2130
+"BelowGradeFinishedArea": 659
+"OriginalEntryTimestamp": "2026-06-04T14:00:50.29Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1108799"
+"ListOfficeNationalAssociationId": "1004341"
+"Media": array:37 [
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]
]
+"DaysOnMarket": 2
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29852179')"
+"ID": "1494487"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25200
+post_id: "1492205"
+post_author: 1
+"ListingKey": "29850552"
+"ListingId": "40835076"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T21:21:10Z"
+"RFModificationTimestamp": "2026-06-04T21:41:59Z"
+"ListPrice": 799000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2226.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4C2"
+"UnparsedAddress": "644 YARMOUTH Drive, Waterloo, Ontario N2K4C2"
+"Coordinates": array:2 [
0 => -80.4980853
1 => 43.5099308
]
+"Latitude": 43.5099308
+"Longitude": -80.4980853
+"YearBuilt": 1999
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "It isn't every day that you find an East Coast-inspired home with a backyard that's every bit as charming as the front porch. This is a home filled with inviting spaces that encourage you to slow down, relax, and enjoy life's quieter moments. Inside, the bright, open layout feels surprisingly spacious, with large windows that fill the home with natural light and create a warm, welcoming atmosphere. Some of the most stunning features include the hardwood and ceramic tile floors, the two matte-black gas fireplaces, and the beautiful, creamy quartz countertops paired with a soft subway backsplash. Finished on all three levels with three generous bedrooms and three bathrooms, this is a home you can move into and immediately begin enjoying. Located in the highly sought-after Eastbridge neighbourhood, you'll appreciate being within a short walking distance of both Catholic and public schools, while also being minutes from RIM Park, Browns Socialhouse, Grey Silo Golf Course, and convenient expressway access. From sunny reading corners to peaceful places to unwind at the end of the day, this home simply feels good to be in. (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Central Vacuum"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"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-06-04T00:49:12.108870+00:00"
+"Directions": "Eastbridge"
+"ExteriorFeatures": array:1 [
0 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1878823"
+"ListOfficeKey": "299554"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Country residential"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-04T14:00:44Z"
+"PhotosCount": 49
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T21:09:57Z"
+"Stories": "2.0"
+"StreetName": "YARMOUTH"
+"StreetNumber": "644"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5425"
+"VirtualTourURLUnbranded": "https://youtu.be/EjB3iZm_x-k"
+"WaterSource": array:2 [
0 => "Municipal water"
1 => "Unknown"
]
+"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/29850552/644-yarmouth-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R2"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 37.0
+"AboveGradeFinishedArea": 1612
+"BelowGradeFinishedArea": 614
+"OriginalEntryTimestamp": "2026-06-03T23:31:16.94Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1205262"
+"ListOfficeNationalAssociationId": "1473831"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29850552')"
+"ID": "1492205"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25198
+post_id: "1492494"
+post_author: 1
+"ListingKey": "29850354"
+"ListingId": "40830528"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:51Z"
+"RFModificationTimestamp": "2026-06-06T20:47:37Z"
+"ListPrice": 749000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1880.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "610 SOUTH HAVEN Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.5000252
1 => 43.5120868
]
+"Latitude": 43.5120868
+"Longitude": -80.5000252
+"YearBuilt": 2002
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this exceptional home in the highly sought-after Eastridge community! This move-in ready 2-storey detached home offers 3 spacious bedrooms and 3 bathrooms, ideally located within walking distance to schools and close to charming neighbourhood parks. Backing onto Rim Park and the Grand River, this property provides a rare combination of convenience, privacy, and natural beauty. Recently renovated throughout, the home features brand-new waterproof flooring, fresh designer paint, and numerous modern light fixtures that create a bright and contemporary living environment. The main floor living room is enhanced with abundant pot lights, providing excellent illumination and a warm, inviting atmosphere. The kitchen is equipped with a brand-new refrigerator, adding both style and functionality. Upstairs, a separate family room with a cozy fireplace offers an ideal private retreat for family gatherings, entertainment, or relaxation. The spacious primary bedroom features its own ensuite bathroom, creating a comfortable and private sanctuary. Step outside to enjoy the large backyard deck, perfect for outdoor dining, entertaining, or simply unwinding while enjoying the peaceful surroundings. A beautifully updated home in an unbeatable location—don't miss this incredible opportunity! (id:62783)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Dryer"
5 => "Hood Fan"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-03T23:21:53.555716+00:00"
+"Directions": "Shediac"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2073939"
+"ListOfficeKey": "253316"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Paved driveway"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-03T22:50:39Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:23:22Z"
+"Stories": "2.0"
+"StreetName": "SOUTH HAVEN"
+"StreetNumber": "610"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4891"
+"VirtualTourURLUnbranded": "https://youtu.be/EeMRCR1OF9M"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29850354/610-south-haven-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1880
+"OriginalEntryTimestamp": "2026-06-03T22:50:38.81Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Owner"
+"ListAgentNationalAssociationId": "1349103"
+"ListOfficeNationalAssociationId": "1223329"
+"Media": array:31 [
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]
]
+"DaysOnMarket": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29850354')"
+"ID": "1492494"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25192
+post_id: "1482660"
+post_author: 1
+"ListingKey": "29836980"
+"ListingId": "40835649"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-04T22:15:24Z"
+"RFModificationTimestamp": "2026-06-04T22:20:08Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2132.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G1"
+"UnparsedAddress": "529 CHESAPEAKE Crescent, Waterloo, Ontario N2K4G1"
+"Coordinates": array:2 [
0 => -80.5161315
1 => 43.5112898
]
+"Latitude": 43.5112898
+"Longitude": -80.5161315
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 529 Chesapeake Cres! In world full of so close and almost there, welcome to the whole package. This gorgeous home in the heart of Waterloo's most sought after neighborhood, is the definition of a move in ready sanctuary. Nestled into a quiet crescent, close to schools, parks, restaurants and every convenience you could ask for. Complete with a Renovated Kitchen, New Flooring, Updated Bathrooms, Primary Bedroom with huge walk-in closet, Finished basement, Backyard oasis complete with a hot tub, Updated Windows (2021), Attic Insulation (2021) Furnace (2018) Water Heater (2021) Softener (2023) this list just goes on and on. The only thing waiting for an update is new owners to call it home. Call to book your private tour today! (id:62650)"
+"Appliances": array:13 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Satellite Dish"
5 => "Gas stove(s)"
6 => "Range - Gas"
7 => "Dishwasher"
8 => "Stove"
9 => "Dryer"
10 => "Window Coverings"
11 => "Garage door opener"
12 => "Microwave Built-in"
]
+"ArchitecturalStyle": array:1 [
0 => "Contemporary"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-02T00:50:53.067998+00:00"
+"Directions": "Turn onto Chesepeake Dr from Bridge St. Left onto Chesapeake Cres."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1744122"
+"ListOfficeKey": "294048"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:5 [
0 => "Paved driveway"
1 => "Gazebo"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
4 => "Private Yard"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-01T23:39:00Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-04T22:09:42Z"
+"StreetName": "CHESAPEAKE"
+"StreetNumber": "529"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "4672"
+"Utilities": array:3 [
0 => "Natural Gas"
1 => "Electricity"
2 => "Cable"
]
+"VirtualTourURLUnbranded": "https://youriguide.com/529_chesapeake_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": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29836980/529-chesapeake-crescent-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "SD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 32.0
+"AboveGradeFinishedArea": 1530
+"BelowGradeFinishedArea": 602
+"OriginalEntryTimestamp": "2026-06-01T23:39:00.44Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1179780"
+"ListOfficeNationalAssociationId": "1438829"
+"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('29836980')"
+"ID": "1482660"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23345
+post_id: "1469980"
+post_author: 1
+"ListingKey": "29816400"
+"ListingId": "40833026"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T15:31:02Z"
+"RFModificationTimestamp": "2026-06-06T16:39:15Z"
+"ListPrice": 684900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1815.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4E7"
+"UnparsedAddress": "475 ANNAPOLIS Court, Waterloo, Ontario N2K4E7"
+"Coordinates": array:2 [
0 => -80.5094905
1 => 43.5056813
]
+"Latitude": 43.5056813
+"Longitude": -80.5094905
+"YearBuilt": 2000
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 475 Annapolis Crt in the heart of Eastbridge, a thoughtfully updated 3 bedroom, 3 bathroom townhome offering modern comfort and community charm. Tucked away on a quiet, private court in one of Waterloo's most sought-after neighbourhoods, this home is ideal for families seeking privacy, functionality, and an unbeatable location. The main level was refreshed in 2021, featuring an updated kitchen and contemporary finishes throughout, which creates an open and inviting space for everyday living. Upstairs, you'll find three comfortable bedrooms and a full bathroom, and a smart layout designed to meet the demands of busy family life. The fully finished basement extends your living space with a versatile recreation room and a powder room, perfect for a home office, a playroom for the kids, movie nights, or a home gym. Step outside and enjoy a private, treed backyard that offers a level of privacy rarely found in townhouse living, ideal for summer gatherings, a quiet morning coffee, or a place to unwind after a long day. Residents of Eastbridge enjoy the tight-knit, family-centered community and benefit from a short walk to schools, the Eastbridge Green Splash Pad, and a extensive trail network. Conestoga Mall and everyday amenities are just minutes away, with quick access to Hwy 7/8 making commutes across the Waterloo Region effortless. Don't miss your opportunity to own a move-in-ready townhouse in one of Waterloo's most established and welcoming communities. (id:62783)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T18:11:18.206273+00:00"
+"Directions": "CHESAPEAKE DR BRIDGE ST. TO CHESAPEAKE TO ANNAPOLIS"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2074436"
+"ListOfficeKey": "291822"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T12:11:18Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T15:20:26Z"
+"Stories": "2.0"
+"StreetName": "ANNAPOLIS"
+"StreetNumber": "475"
+"StreetSuffix": "Court"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/475_annapolis_ct_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/29816400/475-annapolis-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2066786"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "291822"
+"GeocodeManualYN": true
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 20.0
+"AboveGradeFinishedArea": 1281
+"BelowGradeFinishedArea": 534
+"OriginalEntryTimestamp": "2026-05-28T12:09:32.35Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1349616"
+"ListOfficeNationalAssociationId": "1405037"
+"CoListAgentNationalAssociationId": "1341921"
+"CoListOfficeNationalAssociationId": "1405037"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816400')"
+"ID": "1469980"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25201
+post_id: "1469981"
+post_author: 1
+"ListingKey": "29816681"
+"ListingId": "X13206864"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-03T21:25:18Z"
+"RFModificationTimestamp": "2026-06-03T21:34:42Z"
+"ListPrice": 684900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 2
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4E7"
+"UnparsedAddress": "475 ANNAPOLIS COURT, Waterloo, Ontario N2K4E7"
+"Coordinates": array:2 [
0 => -80.509493
1 => 43.505698
]
+"Latitude": 43.505698
+"Longitude": -80.509493
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 475 Annapolis Crt in the heart of Eastbridge, a thoughtfully updated 3 bedroom, 3 bathroom townhome offering modern comfort and community charm. Tucked away on a quiet, private court in one of Waterloo's most sought-after neighbourhoods, this home is ideal for families seeking privacy, functionality, and an unbeatable location. The main level was refreshed in 2021, featuring an updated kitchen and contemporary finishes throughout, which creates an open and inviting space for everyday living. Upstairs, you'll find three comfortable bedrooms and a full bathroom, and a smart layout designed to meet the demands of busy family life. The fully finished basement extends your living space with a versatile recreation room and a powder room, perfect for a home office, a playroom for the kids, movie nights, or a home gym. Step outside and enjoy a private, treed backyard that offers a level of privacy rarely found in townhouse living, ideal for summer gatherings, a quiet morning coffee, or a place to unwind after a long day. Residents of Eastbridge enjoy the tight-knit, family-centered community and benefit from a short walk to schools, the Eastbridge Green Splash Pad, and a extensive trail network. Conestoga Mall and everyday amenities are just minutes away, with quick access to Hwy 7/8 making commutes across the Waterloo Region effortless. Don't miss your opportunity to own a move-in-ready townhouse in one of Waterloo's most established and welcoming communities. (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 remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-05-28T17:49:09.997119+00:00"
+"Directions": "Cross Streets: CHESAPEAKE DR. ** Directions: CHESAPEAKE DR BRIDGE ST. TO CHESAPEAKE TO ANNAPOLIS."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2243519"
+"ListOfficeKey": "297463"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "19.8 x 116.8 FT ; 19.83 ft x 112.70 ft x19.81 ftx116.75 ft"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T13:18:57Z"
+"PhotosCount": 48
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-03T21:15:24Z"
+"Stories": "2.0"
+"StreetName": "Annapolis"
+"StreetNumber": "475"
+"StreetSuffix": "Court"
+"TaxAnnualAmount": "3809"
+"VirtualTourURLUnbranded": "https://youriguide.com/475_annapolis_ct_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:8 [
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]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29816681/475-annapolis-court-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "2239425"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "297463"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "MD3"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 19.9
+"OriginalEntryTimestamp": "2026-05-28T13:18:57.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1482066"
+"ListOfficeNationalAssociationId": "1470704"
+"CoListAgentNationalAssociationId": "1477385"
+"CoListOfficeNationalAssociationId": "1470704"
+"Media": array:48 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
]
+"DaysOnMarket": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816681')"
+"ID": "1469981"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25202
+post_id: "1468337"
+post_author: 1
+"ListingKey": "29816324"
+"ListingId": "40832166"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-06T20:30:44Z"
+"RFModificationTimestamp": "2026-06-06T20:48:03Z"
+"ListPrice": 1359000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3183.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B5"
+"UnparsedAddress": "828 COPPER RIDGE Drive, Waterloo, Ontario N2K0B5"
+"Coordinates": array:2 [
0 => -80.4934595
1 => 43.5213644
]
+"Latitude": 43.5213644
+"Longitude": -80.4934595
+"YearBuilt": 2013
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover elegant family living in desirable Carriage Crossing. This impeccably maintained home features custom upgrades including 9 ft. ceilings, 8 ft. doors, and crown moulding throughout the main level. It includes a dedicated main-floor office, formal dining area, and a spacious kitchen open to a cozy family room with a gas fireplace. Upstairs, 4 spacious, bright bedrooms, including a primary retreat with 10 ft. tray ceilings and a 5-piece ensuite make this a comfortable space for families to get some R&R. The second-floor laundry is also a convenient added feature. The finished basement, featuring a second fireplace is a cozy spot to hang out and gather with family and friends. This level also includes a bathroom rough-in and plenty of unfinished space for storage or future finishing. Outside, the private, serene backyard features a pool, an outdoor 2-piece washroom, a hot tub, and a gas BBQ hookup. This location offers huge added value for families. Enjoy outstanding parks and trails nearby including a skate and bike park or spend an afternoon in the local library with the kids. RIM Park and Grey Silo Golf Course are just steps away. Experience the perfect blend of sophisticated upgrades, backyard bliss and a winning location in this sought-after neighbourhood. (id:62783)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Hot Tub"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
]
+"ArchitecturalStyle": array:1 [
0 => "2 Level"
]
+"AssociationFeeFrequency": "Monthly"
+"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-05-28T15:02:44.593108+00:00"
+"Directions": "Deerfoot Trail to Copper Ridge"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Electric"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"Heating": array:1 [
0 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2056961"
+"ListOfficeKey": "76840"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"NumberOfUnitsTotal": "1"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-05-28T12:22:00Z"
+"PhotosCount": 50
+"PoolFeatures": array:1 [
0 => "Inground pool"
]
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-06T20:22:47Z"
+"Stories": "2.0"
+"StreetName": "COPPER RIDGE"
+"StreetNumber": "828"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "8671.08"
+"VirtualTourURLUnbranded": "https://youriguide.com/828_copper_ridge_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29816324/828-copper-ridge-drive-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 44.0
+"AboveGradeFinishedArea": 2738
+"BelowGradeFinishedArea": 446
+"OriginalEntryTimestamp": "2026-05-28T11:51:25.43Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1332177"
+"ListOfficeNationalAssociationId": "1004363"
+"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": 9
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29816324')"
+"ID": "1468337"
}
]
+success: true
+page_size: 9
+page_count: 3
+count: 24
+after_key: ""
}
"RF Response Time" => "0.13 seconds"
]
]