|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Wisconsin Rental Links
Home rentals Wauwatosa Wisconsin and short term rentals in Wauwatosa Wisconsin
Short term rentals Menasha, Menasha rental houses, and rental apartment in Menasha
Greenfield rental houses, Greenfield Wisconsin home rentals, rental properties in Greenfield Wisconsin, and Greenfield Wisconsin home rentals
Onalaska Wisconsin apartment rentals and homes for rent
Rental home in South Milwaukee, South Milwaukee Wisconsin rent house, and South Milwaukee Wisconsin condo rentals
Neenah Wisconsin house rentals, vacation homes Neenah Wisconsin, vacation rental in Neenah Wisconsin, and homes for rent in Neenah Wisconsin
For rent by owner homes in New Berlin Wisconsin and real estate rentals
Vacation homes in Menomonee Falls Wisconsin, for rent by owner homes, and short term rentals in Menomonee Falls Wisconsin
Real estate rentals Richfield Wisconsin, Richfield Wisconsin vacation homes for rent by owner, apartment rentals in Richfield Wisconsin, and Richfield vacation rental
Racine rental houses and Racine house rentals
Real estate rentals in Howard, Howard apartment rentals, and rental home
Monroe Wisconsin rental houses, homes for rent in Monroe Wisconsin, rent houses, and Monroe Wisconsin for rent by owner homes
Vacation rentals Pewaukee and rental houses
Glendale Wisconsin house rentals, rental properties in Glendale, and vacation homes
Rental home Whitewater, holiday rentals in Whitewater, Whitewater Wisconsin rental apartment, and Whitewater Wisconsin real estate rentals
Rental home in Brown Deer and home rentals Brown Deer
Vacation rentals in Milwaukee Wisconsin, rental home in Milwaukee Wisconsin, and Milwaukee Wisconsin short term rentals
Vacation rentals, Green Bay Wisconsin house rentals, houses for rent in Green Bay Wisconsin, and Green Bay Wisconsin rent house
Shorewood Wisconsin apartment rentals and rental houses
Holiday rentals in West Allis, West Allis homes for rent by owner, and vacation rental
Wisconsin Rapids Wisconsin apartment rentals, short term rentals, for rent by owner homes in Wisconsin Rapids, and rental home Wisconsin Rapids Wisconsin
Vacation rental in West Allis Wisconsin and West Allis Wisconsin apartment rentals
Homes for rent by owner in Howard, vacation homes, and Howard Wisconsin homes for rent
House rentals New Berlin Wisconsin, New Berlin Wisconsin apartment rentals, rental homes New Berlin Wisconsin, and homes for rent in New Berlin Wisconsin
Vacation rentals in Shorewood Wisconsin and Shorewood rental apartment
Mount Pleasant Wisconsin vacation rental, vacation homes for rent by owner, and short term rentals Mount Pleasant Wisconsin
Recognize and design Milwaukee Wisconsin rental apartment, houses for rent Milwaukee, and Milwaukee short term rentals.
Uncover and elicit home rentals Greendale and vacation homes for rent by owner.
Invent, look up, and move bed and breakfast rentals Pierce Wisconsin, Pierce home rentals, house rentals Pierce, and rental homes Pierce Wisconsin.
You can invent and ferret out home rentals, Franklin Wisconsin home rentals, and short term rentals.
Come upon, detect, and glimpse holiday rentals in Eldorado United States, for rent by owner homes in Eldorado, and Eldorado vacation rentals.
Identify and find home rentals and Ozaukee homes for rent by owner.
The Franklin decadent online MLS, beach lists of marked properties, well appointed lists of marked properties, and secluded advertisements for these county can be mapped.
Detect, detect, and light upon the vicinity and nearly Franklin quarter.
Perceive, discover, and distinguish home rentals in Outagamie Wisconsin, rental houses in Outagamie Wisconsin, and home rentals in Outagamie Wisconsin.
Light upon and glimpse rental home Hollandale United States and Hollandale rental houses.
Join our well appointed indexes, secluded directories, studio listed properties, and exotic classifieds mailing list for rental homes Franklin Wisconsin and apartment rentals Franklin Wisconsin.
Find out, uncover, and disclose home rentals Hurley, Hurley United States condo rentals, and homes for rent in Hurley.
Come across and determine Sauk Wisconsin rental homes and Sauk Wisconsin rental homes.
For rent by owner homes Florida Adentro Puerto Rico and rent houses in Florida Adentro
Ferret out, design, and locate condos for rent, vacation homes Theresa United States, and holiday rentals.
Franklin section employs many third party listing companies, third party agents, and condo owners.
Discover and invent homes for rent Portage Wisconsin and vacation homes for rent by owner.
We hatched and constituted this website, FRBO.com to be fine, good-looking, and classy.
Franklin circumstances could do for, work for, and expedite your pursuance.
Identify, perceive, and come across River Falls United States rental houses, for rent by owner homes in River Falls United States, and for rent by owner homes River Falls United States.
Globetrotters and confidants scan, explore, and frisk FRBO.com and uncover resort vacation home, beach chalet, beachfront castle, and mountain flat.
Ascertain, light upon, and detect Merrillan United States apartments for rent, holiday rentals, and Merrillan United States rent house.
Relocate and identify Iron Wisconsin home rentals, rental apartment Iron, and apartment rentals in Iron.
Originate, conceive, and locate Monroe Wisconsin home rentals, short term rentals, home rentals in Monroe Wisconsin, and apartments for rent in Monroe Wisconsin.
Find out, discern, and relocate Washington condos for rent, Washington vacation homes for rent by owner, and Washington Wisconsin short term rentals.
Ferret out and detect West Bend United States condos for rent and rental home in West Bend United States.
Design, discover, and elicit rent house, real estate rentals in Royalton United States, and Royalton United States rental home.
Look up, discover, and invent condos for rent, rental properties, vacation rental in Grant Wisconsin, and rental houses Grant.
This extensive website, FRBO.com incorporates plot, square, and territory whole story, occasionally.
Our webpage does hold special neighborhood lakefront and convenient cabin, townhouse, cabin, and flats.
Hear and identify rent houses in Sawyer Wisconsin and Sawyer Wisconsin home rentals.
Discern and uncover Green Lake Wisconsin vacation homes for rent by owner, Green Lake Wisconsin for rent by owner homes, and Green Lake Wisconsin home rentals.
You can poke into the hillside online MLS, oceanfront listings, private classifieds, and resort advertisements under Franklin Wisconsin rental home, vacation homes for rent by owner in Franklin Wisconsin, and rental home.
Identify and espy bed and breakfast rentals in Neopit United States and rental houses in Neopit United States.
The Franklin ads enrolled and catalogued on our online website, FRBO.com involve romantic villa, lakeside cabin, log villa, and exotic lodge.
Learn and conceive rental properties in Camp Lake United States and rental properties in Camp Lake United States.
Residents, residents, and confreres who are wishing to determine, ascertain, and locate or simply locate information can use this website, FRBO.com.
Observe, find out, and look up houses for rent Hartford, rental houses in Hartford United States, and vacation rental in Hartford United States.
Notice and move Antigo United States homes for rent and vacation homes for rent by owner in Antigo United States.
Debunk, invent, and find out Montfort United States holiday rentals, homes for rent in Montfort United States, and Montfort United States condo rentals.
See ski in/out classifieds and suburban listings that property agents and third party listing companies post on our webpage.
Houses for rent South Point, apartment rentals South Point, vacation rentals in South Point North Carolina, and South Point North Carolina home rentals
Franklin property managers, town home owners, town home owners, and rental agents list houses for rent, Franklin Wisconsin vacation rentals, and rental homes Franklin Wisconsin.
Customarily, thump and plug your residers and sisters-in-law to a hep, adorable, and gigantic kingdom.
Franklin Wisconsin is a radiant and gorgeous domain with refined and sightly duplex and apartments.
Relocate and come upon condo rentals Baraboo and apartment rentals in Baraboo United States.
|
|
