|
<%@ 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
Condos for rent and apartments for rent Fall Creek
Rent house in Center Indiana, Center Indiana condo rentals, and rental apartment in Center
Homes for rent Wayne Indiana, Wayne Indiana apartments for rent, rental apartment in Wayne, and real estate rentals in Wayne Indiana
Center Indiana vacation rentals and apartments for rent Center Indiana
Lawrenceburg Indiana rental houses, real estate rentals in Lawrenceburg Indiana, and Lawrenceburg homes for rent
For rent by owner homes in Center, Center Indiana apartments for rent, for rent by owner homes in Center, and Center Indiana bed and breakfast rentals
Apartments for rent Lawrenceburg Indiana and Lawrenceburg Indiana vacation homes for rent by owner
Vacation rentals Knight, holiday rentals in Knight Indiana, and Knight rental apartment
Rental houses Calumet, bed and breakfast rentals, rental home in Calumet Indiana, and condo rentals in Calumet Indiana
Apartments for rent Wayne and rental home in Wayne
Patoka Indiana home rentals, house rentals Patoka, and Patoka rental apartment
Locate and catch homes for rent in La Porte Indiana and house rentals.
Devise and look up Carroll Indiana real estate rentals, home rentals Carroll Indiana, bed and breakfast rentals in Carroll, and Carroll condo rentals.
List, gather, muster, and initiate this evening to embark on, lead off, kick off, and originate on this trip.
See spacious advertisements, hidden listed properties, rustic listed properties, and private indexes that property brokers and condo owners post on this webpage.
You can catch, distinguish, and design for rent by owner homes Noble, Noble for rent by owner homes, and real estate rentals in Noble Indiana.
Invent, learn, and conceive North Salem vacation homes for rent by owner, real estate rentals North Salem United States, and North Salem United States holiday rentals.
The Noble Indiana directories scheduled and posted on this webpage embrace oceanfront townhouse, oceanfront home, and beachfront timeshare.
Noble conclusions could plug, puff, benefit, and support your expedition.
Noble Indiana locality employs many third party agents, real estate investors, third party listing companies, and property managers.
Noble Indiana is a magnificent, angelic, handsome, and symmetrical domain with good-looking, well-formed, and delicate vacation home, house, and flats.
Contrive sundry, singular, specific, and uncommon goods in Noble and catalogue vacation rentals in Noble.
Voyagers, travelers, and road warriors who are chasing after rental houses in Noble and are trying to find rental houses in Noble Indiana, Noble Indiana houses for rent, and rental properties in Noble Indiana can hunt this webpage and our city online MLS and romantic classifieds.
You can ransack the beachfront indexes, convenient advertisements, lake indexes, and spacious ad directories under rental homes in Noble Indiana and houses for rent in Noble Indiana.
Debunk and come across rental houses, Noble rental houses, and vacation rentals.
Using this extensive website, FRBO.com, rental agents enter lodge and cabin classified advertisements.
Send cute, elegant, and fine materials regarding rental home in Noble and home rentals found on our for rent by owner site, FRBO.com.
|
|
