Listing Details
object(stdClass) { StreetDirPrefix => null DistanceToStreetComments => null PublicSurveyRange => null LeaseAssignableYN => null GreenWaterConservation => null NumberOfUnitsMoMo => null CoListAgent2Nickname => null LivingAreaUnits => null CoListAgent2Email => null CoListAgent2HomePhone => null SeatingCapacity => null AboveGradeUnfinishedAreaUnits => null OriginatingSystemCoListAgent3MemberKey => null CoListAgent3MobilePhone => null TaxLegalDescription => null BuyerAgentDesignation => null YearEstablished => null BuyerTeamKey => null CoListOffice2Email => null ListPriceLow => null ContingentDate => null HumanModifiedYN => true LaundryFeatures => 'InBasement' Flooring => 'Hardwood,Varies,Vinyl' CoListOfficeNationalAssociationId => null PhotosCount => (int) 36 FireplacesTotal => (int) 0 DaysOnMarketReplicationDate => '2025-10-13' CoListAgent3FirstName => null ListTeamKey => null AdditionalParcelsYN => null WaterfrontFeatures => null CoBuyerAgentDirectPhone => null PastureArea => null SubAgencyCompensation => null SeniorCommunityYN => false ViewYN => null Cooling => null ExteriorFeatures => 'BlacktopDriveway,Fence' CountryRegion => null OtherParking => null IrrigationWaterRightsAcres => null SourceSystemID => 'TRESTLE' StatusChangeTimestamp => '2025-10-13T16:14:42.000-00:00' SecurityFeatures => null BuyerAgentFullName => null RVParkingDimensions => null CoBuyerAgentDesignation => null CoBuyerAgentNamePrefix => null OriginatingSystemBuyerTeamKey => null CoBuyerAgentLastName => null DocumentsCount => (int) 6 AssociationName => null DistanceToBusComments => null BuyerBrokerageCompensationType => null CoListAgentURL => null BuildingName => null YearsCurrentOwner => null DistanceToSchoolsComments => null ListAgentPreferredPhoneExt => null AssociationFeeFrequency => null CoListAgent3LastName => null CrossStreet => 'W Elm St' DelayedMarketingYN => null CoListAgent2OfficePhone => null FhaEligibility => null HeatingYN => true CoBuyerAgentStateLicense => null CoListAgent2StateLicense => null WaterBodyName => null ManagerExpense => null DistanceToSewerNumeric => null DistanceToGasComments => null CoBuyerAgentMiddleName => null AboveGradeFinishedArea => null CoListAgent2URL => null BuyerAgentFax => null ListingKeyNumeric => (int) 1139733693 MajorChangeType => 'NewListing' CoListAgent3StateLicense => null FrontageLengthUnit => null Appliances => 'Dryer,ExhaustFan,ElectricOven,ElectricRange,GasWaterHeater,Refrigerator,RangeHood,Washer' MLSAreaMajor => 'Oneida-Inside-251201' TaxAnnualAmount => (float) 3487 OriginatingSystemListAgentMemberKey => '24771929' CoListOffice2URL => null LandLeaseAmount => null Exposures => null BackOnMarketTimestamp => null CoBuyerAgentPreferredPhoneExt => null CoListAgentPreferredPhone => '315-247-9765' CurrentUse => null OriginatingSystemKey => '67631304' CountyOrParish => 'Madison' PropertyType => 'Residential' NumberOfPads => null TaxParcelLetter => null OriginatingSystemName => 'NYS' AssociationYN => null AvailableLeaseType => null MlsStatus => 'Active' CarrierRoute => null OriginatingSystemListOfficeKey => '40264301' BuyerOfficeURL => null CoListAgent2AOR => null PropertySubTypeAdditional => null GrossScheduledIncome => null StreetNumber => '215' UniversalPropertyId => 'US-36053-N-25120103007100010300000000-R-N' LeaseTerm => null ListingKey => '1139733693' CoBuyerAgentNameSuffix => null CoListAgentNamePrefix => null CoBuyerAgentNationalAssociationId => null CommonWalls => null AssociationPhone2 => null CountrySubdivision => '36053' ListAgentVoiceMail => null AssociationPhone3 => null CommonInterest => null ListAgentKeyNumeric => (int) 8389545 MaximumPetWeight => null CoListAgentLastName => 'Freeman' DualOrVariableRateCommissionYN => null ShowingContactType => null Vegetation => null IrrigationWaterRightsYN => null BuyerAgentMiddleName => null DistanceToFreewayComments => null ElementarySchool => null OriginatingSystemCoListAgentMemberKey => '25686776' StreetDirSuffix => null DistanceToSchoolsNumeric => null CoBuyerOfficePhone => null CoListOfficePhoneExt => null ListAgentFirstName => 'Douglas' CoListAgent2MiddleName => null DistanceToShoppingNumeric => null TaxMapNumber => null Directions => 'Main St to W Elm St to North St' AttachedGarageYN => false CoListAgent2PreferredPhone => null CoListAgent3URL => null OnMarketTimestamp => null DistanceToBusNumeric => null StandardStatus => 'Active' CultivatedArea => null Roof => 'Asphalt,Shingle' BuyerAgentNamePrefix => null EstimatedCloseDate => null ParkingTotal => null ContinentRegion => null ListAgentOfficePhone => '315-216-7648' SecurityDeposit => null BuyerTeamName => null CoListOfficeKeyNumeric => (int) 4246091 PetsComments => null DistanceToElectricUnits => null PoolPrivateYN => null AdditionalParcelsDescription => null Township => 'Not Applicable' ListingTerms => 'Cash,Conventional,FHA,VaLoan' NumberOfUnitsLeased => null FurnitureReplacementExpense => null DistanceToStreetUnits => null GardenerExpense => null BuyerAgentNameSuffix => null CoListAgent3HomePhone => null DistanceToSchoolBusUnits => null BuilderName => null BuyerAgentStateLicense => null ListOfficeEmail => 'kat@bellhometeam.com' CoListAgent3PreferredPhone => null CoListAgentFirstName => 'Nancy' PropertySubType => 'SingleFamilyResidence' BuyerAgentDirectPhone => null CoBuyerAgentPreferredPhone => null OtherExpense => null Possession => 'CloseOfEscrow' CoListAgentOfficePhone => '315-216-7648' DaysOnMarketReplication => (int) 0 BathroomsFull => (int) 1 WaterfrontYN => false LotSizeAcres => (float) 0.11 SubdivisionName => 'Gay's Add' SpecialLicenses => null BuyerOfficeAOR => null Fencing => 'Partial' InternetAddressDisplayYN => true LotSizeSource => null WithdrawnDate => null DistanceToWaterNumeric => null VideosCount => null Contingency => null FarmCreditServiceInclYN => null ListingService => null Elevation => null WaterSource => 'Connected,Public' CoListAgent2LastName => null Topography => null SubAgencyCompensationType => null CoListOffice2MlsId => null ProfessionalManagementExpense => null DistanceToFreewayUnits => null DoorFeatures => null StoriesTotal => (int) 2 YearBuilt => (int) 1920 CoListOffice2Name => null ElectricOnPropertyYN => null StateRegion => null MapCoordinateSource => null CoListAgent2DirectPhone => null CoListAgent3Email => null IrrigationSource => null CoListOfficeFax => null BathroomsPartial => null Disclaimer => null ZoningDescription => null LandLeaseYN => null PreviousListPrice => null CoListAgent3FullName => null VacancyAllowanceRate => null NumberOfSeparateWaterMeters => null DaysOnMarket => (int) 0 PetsAllowed => null CoBuyerAgentVoiceMailExt => null ListAgentFax => null NetOperatingIncome => null SerialXX => null OccupantType => null OtherStructures => null AssociationAmenities => null BodyType => null OriginatingSystemListTeamKey => null ClosePrice => null ListAgentDesignation => null BuyerAgentPreferredPhone => null DistanceToPhoneServiceComments => null PoolExpense => null PendingTimestamp => null CoBuyerAgentURL => null StreetNumberNumeric => (int) 215 CoListAgentOfficePhoneExt => null IncomeIncludes => null CoBuyerAgentVoiceMail => null LivingArea => (float) 1440 TaxAssessedValue => (int) 70100 BuyerTeamKeyNumeric => null CoListAgentKeyNumeric => (int) 8891254 CumulativeDaysOnMarket => (int) 0 CoListAgentStateLicense => '10401304573' ParkingFeatures => 'Detached,Garage' PostalCodePlus4 => null OriginatingSystemBuyerAgentMemberKey => null ListAgentPreferredPhone => '315-216-7648' CoListAgent3AOR => null BuyerOfficePhoneExt => null PoolFeatures => null BuyerAgentOfficePhoneExt => null NumberOfUnitsInCommunity => null CoListAgent2Key => null Heating => 'Gas,Baseboard,ForcedAir' StructureType => null BuildingAreaSource => 'PublicRecords' BathroomsOneQuarter => null BuilderModel => null CoBuyerAgentTollFreePhone => null TotalActualRent => null TrashExpense => null DistanceToStreetNumeric => null CoListAgentMlsId => 'freemanan' PublicSurveyTownship => null ListAgentMiddleName => null OwnerPays => null PetsAllowedYN => null BedroomsPossible => null BuyerAgentVoiceMailExt => null BuyerOfficePhone => null DaysOnMarketReplicationIncreasingYN => true ListingAgreement => 'ExclusiveRightToSell' PublicSurveySection => null RoadResponsibility => null CoListOfficeEmail => 'kat@bellhometeam.com' TenantPaysDescription => null UniversalPropertySubId => null AssociationName2 => null ListingId => 'S1643995' AssociationName3 => null DocumentsChangeTimestamp => '2025-10-13T15:40:59.000-00:00' AboveGradeUnfinishedArea => null CommunityFeatures => null BathroomsTotalInteger => (int) 1 ParkManagerName => null MapCoordinate => null RoomsTotal => (int) 6 DistanceToPlaceofWorshipComments => null ListAgentOfficePhoneExt => null BuildingAreaUnits => null City => 'Oneida' InternetEntireListingDisplayYN => true CropsIncludedYN => null BuyerAgentOfficePhone => null GrazingPermitsBlmYN => null ListingURL => null CoBuyerOfficeKeyNumeric => null LeaseExpiration => null ListAgentNameSuffix => null SerialX => null InternetAutomatedValuationDisplayYN => false BuyerAgentTollFreePhone => null SerialU => null TaxYear => null CoListAgent3Nickname => null DirectionFaces => null SourceSystemName => null PossibleUse => null Furnished => null CompensationComments => null DistanceToSchoolBusComments => null ConstructionMaterials => 'AluminumSiding,WoodSiding' SuppliesExpense => null ParcelSubcomponent => null ListOfficeURL => 'www.bellhometeam.com' RangeArea => null CoListAgent3Key => null OriginatingSystemCoListOffice2Key => null PreviousStandardStatus => null BuyerOfficeKey => null TaxOtherAnnualAssessmentAmount => (float) 0 OriginatingSystemBuyerOfficeKey => null InternetConsumerCommentYN => false WaterHeater => null BuildingAreaTotal => (float) 1440 YearBuiltSource => null OtherEquipment => null HabitableResidenceYN => null PestControlExpense => null SaleOrLeaseIndicator => null LaborInformation => null UniversalParcelId => 'urn:reso:upi:2.0:US:36053:251201-030-071-0001-030-000-0000' LandLeaseAmountFrequency => null CompSaleYN => null BedroomsTotal => (int) 3 UtilitiesExpense => null CoBuyerOfficeEmail => null CoListAgentDesignation => null CoListAgentDirectPhone => '315-247-9765' GreenSustainability => null CoolingYN => null InsuranceExpense => null ListAgentKey => '8389545' LeaseTermOptions => null CarportSpaces => null OnMarketDate => '2025-10-13' LotSizeUnits => 'Acres' ListAgentEmail => 'Douglas@bellhometeam.com' OriginatingSystemCoBuyerAgentMemberKey => null ContractStatusChangeDate => '2025-10-13' MajorChangeTimestamp => '2025-10-13T16:14:42.000-00:00' LeaseAmountFrequency => null ElevationUnits => null Permission => 'IDX' ActivationDate => null CoBuyerAgentEmail => null WalkScore => null GarageYN => true HoursDaysOfOperation => null BuyerAgentPreferredPhoneExt => null Make => null DistanceToWaterUnits => null AvailabilityDate => null Longitude => (float) -75.657442 TaxTract => null Skirt => null BuyerAgentURL => null RecordSignature => (int) -1794611201 BuyerOfficeFax => null CarportYN => null PublicRemarks => 'THIS FULLY UPDATED AND MOVE-IN READY HOME IN ONEIDA IS WAITING FOR YOU! PLEASE NOTE: HOUSE WAS PURCHASED IN JULY 2025 AND WAS RENOVATED BY CURRENT OWNER FOR A FAMILY MEMBER WHOSE PLANS CHANGED. IT WAS NOT A FLIP AND RENOVATIONS ARE WELL DONE AND READY FOR YOU TO ENJOY! This home is full of character and charm, boasting natural woodwork, gleaming hardwood floors, built-ins, sparkling new appliances, & coffered ceilings. The massive list of improvements can be found in the disclosures, but to mention just a few: all new windows on second floor & basement; all new appliances; all new plumbing & fixtures in the bathroom; new glass door panels; original floor & ceiling on front porch restored & sealed; freshly painted throughout; hardwood floors sanded, cleaned & top-coated; updated electrical wiring; waterproof/mold resistant sealer on basement walls; and many more improvements too numerous to detail here. This home has it all - located in the heart of Oneida, near major highways, dining, shopping, and entertainment, not to mention less than 30 minutes from Syracuse. Don't miss your opportunity to see this stunning home!' FinancialDataSource => null OriginatingSystemCoBuyerOfficeKey => null CoListAgent3MlsId => null CoBuyerAgentKey => null PostalCity => 'Oneida' CurrentFinancing => null CableTvExpense => null NumberOfSeparateElectricMeters => null ElementarySchoolDistrict => 'Oneida' NumberOfFullTimeEmployees => null OffMarketTimestamp => null CoBuyerOfficeFax => null CoBuyerAgentFirstName => null CoBuyerAgentPager => null CoListOfficeName => 'Bell Home Team' PurchaseContractDate => null ListAgentVoiceMailExt => null RoadSurfaceType => null ListAgentPager => null PriceChangeTimestamp => null MapURL => null BelowGradeUnfinishedAreaUnits => null CoListAgentPager => null LeasableArea => null ListingContractDate => '2025-10-13' MLSAreaMinor => null CoListOfficeKey => '4246091' FarmLandAreaUnits => null ListOfficeNationalAssociationId => null Zoning => null ListAgentAOR => null CoBuyerAgentKeyNumeric => null BelowGradeUnfinishedAreaSource => null GreenIndoorAirQuality => null LivingAreaSource => null MaintenanceExpense => null BuyerAgentVoiceMail => null DistanceToElectricNumeric => null ListAOR => 'Syracuse' CoListAgent3NationalAssociationId => null CoBuyerOfficeName => null ListOfficeName => 'Bell Home Team' BelowGradeFinishedArea => null CoListAgentTollFreePhone => null TaxBlock => null BuyerFinancing => null CoListAgent3OfficePhone => null GreenLocation => null MobileWidth => null GrazingPermitsPrivateYN => null Basement => 'Full' BusinessType => null NumberOfSeparateGasMeters => null Latitude => (float) 43.096601 PhotosChangeTimestamp => '2025-10-13T20:15:31.030-00:00' ListPrice => (float) 214900 BuyerAgentKeyNumeric => null ListAgentTollFreePhone => null RoadFrontageType => 'CityStreet' DistanceToGasUnits => null AboveGradeUnfinishedAreaSource => null DistanceToPlaceofWorshipNumeric => null ListOfficePhone => '315-216-7648' CoListAgentFax => null GreenEnergyGeneration => null DOH1 => null DOH2 => null DOH3 => null FoundationArea => null CoListAgent2NationalAssociationId => null X_GeocodeSource => null ListingURLDescription => null AssociationFee3Frequency => null BelowGradeFinishedAreaSource => null CoBuyerOfficeKey => null ElectricExpense => null CoListOfficeMlsId => 'BHTM01' DistanceToElectricComments => null CoBuyerOfficePhoneExt => null AssociationFee2Frequency => null CoListAgentVoiceMailExt => null OpenHouseModificationTimestamp => null StateOrProvince => 'NY' AboveGradeFinishedAreaUnits => null DistanceToSewerComments => null OriginatingSystemCoListOfficeKey => '40264301' ListOfficeAOR => null StreetAdditionalInfo => null GreenBuildingVerificationType => null CoveredSpaces => null MiddleOrJuniorSchool => 'Otto L Shortell Middle' DelayedMarketingDate => null AssociationFeeIncludes => null SyndicateTo => 'Realtorcom' VirtualTourURLUnbranded => null BasementYN => true CoListAgentEmail => 'nancy@bellhometeam.com' LandLeaseExpirationDate => null OriginatingSystemSubName => 'NYS_S' FrontageLength => null WorkmansCompensationExpense => null ListOfficeKeyNumeric => (int) 4246091 CoListOfficeAOR => null Disclosures => null BelowGradeUnfinishedArea => null ListOfficeKey => '4246091' DistanceToGasNumeric => null FireplaceYN => false BathroomsThreeQuarter => null EntryLevel => null ListAgentFullName => 'Douglas Freeman' YearBuiltEffective => null TaxBookNumber => null DistanceToSchoolBusNumeric => null ShowingContactPhoneExt => null MainLevelBathrooms => (int) 0 CoListAgent2FullName => null BuyerAgentNationalAssociationId => null PropertyCondition => 'Resale' FrontageType => null Stories => (int) 2 DevelopmentStatus => null GrossIncome => null CoListAgent2MobilePhone => null ParcelNumber => '251201-030-071-0001-030-000-0000' CoBuyerAgentAOR => null UnitsFurnished => null FuelExpense => null PowerProductionYN => null CoListAgentVoiceMail => null FoundationDetails => 'Block' View => null OperatingExpense => null SignOnPropertyYN => null LeaseRenewalOptionYN => null LeaseRenewalCompensation => null YearBuiltDetails => 'Existing' GreenVerificationYN => null BuyerAgentPager => null HighSchool => 'Oneida Senior High' LeaseConsideredYN => null HomeWarrantyYN => null Levels => 'Two' OperatingExpenseIncludes => null StreetSuffixModifier => null DistanceToFreewayNumeric => null AttributionContact => null ListAgentLastName => 'Freeman' ListAgentURL => null VirtualTourURLBranded2 => null InteriorFeatures => 'BreakfastBar,CeilingFans,SeparateFormalDiningRoom,SeparateFormalLivingRoom,NaturalWoodwork' VirtualTourURLBranded3 => null OffMarketDate => null CoBuyerAgentMlsId => null PowerProductionType => null DistanceToPhoneServiceNumeric => null DistanceToWaterComments => null CloseDate => null StreetSuffix => 'Street' ListAgentMlsId => 'FREEMADO' DistanceToPhoneServiceUnits => null HorseAmenities => null ListOfficePhoneExt => null CoListAgentNameSuffix => null WaterSewerExpense => null GrazingPermitsForestServiceYN => null LotSizeDimensions => '50X100' ModificationTimestamp => '2025-10-13T20:15:31.030-00:00' PropertyAttachedYN => null BuyerAgentKey => null TaxLot => '30' BusinessName => null BuyerAgentEmail => null ListAgentNationalAssociationId => '639090877' CoBuyerOfficeMlsId => null ListAgentNamePrefix => null OriginatingSystemID => null BackOnMarketDate => null CoListAgentNationalAssociationId => '639090992' CoListAgent2FirstName => null HorseYN => null LotDimensionsSource => null Country => null UnitNumber => null CoListAgentPreferredPhoneExt => null OpenParkingYN => null TransactionBrokerCompensation => null LeasableAreaUnits => null PetDeposit => null MobileLength => null CoBuyerOfficeAOR => null NumberOfUnitsVacant => null ListOfficeMlsId => 'BHTM01' Inclusions => null ListTeamKeyNumeric => null OriginatingSystemModificationTimestamp => null CLIP => null ListAgentDirectPhone => '315-216-7648' CoBuyerAgentOfficePhone => null VacancyAllowance => null RoomType => 'Laundry,LivingRoom' VirtualTourURLBranded => null AssociationPhone => null CoListAgentFullName => 'Nancy J Freeman' CoListAgentKey => '8891254' BelowGradeFinishedAreaUnits => null CoListOfficeURL => 'www.bellhometeam.com' CoListAgentMiddleName => 'J' RentControlYN => null EntryLocation => null SpaYN => null SpaFeatures => null CoListAgent3MiddleName => null ShowingContactPhone => 'Showing Serv' BuyerAgentFirstName => null DistanceToPlaceofWorshipUnits => null ExistingLeaseType => null BathroomsHalf => (int) 0 CoBuyerOfficeNationalAssociationId => null LotSizeArea => (float) 0.11 Sewer => 'Connected' SyndicationRemarks => null Model => null BuyerAgentLastName => null ListAgentStateLicense => '10301221801' FrontageLengthRemarks => null StreetName => 'North' AboveGradeFinishedAreaSource => null ListOfficeFax => null AnchorsCoTenants => null PatioAndPorchFeatures => 'Open,Porch' NumberOfLots => null ParkManagerPhone => null ListTeamName => null MainLevelBedrooms => (int) 0 CoListOffice2Key => null NumberOfPartTimeEmployees => null CityRegion => null Utilities => 'CableAvailable,ElectricityConnected,HighSpeedInternetAvailable,SewerConnected,WaterConnected' DistanceToBusUnits => null OngoingFees => null FireplaceFeatures => null ListAgentNickname => null WindowFeatures => 'ThermalWindows' SpecialListingConditions => 'Standard' NewConstructionYN => null BuyerAgentAOR => null ParkName => null NumberOfBuildings => null GarageSpaces => (float) 1 OriginalListPrice => (float) 214900 AssociationFee2 => null HoursDaysOfOperationDescription => null AssociationFee3 => null GreenEnergyEfficient => 'Appliances,Windows' CapRate => null StartShowingDate => null RentIncludes => null DistanceToSchoolsUnits => null CoListAgentNickname => null CoListAgent3DirectPhone => null BuyerOfficeKeyNumeric => null MoveInCosts => null VirtualTourURLUnbranded3 => null UnitTypeType => null VirtualTourURLUnbranded2 => null AccessibilityFeatures => null FarmLandAreaSource => null HighSchoolDistrict => 'Oneida' CoListOffice2Phone => null BuildingFeatures => null OriginalEntryTimestamp => '2025-10-13T16:14:42.000-00:00' OwnershipType => null SourceSystemKey => '1139733693' BuyerAgentMlsId => null Ownership => null Exclusions => null CopyrightNotice => null MobileDimUnits => null ShowingContactName => null LotFeatures => 'Rectangular,RectangularLot,ResidentialLot' CoBuyerAgentOfficePhoneExt => null License3 => null PostalCode => '13421' License1 => null License2 => null BuyerOfficeMlsId => null DocumentsAvailable => null DistanceToShoppingUnits => null NumberOfUnitsTotal => (int) 0 BuyerOfficeName => null AssociationFee => null LeaseAmount => null LotSizeSquareFeet => (float) 4792 DistanceToSewerUnits => null CoBuyerAgentFullName => null TenantPays => null DistanceToShoppingComments => null MiddleOrJuniorSchoolDistrict => 'Oneida' CoListAgent2MlsId => null OriginatingSystemCoListAgent2MemberKey => null BuyerOfficeNationalAssociationId => null CoListOffice2AOR => null Electric => 'CircuitBreakers' ArchitecturalStyle => 'HistoricAntique' MobileHomeRemainsYN => null VideosChangeTimestamp => null NewTaxesExpense => null BuyerBrokerageCompensation => null CoBuyerOfficeURL => null TaxStatusCurrent => null UnparsedAddress => '215 North Street' MaximumNumberOfPets => null OpenParkingSpaces => null CoListOfficePhone => '315-216-7648' CurrentPrice => (float) 214900 WoodedArea => null TransactionBrokerCompensationType => null LicensesExpense => null BuyerOfficeEmail => null CoListAgentAOR => null CoBuyerAgentFax => null Media => [ (int) 0 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651518' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Prepare to be impressed when you enter this charmi' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 1 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/1/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/5tflACpHnFoXq-prR48HoduQAtqBSeMXEi3Nrr0-5Bw' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883117 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883117' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-1.jpg' SourceSystemMediaKey => '67651518' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Prepare to be impressed when you enter this charming old style home that has been lovingly restored and updated while maintaining the home's unique character. Located in the heart of Oneida, this home is ready for you to move in and love!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 1 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651519' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The home may be entered from the front porch throu' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 2 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/2/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/1k033_0U3jgbGwaK5mujjDotgm4035rfH4roX9X46G4' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883118 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883118' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-2.jpg' SourceSystemMediaKey => '67651519' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The home may be entered from the front porch through the front door, from the driveway through the convenient side door, or from the backyard through a back door directly into the kitchen. Here you also see the close proximity of the detached garage.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 2 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651520' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The original fir wood floor on this fabulous front' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 3 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/3/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/8qokyPEWMR2Y8SHjwtmoG3mKvvr8wM5q7HAVnoKaYcw' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883119 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883119' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-3.jpg' SourceSystemMediaKey => '67651520' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The original fir wood floor on this fabulous front porch was restored and sealed. Imagine sitting out here Spring, Summer, and Fall to enjoy the peaceful neighborhood setting or to entertain friends and family!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 3 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651521' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'This stunning porch is the perfect spot to relax!' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 4 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/4/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/y4zXYcq09jDPwcaBIhAsVVmv3gFga1ypaGF9vSR7Fx4' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883120 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883120' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-4.jpg' SourceSystemMediaKey => '67651521' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'This stunning porch is the perfect spot to relax!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 4 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651522' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Enter the home through this gorgeous solid wood do' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 5 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/5/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/FzOdcKpLCbDPX_nZ3yRzR2R0rd8PJ_TG3jEvoios4og' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883121 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883121' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-5.jpg' SourceSystemMediaKey => '67651522' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Enter the home through this gorgeous solid wood door. Immediately to your left is a large cedar closet, with plenty of room to remove shoes, boots, and coats.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 5 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651523' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'From the front door, one can head upstairs, straig' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 6 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/6/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/VSiWnpZaxbaGHIN52mXUpSi_Wwb8doURShJlLCx-ypE' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883122 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883122' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-6.jpg' SourceSystemMediaKey => '67651523' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'From the front door, one can head upstairs, straight into the kitchen, or right to the living room. Note the huge window. gleaming hardwood floors and gorgeous wood banister and trim.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 6 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651524' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Entering the living room you will find a striking' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 7 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/7/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/eXuS8BkQcRCgy91XtKGBU573cflY5m0jKH1uqq9t-ig' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883123 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883123' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-7.jpg' SourceSystemMediaKey => '67651524' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Entering the living room you will find a striking coffered ceiling that adds depth and dimension to the room, and creates authenticity to the space.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 7 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651527' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The natural wood built-ins have been updated with' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 8 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/8/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/zQ9r3NLNcAQqN_WMz7DoqwnER0y7fb4oA9_3DF73uJ4' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883126 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883126' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-10.jpg' SourceSystemMediaKey => '67651527' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The natural wood built-ins have been updated with safety glass inserts giving them timeless beauty and character. The hardwood floors shine with all the glorious natural light that floods in from both the front and the back of the house through the large windows.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 8 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651525' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'A look back toward the front door,, you see the sp' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 9 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/9/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/M7WZdv1dsVYxmsdqB4Vn48TrHM1v-VPFrA8N7BhE8cU' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883124 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883124' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-8.jpg' SourceSystemMediaKey => '67651525' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'A look back toward the front door,, you see the spectacular French doors, again adding charm and period correct authenticity to this home.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 9 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651526' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The house boasts beautiful windows, framed by natu' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 10 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/10/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/cwbVyNvgjQT3va3oMljvbMMZHCmeudjGAh2QYw_ECew' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883125 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883125' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-9.jpg' SourceSystemMediaKey => '67651526' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The house boasts beautiful windows, framed by natural woodwork.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 10 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651528' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Entering the formal dining room, you find the same' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 11 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/11/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/9AljrJPRnWB2wdvOEFy5hyVqJs8WaAymWBeictfN-FI' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883127 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883127' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-11.jpg' SourceSystemMediaKey => '67651528' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Entering the formal dining room, you find the same coffered ceiling and lovingly restored built-in shelves providing the perfect space to display decor, pictures and books. The possibilities for holiday decorating here are endless!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 11 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651529' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The dining room contains a breakfast bar the could' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 12 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/12/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/dmz0c81MOMTpMDQ-_rMpa3Udfgyv-j5jk9tkYxzrnJc' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883128 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883128' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-12.jpg' SourceSystemMediaKey => '67651529' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The dining room contains a breakfast bar the could also serve as an awesome coffee bar or wine/cocktail area! In addition, a built-in seating area serves as extra space around the table!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 12 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651531' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'In addition to connecting to the living room, the' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 13 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/13/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/H_JnkP9_b_olnWZ6a_3kTF9_HRP1LWs3M9Ipu7SqYhg' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883130 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883130' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-14.jpg' SourceSystemMediaKey => '67651531' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'In addition to connecting to the living room, the dining room conveniently flows right into the kitchen, making entertainment seamless in this space.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 13 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651532' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'A new vinyl plank floor adds warmth and beauty to' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 14 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/14/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/xnYHPHuAvvYsB6wCpyHDPdQC7PAb1DX3oEK6P-2G-xk' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883131 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883131' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-15.jpg' SourceSystemMediaKey => '67651532' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'A new vinyl plank floor adds warmth and beauty to the kitchen. The wrought iron railing was sandblasted and repainted and keeps an open feeling to the space. From the kitchen, you can head out back, out to the driveway, or down to the basement.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 14 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651533' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'This authentic brick chimney adds warmth and chara' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 15 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/15/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/U8D9sBjCnG7avP1OABoof5oSVcpI7BQNotD_ZpAc-dQ' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883132 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883132' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-16.jpg' SourceSystemMediaKey => '67651533' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'This authentic brick chimney adds warmth and character to this large kitchen. The solid wood cabinets were cleaned and polished and provide an abundance of space.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 15 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651534' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The huge windows overlook the backyard and provide' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 16 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/16/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/M6QiIcEyh67DOcXTnZdcB_Iegf7_YT_Zh9JtyaYOQrc' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883133 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883133' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-17.jpg' SourceSystemMediaKey => '67651534' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The huge windows overlook the backyard and provide glorious natural light to the kitchen. The double stainless steel sink and new faucet make clean-up a breeze! And the refrigerator and stove are brand new!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 16 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651536' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Another look at this wonderful space with a peek i' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 17 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/17/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/YszGD99__6IlVga-yrDEz-1bQ930H69WfxQsqKylQNo' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883105 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883105' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-19.jpg' SourceSystemMediaKey => '67651536' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Another look at this wonderful space with a peek into the dining room and outside.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 17 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651537' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Amazing backsplash and countertops provide plenty' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 18 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/18/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/KTyRUnRya91NxEUVi-33Pi2tbEIHhE3t9NmIbTP4Rzs' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883106 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883106' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-20.jpg' SourceSystemMediaKey => '67651537' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Amazing backsplash and countertops provide plenty of workspace in this charming kitchen.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 18 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651538' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'More cupboard space abounds near the well-placed,' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 19 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/19/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/UnpKn_UWN5ptYBLMPVQ94av3BWJiIMz1JrATgm7hxIk' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883107 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883107' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-21.jpg' SourceSystemMediaKey => '67651538' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'More cupboard space abounds near the well-placed, energy efficient appliances.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 19 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651535' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The floor plan flows beautifully, and heading back' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 20 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/20/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/NOtgtRXOhnadxIbMLFMfdf1QgYkWnAc-GTbwVppWXu0' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883134 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883134' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-18.jpg' SourceSystemMediaKey => '67651535' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The floor plan flows beautifully, and heading back toward the front door, we will explore the bedroom level of the home.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 20 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651539' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'This totally updated bathroom is conveniently loca' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 21 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/21/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/vvGNutnghz-2STJ6i7gVPnN9WoVe-lf59dfo9ZQdnMQ' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883108 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883108' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-22.jpg' SourceSystemMediaKey => '67651539' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'This totally updated bathroom is conveniently located at the top of the stairs on the second floor. It boasts all new fixtures, plumbing and flooring.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 21 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651540' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'This bright and cheery room is also warm and cozy' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 22 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/22/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/tYPN2o5n4p1F2IrB_EcF640O3E4eaDWpVPBKSN61sk4' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883109 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883109' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-23.jpg' SourceSystemMediaKey => '67651540' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'This bright and cheery room is also warm and cozy with the radiator and natural wood trim.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 22 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651543' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The primary bedroom receives fantastic light and r' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 23 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/23/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/h7UK7e--i1qZ9N-Bu36m5_N_ANJtpGqBwPjIP-jsdnI' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883112 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883112' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-26.jpg' SourceSystemMediaKey => '67651543' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The primary bedroom receives fantastic light and refreshing breezes from these new windows. It is a generous size that will accommodate large bedroom furniture.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 23 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651544' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Another vantage point of the large primary bedroom' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 24 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/24/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/nVGoOe7dTNqedRDFa3cOkkrAUg2CxULDQ4e24s8IdyY' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883113 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883113' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-27.jpg' SourceSystemMediaKey => '67651544' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Another vantage point of the large primary bedroom and its closet and stunning wood floors.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 24 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651541' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Bedroom #2 is large and continues the home's theme' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 25 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/25/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/HhZ6c-Sv-aG503DjwdkbwFgL3OzBXwjIWsZgU4dsmEc' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883110 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883110' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-24.jpg' SourceSystemMediaKey => '67651541' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Bedroom #2 is large and continues the home's theme of natural wood floors and trim around the new windows.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 25 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651542' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'A look out into the hallway and the closet in this' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 26 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/26/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/eP2Y4fI7PuXB0A_n67Aq5viWKuRdb-FZik5B-T6fSd0' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883111 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883111' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-25.jpg' SourceSystemMediaKey => '67651542' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'A look out into the hallway and the closet in this bedroom shows the warmth and beauty of all the wood flooring and trim.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 26 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651545' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Bedroom #3 provides more of the same beauty! Anoth' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 27 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/27/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/D-p-G7PWQn0yxtiM8mHJ5s44_LkcVpM1i0zc5C6wYRM' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883114 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883114' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-28.jpg' SourceSystemMediaKey => '67651545' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Bedroom #3 provides more of the same beauty! Another good-sized room with large new windows.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 27 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651546' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'A look back toward the hallway from bedroom #3.' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 28 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/28/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/pE6DgPVg_JARcP-5Byt7FJnqj_B4QpRDRcMER30Ag6c' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883115 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883115' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-29.jpg' SourceSystemMediaKey => '67651546' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'A look back toward the hallway from bedroom #3.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 28 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651547' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'A full walk up attic awaits you, providing plenty' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 29 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/29/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/OgWt_0qBPwTO4kRLL5LbAJ6iZ1lBuCcJyCUxeTGqlow' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496883116 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496883116' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-30.jpg' SourceSystemMediaKey => '67651547' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'A full walk up attic awaits you, providing plenty of dry storage space.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 29 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651548' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The basement in this home is beautifully clean and' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 30 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/30/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/bsV1IuY9WS680snlEZtz0f8D3fdN45a2EfIXyyRTLMM' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884350 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884350' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-31.jpg' SourceSystemMediaKey => '67651548' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The basement in this home is beautifully clean and dry!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 30 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651549' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The basement is complete with a brand new washer a' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 31 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/31/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/stWWIa7gMqWpLBEFfz3-SM7YFrp_Kfce4GHUEBxrg5M' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884351 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884351' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-32.jpg' SourceSystemMediaKey => '67651549' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The basement is complete with a brand new washer and dryer.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 31 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651550' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Limitless opportunities await you if you'd like to' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 32 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/32/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/ZaK8EstkRWbXFeYq3jwHu3vRo5_xvW-Ci7N8vE19o7o' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884352 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884352' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-33.jpg' SourceSystemMediaKey => '67651550' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Limitless opportunities await you if you'd like to make this space even better - perhaps an exercise room, playroom, or media room!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 32 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651551' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'Everything is clean and in excellent condition!' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 33 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/33/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/rZyKfZ2w-KuZ_VTjiJ2Kn6SEluNm8Ae03cpwY1YCzWU' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884353 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884353' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-34.jpg' SourceSystemMediaKey => '67651551' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'Everything is clean and in excellent condition!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 33 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651553' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'The backyard is partially fenced and provides grea' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 34 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/34/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/HZMtLek99gY28fqAWGZM1YIDlTxUOnnf5TqkW9RugMU' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884355 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884355' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-36.jpg' SourceSystemMediaKey => '67651553' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'The backyard is partially fenced and provides great space for outdoor activities. The garage is conveniently located near the house.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 34 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651554' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'To conclude our tour, here is a full floor plan to' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 35 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/35/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/HrO9C4mYiACWc-zS5aX0-_DvqqHsvqHmuZEIhaWZZc0' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884356 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884356' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-41.jpg' SourceSystemMediaKey => '67651554' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'To conclude our tour, here is a full floor plan to pull the entire space together and visualize the entire home.' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null }, (int) 35 => object(stdClass) { OffMarketDate => null ResourceRecordKey => '1139733693' ResourceName => 'Property' OriginatingSystemMediaKey => '67651552' PropertyType => 'Residential' ListAgentKey => '8389545' ShortDescription => 'This property offers everything you need - a fully' OriginatingSystemName => 'NYS' ImageWidth => null HumanModifiedYN => false Permission => null MediaType => 'Jpeg' PropertySubTypeAdditional => null ResourceRecordID => 'S1643995' ModificationTimestamp => '2025-10-13T20:15:09.337-00:00' ImageSizeDescription => null MediaStatus => 'Active' Order => (int) 36 MediaURL => 'https://api-trestle.corelogic.com/trestle/Media/Property/PHOTO-Jpeg/1139733693/36/MzYxNi8yMzc0LzIw/MjAvNTY0OC8xNzYwMzk4OTA3/QnRp6KsJgDFr7tK_vVh5hTA-vKWYlY2naqp5o1lxt9U' SourceSystemID => 'TRESTLE' InternetEntireListingDisplayYN => true OriginatingSystemID => null MediaKeyNumeric => (int) 2004496884354 OriginatingSystemResourceRecordKey => '67631304' SyndicateTo => 'Realtorcom' ListingPermission => 'IDX' ChangedByMemberKey => null ImageHeight => null RecordSignature => (int) -600012855 OriginatingSystemSubName => 'NYS_S' ListOfficeKey => '4246091' MediaModificationTimestamp => '2025-10-13T20:15:09.337-00:00' SourceSystemName => null ListOfficeMlsId => 'BHTM01' StandardStatus => 'Active' MediaKey => '2004496884354' ResourceRecordKeyNumeric => (int) 1139733693 ChangedByMemberID => null ChangedByMemberKeyNumeric => null ClassName => null ImageOf => null MediaCategory => 'Photo' MediaObjectID => '215 north street-35.jpg' SourceSystemMediaKey => '67651552' MediaHTML => null PropertySubType => 'SingleFamilyResidence' PreferredPhotoYN => null LongDescription => 'This property offers everything you need - a fully renovated, move-in ready home near downtown Oneida with nearby shopping, restaurants, entertainment, and major highways. Don't miss your chance to see this beauty!' ListAOR => 'Syracuse' MediaClassification => 'PHOTO' X_MediaStream => null OriginatingSystemResourceRecordId => null MediaAlteration => null MediaStatusDescription => null SourceSystemResourceRecordKey => null } ] ListAgentMobilePhone => null ListAgentHomePhone => null LockBoxLocation => null LockBoxSerialNumber => null LockBoxType => null ExpirationDate => null OwnerPhone => null OccupantName => null OccupantPhone => null OwnerName => null PrivateOfficeRemarks => null ShowingDays => null ShowingEndTime => null ShowingInstructions => null ShowingRequirements => null ShowingStartTime => null ShowingAttendedYN => null ShowingAdvanceNotice => null PrivateRemarks => null CoListAgentHomePhone => null CoBuyerAgentHomePhone => null CoBuyerAgentMobilePhone => null CoListAgentMobilePhone => null ConcessionsComments => null ConcessionsAmount => null Concessions => null AccessCode => null CancellationDate => null BuyerAgentMobilePhone => null BuyerAgentHomePhone => null OwnerName2 => null ShowingConsiderations => null ShowingServiceName => null ConcessionInPrice => null ConcessionInPriceType => null ConcessionsBuyerBrokerFee => null ConcessionsClosingCosts => null ConcessionsFinancingCosts => null ConcessionsOtherCosts => null ConcessionsPropertyImprovementCosts => null SellerConsiderConcessionYN => null HeadBrokerMemberKey => null HeadBrokerMemberMlsId => null user => object(App\Model\Entity\User) { 'id' => '5e7b29a4-7deb-4ee3-8834-d8b1dd5fac74', 'username' => 'agnieszka', 'avatar' => 'https://lh3.googleusercontent.com/a/ACg8ocLzyA-wfZTN9LFjifIQnsHqy_kRFSunVSHmzjrTtJX85rK1BwjybQ=s96-c', 'email' => 'agnieszka.bajan@gmail.com', 'password' => '$2y$10$XtNNIrN3OTMC.0oQdpQTMOWE7kjLrOSn08M0pQ1CdtNi5DVpiOmde', 'first_name' => 'Agnieszka', 'last_name' => 'BAJAN', 'token' => '{"access_token":"ya29.A0ARrdaM_4N2RGVPMB1VrKJ2spf9VOfa3_C_YPEWEAB5q4JYqWCorWq0iHmLLYmn1-DCZDfCt3P98O2n9bCpOM4WrzZ91GlL_CRBV0E2d50Hye14DpgXlQH6DUUWeWHMnzZcAH0aCr86XsmQA1aAKlAbyI052Z","expires_in":3599,"refresh_token":"1\/\/04nHK7ScLNxlmCgYIARAAGAQSNwF-L9IrWhU4qhijdLReaANwCXL8DNutO5e5InhbMLk4W9j2l3G7UmUYTTZR1ImWs7nD_Ni_VWQ","scope":"https:\/\/www.googleapis.com\/auth\/youtube https:\/\/www.googleapis.com\/auth\/userinfo.email https:\/\/www.googleapis.com\/auth\/analytics https:\/\/www.googleapis.com\/auth\/tasks https:\/\/www.googleapis.com\/auth\/drive https:\/\/www.googleapis.com\/auth\/photoslibrary openid https:\/\/www.googleapis.com\/auth\/contacts https:\/\/www.googleapis.com\/auth\/userinfo.profile https:\/\/mail.google.com\/ https:\/\/www.googleapis.com\/auth\/calendar","token_type":"Bearer","id_token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjllYWEwMjZmNjM1MTU3ZGZhZDUzMmU0MTgzYTZiODIzZDc1MmFkMWQiLCJ0eXAiOiJKV1QifQ.eyJpc3MiOiJodHRwczovL2FjY291bnRzLmdvb2dsZS5jb20iLCJhenAiOiI1MjI3MDAwNzIyMTYtNWJrdWl0NnRxcTBucmd2ZHMxZGZoYnF1dG9wMm5xdTMuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJhdWQiOiI1MjI3MDAwNzIyMTYtNWJrdWl0NnRxcTBucmd2ZHMxZGZoYnF1dG9wMm5xdTMuYXBwcy5nb29nbGV1c2VyY29udGVudC5jb20iLCJzdWIiOiIxMTM2MjQzMjQ2MTgyNjk2MzUyNzciLCJlbWFpbCI6ImFnbmllc3prYS5iYWphbkBnbWFpbC5jb20iLCJlbWFpbF92ZXJpZmllZCI6dHJ1ZSwiYXRfaGFzaCI6IlVrM05JT1pYY2xiUGxENUZHZ2NFY0EiLCJuYW1lIjoiQWduaWVzemthIEJBSkFOIiwicGljdHVyZSI6Imh0dHBzOi8vbGgzLmdvb2dsZXVzZXJjb250ZW50LmNvbS9hLS9BT2gxNEdoQmxKTDRuUGJ4eHpURWxheHJDeUUxZ3lWZ0RMdzZSTjFyVTBTRWprST1zOTYtYyIsImdpdmVuX25hbWUiOiJBZ25pZXN6a2EiLCJmYW1pbHlfbmFtZSI6IkJBSkFOIiwibG9jYWxlIjoiZW4iLCJpYXQiOjE2NDMyNDk4NTEsImV4cCI6MTY0MzI1MzQ1MX0.PxvEYrW23zFSy49MFZ-S01lonK6wJU5dALiBk8Q1SnuObmjPL2BTAVhpt2eIipCuuIacSB2FrTYvMQ7c1MOc8qFP6_9qs09gaSSUS9G5zUhtoExZ-GcYBe5DurwZFBw1RorBhp_vQel5YxXW_BFtm_Cwpv5Rc8OcF5vcrX-HLeWXYGLRmVcXTqqE_DTYwIH-aqIOJ07JWEDR2pchZhN19XevFhz6DfNVEOrHbkFzGn3ynFkpjpwtRlL6KCJhn-kw0pTM-0e9dg0hb3MjOAJaHhJLu1a81mWmWlAv5EpZfUnxlmj0NGVLS-U5E2gr9W_Hnfe25SMjMRu3r7PLyAQGpQ","created":1643249851}', 'token_expires' => null, 'api_token' => null, 'activation_date' => object(Cake\I18n\FrozenTime) { 'time' => '2021-03-03 14:44:10.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'secret' => null, 'secret_verified' => null, 'tos_date' => object(Cake\I18n\FrozenTime) { 'time' => '2021-03-03 14:44:10.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'active' => true, 'is_superuser' => false, 'role' => 'user', 'login' => object(Cake\I18n\FrozenTime) { 'time' => '2025-10-05 13:53:59.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'picture_id' => (int) 5, 'created' => object(Cake\I18n\FrozenTime) { 'time' => '2021-03-03 14:44:10.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\FrozenTime) { 'time' => '2025-10-05 13:53:59.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'additional_data' => null, 'picture' => object(App\Model\Entity\Picture) { 'id' => (int) 5, 'name' => '6054a4735851d-IMGP3421.jpg', 'title' => null, 'path' => '/var/www/agnieszka.realtor/www/webroot/img/uploads', 'type' => 'image/jpeg', 'size' => '109959', 'created' => object(Cake\I18n\FrozenTime) { 'time' => '2020-07-05 13:29:50.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\FrozenTime) { 'time' => '2021-03-19 09:17:49.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, '[new]' => false, '[accessible]' => [ 'name' => true, 'title' => true, 'path' => true, 'type' => true, 'size' => true, 'articles' => true, 'users' => true, 'contacts' => true, 'reviews' => true, 'properties' => true, 'listings' => true, 'communities' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[hasErrors]' => false, '[errors]' => [], '[invalid]' => [], '[repository]' => 'Pictures' }, 'profile' => object(App\Model\Entity\Profile) { 'id' => (int) 1, 'firstname' => 'Agnieszka', 'lastname' => 'Bajan', 'company' => 'Empire Realty Group', 'position' => 'Associate Broker', 'bio' => 'Professional… Real Estate is my true passion! I’ve bought, sold, rented, leased, flipped residential and commercial properties during the 12+ years I’ve been a licensed Realtor in New York State. I know that once you have made a decision to buy or sell, you want to make it happen now. It's my goal to make your experience pleasant, comfortable and fun. I am flexible, committed and pride myself on being available on-your-schedule. When selling, my marketing strategy is personalized utilizing the latest up to date professional tools to best fit and showcase your property. When buying, I make sure you understand and see all possible options to best fit your budget and desired timeframe. My expertise and attention to detail will help you achieve your desired real estate goals. Bottom line…if you’re looking to buy or sell a home in the Greater Rochester Area call, text or email me today! My family… My wonderful husband Robert has been building trains for Alstom Transportation for the past 20 years. I am the mother of two actively involved children, Nadia and Alex. When I am not working Real Estate, I am their chauffeur. Aside from real estate… I am a yogi and I love to snow board during the winter months. Both of these activities keep me grounded, focused and appreciative of every moment we have on this beautiful planet. The finest compliment I can receive is a referral from you. Thank you for your trust!', 'address_street' => 'PO Box 319', 'address_city' => 'Livonia', 'address_state' => 'NY', 'address_zip' => '14487', 'email_signature' => '', 'email_footer' => '', 'letter_signature' => '', 'letter_footer' => '', 'phone' => '585 519-2139', 'year_started' => (int) 2005, 'mlsid' => '29809', 'member_key' => '2780264', 'license_number' => '10301202481', 'zillow_email_address' => 'agnieszka.bajan@gmail.com', 'zillow_screenname' => 'Agnieszka-Bajan', 'user_id' => '5e7b29a4-7deb-4ee3-8834-d8b1dd5fac74', 'created' => object(Cake\I18n\FrozenTime) { 'time' => '2020-07-05 13:29:50.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, 'modified' => object(Cake\I18n\FrozenTime) { 'time' => '2020-08-26 10:46:02.000000+00:00', 'timezone' => 'UTC', 'fixedNowTime' => false }, '[new]' => false, '[accessible]' => [ '*' => true ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[hasErrors]' => false, '[errors]' => [], '[invalid]' => [], '[repository]' => 'Profiles' }, '[new]' => false, '[accessible]' => [ '*' => true, 'id' => false ], '[dirty]' => [], '[original]' => [], '[virtual]' => [], '[hasErrors]' => false, '[errors]' => [], '[invalid]' => [], '[repository]' => 'Users' } }
Listing Details
Agent | Douglas Freeman |
---|---|
Phone | 315-216-7648 |
Tax Assessment | $70,100.00 |
Est. Annual Taxes | $3,487.00 |
Water Source | Connected,Public |
Sewer | Connected |
Days on market | 0 |
Cummulative Days on market | 0 |
Type | Single Family Residence Residential |
Elementary School | Oneida |
Middle School | Oneida |
High School | Oneida |
Major Change | NewListing |
Last Modified | Oct 13, 2025, 8:15 PM |
Share per email
Analyze investment
Property Description
THIS FULLY UPDATED AND MOVE-IN READY HOME IN ONEIDA IS WAITING FOR YOU! PLEASE NOTE: HOUSE WAS PURCHASED IN JULY 2025 AND WAS RENOVATED BY CURRENT OWNER FOR A FAMILY MEMBER WHOSE PLANS CHANGED. IT WAS NOT A FLIP AND RENOVATIONS ARE WELL DONE AND READY FOR YOU TO ENJOY! This home is full of character and charm, boasting natural woodwork, gleaming hardwood floors, built-ins, sparkling new appliances, & coffered ceilings. The massive list of improvements can be found in the disclosures, but to mention just a few: all new windows on second floor & basement; all new appliances; all new plumbing & fixtures in the bathroom; new glass door panels; original floor & ceiling on front porch restored & sealed; freshly painted throughout; hardwood floors sanded, cleaned & top-coated; updated electrical wiring; waterproof/mold resistant sealer on basement walls; and many more improvements too numerous to detail here. This home has it all - located in the heart of Oneida, near major highways, dining, shopping, and entertainment, not to mention less than 30 minutes from Syracuse. Don't miss your opportunity to see this stunning home!
Details

If you'd like more information, please let me know how to contact you: