Loretta Weldner
Licensed Associate Real Estate Broker
REALTOR®
Johnstown, NY
social icon 
View Full Photo Gallery

Property Description

Wake up to breathtaking sunrises over Otisco Lake in this custom-built home inspired by the timeless design principles of Frank Lloyd Wright. Thoughtfully designed to embrace its natural surroundings, the home features rich cherry hardwood floors, custom cherry kitchen cabinetry, four bedrooms, and three full bathrooms. A spacious covered deck overlooks the lake, creating an ideal setting for outdoor dining and relaxation. The dining room, living room with vaulted ceiling and beautiful gas fireplace, kitchen, and primary bedroom all enjoy stunning panoramic views of Otisco Lake. The Seller and listing agent estimated +860 square feet of additional finished living space added in 2008 to the walkout basement that has a patio and serene water views. This level offers a kitchenette, expansive family room with wood-burning stove and indirect lighting, a full bath, and a large bedroom with full pocket doors. The basement also includes a shop/storage area. The Seller owns one of five shares of Lakeside Deck, LLC, waterfront property located approximately 1/4 mile north of 2334 State Route 174, tax map #06.-03-24.0. This share will be conveyed to the Buyer at closing. Waterfront expenses, repairs, and taxes are shared equally among the five owners. Access includes stairs leading to the waterfront deck, where boats may be stored. According to association members, there is space for a mooring or hoist in front of the approximately 50-foot waterfront lot, if desired. Please note there is no parking available at the waterfront access. It is just a short distance from the home. Some photos have been virtually staged. There are cameras on site. Taxes reflect no exemptions.

2334 State Route 174 | MLS# S1658590

This single family home located at 2334 State Route 174, Marietta, NY 13110 is currently listed for sale with an asking price of $799,000. This property was built in 2003 and has 4 bedrooms and 3 full baths with 2944 sq. ft. State Route 174 is located within the Marcellus school district. Search Marietta real estate on loretta-weldner.coldwellbankerprime.com today.

Upcoming Open Houses

Open House Sunday March 22nd, 12:00pm - 2:00pm

Gallery

Property Features

Property Type: Residential - Single Family
Basement: PartiallyFinished, WalkOutAccess, SumpPump
Cooling: CentralAir
Fireplaces: 2
Garage: 2 car attached
Heating: Propane, Baseboard, ForcedAir
Home Style: Ranch
Lot Size: 1.45 Acres
Roof Type: Architectural, Shingle
Stories: 1.0
Taxes: $12,108
Year Built: 2003

Amenities

CathedralCeilings
SeparateFormalDiningRoom
EntranceFoyer
SeparateFormalLivingRoom
GuestAccommodations
HomeOffice
KitchenIsland
Pantry
SecondKitchen
Storage
SolidSurfaceCounters
BedroomOnMainLevel
BathInPrimaryBedroom
MainLevelPrimary
Workshop
BlacktopDriveway
Deck
Patio
PropaneTankLeased

Feature Descriptions

Appliances: Dryer, Dishwasher, ElectricWaterHeater, GasOven, GasRange, Microwave, Refrigerator, Washer, WaterSoftenerOwned
Body of Water: Otisco Lake
Days on Site: 39
Exterior: FiberCement, Frame, CopperPlumbing
Flooring: Hardwood, Tile, Varies
Laundry: MainLevel
Lot: IrregularLot, RuralLot
Lot Dimensions: 150X491
Parcel#: 315200-007-000-0001-002-003-0000
Parking: Attached, Carport, Garage, CircularDriveway
Parking Notes: Attached, Carport, Garage, CircularDriveway
Patio/Porch: Covered, Deck, Open, Patio, Porch
Sewer: SepticTank
Special View Info: SlopeView, Water
Utilities: CableAvailable, ElectricityConnected, WaterConnected
Water: Connected, Public
Water Features: BeachAccess, Lake

Local Schools

High School: Marcellus High
Middle School: C S Driver Middle
Elementary School: K C Heffernan Elementary
School District: Marcellus

Estimate Your Payment

Estimated Payment

$ 3,020.27 per month $1,778.23 Principal & Interest $1,009.00 Property Tax $233.04 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Yuhas Real Estate
Agency Phone: 315-673-1628

Shown By

Agent Name: Loretta Weldner
Agent Phone: (518) 762-3808 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information on this site was last updated 03/22/2026. The listing information on this page last changed on 03/22/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Sun 03/22/2026 12:35:28 PM EST) or Global MLS (last updated Sun 03/22/2026 12:22:12 PM EST) or New York State Alliance MLS (last updated Sun 03/22/2026 12:30:52 PM EST) or Hudson Valley Catskill Region MLS (last updated Sun 03/22/2026 12:31:26 PM EST) or OneKey MLS (last updated Sun 03/22/2026 12:27:10 PM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel