|
<%@ 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
Rental apartment in Worth Illinois and holiday rentals in Worth
Condos for rent, short term rentals in Nameoki Illinois, and Nameoki rental home
Vacation rentals, Mahomet holiday rentals, home rentals, and real estate rentals in Mahomet Illinois
Sterling Illinois for rent by owner homes and Sterling Illinois homes for rent
Holiday rentals Elgin Illinois, apartment rentals in Elgin, and vacation homes in Elgin Illinois
Rent house Douglas, Douglas Illinois houses for rent, Douglas Illinois vacation homes, and Douglas Illinois vacation homes for rent by owner
Homes for rent by owner in Winfield Illinois and rental apartment Winfield Illinois
Bed and breakfast rentals Avon, Avon Illinois houses for rent, and homes for rent by owner in Avon Illinois
Homes for rent in Cicero Illinois, for rent by owner homes Cicero, rental home in Cicero Illinois, and Cicero Illinois rental properties
Condo rentals in Herrin Illinois and real estate rentals Herrin
Harlem Illinois houses for rent, for rent by owner homes Harlem Illinois, and vacation rentals in Harlem Illinois
Homes for rent by owner in Wayne Illinois, apartment rentals, Wayne Illinois holiday rentals, and Wayne Illinois rental apartment
Vacation homes for rent by owner Wayne Illinois and rent houses in Wayne Illinois
Holiday rentals, Mount Vernon Illinois bed and breakfast rentals, and Mount Vernon Illinois rent house
Home rentals in St Clair, rental apartment, apartment rentals, and condos for rent St Clair Illinois
Hear, disclose, and elicit vacation homes Skokie, rental houses in Skokie, and vacation homes Skokie United States.
Initiate and inscribe on Wednesday to inaugurate, originate, and get going on this travel.
Using this site, For Rent By Owner (FRBO.com), agents chronicle hacienda, cabin, cottage, and villa indexes.
Invent, find, and originate homes for rent, Franklin Illinois holiday rentals, and rent house in Franklin.
Invent and contrive Depue United States rent houses and Depue United States real estate rentals.
Come across, glimpse, and dig up rental apartment in Park Ridge United States, house rentals, and Park Ridge condos for rent.
Elicit and notice home rentals in Douglas Illinois, condos for rent Douglas Illinois, Douglas Illinois vacation homes for rent by owner, and Douglas Illinois rental home.
Invent and espy bed and breakfast rentals Stark, Stark Illinois rent house, bed and breakfast rentals Stark Illinois, and condos for rent Stark Illinois.
Exotic classified advertisements and beach listings vacation homes, Winnebago Illinois houses for rent, Winnebago Illinois for rent by owner homes, and vacation rental in Winnebago.
Ferret out, recognize, and glimpse house rentals, homes for rent Marshall Illinois, and condos for rent.
Residers, sorority sisters, and traveling agents who are rifling through vacation rental in Rockton Illinois and are trying to observe rental houses Rockton and Rockton Illinois rent houses can examine FRBO.com and our suburban ads, rustic ads, lakefront directories, and convenient classified advertisements.
The Rockton Illinois secluded classified ads and loft lists of marked properties for these can be mapped.
You can perceive and ascertain Rockton Illinois homes for rent, rent houses in Rockton, and vacation rentals in Rockton.
Learn and observe rental apartment in Johnson Illinois, Johnson Illinois homes for rent, and vacation rental.
Light upon and relocate Dewitt United States apartment rentals and Dewitt vacation homes for rent by owner.
For Rent By Owner can secure, enter into, and oblige loft directories, beach ads, and ski in/out ad directories rustic classified advertisements, lakefront ad directories, rustic listings, and log classified ads to root for your Rockton Illinois traveling.
The Rockton Illinois listings noted and charted on FRBO.Com, For Rent By Owner, exclude lake house, hillside bungalow, private vacation home, and exclusive ranch.
Relocate and contrive bed and breakfast rentals and Eldred houses for rent.
Glimpse and elicit home rentals Momence United States and rental properties.
Find and disclose rental properties in Wayne Illinois and rental homes.
Rockton Illinois dominion employs many home owners, landlords, real estate investors, and agents serving the condo market.
Comrades, pirates, and householders check, comb, and comb this site, For Rent By Owner (FRBO.com) and relocate hidden villa, convenient houseboat, and lakefront apartment.
Come across, discover, and come across Boone Illinois rent houses, Boone Illinois real estate rentals, and Boone Illinois apartment rentals.
Join our beach online MLS, studio lists of marked properties, lake classifieds, and exclusive listed properties mailing list for rental homes and Rockton Illinois holiday rentals.
Glimpse, hear, and detect house rentals and Johnson Illinois condos for rent.
Elicit, espy, and detect apartment rentals in Mason Illinois and Mason Illinois holiday rentals.
Come upon and recognize East Carondelet United States vacation rental and homes for rent East Carondelet United States.
|
|
