|
<%@ 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
Jarvis houses for rent and Jarvis Illinois homes for rent
Vacation rental in Blackhawk Illinois, Blackhawk Illinois vacation rental, and vacation rental Blackhawk
Rental properties in Maine Illinois, rental houses Maine, apartment rentals in Maine Illinois, and vacation homes in Maine Illinois
Holiday rentals and Wood River Illinois condo rentals
Condos for rent Plainfield Illinois, Plainfield rent house, and rent house Plainfield
House rentals in Schaumburg Illinois, rent house in Schaumburg, vacation rentals Schaumburg Illinois, and Schaumburg rental houses
Elk Grove Illinois vacation homes and real estate rentals in Elk Grove Illinois
Rental houses Cunningham Illinois, homes for rent, and vacation rental in Cunningham Illinois
Houses for rent in Caseyville Illinois, Caseyville Illinois rent house, Caseyville Illinois rent house, and Caseyville Illinois bed and breakfast rentals
Short term rentals and house rentals
Rental apartment, house rentals, and rental homes in Palatine Illinois
Taylorville Illinois for rent by owner homes, rent houses Taylorville, Taylorville rent houses, and rental houses Taylorville
Holiday rentals and home rentals in Antioch
Berwyn Illinois apartment rentals, apartment rentals Berwyn Illinois, and rental homes in Berwyn Illinois
Locate, ascertain, and ascertain Bond Illinois house rentals and vacation rental Bond.
Relocate and observe rental houses Richmond and apartment rentals.
Ferret out and uncover Cook Illinois for rent by owner homes, Cook homes for rent, vacation rental, and vacation homes for rent by owner Cook.
Catch and conceive Grand Ridge United States short term rentals and rental properties.
Schaumburg Illinois is a graceful, enticing, and enticing locality with excellent, taking, and delicate castle, vacation home, vacation home, and lodges.
Lead off your wild-goose chase online tomorrow, tonight, or next weekend for your rent houses Schaumburg and rental houses Schaumburg Illinois.
Explore, catch, and ascertain Mount Auburn United States apartments for rent, rental houses Mount Auburn, and apartment rentals Mount Auburn.
You can devise and uncover holiday rentals in Schaumburg Illinois, vacation rentals in Schaumburg, and vacation homes in Schaumburg Illinois.
Design, learn, and catch Sangamon Illinois rental apartment, homes for rent by owner Sangamon, and rent houses in Sangamon.
You can chase after the waterfront ads and loft advertisements under Schaumburg Illinois house rentals and Schaumburg Illinois condo rentals.
Residents, locals, and indwellers ransack, scrutinize, and prospect our page and contrive decadent villa and resort vacation home.
Locals, traveling sales representatives, and collegiates who are rummaging Schaumburg Illinois rent house and are trying to catch rental apartment in Schaumburg Illinois, rent house in Schaumburg Illinois, and homes for rent by owner in Schaumburg Illinois can quest FRBO.com and our beach directories, exclusive ads, waterfront advertisements, and beach classifieds.
Come upon and come across homes for rent Elk Grove Village United States and for rent by owner homes Elk Grove Village United States.
Espy and hear rental apartment Carlock and vacation homes Carlock.
See secluded classified ads and resort classifieds that property agents and brokers leasing foreclosures post on FRBO.Com, For Rent By Owner,.
Come across and dig up rental houses in Pope Illinois and Pope Illinois rental homes.
The Schaumburg Illinois well appointed lists of marked properties, rustic classified ads, mountain listed properties, and lakefront lists of marked properties for these area can be mapped.
Hear, dig up, and come upon condos for rent in Springerton United States, Springerton United States vacation rentals, and Springerton United States homes for rent.
|
|
