Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1894 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1894 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1894 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

3530 Van Buren Street Sw
Supply, NC 28462

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,999,000
Beds: 3
Baths: 6
Status: Active
SqFt: 6093
Agency: PROACTIVE Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 2005
Notes: INCREDIBLE OPPORTUNITY NEW PRICE PLUS OWNER FINANCING!! Extraordinary Coastal Waterfront Estate with panoramic views of the Shallotte River & Intracoastal Waterway is perfectly situated on a high bluff to maximize all the incredible views. This Luxurious residence sits on 3.11 acres with 320'+ of River Front. The direct water access is a boater's dream. Private & secluded with a gated entry & fully fenced in perimeter. Entering the front gates, you are greeted with lush landscaping & your very own putting green off to the right. The circular drive brings you to the grand front entrance & oversized 3+ car garage. Through the front door is a jaw dropping grand 2 story entry with eye catching water views beyond the glass French door leading outside. The exquisite foyer chandelier sets the tone for all the luxurious architectural details you will find throughout this beautifully designed home. No detail was overlooked in the meticulously maintained property. The formal dining room is framed with decorative arches & features another magnificent crystal chandelier. Gorgeous Italian inspired chefs' kitchen with artisan custom cabinets. The charming breakfast area has doors leading to the outdoor lanai. This is a serene spot for enjoying your morning coffee & taking in more picturesque water views. The stunning grand living has a gorgeous wood burning fireplace, more custom cabinets, elaborate wood ceilings details, and a wet bar with stone countertops. An elegant powder room is conveniently tucked away around the corner. On the opposite side of the residence are 2 private ensuites with large walk-in closets. Head upstairs to the bonus room over the garage with a full bath & endless floored attic storage. First floor laundry has a deep utility sink. Ready for a swim? Meander down to the pool house. This incredible pool house has a kitchenette with countertop seating, living space, full bathroom, and plenty of additional storage. This beautifully designed outdoor area has covered outdoor dining, grilling area, fire pit area with built-in seating, and a magnificent waterfall feature running the length of the entire pool area. Cross the small bridge over the cascading waterfall to an amazing deck overlooking the water. The outdoor lanai is a fantastic area to unwind in the evening or entertain family & friends. This rare & captivating property has it ALL! Must see in person. Schedule your private tour today. Owner financing is available with 25% down 5% interest only for 5 years or 20% down and 4.5 % fixed for 30 years. Less than 8 miles from Holden Beach Island!
MlsNumber: 100411865


Listing Provided By: PROACTIVE Real Estate, original listing
Name: PROACTIVE Real Estate
Phone: (910) 842-1616
Office Name: PROACTIVE Real Estate
Office Phone: (910) 842-1616
Agent Name: Michele Klock
Disclaimer: Copyright © 2024 NCRMLS/ Brunswick County Association of REALTORS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 1894 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Corey Hunt
Corey Hunt
ASCIIColdwell Banker Sea Coast Realty
Call Today!: (910) 231-4710

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App