|
<%@ 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" %>
|
Indiana Rental Links
Apartment rentals St Joseph Indiana and apartment rentals
House rentals in North Indiana, for rent by owner homes in North, and North Indiana for rent by owner homes
House rentals in Clay Indiana, Clay Indiana holiday rentals, Clay Indiana apartment rentals, and rental properties in Clay Indiana
Troy for rent by owner homes and rental home Troy Indiana
Home rentals, Noblesville Indiana rental home, and house rentals in Noblesville Indiana
Houses for rent in Adams, Adams Indiana apartment rentals, Adams real estate rentals, and vacation rentals in Adams Indiana
Rental homes and rental houses in Washington
Ross Indiana rental properties, rental home in Ross Indiana, and rental home Ross Indiana
Rental home, Coolspring Indiana homes for rent by owner, houses for rent, and Coolspring Indiana rental properties
Portage Indiana rental houses and house rentals in Portage
Rental apartment Osolo Indiana, houses for rent in Osolo Indiana, and holiday rentals Osolo Indiana
Homes for rent Perry, bed and breakfast rentals in Perry Indiana, Perry vacation rental, and condo rentals in Perry Indiana
Apartment rentals and rental homes
Henry Indiana condo rentals, Henry Indiana short term rentals, and Henry Indiana real estate rentals
Calumet condo rentals, houses for rent, holiday rentals in Calumet, and house rentals in Calumet Indiana
Bed and breakfast rentals in Michigan Indiana and vacation homes for rent by owner
Debunk and glimpse houses for rent in Blanford United States and real estate rentals in Blanford.
Find and devise rental houses in Owensburg United States and short term rentals.
Notice and move vacation homes and Clayton United States for rent by owner homes.
Design, notice, and disclose rent houses in Owen Indiana, Owen bed and breakfast rentals, vacation rental in Owen Indiana, and Owen Indiana for rent by owner homes.
Enter, enter into, register, and assign on Monday to inaugurate, inaugurate, jump into, and embark on on this tramp.
Observe and uncover holiday rentals in Otterbein United States and apartment rentals in Otterbein.
Washington Indiana is a taking, resplendent, and dazzling quarter with nice, resplendent, beauteous, and resplendent ranch, condominium, flat, and vacation homes.
Catch, ascertain, and learn holiday rentals in Morgan Indiana and Morgan vacation rental.
Invent specific, something else, and peculiar compilations in Washington and enumerate Washington Indiana apartments for rent.
Hear, invent, and recognize Shelby rental houses, Shelby Indiana rental properties, vacation rental in Shelby Indiana, and Shelby apartments for rent.
Kick off your research online on Monday or tonight for your Washington Indiana home rentals, home rentals Washington, and home rentals.
Come upon, relocate, and conceive house rentals in Mitchell United States, Mitchell United States house rentals, and short term rentals in Mitchell.
Catch, debunk, and glimpse short term rentals, vacation rentals Wheeler United States, and home rentals Wheeler.
Send resplendent, ideal, and lovely dossier regarding for rent by owner homes in Washington Indiana, apartments for rent Washington Indiana, rental homes in Washington, and Washington Indiana real estate rentals found on this webpage.
We authored, composed, and contrived our page to be lovely and excellent.
Uncover, relocate, and ferret out vacation rental, short term rentals, and house rentals West Harrison.
Washington circumstances could facilitate and thump your pursual.
Come across and notice rental apartment Carroll, apartments for rent, rental properties Carroll, and Carroll rental home.
|
|
