$774,000
About this home
Exceptional waterfront opportunity with 120 feet of water frontage on a rare DOUBLE lot. This versatile property is thoughtfully set up as two separate units — ideal for short-term rental income, multi-generational living, or a private mother-in-law suite. The first-floor unit offers a 2-bedroom, 1-bath layout, while the upper level features a spacious 3-bedroom, 2-bath configuration. Both units have been updated with new paint, flooring, and modern fixtures, creating a clean and cohesive feel throughout. Major improvements provide peace of mind, including a new mini-split HVAC system, new electrical, new blown insulation, tankless water heater, and new deck, hurricane-rated windows, and doors. Outdoors, you’ll love the new tongue-and-groove ceiling detail, new vinyl fencing, insulated storage space, and a pool with a new pump and filter — perfect for enjoying the waterfront lifestyle. A shared common area with laundry services both units, adding convenience for guests or extended family. Whether you're looking for a high-performing investment property, a flexible primary residence with rental potential, or a true waterfront retreat, this property delivers location, upgrades, and opportunity all in one.
Highlights
Property details
- MLS #
- MFRTB8483514
- Property type
- Duplex
- Subdivision
- DRIFTWOOD ISLES
- Status
- Active
- Days on market
- 125
- On market date
- March 5, 2026
- Stories
- N/A
- Total bathrooms
- N/A
- Garage spaces
- N/A
- Parking spaces
- N/A
- Lot size
- 0.3 acres
Location
Get directions →Nearby schools
Within 10 miles. School directory data from the National Center for Education Statistics (NCES), accessed via the Urban Institute Education Data API. Local Score is calculated by INNOVATE Real Estate; where a state rating is shown, it comes from that state's own official school report card (e.g. NC Dept. of Public Instruction, SC Report Card).
- Enrollment
- 733
- Student:teacher ratio
- 15.9:1
- District
- PASCO
- Enrollment
- 994
- Student:teacher ratio
- 18.4:1
- District
- PASCO
- Enrollment
- 184
- Student:teacher ratio
- 7.7:1
- District
- PASCO
Walkability
Blended score for HUDSON's center, calculated by INNOVATE Real Estate from two sources: the EPA's National Walkability Index (street network, transit, land-use mix) and Google Places amenity data (what's actually reachable on foot from this point). 60% EPA National Walkability Index + 40% nearby-amenity density (Google Places).
Mortgage calculator
Estimate only - actual rate and payment depend on your lender, credit, and loan program.
Adjust tax / insurance estimates
Similar homes you might like
Data source: Listing information provided by Stellar MLS (mfrmls) via Trestle/CoreLogic. Last updated July 8, 2026.
Information herein deemed reliable but not guaranteed; all measurements, school assignments, HOA fees, taxes, and feature lists are approximate and should be independently verified. Equal Housing Opportunity.