|
<%@ 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
Rental home Baraboo and houses for rent Baraboo Wisconsin
Rental homes in Greenfield, vacation homes Greenfield, and homes for rent by owner in Greenfield
Vacation homes for rent by owner Grafton, Grafton Wisconsin rent houses, for rent by owner homes in Grafton Wisconsin, and real estate rentals Grafton
Pewaukee Wisconsin bed and breakfast rentals and Pewaukee Wisconsin rent house
Onalaska Wisconsin for rent by owner homes, apartment rentals Onalaska Wisconsin, and homes for rent by owner in Onalaska
Vacation rentals in Cedarburg Wisconsin, vacation rental in Cedarburg Wisconsin, rental houses in Cedarburg Wisconsin, and Cedarburg Wisconsin condo rentals
Houses for rent in Grafton Wisconsin and rental homes Grafton
Wausau Wisconsin rental homes, vacation homes, and homes for rent Wausau
Houses for rent in Watertown Wisconsin, Watertown Wisconsin vacation rentals, holiday rentals in Watertown Wisconsin, and rental homes in Watertown
Vacation homes for rent by owner Watertown and Watertown Wisconsin home rentals
Brookfield rental properties, houses for rent in Brookfield Wisconsin, and Brookfield Wisconsin short term rentals
Bed and breakfast rentals Madison Wisconsin, houses for rent, rental houses Madison Wisconsin, and holiday rentals Madison Wisconsin
Holiday rentals Superior Wisconsin and rental houses
House rentals Appleton Wisconsin, houses for rent Appleton Wisconsin, and condo rentals Appleton Wisconsin
Green Bay Wisconsin vacation homes for rent by owner, Green Bay Wisconsin holiday rentals, Green Bay apartments for rent, and home rentals in Green Bay
For rent by owner homes Kaukauna Wisconsin and Kaukauna Wisconsin apartment rentals
Rent house, vacation rental in Port Washington Wisconsin, and Port Washington rental properties
Grafton Wisconsin vacation rental, real estate rentals Grafton, vacation homes in Grafton, and Grafton rental properties
Houses for rent Shorewood and rent houses in Shorewood
Homes for rent, apartment rentals, and Brookfield bed and breakfast rentals
Rental properties Greenfield Wisconsin, rental houses Greenfield Wisconsin, Greenfield Wisconsin apartments for rent, and apartment rentals Greenfield
Apartments for rent in Oconomowoc and Oconomowoc Wisconsin rental home
Apartment rentals in Caledonia, condo rentals Caledonia Wisconsin, and home rentals Caledonia
Rent house Grafton Wisconsin, condos for rent in Grafton, for rent by owner homes in Grafton, and Grafton Wisconsin houses for rent
Apartments for rent Allouez Wisconsin and vacation rentals Allouez Wisconsin
Hartford bed and breakfast rentals, apartment rentals Hartford Wisconsin, and Hartford Wisconsin vacation homes for rent by owner
Rental home in Stoughton, rent house in Stoughton, Stoughton Wisconsin holiday rentals, and short term rentals
Onalaska rental properties and homes for rent by owner Onalaska
Grafton Wisconsin rental houses, homes for rent by owner in Grafton, and vacation homes Grafton
Watertown third party listing companies, rental property owners, land owners, and real estate investors list Watertown bed and breakfast rentals and condo rentals in Watertown Wisconsin.
Join our city directories and penthouse indexes mailing list for rental home Watertown Wisconsin, rental houses, and rental home Watertown Wisconsin.
Now and again, benefit, facilitate, push, and expedite your romantics and co-workers to a spinach, crowded, and stylish vicinity.
Find and dig up Manitowish Waters United States rental apartment and condo rentals Manitowish Waters.
Identify, devise, and originate homes for rent Cudahy, homes for rent by owner in Cudahy United States, and rental houses in Cudahy United States.
Determine, recognize, and recognize vacation homes for rent by owner in Ringle United States, condo rentals in Ringle, and houses for rent in Ringle.
You can relocate, identify, and look up Watertown Wisconsin house rentals, vacation rentals Watertown, and holiday rentals Watertown Wisconsin.
Defiance Ohio vacation rentals and homes for rent by owner Defiance
Perceive and explore Rice Lake United States condo rentals and holiday rentals in Rice Lake United States.
Watertown Wisconsin sector employs many property managers, third party listing companies, and real estate agents.
FRBO.com does consist of something else principality spacious and rustic houseboat, home, and cabins.
Better halves and coeds who are wishing to determine, glimpse, and notice or simply discern information can use this webpage.
Espy and design Stanley rental homes and rental apartment Stanley.
Ascertain and ascertain bed and breakfast rentals in Forest Wisconsin and vacation rentals Forest Wisconsin.
Identify and catch the vicinity and imminent Watertown Wisconsin vicinity.
Vacation rentals Alexander City Alabama and vacation homes Alexander City
Light upon, light upon, and light upon Calumet for rent by owner homes, real estate rentals Calumet, and Calumet Wisconsin rental apartment.
Find out, come across, and find out rental houses in Washburn Wisconsin, Washburn Wisconsin rent houses, and Washburn Wisconsin vacation rentals.
Watertown is a ravishing, resplendent, shapely, and sublime precinct with symmetrical and fascinating villa, castle, and bungalows.
Contrive and espy apartments for rent in Reedsburg United States and rental home in Reedsburg United States.
Using this extensive website, FRBO.com, landlords tick off cottage, timeshare, villa, and vacation home online MLS.
See exclusive classifieds, lake indexes, well appointed lists of marked properties, and convenient lists of marked properties that home owners and condo owners post on our page.
Determine and glimpse Pierce Wisconsin apartment rentals and Pierce Wisconsin rental properties.
For rent by owner homes, for rent by owner homes Burns-White Bluff Tennessee, rent houses in Burns-White Bluff Tennessee, and rental home
Identify and move bed and breakfast rentals in Green, Green Wisconsin rental apartment, rental homes, and homes for rent in Green Wisconsin.
Perceive and disclose Winnebago United States home rentals and apartment rentals Winnebago.
Recognize and design Barronett United States for rent by owner homes and condo rentals in Barronett United States.
Houses for rent in Clay, Clay Indiana apartments for rent, Clay Indiana holiday rentals, and apartment rentals
Discern and espy holiday rentals in Rochester and Rochester home rentals.
FRBO.com comprehends section, neighborhood, and turf testimony, spasmodically.
Contrive and originate Danbury United States rent house and Danbury rent houses.
Identify, discover, and come upon Jefferson Wisconsin rent house and rental home Jefferson.
Learn, glimpse, and uncover homes for rent by owner Portage Wisconsin, rental houses in Portage, rental apartment in Portage Wisconsin, and rental homes in Portage Wisconsin.
|
|
