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

10 Caledonia Dr Dr
Ocean View, NJ 08230
« Prev
Next »
Currently Displayed Property Photo


Property Details

List Price: $1,125,000
Beds: 4
Baths:
Status: Active
SqFt: 4786 Square Feet
Agency: Compass Real Estate-Avalon Dune Dr

Map Details Show Map | Show StreetView



Description/Comments

Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1995
Notes: Welcome to this exceptional custom-built home by Georgetti Construction, boasting nearly 4,800 square feet of living space, situated in a perfect community in one of the best school districts in the state yet only minutes to beaches. This meticulously designed residence features potential for four bedrooms, three and a half baths, and a wealth of upgrades throughout. Step inside to discover a luxurious floorplan, incorporating the gorgeous custom curved staircase flanked by formal living and dining rooms adorned with exquisite trim work, crown moldings, and refinished hardwood flooring. The home boasts large casement windows that add to the security and visual appeal of the home, providing maximum ventilation and natural light to every room. The chef's kitchen is a culinary delight, showcasing imported granite countertops from Italy, marble flooring and a Sub Zero refrigerator with custom paneling, walk-in pantry and an additional min fridge beverage cooler. The kitchen island adds utility to the well-planned kitchen, providing additional workspace and storage. Crank-style windows open to allow for ample sunshine and breeze as you peak out over the beautiful backyard. Adjacent to the kitchen, an eat in kitchen area provides fabulous pool views. The step down family room offers impressive ambiance and grandeur with cathedral ceilings and a gas fireplace and wall of windows and sliders that lead to the patio and pool area. On the main floor, there is also a separate den with access to the outside resort-style backyard setting. The first floor also has a private office which could also be converted into a that potential 5th bedroom if so desired.On the open stairwell second floor, retreat to the five-star master suite, featuring a two-sided fireplace, offering ambiance to the bedroom as well as to the spa-like adjacent master bath ensuite complete with custom free-standing tub and impressive shower system. The master suite is further enhanced with a dressing area/ or personal office as well as a fabulous custom-designed cherry walk- in closet system. The sunny and open second floor of the home features three additional bedrooms and two additional fully customized bathrooms. One of the bedrooms boasts a custom-built bunk bed system complete with its own slide, perfect for creating a fun and imaginative space for children. There is a private back staircase leading to the kitchen and laundry room complete with a chair lift system . Entertain in style in the outdoor space on the Italian garden-style patio with multi level decking or gather around the massive custom stone gas fireplace . The expansive patio has an outside serving bar, perfect for entertaining guests while enjoying the outdoor amenities. Take a dip in the heated gunite pool, which has been newly resurfaced, or enjoy a game of basketball on the court, all within the privacy of your wrought iron fenced backyard illuminated in the evening by custom outdoor lighting. The home has a brand new roof, a new superior LED Halo air filtration system and a new tankless water heater with circulator. Upstairs has new HVAC/ new ductwork and downstairs unit is three years new. In addition to all of the updates the home has fresh meticulous landscaping and has been freshly painted throughout, adding a touch of modern elegance to its already impressive features. This home offers unparalleled luxury and comfort. Don't miss the opportunity to make this your dream home - schedule a showing today!
MlsNumber: --


Listing Provided By: Compass Real Estate-Avalon Dune Dr, original listing
Phone: (609) 408-1480
Office Phone: (609) 967-0466
Agent Name: CHRISTINE TUMELTY
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.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => cape-may [3] => NJ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: cape-may State: NJ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: cape-may State: NJ 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 = 1772 AND i.igate IN ('inhud','usahud','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 = 'inhud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Vera Covali
ASCIIKeller Williams Shore
Call Today!: (609) 810-9930

Contact Me

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App