array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29964583 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23441
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23443
+post_id: "1574855"
+post_author: 1
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-30T03:45:02Z"
+"RFModificationTimestamp": "2026-06-30T03:49:17Z"
+"ListPrice": 749900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2615.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4M2"
+"UnparsedAddress": "729 GRAND BANKS Drive, Waterloo, Ontario N2K4M2"
+"Coordinates": array:2 [
0 => -80.4982397
1 => 43.5124183
]
+"Latitude": 43.5124183
+"Longitude": -80.4982397
+"YearBuilt": 2003
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home in the highly desirable Eastbridge neighbourhood! Featuring a bright open-concept layout, this well-maintained home offers a grand two-storey foyer, spacious Great Room with maple hardwood flooring, California shutters, and a walkout to the deck with stunning seasonal views of the Grand River. The kitchen boasts abundant cabinetry, a breakfast bar, and updated appliances. Upstairs, the spacious primary bedroom features a walk-in closet, an elegant 9'4 tray ceiling, and a private ensuite. The finished walkout basement provides additional living space, direct access to a large stone patio, and a rough-in for a future bathroom. The fully fenced backyard is perfect for family enjoyment and entertaining. Recent updates include roof (2021), driveway resurfacing (2023), patio and deck improvements (2024), bathroom updates (2025), washer (2022), kitchen appliances (2019), and owned water softener. Ideally located within walking distance to top-rated schools and close to RIM Park, shopping, trails, transit, and the Expressway. A fantastic opportunity to own a move-in-ready home in one of Waterloo's most sought-after family communities! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "School Bus"
1 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T06:20:09.218915+00:00"
+"Directions": "TAKE UNIVERSITY AVE EAST; TURN LEFT ON TO NEW BEDFORD DR; THEN TURN RIGHT ON TO GRAND BANKS DR."
+"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": "1955745"
+"ListOfficeKey": "295659"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Sump Pump"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-30T03:39:21Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-30T03:39:21Z"
+"Stories": "2.0"
+"StreetName": "GRAND BANKS"
+"StreetNumber": "729"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "5946"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1671689606"
"RoomType" => "Utility room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.14Z"
]
1 => array:11 [
"RoomKey" => "1671689607"
"RoomType" => "Cold room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
2 => array:11 [
"RoomKey" => "1671689608"
"RoomType" => "Laundry room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "7'11'' x 12'10''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
3 => array:11 [
"RoomKey" => "1671689609"
"RoomType" => "Recreation room"
"ListingId" => "40843675"
"RoomLevel" => "Basement"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "13'11'' x 23'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
4 => array:11 [
"RoomKey" => "1671689610"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
5 => array:11 [
"RoomKey" => "1671689611"
"RoomType" => "Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "9'4'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
6 => array:11 [
"RoomKey" => "1671689612"
"RoomType" => "Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 14'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
7 => array:11 [
"RoomKey" => "1671689613"
"RoomType" => "4pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.15Z"
]
8 => array:11 [
"RoomKey" => "1671689614"
"RoomType" => "Primary Bedroom"
"ListingId" => "40843675"
"RoomLevel" => "Second level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "14'8'' x 17'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
9 => array:11 [
"RoomKey" => "1671689615"
"RoomType" => "2pc Bathroom"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
10 => array:11 [
"RoomKey" => "1671689616"
"RoomType" => "Kitchen"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "12'3'' x 14'0''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
11 => array:11 [
"RoomKey" => "1671689617"
"RoomType" => "Dining room"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "8'6'' x 11'4''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
12 => array:11 [
"RoomKey" => "1671689618"
"RoomType" => "Great room"
"ListingId" => "40843675"
"RoomLevel" => "Main level"
"RoomWidth" => null
"ListingKey" => "29964583"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 14'9''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-30T03:39:21.16Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964583/729-grand-banks-drive-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "FR"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 30.0
+"AboveGradeFinishedArea": 1825
+"BelowGradeFinishedArea": 790
+"OriginalEntryTimestamp": "2026-06-29T05:59:41.08Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1247419"
+"ListOfficeNationalAssociationId": "1452740"
+"Media": array:38 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29964583_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/2d983f4577119a075d858eaaeb7afa3a.webp"
"MediaSize" => 117065
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-2d983f4577119a075d858eaaeb7afa3a.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-colored siding and a brown shingle roof"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.2Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29964583_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/8158296ffdd392857a8e057793bd6eb4.webp"
"MediaSize" => 126454
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-8158296ffdd392857a8e057793bd6eb4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story home featuring light-colored siding, a prominent front garage with a panel design, and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29964583_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/b035cc6d05ca57a9d6d5b3c4a83ccd6e.webp"
"MediaSize" => 119519
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-b035cc6d05ca57a9d6d5b3c4a83ccd6e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story detached residence featuring light-colored siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.22Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29964583_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c334977cdef17d9d6ccff4d93b3061e2.webp"
"MediaSize" => 74541
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c334977cdef17d9d6ccff4d93b3061e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding, a prominent front gable, and an arched window"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29964583_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/19ea2b14561a92face62f1a6f7fce7ce.webp"
"MediaSize" => 59009
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-19ea2b14561a92face62f1a6f7fce7ce.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary two-story residence with a light-colored facade, featuring an attached two-car garage with a brown door"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.81Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29964583_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/d2539857c00ff1c9f20a30b402db8066.webp"
"MediaSize" => 56936
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-d2539857c00ff1c9f20a30b402db8066.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story residence featuring light-toned siding and brick accents"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29964583_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/e315bd514d854b14d5ad135288368a53.webp"
"MediaSize" => 37762
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-e315bd514d854b14d5ad135288368a53.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Front entry with a dark-paneled door and storm door, accented by dual sconce lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29964583_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/2f595db2c259465988671b745424edbc.webp"
"MediaSize" => 77494
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-2f595db2c259465988671b745424edbc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Image quality insufficient for description"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29964583_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/244092c5b8b79a63e91e27bf1a83437f.webp"
"MediaSize" => 70712
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-244092c5b8b79a63e91e27bf1a83437f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Foyer featuring wood-finish flooring, a white paneled entry door with brushed nickel hardware, and a carpeted staircase with white balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29964583_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/43a8a6ec3fb349820a41023581e149cf.webp"
"MediaSize" => 97695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-43a8a6ec3fb349820a41023581e149cf.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring light wood-finish flooring, a white paneled front door with sidelight window, and a flush-mount ceiling light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29964583_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/f83b56fd134ceb97b6154b581b73bb71.webp"
"MediaSize" => 79997
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-f83b56fd134ceb97b6154b581b73bb71.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entryway featuring a paneled main door with a frosted sidelight, wood-finish flooring, a carpeted staircase with white balusters, and a high ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29964583_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/3ed08ac0be9f871b6ea6b2d410153d1d.webp"
"MediaSize" => 59677
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-3ed08ac0be9f871b6ea6b2d410153d1d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with paneling, a white countertop, a mirror, and a window with wood-finish blinds"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29964583_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/f43cc77c917c3b02176578bdc59fc1f1.webp"
"MediaSize" => 61820
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-f43cc77c917c3b02176578bdc59fc1f1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bright living space featuring natural light from multiple windows with wooden shutters, light wood-finish flooring, and a white ceiling with a flush-mount light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.21Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29964583_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/7555d16acaaed6465fdcc98a367ce21b.webp"
"MediaSize" => 72952
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-7555d16acaaed6465fdcc98a367ce21b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring light wood-finish flooring, multiple windows with wooden louvered shutters, and a prominent built-in ceiling light fixture"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.18Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29964583_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c0e943d3689532f28e1860c3cbae7d5b.webp"
"MediaSize" => 60216
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c0e943d3689532f28e1860c3cbae7d5b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring wood-finish flooring, light-toned walls, and a window with natural wood shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.81Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29964583_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/3d3a4f3a835a637eb797fcb118ffc1b7.webp"
"MediaSize" => 56786
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-3d3a4f3a835a637eb797fcb118ffc1b7.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living area featuring light wood-finish flooring, light-toned walls, a glass-paned door, and a large window with wooden louvered shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29964583_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/d6b3d1786499b1e286aff31ddb3998ed.webp"
"MediaSize" => 52765
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-d6b3d1786499b1e286aff31ddb3998ed.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Interior space featuring light wood-finish flooring and a white ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29964583_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/1e1d1a1137bf91107287648c8ef1b9a3.webp"
"MediaSize" => 70373
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-1e1d1a1137bf91107287648c8ef1b9a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Open-concept living space featuring wood-finish flooring, a dining area with a chandelier, and a kitchen with white cabinetry"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:55.19Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29964583_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c3650e586648a5645b00956258261bde.webp"
"MediaSize" => 46074
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c3650e586648a5645b00956258261bde.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29964583_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/e9fe4838713a6dce23a998b69a3e2fd6.webp"
"MediaSize" => 55842
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-e9fe4838713a6dce23a998b69a3e2fd6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Contemporary kitchen featuring white cabinetry, stainless steel appliances, a breakfast bar island, wood-finish flooring, and a modern black faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29964583_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/7a31d60102f852f6ef0f6ccb87e3c8c1.webp"
"MediaSize" => 61645
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-7a31d60102f852f6ef0f6ccb87e3c8c1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring light wood-finish flooring, white cabinetry, stainless steel appliances, and an eat-at island with a contrasting countertop"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.8Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29964583_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/4f17e1cbd3dd44b9ad23c5c85ef5abd8.webp"
"MediaSize" => 78623
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-4f17e1cbd3dd44b9ad23c5c85ef5abd8.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen counter with light-colored countertop and backsplash"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29964583_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/be0dd11dd6cf8bdca9f39d7f15ee9277.webp"
"MediaSize" => 95983
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-be0dd11dd6cf8bdca9f39d7f15ee9277.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, stainless steel appliances, light-toned countertops, and wood-finish flooring"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29964583_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/b88ebbe4fc3010c808354f8eca63d5bd.webp"
"MediaSize" => 56046
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-b88ebbe4fc3010c808354f8eca63d5bd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Modern kitchen featuring white cabinetry, light wood-finish flooring, stainless steel appliances, a center island with seating, and a sleek black faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.81Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29964583_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c1e024d05fc3921a32819a84dfdda9e2.webp"
"MediaSize" => 51688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c1e024d05fc3921a32819a84dfdda9e2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Dining area featuring wood-finish flooring, light-toned walls, and a window with light-colored drapes"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29964583_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c7eed5dcc9d9275be668a7ee1c914fd9.webp"
"MediaSize" => 52382
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c7eed5dcc9d9275be668a7ee1c914fd9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story foyer featuring an overhead chandelier, transom window, and paneled entry door with sidelights"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.7Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29964583_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c246dd5b154f8a4c1992420f88131e2c.webp"
"MediaSize" => 47127
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c246dd5b154f8a4c1992420f88131e2c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Staircase with white spindles and neutral carpeting, featuring a decorative chandelier, recessed lighting, and a window providing natural light"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.71Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29964583_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/683a749849d44200eef894c8a2e08384.webp"
"MediaSize" => 59392
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-683a749849d44200eef894c8a2e08384.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Two-story foyer featuring an ornate chandelier, white paneled entry door with sidelights, and a carpeted staircase with white balusters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.7Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29964583_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/5160ba5f271744afdf935774db1384a4.webp"
"MediaSize" => 48946
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-5160ba5f271744afdf935774db1384a4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room featuring a distinctive arched window, light-colored walls, and a built-in shelving unit with cabinet storage"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.8Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29964583_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/bf0262225d538e70819fa5326f8d98e3.webp"
"MediaSize" => 50275
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-bf0262225d538e70819fa5326f8d98e3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted room with light yellow walls and a white ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.69Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29964583_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/f62e4db7cb82191d4834d98be62709c6.webp"
"MediaSize" => 84931
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-f62e4db7cb82191d4834d98be62709c6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Room featuring a prominent arched window, light-colored walls, and carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29964583_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/a0d231621c160a1d572ea0464a55ae21.webp"
"MediaSize" => 57249
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-a0d231621c160a1d572ea0464a55ae21.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Cream-colored walls framing a window with operable blinds, wall-to-wall carpeting, and white baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.71Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29964583_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/16a2e1b8eb7c29643f4a99e851e7431d.webp"
"MediaSize" => 75008
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-16a2e1b8eb7c29643f4a99e851e7431d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Neutral-toned walls complement the light-colored carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.7Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29964583_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/224fa24a03499fdbc10b9065252ef4a3.webp"
"MediaSize" => 74399
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-224fa24a03499fdbc10b9065252ef4a3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a white vanity with an integrated sink, a large wall-mounted mirror, and a window with wood plantation shutters"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.7Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29964583_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/c8738982c8546b52571e548460da4aa0.webp"
"MediaSize" => 91773
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-c8738982c8546b52571e548460da4aa0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Bathroom featuring a single vanity with a white countertop and integrated sink, a large wall-mounted mirror, and a wall-mounted light fixture with four sconces"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:56.7Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29964583_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/befa6aef9c8b329d08776872416001af.webp"
"MediaSize" => 156695
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-befa6aef9c8b329d08776872416001af.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "White vanity with shaker-style cabinetry, an integrated rectangular sink, a light-colored countertop, and a chrome faucet"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.7Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29964583_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/f333384f8b609ead9474611a998549e5.webp"
"MediaSize" => 174078
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-f333384f8b609ead9474611a998549e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room with a tray ceiling and a ceiling fan with integrated lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.72Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29964583_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29964583/8dc81e9ac83fe589c51d33696c067bb5.webp"
"MediaSize" => 163087
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29964583/thumbnail-8dc81e9ac83fe589c51d33696c067bb5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Spacious room featuring a tray ceiling, ceiling fan with integrated lighting, and light-toned carpeting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40843675"
"ResourceRecordKey" => "29964583"
"ModificationTimestamp" => "2026-06-30T03:10:58.7Z"
]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964583')"
+"ID": "1574855"
}
]
+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 295659" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24897
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.23 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 1955745" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24855
+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 '29964583'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25250
+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 '29964583'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25263
+items: array:6 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25266
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31717721"
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-29T09:46:05Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31717721')"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25268
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31717722"
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T14:00:00Z"
+"OpenHouseEndTime": "2026-07-04T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-29T09:46:05Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31717722')"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25265
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31717888"
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-29T23:35:21Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31717888')"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25269
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31717889"
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T14:00:00Z"
+"OpenHouseEndTime": "2026-07-04T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-06-29T23:35:21Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31717889')"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25267
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31728334"
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-05"
+"OpenHouseStartTime": "2026-07-05T14:00:00Z"
+"OpenHouseEndTime": "2026-07-05T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-01T03:05:09Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31728334')"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25264
+post_id: ? mixed
+post_author: ? mixed
+"OpenHouseKey": "31728335"
+"ListingKey": "29964583"
+"ListingId": "40843675"
+"OpenHouseStatus": "Active"
+"OpenHouseType": "Open House"
+"OpenHouseDate": "2026-07-04"
+"OpenHouseStartTime": "2026-07-04T14:00:00Z"
+"OpenHouseEndTime": "2026-07-04T16:00:00Z"
+"OpenHouseRemarks": null
+"OriginatingSystemName": "CREA"
+"ModificationTimestamp": "2026-07-01T03:05:09Z"
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/OpenHouse('31728335')"
}
]
+success: true
+page_size: 6
+page_count: 1
+count: 6
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29964583' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.4982397 43.5124183)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25351
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25345
+post_id: "1576427"
+post_author: 1
+"ListingKey": "29964980"
+"ListingId": "X13499606"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:35:17Z"
+"RFModificationTimestamp": "2026-06-29T19:41:06Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT STREET, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.490937
1 => 43.499333
]
+"Latitude": 43.499333
+"Longitude": -80.490937
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property. The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23, AC '22 (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water meter"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Window Coverings"
9 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "N/A"
]
+"BathroomsPartial": 1
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:43:10.232271+00:00"
+"Directions": "Cross Streets: University/Woolwich. ** Directions: University to Colt."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "286883"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "22.9 x 102 FT"
+"ParkingFeatures": array:3 [
0 => "Attached Garage"
1 => "Garage"
2 => "Inside Entry"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:08Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T19:28:30Z"
+"Stories": "2.0"
+"StreetName": "Colt"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"TaxAnnualAmount": "4354"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1671392524"
"RoomType" => "Great room"
"ListingId" => "X13499606"
"RoomLevel" => "Main level"
"RoomWidth" => 3.58
"ListingKey" => "29964980"
"RoomLength" => 5.49
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.75Z"
]
1 => array:11 [
"RoomKey" => "1671392525"
"RoomType" => "Kitchen"
"ListingId" => "X13499606"
"RoomLevel" => "Main level"
"RoomWidth" => 2.57
"ListingKey" => "29964980"
"RoomLength" => 3.43
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.75Z"
]
2 => array:11 [
"RoomKey" => "1671392526"
"RoomType" => "Dining room"
"ListingId" => "X13499606"
"RoomLevel" => "Main level"
"RoomWidth" => 2.69
"ListingKey" => "29964980"
"RoomLength" => 3.02
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.76Z"
]
3 => array:11 [
"RoomKey" => "1671392527"
"RoomType" => "Bedroom"
"ListingId" => "X13499606"
"RoomLevel" => "Second level"
"RoomWidth" => 3.71
"ListingKey" => "29964980"
"RoomLength" => 4.04
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-29T19:28:30.76Z"
]
4 => array:11 [
"RoomKey" => "1671392528"
"RoomType" => "Bedroom 2"
"ListingId" => "X13499606"
"RoomLevel" => "Second level"
"RoomWidth" => 2.69
"ListingKey" => "29964980"
…5
]
5 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29964980/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 22.1
+"OriginalEntryTimestamp": "2026-06-29T13:50:08.26Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1364605"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964980')"
+"ID": "1576427"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25347
+post_id: "1575738"
+post_author: 1
+"ListingKey": "29964993"
+"ListingId": "40839771"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T19:00:07Z"
+"RFModificationTimestamp": "2026-06-29T19:03:37Z"
+"ListPrice": 659000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0.05
+"LivingArea": 1440.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4N9"
+"UnparsedAddress": "488 COLT Street, Waterloo, Ontario N2K4N9"
+"Coordinates": array:2 [
0 => -80.4908096
1 => 43.4991897
]
+"Latitude": 43.4991897
+"Longitude": -80.4908096
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Bright, impeccably maintained freehold townhouse nestled in Waterloo's highly desirable Lexington neighbourhood. Designed for modern living, the open-concept main floor offers a spacious kitchen complete with stainless steel appliances, a well-appointed dining area, and an inviting great room that seamlessly connects to the outdoors. Step out to the expansive deck, perfect for summer entertaining, morning coffee, or simply relaxing in your private backyard setting, backing onto only one neighbouring property.The carpet-free main floor adds both style and practicality. Upstairs, you'll find three generously sized bedrooms, two full bathrooms, and the convenience of second-floor laundry. Ideally located close to shopping, schools, parks, public transit, and everyday amenities, this move-in-ready home offers the perfect blend of comfort, privacy, and convenience. Some photos virtually staged. Roof '23 AC ' 22 (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Window Coverings"
7 => "Garage door opener"
8 => "Microwave Built-in"
]
+"Basement": array:2 [
0 => "Unfinished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-29T14:32:02.394661+00:00"
+"Directions": "University to Colt"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1982520"
+"ListOfficeKey": "294000"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Sump Pump"
]
+"LotSizeDimensions": "0.05"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T13:50:41Z"
+"PhotosCount": 31
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T18:51:28Z"
+"Stories": "2.0"
+"StreetName": "COLT"
+"StreetNumber": "488"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4354"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:10 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29964993/488-colt-street-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 23.0
+"AboveGradeFinishedArea": 1440
+"OriginalEntryTimestamp": "2026-06-29T13:50:41.6Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1267654"
+"ListOfficeNationalAssociationId": "1434122"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29964993')"
+"ID": "1575738"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25344
+post_id: "1574152"
+post_author: 1
+"ListingKey": "29963525"
+"ListingId": "40843481"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T00:30:35Z"
+"RFModificationTimestamp": "2026-06-28T01:33:44Z"
+"ListPrice": 354990.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 582.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0G5"
+"UnparsedAddress": "255 NORTHFIELD Drive Unit# 308, Waterloo, Ontario N2K0G5"
+"Coordinates": array:2 [
0 => -80.5213765
1 => 43.5107332
]
+"Latitude": 43.5107332
+"Longitude": -80.5213765
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this stunning 1-bedroom plus den, 1-bath condo offering the perfect blend of style, comfort, and low-maintenance living in one of the area's most sought-after neighbourhoods. This beautifully appointed unit features high-end finishes, abundant natural light, a primary bedroom complete with a walk-in closet and ensuite access, convenient in-suite laundry, one underground parking space, and a private locker. The versatile den is ideal for a home office. Enjoy an impressive selection of building amenities, including a fitness centre, event room, rooftop terrace with BBQ area and beautiful views, bike storage, and even a dog washing station. The well-maintained building also offers keyless entry. Perfectly situated just minutes from restaurants, shopping, theatres, the community centre, and the renowned St. Jacobs Farmers' Market. Outdoor enthusiasts will appreciate the nearby Walter Bean Trail, Grand River, RIM Park, and Grey Silo Golf Course. Conveniently located close to two universities with quick access to Highways 85 and 401, making commuting a breeze. This exceptional condo truly has it all—don't miss your opportunity to make it yours. Book your private showing today! (id:62650)"
+"Appliances": array:7 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Window Coverings"
6 => "Garage door opener"
]
+"AssociationFee": "493"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-28T01:33:38.248335+00:00"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564233"
+"ListOfficeKey": "283125"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:3 [
0 => "Conservation/green belt"
1 => "Balcony"
2 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:2 [
0 => "Underground"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-28T00:20:47Z"
+"PhotosCount": 50
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T00:20:47Z"
+"Stories": "3.0"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "3137.65"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29963525/255-northfield-drive-unit-308-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"ZoningDescription": "MXC"
+"BedroomsAboveGrade": 1
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 582
+"OriginalEntryTimestamp": "2026-06-28T00:20:47.64Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1070035"
+"ListOfficeNationalAssociationId": "1324759"
+"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": 3
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29963525')"
+"ID": "1574152"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25348
+post_id: "1572262"
+post_author: 1
+"ListingKey": "29961016"
+"ListingId": "40843507"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-27T20:25:21Z"
+"RFModificationTimestamp": "2026-06-27T20:29:58Z"
+"ListPrice": 1630000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 4544.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3H9"
+"UnparsedAddress": "250 GREY SQUIRREL Place, Waterloo, Ontario N2K3H9"
+"Coordinates": array:2 [
0 => -80.5202288
1 => 43.5085201
]
+"Latitude": 43.5085201
+"Longitude": -80.5202288
+"YearBuilt": 1988
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Discover exceptional family living at 250 Grey Squirrel Place, a beautifully maintained home nestled on a quiet crescent in Waterloo's sought-after Colonial Acres. Situated on a rare double-sized lot, this impressive property offers an outstanding blend of space, comfort, and privacy in one of the city's most established neighbourhoods. Step inside to an inviting interior highlighted by soaring 14-foot ceilings in the front living room, rich hardwood flooring, and a charming wood-burning fireplace. A second fireplace anchors the spacious family room, providing the perfect setting for relaxed evenings, while a dedicated main-floor office offers a quiet space for working from home. Everyday convenience is enhanced by the functional mudroom and laundry area with direct access from the double-car garage. At the heart of the home, the well-appointed kitchen features granite countertops, a Bosch stove, Miele appliances, and a walkout to the newly completed tiered wood deck (2025). The expansive backyard is a true standout, offering a sports court, mature landscaping, Honeycrisp apple trees, a peach tree, and ample room for entertaining, gardening, or family recreation. The upper level features four spacious bedrooms, including a private primary retreat with its own ensuite bath, as well as a second full bathroom to accommodate family and guests. The fully finished basement adds incredible versatility with two additional bedrooms, a three-piece bathroom, and a large recreation area ideal for movie nights, games, or multi-generational living. Surrounded by mature trees and enhanced by an interlock driveway, this home delivers both curb appeal and lasting quality. Ideally positioned just minutes from Uptown Waterloo, the University of Waterloo, Waterloo Park, RIM Park, Grey Silo Golf Course, and The Boardwalk, this exceptional property offers the perfect balance of peaceful family living and convenient access to the region's top amenities. (id:62650)"
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Hood Fan"
8 => "Garage door opener"
]
+"AssociationFeeFrequency": "Monthly"
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-26T22:36:56.385277+00:00"
+"Directions": "Deer Run Dr to Grey Squirrel Pl"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceFeatures": array:2 [
0 => "Wood"
1 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2152269"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-26T21:50:05Z"
+"PhotosCount": 36
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-27T20:19:50Z"
+"Stories": "2.0"
+"StreetName": "GREY SQUIRREL"
+"StreetNumber": "250"
+"StreetSuffix": "Place"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "9353.85"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:22 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
21 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29961016/250-grey-squirrel-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"SecurityFeatures": array:1 [
0 => "Alarm system"
]
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 114.0
+"AboveGradeFinishedArea": 2883
+"BelowGradeFinishedArea": 1661
+"OriginalEntryTimestamp": "2026-06-26T21:50:05.68Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1403932"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:36 [
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]
]
+"DaysOnMarket": 4
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29961016')"
+"ID": "1572262"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25346
+post_id: "1557351"
+post_author: 1
+"ListingKey": "29941712"
+"ListingId": "40842211"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-28T20:20:22Z"
+"RFModificationTimestamp": "2026-06-28T20:25:14Z"
+"ListPrice": 1199900.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 2
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 3520.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K3J1"
+"UnparsedAddress": "391 TIMLOCK Place, Waterloo, Ontario N2K3J1"
+"Coordinates": array:2 [
0 => -80.5005194
1 => 43.4981893
]
+"Latitude": 43.4981893
+"Longitude": -80.5005194
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this beautiful family home tucked away on a quiet court in Waterloo's sought-after Lexington neighbourhood. Surrounded by mature trees, parks, trails, schools and a strong sense of community, this is the kind of neighbourhood where families put down roots and stay for years. Offering generous above-grade living space plus a finished basement, this 4-bedroom, 4-bathroom home blends comfort, functionality and timeless style. Freshly painted in neutral tones with recent basement updates, it has been well maintained with a new roof (2020), furnace (2014), air conditioner (2026) 200 AMP service and many updated windows. The spacious kitchen is the heart of the home, with plenty of room for family and friends to gather. Multiple living areas on the main floor provide flexibility for everyday living and entertaining, including a welcoming family room, dining room and separate sitting room. Main floor laundry adds convenience. Upstairs, four generous bedrooms include a relaxing primary retreat with a beautifully updated ensuite bath. The finished basement adds valuable living space with a large recreation and games area, perfect for movie nights, gaming, ping pong, board games or simply spending time together. A separate bonus room works equally well as a home office, fitness room, guest space or hobby room. A two-piece bathroom and ample storage complete the lower level. Outside, the large private backyard offers plenty of room for children and pets to play, gardens to grow, or future outdoor living plans. A double garage and parking for four vehicles provide plenty of room for family and guests. Located minutes from Rim Park, recreation facilities, transit, shopping and everyday amenities, this home offers the perfect balance of peaceful suburban living and convenient city access. Beautifully maintained, thoughtfully updated and ideally located, this is a rare opportunity to own a home in one of Waterloo's most desirable family neighbourhoods. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Gas stove(s)"
5 => "Dishwasher"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 2
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-23T17:50:07.259543+00:00"
+"Directions": "Bridge to Dansbury to Forestlawn to Timlock Pl"
+"ExteriorFeatures": array:2 [
0 => "Aluminum siding"
1 => "Brick Veneer"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1830254"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Cul-de-sac"
1 => "Paved driveway"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-24T21:22:31Z"
+"PhotosCount": 47
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-28T20:11:05Z"
+"Stories": "2.0"
+"StreetName": "TIMLOCK"
+"StreetNumber": "391"
+"StreetSuffix": "Place"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "7963.37"
+"VirtualTourURLUnbranded": "https://youriguide.com/391_timlock_pl_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:17 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29941712/391-timlock-place-waterloo"
+"ParkingTotal": 6
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR2"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 2400
+"BelowGradeFinishedArea": 1120
+"OriginalEntryTimestamp": "2026-06-23T16:11:30.38Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1195645"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:47 [
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]
]
+"DaysOnMarket": 7
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29941712')"
+"ID": "1557351"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25341
+post_id: "1549420"
+post_author: 1
+"ListingKey": "29930600"
+"ListingId": "X13468586"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T22:00:14Z"
+"RFModificationTimestamp": "2026-06-29T22:03:04Z"
+"ListPrice": 1600000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B4"
+"UnparsedAddress": "325 DEERFOOT TRAIL, Waterloo, Ontario N2K0B4"
+"Coordinates": array:2 [
0 => -80.492293
1 => 43.520642
]
+"Latitude": 43.520642
+"Longitude": -80.492293
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "This is your Carriage Crossing dream home. Welcome to 325 Deerfoot Trail, located in one of Waterloo's most sought-after communities. This custom Klondike-built home offers 5,300+ SF of beautifully finished living space, with 4+1 bedrms & 4 bathrms, thoughtfully designed with quality craftsmanship, timeless finishes, & functional family living. Step inside the grand entry opening to formal living & dining rms with coffered ceilings & detailed millwork. The home is anchored by a stunning 2-storey great rm with gas fireplace & oversized windows flooding the space with natural light. The well-appointed Chervin kitchen features a lrg centre island, granite counters, premium appliances, under-cabinet lighting, backsplash, & a bright breakfast area with walkout to the backyard & covered back porch. The main flr also offers a private office/potential 6th bedrm, mudrm/laundry rm, & powder rm. Upstairs offers 4 spacious bedrms, including an expansive primary retreat with tray ceiling, feature wall with linear electric fireplace, sitting area, walk-in closet with built-ins, additional dual closets, & a 5-pce ensuite with dual vanities, tiled glass shower, & jacuzzi tub. 3 additional sizable bedrms & a 5-pce main bathrm complete the upper level. The fully finished lower level features a lrg rec rm with electric fireplace, additional bedrm, 3-pce bathrm, wet bar (in-law potential), & ample storage. Hardwood & natural stone flring, custom ceiling treatments, crown moulding, curated millwork, & custom window coverings throughout. Set on a professionally landscaped lot with interlocking driveway, covered back porch, expansive patio, & fully fenced private backyard with mature trees, hardscaping, & perennial gardens. Located just mins to top-rated schools, U of W & Wilfrid Laurier University, RIM Park, Grey Silo Golf Club, trails, St. Jacobs Market, & major commuter routes. *Some images have been virtually staged. (id:62650)"
+"Appliances": array:12 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Microwave"
8 => "Hood Fan"
9 => "Window Coverings"
10 => "Garage door opener"
11 => "Garage door opener remote(s)"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T21:11:46.156494+00:00"
+"Directions": "Cross Streets: OAK PARK DRIVE. ** Directions: MILLENNIUM BLVD TO OAK PARK DRIVE, THEN DEERFOOT TRAIL."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2103799"
+"ListOfficeKey": "290246"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Conservation/green belt"
1 => "Sump Pump"
]
+"LotSizeDimensions": "59.1 x 108.4 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T21:12:20Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T21:53:08Z"
+"Stories": "2.0"
+"StreetName": "Deerfoot"
+"StreetNumber": "325"
+"StreetSuffix": "Trail"
+"TaxAnnualAmount": "12084.9"
+"VirtualTourURLUnbranded": "https://youriguide.com/325_deerfoot_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29930600/325-deerfoot-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 5000
+"LivingAreaMinimum": 3500
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 59.1
+"OriginalEntryTimestamp": "2026-06-19T19:55:19.86Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1373322"
+"ListOfficeNationalAssociationId": "1385020"
+"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": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930600')"
+"ID": "1549420"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23455
+post_id: "1548926"
+post_author: 1
+"ListingKey": "29930068"
+"ListingId": "40841146"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T21:20:03Z"
+"RFModificationTimestamp": "2026-06-29T21:24:52Z"
+"ListPrice": 1600000.0
+"BathroomsTotalInteger": 4.0
+"BathroomsHalf": 1
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 5333.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0B4"
+"UnparsedAddress": "325 DEERFOOT Trail, Waterloo, Ontario N2K0B4"
+"Coordinates": array:2 [
0 => -80.4922223
1 => 43.5206371
]
+"Latitude": 43.5206371
+"Longitude": -80.4922223
+"YearBuilt": 2014
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "This is your Carriage Crossing dream home. Welcome to 325 Deerfoot Trail, located in one of Waterloo’s most sought-after communities. This custom Klondike-built home offers 5,300+ SF of beautifully finished living space, with 4+1 bedrms & 4 bathrms, thoughtfully designed with quality craftsmanship, timeless finishes, & functional family living. Step inside the grand entry opening to formal living & dining rms with coffered ceilings & detailed millwork. The home is anchored by a stunning 2-storey great rm with gas fireplace & oversized windows flooding the space with natural light. The well-appointed Chervin kitchen features a lrg centre island, granite counters, premium appliances, under-cabinet lighting, backsplash, & a bright breakfast area with walkout to the backyard & covered back porch. The main flr also offers a private office/potential 6th bedrm, mudrm/laundry rm, & powder rm. Upstairs offers 4 spacious bedrms, including an expansive primary retreat with tray ceiling, feature wall with linear electric fireplace, sitting area, walk-in closet with built-ins, additional dual closets, & a 5-pce ensuite with dual vanities, tiled glass shower, & jacuzzi tub. 3 additional sizable bedrms & a 5-pce main bathrm complete the upper level. The fully finished lower level features a lrg rec rm with electric fireplace, additional bedrm, 3-pce bathrm, wet bar (in-law potential), & ample storage. Hardwood & natural stone flring, custom ceiling treatments, crown moulding, curated millwork, & custom window coverings throughout. Set on a professionally landscaped lot with interlocking driveway, covered back porch, expansive patio, & fully fenced private backyard with mature trees, hardscaping, & perennial gardens. Located just mins to top-rated schools, U of W & Wilfrid Laurier University, RIM Park, Grey Silo Golf Club, trails, St. Jacobs Market, & major commuter routes. *Some images have been virtually staged. (id:62650)"
+"Appliances": array:11 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water purifier"
3 => "Water softener"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Hood Fan"
8 => "Window Coverings"
9 => "Garage door opener"
10 => "Microwave Built-in"
]
+"AssociationFeeIncludes": array:2 [
0 => "Landscaping"
1 => "Other, See Remarks"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-19T20:31:37.100088+00:00"
+"Directions": "MILLENNIUM BLVD TO OAK PARK DRIVE, THEN DEERFOOT TRAIL."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stucco"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceFeatures": array:3 [
0 => "Electric"
1 => "Other - See remarks"
2 => "Other - See remarks"
]
+"FireplaceYN": true
+"FireplacesTotal": "3"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1932106"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Southern exposure"
1 => "Conservation/green belt"
2 => "Sump Pump"
3 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-29T21:01:09Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T21:11:05Z"
+"Stories": "2.0"
+"StreetName": "DEERFOOT"
+"StreetNumber": "325"
+"StreetSuffix": "Trail"
+"SubdivisionName": "118 - Colonial Acres/East Bridge"
+"TaxAnnualAmount": "12084.9"
+"VirtualTourURLUnbranded": "https://youriguide.com/325_deerfoot_trail_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:21 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
15 => array:11 [ …11]
16 => array:11 [ …11]
17 => array:11 [ …11]
18 => array:11 [ …11]
19 => array:11 [ …11]
20 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29930068/325-deerfoot-trail-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "1975048"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "76789"
+"GeocodeManualYN": true
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 59.0
+"AboveGradeFinishedArea": 3685
+"BelowGradeFinishedArea": 1648
+"OriginalEntryTimestamp": "2026-06-19T18:50:50.59Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1232419"
+"ListOfficeNationalAssociationId": "1384313"
+"CoListAgentNationalAssociationId": "1261853"
+"CoListOfficeNationalAssociationId": "1004357"
+"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": 11
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29930068')"
+"ID": "1548926"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25349
+post_id: "1538217"
+post_author: 1
+"ListingKey": "29914406"
+"ListingId": "X13454334"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T16:35:07Z"
+"RFModificationTimestamp": "2026-06-29T16:47:50Z"
+"ListPrice": 399000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 2.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K0H2"
+"UnparsedAddress": "405 - 243 NORTHFIELD DRIVE E, Waterloo, Ontario N2K0G9"
+"Coordinates": array:2 [
0 => -80.522255
1 => 43.509258
]
+"Latitude": 43.509258
+"Longitude": -80.522255
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to Blackstone Condominiums in Waterloo! This modern, carpet-free 2-bedroom, 2-bathroom suite offers stylish finishes throughout, including custom cabinetry, quartz countertops, backsplash, in-suite laundry, and a spacious storage room. Enjoy exceptional building amenities including a fitness centre, co-working lounge, party room, rooftop terrace, bike storage, pet wash station, and landscaped outdoor spaces. High-speed internet is included in the condo fees. Conveniently located steps from Brown's Socialhouse, shopping, restaurants, and transit, with easy access to Conestoga Mall, ION LRT, RIM Park, Grey Silo Golf Club, St. Jacobs, universities, and colleges. A fantastic opportunity to own in one of Waterloo's most desirable communities. (id:62650)"
+"Appliances": array:6 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Microwave"
5 => "Hood Fan"
]
+"AssociationFee": "633"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Common Area Maintenance"
1 => "Heat"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:1 [
0 => "None"
]
+"CommunityFeatures": array:1 [
0 => "Pets Allowed With Restrictions"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-17T13:47:22.400606+00:00"
+"Directions": "Cross Streets: Northfield/bridge st w. ** Directions: on northfield dr e."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Stone"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2249954"
+"ListOfficeKey": "292962"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:4 [
0 => "Elevator"
1 => "Balcony"
2 => "Carpet Free"
3 => "In suite Laundry"
]
+"ParkingFeatures": array:1 [
0 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T12:16:42Z"
+"PhotosCount": 49
+"PropertyAttachedYN": true
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T16:29:14Z"
+"StreetDirSuffix": "East"
+"StreetName": "Northfield"
+"StreetNumber": "243"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3685"
+"VirtualTourURLUnbranded": "https://unbranded.youriguide.com/405_243_northfield_dr_e_waterloo_on"
+"Rooms": array:5 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2025
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29914406/405-243-northfield-drive-e-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Apartment"
]
+"CommonInterest": "Condo/Strata"
+"AssociationName": "Five Rivers Property Mgmt"
+"GeocodeManualYN": false
+"BuildingFeatures": array:2 [
0 => "Exercise Centre"
1 => "Party Room"
]
+"LivingAreaMaximum": 899
+"LivingAreaMinimum": 800
+"BedroomsAboveGrade": 2
+"OriginalEntryTimestamp": "2026-06-17T12:16:42.75Z"
+"ListAgentNationalAssociationId": "1488846"
+"ListOfficeNationalAssociationId": "1420223"
+"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": 13
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29914406')"
+"ID": "1538217"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25350
+post_id: "1530988"
+post_author: 1
+"ListingKey": "29903648"
+"ListingId": "40839800"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-29T14:30:06Z"
+"RFModificationTimestamp": "2026-06-29T14:43:31Z"
+"ListPrice": 735000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 2287.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2K4G8"
+"UnparsedAddress": "460 WOOLWICH Street Unit# 24, Waterloo, Ontario N2K4G8"
+"Coordinates": array:2 [
0 => -80.4939516
1 => 43.5014803
]
+"Latitude": 43.5014803
+"Longitude": -80.4939516
+"YearBuilt": 2001
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome home to Riverstone Estates. Beautiful bright 3 bedroom, 3 bathroom multi level townhome located in highly desirable East Waterloo. Main floor has large open concept living/dining/kitchen area. Second floor features 2 bedrooms + 4 pc bath. Master suite located on upper level with full ensuite and walk in closet. Living room features a gas fireplace. All appliances included. Lower level finished, with full walkout basement and access to single garage. Patio door walk out from dining room to private deck area. Parking for 2 cars. Prime location to Walter Bean Trail, the Grand River, Kiwanis Park, Grey Silo Golf Course, Rim Park and expressway. Ample Visitor parking in front of unit. Seller can be flexible on closing. Low Condo Fee. Come Check out. (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"
]
+"AssociationFee": "235"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:4 [
0 => "Landscaping"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"BathroomsPartial": 1
+"CommunityFeatures": array:1 [
0 => "Quiet Area"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-15T19:21:53.555087+00:00"
+"Directions": "Off Woolwich"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stone"
2 => "Vinyl siding"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564596"
+"ListOfficeKey": "76831"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Automatic Garage Door Opener"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:31:12Z"
+"PhotosCount": 45
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-29T14:20:37Z"
+"Stories": "2.0"
+"StreetName": "WOOLWICH"
+"StreetNumber": "460"
+"StreetSuffix": "Street"
+"SubdivisionName": "120 - Lexington/Lincoln Village"
+"TaxAnnualAmount": "4712.14"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:11 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29903648/460-woolwich-street-unit-24-waterloo"
+"ParkingTotal": 2
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CoListAgentKey": "1950017"
+"CommonInterest": "Condo/Strata"
+"CoListOfficeKey": "299554"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 2287
+"OriginalEntryTimestamp": "2026-06-15T15:31:11.85Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1095797"
+"ListOfficeNationalAssociationId": "1004391"
+"CoListAgentNationalAssociationId": "1244287"
+"CoListOfficeNationalAssociationId": "1473831"
+"Media": array:45 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
]
+"DaysOnMarket": 15
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29903648')"
+"ID": "1530988"
}
]
+success: true
+page_size: 9
+page_count: 6
+count: 48
+after_key: ""
}
"RF Response Time" => "0.21 seconds"
]
]