For Sale Sign Logo
Awards News Careers Contact Us
site banner The Leader In Commercial Real Estate
Brokerage Services

Brokerage Overview

Retail

Office

Industrial

Investment

Corporate Services

Business Parks

 
Property Management Services

Management Overview

Construction Management

Facility Management

Financial Management

Transition Management

Consulting Services

 
Office Locations

Milwaukee

Fox Valley

Madison

Florida

 

enter keyword for quick search
Search MLG Listings

Retail Space in Hansen . Records found 0.

No Properties were found using your search criteria. Let our commercial real estate experts find it for you.
 

Commercial Real Estate Listings in communities adjacent to Hansen

Arpin Available Retail Space

0 listings

Dexter Available Retail Space

0 listings

Richfield Available Retail Space

0 listings

Seneca Available Retail Space

0 listings

Sherry Available Retail Space

0 listings

Sigel Available Retail Space

0 listings

Vesper Available Retail Space

0 listings

Wood Available Retail Space

0 listings

(414) 347-9400 | Offices in Milwaukee , Fox Valley , Madison , and Florida
Milwaukee Industrial Properties | Milwaukee Office Properties | Milwaukee Retail Properties | Madison Industrial Properties | Madison Office Properties | Madison Retail Properties | Waukesha Industrial Properties | Waukesha Office Properties | Waukesha Retail Properties | Appleton Industrial Properties | Appleton Office Properties | Appleton Retail Properties |
© 2006 MLG Commercial, Inc. All Rights Reserved
MLG Blog
 


Debugging Information
ColdFusion Server Enterprise 9,0,2,282541
Template /properties/ShowList.cfm
Time Stamp 24-Jul-14 07:36 PM
Locale English (US)
User Agent ColdFusion
Remote IP 192.168.1.40
Host Name 192.168.1.40


Execution Time

Total Time Avg Time Count Template
32 ms 32 ms 1 top level E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm
0 ms 0 ms 1 E:/RealPlaces/E/INETPUB/mlgcommercial.wwwroot/Application.cfm
0 ms 0 ms 1 E:/RealPlaces/E/INETPUB/mlgcommercial.wwwroot/footer.cfm
0 ms 0 ms 1 E:/RealPlaces/E/INETPUB/mlgcommercial.wwwroot/header.cfm
0 ms 0 ms 1 E:/RealPlaces/E/INETPUB/mlgcommercial.wwwroot/sideMenu.cfm
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
47 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

getCompanyInfo (Datasource=mlgcommercial, Time=0ms, Records=1) in E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\Application.cfm @ 19:36:37.037
	SELECT	*
	FROM	company
	Where	companyID = 1 
getFeatured (Datasource=mlgcommercial, Time=0ms, Records=0) in E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm @ 19:36:37.037
	  Select *, newid() as newid
	  from PropSummary
	  Where	psActive = '1'
	  And  PSPROPERTYTYPE LIKE '%Retail%' And  PSCITY = 'Hansen' 
	  Order	by psCity
	
getBrokerageServices (Datasource=mlgcommercial, Time=0ms, Records=13) in E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\sideMenu.cfm @ 19:36:37.037
			SELECT	srvID, srvName, srvTemplate, srvType as ServiceType, srvOrder

			From	Services
			Where	srvType in ( ?, ?)
			And		srvCompany in (1, 8)
			And		Show = 'Y'
            AND srvName not IN ('About Us', 'Services')
			Order	By srvType, srvOrder
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Brokerage
Parameter #2(cf_sql_varchar) = Property Management

getOfficeServices (Datasource=mlgcommercial, Time=0ms, Records=4) in E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\sideMenu.cfm @ 19:36:37.037
			SELECT	srvID, srvName, srvType, srvTemplate
			From	Services
			Where	srvType = ?
			
            And		srvCompany in (1, 8)
            And		Show <> 'N'
            And		Show <> 'No'
            
			Order	By srvOrder
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Office

getSpecialtyServices (Datasource=mlgcommercial, Time=0ms, Records=0) in E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\sideMenu.cfm @ 19:36:37.037
			SELECT	srvID, srvName
			From	Services
			Where	srvType = ?
			And		srvCompany = ?
			Order	By srvOrder
		
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = specialty
Parameter #2(cf_sql_integer) = 1

getCities (Datasource=mlgcommercial, Time=32ms, Records=8) in E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm @ 19:36:37.037
				SELECT     AdjacentCities.Adjacent, COUNT(PropSummary.psID) AS NumOfListings
				FROM         AdjacentCities LEFT OUTER JOIN
									  PropSummary ON AdjacentCities.Adjacent = PropSummary.psCity AND PropSummary.psActive = '1'
									  	And  PSPROPERTYTYPE LIKE '%Retail%'
				WHERE          (AdjacentCities.CITY = 'Hansen')
				GROUP BY AdjacentCities.Adjacent, PropSummary.psActive
			


Scope Variables

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=E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm
CONTENT_LENGTH=67
CONTENT_TYPE=application/x-www-form-urlencoded
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=
HTTP_ACCEPT_ENCODING=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=www.mlgcommercial.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/properties/ShowList.cfm
PATH_TRANSLATED=E:\RealPlaces\E\INETPUB\mlgcommercial.wwwroot\properties\showList.cfm
QUERY_STRING=
REMOTE_ADDR=192.168.1.40
REMOTE_HOST=192.168.1.40
REMOTE_USER=
REQUEST_METHOD=POST
SCRIPT_NAME=/properties/ShowList.cfm
SERVER_NAME=www.mlgcommercial.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Cookie Variables:
CFID=627096
CFTOKEN=15422041
Form Fields:
FIELDNAMES=PSCITY,RANDOMORDER,PSPROPERTYTYPE,SEARCHTYPE
PSCITY=Hansen
PSPROPERTYTYPE=Retail
RANDOMORDER=yes
SEARCHTYPE=long
Server Variables:
coldfusion=Struct (8)
os=Struct (5)
Session Variables:
cfid=627096
cftoken=15422041
sessionid=MLGCOMMERCIALPORTAL_627096_15422041
urltoken=CFID=627096&CFTOKEN=15422041
URL Parameters:
CAT=
MLGWORD=
Debug Rendering Time: 15 ms