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

709 Lakeland Drive Se
Bolivia, NC 28422

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $310,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1709 Square Feet
Agency: ADAMS HOMES REALTY NC INC
Agency Phone: (910) 338-2853

Map Details Show Map | Show StreetView




House Features

Architectural Style: Other
Construction Materials: Vinyl Siding, Stone
Heating: Heat Pump
Interior Features: Kitchen Island, Pantry, Foyer, Master Downstairs, 9ft+ Ceilings, Walk-in Closet(s), Vaulted Ceiling(s), Walk-in Shower
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: Porch, Covered
Patio and Porch Features: Porch
Property Condition: New Construction
Roof: Shingle

Neighborhood/Schools

Elementary School/District: Virginia Williamson/Brunswick
Middle/Junior High School/District: /Brunswick
High School/District: West Brunswick/Brunswick
Subvidision Name: Mill Creek Cove

Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: New Construction in Mill Creek Cove, just 15 Minutes from the beach! This 1709 Floor plan features a beautiful open concept. The kitchen has beautiful white cabinets and granite kitchen countertops with a full kitchen backsplash. This home will have laminated wood flooring in the main areas of the home. There is Wainscotting and crown molding trim is included in the dining area. Crown Moulding is included in the master suite also. $1000 builder deposit to reserve. <br /> This home will start construction soon and is expected to be ready to move in approximately August 30, 2024. Mill Creek Cove offers a large spacious pool, clubhouse for gatherings, an exercise room, tennis courts, and a golf putting green. Photos are of the same floorplan in another community.
MlsNumber: --
ListingId: 100437356


Listing Provided By: ADAMS HOMES REALTY NC INC, original listing
Phone: (530) 344-3524
Office Phone: (910) 338-2853
Agent Name: Joanna Lopez
Disclaimer: Copyright © 2024 NCRMLS/ Jacksonville Board of Realtors NC. 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