Mountain Homes Realty
Enter City, Zip or MLS

4 big bay road

Queensbury, NY 12804

$899,900

5 BEDS 3 BATHS
2,000 SQFT1.04 AC LOT
Residential - Single Family
Waterfront
Image 1: Parrish.1
Image 2: Parrish.2
Image 3: Parrish.3
Image 4: Parrish.4
Bedrooms 5
Total Baths 3
Full Baths 3
Square Feet 2000
Acreage 1.05
Status Active
MLS # 202621145
County Warren
More Info
Category Residential - Single Family
Status Active
Square Feet 2000
Acreage 1.05
MLS # 202621145
County Warren
An opportunity to own a custom-built, direct waterfront ranch style home, with a private boat launch, beach area, and approved for (2) 40-foot docks. With walk-in water access, and multiple areas for indoor and outdoor entertaining, this property offers a one-of-a-kind lifestyle experience. The open floor plan offers 9 ft ceilings throughout. It has a spacious living area and dining space; the kitchen has 42-inch cabinets and newer appliances. Main floor washer/dryer. Multiple sliding glass doors lead out to a 40 ft covered patio with a hot tub, providing dramatic views of the Hudson River day or night. The primary suite offers waterfront views with direct access to the patio, his and her closet and an oversized en-suite bath, that features a large, jetted tub. The fully finished lower level has 9.5 ft ceilings with a huge game room. A private mother-in-law suite with a bedroom, living room, office, bath and kitchen. It has its own laundry room with additional room for plenty of storage. Property Highlights: • 190' of direct Hudson River frontage • 3 car heated garage • Waterfront deck • Covered outdoor grilling area • Multiple storage sheds • Full sand volleyball court • Kayak racks • Circular Driveway • Boat and RV parking/storage • ADT security system • Newer furnace and hot water tank • Proven short-term rental income history Whether you're looking for a year-round residence, vacation getaway, or investment opportunity, this one-of-a-kind Hudson River retreat offers an exceptional combination of waterfront recreation, privacy, and proven short-term rental income potential.
Location not available
Listing
Street
Satellite

Exterior Features

  • Style Ranch
  • Siding Shingle
  • Exterior Other, Drive-Paved, Gas Grill, Lighting
  • Roof Shingle
  • Garage Yes
  • Garage Description 3
  • Water Public
  • Sewer Septic Tank
  • Lot Description Level, Road Frontage, Views, Corner Lot, Landscaped, Waterfront

Interior Features

  • Appliances Ice Maker, Dishwasher, Disposal, Dryer, Electric Oven, ENERGY STAR Qualified Appliances, Freezer, Gas Oven, Gas Water Heater, Microwave, Refrigerator, Washer
  • Heating Ductless, Forced Air, Humidity Control, Propane, Propane Tank Owned
  • Cooling Central Air
  • Basement Other, Apartment, Bath/Stubbed, Exterior Entry, Finished, Full, Heated, Interior Entry, Walk-Out Access
  • Fireplaces 1
  • Living Area 2,000 SQFT
  • Year Built 2005

Financial Information

  • Parcel ID 523400 316.18-1-1.4
  • Zoning Single Residence

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Realmart Realty LLC
©2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. Data last updated 07/28/2026.Source MLS Verified
Listing data is current as of 07/28/2026.

Contact Our Agent

By clicking “Submit,” I agree to be contacted by Lake Homes Realty, LLC, its affiliates, and real estate professionals via call, text, and email for real estate services. This includes by automated means, even if your number is on a federal, state, or our internal Do Not Call list. To opt out, you can reply "stop" at any time or reply "help" for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. You also agree to our Terms of Use and Privacy Policy.