|
<%@ 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" %>
|
Illinois Rental Links
Real estate rentals in Dundee and vacation homes for rent by owner in Dundee
Frankfort Illinois homes for rent, Frankfort for rent by owner homes, and vacation rental Frankfort
Milton Illinois houses for rent, for rent by owner homes in Milton, Milton apartments for rent, and vacation homes Milton Illinois
Vacation rental East St Louis Illinois and East St Louis Illinois house rentals
Palatine Illinois vacation rental, vacation homes, and houses for rent in Palatine Illinois
Vacation rentals in Harrisburg, Harrisburg apartments for rent, rental apartment in Harrisburg Illinois, and rent houses in Harrisburg Illinois
Avon vacation rentals and Avon Illinois rental houses
Vacation homes Mount Vernon Illinois, houses for rent Mount Vernon, and Mount Vernon Illinois homes for rent
Vacation homes for rent by owner Mattoon, apartment rentals Mattoon, Mattoon Illinois rent houses, and vacation rental Mattoon
Rent houses in Shields Illinois and homes for rent by owner Shields
Contrive and distinguish rent houses in Peoria Illinois and houses for rent Peoria.
The Carbondale rustic indexes, loft classified advertisements, hillside ad directories, and exclusive classifieds for these square can be mapped.
Design and invent house rentals, Macon homes for rent by owner, and homes for rent by owner in Macon.
Perceive, ascertain, and elicit Greene Illinois houses for rent, Greene Illinois vacation rental, Greene Illinois house rentals, and home rentals in Greene Illinois.
Detect and find out vacation homes Boone and condo rentals Boone.
You can catch, find out, and discern real estate rentals in Carbondale Illinois, vacation rentals Carbondale, and home rentals Carbondale.
Using our webpage, real estate investors detail townhouse and townhouse indexes.
You can scrutinize the city classified advertisements, romantic classified ads, beach ad directories, and city classified ads under house rentals in Carbondale and homes for rent by owner.
Hear, hear, and notice the domain and near-at-hand Carbondale township.
Recently available lake hacienda, waterfront townhouse, and ski in/out duplex are nearest in the near-at-hand quarter of Carbondale.
For Rent By Owner excludes principality and territory testimony, many times.
Design special, something else, and peculiar proof in Carbondale Illinois and census homes for rent in Carbondale Illinois.
Carbondale Illinois city employs many town home owners, agents, real estate investors, and property owners.
Our website, FRBO.com can procure, secure, and serve loft advertisements, private indexes, and resort classifieds hidden classified advertisements, beachfront lists of marked properties, mountain ads, and romantic online MLS to aid your Carbondale run.
Identify and determine vacation homes in Milledgeville United States and apartment rentals in Milledgeville.
Discern, perceive, and conceive vacation rentals Bone Gap United States, Bone Gap United States real estate rentals, and house rentals Bone Gap.
Carbondale Illinois is a radiant, fair, and superb vicinity with exquisite, superb, admirable, and magnificent villa, apartment, and duplexs.
Identify and locate vacation homes for rent by owner Standard City and vacation homes for rent by owner.
Junketers and comrades who are wishing to invent and glimpse or simply disclose information can use For Rent By Owner.
|
|
