Start Over Reset Search
Show as a Map - Up to 500 Facilities Show as List
ENERGY STAR Labeled Buildings & Plants
Showing ENERGY STAR Labeled Facilities in San Antonio, TX
ENERGY STAR Logo Advanced Search
Print this page
Select Search Category
1-101 of 101 Facilities. Labeled Buildings represent 20,372,168 square feet.
Page 1
Loading. Please Wait.

State

  • Texas (101)

Zip Code


Separate multiple entries with comma

Label Year

Facility Owners »

Property Managers »

Service & Product Providers »

Please note: This list is updated with new buildings daily. The registry reflects building information that was verified and submitted to EPA at the time of application. Building energy performance, operating characteristics, and ownership/management may be subject to change over time.
0815 Remington Oaks MOB
[ Map It! | Profile ]
525 Oak Centre Drive
San Antonio, TX 78258
Facility Type: Medical Office
Owner: HCP, Inc.
Property Manager: Lincoln Harris CSG
Label Years: 2010, 2011, 2013
13694 Tesoro Headquarters
[ Map It! | Profile ]
19100 Ridgewood Parkway
San Antonio, TX 78259
Facility Type: Office
Owner: Tesoro Companies
Property Manager: Grubb & Ellis
Label Years: 2010
Alamo Cement Company
[ Map It! | Profile ]
6055 West Green Mountain Road
San Antonio, TX 78266
Facility Type: Cement
Owner: Buzzi Unicem USA, Inc.
Property Manager: N/A
Label Years: 2012, 2013, 2014
Architectura Building San Antonio, TX
[ Map It! | Profile ]
17038 Redland Road
San Antonio, TX 78247
Facility Type: Office
Owner: Architectura S.A.
Property Manager: Architectura S.A.
Label Years: 2010
Audie L. Murphy Memorial VA Hospital
[ Map It! | Profile ]
7400 Merton Minter Blvd.
San Antonio, TX 78229
Facility Type: Hospital (General Medical & Surgical)
Owner: South Texas Veterans Health Care System, Audie L. Murphy Memorial VA Hospital
Property Manager: South Texas Veterans Health Care System, Audie L. Murphy Memorial VA Hospital
Label Years: 2012
Bank of America Plaza
[ Map It! | Profile ]
300 Convent
Suite 2424
San Antonio, TX 78205
Facility Type: Office
Owner: Talcott Realty Investors
Property Manager: Transwestern
Label Years: 2010, 2013
BRI 1841 Energy Plaza, LLC
[ Map It! | Profile ]
8610 & 8620 N. New Braunfels Ave.
San Antonio, TX 78217
Facility Type: Office
Owner: BRI 1841 Energy Plaza LLC
Property Manager: Beacon Real Estate Services LLC
Label Years: 2013
Central Market SA #02-191
[ Map It! | Profile ]
4821 Broadway
San Antonio, TX 78209
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
Chase Center - Oak Park
[ Map It! | Full Profile ]
1020 N.E. Loop 410
San Antonio, TX 78209
Facility Type: Other
Owner: The Realty Associates Fund X, LP
Property Manager: HPI Real Estate Services and Investments
Label Years: 2003, 2007, 2009, 2010, 2011, 2014
building
City View 2012
[ Map It! | Profile ]
10999 IH-10 West
Suite 315
San Antonio, TX 78230
Facility Type: Office
Owner: KBS City View
Property Manager: Transwestern
Label Years: 2010, 2011, 2012, 2013
Colonnade 1
[ Map It! | Full Profile ]
9901 I-H 10 West
San Antonio, TX 78230
Facility Type: Office
Owner: Westdale Colonnade LP
Property Manager:
Label Years: 2001, 2011, 2012, 2014
building
Colonnade Centre
[ Map It! | Profile ]
9830 Colonnade Boulevard
San Antonio, TX 78230
Facility Type: Office
Owner: USAA Properties Fund, Inc.
Property Manager: USAA Real Estate Company
Label Years: 2009, 2010, 2012, 2013
Concord Park I
[ Map It! | Profile ]
800 East Sonterra Blvd.
San Antonio, TX 78258
Facility Type: Office
Owner: Concord Corporation
Property Manager: Concord Corporation
Label Years: 2008, 2009, 2011
Concord Plaza
[ Map It! | Profile ]
200 Concord Plaza Drive
San Antonio, TX 78216
Facility Type: Office
Owner: Frost National Bank Trustee - Concord Plaza
Property Manager: Endura Advisory Group, LLC
Label Years: 2011, 2012, 2013
Corporate Square
[ Map It! | Profile ]
4801 NW Loop 410
Suite 100
San Antonio, TX 78229
Facility Type: Office
Owner: Maseho, Inc
Property Manager: Newmark Grubb Knight Frank
Label Years: 2010, 2012, 2013, 2014
Earl Warren High School
[ Map It! | Profile ]
9411 W Military Drive
San Antonio, TX 78251
Facility Type: K-12 School
Owner: Northside Independent School District
Property Manager: Northside Independent School District
Label Years: 2013
Farinon Building
[ Map It! | Profile ]
5859 Farinon
San Antonio, TX 78249
Facility Type: Office
Owner: MJ 281 Development, Ltd
Property Manager: Travis Commercial Real Estate
Label Years: 2012
Fountainhead Business Park II
[ Map It! | Profile ]
4545 Horizon Hill Blvd.
San Antonio, TX 78229
Facility Type: Office
Owner: Shorecliffs Investments, LLC
Property Manager: Daymark Realty Advisors
Label Years: 2008, 2009, 2012
Fountainhead Tower
[ Map It! | Profile ]
8200 IH-10 West
Suite 810
San Antonio, TX 78230
Facility Type: Office
Owner: EOS Aquisition I, LLC
Property Manager: Transwestern
Label Years: 2011
Heritage Oaks 2
[ Map It! | Profile ]
2338 North Loop 1604 West
San Antonio, TX 78248
Facility Type: Office
Owner: R.L.Worth & Associates
Property Manager: R.L.Worth & Associates
Label Years: 2011
HIPOLITO F. GARCIA FOB/US CTHS
[ Map It! | Profile ]
615 E HOUSTON STREET
SAN ANTONIO, TX 78205
Facility Type: Office
Owner: General Services Administration Region 7
Property Manager: General Services Administration Region 7
Label Years: 2012
J Wood Courthouse
[ Map It! | Profile ]
655 E CESAR E CHAVEZ BOULEVARD
SAN ANTONIO, TX 78206
Facility Type: Courthouse
Owner: General Services Administration Region 7
Property Manager: General Services Administration Region 7
Label Years: 2009, 2010, 2011, 2013
Jim G. Martin Elementary School
[ Map It! | Profile ]
730 Canterbury Dr.
San Antonio, TX 78228
Facility Type: K-12 School
Owner: Northside Independent School District
Property Manager: Northside Independent School District
Label Years: 2013
Kinder Ranch Elementary
[ Map It! | Profile ]
2035 Kinder Parkway
San Antonio, TX 78260
Facility Type: K-12 School
Owner: Comal Independent School District
Property Manager:
Label Years: 2013
Leon Springs-566
[ Map It! | Profile ]
24165 I-H 10 West, Suite 300
San Antonio, TX 78006
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
Marriott Courtyard San Antonio Airport
[ Map It! | Profile ]
8615 Broadway
San Antonio, TX 78217
Facility Type: Hotel
Owner: ING Clarion Partners
Property Manager: Marriott International
Label Years: 2005, 2007
Marriott Courtyard San Antonio Downtown/Market Square
[ Map It! | Profile ]
600 Santa Rosa South
San Antonio, TX 78204
Facility Type: Hotel
Owner: ING Clarion Partners
Property Manager: Marriott International
Label Years: 2005, 2007
Marriott Courtyard San Antonio Medical Center
[ Map It! | Profile ]
8585 Marriott Drive
San Antonio, TX 78229
Facility Type: Hotel
Owner: ING Clarion Partners
Property Manager: Marriott International
Label Years: 2007
McAllister Plaza
[ Map It! | Profile ]
9601 McAllister Fwy.
San Antonio, TX 78216
Facility Type: Office
Owner: RBL McAllister LLP
Property Manager: Travis Commercial Real Estate
Label Years: 2011
Medical Center Plaza
[ Map It! | Profile ]
8431 Fredericksburg Road
San Antonio, TX 78229
Facility Type: Office
Owner: WNLV Ltd.
Property Manager: Travis Commercial Real Estate
Label Years: 2009, 2011
Medical Tower One
[ Map It! | Profile ]
2829 Babcock Road, Suite 527
San Antonio, TX 78229
Facility Type: Medical Office
Owner: Lillibridge Healthcare Services, Inc (San Antonio)
Property Manager: Lillibridge Healthcare Services, Inc (San Antonio)
Label Years: 2010, 2011, 2012, 2013
Medical Tower Two
[ Map It! | Profile ]
2833 Babcock
San Antonio, TX 78229
Facility Type: Medical Office
Owner: Lillibridge Healthcare Services, Inc (San Antonio)
Property Manager: Lillibridge Healthcare Services, Inc (San Antonio)
Label Years: 2010, 2011
Northwest Center
[ Map It! | Full Profile ]
7550 I-H 10 West
San Antonio, TX 78229
Facility Type: Office
Owner: Griffin Partners
Property Manager: Griffin Partners
Label Years: 2001, 2009, 2011, 2013
building
Northwood Tower
[ Map It! | Profile ]
1777 NE Loop 410
San Antonio, TX 78217
Facility Type: Office
Owner: Newmark Grubb Knight Frank
Property Manager: Newmark Grubb Knight Frank
Label Years: 2008, 2010, 2012, 2013
One Countryside Place
[ Map It! | Profile ]
12500 San Pedro Ave.
San Antonio, TX 78216
Facility Type: Office
Owner: Frost National Bank Trustee - One Countryside Place
Property Manager: Endura Advisory Group, LLC
Label Years: 2012
One International Centre
[ Map It! | Profile ]
100 NE Loop 410
San Antonio, TX 78254
Facility Type: Office
Owner: Rosemont Realty
Property Manager: Rosemont Realty
Label Years: 2008, 2010, 2012, 2013
One Riverwalk Place
[ Map It! | Profile ]
700 N. St. Mary's Street
San Antonio, TX 78205
Facility Type: Office
Owner: Equastone One Riverwalk Place, LP
Property Manager: Cambridge Professional Services, Inc.
Label Years: 2009
Pacific Plaza
[ Map It! | Profile ]
14100 San Pedro
San Antonio, TX 78232
Facility Type: Office
Owner: Domicilio Conocido III LLC
Property Manager: Endura Advisory Group, LLC
Label Years: 2010, 2011, 2012, 2013
Public Safety Headquarters
[ Map It! | Profile ]
315 South Santa Rosa Avenue
San Antonio, TX 78207
Facility Type: Office
Owner: City of San Antonio
Property Manager:
Label Years: 2014
Renaissance Plaza
[ Map It! | Profile ]
70 NE Loop 410
San Antonio, TX 78216
Facility Type: Office
Owner: 70NE410 Partnership
Property Manager: CBRE
Label Years: 2010, 2011, 2012, 2014
Rosa Verde Tower
[ Map It! | Profile ]
343 West Houston St., Ste. 411
San Antonio, TX 78205
Facility Type: Medical Office
Owner: Lillibridge Healthcare Services, Inc (San Antonio)
Property Manager: Lillibridge Healthcare Services, Inc (San Antonio)
Label Years: 2010, 2011, 2012, 2013
SA #01-372
[ Map It! | Profile ]
1955 Nacogdoches
San Antonio, TX 78209
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #05-556
[ Map It! | Profile ]
2118 Fredricksburg
San Antonio, TX 78201
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #06-047
[ Map It! | Profile ]
2701 S. Presa
San Antonio, TX 78210
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2009
SA #07-211
[ Map It! | Profile ]
415 N. New Braunfels
San Antonio, TX 78202
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager:
Label Years: 2004
SA #08-385
[ Map It! | Profile ]
300 Olmos Dr.
San Antonio, TX 78212
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #09-427
[ Map It! | Profile ]
735 Sw Military Dr.
San Antonio, TX 78221
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008, 2010
SA #10-189
[ Map It! | Profile ]
2130 Culebra
San Antonio, TX 78228
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #12-397
[ Map It! | Profile ]
18140 San Pedro
San Antonio, TX 78232
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #13-026
[ Map It! | Profile ]
4100 S New Braunfels
San Antonio, TX 78223
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2010
SA #13-181
[ Map It! | Profile ]
3524 S. New Braunfels
San Antonio, TX 78223
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007
SA #15-555
[ Map It! | Profile ]
910 Kitty Hawk
San Antonio, TX 78148
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2007, 2008
SA #16-205
[ Map It! | Profile ]
721 Castroville Rd.
San Antonio, TX 78237
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008, 2010
SA #17-395
[ Map It! | Profile ]
12777 IH 10 West
San Antonio, TX 78230
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #18 585
[ Map It! | Profile ]
1520 Austin Highway
San Antonio, TX 78211
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #20-398
[ Map It! | Profile ]
2929 Thousand Oaks
San Antonio, TX 78247
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #21-444
[ Map It! | Profile ]
3323 S.E. Military
San Antonio, TX 78223
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #22-106
[ Map It! | Profile ]
1015 S. W.W. White Rd.
San Antonio, TX 78220
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #23-222
[ Map It! | Profile ]
5803 Babcock Rd.
San Antonio, TX 78240
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #24-389
[ Map It! | Profile ]
6000 West Ave.
San Antonio, TX 78213
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008, 2010
SA #25-224
[ Map It! | Profile ]
7951 Guilbeau
San Antonio, TX 78250
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008, 2010
SA #27-190
[ Map It! | Profile ]
8231 Marbach Rd.
San Antonio, TX 78227
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #29-480
[ Map It! | Profile ]
9900 Wurzbach
San Antonio, TX 78201
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #30-262
[ Map It! | Profile ]
5601 Bandera
San Antonio, TX 78238
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #31-102
[ Map It! | Profile ]
8503 NW Military Hwy
San Antonio, TX 78230
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2010
SA #32-447
[ Map It! | Profile ]
11600 Bandera Rd.
San Antonio, TX 78250
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #33-230
[ Map It! | Profile ]
14087 O'Connor Rd.
San Antonio, TX 78217
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #34-384
[ Map It! | Profile ]
6030 Montgomery Rd.
San Antonio, TX 78239
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #35-164
[ Map It! | Profile ]
15000 San Pedro
San Antonio, TX 78212
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #36-084
[ Map It! | Profile ]
6818 S. Zarzamora
San Antonio, TX 78224
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2007, 2008
SA #36-187
[ Map It! | Profile ]
7010 S. Zarzamora
San Antonio, TX 78224
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager:
Label Years: 2004
SA #37-235
[ Map It! | Profile ]
9255 Grissom Rd.
San Antonio, TX 78250
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #38-195
[ Map It! | Profile ]
11551 West Ave.
San Antonio, TX 78213
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #39-463
[ Map It! | Profile ]
1150 N. Loop 1604 W.
San Antonio, TX 78248
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #40-494
[ Map It! | Profile ]
10660 FM 471 W.
San Antonio, TX 78251
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #41-085
[ Map It! | Profile ]
10718 Potranco Rd
San Antonio, TX 78251
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2008, 2010
SA #42-565
[ Map It! | Profile ]
1410 Huebner Road
San Antonio, TX 78230
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #43-567
[ Map It! | Profile ]
999 East Basse Road, Suite 150
San Antonio, TX 78209
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #44-568
[ Map It! | Profile ]
12018 Perrin Beitel Road
San Antonio, TX 78217
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
SA #45-108
[ Map It! | Profile ]
20935 US Hyw 281 N
San Antonio, TX 78258
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2010
SA #45-569
[ Map It! | Profile ]
20760 North Highway 281
San Antonio, TX 78259
Facility Type: Supermarket/Grocery Store
Owner: HEB
Property Manager: HEB
Label Years: 2004, 2007, 2008
San Antonio Airport Residence Inn by Marriott
[ Map It! | Profile ]
1014 Ne 410 Blvd
San Antonio, TX 78209
Facility Type: Hotel
Owner: Marriott Family Trust
Property Manager: Marriott International
Label Years: 2005
SAN ANTONIO FEDERAL BLDG WEST
[ Map It! | Profile ]
727 E CESAR E CHAVEZ BOULEVARD
SAN ANTONIO, TX 78206
Facility Type: Office
Owner: General Services Administration Region 7
Property Manager: General Services Administration Region 7
Label Years: 2012
San Antonio Marriott Riverwalk
[ Map It! | Profile ]
711 East Riverwalk
San Antonio, TX 78205
Facility Type: Hotel
Owner: Host Hotels and Resorts, Inc.
Property Manager: Marriott International
Label Years: 2004, 2007
SAN ANTONIO, TX-2877
[ Map It! | Profile ]
17710 LA CANTERA PKWY
SAN ANTONIO, TX 78257
Facility Type: Retail Store
Owner: JCPenney
Property Manager:
Label Years: 2014
San Pedro Plaza
[ Map It! | Profile ]
7330 San Pedro
San Antonio, TX 78216
Facility Type: Office
Owner: A&B Properties, Inc
Property Manager: Endura Advisory Group, LLC
Label Years: 2009, 2010, 2011, 2012, 2013
Sterling Bank Building
[ Map It! | Profile ]
13750 San Pedro
San Antonio, TX 78232
Facility Type: Office
Owner: M.S.G. Management
Property Manager: M.S.G. Management
Label Years: 2009
Stone Oak 1
[ Map It! | Profile ]
19016 Stone Oak Pkwy
San Antonio, TX 78258
Facility Type: Medical Office
Owner: Health Care REIT
Property Manager: Health Care REIT
Label Years: 2011
SWBC Tower
[ Map It! | Profile ]
9311 San Pedro
Suite 285
San Antonio, TX 78216
Facility Type: Other
Owner: Property Interests
Property Manager: Endura Advisory Group, LLC
Label Years: 2010, 2011, 2012, 2013
Target T0771
[ Map It! | Profile ]
2810 SW MILITARY DR
SAN ANTONIO, TX 78224
Facility Type: Retail Store
Owner: Target Corporation
Property Manager:
Label Years: 2014
Target T2452
[ Map It! | Profile ]
7014 FM 78
SAN ANTONIO, TX 78244
Facility Type: Retail Store
Owner: Target Corporation
Property Manager: Target Corporation
Label Years: 2013
The Commons at Concord Park
[ Map It! | Profile ]
300 E. Sonterra
San Antonio, TX 78258
Facility Type: Office
Owner: Concord Property Corporation
Property Manager: Concord Property Corporation
Label Years: 2009
The Pyramid Building
[ Map It! | Profile ]
601 NW Loop 410
San Antonio, TX 78216
Facility Type: Office
Owner: MSB Pyramid, LP c/o Buchanan Street Partners
Property Manager: Endura Advisory Group, LLC
Label Years: 2010, 2011, 2012, 2013
The Terrace
[ Map It! | Profile ]
777 East Sonterra Blvd.
San Antonio, TX 78258
Facility Type: Office
Owner: Concord Corporation
Property Manager: Concord Corporation
Label Years: 2008, 2009
Toyota Motor Manufacturing Texas (TMMTX)
[ Map It! | Profile ]
1 Lone Star Pass
San Antonio, TX 78264
Facility Type: Auto Assembly
Owner: Toyota Motor Engineering & Manufacturing North America, Inc.
Property Manager: N/A
Label Years: 2013, 2014
Trinity Plaza 2
[ Map It! | Profile ]
745 East Mulberry
San Antonio, TX 78212
Facility Type: Office
Owner: MJ 281 Development, Ltd
Property Manager: Travis Commercial Real Estate
Label Years: 2011
Union Square I
[ Map It! | Full Profile ]
10101 Reunion Place
San Antonio, TX 78216
Facility Type: Office
Owner: Union Square SPE, LLC
Property Manager: Union Square SPE, LLC
Label Years: 2001, 2009, 2013
building
Union Square II
[ Map It! | Profile ]
10001 Reunion Place
San Antonio, TX 78216
Facility Type: Office
Owner: Union Square SPE, LLC
Property Manager: Union Square SPE, LLC
Label Years: 2009, 2013
USAA Bank Services Building
[ Map It! | Profile ]
10750 McDermott Freeway
San Antonio, TX 78288
Facility Type: Financial Office
Owner: USAA - Corporate Real Estate
Property Manager:
Label Years: 2009, 2010, 2011, 2012, 2013
USAA Federal Savings Bank
[ Map It! | Profile ]
10750 McDermott Freeway
San Antonio, TX 78288
Facility Type: Financial Office
Owner: USAA - Corporate Real Estate
Property Manager:
Label Years: 2009, 2010, 2011, 2012, 2013
USAA McDermott Building
[ Map It! | Full Profile ]
9800 Fredericksburg Road
San Antonio, TX 78288
Facility Type: Financial Office
Owner: USAA - Corporate Real Estate
Property Manager:
Label Years: 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013
building


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:49 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 192.168.15.110
Host Name 192.168.15.110


Execution Time

Total Time Avg Time Count Template
420 ms 420 ms 1 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
420 ms 420 ms 1 /data/cf_code/estar/index.cfm
379 ms 379 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fa_showresults.cfm
379 ms 379 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_switch.cfm
143 ms 143 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm
84 ms 84 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm
73 ms 73 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/dsp_showresults_list.cfm
64 ms 64 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm
22 ms 22 ms 1 /data/cf_code/estar/ia/fbx_layouts.cfm
11 ms 11 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
8 ms 8 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/dsp_showresults_sidebar.cfm
2 ms 2 ms 1 /data/cf_code/estar/Application.cfm
2 ms 2 ms 1 /data/cf_code/estar/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_settings.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/lay_lb_popup.cfm
2 ms 2 ms 1 /data/cf_code/estar/ia/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/fbx_circuits.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/lay_lb_popup_showresults.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/view_showresults.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/lay_english_default.cfm
1 ms 1 ms 1 /data/coldfusion10/cfusion/CustomTags/inputfilter.cfm
0 ms 0 ms 1 /data/cf_code/estar/OnRequestEnd.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_cache_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_debug_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_layoutoption_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_message_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_specialurlformat_init.cfm
0 ms 0 ms 2 /data/cf_code/estar/fbx_server.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_js_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_layout_pick.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagecrumb_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagetitle_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/act_showresults_paging.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/dsp_breadcrumbtrail.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/fbx_layouts.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_createqstring.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_normalizevalue.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_building_type_id.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/business/labeled_buildings/val_showresults.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_acrobat_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_devnotes.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_email_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_footer.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_footer_links.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_googletagmanager.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_photo.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_printable_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sections.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sitesearch_textbox.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_slogan.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_trail.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/lay_english_standard.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/metadata/metadata.wddx
0 ms 0 ms 2 /data/cf_code/estar/ia/val_language.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_layout.cfm
0 ms 0 ms 1 /data/cf_code/estar/lockoutapps.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
423 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:49:39.039 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template ia/business/fbx_Layouts.cfm.
	    
12:49:39.039 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template fbx_Layouts.cfm.
	    


SQL Queries

allLocatorResults (Datasource=PMULAB_PMU, Time=19ms, Records=24350, Cached Query) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:49:38.038
	SELECT
		b_id,
		sort_building_name,
		building_name,
		building_type_id,
		building_type,
		bt_id,
		nvl(owner,'N/A') as owner,
		prop_manager,
		address1,
		address2,
		city,
		state,
		state_name,
		zip,
		formatted_zip,
		spp,
		property_type_id,
		property_type_name,
		property_type,
		plantyears,
		ratings_desc,
		yearBuilt,
		floorspace,
		hasFullProfile_tf,
		latitude,
		longitude,
		date_approved,
		approx_yn,
		federal_bldg_yn,
		pin_offset_yn		
	FROM
		mv_bldg_loc_result
	WHERE
		building_type_id != '23'
getCount (Datasource=, Time=48ms, Records=24350) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:49:38.038
SELECT DISTINCT
	b_id,
	floorspace
FROM allLocatorResults
getFootage (Datasource=, Time=73ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_alllocatorresults.cfm @ 12:49:38.038
SELECT SUM(floorspace) AS footage
FROM getCount
allBuildings (Datasource=, Time=58ms, Records=101) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:49:38.038
SELECT *
FROM allLocatorResults
WHERE
	1 = 1
	
	
	AND (
			
		LOWER(city) LIKE ? 
	)
		
	AND state IN (?)
		
ORDER BY
	sort_building_name,
	date_approved DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %san antonio%
Parameter #2(CF_SQL_VARCHAR) = TX

getFilteredCount (Datasource=, Time=2ms, Records=101) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:49:38.038
SELECT DISTINCT
	b_id,
	floorspace
FROM allBuildings
getFilteredFootage (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/qry_filterlocatorresults.cfm @ 12:49:38.038
SELECT SUM(floorspace) AS footage
FROM getFilteredCount
getFacilityTypes (Datasource=, Time=2ms, Records=12) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT DISTINCT
	property_type_id,
	property_type_name,
	property_type,
	building_type_id,
	building_type
FROM allBuildings
ORDER BY
	property_type,
	building_type
building_count (Datasource=, Time=1ms, Records=99) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
	SELECT DISTINCT
		b_id,
		building_type
	FROM allBuildings
	WHERE property_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = building

Courthouse_count (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Courthouse

FinancialOffice_count (Datasource=, Time=1ms, Records=3) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Financial Office

HospitalGeneralMedicalSurgical_count (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Hospital (General Medical & Surgical)

Hotel_count (Datasource=, Time=1ms, Records=5) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Hotel

KSchool_count (Datasource=, Time=1ms, Records=3) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = K-12 School

MedicalOffice_count (Datasource=, Time=1ms, Records=5) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Medical Office

Office_count (Datasource=, Time=2ms, Records=34) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Office

Other_count (Datasource=, Time=2ms, Records=2) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Other

RetailStore_count (Datasource=, Time=2ms, Records=3) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Retail Store

SupermarketGroceryStore_count (Datasource=, Time=2ms, Records=42) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM building_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Supermarket/Grocery Store

plant_count (Datasource=, Time=2ms, Records=2) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
	SELECT DISTINCT
		b_id,
		building_type
	FROM allBuildings
	WHERE property_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = plant

AutoAssembly_count (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM plant_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Auto Assembly

Cement_count (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT DISTINCT(b_id)
		FROM plant_count
		WHERE building_type = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = Cement

getStates (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT DISTINCT
	state,
	state_name,
	0 AS cnt
FROM allBuildings
ORDER BY state_name
count (Datasource=, Time=2ms, Records=101) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
	SELECT *
	FROM allBuildings
	WHERE state = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = TX

getStates (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT *
FROM getStates
ORDER BY state_name 
getYears (Datasource=, Time=2ms, Records=38) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT DISTINCT
	plantyears,
	0 AS cnt
FROM allBuildings
count (Datasource=, Time=2ms, Records=3) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2001%

count (Datasource=, Time=1ms, Records=18) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2009%

count (Datasource=, Time=1ms, Records=25) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2011%

count (Datasource=, Time=2ms, Records=28) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2013%

count (Datasource=, Time=1ms, Records=24) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2012%

count (Datasource=, Time=1ms, Records=9) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2014%

count (Datasource=, Time=2ms, Records=2) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2003%

count (Datasource=, Time=1ms, Records=37) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2004%

count (Datasource=, Time=2ms, Records=4) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2005%

count (Datasource=, Time=3ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2006%

count (Datasource=, Time=1ms, Records=41) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2007%

count (Datasource=, Time=2ms, Records=41) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2008%

count (Datasource=, Time=2ms, Records=30) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE plantyears LIKE ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = %2010%

getYearCounts (Datasource=, Time=1ms, Records=13) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT *
FROM getYearCounts
ORDER BY yr DESC
getYearLast30 (Datasource=, Time=2ms, Records=0) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT *
FROM allBuildings
WHERE date_approved >= ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 20140623

getCities (Datasource=, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
	SELECT DISTINCT
		UPPER(city) AS city,
		state,
		state_name,
		0 AS cnt
	FROM allBuildings
	ORDER BY
		city,
		state_name
	
count (Datasource=, Time=2ms, Records=101) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
		SELECT *
		FROM allBuildings
		WHERE
			UPPER(city) = ?
			AND state = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = SAN ANTONIO
Parameter #2(CF_SQL_VARCHAR) = TX

getCities (Datasource=, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
	SELECT *
	FROM getCities
	ORDER BY
		cnt DESC,
		city,
		state_name
	
getProfiles (Datasource=, Time=1ms, Records=5) in /data/cf_code/estar/ia/business/labeled_buildings/act_showresults.cfm @ 12:49:38.038
SELECT *
FROM allBuildings
WHERE hasFullProfile_tf > ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 0

qProfile (Datasource=PMULAB_PMU, Time=2ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:49:38.038
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 1394357

qProfile (Datasource=PMULAB_PMU, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:49:38.038
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 2587415

qProfile (Datasource=PMULAB_PMU, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:49:39.039
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 2564230

qProfile (Datasource=PMULAB_PMU, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:49:39.039
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 3487072

qProfile (Datasource=PMULAB_PMU, Time=1ms, Records=1) in /data/cf_code/estar/ia/business/labeled_buildings/udf_photoready.cfm @ 12:49:39.039
		SELECT
			prof.*,
			CASE WHEN (photo_length) > 0 THEN 1 ELSE 0 END AS has_photo
		FROM (
			SELECT
				p.p_id,
				p.update_date,
				p.p_file_name,
				LENGTH(p_bldg_photo) AS photo_length,
				pa.pt_code
			FROM
				profile p,
				profile_acct pa
			WHERE
				p.b_id = ?
				AND p.pa_id = pa.pa_id
		) prof
		ORDER BY
			has_photo DESC,
			pt_code ASC
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 23313

getMenuItems (Datasource=, Time=9ms, Records=20) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:49:39.039
SELECT *
FROM menuItems
ORDER BY
  itemGroup,
  itemOrder


Scope Variables

Application Variables:
applicationname=lb
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/data/cf_code/estar/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energystar.gov
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/data/cf_code/estar/index.cfm
QUERY_STRING=fuseaction=labeled_buildings.showResults&building_type_id=ALL&city=San%20Antonio&s_code=TX&profiles=0&also_search_id=NONE&letter=ALL&current_sort_column=building%5Fname&current_sort_order=asc&startnum=1&resultsperpage=53
REMOTE_ADDR=192.168.15.110
REMOTE_HOST=192.168.15.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.energystar.gov
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=
WEB_SERVER_API=
Client Variables:
cfid=19823272
cftoken=8cbc5ad7b0d36776-E9484262-0D41-75EF-D20E8AEABB3D44BF
hitcount=1
lastvisit={ts '2014-07-23 12:49:38'}
timecreated={ts '2014-07-23 12:49:38'}
urltoken=CFID=19823272&CFTOKEN=8cbc5ad7b0d36776-E9484262-0D41-75EF-D20E8AEABB3D44BF
Cookie Variables:
CFID=19823272
CFTOKEN=8cbc5ad7b0d36776-E9484262-0D41-75EF-D20E8AEABB3D44BF
URL Parameters:
also_search_id=NONE
building_type_id=ALL
city=San Antonio
current_sort_column=building_name
current_sort_order=asc
fuseaction=labeled_buildings.showResults
letter=ALL
profiles=0
resultsperpage=53
s_code=TX
startnum=1
Debug Rendering Time: 27 ms