SELECT client_date_created, dbo.client_details.client_id, dbo.Window_order_client_joiner.window_order_job_picture1_filename, dbo.Window_order_client_joiner.window_order_job_picture1_description, dbo.Window_order_client_joiner.window_order_job_picture1_before_after, dbo.Window_order_client_joiner.window_order_job_picture2_filename, dbo.Window_order_client_joiner.window_order_job_picture2_before_after, dbo.Window_order_client_joiner.window_order_job_picture2_description, dbo.Window_order_client_joiner.window_order_job_picture3_description, dbo.Window_order_client_joiner.window_order_job_picture3_filename, dbo.Window_order_client_joiner.window_order_job_picture3_before_after, dbo.Window_order_client_joiner.window_order_job_picture4_filename, dbo.Window_order_client_joiner.window_order_job_picture4_description, dbo.Window_order_client_joiner.window_order_job_picture4_before_after, dbo.client_details.client_city, dbo.client_details.client_state_id, dbo.Window_order_client_joiner.window_order_type_of_request, dbo.client_details.client_lead_from FROM dbo.client_details INNER JOIN dbo.Window_order_client_joiner ON dbo.client_details.client_id = dbo.Window_order_client_joiner.client_id WHERE window_order_type_of_request='windows' AND dbo.client_details.client_lead_from IN ('Hallmark Windows', 'Next Day Gutters') AND (dbo.Window_order_client_joiner.window_order_job_picture1_filename > '') AND (dbo.Window_order_client_joiner.window_order_job_picture1_before_after IN ( 'After', 'During')) OR (dbo.Window_order_client_joiner.window_order_job_picture2_filename > '') AND (dbo.Window_order_client_joiner.window_order_job_picture2_before_after IN ('After', 'During')) OR (dbo.Window_order_client_joiner.window_order_job_picture3_filename > '') AND (dbo.Window_order_client_joiner.window_order_job_picture3_before_after IN ('After', 'During')) OR (dbo.Window_order_client_joiner.window_order_job_picture4_filename > '') AND (dbo.Window_order_client_joiner.window_order_job_picture4_before_after IN ( 'After', 'During')) ORDER BY window_order_type_of_request, client_date_created
windows and siding maryland virginia dc window Estimate Maryland Virginia DC
windows siding Maryland Virginia DC Contact / About Us replacement windows maryland Patio Doors Maryland Virginia DC Vinyl Siding Maryland James Hardie Siding Maryland Virginia DC roofing maryland community

We proudly install replacement windows in Maryland, Washington DC and Virginia manufactured by:

REQUEST A FREE WINDOW ESTIMATE

Investing in the right windows can make all the difference, and there are many factors you will want to consider. Window style, glazing, brand and construction materials all play a part in your decision, but so does your budget. Please explore the information presented here and then contact us for a free estimate so that we can help you make the choice that's best for you. Our friendly representatives will come to your home to measure and give you an estimate for completing the job. We are fully licensed and bonded and come with many excellent references.

Learn more:

Frequently Asked Questions
Window Styles

We proudly offer the following brands of windows:

Alside Excalibur and Ultramaxx Vinyl Windows
CertainTeed Bryn Mawr II and Devan Vinyl Windows
Royal Patio Doors
Alside Patio Doors
Traco Protection Plus Aluminum Windows
Vytex Vinyl Windows
WeatherShield CustomShield

Ask for Energy Star compliant windows

Window Photo Gallery
Click to view images.
paver driveway rockville   concrete driveway rolled curb
     
pea gravel driveway p-gravel   driveway and wall with lamp
     
Patio with retaining walls   driveway installation vienna, va
     
concrete stone mix driveway    


© 2006 Hallmark Windows & Siding 10411 Motor City Drive, #610, Bethesda, MD 20817

vytex windows