Title Page Background
DEBUG FN args: Array ( [0] => 1958 [1] => [2] => [3] => agent ) BEFORE: Site: 1958 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1958 Igate: njhud LocID: 1958 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 = 1958 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1958 [1] => [2] => [3] => lender ) BEFORE: Site: 1958 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1958 Igate: njhud LocID: 1958 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 = 1958 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1958 [1] => [2] => [3] => other ) BEFORE: Site: 1958 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1958 Igate: njhud LocID: 1958 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 = 1958 AND i.igate IN ('cihud','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 = 'cihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1104 Autumn Lakes Drive
Grimesland, NC 27837
Caroline Johnson with Caroline Johnson Real Estate Inc, original listing - (252) 717-6253

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,699,000
Beds: 4
Baths: Full: 5, ½: 2
Status: Active
SqFt: 6630 Square Feet
Agency: Caroline Johnson Real Estate Inc
Agency Phone: (252) 717-6253

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2005
Notes: This Luxurious Lake-Front Stunner Perfectly Situated on Cul-de-sac Lot Offers Impeccable Finishes Inside & Out! Numerous 2024 Updates! ''Showcase'' Kitchen with Double Islands, Quartz Counters, New Cabinets, New Appliances, & Walk-in Pantry. Desirable Open & Split Bedroom Floor Plan. 1st Floor Owner's Suite Features Sitting Room with Modern Fireplace, Decorative Trim Work on Walls Plus Water Feature, 2 Walk-in Closets, Remodeled Bath with Tile Shower & Two Vanities, PLUS Private Wellness Room with Infrared Sauna and Polar Monkey Cold Plunge. Two Additional Bedrooms with En-suite Baths, Laundry Room with Separate Mudroom/Drop Zone Area, Formal Dining Room, & Office with Built-ins also Located on 1st Floor. The 4th Bedroom with En-suite Bath, Custom Bunk Room/Bonus, 2nd Office with Built-ins, & Media/Theater Room with Kitchen Area are Located on 2nd Floor. Enjoy the Gorgeous Views of the Lake & Pool Area from the 2nd Floor New Trex Deck. <br /> <br /> This Home Perfectly Balances Indoors & Out with Large Picture Windows Plus New Nano Folding Door System in the Living Room to Screened Porch with Private Pool Bath. Venture Out Back to Dip Your Toes in the Inground Saltwater Pool (New Pool Liner) Accented by Raised Brick Paver Patio. <br /> <br /> Other Extras: 3 Indoor Staircases including 2 Spiral Staircases, Heavy Moldings, Tons of Built-ins, New Plumbing & Light Fixtures, Wood Accented Decorative Ceilings, HUGE Walk-in Attic or Additional Unfinished Space, Gorgeous Hardwood Floors, Irrigation System, Smart Closet, Tankless Water Heater, Audio System, Professional Landscaping & Landscape Lighting, Central Vac System, Fencing with Brick Columns, Plantation Blinds, Basketball Goal, Grass Paver Parking Pad, & So Much More! MUST SEE!
MlsNumber: --
ListingId: 100460128


Listing Provided By: Caroline Johnson Real Estate Inc, original listing
Phone: (252) 717-6253
Office Phone: (252) 717-6253
Agent Name: Caroline Johnson
Disclaimer: Copyright © 2024 NCRMLS/ Coastal Plains 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