Buy
  • Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
    Canada Listings (730)
    Mexico Listings (329)
    Central America Listings (620)
    Caribbean Islands Listings (46)
    Asia Listings (20) Europe Listings (9)
    Advanced Search
Sell Find an Agent
BeachHouse.com BeachHouse.com
My Account
  • Login
  • Manage My Real Estate Ads
  • Manage My Search Profile / Auto Notify
  • My Account Info
  • Manage My Favorites
Advertise Join
  • Buy
  • 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 BeachHouse.com logo
Share
BeachHouse.com logo
Ad #7182549
MLS #100551081
Listing photo

Rare live/work opportunity in the heart of Sunset Beach

1790 Queen Anne St 5, Sunset Beach, NC 28468
$334,900
2Beds
4Baths
1,776Sqft
0.02Acres

About this property

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.

Property Features

2 Beds
4 Baths
1,776 Sqft
Built in 2006
0.02 Acres
3 Stories
Assigned
Siding: Brick, Wood Frame
Shingle Roof
Electric (Heating), Heat Pump (Heating)
$1,855 / yr property tax
Brunswick County
Seaside Village Community

Additional Photos

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

Contact Information

Candace R Mooney

ASAP Realty

910-664-2028

Location

Map
Listing Agent: Candace R Mooney (License #: 229186) 910-664-2028
Broker: ASAP Realty 910-477-1378 Listing Site
Copyright © 2026 Hive MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Aug 12, 2026

Photo Gallery

Rare live/work opportunity in the heart of Sunset Beach - photo 1
Rare live/work opportunity in the heart of Sunset Beach - photo 2
Rare live/work opportunity in the heart of Sunset Beach - photo 3
Rare live/work opportunity in the heart of Sunset Beach - photo 4
Rare live/work opportunity in the heart of Sunset Beach - photo 5
Rare live/work opportunity in the heart of Sunset Beach - photo 6
Rare live/work opportunity in the heart of Sunset Beach - photo 7
Rare live/work opportunity in the heart of Sunset Beach - photo 8
Rare live/work opportunity in the heart of Sunset Beach - photo 9
Rare live/work opportunity in the heart of Sunset Beach - photo 10
Rare live/work opportunity in the heart of Sunset Beach - photo 11
Rare live/work opportunity in the heart of Sunset Beach - photo 12
Rare live/work opportunity in the heart of Sunset Beach - photo 13
Rare live/work opportunity in the heart of Sunset Beach - photo 14
Rare live/work opportunity in the heart of Sunset Beach - photo 15
Rare live/work opportunity in the heart of Sunset Beach - photo 16
Rare live/work opportunity in the heart of Sunset Beach - photo 17
Rare live/work opportunity in the heart of Sunset Beach - photo 18
Rare live/work opportunity in the heart of Sunset Beach - photo 19
Rare live/work opportunity in the heart of Sunset Beach - photo 20
Rare live/work opportunity in the heart of Sunset Beach - photo 21
Rare live/work opportunity in the heart of Sunset Beach - photo 22
Rare live/work opportunity in the heart of Sunset Beach - photo 23
Rare live/work opportunity in the heart of Sunset Beach - photo 24
Rare live/work opportunity in the heart of Sunset Beach - photo 25
Rare live/work opportunity in the heart of Sunset Beach - photo 26

$334,900

2
Beds
4
Baths
1,776
Sqft

1790 Queen Anne St 5, Sunset Beach, NC 28468

By contacting this agent you agree to these Terms and Conditions.
Home North Carolina Sunset Beach
Rare live/work opportunity in the heart of Sunset Beach - photo 1
Rare live/work opportunity in the heart of Sunset Beach - photo 2
Rare live/work opportunity in the heart of Sunset Beach - photo 3
Rare live/work opportunity in the heart of Sunset Beach - photo 4
Rare live/work opportunity in the heart of Sunset Beach - photo 5
MLS# 100551081
Townhome/Townhouse For Sale

Rare live/work opportunity in the heart of Sunset Beach

$334,900

1790 Queen Anne St 5, Sunset Beach, NC 28468

2
Beds
4
Baths
1,776
Sqft
0.02
Acres
$334,900
1790 Queen Anne St 5, Sunset Beach, NC 28468
2 Beds
4 Baths
1,776 Sqft
0.02 Acres
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.
199 days
on BeachHouse.com
148
views
0
saves

Property Details

HOME DETAILS

2 Beds
4 Baths
1,776 Sqft
Built in 2006
0.02 Acres
3 Stories

EXTERIOR

Assigned
Siding: Brick, Wood Frame
Shingle Roof

INTERIOR

Electric (Heating), Heat Pump (Heating)

FINANCIAL & COMMUNITY

$1,855 / yr property tax
Brunswick County
Seaside Village Community
See More Details

Location

Map
Open in Google Maps

Mortgage Calculator

Ad Statistics

Ad Number
7182549
Viewed
148 times
Listing Status
Active
Added
Jan 24, 2026
Last Refreshed
Jul 03, 2026 06:17:28 PM

Listing Information

Data Source
Hive MLS
Source Property ID
100551081
Listing Agent: Candace R Mooney (License #: 229186) 910-664-2028
Broker: ASAP Realty 910-477-1378 Listing Site
Copyright © 2026 Hive 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 BeachHouse.com
Sell Your Home

Explore Similar Properties

For Sale
Life moves a little slower at Waterway Landing. From this - photo 1
Life moves a little slower at Waterway Landing. From this - photo 2
Life moves a little slower at Waterway Landing. From this - photo 3
Life moves a little slower at Waterway Landing. From this - photo 4
Life moves a little slower at Waterway Landing. From this - photo 5
Life moves a little slower at Waterway Landing. From this - photo 6
Life moves a little slower at Waterway Landing. From this - photo 7
Life moves a little slower at Waterway Landing. From this - photo 8
Life moves a little slower at Waterway Landing. From this - photo 9
Life moves a little slower at Waterway Landing. From this - photo 10
Life moves a little slower at Waterway Landing. From this - photo 11
Life moves a little slower at Waterway Landing. From this - photo 12
Life moves a little slower at Waterway Landing. From this - photo 13
Life moves a little slower at Waterway Landing. From this - photo 14
Life moves a little slower at Waterway Landing. From this - photo 15
Life moves a little slower at Waterway Landing. From this - photo 16
Life moves a little slower at Waterway Landing. From this - photo 17
Life moves a little slower at Waterway Landing. From this - photo 18
Life moves a little slower at Waterway Landing. From this - photo 19
Life moves a little slower at Waterway Landing. From this - photo 20
Life moves a little slower at Waterway Landing. From this - photo 21
Life moves a little slower at Waterway Landing. From this - photo 22
Life moves a little slower at Waterway Landing. From this - photo 23
Life moves a little slower at Waterway Landing. From this - photo 24
Life moves a little slower at Waterway Landing. From this - photo 25
Life moves a little slower at Waterway Landing. From this - photo 26
Life moves a little slower at Waterway Landing. From this - photo 27
Life moves a little slower at Waterway Landing. From this - photo 28
Life moves a little slower at Waterway Landing. From this - photo 29
Life moves a little slower at Waterway Landing. From this - photo 30
Life moves a little slower at Waterway Landing. From this - photo 31
Life moves a little slower at Waterway Landing. From this - photo 32
Life moves a little slower at Waterway Landing. From this - photo 33
Life moves a little slower at Waterway Landing. From this - photo 34
Life moves a little slower at Waterway Landing. From this - photo 35
Life moves a little slower at Waterway Landing. From this - photo 36
Life moves a little slower at Waterway Landing. From this - photo 37
Life moves a little slower at Waterway Landing. From this - photo 38
Life moves a little slower at Waterway Landing. From this - photo 39

$400,000

2 Beds | 2.0 Baths | 1,188 Sqft

1135 Park Rd SW 3204, Sunset Beach, NC 28468

Life moves a little slower at Waterway Landing. From this

Added: 07/01/2026 • Updated: 07/01/2026
For Sale
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 1
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 2
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 3
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 4
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 5
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 6
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 7
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 8
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 9
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 10
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 11
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 12
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 13
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 14
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 15
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 16
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 17
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 18
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 19
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 20
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 21
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 22
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 23
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 24
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 25
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 26
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 27
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 28
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 29
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 30
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 31
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 32
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 33
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 34
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 35
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 36
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 37
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 38
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 39
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 40
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 41
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 42
LOCATION!! Sunset Beach NC located ON the island and just steps - photo 43

$399,999

2 Beds | 1.0 Baths | 780 Sqft

420 1st St 2B, Sunset Beach, NC 28468

LOCATION!! Sunset Beach NC located ON the island and just steps

Added: 07/01/2026 • Updated: 07/08/2026
For Sale
Beautifully decorated and fully furnished second-floor end unit - photo 1
Beautifully decorated and fully furnished second-floor end unit - photo 2
Beautifully decorated and fully furnished second-floor end unit - photo 3
Beautifully decorated and fully furnished second-floor end unit - photo 4
Beautifully decorated and fully furnished second-floor end unit - photo 5
Beautifully decorated and fully furnished second-floor end unit - photo 6
Beautifully decorated and fully furnished second-floor end unit - photo 7
Beautifully decorated and fully furnished second-floor end unit - photo 8
Beautifully decorated and fully furnished second-floor end unit - photo 9
Beautifully decorated and fully furnished second-floor end unit - photo 10
Beautifully decorated and fully furnished second-floor end unit - photo 11
Beautifully decorated and fully furnished second-floor end unit - photo 12
Beautifully decorated and fully furnished second-floor end unit - photo 13
Beautifully decorated and fully furnished second-floor end unit - photo 14
Beautifully decorated and fully furnished second-floor end unit - photo 15
Beautifully decorated and fully furnished second-floor end unit - photo 16
Beautifully decorated and fully furnished second-floor end unit - photo 17
Beautifully decorated and fully furnished second-floor end unit - photo 18
Beautifully decorated and fully furnished second-floor end unit - photo 19
Beautifully decorated and fully furnished second-floor end unit - photo 20
Beautifully decorated and fully furnished second-floor end unit - photo 21
Beautifully decorated and fully furnished second-floor end unit - photo 22
Beautifully decorated and fully furnished second-floor end unit - photo 23

$399,777

3 Beds | 3.0 Baths | 1,430 Sqft

182 Clubhouse Rd. 4, Sunset Beach, NC 28468

Beautifully decorated and fully furnished second-floor end unit

Added: 04/06/2026 • Updated: 07/07/2026
For Sale
Beautifully decorated and fully furnished second-floor end unit - photo 1
Beautifully decorated and fully furnished second-floor end unit - photo 2
Beautifully decorated and fully furnished second-floor end unit - photo 3
Beautifully decorated and fully furnished second-floor end unit - photo 4
Beautifully decorated and fully furnished second-floor end unit - photo 5
Beautifully decorated and fully furnished second-floor end unit - photo 6
Beautifully decorated and fully furnished second-floor end unit - photo 7
Beautifully decorated and fully furnished second-floor end unit - photo 8
Beautifully decorated and fully furnished second-floor end unit - photo 9
Beautifully decorated and fully furnished second-floor end unit - photo 10
Beautifully decorated and fully furnished second-floor end unit - photo 11
Beautifully decorated and fully furnished second-floor end unit - photo 12
Beautifully decorated and fully furnished second-floor end unit - photo 13
Beautifully decorated and fully furnished second-floor end unit - photo 14
Beautifully decorated and fully furnished second-floor end unit - photo 15
Beautifully decorated and fully furnished second-floor end unit - photo 16
Beautifully decorated and fully furnished second-floor end unit - photo 17
Beautifully decorated and fully furnished second-floor end unit - photo 18
Beautifully decorated and fully furnished second-floor end unit - photo 19
Beautifully decorated and fully furnished second-floor end unit - photo 20
Beautifully decorated and fully furnished second-floor end unit - photo 21
Beautifully decorated and fully furnished second-floor end unit - photo 22
Beautifully decorated and fully furnished second-floor end unit - photo 23
Beautifully decorated and fully furnished second-floor end unit - photo 24
Beautifully decorated and fully furnished second-floor end unit - photo 25
Beautifully decorated and fully furnished second-floor end unit - photo 26
Beautifully decorated and fully furnished second-floor end unit - photo 27
Beautifully decorated and fully furnished second-floor end unit - photo 28
Beautifully decorated and fully furnished second-floor end unit - photo 29
Beautifully decorated and fully furnished second-floor end unit - photo 30
Beautifully decorated and fully furnished second-floor end unit - photo 31

$399,777

3 Beds | 3.0 Baths | 1,430 Sqft

182 Clubhouse Rd Apt 4, Sunset Beach, NC 28468

Beautifully decorated and fully furnished second-floor end unit

Added: 03/07/2026 • Updated: 07/01/2026
SEARCH STATES
Alabama Alaska California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.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 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
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

Sunset Beach

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

Sunset Beach Real Estate Agent Info

About Sunset Beach

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 California Connecticut Delaware Florida Georgia Hawaii Louisiana Maine Maryland Mississippi New Hampshire New Jersey New York North Carolina Oregon Pennsylvania Rhode Island South Carolina Texas Virginia Washington
SERVICES
Buy Buy Advertise
COMPANY
Testimonials About Us Office Locations
SUPPORT
Help Contact Us
ADDITIONAL MARKETS
LakeHouse.com MountainHomes.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 BeachHouse.com
Part of Dream Home Network, Inc.
Last updated on 2026.08.11
Terms & Policy