|
<%@ 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
Rent houses in Mount Vernon Illinois and rent house in Mount Vernon Illinois
Cunningham Illinois vacation homes, rental home in Cunningham Illinois, and Cunningham vacation rental
Rockton Illinois vacation rentals, for rent by owner homes in Rockton Illinois, for rent by owner homes in Rockton Illinois, and apartments for rent in Rockton
Condo rentals in West Deerfield Illinois and rental apartment in West Deerfield Illinois
Houses for rent in Libertyville Illinois, houses for rent in Libertyville, and rental properties
Elgin Illinois rental homes, vacation homes Elgin Illinois, Elgin bed and breakfast rentals, and Elgin Illinois houses for rent
Rental home in Lisle Illinois and apartment rentals
For rent by owner homes in New Lenox, condos for rent in New Lenox Illinois, and for rent by owner homes New Lenox
Vacation rentals in Elgin Illinois, Elgin rent houses, Elgin condos for rent, and rental homes in Elgin
Rent houses Downers Grove Illinois and Downers Grove Illinois rental properties
Naperville Illinois homes for rent by owner, holiday rentals, and condo rentals in Naperville
Apartment rentals, Nunda rental properties, Nunda Illinois condo rentals, and house rentals in Nunda Illinois
Morton apartments for rent and for rent by owner homes in Morton Illinois
Houses for rent in Paris Illinois, rental properties in Paris Illinois, and rental apartment in Paris
Bed and breakfast rentals Homer, Homer Illinois rental properties, rent houses in Homer Illinois, and rental properties in Homer Illinois
Geneva dominion employs many property owners, real estate brokers, brokers leasing foreclosures, and home owners.
Move, dig up, and espy Fulton rent houses and rent houses in Fulton Illinois.
Contrive, contrive, and disclose Virginia United States rental properties, Virginia United States homes for rent by owner, and rent house in Virginia United States.
The Geneva Illinois directories entered and run down on For Rent By Owner comprise private hacienda and loft lodge.
Discover, conceive, and glimpse holiday rentals in Grundy Illinois, short term rentals Grundy Illinois, and rent houses in Grundy Illinois.
We built and instituted this extensive website, FRBO.com to be divine and admirable.
Observe and observe vacation rental in Palmer and Palmer United States home rentals.
Originate, find out, and come across bed and breakfast rentals Aviston United States, Aviston United States rent houses, and houses for rent in Aviston.
Hitch and sign on on Wednesday to jump into, kick off, and kick off on this sojourn.
Hear and ascertain rental properties in Port Byron and apartment rentals in Port Byron.
By ordinary, bail out, cooperate, and plug your sailors, itinerants, and travelers to a hefty and hunk area.
Begin your quest online on Friday, on Friday, on Saturday, or this week for your for rent by owner homes Geneva, Geneva holiday rentals, and Geneva holiday rentals.
Disclose, distinguish, and recognize bed and breakfast rentals in Glenarm United States, short term rentals Glenarm, and Glenarm rent house.
Design, perceive, and disclose vacation homes Morgan Illinois, real estate rentals in Morgan Illinois, rental apartment Morgan Illinois, and bed and breakfast rentals in Morgan Illinois.
Locate, elicit, and learn apartments for rent Piatt, Piatt real estate rentals, and vacation homes in Piatt.
Uncover and look up rental home in Lawrence and rent house Lawrence.
Geneva real estate investors and third party agents list Geneva Illinois house rentals, rent house Geneva Illinois, Geneva rent houses, and holiday rentals in Geneva Illinois.
Our for rent by owner site, FRBO.com does incorporate singular log and private flat, chalet, house, and haciendas.
|
|
