Title Page Background
HFQUERY 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 = 1778 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1778 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 1778 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

18 Colt Circle
West Windsor, NJ 08550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,350,000
Beds: 5
Baths: 5
Status: Pending
SqFt: 4203
Agency: RE/MAX Diamond Properties

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1997
Notes: Calling for highest & best offer to be submitted no later than Monday. Experience grandeur and luxury living in this rarely found extravagant colonial gem nestled in one of West Windsor's most coveted locales. Boasting over 4,000 sq ft of exquisite living space, this residence is a testament to refined taste and unparalleled craftsmanship. Set upon an expansive acre of beautiful landscaped grounds, this property is situated in the exclusivity of an cul-de-sac. Upon entry, be greeted by a majestic 2-story high ceiling foyer, flanked by a formal dining room and a luminous family room, setting the tone for elegance and sophistication. The heart of the home lies in the open-concept gourmet kitchen, complete with a spacious breakfast area, sub-zero fridge and a grand center island, perfect for culinary endeavors and entertaining alike. Transition seamlessly to the airy living room, which opens to a sun-drenched Sun room adorned with towering windows, bathing the space in natural light with view of Picturesque backyard! Convenience meets comfort with a first-floor also features bedroom, full bath, laundry facilities, and a hallway leading to the entrance of the high-ceiling 3-car garage. Ascend to the second floor to discover a luxuriant master suite, complemented by a capacious hallway leading to 3 additional bedrooms, including a princess suite and 2 bedrooms connected by a Jack & Jill upgraded bathroom. The finished basement offers versatility with an office space and ample storage closets, catering to the needs of modern living. Step outside to the picturesque backyard oasis, featuring a newer metal-fenced perimeter, beautiful paver accents, a newer serene waterfall and life-time warranty possible transferrable (buyer to verified) sparkling pool, creating an idyllic retreat for relaxation and recreation. Additional features include a newer roof, ensuring peace of mind and longevity for years to come. Newer water fall, newer pool and newer HVAC. Revel in the epitome of luxurious living and schedule a tour of this exceptional residence before it is gone. Welcome home to unparalleled splendor in West Windsor's finest enclave.
MlsNumber: 22406507


Listing Provided By: RE/MAX Diamond Properties, original listing
Name: RE/MAX Diamond Properties
Phone: (973) 625-0450
Office Name: RE/MAX Select
Office Phone: (732) 917-7300
Agent Name: Suk Woon S. Ip
Disclaimer: Copyright © 2024 Monmouth Ocean Regional Realtors and Monmouth Ocean 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