Title Page Background
DEBUG FN args: Array ( [0] => 1899 [1] => [2] => [3] => agent ) BEFORE: Site: 1899 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1899 Igate: njhud LocID: 1899 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1899 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1899 [1] => [2] => [3] => lender ) BEFORE: Site: 1899 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1899 Igate: njhud LocID: 1899 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1899 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1899 [1] => [2] => [3] => other ) BEFORE: Site: 1899 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1899 Igate: njhud LocID: 1899 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1899 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

105 Blue Heron Rd Road
Shiloh, NC 27974
Nicole Price with A Better Way Realty, Inc., original listing - (252) 453-4075

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 3
Baths: Full: 1
Status: Active
SqFt: 1245 Square Feet
Agency: A Better Way Realty, Inc.
Agency Phone: (252) 453-4075

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1992
Notes: This 3/1 Waterfront Haven has been listed just for you! Having a private balcony, large deck for gatherings, enclosed sunroom, breathtaking views from almost every window, it's sure to impress you! This sale includes a parcel to the left that Conveys, a parcel to the right,AND a parcel on the Albemarle Sound that can be accessed by kayak/boat directly from the backyard canal.(Head over to the Soundfront lot for a peaceful Island Oasis feel, relax, & watch the sunsets) Gorgeous Views. All 4 Lots totaling 1.54Acre. You won't have to worry about anyone building next to your home, as you would own both sides with this. The possibilities are endless. Camden County schools are definitely sought after for their high ratings. This area in Camden County is popular to all, Investors (Airbnb same street), hunting enthusiasts, and those whom love to fish. Commercial seafood is just up the road. If you'd rather boat, well, we have options for that too! ''One Mill Park'' is only 13 minutes from this home, offering a public boat ramp, picnic tables, and playground. Want more, sure thing, there is an additional detached building by the canal with its own 1/2 bath, sink, & fridge. Utilize as an office or extra private space for your guests to stay! Lastly, this home is fully furnished!! What are you waiting for? Make an apt to see while it's still active. Agents, SEE REMARKS
MlsNumber: --
ListingId: 100500430


Listing Provided By: A Better Way Realty, Inc., original listing
Phone: (760) 608-0134
Office Phone: (252) 453-4075
Agent Name: Nicole Price
Disclaimer: Copyright © 2025 Hive MLS / Albemarle Area 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App