s AND MOTIVATED SELLER .... Don't miss out on Great Waterfront living with this spacious Oneida Lake ranch showcasing 50’ of prime lakefront, complete with a private dock and solar-powered electric boat hoist. Offering 1,857 sq ft on the main level—plus a large finished lower level not included in the total square footage—this home combines comfort, versatility, and year-round recreation. Inside, the home features hardwood and ceramic flooring throughout, 3 bedrooms, and 3 full baths. The inviting front living room includes a stone-faced wood-burning fireplace and opens directly to the kitchen and dining area for seamless everyday living. At the back of the home, a generous family room with double sliders leads to the deck and pool area, creating ideal indoor-outdoor flow. The private primary suite is situated at the rear of the home and features a full bath with whirlpool tub and a cedar walk-in closet. First-floor laundry adds convenience. Open stairs lead to the expansive finished lower level, offering exceptional bonus space that includes a great room/rec room with wet bar, a second stone wall faced wood fireplace, a second kitchenette, a full bath, a wood stove, and a workshop/storage area and with its own separate entry from garage perfect for guests, hobbies, or additional living flexibility. The finished garage provides even more functional space, featuring a custom wood stove, screened front entry, and back sliders that open to a covered patio area. The deep backyard includes multiple sheds for storage and plenty of room for outdoor activities. Located minutes from Oneida Shores Park and Arrowhead Lodge, this waterfront property delivers an unbeatable combination of lake access, entertainment space, and comfortable year-round living.","private_remarks":"Please confirm all showings through Showing Time online. Please \"DO NOT\" park across the street in neighbors parking area. Please make sure the storm door is fully closed.","images":[{"url":"https://cdn.homesfarmsandland.com/listings/1156980160/thumb_1.webp","caption":"Photo Nov 23 2025, 11 28 57 AM.jpg","order":1},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/2","caption":"Photo Nov 23 2025, 11 28 26 AM.jpg","order":2},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/3","caption":"Photo Nov 24 2025, 2 23 07 PM.jpg","order":3},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/4","caption":"Photo Nov 23 2025, 11 31 26 AM.jpg","order":4},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/5","caption":"Photo Nov 24 2025, 1 29 10 PM.jpg","order":5},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/6","caption":"Photo Nov 23 2025, 11 30 30 AM.jpg","order":6},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/7","caption":"Photo Nov 24 2025, 2 23 57 PM.jpg","order":7},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/8","caption":"Photo Nov 24 2025, 2 24 05 PM.jpg","order":8},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/9","caption":"Photo Nov 24 2025, 1 29 49 PM.jpg","order":9},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/10","caption":"Photo Nov 24 2025, 1 30 12 PM.jpg","order":10},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/11","caption":"Photo Nov 24 2025, 1 30 23 PM.jpg","order":11},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/12","caption":"Photo Nov 24 2025, 1 30 38 PM.jpg","order":12},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/13","caption":"Photo Nov 24 2025, 1 30 47 PM.jpg","order":13},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/14","caption":"Photo Nov 24 2025, 1 31 16 PM.jpg","order":14},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/15","caption":"Photo Nov 24 2025, 1 31 37 PM.jpg","order":15},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/16","caption":"Photo Nov 24 2025, 1 31 47 PM.jpg","order":16},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/17","caption":"Photo Nov 24 2025, 1 32 59 PM.jpg","order":17},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/18","caption":"Photo Nov 24 2025, 1 33 32 PM.jpg","order":18},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/19","caption":"Photo Nov 24 2025, 1 33 55 PM.jpg","order":19},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/20","caption":"Photo Nov 24 2025, 1 34 06 PM.jpg","order":20},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/21","caption":"Photo Nov 24 2025, 1 34 57 PM.jpg","order":21},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/22","caption":"Photo Nov 24 2025, 1 35 21 PM.jpg","order":22},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/23","caption":"Photo Nov 24 2025, 1 35 31 PM.jpg","order":23},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/24","caption":"Photo Nov 24 2025, 1 36 25 PM.jpg","order":24},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/25","caption":"Photo Nov 24 2025, 1 36 37 PM.jpg","order":25},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/26","caption":"Photo Nov 24 2025, 1 36 53 PM.jpg","order":26},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/27","caption":"Photo Nov 24 2025, 1 39 09 PM.jpg","order":27},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/28","caption":"Photo Nov 24 2025, 1 39 17 PM.jpg","order":28},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/29","caption":"Photo Nov 24 2025, 1 39 31 PM.jpg","order":29},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/30","caption":"Photo Nov 24 2025, 1 39 57 PM.jpg","order":30},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/31","caption":"Photo Nov 24 2025, 1 40 11 PM.jpg","order":31},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/32","caption":"Photo Nov 24 2025, 1 41 25 PM.jpg","order":32},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/33","caption":"Photo Nov 24 2025, 1 50 18 PM.jpg","order":33},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/34","caption":"Photo Nov 24 2025, 1 50 52 PM.jpg","order":34},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/35","caption":"Photo Nov 24 2025, 1 51 28 PM.jpg","order":35},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/36","caption":"Photo Nov 24 2025, 1 52 48 PM.jpg","order":36},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/37","caption":"Photo Nov 24 2025, 1 53 47 PM.jpg","order":37},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/38","caption":"Photo Nov 24 2025, 1 54 38 PM.jpg","order":38},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/39","caption":"Photo Nov 24 2025, 1 54 54 PM.jpg","order":39},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/40","caption":"Photo Nov 24 2025, 1 56 23 PM.jpg","order":40},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/41","caption":"Photo Nov 24 2025, 2 04 16 PM.jpg","order":41},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/42","caption":"Photo Nov 24 2025, 2 10 40 PM.jpg","order":42},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/43","caption":"Photo Nov 24 2025, 2 11 05 PM.jpg","order":43},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/44","caption":"Photo Nov 24 2025, 2 11 30 PM.jpg","order":44},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/45","caption":"Photo Nov 24 2025, 2 11 53 PM.jpg","order":45},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/46","caption":"Photo Nov 24 2025, 2 17 28 PM.jpg","order":46},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/47","caption":"Photo Nov 24 2025, 2 19 10 PM.jpg","order":47},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/48","caption":"Photo Nov 24 2025, 2 19 52 PM.jpg","order":48},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/49","caption":"Photo Nov 24 2025, 2 20 04 PM.jpg","order":49},{"url":"https://cdn.homesfarmsandland.com/v1/media/1156980160/50","caption":"Photo Nov 24 2025, 2 20 29 PM.jpg","order":50}],"lead_image":"https://cdn.homesfarmsandland.com/listings/1156980160/thumb_1.webp","list_office_name":"My Town Realty LLC","agents":[{"role":"ListAgent","key":"2792353","key_numeric":2792353,"name":"David J. Manzano Sr.","phone":"315-497-6500","email":"davemanzanosr@mytowncny.com"}],"days_on_market":47,"modification_timestamp":"2026-05-18T18:32:30.623Z","mls_line":"My Town Realty LLC","distance_miles":null,"virtual_tour_url":"https://www.propertypanorama.com/instaview/syr/S1671756"},"property_details":{"bedrooms":3,"bathrooms_full":3,"bathrooms_half":0,"square_footage":1857,"lot_size_acres":0.37,"year_built":1972,"parking_spaces":0,"garage_spaces":1},"facts_and_features":{"interior":{"rooms":[],"heating":["Gas","Baseboard","Hot Water"],"cooling":[],"appliances":["Built In Range","Built In Oven","Double Oven","Dryer","Dishwasher","Exhaust Fan","Free Standing Range","Gas Cooktop","Gas Oven","Gas Range","Gas Water Heater","Microwave","Oven","Refrigerator","Range Hood","Washer"],"flooring":["Ceramic Tile","Hardwood","Tile","Varies"],"fireplace_features":[],"basement_details":["Full","Finished","Walk Out Access","Sump Pump"],"interior_features":["Wet Bar","Cedar Closets","Ceiling Fans","Entrance Foyer","Eat In Kitchen","Separate Formal Living Room","Great Room","Jetted Tub","Living Dining Room","Pantry","Pull Down Attic Stairs","See Remarks","Storage","Bar","Natural Woodwork","Bedroom On Main Level","In Law Floorplan","Bath In Primary Bedroom","Main Level Primary","Programmable Thermostat","Workshop"],"kitchen_features":[],"laundry_features":[],"window_features":["Thermal Windows"],"door_features":[],"attic_features":[]},"construction":{"architectural_style":["Ranch"],"construction_materials":["Stone","Vinyl Siding","Copper Plumbing"],"foundation_details":["Block"],"roof_materials":["Architectural","Shingle"],"property_condition":["Resale"]},"property":{"exterior_features":["Blacktop Driveway","Deck","Pool"],"view_descriptions":["Water"],"parking_features":["Attached","Garage","Heated Garage"],"lot_features":["Other","Rectangular","Rectangular Lot","Residential Lot","See Remarks"],"fencing":[],"patio_and_porch":["Deck"]},"utilities":{"water_source":"Connected","sewer":"Connected","electric":["Circuit Breakers"],"utilities":["Cable Available","High Speed Internet Available","Sewer Connected","Water Connected"]}},"financial_and_listing":{"tax_assessed_value":250000,"tax_annual_amount":9186,"school_taxes":null,"general_taxes":null,"on_market_date":"2026-04-08","listing_contract_date":"2026-04-08","purchase_contract_date":null,"listing_terms":["Cash","Conventional","FHA","Va Loan"],"road_surface_type":null,"cumulative_days_on_market":127,"body_type":null,"listing_agreement":"Exclusive Right To Sell","is_electric_on_property":null,"tenant_pays":null},"also_listed_on":[],"property_history":[],"original_source_data":[{"ListAOR":"Syracuse","ListingId":"S1671756","ListingKey":"1156980160","Permission":"IDX","OpenHouseId":"146873161","SyndicateTo":"Realtorcom","ListAgentKey":"2792353","OpenHouseKey":"146873161","PropertyType":"Residential","Refreshments":"No","ListOfficeKey":"2244723","OffMarketDate":null,"OpenHouseDate":"2026-05-17","OpenHouseType":"Public","SourceSystemID":"TRESTLE","StandardStatus":"Active","HumanModifiedYN":false,"ListOfficeMlsId":"MYTN01","OpenHouseStatus":"Ended","PropertySubType":"SingleFamilyResidence","RecordSignature":-1223361226,"ShowingAgentKey":null,"SourceSystemKey":"146873161","OpenHouseEndTime":"2026-05-17T14:00:00.000-04:00","OpenHouseRemarks":"Recently Reduced $$
HOMESFARMSANDLAND
BuySell
s Motivated Seller... Great waterfront living with this spacious Oneida Lake ranch showcasing 50’ of prime lakefront, complete with a private dock and solar-powered electric boat hoist. Offering 1,857 sq ft on the main level—plus a large finished lower level not included in the total square footage—this home combines comfort, versatility, and year-round recreation.","SourceSystemName":null,"ListingKeyNumeric":1156980160,"ListingPermission":"IDX","ShowingAgentMlsID":null,"OpenHouseStartTime":"2026-05-17T12:00:00.000-04:00","OpenHouseAttendedBy":null,"OpenHouseKeyNumeric":146873161,"OriginatingSystemID":null,"OriginatingSystemKey":"69833467","ShowingAgentLastName":null,"AppointmentRequiredYN":null,"ModificationTimestamp":"2026-05-17T18:00:40.610-00:00","OriginatingSystemName":"NYS","ShowingAgentFirstName":null,"LivestreamOpenHouseURL":null,"OriginalEntryTimestamp":"2026-05-17T14:00:00.000-00:00","ShowingAgentKeyNumeric":null,"SourceSystemListingKey":null,"OriginatingSystemSubName":"NYS_S","PropertySubTypeAdditional":null,"OriginatingSystemListingKey":"68801581","InternetEntireListingDisplayYN":true}]},{"id":"49630540","listing_key":"20260318200812422908000000","listing_id":"202615522","source_provider":"SPARK","mls_name":"Global MLS","general_info":{"price":"$415,000","price_value":415000,"price_formatted":"$415,000","price_cut":0,"price_cut_formatted":null,"property_status":"Active","status":"Active","property_type":"Residential","property_subtype":"Single Family Residence","full_address":"549 Columbia Street Extension, Cohoes, NY 12047","fullAddress":"549 Columbia Street Extension, Cohoes, NY 12047","address_line":"549 Columbia Street Extension","street_number":"549","street_direction":null,"street_name":"Columbia Street","city":"Cohoes","state":"NY","postal_code":"12047","county":"Albany","latitude":42.767897,"longitude":-73.739304,"unit_number":null,"bedrooms":3,"bathrooms":2,"total_rooms":8,"square_footage":2168,"lot_size":{"value":0.46,"unit":"acres"},"year_built":1953,"description":"Opportunity knocks in the highly sought-after North Colonie School District--where location truly is everything! Priced to sell, this estate property offers the perfect combination of value, layout, and potential, making it a slam dunk for any buyer. Featuring 3 massive bedrooms, 2 full bathrooms, and a functional floor plan, this home is filled with fantastic features and just awaits your personal touch. Enjoy a level backyard and unbeatable proximity to major shopping, dining, and everyday conveniences.\r\n\r\nRoof details include an asphalt shingle roof (40-year shingle) with approximately half of its life remaining, along with a rubber roof section that is only 1 year old. The home was previously heated with oil and has since been converted to forced hot air powered by natural gas; an empty oil tank remains in the basement.\r\n\r\nThis is an estate sale and the property is being sold strictly as-is. The wood-burning fireplace has not been used in approximately 25 years, and the estate has no knowledge of its current condition. The estate will not provide any credits or repairs. Buyers are welcome to conduct any inspections they deem necessary.\r\n\r\nThere are a few windows requiring attention, including sash replacement on select windows and two cracked crank windows in the living room. All known conditions have been disclosed in advance.\r\n\r\nWhether you're looking to invest, renovate, or create your dream home in an unbeatable location, this is an incredible opportunity you won't want to miss.","private_remarks":null,"images":[{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135304358589000000-o.jpg","caption":"01-P1839118","order":1},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135309000359000000-o.jpg","caption":"02-P1839161","order":2},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135316383618000000-o.jpg","caption":"04-P1839173","order":3},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135327992261000000-o.jpg","caption":"07-P1839185","order":4},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135323926001000000-o.jpg","caption":"06-P1839179","order":5},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135341820061000000-o.jpg","caption":"11-P1839203","order":6},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135355879871000000-o.jpg","caption":"15-P1839227","order":7},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135359659712000000-o.jpg","caption":"16-P1839233","order":8},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135352335817000000-o.jpg","caption":"14-P1839221","order":9},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135403866989000000-o.jpg","caption":"17-P1839239","order":10},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135412194982000000-o.jpg","caption":"19-P1839256","order":11},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135407989137000000-o.jpg","caption":"18-P1839250","order":12},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135445475438000000-o.jpg","caption":"26-P1839297","order":13},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135439449338000000-o.jpg","caption":"25-P1839291","order":14},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135459877586000000-o.jpg","caption":"28-P1839309","order":15},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135455568554000000-o.jpg","caption":"27-P1839303","order":16},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135435364598000000-o.jpg","caption":"24-P1839286","order":17},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135430962228000000-o.jpg","caption":"23-P1839280","order":18},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135509061053000000-o.jpg","caption":"30-P1839321","order":19},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135504816978000000-o.jpg","caption":"29-P1839315","order":20},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135516855765000000-o.jpg","caption":"32-P1839333","order":21},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135512785124000000-o.jpg","caption":"31-P1839327","order":22},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034844592482000000-o.jpg","caption":"40-P1839133","order":23},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135312503436000000-o.jpg","caption":"03-P1839167","order":24},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034845526838000000-o.jpg","caption":"39-P1839128","order":25},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135416155114000000-o.jpg","caption":"20-P1839262","order":26},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034839763960000000-o.jpg","caption":"44-P1839153","order":27},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034838494190000000-o.jpg","caption":"45-P1839158","order":28},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034841196131000000-o.jpg","caption":"43-P1839148","order":29},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034843403811000000-o.jpg","caption":"41-P1839138","order":30},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034842367297000000-o.jpg","caption":"42-P1839143","order":31},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135422376645000000-o.jpg","caption":"21-P1839268","order":32},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135520620838000000-o.jpg","caption":"33-P1839338","order":33},{"url":"https://cdn.photos.sparkplatform.com/glo/20260420135524070804000000-o.jpg","caption":"34-P1839344","order":34},{"url":"https://cdn.photos.sparkplatform.com/glo/20260422034849320718000000-o.jpg","caption":"35-P1839093","order":35}],"lead_image":"https://cdn.photos.sparkplatform.com/glo/20260420135304358589000000-o.jpg","list_office_name":"Hunt ERA","agents":[{"role":"ListAgent","key":"20211012215324659681000000","key_numeric":null,"name":"Caitlin Cucchiella","phone":"518-852-3665","email":"realestatecaitsaratoga@gmail.com"}],"days_on_market":33,"modification_timestamp":"2026-05-07T22:46:12.000Z","mls_line":"Hunt ERA","distance_miles":null,"virtual_tour_url":"https://app.doaudiotours.com/unbranded?id=20422&lang=en-US"},"property_details":{"bedrooms":3,"bathrooms_full":2,"bathrooms_half":0,"square_footage":2168,"lot_size_acres":0.46,"year_built":1953,"parking_spaces":8,"garage_spaces":2},"facts_and_features":{"interior":{"rooms":[{"name":"Foyer","count":1},{"name":"Bedroom","count":3},{"name":"Dining Room","count":1},{"name":"Living Room","count":1},{"name":"Kitchen","count":1},{"name":"Laundry","count":1}],"heating":["Baseboard","Hot Water"],"cooling":[],"appliances":["Range","Refrigerator","Washer/Dryer"],"flooring":["Carpet","Ceramic Tile"],"fireplace_features":["Wood Burning"],"basement_details":["Unfinished","Full"],"interior_features":["Walk-In Closet(s)","Ceramic Tile Bath","Eat-in Kitchen"],"kitchen_features":["Eat-in Kitchen"],"laundry_features":[],"window_features":[],"door_features":["Storm Door(s)"],"attic_features":[]},"construction":{"architectural_style":["Cape Cod"],"construction_materials":["Brick","Vinyl Siding"],"foundation_details":[],"roof_materials":["Asphalt","Rubber","Shingle"],"property_condition":[]},"property":{"exterior_features":["Drive-Paved"],"view_descriptions":[],"parking_features":["Attached","Off Street","Paved","Driveway","Garage"],"lot_features":["Cleared","Landscaped","Level","Road Frontage"],"fencing":["None"],"patio_and_porch":["Rear Porch"]},"utilities":{"water_source":"Public","sewer":"Public Sewer","electric":["200+ Amp Service"],"utilities":[]}},"financial_and_listing":{"tax_assessed_value":null,"tax_annual_amount":5476,"school_taxes":3924,"general_taxes":1552,"on_market_date":"2026-04-22","listing_contract_date":"2026-04-22","purchase_contract_date":null,"listing_terms":[],"road_surface_type":null,"cumulative_days_on_market":null,"body_type":[],"listing_agreement":null,"is_electric_on_property":null,"tenant_pays":null},"also_listed_on":[],"property_history":[],"original_source_data":[]},{"id":"35113097","listing_key":"20260117133300881459000000","listing_id":"202610920","source_provider":"SPARK","mls_name":"Global MLS","general_info":{"price":"$415,000","price_value":415000,"price_formatted":"$415,000","price_cut":10000,"price_cut_formatted":"$10,000","property_status":"Active","status":"Active","property_type":"Residential","property_subtype":"Single Family Residence","full_address":"50 Hillcrest Drive, Sand Lake, NY 12018","fullAddress":"50 Hillcrest Drive, Sand Lake, NY 12018","address_line":"50 Hillcrest Drive","street_number":"50","street_direction":null,"street_name":"Hillcrest","city":"Sand Lake","state":"NY","postal_code":"12018","county":"Rensselaer","latitude":42.636464,"longitude":-73.605181,"unit_number":null,"bedrooms":3,"bathrooms":2,"total_rooms":9,"square_footage":1534,"lot_size":{"value":0.35,"unit":"acres"},"year_built":1953,"description":"Beautiful 1 Owner Ranch Style Estate Property. Meticulously Maintained and Updated Throughout. New Kitchen Appliances, Updated Baths, Fresh Paint and Sanded Hardwood in your Wide Open, Bright One Level Living Space. Close to shopping (Hannaford, Stewarts, Wal-Green) all within a mile. Step out back to your, Private Park-Like Backyard. Includes Generations of Beautiful Plantings, Landscaping, Walks, Lawn, Patio, Modern Decking and Outdoor Cooking Area . It has a New Roof 2018, Well Pump in 2025, Furnace Overhaul 2024. The super dry basement was finished many years ago and includes the pool table and piano, Nextdoor: # 54 Hillcrest Dr. The Cutest Little Cabin that was previously Married to this Property as an In-Law/Rental. That is also for sale by this Estate Under its own New Individual Tax-ID #. and separate MLS # SHOWINGS Start 1/26/2026","private_remarks":null,"images":[{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033904173379000000-o.jpg","caption":"0 Air Front 1","order":1},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033905356491000000-o.jpg","caption":"0 Air Front 2","order":2},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033906879741000000-o.jpg","caption":"0 Air Front 3","order":3},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033909652097000000-o.jpg","caption":"0 Air Front 4","order":4},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033911469387000000-o.jpg","caption":"0 Front 1 addon dtd","order":5},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033913338934000000-o.jpg","caption":"0 Front 1","order":6},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033915187221000000-o.jpg","caption":"0 Front 2","order":7},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033918315672000000-o.jpg","caption":"0 Front 3","order":8},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033922244324000000-o.jpg","caption":"0 Front 4","order":9},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033924245816000000-o.jpg","caption":"1 Livingroom 1","order":10},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033926020355000000-o.jpg","caption":"1 Livingroom 2","order":11},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033927412169000000-o.jpg","caption":"1 Livingroom 3","order":12},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033928781432000000-o.jpg","caption":"1 Livingroom 4","order":13},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033930220472000000-o.jpg","caption":"2 Diningroom 1","order":14},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033931573498000000-o.jpg","caption":"2 Diningroom 2","order":15},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033933154505000000-o.jpg","caption":"2 Diningroom 3","order":16},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033935183764000000-o.jpg","caption":"3 Kitchen 1","order":17},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033937086966000000-o.jpg","caption":"3 Kitchen 2","order":18},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033938544510000000-o.jpg","caption":"3 Kitchen 3","order":19},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033939953025000000-o.jpg","caption":"3 Kitchen 4","order":20},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033942952976000000-o.jpg","caption":"4 Familyroom 1","order":21},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033944837026000000-o.jpg","caption":"4 Familyroom 2","order":22},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033946966381000000-o.jpg","caption":"4 Familyroom 3","order":23},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033948567841000000-o.jpg","caption":"5 Bedroom 1","order":24},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033950115079000000-o.jpg","caption":"5 Bedroom 2","order":25},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033952291631000000-o.jpg","caption":"5 Bedroom 3","order":26},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033954789308000000-o.jpg","caption":"5 Bedroom 4","order":27},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033956363238000000-o.jpg","caption":"5 Bedroom 5","order":28},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033957539014000000-o.jpg","caption":"5 Bedroom 6","order":29},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121033958813455000000-o.jpg","caption":"5 Bedroom 7","order":30},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034000212536000000-o.jpg","caption":"6 Bathroom 1","order":31},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034001548960000000-o.jpg","caption":"6 Bathroom 2","order":32},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034003322539000000-o.jpg","caption":"7 Basement 1","order":33},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034006021443000000-o.jpg","caption":"7 Basement 2","order":34},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034007943238000000-o.jpg","caption":"7 Basement 3","order":35},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034010247125000000-o.jpg","caption":"7 Basement 4","order":36},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034011993210000000-o.jpg","caption":"7 Basement 5","order":37},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034015317021000000-o.jpg","caption":"9 Attic 1","order":38},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034018123270000000-o.jpg","caption":"9 Attic 2","order":39},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034019723934000000-o.jpg","caption":"10 Garage 1","order":40},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034021859014000000-o.jpg","caption":"10 Garage 2","order":41},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034023860181000000-o.jpg","caption":"11 Screen porch 1","order":42},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034025299112000000-o.jpg","caption":"11 Screen porch 2","order":43},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034027672476000000-o.jpg","caption":"11 Screen porch 3","order":44},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034030385597000000-o.jpg","caption":"Air Yard 1","order":45},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034033187656000000-o.jpg","caption":"Air Yard 2","order":46},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034036248947000000-o.jpg","caption":"Air Yard 3","order":47},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034039260582000000-o.jpg","caption":"Air Yard 4","order":48},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034042126257000000-o.jpg","caption":"Air Yard 5","order":49},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034045802286000000-o.jpg","caption":"Air Yard 6","order":50},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034048517861000000-o.jpg","caption":"Air Yard 7","order":51},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034051440366000000-o.jpg","caption":"Yard 1","order":52},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034055102854000000-o.jpg","caption":"Yard 2","order":53},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034059197459000000-o.jpg","caption":"Yard 3","order":54},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034102394334000000-o.jpg","caption":"Yard 4","order":55},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034105785370000000-o.jpg","caption":"Yard 5","order":56},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034107996983000000-o.jpg","caption":"Yard 6","order":57},{"url":"https://cdn.photos.sparkplatform.com/glo/20260121034124549721000000-o.jpg","caption":"Property Line Overlay","order":58}],"lead_image":"https://cdn.photos.sparkplatform.com/glo/20260121033911469387000000-o.jpg","list_office_name":"Brian Neary Realty","agents":[{"role":"ListAgent","key":"20211012215512108059000000","key_numeric":null,"name":"Brian T Neary","phone":"518-573-4287","email":"FHDogman@gmail.com"}],"days_on_market":123,"modification_timestamp":"2026-05-07T19:46:45.000Z","mls_line":"Brian Neary Realty","distance_miles":null,"virtual_tour_url":"https://walkthruphoto.info/Public/50-Hillcrest-Dr-1-20-26/"},"property_details":{"bedrooms":3,"bathrooms_full":2,"bathrooms_half":0,"square_footage":1534,"lot_size_acres":0.35,"year_built":1953,"parking_spaces":4,"garage_spaces":4},"facts_and_features":{"interior":{"rooms":[{"name":"Kitchen","count":1},{"name":"Dining Room","count":1},{"name":"Primary Bedroom","count":1},{"name":"Primary Bathroom","count":1},{"name":"Bedroom","count":2},{"name":"Full Bathroom","count":1},{"name":"Den","count":1},{"name":"3 Seasons Room","count":1}],"heating":["Oil","Baseboard","Hot Water"],"cooling":[],"appliances":["Cooktop","Dishwasher","Microwave","Electric Oven","Washer/Dryer","Built-In Electric Oven","ENERGY STAR Qualified Appliances"],"flooring":["Hardwood"],"fireplace_features":[],"basement_details":["Walk-Out Access","Full","Finished","Interior Entry"],"interior_features":["High Speed Internet","Paddle Fan","Solid Surface Counters","Eat-in Kitchen","Built-in Features"],"kitchen_features":["Eat-in Kitchen","Modern Kitchen","Built-in Features"],"laundry_features":[],"window_features":["Insulated Windows","Screens"],"door_features":[],"attic_features":[]},"construction":{"architectural_style":["Ranch"],"construction_materials":["Vinyl Siding"],"foundation_details":["Block"],"roof_materials":["Asphalt"],"property_condition":["Updated/Remodeled"]},"property":{"exterior_features":["Garden"],"view_descriptions":["Garden"],"parking_features":["Under Residence","Garage Door Opener","Garage"],"lot_features":["Landscaped","Private","Garden"],"fencing":[],"patio_and_porch":["Patio","Covered","Rear Porch"]},"utilities":{"water_source":"Well","sewer":"Septic Tank","electric":["200+ Amp Service"],"utilities":["Cable Connected"]}},"financial_and_listing":{"tax_assessed_value":null,"tax_annual_amount":9775.42,"school_taxes":null,"general_taxes":null,"on_market_date":"2026-01-22","listing_contract_date":"2026-01-22","purchase_contract_date":null,"listing_terms":["Cash"],"road_surface_type":null,"cumulative_days_on_market":null,"body_type":[],"listing_agreement":null,"is_electric_on_property":null,"tenant_pays":null},"also_listed_on":[],"property_history":[],"original_source_data":[]},{"id":"53244724","listing_key":"20260506103354525936000000","listing_id":"202616555","source_provider":"SPARK","mls_name":"Global MLS","general_info":{"price":"$415,000","price_value":415000,"price_formatted":"$415,000","price_cut":0,"price_cut_formatted":null,"property_status":"Active","status":"Active","property_type":"Residential","property_subtype":"Single Family Residence","full_address":"10398 Route 23-A, Hunter, NY 12442","fullAddress":"10398 Route 23-A, Hunter, NY 12442","address_line":"10398 Route 23-A","street_number":"10398","street_direction":null,"street_name":"Route 23-A","city":"Hunter","state":"NY","postal_code":"12442","county":"Greene","latitude":42.242124,"longitude":-74.322613,"unit_number":null,"bedrooms":3,"bathrooms":2,"total_rooms":11,"square_footage":1390,"lot_size":{"value":1,"unit":"acres"},"year_built":1960,"description":"Wonderful Log home situated in the Catskills, located just a couple of minutes outside of the Hunter village. Both the main house and the detached ADU/Studio/Cottage were totally renovated over the past 18 months. Updates and upgrades include Roof, Decks, Windows Kitchen (with Frigidaire, black stainless appliances), Baths Electric, Siding, Windows, doors (inside and out), Insulation, Flooring, Appliances, Heating (propane furnace) and A/C, (heat pump Mini Split in ADU). There are 3 electric fireplaces for taking off the chill (main house, in the bedroom, and the ADU living room) The convenient location to NYC/NJ region to this mountain retreat is a perfect getaway, rental (long term or short term), or a year-round residence. it is just a couple minutes to Hunter, Tannersville and a short drive to Windham. There are hiking trails, waterfalls, hiking trails, parks and so much more! Don't miss this one!","private_remarks":null,"images":[{"url":"https://cdn.photos.sparkplatform.com/glo/20260506142613508305000000-o.jpg","caption":"Screenshot (1028)","order":1},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135828772047000000-o.jpg","caption":"20260505_153112","order":2},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506113727087396000000-o.jpg","caption":"front","order":3},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135834250314000000-o.jpg","caption":"20260505_155003","order":4},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135831615271000000-o.jpg","caption":"20260505_154648","order":5},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506142528525644000000-o.jpg","caption":"20260505_151823AA","order":6},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135944343847000000-o.jpg","caption":"20260505_151634","order":7},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135940205093000000-o.jpg","caption":"20260505_151551","order":8},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135953880415000000-o.jpg","caption":"20260505_152214","order":9},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135946476298000000-o.jpg","caption":"20260505_151701","order":10},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135942226585000000-o.jpg","caption":"20260505_151609","order":11},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135930603826000000-o.jpg","caption":"20260505_150521","order":12},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135928655972000000-o.jpg","caption":"20260505_150507","order":13},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135926392118000000-o.jpg","caption":"20260505_150405","order":14},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135923949989000000-o.jpg","caption":"20260505_150042","order":15},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135916039677000000-o.jpg","caption":"20260505_152422","order":16},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135918124775000000-o.jpg","caption":"20260505_145907","order":17},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506140002459591000000-o.jpg","caption":"20260505_144726","order":18},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506140004707774000000-o.jpg","caption":"20260505_144556","order":19},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506141214460340000000-o.jpg","caption":"20260505_151223","order":20},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135932340534000000-o.jpg","caption":"20260505_151256","order":21},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135920168421000000-o.jpg","caption":"20260505_145928","order":22},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135922140663000000-o.jpg","caption":"20260505_145947","order":23},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506140006819441000000-o.jpg","caption":"20260505_144619","order":24},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135936449834000000-o.jpg","caption":"20260505_151425","order":25},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135938325911000000-o.jpg","caption":"20260505_151445","order":26},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135948165139000000-o.jpg","caption":"20260505_151736","order":27},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135959942557000000-o.jpg","caption":"20260505_144636","order":28},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135903354111000000-o.jpg","caption":"DJI_0055","order":29},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135858304917000000-o.jpg","caption":"DJI_0051","order":30},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135907054181000000-o.jpg","caption":"DJI_0057","order":31},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135850928503000000-o.jpg","caption":"DJI_0049","order":32},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135837405158000000-o.jpg","caption":"20260505_160007","order":33},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135840646356000000-o.jpg","caption":"DJI_0044","order":34},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135825803527000000-o.jpg","caption":"DJI_0059","order":35},{"url":"https://cdn.photos.sparkplatform.com/glo/20260506135843408968000000-o.jpg","caption":"DJI_0045","order":36}],"lead_image":"https://cdn.photos.sparkplatform.com/glo/20260506142613508305000000-o.jpg","list_office_name":"RE/MAX Capital","agents":[{"role":"ListAgent","key":"20211012220534994986000000","key_numeric":null,"name":"Douglas S Schenk","phone":"518-221-2949","email":"schenk.remax@gmail.com"}],"days_on_market":19,"modification_timestamp":"2026-05-06T18:50:07.000Z","mls_line":"RE/MAX Capital","distance_miles":null,"virtual_tour_url":null},"property_details":{"bedrooms":3,"bathrooms_full":2,"bathrooms_half":0,"square_footage":1390,"lot_size_acres":1,"year_built":1960,"parking_spaces":6,"garage_spaces":0},"facts_and_features":{"interior":{"rooms":[{"name":"Living Room","count":2},{"name":"Kitchen","count":2},{"name":"Bedroom","count":2},{"name":"Den","count":1},{"name":"Other","count":2},{"name":"Full Bathroom","count":2}],"heating":["Propane","Propane Tank Leased","Forced Air","Heat Pump","Ductless"],"cooling":[],"appliances":["Range","Refrigerator","Dishwasher","Microwave","Electric Water Heater","Built-In Gas Oven"],"flooring":["Laminate","Ceramic Tile","Hardwood"],"fireplace_features":["Electric","Other","Living Room","Bedroom"],"basement_details":["Crawl Space","Partial"],"interior_features":["Cathedral Ceiling(s)","Ceramic Tile Bath","High Speed Internet","Paddle Fan","Solid Surface Counters"],"kitchen_features":["Gourmet Kitchen","Modern Kitchen"],"laundry_features":[],"window_features":["Insulated Windows","Double Pane Windows"],"door_features":["Sliding Doors"],"attic_features":[]},"construction":{"architectural_style":["Log","Ranch"],"construction_materials":["Log","Drywall"],"foundation_details":["Block"],"roof_materials":["Asphalt","Shingle"],"property_condition":["Updated/Remodeled"]},"property":{"exterior_features":["Drive-Paved","Lighting"],"view_descriptions":["Creek/Stream","Mountain(s)","Trees/Woods"],"parking_features":["Off Street","Paved","Driveway"],"lot_features":["Level","Private","Road Frontage","Secluded","Sloped","Steep Slope","Views","Waterfront"],"fencing":[],"patio_and_porch":["Deck","Pressure Treated Deck"]},"utilities":{"water_source":"Well","sewer":"Septic Tank","electric":["200+ Amp Service","220 Volts","Circuit Breakers"],"utilities":["Cable Connected"]}},"financial_and_listing":{"tax_assessed_value":null,"tax_annual_amount":871.26,"school_taxes":520.95,"general_taxes":350.51,"on_market_date":"2026-05-06","listing_contract_date":"2026-05-06","purchase_contract_date":null,"listing_terms":[],"road_surface_type":null,"cumulative_days_on_market":null,"body_type":[],"listing_agreement":null,"is_electric_on_property":null,"tenant_pays":null},"also_listed_on":[],"property_history":[],"original_source_data":[]}],"total":590,"count":10,"page":1,"pageSize":10,"totalPages":59,"hasNext":true,"hasPrevious":false,"nextPage":2,"previousPage":null,"filters":{"minPrice":413100,"maxPrice":504900.00000000006,"minBedrooms":null,"minBathrooms":null,"minSqFt":null,"minLotSize":null,"propertyType":null,"propertyStatus":null,"open":null,"city":null,"county":null,"zip":null}}};
HOMESFARMSANDLAND
BuySell