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

1 Mgm
Seaville, NJ 08230

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,900
Beds: 4
Baths:
Status: Active
SqFt: 3320 Square Feet
Agency: LONG & FOSTER REAL ESTATE, INC - OC

Map Details Show Map | Show StreetView




House Features

Appliances: Dishwasher, Washer, Microwave, Refrigerator, Dryer
Architectural Style: Other
Construction Materials: See Remarks
Heating: Forced Air, Zoned
Interior Features: Storage, Whirlpool, Cathedral Ceilings, Walk In Closet, Tile Flooring, Vinyl Flooring
Rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Den, Dining Room, Kitchen, Laundry, Living Room, Loft, Utility Room

Window Features

Exterior Features: Porch, Deck, See Remarks, Sprinkler System, Fenced Yard
Fencing: Fenced
Parking Features: Garage, Driveway
Other Features: See Remarks
Patio and Porch Features: Porch, Deck

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name:

Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Pride of Ownership in Upper Twp. The original home, built in 2007, was custom designed by the owner, well built and with a thoughtful layout. The current owner has just completed an update and renovation that has the feel of new construction. With approximately 3,450 sq ft of living space, a full poured basement (unfinished but high ceilings) and an additional loft/storage room, there is plenty of room for every lifestyle. The long driveway leading to the garage and outside parking affords you room to park two cars inside and multiple cars outside. Enter the house through the attached garage or use the walkway to the front door. The front porch has been totally renovated with a new metal roof, solid perimeter soffit, Trex decking and Azek trim package complimented by a new gutter system that was not previously installed. Entering the grand foyer, you are welcomed by a cathedral ceiling and an elegant staircase to the second floor. Except for the Bathrooms, Kitchen and Laundry room that are still tiled, all of the flooring throughout the house has been upgraded with new Vinyl Plank Flooring and installed by Avalon Flooring. Standing in the foyer, to the left is a Den/Office or Playroom and a hallway taking you to the half-bath, laundry/utility/mudroom and the garage. To the right of the Foyer is a spacious Family room complete with an elegant stone, gas fireplace and complimented by new Bali blinds. Going forward from the Foyer is the Modern Kitchen complete with custom cabinets, granite counters, center island and stainless-steel appliances including a New Samsung Refrigerator. Just beyond the Kitchen is an additional area or breakfast nook. To the left the kitchen area is a Formal Dining Room and both rooms lead to an oversized outside deck, great for entertaining family and friends, cook-outs or just enjoying the evening watching the stars. Making your way to the second floor up the grand staircase there are four bedrooms and two full baths on this floor, along with a large unfinished room at the end of the hall; great for storage, man-cave, she-shed, game room, craft room, workshop or whatever else you may need it for. When you arrive at the top of the staircase, you can make a hard left and go to the east- end of the hall where you are greeted with a full bath and to each side is a bedroom. Going back down the hall, past the stairs, is an oversized bedroom. Crossing the hall, a little to the right you enter the Grand Master Bedroom with ample space for a sitting area. Entering in the palatial Master Bath you'll find custom cabinetry, dual sinks with quartz tops, a whirlpool soaking tub, a tiled walk-in shower with a New Moen Thermostatic Shower System, including a Rain Shower and four Body Sprays. A full walk-in closet rounds out the area. Still on the second-floor hall, there is also a pull down for the full-size attic and an Attic Tent has been installed for energy efficiency. Attributing to additional Energy Efficiency are two Multi-Zoned New Trane High Efficiency Heating and 16 seer AC units with a transferrable warranty. The entire interior of the house has been repainted, including all the trim and doors, giving it a very clean, new look. This oversized corner lot features all new landscaping surrounding the house, with drip irrigation. An Irrigation well tune-up was performed with new bladder tank and irrigation switch, four new irrigation valves installed in rear yard and a new irrigation Wi-Fi controller. The rear yard has endless options to make this property your private oasis, including ample room for a large pool and entertainment area. So many more possibilities to make this house even better than it already is. Call today for your private showing!!
MlsNumber: --


Listing Provided By: LONG & FOSTER REAL ESTATE, INC - OC, original listing
Phone: (609) 513-6220
Office Phone: (609) 398-6762
Agent Name: Kevin Redmond
Disclaimer: Copyright © 2024 Cape May 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App