Ravine Lot!!! Backing Into Conservation Area/Fairy Lake!!! Welcome To 408 Andrew St. This 4 + 1 Bedroom Fully Renovated Property Is Seating On A Premium, Extra Deep Lot, Approx 200 Feet Deep!!! Conveniently Located In Central Newmarket. This Property Offers A Silent Tranquility Of Cottage Style Living Combined With A Unique Proximity To All Local Amenities And Infrastructure! Major Renovation Project Was Completed In 2025 By The Owner Which Included Adding A 2nd Floor And Building A Main Floor Extension. Over $350,000 Invested In High-End Thoughtfully Designed Upgrades. Never Lived In Since Its Renovation (2025), It Seamlessly Blends Modern Comfort With Exceptional Attention To Detail. The Custom Kitchen (2025) Showcases Quartz Countertops, Stainless Steel Appliances (2025), Durable Non-Scratch Cabinetry, A Moveable Island, And A Washer And Dryer-All Complemented By A Bright Separate Breakfast Area With Heated Floors. The Main Floor Includes Rough-Ins For A Powder Room, Offering Added Convenience. The Primary Bedroom, Conveniently Located On The Main Floor, Comfortably Fits A King-Size Bed, While The Bathrooms Feature Luxurious Rain Showers And Elegant Finishes. The Finished Basement Adds Incredible Versatility With A Bedroom, Bathroom, Living Room, And A Second Washer/Dryer-Plus Rough-ins For A Kitchen, ideal For An In-law Suite Or Income Potential. Outside, Enjoy Parking For 4 Vehicles, New Front Interlock (2025), And A $25K Custom Backyard Fence With Direct Access To Walking Trails. Extensive Upgrades Include Spray Foam Insulation In Ceilings And Exterior Walls (2025), A New Roof (2025), High-Efficiency Furnace (2025), Air Circulation System, Dehumidifier, Updated Plumbing And Water Line, Upgraded Windows And Doors (2025) Modernized Electrical (200 Amps), New Hardware Throughout. Steps From Historic Main Street's Shops, Dining, And Amenities, This Move-In-Ready Home Stands Out For its Quality, Comfort, And Modern Craftsmanship.