SELECT * FROM company Where companyID = 1
Select *, newid() as newid from PropSummary Where psActive = '1' And PSCITY = 'Racine' Order by psCity
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
SELECT srvID, srvName, srvType, srvTemplate From Services Where srvType = ? And srvCompany in (1, 8) And Show <> 'N' And Show <> 'No' Order By srvOrder
SELECT srvID, srvName From Services Where srvType = ? And srvCompany = ? Order By srvOrder
SELECT AdjacentCities.Adjacent, COUNT(PropSummary.psID) AS NumOfListings FROM AdjacentCities LEFT OUTER JOIN PropSummary ON AdjacentCities.Adjacent = PropSummary.psCity AND PropSummary.psActive = '1' WHERE (AdjacentCities.CITY = 'Racine') GROUP BY AdjacentCities.Adjacent, PropSummary.psActive
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=61 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=1630669 CFTOKEN=64816313
Form Fields: FIELDNAMES=PSCITY,RANDOMORDER,PSPROPERTYTYPE,SEARCHTYPE PSCITY=Racine PSPROPERTYTYPE= RANDOMORDER=yes SEARCHTYPE=long
Server Variables: coldfusion=Struct (8) os=Struct (5)
Session Variables: cfid=1630669 cftoken=64816313 sessionid=MLGCOMMERCIALPORTAL_1630669_64816313 urltoken=CFID=1630669&CFTOKEN=64816313
URL Parameters: CAT= MLGWORD=Debug Rendering Time: 31 ms
Racine is a city in Racine County, Wisconsin, United States, located beside Lake Michigan at the mouth of the Root River. As of the 2006 census, the city had a total population of 79,592. It is the county seat of Racine County.
On October 10, 1699, a fleet of eight canoes bearing a party of French explorers entered the mouth of Root River. These were the first known white men to visit what is now Racine County. They founded a French trading post in the area which eventually became a small settlement on Lake Michigan near where the Root River empties into Lake Michigan. That is why Racine has a French name: "racine" means "root" in the French language.
In 1832, just after the Blackhawk War, the area surrounding Racine was settled by Yankees from upstate New York, looking for new horizons for their entrepreneurial urges.
Gilbert Knapp, a Lake boat captain in 1834, founded the settlement of Port Gilbert at the place where the Root River empties into Lake Michigan. The area was previously called Kipi Kawi and Chippecotton by the indigenous peoples, both names for the Root River. The name "Port Gilbert" was never really accepted, and in 1841, the community was incorporated as the village of Racine. (The word "racine" means "root" in French). After Wisconsin's statehood was granted in 1848, the new legislature voted in August to incorporate Racine as a city.
Before the American Civil War, Racine was well known for its strong opposition to slavery. Many slaves escaping to freedom via the Underground Railroad passed through the city. In 1854 Joshua Glover, an escaped slave who had made a home in Racine, was arrested by federal marshals and taken to a jail in Milwaukee. One hundred men from Racine, and ultimately 5,000 Wisconsinites, rallied and broke into the jail to free him. He was helped to escape to Canada. Glover's rescue gave rise to many legal complications and a great deal of litigation. This eventually lead to the Wisconsin Supreme Court declaring the Fugitive Slave Law of 1850 unconstitutional, and later, the Wisconsin State Legislature refusing to recognize the authority of the U.S. Supreme Court.
Waves of immigrants, including Danes, Germans, and Czechs began to settle in Racine between the Civil War and the First World War. African Americans started arriving in large numbers during World War I, as they did in other Midwestern industrial towns, and Mexicans started migrating to Racine from roughly 1925 onward.
Unitarians from New England initially dominated Racine's religious life, as they did in other parts of the Upper Midwest before 1880. Racine's Emmaus Lutheran Church is the oldest Danish Lutheran Church in North America, founded on August 22, 1851. Emmaus Lutheran, originally a founding member of the Danish American Lutheran Church, has subsequently been a member of the United Danish Evangelical Lutheran Church in America (UDELCA), the American Lutheran Church (ALC), and, since 1988, the Evangelical Lutheran Church in America (ELCA).
Racine was a factory town almost from the very beginning. The first industry in Racine County included the manufacture of Fanning mills, machines that separated wheat grain from chaff. Racine also had its share of captains of industry, including J. I. Case (heavy equipment), S.C. Johnson (cleaning and chemical products), Secor, and many others, including shipping. Racine's harbor was very central to the shipping industry in the late 1800s. Racine furthermore was an early car manufacturing center. One of the world's first automobiles was allegedly built there in 1871 or 1872 by Dr. J. W. Cathcart,, as was the Pennington Victoria tricycle, the Mitchell, and the Case
In 1887, malted milk was invented by Englishman William Horlick in Racine, and Horlicks remains a global brand. The garbage disposal was invented in 1927 by architect John Hammes of Racine. He founded the company InSinkErator in Racine, which still produces millions of garbage disposers a year. In addition, Racine is the home of Johnson Wax, with its headquarters designed in 1936 by Frank Lloyd Wright, who also designed the Wingspread Conference Center and two homes in Racine. The city is also home to the Dremel Corporation as well as Twin Disc.
Racine claims to be the largest North American settlement of Danes outside of Greenland. Racine is particularly known for its Danish pastries, especially kringle. Several bakeries have been featured on Food Network.
Racine is located at(42.726052, -87.805873).
According to the United States Census Bureau, the city has a total area of 18.7 square miles (48.4 km²), of which, 15.5 square miles (40.2 km²) of it is land and 3.1 square miles (8.1 km²) of it (16.76%) is water.
As of the census of 2000, there were 81,855 people, 31,449 households, and 20,405 families residing in the city. The population density was 5,267.6 people per square mile (2,033.7/km²). There were 33,414 housing units at an average density of 2,150.3/sq mi (830.2/km²). The racial makeup of the city was 68.91% White, 20.32% African American, 0.40% Native American, 0.61% Asian, 0.05% Pacific Islander, 7.14% from other races, and 2.57% from two or more races. Hispanic or Latino of any race were 13.95% of the population.
There were 31,449 households out of which 33.9% had children under the age of 18 living with them, 42.2% were married couples living together, 17.9% had a female householder with no husband present, and 35.1% were non-families. 29.4% of all households were made up of individuals and 10.5% had someone living alone who was 65 years of age or older. The average household size was 2.54 and the average family size was 3.15.
In the city the population was spread out with 28.7% under the age of 18, 9.9% from 18 to 24, 30.0% from 25 to 44, 19.2% from 45 to 64, and 12.2% who were 65 years of age or older. The median age was 33 years. For every 100 females there were 95.0 males. For every 100 females age 18 and over, there were 91.2 males.
The median income for a household in the city was $37,164, and the median income for a family was $45,150. Males had a median income of $35,079 versus $24,279 for females. The per capita income for the city was $17,705. About 10.8% of families and 13.9% of the population were below the poverty line, including 20.6% of those under age 18 and 6.6% of those aged 65 or over.
The government of the City of Racine is divided into executive and legislative branches. The mayor is the chief executive, elected by general election for a term of four years. The mayor appoints commissioners and other officials who oversee the various departments, subject to Common Council approval. The current mayor is Gary Becker, a member of the Mayors Against Illegal Guns Coalition, a bi-partisan group with a stated goal of "making the public safer by getting illegal guns off the streets." The Coalition is co-chaired by Boston Mayor Thomas Menino and New York City Mayor Michael Bloomberg.
In addition to the mayor, Racine's other citywide elected official is the Municipal Judge. The City Council is the legislative branch and is made up of 15 aldermen, one elected from each district in the city. The council enacts local ordinances and approves the city budget. Government priorities and activities are established in a budget ordinance usually adopted each November. The council takes official action through the passage of ordinances and resolutions.
Racine's public schools are managed by the Racine Unified School District, which oversees twenty-one elementary schools, seven middle schools and five high schools with a combined student population of around 21,000 students.
Private Elementary Schools
The Journal Times is Racine's daily newspaper.
WRJN-AM 1400 and WEZY-FM 92.1 are Racine's radio stations.
The Insider News covers the black community.
The Milwaukee Journal-Sentinel publishes a Racine page on Thursdays and a section on Sundays.
WIPZ out of the University of Wisconsin-Parkside is available to most of the city of Racine.
There are many recreational outings to serve the people living in Racine and its surrounding areas. Among the parks and commercial centers, there are many outlets for relaxation available to the citizens of Racine.
Racine has five sister cities:
Notable people from Racine