array:6 [
"RF Query: /Property?$select=ALL&$top=20&$filter=ListingKey eq 29875697 AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#23362
+items: array:1 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23364
+post_id: "1510670"
+post_author: 1
+"ListingKey": "29875697"
+"ListingId": "40835793"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T20:30:08Z"
+"RFModificationTimestamp": "2026-06-17T20:47:59Z"
+"ListPrice": 389000.0
+"BathroomsTotalInteger": 1.0
+"BathroomsHalf": 0
+"BedroomsTotal": 1.0
+"LotSizeArea": 0
+"LivingArea": 690.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L0A6"
+"UnparsedAddress": "410 NORTHFIELD Drive W Unit# D13, Waterloo, Ontario N2L0A6"
+"Coordinates": array:2 [
0 => -80.5658478
1 => 43.4905539
]
+"Latitude": 43.4905539
+"Longitude": -80.5658478
+"YearBuilt": 2025
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to Arbour Park in North Waterloo. This brand new Hazel model stacked townhome offers 690 sq. ft. of modern living with one bedroom plus den, a four-piece bathroom, open-concept layout, stylish kitchen with stainless steel appliances, in-suite laundry, and a walk-out patio. This unit also includes 1 parking spot. An excellent opportunity for investors, the property is currently tenanted with a quality tenant paying $1,850/month plus utilities, with the first year of the lease agreement running through September 30th, providing immediate rental income and stability. Ideally located beside Laurel Creek Conservation Area with quick access to Hwy 85, the 401, parks, schools, shopping, and dining. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
]
+"AssociationFee": "202.5"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Property Management"
2 => "Insurance"
3 => "Parking"
4 => "Residential Manager"
]
+"Basement": array:1 [
0 => "None"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-09T17:05:40.655318+00:00"
+"Directions": "WESTMOUNT RD/WEBER ST N"
+"ExteriorFeatures": array:3 [
0 => "Brick"
1 => "Stucco"
2 => "Other"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:3 [
0 => "Heat Pump"
1 => "Forced air"
2 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2239753"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Balcony"
1 => "Paved driveway"
]
+"ParkingFeatures": array:2 [
0 => "Open"
1 => "Visitor Parking"
]
+"PhotosChangeTimestamp": "2026-06-09T15:21:12Z"
+"PhotosCount": 14
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T20:21:58Z"
+"StreetDirSuffix": "West"
+"StreetName": "NORTHFIELD"
+"StreetNumber": "410"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "1"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:6 [
0 => array:11 [
"RoomKey" => "1661455191"
"RoomType" => "Laundry room"
"ListingId" => "40835793"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29875697"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:21:58.82Z"
]
1 => array:11 [
"RoomKey" => "1661455192"
"RoomType" => "Den"
"ListingId" => "40835793"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29875697"
"RoomLength" => null
"RoomDimensions" => "6'0'' x 8'3''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:21:58.82Z"
]
2 => array:11 [
"RoomKey" => "1661455193"
"RoomType" => "Primary Bedroom"
"ListingId" => "40835793"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29875697"
"RoomLength" => null
"RoomDimensions" => "10'4'' x 8'7''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:21:58.82Z"
]
3 => array:11 [
"RoomKey" => "1661455194"
"RoomType" => "4pc Bathroom"
"ListingId" => "40835793"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29875697"
"RoomLength" => null
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:21:58.82Z"
]
4 => array:11 [
"RoomKey" => "1661455195"
"RoomType" => "Kitchen"
"ListingId" => "40835793"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29875697"
"RoomLength" => null
"RoomDimensions" => "10'0'' x 12'2''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:21:58.82Z"
]
5 => array:11 [
"RoomKey" => "1661455196"
"RoomType" => "Living room/Dining room"
"ListingId" => "40835793"
"RoomLevel" => "Lower level"
"RoomWidth" => null
"ListingKey" => "29875697"
"RoomLength" => null
"RoomDimensions" => "14'9'' x 12'6''"
"RoomDescription" => null
"RoomLengthWidthUnits" => null
"ModificationTimestamp" => "2026-06-17T20:21:58.82Z"
]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29875697/410-northfield-drive-w-unit-d13-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "R8"
+"BedroomsAboveGrade": 0
+"BedroomsBelowGrade": 1
+"AboveGradeFinishedArea": 690
+"OriginalEntryTimestamp": "2026-06-09T15:21:12.68Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Builder"
+"ListAgentNationalAssociationId": "1477702"
+"ListOfficeNationalAssociationId": "1378680"
+"Media": array:14 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29875697_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/b2a812314443885529af8e3f8a2008dc.webp"
"MediaSize" => 101960
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-b2a812314443885529af8e3f8a2008dc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => true
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29875697_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/833ab0df30c6208c6eeec38843f147b4.webp"
"MediaSize" => 48539
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-833ab0df30c6208c6eeec38843f147b4.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Carpeted bedroom with baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29875697_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/18d458aaf43abfa3dad41a6eea5c6b83.webp"
"MediaSize" => 52941
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-18d458aaf43abfa3dad41a6eea5c6b83.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Living room featuring wood finished floors, recessed lighting, and a raised ceiling"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29875697_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/374e40dd27df7910775698ee606bba47.webp"
"MediaSize" => 42165
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-374e40dd27df7910775698ee606bba47.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Home office featuring light colored carpet and baseboards"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29875697_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/e48ec487541c2c4cff583939a533e1d3.webp"
"MediaSize" => 23630
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-e48ec487541c2c4cff583939a533e1d3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Corridor featuring electric panel and light tile patterned floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29875697_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/b8093c92f68e68a7db7e2ebdc02ba186.webp"
"MediaSize" => 53041
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-b8093c92f68e68a7db7e2ebdc02ba186.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, white cabinets, a center island with sink, and dark wood finished floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29875697_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/eb06ecfd51856fb517af55b9c09205e5.webp"
"MediaSize" => 57139
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-eb06ecfd51856fb517af55b9c09205e5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Kitchen featuring appliances with stainless steel finishes, white cabinetry, dark wood finished floors, and recessed lighting"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29875697_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/b1a4fb9e7b8867ec12c3ada91f05fa3b.webp"
"MediaSize" => 39672
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-b1a4fb9e7b8867ec12c3ada91f05fa3b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Full bath with shower / bathtub combination, vanity, and dark wood-style floors"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29875697_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/81058be7aeed8207fd8f1c64c3027755.webp"
"MediaSize" => 55933
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-81058be7aeed8207fd8f1c64c3027755.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Washroom with dark wood-style flooring, electric water heater, and estacked washer and dryer"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29875697_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/2e1cd031c6c80b6f8c01244ddd761207.webp"
"MediaSize" => 77096
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-2e1cd031c6c80b6f8c01244ddd761207.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "Entrance to property"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29875697_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/21b213c15c6d48f238afd0c0140f76cc.webp"
"MediaSize" => 90919
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-21b213c15c6d48f238afd0c0140f76cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of patio / terrace"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29875697_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/a915cf593f50d7f1d3cf962e26d1f612.webp"
"MediaSize" => 82134
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-a915cf593f50d7f1d3cf962e26d1f612.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of front of home"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29875697_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/206186e21284053d76ab70ba00f28e3d.webp"
"MediaSize" => 98528
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-206186e21284053d76ab70ba00f28e3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of building exterior"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29875697_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29875697/148b8262dfba65df841dba8a1feae71c.webp"
"MediaSize" => 36514
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29875697/thumbnail-148b8262dfba65df841dba8a1feae71c.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => "View of room layout"
"PreferredPhotoYN" => false
"ResourceRecordId" => "40835793"
"ResourceRecordKey" => "29875697"
"ModificationTimestamp" => "2026-06-09T15:21:12.69Z"
]
]
+"DaysOnMarket": 8
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29875697')"
+"ID": "1510670"
}
]
+success: true
+page_size: 1
+page_count: 1
+count: 1
+after_key: ""
}
"RF Response Time" => "0.16 seconds"
]
"RF Query: /Office?$select=ALL&$top=10&$filter=OfficeMlsId eq 289541" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24724
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.11 seconds"
]
"RF Query: /Member?$select=ALL&$top=10&$filter=MemberMlsId eq 2239753" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#24809
+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 '29875697'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25100
+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 '29875697'" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25116
+items: []
+success: true
+page_size: 0
+page_count: 0
+count: 0
+after_key: ""
}
"RF Response Time" => "0.1 seconds"
]
"RF Query: /Property?$select=ALL&$orderby=CreationDate DESC&$top=9&$filter=ListingKey ne '29875697' AND (PropertyType ne 'Residential Lease' AND PropertyType ne 'Commercial Lease' AND PropertyType ne 'Rental') AND PropertyType eq 'Residential' AND geo.distance(Coordinates, POINT(-80.5658478 43.4905539)) le 2000m AND InternetEntireListingDisplayYN eq true&$expand=Media&$count=true" => array:2 [
"RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#25190
+items: array:9 [
0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25184
+post_id: "1541891"
+post_author: 1
+"ListingKey": "29919897"
+"ListingId": "X13459364"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-18T02:10:15Z"
+"RFModificationTimestamp": "2026-06-18T02:20:23Z"
+"ListPrice": 929900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4V8"
+"UnparsedAddress": "535 SPRUCEHILL AVENUE, Waterloo, Ontario N2L4V8"
+"Coordinates": array:2 [
0 => -80.5485904
1 => 43.4901956
]
+"Latitude": 43.4901956
+"Longitude": -80.5485904
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "OnePoint Association of REALTORS®"
+"PublicRemarks": "Set well back from the road on a large, private lot in a fantastic neighbourhood, this charming two-storey Cape Cod style home boasts exceptional curb appeal and a peaceful setting. Inside, you will find over 3,000 square feet of finished living space that blends timeless character with thoughtful modern updates. The tastefully updated kitchen perfectly balances style and functionality, featuring quartz countertops, stainless steel appliances, a breakfast bar, and a bright dining area ideal for everyday living. The spacious living room provides a warm and welcoming setting to relax, while the adjoining formal dining space is enhanced by picturesque views of the backyard, creating a beautiful backdrop for entertaining and family gatherings. A full bathroom and convenient access to the backyard complete the main level. Step outside to discover a truly spectacular outdoor retreat. The private, fully fenced backyard is surrounded by mature trees, creating a serene and secluded atmosphere. The large deck offers ample space for dining and relaxing, and comes complete with gas BBQ hookup. You will also find a storage shed (with electricity)! Upstairs, you'll find three generously sized and beautifully appointed bedrooms, two of which include their own dedicated den or sitting areas-perfect for a home office, reading nook, or play space! The recently renovated bathroom provides a spa-like atmosphere with its tranquil design and modern finishes. The fully finished basement adds even more versatile living space, highlighted by a cozy wood-burning fireplace and two spacious areas that can easily serve as a recreation room, home office, fitness area, or whatever suits your lifestyle. For added peace of mind, the home's major mechanical systems-including the furnace, air conditioner, water heater, and water softener-have all been recently updated. Beautifully maintained and thoughtfully updated, this exceptional home is ready to welcome its new owners. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Dishwasher"
4 => "Stove"
5 => "Dryer"
6 => "Garage door opener remote(s)"
7 => "Water Heater"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T02:20:08.307374+00:00"
+"Directions": "Cross Streets: Parkside Dr. and Cedarbrae Ave. ** Directions: Cedarbrae Ave. to Sprucehill Ave."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Aluminum siding"
]
+"Fencing": array:1 [
0 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2003422"
+"ListOfficeKey": "85457"
+"LivingAreaUnits": "square feet"
+"LotSizeDimensions": "65.1 x 130.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-18T01:32:36Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-18T02:03:33Z"
+"Stories": "2.0"
+"StreetName": "Sprucehill"
+"StreetNumber": "535"
+"StreetSuffix": "Avenue"
+"TaxAnnualAmount": "5270.72"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/535-Sprucehill-Ave/idx"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [
"RoomKey" => "1661741697"
"RoomType" => "Foyer"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 2.73
"ListingKey" => "29919897"
"RoomLength" => 1.73
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
1 => array:11 [
"RoomKey" => "1661741698"
"RoomType" => "Family room"
"ListingId" => "X13459364"
"RoomLevel" => "Basement"
"RoomWidth" => 4.41
"ListingKey" => "29919897"
"RoomLength" => 7.31
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
2 => array:11 [
"RoomKey" => "1661741699"
"RoomType" => "Recreational, Games room"
"ListingId" => "X13459364"
"RoomLevel" => "Basement"
"RoomWidth" => 3.35
"ListingKey" => "29919897"
"RoomLength" => 7.65
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
3 => array:11 [
"RoomKey" => "1661741700"
"RoomType" => "Kitchen"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.46
"ListingKey" => "29919897"
"RoomLength" => 5.37
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
4 => array:11 [
"RoomKey" => "1661741701"
"RoomType" => "Laundry room"
"ListingId" => "X13459364"
"RoomLevel" => "Basement"
"RoomWidth" => 2.72
"ListingKey" => "29919897"
"RoomLength" => 3.8
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
5 => array:11 [
"RoomKey" => "1661741702"
"RoomType" => "Eating area"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.46
"ListingKey" => "29919897"
"RoomLength" => 2.4
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.36Z"
]
6 => array:11 [
"RoomKey" => "1661741703"
"RoomType" => "Living room"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29919897"
"RoomLength" => 6.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
7 => array:11 [
"RoomKey" => "1661741704"
"RoomType" => "Dining room"
"ListingId" => "X13459364"
"RoomLevel" => "Main level"
"RoomWidth" => 3.77
"ListingKey" => "29919897"
"RoomLength" => 2.34
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
8 => array:11 [
"RoomKey" => "1661741705"
"RoomType" => "Primary Bedroom"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 3.49
"ListingKey" => "29919897"
"RoomLength" => 5.59
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
9 => array:11 [
"RoomKey" => "1661741706"
"RoomType" => "Den"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 4.02
"ListingKey" => "29919897"
"RoomLength" => 5.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
10 => array:11 [
"RoomKey" => "1661741707"
"RoomType" => "Bedroom"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 3.54
"ListingKey" => "29919897"
"RoomLength" => 3.42
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
11 => array:11 [
"RoomKey" => "1661741708"
"RoomType" => "Bedroom"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 4.63
"ListingKey" => "29919897"
"RoomLength" => 2.71
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
12 => array:11 [
"RoomKey" => "1661741709"
"RoomType" => "Den"
"ListingId" => "X13459364"
"RoomLevel" => "Second level"
"RoomWidth" => 4.34
"ListingKey" => "29919897"
"RoomLength" => 2.33
"RoomDimensions" => null
"RoomDescription" => null
"RoomLengthWidthUnits" => "meters"
"ModificationTimestamp" => "2026-06-18T02:03:33.37Z"
]
]
+"ListAOR": "OnePoint"
+"TaxYear": 2026
+"ListAORKey": "47"
+"ListingURL": "www.realtor.ca/real-estate/29919897/535-sprucehill-avenue-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 2500
+"LivingAreaMinimum": 2000
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 3
+"FrontageLengthNumeric": 65.1
+"OriginalEntryTimestamp": "2026-06-18T01:32:36.43Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1286265"
+"ListOfficeNationalAssociationId": "1002051"
+"Media": array:45 [
0 => array:13 [
"Order" => 1
"MediaKey" => "29919897_4890_1"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/6102886661e607c8aae17a5cb8e1b24f.webp"
"MediaSize" => 430061
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-6102886661e607c8aae17a5cb8e1b24f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => true
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
1 => array:13 [
"Order" => 2
"MediaKey" => "29919897_4890_2"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/29f22fb52dca72901026632450ed70c3.webp"
"MediaSize" => 451342
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-29f22fb52dca72901026632450ed70c3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
2 => array:13 [
"Order" => 3
"MediaKey" => "29919897_4890_3"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/ab67dfc1339632d5413e8a8f83616cf3.webp"
"MediaSize" => 413352
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-ab67dfc1339632d5413e8a8f83616cf3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
3 => array:13 [
"Order" => 4
"MediaKey" => "29919897_4890_4"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/765b7b1ce6d2f9e62ce8e468387be0d9.webp"
"MediaSize" => 332191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-765b7b1ce6d2f9e62ce8e468387be0d9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
4 => array:13 [
"Order" => 5
"MediaKey" => "29919897_4890_5"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/3ab206bc4d39ef479fb9995f86491c89.webp"
"MediaSize" => 161135
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-3ab206bc4d39ef479fb9995f86491c89.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
5 => array:13 [
"Order" => 6
"MediaKey" => "29919897_4890_6"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/7468331d3089afb33430e3404dc77a79.webp"
"MediaSize" => 165228
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-7468331d3089afb33430e3404dc77a79.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
6 => array:13 [
"Order" => 7
"MediaKey" => "29919897_4890_7"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/b5cee3c1825d4cac207822ee5f3f711b.webp"
"MediaSize" => 180734
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-b5cee3c1825d4cac207822ee5f3f711b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
7 => array:13 [
"Order" => 8
"MediaKey" => "29919897_4890_8"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/bc170c5e842e85b7303aa23651519b41.webp"
"MediaSize" => 170774
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-bc170c5e842e85b7303aa23651519b41.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
8 => array:13 [
"Order" => 9
"MediaKey" => "29919897_4890_9"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/29c65bea01d9c046805791c7975915aa.webp"
"MediaSize" => 205495
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-29c65bea01d9c046805791c7975915aa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
9 => array:13 [
"Order" => 10
"MediaKey" => "29919897_4890_10"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/287c63a0b4159a040f4a8c6da88ec2cc.webp"
"MediaSize" => 170147
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-287c63a0b4159a040f4a8c6da88ec2cc.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
10 => array:13 [
"Order" => 11
"MediaKey" => "29919897_4890_11"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/aa3e56a395f9e17473eb70a88384cdc1.webp"
"MediaSize" => 192978
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-aa3e56a395f9e17473eb70a88384cdc1.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
11 => array:13 [
"Order" => 12
"MediaKey" => "29919897_4890_12"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/5f98387953418cf4ed526f5cc649c943.webp"
"MediaSize" => 191411
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-5f98387953418cf4ed526f5cc649c943.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
12 => array:13 [
"Order" => 13
"MediaKey" => "29919897_4890_13"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/c43d65b3c2f5911fe2776c5ed0203b8d.webp"
"MediaSize" => 146130
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-c43d65b3c2f5911fe2776c5ed0203b8d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
13 => array:13 [
"Order" => 14
"MediaKey" => "29919897_4890_14"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/8dc7995a1eb46208c5491318fade3549.webp"
"MediaSize" => 162699
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-8dc7995a1eb46208c5491318fade3549.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
14 => array:13 [
"Order" => 15
"MediaKey" => "29919897_4890_15"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/2905755a66ef2ebeb76dcbb6778cad4b.webp"
"MediaSize" => 174174
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-2905755a66ef2ebeb76dcbb6778cad4b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
15 => array:13 [
"Order" => 16
"MediaKey" => "29919897_4890_16"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/5a9f13fa0b6a82d3b5e154a3294f6108.webp"
"MediaSize" => 167407
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-5a9f13fa0b6a82d3b5e154a3294f6108.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
16 => array:13 [
"Order" => 17
"MediaKey" => "29919897_4890_17"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/8f6f7de50e2821728d6add3c1eb57561.webp"
"MediaSize" => 125557
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-8f6f7de50e2821728d6add3c1eb57561.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
17 => array:13 [
"Order" => 18
"MediaKey" => "29919897_4890_18"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/db2227de579795da703ab6140880a63b.webp"
"MediaSize" => 163191
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-db2227de579795da703ab6140880a63b.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
18 => array:13 [
"Order" => 19
"MediaKey" => "29919897_4890_19"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/882ae39d8b8a8f1dfdd23dbd3ea4a7f0.webp"
"MediaSize" => 181104
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-882ae39d8b8a8f1dfdd23dbd3ea4a7f0.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
19 => array:13 [
"Order" => 20
"MediaKey" => "29919897_4890_20"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/7a03627959d834ab1a9e19e6b85015b3.webp"
"MediaSize" => 140688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-7a03627959d834ab1a9e19e6b85015b3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
20 => array:13 [
"Order" => 21
"MediaKey" => "29919897_4890_21"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/e76192e0819bf4e505e14aa7bf3d0031.webp"
"MediaSize" => 152929
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-e76192e0819bf4e505e14aa7bf3d0031.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
21 => array:13 [
"Order" => 22
"MediaKey" => "29919897_4890_22"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/0a57d208fd6bbf5a1d43ea4c7d21a98e.webp"
"MediaSize" => 169688
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-0a57d208fd6bbf5a1d43ea4c7d21a98e.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
22 => array:13 [
"Order" => 23
"MediaKey" => "29919897_4890_23"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/6bb47ba62cde36078959cfe5fb9674f9.webp"
"MediaSize" => 172462
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-6bb47ba62cde36078959cfe5fb9674f9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
23 => array:13 [
"Order" => 24
"MediaKey" => "29919897_4890_24"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/f8053d5aaf04c6dc19a7a7b413716f11.webp"
"MediaSize" => 159431
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-f8053d5aaf04c6dc19a7a7b413716f11.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
24 => array:13 [
"Order" => 25
"MediaKey" => "29919897_4890_25"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/ca5f314c0796cef48cf2cc1f7821b691.webp"
"MediaSize" => 177230
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-ca5f314c0796cef48cf2cc1f7821b691.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
25 => array:13 [
"Order" => 26
"MediaKey" => "29919897_4890_26"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/6ab5e9c63631d9a87560306cf928cb3d.webp"
"MediaSize" => 149907
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-6ab5e9c63631d9a87560306cf928cb3d.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
26 => array:13 [
"Order" => 27
"MediaKey" => "29919897_4890_27"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/4dd86174c24713d4a0ad9013b75b9cc6.webp"
"MediaSize" => 175133
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-4dd86174c24713d4a0ad9013b75b9cc6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
27 => array:13 [
"Order" => 28
"MediaKey" => "29919897_4890_28"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/fb1f2da488501e49e77cbac1e8f5a35f.webp"
"MediaSize" => 148955
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-fb1f2da488501e49e77cbac1e8f5a35f.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
28 => array:13 [
"Order" => 29
"MediaKey" => "29919897_4890_29"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/41c100638ed36af2b373689ce11987cd.webp"
"MediaSize" => 178835
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-41c100638ed36af2b373689ce11987cd.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
29 => array:13 [
"Order" => 30
"MediaKey" => "29919897_4890_30"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/f5530229168f861211437630f1fb2374.webp"
"MediaSize" => 143102
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-f5530229168f861211437630f1fb2374.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
30 => array:13 [
"Order" => 31
"MediaKey" => "29919897_4890_31"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/28c2463efe97e088179d718d56aebafa.webp"
"MediaSize" => 222013
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-28c2463efe97e088179d718d56aebafa.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
31 => array:13 [
"Order" => 32
"MediaKey" => "29919897_4890_32"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/22bcb2efa9a262e95ee25a108dad3850.webp"
"MediaSize" => 246203
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-22bcb2efa9a262e95ee25a108dad3850.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
32 => array:13 [
"Order" => 33
"MediaKey" => "29919897_4890_33"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/5b9d48b5f72986421490d3f449e260a2.webp"
"MediaSize" => 162223
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-5b9d48b5f72986421490d3f449e260a2.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
33 => array:13 [
"Order" => 34
"MediaKey" => "29919897_4890_34"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/a91cebb6ed56b991c5dffe7809f70ec5.webp"
"MediaSize" => 216948
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-a91cebb6ed56b991c5dffe7809f70ec5.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
34 => array:13 [
"Order" => 35
"MediaKey" => "29919897_4890_35"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/385badab6355f5f2238bfc0849aa42ef.webp"
"MediaSize" => 184847
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-385badab6355f5f2238bfc0849aa42ef.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
35 => array:13 [
"Order" => 36
"MediaKey" => "29919897_4890_36"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/d3df569eca29b2c607fba19f77e696d6.webp"
"MediaSize" => 181815
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-d3df569eca29b2c607fba19f77e696d6.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
36 => array:13 [
"Order" => 37
"MediaKey" => "29919897_4890_37"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/c787060d0f00b6871e405368c3763b58.webp"
"MediaSize" => 469822
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-c787060d0f00b6871e405368c3763b58.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
37 => array:13 [
"Order" => 38
"MediaKey" => "29919897_4890_38"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/7e41d9de2724c0736716f6f35d3e4624.webp"
"MediaSize" => 457081
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-7e41d9de2724c0736716f6f35d3e4624.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
38 => array:13 [
"Order" => 39
"MediaKey" => "29919897_4890_39"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/41ea46736b14ea1c7e8402d59ff12f93.webp"
"MediaSize" => 448825
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-41ea46736b14ea1c7e8402d59ff12f93.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
39 => array:13 [
"Order" => 40
"MediaKey" => "29919897_4890_40"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/9ad0e94724d952e5570cfdaa778c3b85.webp"
"MediaSize" => 306350
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-9ad0e94724d952e5570cfdaa778c3b85.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
40 => array:13 [
"Order" => 41
"MediaKey" => "29919897_4890_41"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/4415401d8a7bfe4710595ab1523be209.webp"
"MediaSize" => 488863
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-4415401d8a7bfe4710595ab1523be209.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
41 => array:13 [
"Order" => 42
"MediaKey" => "29919897_4890_42"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/31e6f9bcc2e60f536a5d070e645cdbc3.webp"
"MediaSize" => 486404
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-31e6f9bcc2e60f536a5d070e645cdbc3.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
42 => array:13 [
"Order" => 43
"MediaKey" => "29919897_4890_43"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/1f8c2f3f3ccee7bd895a67960a46c1b9.webp"
"MediaSize" => 496031
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-1f8c2f3f3ccee7bd895a67960a46c1b9.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
"ResourceRecordKey" => "29919897"
"ModificationTimestamp" => "2026-06-18T01:32:36.43Z"
]
43 => array:13 [
"Order" => 44
"MediaKey" => "29919897_4890_44"
"MediaURL" => "https://cdn.realtyfeed.com/cdn/26/29919897/90360a8a19757cbfc4d2bcf71046d328.webp"
"MediaSize" => 486767
"MediaType" => "webp"
"Thumbnail" => "https://cdn.realtyfeed.com/cdn/26/29919897/thumbnail-90360a8a19757cbfc4d2bcf71046d328.webp"
"ResourceName" => "Property"
"MediaCategory" => "Property Photo"
"LongDescription" => null
"PreferredPhotoYN" => false
"ResourceRecordId" => "X13459364"
…2
]
44 => array:13 [ …13]
]
+"DaysOnMarket": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919897')"
+"ID": "1541891"
}
1 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25186
+post_id: "1541612"
+post_author: 1
+"ListingKey": "29919137"
+"ListingId": "X13458766"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T22:25:04Z"
+"RFModificationTimestamp": "2026-06-18T00:00:18Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.55401
1 => 43.486134
]
+"Latitude": 43.486134
+"Longitude": -80.55401
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:5 [
0 => "Finished"
1 => "Full"
2 => "Separate entrance"
3 => "N/A"
4 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-18T00:00:06.866591+00:00"
+"Directions": "Cross Streets: BEARINGER RD / GLEN FORREST BLVD. ** Directions: BEARINGER RD TO GLEN FORREST BLVD."
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2182896"
+"ListOfficeKey": "289816"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "60 x 101.2 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T22:19:46Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T22:19:46Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29919137/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"OriginalEntryTimestamp": "2026-06-17T22:19:46.45Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1432697"
+"ListOfficeNationalAssociationId": "1381521"
+"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": 0
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29919137')"
+"ID": "1541612"
}
2 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25183
+post_id: "1536562"
+post_author: 1
+"ListingKey": "29912895"
+"ListingId": "X13453290"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T22:05:19Z"
+"RFModificationTimestamp": "2026-06-16T22:19:34Z"
+"ListPrice": 769000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 5.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4Y1"
+"UnparsedAddress": "591 DOGWOOD LANE, Waterloo, Ontario N2L4Y1"
+"Coordinates": array:2 [
0 => -80.560828
1 => 43.486633
]
+"Latitude": 43.486633
+"Longitude": -80.560828
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome To Dogwood Lane! This Well-Maintained Bungalow Is Situated On A Quiet, Family-Friendly Street And Offers Comfortable Living With Excellent Income Potential. The Bright Living And Dining Areas Feature Hardwood Flooring And Large Windows For Plenty Of Natural Light. The Updated Kitchen Boasts Ceramic Flooring, Quartz Countertops, And A Stylish Backsplash. The Main Floor Includes Three Generously Sized Bedrooms With Parquet Flooring, Closets, And Separate Main Floor Laundry. The Fully Renovated (2022) Basement Features A Separate Entrance, Separate Laundry, Two Bedrooms, Vinyl Flooring, Pot Lights, A Cozy Fireplace, And A Spacious Living Area. The Bathroom Includes Ceramic Flooring, A Modern Vanity, And A Beautiful Clawfoot Soaker Tub. Enjoy A Large, Beautifully Landscaped Backyard Perfect For Entertaining. Recent Updates Include A.C./Heat Pump (Aug 2023), Furnace (Aug 2023), Tankless Water Heater (Aug 2023), Roof Insulation (Aug 2023), Water Purifier (Jun 2023), Water Filter (Jun 2023), And LeafFilter Gutter Protection (Aug 2023). Conveniently Located Close To Hwy 401, Schools, Shopping, Parks, Public Transit, And Within Walking Distance To The University Of Waterloo Campus. Move-In Ready Home Offering Comfort, Convenience, And Versatility. EXTRAS: Separate Entrance To Renovated Basement With Separate Laundry, Tankless Water Heater, Water Purifier, Water Filter, Heat Pump, LeafFilter Gutter Protection, Fireplace In Basement. (id:62783)"
+"Appliances": array:10 [
0 => "Washer"
1 => "Water purifier"
2 => "Dishwasher"
3 => "Stove"
4 => "Dryer"
5 => "Microwave"
6 => "Hood Fan"
7 => "Garage door opener remote(s)"
8 => "Water Heater"
9 => "Two Refrigerators"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:6 [
0 => "Finished"
1 => "Separate entrance"
2 => "Walk-up"
3 => "N/A"
4 => "N/A"
5 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T22:19:28.544312+00:00"
+"Directions": "Bearinger Road / Toll Gate/Dogwood Ln"
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"Flooring": array:4 [
0 => "Hardwood"
1 => "Parquet"
2 => "Ceramic"
3 => "Vinyl"
]
+"FoundationDetails": array:1 [
0 => "Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2105595"
+"ListOfficeKey": "164016"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Carpet Free"
]
+"LotSizeDimensions": "45 x 114 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T21:55:46Z"
+"PhotosCount": 38
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T21:55:46Z"
+"Stories": "1.0"
+"StreetName": "Dogwood"
+"StreetNumber": "591"
+"StreetSuffix": "Lane"
+"TaxAnnualAmount": "4316"
+"Utilities": array:2 [
0 => "Sewer"
1 => "Electricity"
]
+"View": "View"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:9 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29912895/591-dogwood-lane-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"SecurityFeatures": array:1 [
0 => "Smoke Detectors"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "Residential"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 45.0
+"OriginalEntryTimestamp": "2026-06-16T21:55:46.28Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1374868"
+"ListOfficeNationalAssociationId": "1184644"
+"Media": array:38 [
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]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912895')"
+"ID": "1536562"
}
3 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25187
+post_id: "1536272"
+post_author: 1
+"ListingKey": "29912090"
+"ListingId": "40838984"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T02:40:13Z"
+"RFModificationTimestamp": "2026-06-17T02:46:19Z"
+"ListPrice": 800000.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0.12
+"LivingArea": 2776.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V2J3"
+"UnparsedAddress": "491 SANDBANKS Crescent, Waterloo, Ontario N2V2J3"
+"Coordinates": array:2 [
0 => -80.5768545
1 => 43.4964646
]
+"Latitude": 43.4964646
+"Longitude": -80.5768545
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "IS THIS YOUR NEW HOME? Situated in desirable Conservation Meadows, this 2 Storey home offers a special option for those needing accessible features, including a main floor bedroom and ramp to the front door (2015) and also a ramp off the deck (2016). The stunning acacia engineered hardwood flooring (2019) greets you as you enter this bright and spacious main floor. The updates continue into the kitchen with new white cabinetry, quartz counters, stainless appliances and dimmable pot lights (2022). The sliders to the backyard walk out to the peaceful backyard showcasing lovely perennial gardens, and also features an Arctic Spa Yukon hot tub. Upstairs you will find 3 good-sized bedrooms including a spacious primary bedroom with large walk-in closet, and a long bathroom with potential for splitting it into two (a main bath and an ensuite bath). In the finished basement you will find a newly finished rec room, large utility room / workshop area, laundry room, cold cellar, and a separate den/office/storage room (potential for a 5th bedroom!). Additional updates include roof (2014), air conditioner (2017) washer/dryer (approx 2021), dishwasher (2024). (id:62783)"
+"AccessibilityFeatures": array:1 [
0 => "Accessible Approach with Ramp"
]
+"Appliances": array:9 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Central Vacuum"
5 => "Dishwasher"
6 => "Stove"
7 => "Dryer"
8 => "Garage door opener"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:49:21.761386+00:00"
+"ExteriorFeatures": array:2 [
0 => "Vinyl siding"
1 => "Brick Veneer"
]
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1990854"
+"ListOfficeKey": "289541"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:2 [
0 => "Paved driveway"
1 => "Sump Pump"
]
+"LotSizeDimensions": "0.12"
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-17T00:32:16Z"
+"PhotosCount": 45
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T02:32:01Z"
+"Stories": "2.0"
+"StreetName": "SANDBANKS"
+"StreetNumber": "491"
+"StreetSuffix": "Crescent"
+"SubdivisionName": "441 - Erbsville/Laurelwood"
+"TaxAnnualAmount": "6158"
+"VirtualTourURLUnbranded": "https://media.visualadvantage.ca/491-Sandbanks-Crescent"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:14 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29912090/491-sandbanks-crescent-waterloo"
+"ParkingTotal": 4
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "R4"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 0
+"FrontageLengthNumeric": 42.0
+"AboveGradeFinishedArea": 2063
+"BelowGradeFinishedArea": 713
+"OriginalEntryTimestamp": "2026-06-16T20:10:34.34Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1274526"
+"ListOfficeNationalAssociationId": "1378680"
+"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": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29912090')"
+"ID": "1536272"
}
4 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25185
+post_id: "1536105"
+post_author: 1
+"ListingKey": "29911948"
+"ListingId": "40840389"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-17T21:40:06Z"
+"RFModificationTimestamp": "2026-06-17T21:44:09Z"
+"ListPrice": 689900.0
+"BathroomsTotalInteger": 3.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 2137.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J3"
+"UnparsedAddress": "543 GLEN FORREST Boulevard, Waterloo, Ontario N2L4J3"
+"Coordinates": array:2 [
0 => -80.5539256
1 => 43.4861133
]
+"Latitude": 43.4861133
+"Longitude": -80.5539256
+"YearBuilt": 1967
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to this detached bungalow in a desirable and tucked-away Waterloo location, offering over 1,800 sq. ft. of finished living space, a huge lot, and incredible potential inside and out. Perfect for first-time buyers, investors, or multi-generational families, this home features a bright main level with 3 bedrooms, 1 full bathroom, and comfortable living and dining areas. The separate entrance to the basement adds excellent flexibility, with 4 additional bedrooms and 2 full bathrooms, making it ideal for extended family use or potential mortgage-helper income. Set on a generous lot with 60 ft. frontage, this property offers parking for up to 4 vehicles in the driveway plus 1 in the garage. The backyard is a major highlight, offering so much potential to create a private outdoor retreat, garden space, patio area, or future entertaining setup. Located in a secluded area of Waterloo while still being close to everyday amenities, shopping, schools, public transportation, Conestoga College, and the University of Waterloo, this home provides both convenience and opportunity. Whether you are looking to move in, invest, or add value over time, this property is full of possibilities. Book your private showing today! * Some photos have been virtually staged. (id:62650)"
+"Appliances": array:3 [
0 => "Washer"
1 => "Stove"
2 => "Dryer"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:2 [
0 => "Quiet Area"
1 => "School Bus"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T20:34:13.849462+00:00"
+"Directions": "BEARINGER RD TO GLEN FORREST BLVD"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750682"
+"ListOfficeKey": "289792"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"ParkingFeatures": array:1 [
0 => "Attached Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T19:50:57Z"
+"PhotosCount": 31
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-17T21:31:27Z"
+"Stories": "1.0"
+"StreetName": "GLEN FORREST"
+"StreetNumber": "543"
+"StreetSuffix": "Boulevard"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "4425"
+"VirtualTourURLUnbranded": "https://youriguide.com/0frvu_543_glen_forrest_blvd_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:16 [
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]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29911948/543-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CoListAgentKey": "2172787"
+"CommonInterest": "Freehold"
+"CoListOfficeKey": "156376"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 3
+"FrontageLengthNumeric": 60.0
+"AboveGradeFinishedArea": 1108
+"BelowGradeFinishedArea": 1029
+"OriginalEntryTimestamp": "2026-06-16T19:50:55.86Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"BelowGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1164848"
+"ListOfficeNationalAssociationId": "1381240"
+"CoListAgentNationalAssociationId": "1423270"
+"CoListOfficeNationalAssociationId": "1003925"
+"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('29911948')"
+"ID": "1536105"
}
5 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25180
+post_id: "1534435"
+post_author: 1
+"ListingKey": "29909870"
+"ListingId": "X13450512"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T16:10:11Z"
+"RFModificationTimestamp": "2026-06-16T16:26:29Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK DRIVE, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.55825
1 => 43.489526
]
+"Latitude": 43.489526
+"Longitude": -80.55825
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo's most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop-perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub-an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:4 [
0 => "Finished"
1 => "Separate entrance"
2 => "N/A"
3 => "N/A"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T16:26:23.962076+00:00"
+"Directions": "Glen Forest Blvd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:2 [
0 => "Fenced yard"
1 => "Fully Fenced"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2127512"
+"ListOfficeKey": "283918"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Gazebo"
]
+"LotSizeDimensions": "43.1 x 122.2 FT"
+"ParkingFeatures": array:2 [
0 => "Covered"
1 => "No Garage"
]
+"PhotosChangeTimestamp": "2026-06-16T15:59:56Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:59:56Z"
+"Stories": "1.0"
+"StreetName": "Havelock"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29909870/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1100
+"LivingAreaMinimum": 700
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.1
+"OriginalEntryTimestamp": "2026-06-16T15:59:55.98Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1380753"
+"ListOfficeNationalAssociationId": "1336772"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909870')"
+"ID": "1534435"
}
6 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#23376
+post_id: "1534290"
+post_author: 1
+"ListingKey": "29909459"
+"ListingId": "40836533"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T15:20:10Z"
+"RFModificationTimestamp": "2026-06-16T15:36:25Z"
+"ListPrice": 699900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 4.0
+"LotSizeArea": 0
+"LivingArea": 2101.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4N7"
+"UnparsedAddress": "514 HAVELOCK Drive, Waterloo, Ontario N2L4N7"
+"Coordinates": array:2 [
0 => -80.5582589
1 => 43.4895518
]
+"Latitude": 43.4895518
+"Longitude": -80.5582589
+"YearBuilt": 1971
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Welcome to 514 Havelock Drive! Nestled in one of Waterloo’s most sought-after family-friendly neighbourhoods, this well-maintained 3+1 bedroom, 2-bathroom bungalow offers the perfect combination of comfort, convenience, and future potential. The carpet-free main floor features a bright and functional layout with 3 spacious bedrooms, a full bathroom, a well-appointed kitchen, and inviting living and dining areas ideal for everyday living and entertaining. A separate side entrance provides excellent flexibility and potential for an in-law setup or multi-generational living. The fully finished basement expands your living space with a large rec room, an office or fourth bedroom, a 3-piece bathroom, laundry room, and a bonus workshop—perfect for hobbyists, DIY enthusiasts, or additional storage. Step outside to your own private retreat. The fully fenced backyard oasis is designed for relaxation and entertaining, featuring a spacious deck, storage shed, and a wooden gazebo covering the hot tub—an ideal space to unwind year-round. With parking for up to 5 vehicles, this home is perfectly suited for growing families and busy households. Deck (2023), Water Heater (2023), Washer & Dryer (2024), Roof (2023). Conveniently located just minutes from Highway 7 and Highway 8, as well as Wilfrid Laurier University, University of Waterloo, numerous parks and trails, and Conestoga Mall, this exceptional property offers an unbeatable location close to everything you need. Whether you're a growing family, investor, or buyer seeking multi-generational living potential, 514 Havelock Drive delivers outstanding value in an incredible Waterloo location. Book your private showing today! (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Hot Tub"
4 => "Stove"
5 => "Dryer"
6 => "Hood Fan"
7 => "Window Coverings"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-16T15:36:23.785553+00:00"
+"Directions": "Glen Forest Rd"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Fencing": array:1 [
0 => "Fence"
]
+"FireplaceYN": true
+"FireplacesTotal": "1"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1750161"
+"ListOfficeKey": "283896"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Paved driveway"
]
+"ParkingFeatures": array:1 [
0 => "Carport"
]
+"PhotosChangeTimestamp": "2026-06-16T15:13:40Z"
+"PhotosCount": 34
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T15:13:40Z"
+"Stories": "1.0"
+"StreetName": "HAVELOCK"
+"StreetNumber": "514"
+"StreetSuffix": "Drive"
+"SubdivisionName": "421 - Lakeshore/Parkdale"
+"TaxAnnualAmount": "3987"
+"VirtualTourURLUnbranded": "https://youriguide.com/wqcfm_514_havelock_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:13 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29909459/514-havelock-drive-waterloo"
+"ParkingTotal": 5
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": true
+"ZoningDescription": "SR1-10"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 1
+"FrontageLengthNumeric": 43.0
+"AboveGradeFinishedArea": 1071
+"BelowGradeFinishedArea": 1030
+"OriginalEntryTimestamp": "2026-06-16T15:11:23.62Z"
+"FrontageLengthNumericUnits": "feet"
+"AboveGradeFinishedAreaUnits": "square feet"
+"BelowGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Plans"
+"BelowGradeFinishedAreaSource": "Plans"
+"ListAgentNationalAssociationId": "1163644"
+"ListOfficeNationalAssociationId": "1349002"
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29909459')"
+"ID": "1534290"
}
7 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25188
+post_id: "1534996"
+post_author: 1
+"ListingKey": "29908944"
+"ListingId": "40839096"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-16T14:20:09Z"
+"RFModificationTimestamp": "2026-06-16T14:34:59Z"
+"ListPrice": 399900.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 1
+"BedroomsTotal": 3.0
+"LotSizeArea": 0
+"LivingArea": 1202.0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2V1Z2"
+"UnparsedAddress": "255 NORTHLAKE Drive Unit# 15, Waterloo, Ontario N2V1Z2"
+"Coordinates": array:2 [
0 => -80.55183
1 => 43.4976023
]
+"Latitude": 43.4976023
+"Longitude": -80.55183
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Cornerstone Association of REALTORS®"
+"PublicRemarks": "Don't miss this opportunity to own a well-maintained home in Waterloo's desirable North Lakeshore neighbourhood. Location is everything! Just minutes from the LRT, Conestoga Mall, the St. Jacobs Market District, excellent schools, restaurants, grocery stores, parks, trails, and major highways. Walk or bike to almost everything you need. The main floor features a spacious entryway with a double closet, an updated powder room, and a bright white kitchen with newer countertops and sink, open to the dining and living areas. The functional layout offers comfortable everyday living with direct access to the backyard deck, perfect for relaxing or entertaining. With over 1,500 sq. ft. of finished living space, this home offers 3 bedrooms, 1.5 bathrooms, and a fully finished basement complete with a recreation room, laundry area, and rough-in for a future bathroom. Recent updates include modern laminate flooring, interior doors, and hardware. Outside, enjoy a welcoming patio and the convenience of a single carport. Ideal for first-time buyers, families, commuters, or investors looking for a low-maintenance home in a prime Waterloo location. (id:62783)"
+"Appliances": array:5 [
0 => "Washer"
1 => "Refrigerator"
2 => "Stove"
3 => "Dryer"
4 => "Hood Fan"
]
+"AssociationFee": "500"
+"AssociationFeeFrequency": "Monthly"
+"AssociationFeeIncludes": array:5 [
0 => "Common Area Maintenance"
1 => "Landscaping"
2 => "Property Management"
3 => "Insurance"
4 => "Parking"
]
+"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-16T14:34:50.434290+00:00"
+"Directions": "Weber and Golden Eagle"
+"ExteriorFeatures": array:2 [
0 => "Brick"
1 => "Vinyl siding"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "1564276"
+"ListOfficeKey": "290168"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "Conservation/green belt"
]
+"LotSizeDimensions": "0"
+"ParkingFeatures": array:2 [
0 => "Carport"
1 => "Covered"
]
+"PhotosChangeTimestamp": "2026-06-16T14:12:31Z"
+"PhotosCount": 40
+"PropertyAttachedYN": true
+"Sewer": array:1 [
0 => "Municipal sewage system"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-16T14:12:31Z"
+"Stories": "2.0"
+"StreetName": "NORTHLAKE"
+"StreetNumber": "255"
+"StreetSuffix": "Drive"
+"SubdivisionName": "442 - Lakeshore North"
+"TaxAnnualAmount": "3036.39"
+"VirtualTourURLUnbranded": "https://youriguide.com/unit_15_255_northlake_dr_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:12 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
]
+"ListAOR": "Cornerstone"
+"ListAORKey": "14"
+"ListingURL": "www.realtor.ca/real-estate/29908944/255-northlake-drive-unit-15-waterloo"
+"ParkingTotal": 1
+"StructureType": array:1 [
0 => "Row / Townhouse"
]
+"CommonInterest": "Condo/Strata"
+"GeocodeManualYN": true
+"ZoningDescription": "MD"
+"BedroomsAboveGrade": 3
+"BedroomsBelowGrade": 0
+"AboveGradeFinishedArea": 1202
+"OriginalEntryTimestamp": "2026-06-16T14:10:40.39Z"
+"AboveGradeFinishedAreaUnits": "square feet"
+"AboveGradeFinishedAreaSource": "Other"
+"ListAgentNationalAssociationId": "1107226"
+"ListOfficeNationalAssociationId": "1384313"
+"Media": array:40 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
]
+"DaysOnMarket": 1
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29908944')"
+"ID": "1534996"
}
8 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#25189
+post_id: "1525986"
+post_author: 1
+"ListingKey": "29897607"
+"ListingId": "X13439034"
+"PropertyType": "Residential"
+"PropertySubType": "Single Family"
+"StandardStatus": "Active"
+"ModificationTimestamp": "2026-06-15T15:25:16Z"
+"RFModificationTimestamp": "2026-06-15T15:25:56Z"
+"ListPrice": 779000.0
+"BathroomsTotalInteger": 2.0
+"BathroomsHalf": 0
+"BedroomsTotal": 6.0
+"LotSizeArea": 0
+"LivingArea": 0
+"BuildingAreaTotal": 0
+"City": "Waterloo"
+"PostalCode": "N2L4J8"
+"UnparsedAddress": "598 GLEN FORREST BOULEVARD, Waterloo, Ontario N2L4J8"
+"Coordinates": array:2 [
0 => -80.557071
1 => 43.48873
]
+"Latitude": 43.48873
+"Longitude": -80.557071
+"YearBuilt": 0
+"InternetAddressDisplayYN": true
+"FeedTypes": "IDX"
+"OriginatingSystemName": "Toronto Regional Real Estate Board"
+"PublicRemarks": "Opportunity knocks at 598 Glen Forrest Boulevard! This spacious bungalow is very deceiving from the street! offers a versatile floor plan with 4 bedrooms on the main floor and 2 additional bedrooms in the finished lower level. The home is equipped with 2 kitchens, 2 bathrooms, and a fully separate entrance. The home is ideally suited for multi-generational living, an in-law setup, or potential income-generating possibilities. Numerous upgrades have been completed throughout the years, making this property move-in ready while still offering future potential. Enjoy a double driveway and garage for ample parking. A fantastic location close to top-rated schools, parks, shopping, transit, and Waterloo's renowned universities. 5 minutes from the future home of the new waterloo regional hospital. Quick possession available for buyers looking to make their move without delay. (id:62650)"
+"Appliances": array:8 [
0 => "Washer"
1 => "Refrigerator"
2 => "Water softener"
3 => "Central Vacuum"
4 => "Dishwasher"
5 => "Stove"
6 => "Dryer"
7 => "Water Heater"
]
+"ArchitecturalStyle": array:1 [
0 => "Bungalow"
]
+"Basement": array:2 [
0 => "Finished"
1 => "Full"
]
+"CommunityFeatures": array:1 [
0 => "Community Centre"
]
+"Cooling": array:1 [
0 => "Central air conditioning"
]
+"CreationDate": "2026-06-13T00:11:02.146610+00:00"
+"Directions": "Cross Streets: Weber St. ** Directions: Northfield to Weber St S to Glen Forrest Blvd."
+"ExteriorFeatures": array:1 [
0 => "Brick"
]
+"FireplaceYN": true
+"FireplacesTotal": "2"
+"FoundationDetails": array:1 [
0 => "Poured Concrete"
]
+"Heating": array:2 [
0 => "Forced air"
1 => "Natural gas"
]
+"InternetEntireListingDisplayYN": true
+"ListAgentKey": "2143277"
+"ListOfficeKey": "284147"
+"LivingAreaUnits": "square feet"
+"LotFeatures": array:1 [
0 => "In-Law Suite"
]
+"LotSizeDimensions": "65.6 x 114.5 FT"
+"ParkingFeatures": array:2 [
0 => "Attached Garage"
1 => "Garage"
]
+"PhotosChangeTimestamp": "2026-06-15T15:18:48Z"
+"PhotosCount": 50
+"Sewer": array:1 [
0 => "Sanitary sewer"
]
+"StateOrProvince": "Ontario"
+"StatusChangeTimestamp": "2026-06-15T15:18:48Z"
+"Stories": "1.0"
+"StreetName": "Glen Forrest"
+"StreetNumber": "598"
+"StreetSuffix": "Boulevard"
+"TaxAnnualAmount": "5227.74"
+"VirtualTourURLUnbranded": "https://youriguide.com/598_glen_forrest_boulevard_waterloo_on/"
+"WaterSource": array:1 [
0 => "Municipal water"
]
+"Rooms": array:15 [
0 => array:11 [ …11]
1 => array:11 [ …11]
2 => array:11 [ …11]
3 => array:11 [ …11]
4 => array:11 [ …11]
5 => array:11 [ …11]
6 => array:11 [ …11]
7 => array:11 [ …11]
8 => array:11 [ …11]
9 => array:11 [ …11]
10 => array:11 [ …11]
11 => array:11 [ …11]
12 => array:11 [ …11]
13 => array:11 [ …11]
14 => array:11 [ …11]
]
+"ListAOR": "Toronto"
+"TaxYear": 2026
+"ListAORKey": "82"
+"ListingURL": "www.realtor.ca/real-estate/29897607/598-glen-forrest-boulevard-waterloo"
+"ParkingTotal": 3
+"StructureType": array:1 [
0 => "House"
]
+"CommonInterest": "Freehold"
+"GeocodeManualYN": false
+"BuildingFeatures": array:1 [
0 => "Fireplace(s)"
]
+"LivingAreaMaximum": 1500
+"LivingAreaMinimum": 1100
+"ZoningDescription": "R1"
+"BedroomsAboveGrade": 4
+"BedroomsBelowGrade": 2
+"FrontageLengthNumeric": 65.7
+"OriginalEntryTimestamp": "2026-06-12T19:50:44.02Z"
+"FrontageLengthNumericUnits": "feet"
+"ListAgentNationalAssociationId": "1406869"
+"ListOfficeNationalAssociationId": "1338998"
+"Media": array:50 [
0 => array:13 [ …13]
1 => array:13 [ …13]
2 => array:13 [ …13]
3 => array:13 [ …13]
4 => array:13 [ …13]
5 => array:13 [ …13]
6 => array:13 [ …13]
7 => array:13 [ …13]
8 => array:13 [ …13]
9 => array:13 [ …13]
10 => array:13 [ …13]
11 => array:13 [ …13]
12 => array:13 [ …13]
13 => array:13 [ …13]
14 => array:13 [ …13]
15 => array:13 [ …13]
16 => array:13 [ …13]
17 => array:13 [ …13]
18 => array:13 [ …13]
19 => array:13 [ …13]
20 => array:13 [ …13]
21 => array:13 [ …13]
22 => array:13 [ …13]
23 => array:13 [ …13]
24 => array:13 [ …13]
25 => array:13 [ …13]
26 => array:13 [ …13]
27 => array:13 [ …13]
28 => array:13 [ …13]
29 => array:13 [ …13]
30 => array:13 [ …13]
31 => array:13 [ …13]
32 => array:13 [ …13]
33 => array:13 [ …13]
34 => array:13 [ …13]
35 => array:13 [ …13]
36 => array:13 [ …13]
37 => array:13 [ …13]
38 => array:13 [ …13]
39 => array:13 [ …13]
40 => array:13 [ …13]
41 => array:13 [ …13]
42 => array:13 [ …13]
43 => array:13 [ …13]
44 => array:13 [ …13]
45 => array:13 [ …13]
46 => array:13 [ …13]
47 => array:13 [ …13]
48 => array:13 [ …13]
49 => array:13 [ …13]
]
+"DaysOnMarket": 5
+"@odata.id": "https://api.realtyfeed.com/realtyfeed/odata/Property('29897607')"
+"ID": "1525986"
}
]
+success: true
+page_size: 9
+page_count: 9
+count: 78
+after_key: ""
}
"RF Response Time" => "0.14 seconds"
]
]