Buy
  • Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
    Canada Listings (1339)
    Advanced Search
Rent Sell Find an Agent
LakeHouse.com LakeHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • Rent
  • Sell
  • Find an Agent
  • My Account
    • Login
    • Manage My Real Estate Ads
    • Manage My Search Profile / Auto Notify
    • My Account Info
    • Manage My Favorites
  • Advertise
  • Join
Back to Search Back to Listing LakeHouse.com logo
Share
LakeHouse.com logo
Ad #7718744
MLS #11745688
Listing photo

Welcome to your Brand New Home! Be the FIRST to live in this

48 Water St 6, Ghent, New York, 12075
$90,000
2Beds
2Baths
0Sqft
0Acres

About this property

Welcome to your Brand New Home! Be the FIRST to live in this fantastic 2 Bedroom, 2 Bathroom Single-wide Manufactured home in Historic Ghent NY. Located in a very small and tidy community, this home has a Gorgeous view in Backyard of a Farmers field and Hills. Backyard also has a small stream that is very nice. Directly in front of this home sits the Town of Ghent Recreation Park with Ball fields, and Playground! If you enjoy the peace and tranquility of nature, this is the place for you! Exterior Features: 2-Car Paved Driveway, Vinyl Siding, Vinyl Skirting, Grass has been seeded, 2 Steps of Entry/Exit, For Structural integrity this home IS on a Cement Slab, Large Side Yards and Back Yard, Interior Features: Waterproof Rolled Vinyl Flooring throughout entire home, Whirlpool Kitchen appliances(Refrigerator, Built-in Microwave, Dishwasher), Has Laundry Area, Primary Bedroom with En-suite Full Bathroom w/ Walk-in Shower, Guest Bedroom, 2nd Full Bathroom w/Tub. For Peace of Mind this home was Overseen in 2026 by The Dept. of Housing and Urban Development (HUD) for Quality and Safety. This home DOES qualify for a Manufactured Home Mortgage (a.k.a. Chattel Loan).This home is Located in a Manufactured Home Community where you OWN your home, but LEASE your Yard. The Lot Rent is $465 per month and includes: Main Road Snow Plowing, Sewer and Water Infrastructure, and a Community Manager. For all Lease related questions, Reach out to Listing Agent for Managements contact info. Call Listing agent for any additional questions or to schedule your own Private Showing.

Property Features

2 Beds
2 Baths
0 Sqft
Built in 2026
0 Acres
1 Story
(private lake, pond, coastal)
View Type: Park
On Waterfront
Siding: Vinyl Siding
Asphalt Roof
Propane (Heating), Forced Air
Columbia County

Additional Photos

Additional listing photo 1
Additional listing photo 2
Additional listing photo 3
Additional listing photo 4

Contact Information

Adam Shelmerdine

IRE INVESTMENTS

Location

Map
Listing Agent: Adam Shelmerdine
Broker: IRE INVESTMENTS 518-379-0652 Listing Site
Copyright © 2026 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
LakeHouse.com
Printed Jul 18, 2026

Photo Gallery

Welcome to your Brand New Home! Be the FIRST to live in this - photo 1
Welcome to your Brand New Home! Be the FIRST to live in this - photo 2
Welcome to your Brand New Home! Be the FIRST to live in this - photo 3
Welcome to your Brand New Home! Be the FIRST to live in this - photo 4
Welcome to your Brand New Home! Be the FIRST to live in this - photo 5
Welcome to your Brand New Home! Be the FIRST to live in this - photo 6
Welcome to your Brand New Home! Be the FIRST to live in this - photo 7
Welcome to your Brand New Home! Be the FIRST to live in this - photo 8
Welcome to your Brand New Home! Be the FIRST to live in this - photo 9
Welcome to your Brand New Home! Be the FIRST to live in this - photo 10
Welcome to your Brand New Home! Be the FIRST to live in this - photo 11
Welcome to your Brand New Home! Be the FIRST to live in this - photo 12
Welcome to your Brand New Home! Be the FIRST to live in this - photo 13
Welcome to your Brand New Home! Be the FIRST to live in this - photo 14
Welcome to your Brand New Home! Be the FIRST to live in this - photo 15
Welcome to your Brand New Home! Be the FIRST to live in this - photo 16
Welcome to your Brand New Home! Be the FIRST to live in this - photo 17
Welcome to your Brand New Home! Be the FIRST to live in this - photo 18
Welcome to your Brand New Home! Be the FIRST to live in this - photo 19

$90,000

2
Beds
2
Baths
0
Sqft

48 Water St 6, Ghent, New York, 12075

By contacting this agent you agree to these Terms and Conditions.
Home New York (private lake, pond, coastal)
Welcome to your Brand New Home! Be the FIRST to live in this - photo 1
Welcome to your Brand New Home! Be the FIRST to live in this - photo 2
Welcome to your Brand New Home! Be the FIRST to live in this - photo 3
Welcome to your Brand New Home! Be the FIRST to live in this - photo 4
Welcome to your Brand New Home! Be the FIRST to live in this - photo 5
MLS# 11745688
Home Sale Pending

Welcome to your Brand New Home! Be the FIRST to live in this

$90,000

48 Water St 6, Ghent, New York, 12075

2
Beds
2
Baths
0
Sqft
0
Acres
$90,000
48 Water St 6, Ghent, New York, 12075
2 Beds
2 Baths
0 Sqft
0 Acres
Welcome to your Brand New Home! Be the FIRST to live in this fantastic 2 Bedroom, 2 Bathroom Single-wide Manufactured home in Historic Ghent NY. Located in a very small and tidy community, this home has a Gorgeous view in Backyard of a Farmers field and Hills. Backyard also has a small stream that is very nice. Directly in front of this home sits the Town of Ghent Recreation Park with Ball fields, and Playground! If you enjoy the peace and tranquility of nature, this is the place for you! Exterior Features: 2-Car Paved Driveway, Vinyl Siding, Vinyl Skirting, Grass has been seeded, 2 Steps of Entry/Exit, For Structural integrity this home IS on a Cement Slab, Large Side Yards and Back Yard, Interior Features: Waterproof Rolled Vinyl Flooring throughout entire home, Whirlpool Kitchen appliances(Refrigerator, Built-in Microwave, Dishwasher), Has Laundry Area, Primary Bedroom with En-suite Full Bathroom w/ Walk-in Shower, Guest Bedroom, 2nd Full Bathroom w/Tub. For Peace of Mind this home was Overseen in 2026 by The Dept. of Housing and Urban Development (HUD) for Quality and Safety. This home DOES qualify for a Manufactured Home Mortgage (a.k.a. Chattel Loan).This home is Located in a Manufactured Home Community where you OWN your home, but LEASE your Yard. The Lot Rent is $465 per month and includes: Main Road Snow Plowing, Sewer and Water Infrastructure, and a Community Manager. For all Lease related questions, Reach out to Listing Agent for Managements contact info. Call Listing agent for any additional questions or to schedule your own Private Showing.
65 days
on LakeHouse.com
56
views
0
saves

Property Details

HOME DETAILS

2 Beds
2 Baths
0 Sqft
Built in 2026
0 Acres
1 Story

WATER & VIEW

(private lake, pond, coastal)
View Type: Park
On Waterfront

EXTERIOR

Siding: Vinyl Siding
Asphalt Roof

INTERIOR

Propane (Heating), Forced Air

FINANCIAL & COMMUNITY

Columbia County
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7718744
Viewed
56 times
Listing Status
Pending
Added
May 13, 2026
Last Refresh
Jul 18, 2026 12:42:26 AM

Listing Information

Data Source
My State MLS
Source Property ID
11745688
Listing Agent: Adam Shelmerdine
Broker: IRE INVESTMENTS 518-379-0652 Listing Site
Copyright © 2026 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Request Information

By proceeding, you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), its affiliates, and other real estate professionals that may not be associated with Dream Home Network, to contact you using the contact details you provided, via email, phone call, and text (SMS), including using automated dialing technology and prerecorded and artificial voice, for marketing or advertising purposes, including contacting you about your inquiry and other home-related matters. You understand that your consent to the foregoing is not a condition of any purchase. Message and data rates may apply. This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what you are looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at csv@dreamhomenetwork.com.

Start advertising today

Explore options for real estate agents and homeowners advertising on LakeHouse.com
Sell Your Home

Explore Similar Properties

For Sale
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 1
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 2
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 3
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 4
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 5
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 6
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 7
2013 3 bedroom, 2 full bath manufactured home available for sale - photo 8

$108,000

3 Beds | 2.0 Baths | 906 Sqft

1903 Route 203 104, Chatham, NY, 12037

2013 3 bedroom, 2 full bath manufactured home available for sale

Added: 03/18/2026 • Updated: 07/12/2026
For Sale
Welcome to easy, carefree living in the desirable Greenwood - photo 1

$99,999

1 Beds | 1.0 Baths | 812 Sqft

89 Village Cir W, Manorville, NY, 11949

Welcome to easy, carefree living in the desirable Greenwood

Added: 07/13/2026 • Updated: 07/14/2026
Waterfront For Sale
Perfect opportunity for an owner occupy or an investor! Updated - photo 1
Perfect opportunity for an owner occupy or an investor! Updated - photo 2
Perfect opportunity for an owner occupy or an investor! Updated - photo 3
Perfect opportunity for an owner occupy or an investor! Updated - photo 4
Perfect opportunity for an owner occupy or an investor! Updated - photo 5
Perfect opportunity for an owner occupy or an investor! Updated - photo 6
Perfect opportunity for an owner occupy or an investor! Updated - photo 7
Perfect opportunity for an owner occupy or an investor! Updated - photo 8
Perfect opportunity for an owner occupy or an investor! Updated - photo 9
Perfect opportunity for an owner occupy or an investor! Updated - photo 10
Perfect opportunity for an owner occupy or an investor! Updated - photo 11
Perfect opportunity for an owner occupy or an investor! Updated - photo 12
Perfect opportunity for an owner occupy or an investor! Updated - photo 13
Perfect opportunity for an owner occupy or an investor! Updated - photo 14
Perfect opportunity for an owner occupy or an investor! Updated - photo 15
Perfect opportunity for an owner occupy or an investor! Updated - photo 16
Perfect opportunity for an owner occupy or an investor! Updated - photo 17
Perfect opportunity for an owner occupy or an investor! Updated - photo 18
Perfect opportunity for an owner occupy or an investor! Updated - photo 19
Perfect opportunity for an owner occupy or an investor! Updated - photo 20
Perfect opportunity for an owner occupy or an investor! Updated - photo 21
Perfect opportunity for an owner occupy or an investor! Updated - photo 22
Perfect opportunity for an owner occupy or an investor! Updated - photo 23
Perfect opportunity for an owner occupy or an investor! Updated - photo 24

$99,900

3 Beds | 2.0 Baths | 2,130 Sqft

43 Union St, Gowanda, NY, 14070

Perfect opportunity for an owner occupy or an investor! Updated

Added: 01/29/2026 • Updated: 06/19/2026
For Sale
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 1
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 2
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 3
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 4
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 5
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 6
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 7
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 8
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 9
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 10
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 11
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 12
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 13
Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a - photo 14

$99,000

2 Beds | 1.0 Baths | 792 Sqft

20 Lowerre Ln, Cornwallville, NY, 12418

Charming Updated 2-Bedroom, 1-Bath Single-Family Home in a

Added: 06/23/2026 • Updated: 06/29/2026
View more View More
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
MountainHomes.com BeachHouse.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 LakeHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.18
Terms & Policy

Search Filters
Price
-
0
$100,000
$100,000+
$200,000
$200,000+
$300,000
$300,000+
$400,000
$400,000+
$500,000
$500,000+
$600,000
$600,000+
$700,000
$700,000+
$800,000
$800,000+
$900,000
Any Price
Any Price
Beds & Baths
-
-
Property Type
Sale Status
More Filters
-
-
-
-
Advanced Search

(private lake, pond, coastal)

Read more
Sort By: Featured
  • Featured
  • Newest
  • Price - Low To High
  • Price - High To Low
  • Sqft - Low To High
  • Sqft - High To Low

(private lake, pond, coastal) Real Estate Agent Info

About (private lake, pond, coastal)

Click to activate
Request Information
By proceeding you authorize Dream Home Network Inc., its service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners), and its affiliates, to contact me using the contact details you provided, via phone call or text (SMS) using automated dialing technology for marketing or advertising purposes, including contacting me about my inquiry and other home-related matters. Not a condition for purchase. Message and data rates may apply.
This consent applies even if you are on a corporate, state or national Do Not Call list. Dream Home Network Inc. may share information about your recent and future site activity with its affiliates and service providers (including real estate professionals such as Brokers, Listing Agents, Buyers Agents, and local referral partners) to help them better understand what I am looking for in a property. To opt-out at any time you can reply "STOP" or contact Dream Home Network Inc. at  csv@dreamhomenetwork.com.
Contact Agent
By contacting this agent you agree to these Terms and Conditions.
Share this Ad
Link copied
Video/Virtual Tour
Loading...
SEARCH STATES
Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
MountainHomes.com BeachHouse.com GolfHomes.com BarrierFreeHome.com
SUBSCRIBE
Receive notifications for new listings
Subscribe
X Facebook Instagram YouTube

Dream Home Network Inc.

is committed to ensuring digital accessibility and property listings for individuals with disabilities. All information provided is deemed reliable but is not guaranteed and should be independently verified. We are continuously working to improve the accessibility of our web experience for everyone, and we welcome feedback and accommodation requests. If you wish to report an issue or seek an accommodation, please let us know.

Dream Home Network Inc. Sells leads to DHN Realty Inc. who holds real estate brokerage licenses in Alabama. Listing agents will be sent notification copy of leads on their listings where Dream Home Network Inc. is provided listings via our Feed Provider as required.

© 1997 - 2026 LakeHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.07.18
Terms & Policy