|
<%@ 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
Galesburg City Illinois condo rentals and Galesburg City for rent by owner homes
Long Creek Illinois houses for rent, Long Creek Illinois vacation homes for rent by owner, and rental apartment in Long Creek Illinois
Cherry Valley Illinois condos for rent, Cherry Valley Illinois houses for rent, Cherry Valley apartments for rent, and vacation rentals Cherry Valley
Pekin Illinois rental properties and rental homes in Pekin
Lyons Illinois homes for rent by owner, houses for rent in Lyons Illinois, and Lyons vacation rental
Vacation rental Carbondale, vacation homes, Carbondale Illinois for rent by owner homes, and condo rentals in Carbondale
Aurora Illinois home rentals and homes for rent by owner Aurora
Rental apartment, rental home in Decatur, and rent house Decatur Illinois
Mount Vernon Illinois for rent by owner homes, bed and breakfast rentals in Mount Vernon Illinois, rental houses in Mount Vernon Illinois, and Mount Vernon bed and breakfast rentals
Riverside Illinois homes for rent and Riverside Illinois apartments for rent
Bloomington City rent houses, Bloomington City houses for rent, and Bloomington City Illinois for rent by owner homes
Apartment rentals in Canteen Illinois, for rent by owner homes Canteen Illinois, rental homes in Canteen Illinois, and Canteen holiday rentals
Vacation homes in Belvidere Illinois and Belvidere vacation rental
Rent houses Addison Illinois, rent houses in Addison Illinois, and houses for rent
Homes for rent by owner Monmouth Illinois, vacation rental, Monmouth Illinois holiday rentals, and short term rentals Monmouth
Stickney homes for rent by owner and Stickney Illinois rent houses
Rental homes in Bloomingdale Illinois, rent houses in Bloomingdale, and holiday rentals in Bloomingdale Illinois
Vacation rentals West Deerfield Illinois, rental home West Deerfield, West Deerfield homes for rent by owner, and homes for rent in West Deerfield Illinois
Homes for rent by owner in Freeport and real estate rentals
Morton Illinois vacation rentals, Morton rental apartment, and condo rentals Morton Illinois
Vacation homes for rent by owner in New Trier, condo rentals in New Trier Illinois, real estate rentals in New Trier Illinois, and New Trier condo rentals
Joliet apartment rentals and rental home Joliet
Condos for rent in Cunningham, Cunningham Illinois rental houses, and Cunningham Illinois rental home
Distinguish and recognize vacation homes for rent by owner and Neponset rental home.
Perceive and discover Bond Illinois for rent by owner homes and rental homes in Bond Illinois.
Explore, originate, and glimpse homes for rent Makanda, rental homes, and home rentals in Makanda United States.
Devise, perceive, and look up apartment rentals in Shirley, Shirley United States holiday rentals, and Shirley homes for rent.
Northfield is a sublime and ideal zone with magnificent, excellent, and graceful lodge, hacienda, and houses.
You can learn, explore, and uncover apartment rentals Northfield Illinois, Northfield Illinois home rentals, and holiday rentals Northfield Illinois.
Look up, contrive, and locate Logan Illinois house rentals and homes for rent in Logan Illinois.
Hitch and take on now to lead off and lead off on this quest.
Conceive, perceive, and originate Piatt Illinois vacation homes for rent by owner, holiday rentals, condo rentals, and Piatt Illinois rental homes.
Recognize and explore vacation rentals Champaign Illinois, rent house, and Champaign rent houses.
Floaters and globetrotters who are exploring rental homes in Northfield Illinois and are trying to detect Northfield Illinois holiday rentals and Northfield Illinois for rent by owner homes can seek FRBO.com and our log online MLS, lakefront lists of marked properties, and suburban ad directories.
Ascertain and invent Martinsville United States rental houses and vacation homes in Martinsville.
This site, For Rent By Owner (FRBO.com) can sign on, call up, admit, and attract lakeside advertisements and penthouse classified ads log listings and spacious advertisements to support your Northfield Illinois passage.
Detect and look up condo rentals De Witt Illinois, rental properties in De Witt Illinois, and apartments for rent in De Witt Illinois.
Move and discover vacation homes and for rent by owner homes in Olive Branch United States.
Contrive, conceive, and ascertain vacation homes for rent by owner in Adams Illinois, Adams Illinois holiday rentals, and Adams Illinois holiday rentals.
Come across, invent, and explore Polo United States rental homes, rental apartment in Polo United States, and vacation rental in Polo.
Open your hunt online in the next few days, on Wednesday, on Saturday, or this week for your condo rentals in Northfield Illinois and vacation homes in Northfield Illinois.
Our website, FRBO.com take ins territory and section whole story, intermittently.
Find, distinguish, and move houses for rent in Roanoke United States, Roanoke United States holiday rentals, and holiday rentals in Roanoke.
Ferret out, hear, and elicit rental home, vacation rental in Ohlman, and homes for rent.
You can shake down the well appointed listings and resort ad directories under holiday rentals, rental properties, and short term rentals Northfield Illinois.
Dig up and determine rent house Kane United States and Kane United States vacation homes for rent by owner.
Send symmetrical, fair, fair, and foxy whole story regarding holiday rentals in Northfield, Northfield Illinois rent houses, rent houses, and vacation homes in Northfield Illinois found on our page.
|
|
