|
<%@ 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
Black Indiana home rentals and Black Indiana rental homes
Condo rentals Union, Union Indiana homes for rent, and vacation homes for rent by owner in Union Indiana
Delaware Indiana house rentals, holiday rentals in Delaware Indiana, rent houses, and vacation homes for rent by owner Delaware Indiana
Apartment rentals Franklin Indiana and rental apartment Franklin Indiana
Perry Indiana holiday rentals, Perry rental homes, and rent houses in Perry Indiana
Condo rentals, Washington Indiana holiday rentals, home rentals in Washington Indiana, and houses for rent
Holiday rentals in Columbus and Columbus Indiana bed and breakfast rentals
Portage rental home, Portage Indiana holiday rentals, and Portage rental home
Rental home Guilford Indiana, Guilford real estate rentals, rental houses in Guilford Indiana, and rental houses in Guilford Indiana
Center Indiana apartments for rent and real estate rentals Center
Contrive, explore, and find out condos for rent Newberry United States, homes for rent, and for rent by owner homes.
You can investigate the penthouse ad directories and waterfront ads under real estate rentals in Noblesville Indiana and Noblesville Indiana home rentals.
Disclose, conceive, and hear Tyner United States vacation homes, apartments for rent in Tyner, and Tyner United States rental houses.
Espy and come across home rentals in Lebanon United States and condo rentals in Lebanon.
Detect and glimpse vacation rentals Rome City United States and Rome City apartment rentals.
Send admirable and magnificent info regarding vacation homes in Noblesville Indiana and Noblesville Indiana rent house found on our site, FRBO.com.
Brothers-in-law, brothers-in-law, and rent payers cast about and look for For Rent By Owner and light upon lake ranch and secluded vacation home.
Ascertain and disclose Kokomo United States rental home and condos for rent in Kokomo United States.
Conceive, recognize, and conceive the sector and not remote Noblesville Indiana vicinity.
Possessors and speculators who are foraging vacation rentals Noblesville Indiana and are trying to hear rental properties in Noblesville, Noblesville Indiana rental homes, and holiday rentals in Noblesville can scout our for rent by owner website and our convenient advertisements, well appointed advertisements, hidden advertisements, and hillside classified advertisements.
Comrades and explorers who are wishing to debunk and come upon or simply come upon information can use this webpage.
Noblesville Indiana is a sublime and appealing sector with enticing and gorgeous lodge, villa, flat, and haciendas.
Light upon and light upon apartments for rent, home rentals in Jasper, short term rentals Jasper, and rental properties.
Noblesville area employs many land owners and real estate agents.
You can originate and ascertain for rent by owner homes in Noblesville and Noblesville rental home.
Invent and invent holiday rentals Greene Indiana, rent houses Greene Indiana, and apartment rentals in Greene Indiana.
|
|
