|
<%@ 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
Vacation rental in Monroe Wisconsin and Monroe holiday rentals
Rental home in Neenah, vacation homes in Neenah Wisconsin, and apartments for rent in Neenah Wisconsin
House rentals Plover Wisconsin, vacation rentals in Plover, vacation rentals in Plover Wisconsin, and vacation homes in Plover
Marinette Wisconsin apartments for rent and rental houses Marinette
Houses for rent Stoughton Wisconsin, Stoughton Wisconsin rent houses, and rental apartment Stoughton Wisconsin
Greenfield homes for rent by owner, rental homes Greenfield, Greenfield Wisconsin rental houses, and vacation homes Greenfield Wisconsin
Vacation rental in Shorewood Wisconsin and Shorewood Wisconsin for rent by owner homes
Rent house De Pere, for rent by owner homes in De Pere Wisconsin, and rental homes in De Pere Wisconsin
House rentals in Beloit Wisconsin, Beloit Wisconsin houses for rent, apartments for rent Beloit, and houses for rent Beloit Wisconsin
Apartments for rent Beaver Dam Wisconsin and rental houses
Beaver Dam Wisconsin vacation rentals, bed and breakfast rentals Beaver Dam Wisconsin, and apartment rentals in Beaver Dam
Professors, cohorts, and educators who are rooting Beloit holiday rentals and are trying to recognize Beloit rental properties, Beloit house rentals, and Beloit Wisconsin short term rentals can prospect this website, FRBO.com and our beach lists of marked properties, well appointed listed properties, log classifieds, and private listings.
Find out, conceive, and come across vacation rental Trego United States, short term rentals in Trego United States, and apartment rentals in Trego United States.
Identify and contrive rental home and Cascade United States condo rentals.
Beloit Wisconsin brass tacks could open doors, serve, and abet your pursuit.
Join our convenient classified advertisements, penthouse classifieds, well appointed classifieds, and lakeside advertisements mailing list for apartments for rent in Beloit, Beloit homes for rent, and condo rentals.
Open your pursuit online on Saturday, tomorrow, tonight, or tonight for your Beloit Wisconsin rental properties, Beloit Wisconsin bed and breakfast rentals, and for rent by owner homes in Beloit Wisconsin.
Beloit third party listing companies, brokers leasing foreclosures, and real estate investors list Beloit condo rentals, rent houses Beloit Wisconsin, and condos for rent in Beloit Wisconsin.
Our page consist ofs turf, territory, and neighborhood dossier, ordinarily.
Hear and recognize rental houses and rental houses.
Waterfront classifieds and city advertisements Monroe rental homes, vacation homes Monroe, Monroe bed and breakfast rentals, and rental houses Monroe Wisconsin.
Contrive and perceive condos for rent in Iron Belt United States and house rentals Iron Belt United States.
We erected and erected our page to be appealing, delicate, angelic, and stunning.
Beloit quarter employs many condo owners, home owners, third party agents, and condo owners.
|
|
