STUNNING MODERN FARMHOUSE offering the perfect blend of upscale design, functional living, & exceptional indoor-outdoor living! This expansive 5-bedroom, 3.5-bath two-story home with a FINISHED WALK-OUT BASEMENT, is ideally situated on an oversized, FULLY FENCED CORNER LOT in a quiet CUL-DE-SAC setting with NO HOA. From the moment you enter, you're welcomed by a bright, open foyer & a versatile front flex room-perfect for a home office, formal living space, playroom, or dining room. Large windows throughout the home fill every space with natural light, creating an airy, inviting atmosphere. A conveniently located powder room & direct access to the OVERSIZED, FINISHED 3-car garage-complete with NEW epoxy flooring (2024), an overhead gas heater, & a 220V outlet for EV vehicles-add both style & everyday functionality. The main level unfolds into a beautifully designed open-concept living space, featuring durable vinyl plank flooring & seamless flow between the kitchen, dining area, & family room. The kitchen is both stylish & practical, showcasing quartz countertops, a tile backsplash, abundant cabinetry, walk in angled pantry, & a large island ideal for gathering. The family room is anchored by a NEW custom fireplace build-out (2026), creating a warm & welcoming focal point. Just beyond, the dining area opens to a covered deck with a ceiling fan-perfect for relaxing or entertaining while overlooking the expansive backyard. Upstairs, the oversized primary suite offers a true retreat, featuring an OVERSIZED WALK IN CLOSET with custom organizers & a luxurious spa-inspired en-suite bath with dual vanities & a beautifully tiled shower. 3 additional generously sized bedrooms, a full bathroom, & a conveniently located second-floor laundry room complete the upper level. The FINISHED WALK-OUT BASEMENT expands your living space even more, offering a large recreation space, bar area, additional flex space, a 5th bedroom, & another full bath-perfect for guests, entertaining, or extended living arrangements. Outdoor living is just as impressive with over half an acre of space, a NEWLY fenced yard (2025), fresh professional landscaping (2024), a NEW shed (2025), & a NEW hot tub (2024)-designed for both relaxation & entertaining. Located just minutes from downtown Lowell, this home offers the perfect combination of modern updates, thoughtful design, & an unbeatable setting. A rare opportunity to own a MOVE-IN READY home with space, style, & amenities both inside and out-this one truly stands out!