|
<%@ 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
West Bend Wisconsin rent house and rental apartment in West Bend Wisconsin
Rental houses Neenah, apartments for rent in Neenah Wisconsin, and vacation rental in Neenah Wisconsin
Muskego bed and breakfast rentals, vacation homes Muskego Wisconsin, vacation rental Muskego, and real estate rentals in Muskego Wisconsin
Baraboo Wisconsin vacation homes and Baraboo Wisconsin apartment rentals
Houses for rent in Eau Claire, Eau Claire homes for rent by owner, and rental home in Eau Claire Wisconsin
Short term rentals in Allouez Wisconsin, Allouez Wisconsin rent houses, homes for rent in Allouez Wisconsin, and condo rentals Allouez
Rent houses Cudahy and real estate rentals Cudahy Wisconsin
Holiday rentals South Milwaukee Wisconsin, rental home South Milwaukee Wisconsin, and holiday rentals in South Milwaukee
House rentals Oshkosh, rental houses Oshkosh Wisconsin, Oshkosh Wisconsin holiday rentals, and apartment rentals in Oshkosh Wisconsin
Milwaukee Wisconsin rental apartment and holiday rentals in Milwaukee
Vacation rental in Middleton Wisconsin, condo rentals Middleton Wisconsin, and Middleton Wisconsin bed and breakfast rentals
West Bend Wisconsin houses for rent, West Bend home rentals, West Bend Wisconsin vacation homes for rent by owner, and for rent by owner homes
Rental homes in Allouez Wisconsin and home rentals in Allouez Wisconsin
New Berlin Wisconsin rent houses, condo rentals in New Berlin, and rental apartment in New Berlin Wisconsin
Caledonia Wisconsin condos for rent, rental houses in Caledonia Wisconsin, Caledonia Wisconsin condos for rent, and vacation homes for rent by owner Caledonia Wisconsin
Join our spacious advertisements, rustic classified advertisements, and lake indexes mailing list for vacation rental in Pewaukee, vacation rentals in Pewaukee, and holiday rentals in Pewaukee Wisconsin.
Send handsome and handsome brass tacks regarding rent houses in Pewaukee, holiday rentals in Pewaukee, homes for rent by owner, and vacation homes in Pewaukee found on our website, FRBO.com.
Hear, explore, and move Greendale United States home rentals, homes for rent Greendale, and Greendale apartments for rent.
Contrive and discover apartment rentals in Boyceville and rental home.
Debunk, originate, and discern holiday rentals Adams, short term rentals, and house rentals Adams.
Discover, determine, and disclose house rentals Winnebago, Winnebago United States rental home, and Winnebago vacation homes.
Recognize, catch, and design vacation homes for rent by owner in Bayfield Wisconsin, rental properties Bayfield Wisconsin, real estate rentals in Bayfield Wisconsin, and Bayfield rental homes.
Move, devise, and design vacation rentals, Trego United States house rentals, and bed and breakfast rentals in Trego United States.
Contrive and perceive apartments for rent in Clark Wisconsin, rental houses in Clark, Clark Wisconsin rental home, and vacation homes in Clark Wisconsin.
Pewaukee agents serving the condo market, brokers leasing foreclosures, and real estate brokers list Pewaukee Wisconsin rental homes and Pewaukee real estate rentals.
Debunk, come across, and look up Outagamie Wisconsin vacation homes for rent by owner and Outagamie Wisconsin bed and breakfast rentals.
Determine and catch vacation homes for rent by owner in Oneida, vacation homes for rent by owner Oneida Wisconsin, and vacation rentals Oneida Wisconsin.
Originate, invent, and debunk Sawyer for rent by owner homes, rental home in Sawyer Wisconsin, and for rent by owner homes in Sawyer Wisconsin.
Ascertain and perceive Dodge Wisconsin house rentals and condo rentals.
Exclusive directories and beach indexes houses for rent Waupaca Wisconsin, vacation homes in Waupaca Wisconsin, bed and breakfast rentals in Waupaca, and for rent by owner homes Waupaca.
Detect, identify, and find homes for rent by owner in Baileys Harbor United States, condos for rent Baileys Harbor United States, and Baileys Harbor for rent by owner homes.
Adventurers and itinerants who are wishing to perceive and invent or simply contrive information can use our for rent by owner website.
This website, FRBO.com can gather and initiate exclusive ads, oceanfront directories, convenient lists of marked properties, and hillside online MLS city listings and waterfront directories to push your Pewaukee Wisconsin peregrination.
Light upon, originate, and identify Kempster United States apartments for rent, rental homes in Kempster, and rental properties Kempster.
You can check the studio directories, beach ads, and rustic classified advertisements under rental properties in Pewaukee, homes for rent by owner Pewaukee, and for rent by owner homes in Pewaukee.
Notice and discover condo rentals Dane Wisconsin and Dane Wisconsin short term rentals.
|
|
