Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Please reload the page to update with the latest MLS information available.

Reload
 
Listing provided courtesy of Coldwell Banker Sloane Realty OIB- MLS# 100579504MLS Provider

1004 Great Egret Circle SW ## 2Sunset Beach, NC 28468

Condo · 2 Beds · 2 Full Baths · 1,030 Sq. ft.
$235,000 Active

1004 Great Egret Circle SW ## 2 Overview

Time on Site:
24 days
Visits:
0

Enjoy pond-front living with peaceful fairway views in this immaculate ground-floor condo, ideally tucked away in a secluded setting within the community. Inside, easy-care luxury vinyl plank and tile flooring run throughout--no carpet--complemented by a light, beach-inspired color palette that creates a relaxed coastal feel. The efficient kitchen features solid-surface countertops, and the four-door refrigerator is just two years old. Unwind on the screened porch and take in tranquil water views with the #4 Piper Course at Sandpiper Bay in the distance. This prime location is near the end of a quiet dead-end drive and close to one of the community's two pools, as well as the tennis and pickleball courts. Whether you're searching for a personal getaway, full-time residence, or investment opportunity, this condo offers exceptional flexibility with both short- and long-term rentals allowed. All this and only a short drive to local beaches, shopping, dining, golf, and more in ever-popular Sunset Beach! See it soon!

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

1004 Great Egret Circle SW ## 2 Facts & Features

  • Type Condo
  • Sq. ft. 1,030
  • Price/Sq.ft. $228

Details

General

Association/HOA

  • Association Amenities: Barbecue,Community Pool,Golf Course,Maintenance Common Areas,Maintenance Grounds,Maintenance Roads,Maintenance Structure,Management,Master Insure,Pickleball,Picnic Area,Sewer,Sidewalks,Street Lights,Tennis Court(s),Termite Bond,Water,Short Term Rental
  • Association Fee: 5916.00
  • Association Fee Frequency: Annually
  • Association Name: Sunset Village@Sandpiper Bay HOA
  • Association: true

School Information

  • School District: Brunswick County Schools
  • Elementary School: Jessie Mae Monroe Elementary
  • Middle Or Junior School: Shallotte Middle
  • High School: West Brunswick

Building Information

  • New Construction: false
  • Year Built: 2004

Location/Region

  • County Or Parish: Brunswick
  • Subdivision Name: Sandpiper Bay

Tax Information

  • Tax Assessed Value: 213350
  • Tax Year: 2025

General Information

  • Furnished: Unfurnished
  • Listing Terms: Cash,Conventional
  • Parcel Number: 227pa308
  • Property Sub Type: Condominium
  • Property Type: Residential
  • Special Listing Conditions: Standard
  • Zoning: SB-MR-3

Interior

Parking Information

  • Garage: false

Beds/Baths

  • Bathrooms Full: 2
  • Bathrooms Half: 0
  • Bathrooms Total: 2
  • Bedrooms Total: 2

Building Interior

  • Building Area Total: 1030.0

General Information

  • Appliances: Built-In Microwave,Washer,Refrigerator,Dryer,Disposal,Dishwasher,Electric Range
  • Basement: None
  • Cooling: Ceiling Fan(s),Heat Pump
  • Entry Level: 1
  • Flooring: LVT/LVP,Tile
  • Foundation Details: Slab
  • Interior Features: Walk-in Closet(s),Entrance Foyer,Solid Surface,Ceiling Fan(s),Pantry,Blinds/Shades,Walk-In Closet(s)
  • Laundry Features: Dryer Hookup,Washer Hookup
  • Levels: End Unit,One
  • Living Area: 1030.00
  • Living Area Units: Square Feet
  • Rooms Total: 4
  • Security Features: Smoke Detector(s)
  • Stories Total: 2
  • Window Features: Thermal Windows

Unit Information

  • Unit Number: # 2

Exterior

Parking Information

  • Parking Features: Parking Lot,Paved

Lot Information

  • Frontage Type: Pond Front
  • Lot Features: Dead End,Level,Near Golf Course
  • Road Surface Type: Paved
  • Water Source: County Water

Waterfront/View

  • View: Golf Course,Pond,Golf Fairway
  • Waterfront Features: None
  • Waterfront: false

Building Exterior/Construction

  • Attached Garage: false
  • Construction Materials: Vinyl Siding,Wood Frame
  • Patio And Porch Features: Screened,Rear Porch
  • Roof: Shingle
  • Structure Type: Wood Frame,Stick Built

General Information

  • Exterior Features: Cluster Mailboxes,End Unit
  • Fencing: None
  • Horse: false
  • Road Frontage Type: Private Road,Paved
  • Utilities: Sewer Connected,Underground Utilities,Water Connected

Room Information

Room: Bedroom 2

    Room: Great Room

      Room: Kitchen

        Room: Master Bedroom

          Find, Buy & Move into Your Home with Us.

          Instead of having a mortgage team here, an insurance agent there, a REALTOR® down the street, an inspector and a moving company across town, you have one team with one goal and one focus: you. Ask for “All-Inclusive” Buying.

          Enjoy the sense of confidence knowing your Long & Foster full team can handle it all. Your agent is supported by a team of specialists in Mortgage, Insurance, Title, Inspection, Moving and Property Management who are there to guide you every step of the way. They’ll make sure things run smoothly, closing happens on time, and you arrive at your dream home according to plan.

          Accolades:
          98 %
          Customer
          Satisfaction
          4.8

          311 Reviews
          Top Services:
          • Buying
          • Selling
          • Rental Properties
          • Investment Properties
          • Luxury Properties
          Key Advantages:
          • Be your guide with expert knowledge of your area
          • Help find your home and offer objective information and opinions
          • Stand in your corner during negotiations
          • Assist with paperwork and details to get you to closing
          • Connect you to vendors if work is needed

          Our mortgage affiliate, Prosperity Home Mortgage, will get you approved for a mortgage before shopping for a home. This will make your offer stand out and give you an edge in a highly competitive market. If you are already pre-approved, no problem, we can take a “second look” and try to get you even better terms.

          Accolades:
          97 %
          Customer
          Satisfaction
          5.0

          3,803 Reviews
          Top Services:
          • Fixed & adjustable rate mortgages
          • FHA and VA mortgage programs
          • Rapid Close™
          • USDA Loans
          Key Advantages:
          • Full suite of mortgage programs to meet your specific needs
          • Friendly professionals guide through every step of the loan process
          • We help you find and lock in on the market’s best interest rate
          • We work closely with your title company to ensure accurate closing

          We help you make good decisions when you’re buying a home and learn how to be a better homeowner after you move-in. We streamline your inspection journey, provide thorough and accurate results, and get you to closing peacefully. Schedule a confirmed inspection online 24x7.

          Accolades:
          97 %
          Customer
          Satisfaction
          5.0

          240 Reviews
          Top Services:
          • Home Inspection
          • Radon Gas
          • Termite Inspection
          • Test Indoor Air Quality
          • Pay at Closing*
          Key Advantages:
          • Scheduling online 24x7 confirm a convenient date & time for you & your agents
          • High-tech journey makes it easy to sign agreement, make payment, view reports
          • One stop shop for home, radon & termite
          • Knowledgeable, friendly inspectors teach you about your home and property
          • Custom homeowner’s manual teaches you how to maintain your home

          * A Long & Foster exclusive benefit. If you work with RGS Title or Sage Title Group and Insight Inspections, your can enjoy a $55 discount and the flexibility to pay for the inspection at settlement. This new approach combines the best of both the title and inspection worlds, creating a seamless and integrated journey.

          We carefully examine your new home’s title, get your legal documents in order, and safeguard your investment. With a team of specialists who expect the unexpected, you can anticipate an on-time, worry-free closing.

          Accolades:
          97 %
          Customer
          Satisfaction
          4.9

          Reviews
          Top Services:
          • Title Search & Status
          • Title Insurance
          • Document Prep
          • Closing Coordination
          • Filing & Recording
          Key Advantages:
          • Ensure that there are no unresolved claims or liens on your home’s title
          • Help secure insurance against unexpected title challenges
          • Prepare closing paperwork to ensure documents are in compliance with laws
          • Coordinate with all parties to schedule final closing
          • File & record your paperwork with the courthouse

          We help you secure the proper coverage at a competitive price to protect your largest investment — your home. Our insurance agents work closely with you to understand your risk exposures, educate you on your options, protect you from the unexpected, and develop insurance strategies to offer ongoing service to address your ever-changing insurance needs.

          Accolades:
          98 %
          Customer
          Satisfaction
          4.9

          77 Reviews
          Top Services:
          • Home Insurance
          • Auto Insurance
          • Umbrella Insurance
          • Motorcycle, Boat, RV and more
          Key Advantages:
          • Specialize in real estate and bundle other policies for savings
          • Work with 10+ leading carriers to secure the best coverage at the best cost
          • Save you time by shopping for you
          • We’re independent - we find and present you with the best offers and let you decide
          • Guide you with ongoing service and support

          We ensure a smooth, stress-free move so you can start enjoying your new home as soon as you move in. Whether you’re headed down the street or across the country, our moving specialists will make sure you don’t have to lift a finger.

          Accolades:
          98 %
          Customer
          Satisfaction
          4.6

          953 Reviews
          Top Services:
          • Packing & Unpacking
          • Decluttering
          • Storage
          • Local or Long Distance
          • International Moving
          Key Advantages:
          • 30-minute guided virtual survey with next business day Guaranteed quote
          • Best Price Guarantee*†
          • 2-months free storage*‡
          • $20,000 full value protection*
          • Personal move concierge - from first call until last box is delivered

          * Long & Foster Customers Only. † Examples of qualified movers: any major van line (United, Mayflower, Atlas, North American, etc) for local: JK, Hilldrup, Town and Country, Able, Interstate, All my Sons, Olympia, Gentle Giant. ‡ 2 Months Free Storage Program: If you’re moving from DE, MD, DC or VA and to DE, MD, DC or VA, we offer 2 months of free storage for all of the contents of your home. There is no charge for the storage of the items for 2 months. There is a cost for pickup of the items to go to storage and for delivery of items from storage to the new home.

          We are the next generation of property management. With our streamlined processes, best-in-class service, and transparent financial updates, we help investors achieve financial success through real estate.

          Accolades:
          98 %
          Customer
          Satisfaction
          4.8

          120 Reviews
          Top Services:
          • Property Surveys
          • Marketing
          • Tenant Screening
          • Maintenance
          • Lease Enforcement
          Key Advantages:
          • We’ll guide and help identify the right properties to invest in
          • Use of smart devices, predictive data and analytics to help maintain properties
          • Get more free time when we handle billing and payments
          • We continuously monitor state and federal landlord/tenant laws
          • Become more knowledgeable with quarterly portfolio reviews & guidance

          • Enjoy the sense of confidence knowing your Long & Foster full team can handle it all. Your agent is supported by a team of specialists in Mortgage, Insurance, Title, Inspection, Moving and Property Management who are there to guide you every step of the way. They’ll make sure things run smoothly, closing happens on time, and you arrive at your dream home according to plan.

            Accolades:
            98 %
            Customer
            Satisfaction
            4.8

            311 Reviews
            Top Services:
            • Buying
            • Selling
            • Rental Properties
            • Investment Properties
            • Luxury Properties
            Key Advantages:
            • Be your guide with expert knowledge of your area
            • Help find your home and offer objective information and opinions
            • Stand in your corner during negotiations
            • Assist with paperwork and details to get you to closing
            • Connect you to vendors if work is needed

          • Our mortgage affiliate, Prosperity Home Mortgage, will get you approved for a mortgage before shopping for a home. This will make your offer stand out and give you an edge in a highly competitive market. If you are already pre-approved, no problem, we can take a “second look” and try to get you even better terms.

            Accolades:
            97 %
            Customer
            Satisfaction
            5.0

            3,803 Reviews
            Top Services:
            • Fixed & adjustable rate mortgages
            • FHA and VA mortgage programs
            • Rapid Close™
            • USDA Loans
            Key Advantages:
            • Full suite of mortgage programs to meet your specific needs
            • Friendly professionals guide through every step of the loan process
            • We help you find and lock in on the market’s best interest rate
            • We work closely with your title company to ensure accurate closing

          • We carefully examine your new home’s title, get your legal documents in order, and safeguard your investment. With a team of specialists who expect the unexpected, you can anticipate an on-time, worry-free closing.

            Accolades:
            97 %
            Customer
            Satisfaction
            4.9

            Reviews
            Top Services:
            • Title Search & Status
            • Title Insurance
            • Document Prep
            • Closing Coordination
            • Filing & Recording
            Key Advantages:
            • Ensure that there are no unresolved claims or liens on your home’s title
            • Help secure insurance against unexpected title challenges
            • Prepare closing paperwork to ensure documents are in compliance with laws
            • Coordinate with all parties to schedule final closing
            • File & record your paperwork with the courthouse

          • We help you secure the proper coverage at a competitive price to protect your largest investment — your home. Our insurance agents work closely with you to understand your risk exposures, educate you on your options, protect you from the unexpected, and develop insurance strategies to offer ongoing service to address your ever-changing insurance needs.

            Accolades:
            98 %
            Customer
            Satisfaction
            4.9

            77 Reviews
            Top Services:
            • Home Insurance
            • Auto Insurance
            • Umbrella Insurance
            • Motorcycle, Boat, RV and more
            Key Advantages:
            • Specialize in real estate and bundle other policies for savings
            • Work with 10+ leading carriers to secure the best coverage at the best cost
            • Save you time by shopping for you
            • We’re independent - we find and present you with the best offers and let you decide
            • Guide you with ongoing service and support

          • We help you make good decisions when you’re buying a home and learn how to be a better homeowner after you move-in. We streamline your inspection journey, provide thorough and accurate results, and get you to closing peacefully. Schedule a confirmed inspection online 24x7.

            Accolades:
            97 %
            Customer
            Satisfaction
            5.0

            240 Reviews
            Top Services:
            • Home Inspection
            • Radon Gas
            • Termite Inspection
            • Test Indoor Air Quality
            • Pay at Closing*
            Key Advantages:
            • Scheduling online 24x7 confirm a convenient date & time for you & your agents
            • High-tech journey makes it easy to sign agreement, make payment, view reports
            • One stop shop for home, radon & termite
            • Knowledgeable, friendly inspectors teach you about your home and property
            • Custom homeowner’s manual teaches you how to maintain your home

            * A Long & Foster exclusive benefit. If you work with RGS Title or Sage Title Group and Insight Inspections, your can enjoy a $55 discount and the flexibility to pay for the inspection at settlement. This new approach combines the best of both the title and inspection worlds, creating a seamless and integrated journey.

          • We ensure a smooth, stress-free move so you can start enjoying your new home as soon as you move in. Whether you’re headed down the street or across the country, our moving specialists will make sure you don’t have to lift a finger.

            Accolades:
            98 %
            Customer
            Satisfaction
            4.6

            953 Reviews
            Top Services:
            • Packing & Unpacking
            • Decluttering
            • Storage
            • Local or Long Distance
            • International Moving
            Key Advantages:
            • 30-minute guided virtual survey with next business day Guaranteed quote
            • Best Price Guarantee*†
            • 2-months free storage*‡
            • $20,000 full value protection*
            • Personal move concierge - from first call until last box is delivered

            * Long & Foster Customers Only. † Examples of qualified movers: any major van line (United, Mayflower, Atlas, North American, etc) for local: JK, Hilldrup, Town and Country, Able, Interstate, All my Sons, Olympia, Gentle Giant. ‡ 2 Months Free Storage Program: If you’re moving from DE, MD, DC or VA and to DE, MD, DC or VA, we offer 2 months of free storage for all of the contents of your home. There is no charge for the storage of the items for 2 months. There is a cost for pickup of the items to go to storage and for delivery of items from storage to the new home.

          • We are the next generation of property management. With our streamlined processes, best-in-class service, and transparent financial updates, we help investors achieve financial success through real estate.

            Accolades:
            98 %
            Customer
            Satisfaction
            4.8

            120 Reviews
            Top Services:
            • Property Surveys
            • Marketing
            • Tenant Screening
            • Maintenance
            • Lease Enforcement
            Key Advantages:
            • We’ll guide and help identify the right properties to invest in
            • Use of smart devices, predictive data and analytics to help maintain properties
            • Get more free time when we handle billing and payments
            • We continuously monitor state and federal landlord/tenant laws
            • Become more knowledgeable with quarterly portfolio reviews & guidance

          1004 Great Egret Circle SW ## 2 Neighborhood

          Community

          28468 (Sunset Beach) Demographics

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

          Schools

          School data courtesy of LiveBy, Inc. School ratings are based on a scale of 1-5, with 5 being the highest rating and 1 being the lowest rating.

          1004 Great Egret Circle SW ## 2 Monthly Cost

          $
          $ %
          %
          $
          $
          * 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.

          1004 Great Egret Circle SW ## 2 Market Data

          Based on the last 30 days in this zip code

          $457,134
          Average List Price
          $270
          Average Price per Square Foot
          0
          Properties Sold
          97
          Average Days on Market
          35
          Properties for Sale
          Calculations provided by Reliance Network

          1004 Great Egret Circle SW ## 2 History

          Date Event Value Agent
          6/6/2026Source: Hive MLS Added to Database
          June 06, 2026