-- Projects Table: core project information CREATE TABLE Projects ( project_id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(200) NOT NULL, location_city VARCHAR(100), location_state VARCHAR(50), project_type VARCHAR(100), -- e.g., 'Window Replacement' year_completed YEAR, description TEXT ); -- Project_Images Table: visual media for project CREATE TABLE Project_Images ( image_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, image_url VARCHAR(500) NOT NULL, caption VARCHAR(255), image_type ENUM('Before', 'After', 'Detail'), FOREIGN KEY (project_id) REFERENCES Projects(project_id) ); -- Project_Features Table: key design or functional attributes CREATE TABLE Project_Features ( feature_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, feature_name VARCHAR(100), details VARCHAR(255), FOREIGN KEY (project_id) REFERENCES Projects(project_id) ); -- Energy_Specs Table: technical performance details for window projects CREATE TABLE Energy_Specs ( spec_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, u_value DECIMAL(5,3), -- e.g., 0.28 solar_heat_gain DECIMAL(5,3), frame_material VARCHAR(100), FOREIGN KEY (project_id) REFERENCES Projects(project_id) ); -- Warranty_Info Table: warranty details CREATE TABLE Warranty_Info ( warranty_id INT PRIMARY KEY AUTO_INCREMENT, project_id INT NOT NULL, labor_warranty VARCHAR(100), product_warranty VARCHAR(100), FOREIGN KEY (project_id) REFERENCES Projects(project_id) );

Past Projects

Bright Window Replacement in Elyria, Ohio

This customer added modern, bright window replacements to their home to lighten the space and let in an abundance of natural light.

project year: 2020

Talk To Us

Free In-Home Consultation

Start creating the home you’ve always wanted — with expert help.
Our free in-home design consultation is the easiest way to explore your options and make confident decisions. Whether you’re upgrading your windows, remodeling your bath, adding a sunroom, or improving your doors, our team is here to help you bring your vision to life.

Why Book Your Free Consultation?

✅ Tailored to Your Home – Every home is unique, and so is our approach. We’ll assess your space and recommend the right solutions for your needs, style, and budget.
✅ Hands-On With Options – See and feel product samples, finishes, and colors; all in the comfort of your own home.
✅ Expert Guidance, No Pressure – Our goal is to educate and inspire, not to sell. You’ll have all the information you need to make the right choice; at no cost or obligation.

We’ll Be In Touch Soon!