Welcome to 400 Celeste Avenue, a charming Cape Cod-style home situated on a corner lot in Essex. Offering three bedrooms, two full bathrooms, recently replaced roof, bathroom renovation (2021) and a fully fenced backyard, this property presents a fantastic opportunity for buyers looking to add their own personal touches while enjoying several key updates already completed. The exterior features a welcoming front porch, rear driveway access, storage shed, patio area to the side and a fully fenced backyard perfect for pets, gardening, or outdoor entertaining. Inside, the main level offers hardwood flooring with a well-defined living room and fireplace, a full bathroom with tub and upgraded vanity with two comfortably sized bedrooms featuring carpeted floors and ample closet space. The rear L-shaped kitchen includes stainless steel appliances, a single deep sink and provides convenient access to the basement and side exterior entrance. The entire upper level is dedicated to a spacious primary suite complete with a recently finished ceiling, two ceiling fans, and a private full bathroom. The lower level offers a full basement with carpeting, a dedicated laundry area, abundant storage space, and a rough-in for a future bathroom, providing excellent potential for additional finished living space. Being sold as-is, this home offers a solid foundation, functional layout, and plenty of opportunity to customize and build equity. Set up a showing today!