Residential For Sale

 Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5115
  +post_id: "51042"
  +post_author: 1
  +"ListingKey": "ae8788ecbe94dce2ccbe87684ccf4815"
  +"ListingId": "202519356"
  +"PropertyType": "Residential"
  +"PropertySubType": "Single Family Residence"
  +"StandardStatus": "Active"
  +"ModificationTimestamp": "2025-08-01T16:34:36Z"
  +"RFModificationTimestamp": "2025-08-01T16:43:15Z"
  +"ListPrice": 499900.0
  +"BathroomsTotalInteger": 2.0
  +"BathroomsHalf": 0
  +"BedroomsTotal": 3.0
  +"LotSizeArea": 7954.056
  +"LivingArea": 1424.0
  +"BuildingAreaTotal": 1424.0
  +"City": "Stewiacke"
  +"PostalCode": "B0N 2J0"
  +"UnparsedAddress": "25 Ridge, Stewiacke, NS B0N 2J0"
  +"Coordinates": array:2 [
    0 => -63.356468943
    1 => 45.137304415
  ]
  +"Latitude": 45.137304415
  +"Longitude": -63.356468943
  +"YearBuilt": 0
  +"InternetAddressDisplayYN": true
  +"FeedTypes": "IDX"
  +"ListAgentFullName": "David Borden"
  +"ListOfficeName": "BORDEN REAL ESTATE LIMITED - A586"
  +"ListAgentMlsId": "N39404"
  +"ListOfficeMlsId": "N7128"
  +"OriginatingSystemName": "NSAR"
  +"PublicRemarks": "Another New Home to be built in Stewiacke River Crossing . Wheelchair friendly home with infloor heat including double garage. 9 foot cielings. Quartz counter tops. Heat Pump. NOTE: room sizes are from plans. NOTE: Pantry on plans is mechanical room. Home will be landsacped by builder. This home is over 1400 sq ft. Photos are from previous home by same builder. Price is including HST  with rebate assigned to builder. Any offer must have written confirmation of financing ability attached.  Home covered by Lux Warranty. Home is is scheduled for completion February 2026. Will be Move in Ready!.  Have a look around this fine development just off exit 11, Stewiacke,  HWY 102. You will definatly be impressed."
  +"AccessibilityFeatures": array:1 [
    0 => "Wheelchair Access"
  ]
  +"ArchitecturalStyle": array:1 [
    0 => "Bungalow"
  ]
  +"AttachedGarageYN": true
  +"Basement": array:1 [
    0 => "None"
  ]
  +"BathroomsFull": 2
  +"BathroomsTotalDecimal": 2
  +"BelowGradeFinishedAreaUnits": "Square Feet"
  +"BuildingAreaUnits": "Square Feet"
  +"CityRegion": "Northern Region"
  +"CommunityFeatures": array:3 [
    0 => "Golf"
    1 => "Park"
    2 => "Place of Worship"
  ]
  +"ConstructionMaterials": array:1 [
    0 => "Vinyl Siding"
  ]
  +"Country": "CA"
  +"CountyOrParish": "Colchester"
  +"CoveredSpaces": "2"
  +"CreationDate": "2025-08-01T14:10:03.892005+00:00"
  +"Directions": "Just off  exit 11 in Stewiacke. Gibson to Ridge"
  +"ElectricOnPropertyYN": true
  +"FarmLandAreaUnits": "Square Feet"
  +"Flooring": array:1 [
    0 => "Laminate"
  ]
  +"FoundationDetails": array:1 [
    0 => "Slab"
  ]
  +"GarageSpaces": "2"
  +"GarageYN": true
  +"Heating": array:2 [
    0 => "Ductless"
    1 => "In Floor"
  ]
  +"HeatingYN": true
  +"IDXParticipationYN": true
  +"InteriorFeatures": array:1 [
    0 => "High Speed Internet"
  ]
  +"RFTransactionType": "For Sale"
  +"InternetEntireListingDisplayYN": true
  +"ListAgentFirstName": "David"
  +"ListAgentKey": "3ef314c4d08013e5ddcfe15edd219b19"
  +"ListAgentKeyNumeric": "1332"
  +"ListAgentLastName": "Borden"
  +"ListAgentOfficePhone": "902-456-3356"
  +"ListOfficeEmail": "bordenre@eastlink.ca"
  +"ListOfficeKey": "340116a285d09e300502139815d8250c"
  +"ListOfficeKeyNumeric": "467"
  +"ListingContractDate": "2025-08-01"
  +"ListingKeyNumeric": "202519356"
  +"LockBoxLocation": "None"
  +"LotFeatures": array:4 [
    0 => "Under 0.5 Acres"
    1 => "Landscaped"
    2 => "Level"
    3 => "Sloping/Terraced"
  ]
  +"LotSizeAcres": 0.1826
  +"LotSizeSquareFeet": 7954.056
  +"MLSAreaMajor": "104-Truro/Bible Hill/Stewiacke"
  +"MLSAreaMinor": "N/A"
  +"MlsStatus": "ACTIVE"
  +"NewConstructionYN": true
  +"OriginalListPrice": 499900
  +"OriginatingSystemKey": "nsar"
  +"OtherEquipment": array:2 [
    0 => "HRV (Heat Rcvry Ventln)"
    1 => "No Rental Equipment"
  ]
  +"OtherParking": "Parking Details(Gravel),Garage Details(Double With Infloor Heat)"
  +"OtherStructures": array:1 [
    0 => "Deck"
  ]
  +"Ownership": "Freehold"
  +"ParcelNumber": "20470878"
  +"ParkingFeatures": array:5 [
    0 => "Attached"
    1 => "Double"
    2 => "Heated Garage"
    3 => "Wired"
    4 => "Gravel"
  ]
  +"ParkingTotal": "4"
  +"PatioAndPorchFeatures": array:1 [
    0 => "Deck"
  ]
  +"PhotosChangeTimestamp": "2025-08-01T14:05:45Z"
  +"PhotosCount": 2
  +"Possession": array:1 [
    0 => "Upon Completition Late February"
  ]
  +"PriceChangeTimestamp": "2025-08-01T00:00:00Z"
  +"PropertyCondition": array:2 [
    0 => "New Construction"
    1 => "To Be Built"
  ]
  +"RoadFrontageType": array:1 [
    0 => "Public"
  ]
  +"Roof": array:1 [
    0 => "Asphalt"
  ]
  +"Sewer": array:1 [
    0 => "Municipal"
  ]
  +"SourceSystemKey": "202519356"
  +"StateOrProvince": "NS"
  +"StreetName": "Ridge"
  +"StreetNumber": "25"
  +"StructureType": array:1 [
    0 => "Detached"
  ]
  +"Utilities": array:3 [
    0 => "Electric"
    1 => "Electricity Connected"
    2 => "Phone Connected"
  ]
  +"WaterSource": array:1 [
    0 => "Municipal"
  ]
  +"Zoning": "R1"
  +"NSAR_LM_Int4_8": 1424
  +"NSAR_LM_Int2_20": 0
  +"NSAR_LM_Int4_12": 351
  +"NSAR_LM_Int4_13": 0
  +"NSAR_LM_char5_1": "Main Floor"
  +"NSAR_LM_char5_2": "Main Floor"
  +"NSAR_LM_char5_3": "Main Floor"
  +"NSAR_LM_char5_4": "Main Floor"
  +"NSAR_LM_char5_5": "Main Floor"
  +"NSAR_LM_char5_6": "Main Floor"
  +"NSAR_LM_char5_7": "Main Floor"
  +"NSAR_LM_char5_8": "Main Floor"
  +"NSAR_LM_Char1_14": "Yes"
  +"NSAR_LM_char30_1": "21 x 11'5"
  +"NSAR_LM_char30_2": "15 x 13"
  +"NSAR_LM_char30_3": "5 x 8"
  +"NSAR_LM_char30_4": "14'4 x 14'4"
  +"NSAR_LM_char30_5": "5 x 6"
  +"NSAR_LM_char30_6": "13 x 11"
  +"NSAR_LM_char30_7": "11'6 x 11"
  +"NSAR_LM_char30_8": "Closet"
  +"NSAR_LM_char5_31": "Eat In Kitchen"
  +"NSAR_LM_char5_32": "Great Room"
  +"NSAR_LM_char5_33": "Bath 1"
  +"NSAR_LM_char5_34": "Primary Bedroom"
  +"NSAR_LM_char5_35": "Ensuite Bath 1"
  +"NSAR_LM_char5_36": "Bedroom"
  +"NSAR_LM_char5_37": "Bedroom"
  +"NSAR_LM_char5_38": "Laundry"
  +"NSAR_LA1_Char10_1": "N39404"
  +"NSAR_LA1_Char10_2": "N7128"
  +"NSAR_LA1_Char10_4": "1034726"
  +"NSAR_LA1_Char50_1": "N39404"
  +"NSAR_LM_Char10_20": "Yes"
  +"NSAR_LM_Char10_21": "No"
  +"NSAR_LM_Char10_22": "Yes"
  +"NSAR_LM_Char25_21": "1034726"
  +"NSAR_LM_Char25_23": "1007248"
  +"NSAR_LM_char10_49": "Subject to HST; included in purchase price"
  +"NSAR_LO1_Char10_4": "1007248"
  +"NSAR_LMD_MP_Quality": 1
  +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('ae8788ecbe94dce2ccbe87684ccf4815')"
  +"provider_name": "NSAR"
  +"Media": array:2 [
    0 => array:13 [
      "Order" => 1
      "MediaKey" => "ae8788ecbe94dce2ccbe87684ccf4815-m1"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/2f157c48a52227b5565837c199556f3b.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 34197
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/thumbnail-2f157c48a52227b5565837c199556f3b.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202519356_1"
      "ShortDescription" => null
      "ResourceRecordKey" => "ae8788ecbe94dce2ccbe87684ccf4815"
    ]
    1 => array:13 [
      "Order" => 2
      "MediaKey" => "ae8788ecbe94dce2ccbe87684ccf4815-m2"
      "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/c8f7f70a2ef0eca4c84a61c6427b95f6.webp"
      "MimeType" => "image/jpeg"
      "ClassName" => "Residential"
      "MediaSize" => 455981
      "MediaType" => "webp"
      "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/thumbnail-c8f7f70a2ef0eca4c84a61c6427b95f6.webp"
      "ResourceName" => "Property"
      "MediaCategory" => "Photo"
      "MediaObjectID" => "202519356_2"
      "ShortDescription" => null
      "ResourceRecordKey" => "ae8788ecbe94dce2ccbe87684ccf4815"
    ]
  ]
  +"ID": "51042"
}

 array:1 [
  "RF Query: /Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq 'ae8788ecbe94dce2ccbe87684ccf4815'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq 'ae8788ecbe94dce2ccbe87684ccf4815'&$expand=Media/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq 'ae8788ecbe94dce2ccbe87684ccf4815'/Property?$select=ALL&$top=20&$filter=(StandardStatus in ('Active', 'Active Under Contract')) and ListingKey eq 'ae8788ecbe94dce2ccbe87684ccf4815'&$expand=Media&$count=true" => array:2 [
    "RF Response" => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\RFResponse {#5117
      +items: array:1 [
        0 => Realtyna\MlsOnTheFly\Components\CloudPost\SubComponents\RFClient\SDK\RF\Entities\RFProperty {#5115
          +post_id: "51042"
          +post_author: 1
          +"ListingKey": "ae8788ecbe94dce2ccbe87684ccf4815"
          +"ListingId": "202519356"
          +"PropertyType": "Residential"
          +"PropertySubType": "Single Family Residence"
          +"StandardStatus": "Active"
          +"ModificationTimestamp": "2025-08-01T16:34:36Z"
          +"RFModificationTimestamp": "2025-08-01T16:43:15Z"
          +"ListPrice": 499900.0
          +"BathroomsTotalInteger": 2.0
          +"BathroomsHalf": 0
          +"BedroomsTotal": 3.0
          +"LotSizeArea": 7954.056
          +"LivingArea": 1424.0
          +"BuildingAreaTotal": 1424.0
          +"City": "Stewiacke"
          +"PostalCode": "B0N 2J0"
          +"UnparsedAddress": "25 Ridge, Stewiacke, NS B0N 2J0"
          +"Coordinates": array:2 [
            0 => -63.356468943
            1 => 45.137304415
          ]
          +"Latitude": 45.137304415
          +"Longitude": -63.356468943
          +"YearBuilt": 0
          +"InternetAddressDisplayYN": true
          +"FeedTypes": "IDX"
          +"ListAgentFullName": "David Borden"
          +"ListOfficeName": "BORDEN REAL ESTATE LIMITED - A586"
          +"ListAgentMlsId": "N39404"
          +"ListOfficeMlsId": "N7128"
          +"OriginatingSystemName": "NSAR"
          +"PublicRemarks": "Another New Home to be built in Stewiacke River Crossing . Wheelchair friendly home with infloor heat including double garage. 9 foot cielings. Quartz counter tops. Heat Pump. NOTE: room sizes are from plans. NOTE: Pantry on plans is mechanical room. Home will be landsacped by builder. This home is over 1400 sq ft. Photos are from previous home by same builder. Price is including HST  with rebate assigned to builder. Any offer must have written confirmation of financing ability attached.  Home covered by Lux Warranty. Home is is scheduled for completion February 2026. Will be Move in Ready!.  Have a look around this fine development just off exit 11, Stewiacke,  HWY 102. You will definatly be impressed."
          +"AccessibilityFeatures": array:1 [
            0 => "Wheelchair Access"
          ]
          +"ArchitecturalStyle": array:1 [
            0 => "Bungalow"
          ]
          +"AttachedGarageYN": true
          +"Basement": array:1 [
            0 => "None"
          ]
          +"BathroomsFull": 2
          +"BathroomsTotalDecimal": 2
          +"BelowGradeFinishedAreaUnits": "Square Feet"
          +"BuildingAreaUnits": "Square Feet"
          +"CityRegion": "Northern Region"
          +"CommunityFeatures": array:3 [
            0 => "Golf"
            1 => "Park"
            2 => "Place of Worship"
          ]
          +"ConstructionMaterials": array:1 [
            0 => "Vinyl Siding"
          ]
          +"Country": "CA"
          +"CountyOrParish": "Colchester"
          +"CoveredSpaces": "2"
          +"CreationDate": "2025-08-01T14:10:03.892005+00:00"
          +"Directions": "Just off  exit 11 in Stewiacke. Gibson to Ridge"
          +"ElectricOnPropertyYN": true
          +"FarmLandAreaUnits": "Square Feet"
          +"Flooring": array:1 [
            0 => "Laminate"
          ]
          +"FoundationDetails": array:1 [
            0 => "Slab"
          ]
          +"GarageSpaces": "2"
          +"GarageYN": true
          +"Heating": array:2 [
            0 => "Ductless"
            1 => "In Floor"
          ]
          +"HeatingYN": true
          +"IDXParticipationYN": true
          +"InteriorFeatures": array:1 [
            0 => "High Speed Internet"
          ]
          +"RFTransactionType": "For Sale"
          +"InternetEntireListingDisplayYN": true
          +"ListAgentFirstName": "David"
          +"ListAgentKey": "3ef314c4d08013e5ddcfe15edd219b19"
          +"ListAgentKeyNumeric": "1332"
          +"ListAgentLastName": "Borden"
          +"ListAgentOfficePhone": "902-456-3356"
          +"ListOfficeEmail": "bordenre@eastlink.ca"
          +"ListOfficeKey": "340116a285d09e300502139815d8250c"
          +"ListOfficeKeyNumeric": "467"
          +"ListingContractDate": "2025-08-01"
          +"ListingKeyNumeric": "202519356"
          +"LockBoxLocation": "None"
          +"LotFeatures": array:4 [
            0 => "Under 0.5 Acres"
            1 => "Landscaped"
            2 => "Level"
            3 => "Sloping/Terraced"
          ]
          +"LotSizeAcres": 0.1826
          +"LotSizeSquareFeet": 7954.056
          +"MLSAreaMajor": "104-Truro/Bible Hill/Stewiacke"
          +"MLSAreaMinor": "N/A"
          +"MlsStatus": "ACTIVE"
          +"NewConstructionYN": true
          +"OriginalListPrice": 499900
          +"OriginatingSystemKey": "nsar"
          +"OtherEquipment": array:2 [
            0 => "HRV (Heat Rcvry Ventln)"
            1 => "No Rental Equipment"
          ]
          +"OtherParking": "Parking Details(Gravel),Garage Details(Double With Infloor Heat)"
          +"OtherStructures": array:1 [
            0 => "Deck"
          ]
          +"Ownership": "Freehold"
          +"ParcelNumber": "20470878"
          +"ParkingFeatures": array:5 [
            0 => "Attached"
            1 => "Double"
            2 => "Heated Garage"
            3 => "Wired"
            4 => "Gravel"
          ]
          +"ParkingTotal": "4"
          +"PatioAndPorchFeatures": array:1 [
            0 => "Deck"
          ]
          +"PhotosChangeTimestamp": "2025-08-01T14:05:45Z"
          +"PhotosCount": 2
          +"Possession": array:1 [
            0 => "Upon Completition Late February"
          ]
          +"PriceChangeTimestamp": "2025-08-01T00:00:00Z"
          +"PropertyCondition": array:2 [
            0 => "New Construction"
            1 => "To Be Built"
          ]
          +"RoadFrontageType": array:1 [
            0 => "Public"
          ]
          +"Roof": array:1 [
            0 => "Asphalt"
          ]
          +"Sewer": array:1 [
            0 => "Municipal"
          ]
          +"SourceSystemKey": "202519356"
          +"StateOrProvince": "NS"
          +"StreetName": "Ridge"
          +"StreetNumber": "25"
          +"StructureType": array:1 [
            0 => "Detached"
          ]
          +"Utilities": array:3 [
            0 => "Electric"
            1 => "Electricity Connected"
            2 => "Phone Connected"
          ]
          +"WaterSource": array:1 [
            0 => "Municipal"
          ]
          +"Zoning": "R1"
          +"NSAR_LM_Int4_8": 1424
          +"NSAR_LM_Int2_20": 0
          +"NSAR_LM_Int4_12": 351
          +"NSAR_LM_Int4_13": 0
          +"NSAR_LM_char5_1": "Main Floor"
          +"NSAR_LM_char5_2": "Main Floor"
          +"NSAR_LM_char5_3": "Main Floor"
          +"NSAR_LM_char5_4": "Main Floor"
          +"NSAR_LM_char5_5": "Main Floor"
          +"NSAR_LM_char5_6": "Main Floor"
          +"NSAR_LM_char5_7": "Main Floor"
          +"NSAR_LM_char5_8": "Main Floor"
          +"NSAR_LM_Char1_14": "Yes"
          +"NSAR_LM_char30_1": "21 x 11'5"
          +"NSAR_LM_char30_2": "15 x 13"
          +"NSAR_LM_char30_3": "5 x 8"
          +"NSAR_LM_char30_4": "14'4 x 14'4"
          +"NSAR_LM_char30_5": "5 x 6"
          +"NSAR_LM_char30_6": "13 x 11"
          +"NSAR_LM_char30_7": "11'6 x 11"
          +"NSAR_LM_char30_8": "Closet"
          +"NSAR_LM_char5_31": "Eat In Kitchen"
          +"NSAR_LM_char5_32": "Great Room"
          +"NSAR_LM_char5_33": "Bath 1"
          +"NSAR_LM_char5_34": "Primary Bedroom"
          +"NSAR_LM_char5_35": "Ensuite Bath 1"
          +"NSAR_LM_char5_36": "Bedroom"
          +"NSAR_LM_char5_37": "Bedroom"
          +"NSAR_LM_char5_38": "Laundry"
          +"NSAR_LA1_Char10_1": "N39404"
          +"NSAR_LA1_Char10_2": "N7128"
          +"NSAR_LA1_Char10_4": "1034726"
          +"NSAR_LA1_Char50_1": "N39404"
          +"NSAR_LM_Char10_20": "Yes"
          +"NSAR_LM_Char10_21": "No"
          +"NSAR_LM_Char10_22": "Yes"
          +"NSAR_LM_Char25_21": "1034726"
          +"NSAR_LM_Char25_23": "1007248"
          +"NSAR_LM_char10_49": "Subject to HST; included in purchase price"
          +"NSAR_LO1_Char10_4": "1007248"
          +"NSAR_LMD_MP_Quality": 1
          +"@odata.id": "https://api.realtyfeed.com/reso/odata/Property('ae8788ecbe94dce2ccbe87684ccf4815')"
          +"provider_name": "NSAR"
          +"Media": array:2 [
            0 => array:13 [
              "Order" => 1
              "MediaKey" => "ae8788ecbe94dce2ccbe87684ccf4815-m1"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/2f157c48a52227b5565837c199556f3b.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 34197
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/thumbnail-2f157c48a52227b5565837c199556f3b.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202519356_1"
              "ShortDescription" => null
              "ResourceRecordKey" => "ae8788ecbe94dce2ccbe87684ccf4815"
            ]
            1 => array:13 [
              "Order" => 2
              "MediaKey" => "ae8788ecbe94dce2ccbe87684ccf4815-m2"
              "MediaURL" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/c8f7f70a2ef0eca4c84a61c6427b95f6.webp"
              "MimeType" => "image/jpeg"
              "ClassName" => "Residential"
              "MediaSize" => 455981
              "MediaType" => "webp"
              "Thumbnail" => "https://cdn.realtyfeed.com/cdn/50/ae8788ecbe94dce2ccbe87684ccf4815/thumbnail-c8f7f70a2ef0eca4c84a61c6427b95f6.webp"
              "ResourceName" => "Property"
              "MediaCategory" => "Photo"
              "MediaObjectID" => "202519356_2"
              "ShortDescription" => null
              "ResourceRecordKey" => "ae8788ecbe94dce2ccbe87684ccf4815"
            ]
          ]
          +"ID": "51042"
        }
      ]
      +success: true
      +page_size: 1
      +page_count: 1
      +count: 1
      +after_key: ""
    }
    "RF Response Time" => "0.05 seconds"
  ]
]