Listing provided courtesy of ASAP RealtyMLS# 100551081MLS Provider
  • 157 days on site
  • 2 views

Rare live/work opportunity in the heart of Sunset Beach, offering flexible use and investment potential in this sought-after location. This versatile unit features ground-floor commercial space complete with a waiting room, office, half bath, and storage, while the residential living space above offers a private, separate entrance. Ideal for investors, business owners, or those seeking a coastal getaway with income-producing potential. The property is set within a peaceful, park-like community with convenient access to grocery, shopping, dining, and just minutes to oceanfront Sunset Beach. Inside you will find a welcoming foyer leading upstairs to the 2 bedroom unit. The main living level offers a spacious living area with wainscoting accents, laundry, a half bath, and kitchen featuring stainless steel appliances, granite countertops, and a pantry. The top floor includes two generously sized bedrooms, each with closets and private baths, making it ideal for guests or as a beach getaway investment property. Enjoy the coastal lifestyle with a quick bike ride or short drive to the beach and nearby Sunset Beach Town Park, known for its majestic live oak canopies, shaded walking paths, and seasonal arts and crafts festivals. Whether used as a primary residence, second home, or investment, this property offers a unique blend of coastal lifestyle and opportunity.

Source: Hive MLS, MLS#: 100551081

Love this property?
Create a profile so you can receive updates on this property as soon as they happen!
  • Property Type
    Residential
  • Lot
    0.02 acres

Get in Contact

Would you like to know more about this property? We're here to help! Let's connect and find what you're looking for.

Chris Prince

Create a profile so you can receive updates on this property as soon as they happen!

  • Median Age
    63
  • Population Density
    226
  • College Educated
    56%
  • Estimated Median Income
    $59,883
  • Estimated Total Home Owners
    1,808
  • Estimated Total Renters
    400
  • Owner / Renter Divide
    82% / 18%
  • Estimated Average Household Size
    2
  • Total Population
    4,388
  • Community data courtesy of LiveBy, Inc.

Owning this Home

$
$ %
%
* All calculations are estimates and provided by Reliance Network, for informational purposes only. Actual amounts may vary. ** Assumes 6.50% APR, 20% down payment, and conventional 30-year fixed rate first mortgage. Rates cited are for instructional purposes only; current rates are subject to change at any time without notice. You should not make any decisions based simply on the information provided. Additional required amounts such as taxes, insurance, homeowner association dues, assessments, mortgage insurance premiums, flood insurance or other such required payments should also be considered. Contact your mortgage company for current rates and additional information. Any mortgage broker or insurance agent that may appear is independent and is not affiliated with, endorsed by, or provided by the MLS.

Want to talk? Contact us here.

Want to talk? Contact us here.

Want to talk? Contact us here.

Life at 1790 Queen Anne Street #Unit 5


Schools


School data courtesy of LiveBy, Inc.
Ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating. The schools displayed on this website are for informational purposes only and may not represent a complete or up-to-date list. School assignments are subject to change and should be verified directly with the local school district. Please contact the appropriate school district to confirm school zoning and enrollment eligibility for this property.

History

Date Event Value Agent
4/3/2026Source: Hive MLS Price Reduction
$334,900 -1.5%
3/17/2026Source: Hive MLS Price Reduction
$339,900 -2.9%
1/24/2026Source: Hive MLS Added to Database
January 24, 2026

This site uses cookies to improve your user experience. Continuing to browse means you accept our use of cookies. Our Privacy Policy.