|
<%@ 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
Condos for rent Manitowoc Wisconsin and holiday rentals in Manitowoc
House rentals in Stoughton Wisconsin, vacation homes in Stoughton, and rental homes
Home rentals in Kenosha, apartment rentals in Kenosha Wisconsin, Kenosha home rentals, and Kenosha Wisconsin condo rentals
Grand Chute homes for rent by owner and condo rentals in Grand Chute Wisconsin
South Milwaukee holiday rentals, South Milwaukee Wisconsin houses for rent, and South Milwaukee Wisconsin bed and breakfast rentals
Onalaska condo rentals, Onalaska homes for rent, Onalaska for rent by owner homes, and Onalaska vacation rentals
Watertown Wisconsin condos for rent and home rentals in Watertown
Neenah Wisconsin for rent by owner homes, Neenah vacation rental, and short term rentals in Neenah Wisconsin
Wauwatosa vacation homes, Wauwatosa Wisconsin for rent by owner homes, for rent by owner homes, and Wauwatosa Wisconsin vacation rentals
Greenfield Wisconsin apartments for rent and holiday rentals Greenfield Wisconsin
Homes for rent by owner in Manitowoc Wisconsin, Manitowoc Wisconsin rental apartment, and rent house in Manitowoc Wisconsin
Greenfield Wisconsin rental homes, Greenfield Wisconsin apartments for rent, Greenfield Wisconsin homes for rent by owner, and Greenfield Wisconsin rental home
Vacation homes for rent by owner and Neenah Wisconsin vacation homes
Stevens Point Wisconsin bed and breakfast rentals, apartment rentals, and for rent by owner homes in Stevens Point
Rental apartment Superior Wisconsin, vacation homes for rent by owner in Superior, vacation homes in Superior, and apartment rentals Superior
Vacation homes Wauwatosa Wisconsin and Wauwatosa Wisconsin rental houses
For rent by owner homes, condos for rent, and Pewaukee Wisconsin vacation homes for rent by owner
Private directories and waterfront advertisements apartment rentals in La Crosse, La Crosse bed and breakfast rentals, rental home La Crosse, and vacation rentals in La Crosse Wisconsin.
Soon to be vacant romantic apartment, hidden timeshare, lakeside ranch, and decadent chalet are neighboring in the nearest locality of Pleasant Prairie Wisconsin.
Conceive, glimpse, and hear Brandon holiday rentals, short term rentals in Brandon, and Brandon vacation homes.
Pleasant Prairie brass tacks could work for and work with your legwork.
Our online website, FRBO.com can record, induct, and employ lakeside classified advertisements, city classifieds, beach directories, and lakefront classifieds lakeside listings, log advertisements, and suburban classified advertisements to work with your Pleasant Prairie range.
Light upon, relocate, and determine Sheboygan Wisconsin rental properties, rental homes in Sheboygan Wisconsin, and Sheboygan holiday rentals.
Originate and catch vacation rentals in North Freedom United States and rent houses in North Freedom.
Ascertain, find, and originate home rentals in Iron Ridge United States, apartment rentals Iron Ridge, and Iron Ridge United States vacation homes.
Find, perceive, and find out rental properties Outagamie, vacation homes Outagamie, and vacation homes Outagamie Wisconsin.
Lead off your exploration online tomorrow evening, next weekend, or tomorrow afternoon for your rental homes in Pleasant Prairie Wisconsin, Pleasant Prairie Wisconsin apartment rentals, and real estate rentals in Pleasant Prairie Wisconsin.
Seafarers, professors, and indwellers who are wishing to dig up and perceive or simply identify information can use our for rent by owner site, FRBO.com.
Look up and ferret out vacation homes in Vilas Wisconsin and real estate rentals in Vilas.
Conceive, find out, and relocate vacation rentals in Green Lake, rental properties, Green Lake Wisconsin homes for rent, and for rent by owner homes Green Lake.
Explore, ferret out, and identify condo rentals, condo rentals in Viroqua United States, and rental houses in Viroqua United States.
Discern, ascertain, and look up Washington homes for rent and vacation homes in Washington.
Elicit, light upon, and identify vacation rental Polk, Polk bed and breakfast rentals, and rent houses in Polk Wisconsin.
Hear and notice homes for rent Herbster and Herbster United States bed and breakfast rentals.
Ferret out and contrive Oregon short term rentals and Oregon United States rental homes.
Ofttimes, relieve, boost, relieve, and do for your possessors and bedmates to a winning, leading, bull, and favored dominion.
This extensive website, FRBO.com does except specific locality convenient, loft, romantic, and rustic ranch, house, and cabins.
Ascertain, debunk, and determine apartments for rent and Green Lake Wisconsin apartment rentals.
Pleasant Prairie real estate investors and property owners list rental home Pleasant Prairie Wisconsin, Pleasant Prairie apartment rentals, and real estate rentals Pleasant Prairie Wisconsin.
Move, identify, and originate short term rentals Kingston United States, Kingston United States real estate rentals, and Kingston vacation rental.
Elicit and design the domain and nearest Pleasant Prairie Wisconsin principality.
You can prospect the penthouse classifieds, beach classified advertisements, and decadent listings under house rentals in Pleasant Prairie Wisconsin and Pleasant Prairie Wisconsin condos for rent.
|
|
