First offering of this custom-built Colonial offering over 3,000 square feet of living space, ideally situated on a quiet residential street in the heart of Oceanside. This exceptional home offers incredible versatility and is perfect for extended family, mother/daughter living with proper permits, or ideal private office/work-from-home space. The main residence features an unbelievable open-concept layout with a stunning updated kitchen, spacious living and entertaining areas, 4 bedrooms, 2 full baths, and a partially finished basement offering even more flexible space. Added to the rear of the home is a separate 1-bedroom duplex-style living space with its own private entrance, creating a rare opportunity for multi-generational living or additional private quarters. Exterior highlights include a detached garage, fire pit area, built-in BBQ, and a beautifully designed outdoor space perfect for entertaining. A truly unique property with endless possibilities - do not miss this rare opportunity!