Title Page Background
DEBUG FN args: Array ( [0] => 1768 [1] => [2] => [3] => agent ) BEFORE: Site: 1768 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1768 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 = 1768 AND eai.ishudvalues = 1 AND m.expertType = 'agent' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1768 [1] => [2] => [3] => lender ) BEFORE: Site: 1768 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1768 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 = 1768 AND eai.ishudvalues = 1 AND m.expertType = 'lender' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1768 [1] => [2] => [3] => other ) BEFORE: Site: 1768 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE hudvalues AFTER: Site: hudmax Igate: hudmax LocID: 1768 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 = 1768 AND eai.ishudvalues = 1 AND m.expertType = 'other' ORDER BY IF (m.expertpos = 'P' AND i.igate = 'hudmax', 0, 99), IF (m.expertpos = 'P', 1, 99), IF (i.igate = 'hudmax', 2, 99), RAND() LIMIT 0, 1;

509 Country Club Dr
Egg Harbor City, NJ 08215

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $439,000
Beds: 3
Baths: 3
Status: Active
SqFt: 2042
Agency: Soleil Sotheby's International Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2003
Notes: It’s Golf Season! What could be better than playing 18 holes? Living in Blue Heron Pines! Voted Best 18-hole Golf Course in NJ. Your dream home, that rarely comes on the market! This exquisite contemporary two-story home, 3 bedroom/2.5 bath immaculately maintained 100% move in ready. Enter to soaring vaulted ceilings, with coveted open concept living. The perfect kitchen with top-of-the-line granite countertops & amp; backsplash that complement the matching center island. Custom 42” cabinets, storage for all your kitchen gadgets. Ample light from the beautiful palladium windows shines down on brand new luxury vinyl flooring throughout whole first floor. Watch the Masters, on the custom accent wall with dedicated space to showcase your prize possessions. Step outside to a beautiful new paver patio, complete with the gas grill hard lined to the home. Privacy fencing, creating the backyard oasis complete with backyard sprinkler system. The first floor boasts a divine primary bedroom and ensuite. Vaulted ceilings give this room the perfect atmosphere for relaxation and elegance all at the same time. Huge walk-in closet, a double vanity greets you as you enter the newly renovated primary bathroom, complete with porcelain soaker tub, stunning glass enclosed state of the art shower and porcelain tile floor, no detail left undone! The lovely powder room, and full laundry room, as well as access to the 2 car garage all accessible on the primary floor. Ascend the staircase, to the large loft area, which lends itself to a host of possible uses. Enjoy quiet time with your guests, or sit with a good book, or stream your favorite networks. The loft area leads to two spacious bedrooms with ample closet space and private full bathroom. This home is a Hole in one!
MlsNumber: 583870


Listing Provided By: Soleil Sotheby's International Realty, original listing
Name: Soleil Sotheby's International Realty
Phone: (609) 487-8000
Office Name: Soleil Sotheby's International Realty - A
Office Phone: (609) 487-8000
Agent Name: Melissa Marshall
Disclaimer: Copyright © 2024 South Jersey Shore Regional MLS. 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