Aquarian Condos - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Unobstructed Views! - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 3 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 4 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 5 of 58
3 bedrooms, 2 baths, 2 covered balconies - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Beach access right next door - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 8 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 9 of 58
Fully furnished - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 11 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 12 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 13 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 14 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 15 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 16 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 17 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 18 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 19 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 20 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 21 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 22 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 23 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 24 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 25 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 26 of 58
En suite w/2nd Bedroom - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
En suite w/hall bath - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
En suite w/hall bath - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
En suite bath - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
En suite bath, sliding doors to balcony - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Off primary bedroom - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Off primary bedroom - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 34 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 35 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 36 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 37 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 38 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 39 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 40 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 41 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 42 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 43 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 44 of 58
Top right, beach access to right - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Top right, beach access on right - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Ocean front with harbour views in back - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Top right, beach access on right - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 49 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 50 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 51 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 52 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 53 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 54 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 55 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 56 of 58
Condominium at 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428, photo 57 of 58
Top right - welcome home! - 900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
58 photos

$675,000

900 Carolina Beach Avenue N Apt F, Carolina Beach, NC 28428
Carolina Beach, NC 28428
Listed by Mary Kaye Hester · Nest Realty
Bedrooms
3
Bathrooms
2
Living area
1,200 sqft
Year built
1986

About this home

Perched on the top floor of Aquarian Condos, this bright 3-bedroom, 2-bath end unit offers breathtaking, unobstructed oceanfront & southern coastline views in an intimate & friendly community of just six privately owned homes. With a strict no-rental policy, Aquarian offers something increasingly hard to find at the beach: a peaceful, uncrowded setting reserved exclusively for its owners and their guests. Equally rare, the beautifully maintained building reflects the pride of its owners & the attentive oversight of a proactive HOA. Spanning 1,200 square feet, this light-filled home celebrates its spectacular coastal setting throughout. Vaulted living room ceilings, charming bay windows, & expansive sliding glass doors frame endless ocean views, while the covered oceanfront balcony invites you to savor morning sunrises & the soothing rhythm of the waves. Enjoy Carolina Beach fireworks from the comfort of your living room! Down the hall, the primary suite opens to a second private balcony with views of the harbor & features a double vanity & walk-in shower. Two additional bedrooms share a full bath, with direct access from one of them. Skylights brighten both bathrooms, while the galley-style kitchen is open to those captivating ocean views. Offered fully furnished with appliances, this coastal haven is ready for your immediate enjoyment. Other conveniences include 2 assigned parking spaces & a private ground-level storage room. Public beach access is right next door, with a neighborhood café, mini-market, & town dinghy dock just across the street. The Carolina Beach Boardwalk is less than a mile away. If you've been longing for the beauty of oceanfront living without the bustle of vacation rentals, this is an extraordinary opportunity to make a coveted stretch of Carolina Beach your very own private escape. Schedule your showing today!

Highlights

Waterfront

Property details

MLS
Hive MLS
MLS #
100613490
Property type
Condominium
Subdivision
Aquarian Condo
Status
Active
Days on market
1
On market date
October 30, 2026
Stories
N/A
Total bathrooms
2
Garage spaces
N/A
Parking spaces
2
Lot size
N/A
Loading map…

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.

Elementary
Carolina Beach Elementary
1.18 mi away · Grades 0-5
Zoned school (attendance boundary, 2015-16 data)
4.0
Local Score (state rating (2025) blended 70/30 with student-teacher ratio) -- not an official state rating
State rating: B (2025)
Enrollment
409
Student:teacher ratio
14.6:1
District
New Hanover County Schools
Middle
Charles P Murray Middle
4.05 mi away · Grades 6-8
Zoned school (attendance boundary, 2015-16 data)
3.7
Local Score (state rating (2025) blended 70/30 with student-teacher ratio) -- not an official state rating
State rating: B (2025)
Enrollment
832
Student:teacher ratio
16.6:1
District
New Hanover County Schools
High
Eugene Ashley High
4.07 mi away · Grades 9-12
Zoned school (attendance boundary, 2015-16 data)
2.7
Local Score (state rating (2025) blended 70/30 with student-teacher ratio) -- not an official state rating
State rating: C (2025)
Enrollment
1,931
Student:teacher ratio
18.2:1
District
New Hanover County Schools

Walkability

Blended score for Carolina Beach'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).

61
Walkable
out of 100
EPA National Walkability Index
8.3 / 20 -- Below average walkable
Google Places amenity density
90 / 100
Restaurants & cafes20
Grocery stores6
Parks20
Schools4
Transit stops0
Pharmacies5

Market position

How this listing compares to current activity in Carolina Beach, from live MLS data.

On the market 1 days -- 114 fewer days than Carolina Beach's current average of 115 days.
For reference, the median list price across 255 active listings in Carolina Beach right now is $599,900.

Mortgage calculator

Estimate only - actual rate and payment depend on your lender, credit, and loan program.

$
%
%
Adjust tax / insurance estimates
% / yr
$
/mo
Est. monthly payment
$4,215/mo
$135,000 down
$540,000 loan
Principal & interest$3,502
Property tax (est.)$563
Home insurance (est.)$150

Similar homes you might like

Data source: Listing information provided by Hive MLS via Trestle/CoreLogic. Last updated 23 hr ago.

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.