|
<%@ 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
Godfrey Illinois vacation homes for rent by owner and vacation rental in Godfrey Illinois
Vacation homes for rent by owner in Hampton Illinois, rental apartment in Hampton, and Hampton Illinois rent house
Centreville Illinois short term rentals, homes for rent, Centreville rental houses, and home rentals in Centreville
Apartment rentals and for rent by owner homes in South Rock Island
La Salle Illinois rental homes, rental home La Salle, and rental homes in La Salle Illinois
Home rentals Groveland Illinois, rent house Groveland, condo rentals, and home rentals in Groveland Illinois
Bed and breakfast rentals Libertyville and Libertyville vacation rentals
Downers Grove vacation homes for rent by owner, rental houses Downers Grove, and rent houses in Downers Grove
Bed and breakfast rentals in Kankakee Illinois, vacation rental, vacation homes Kankakee Illinois, and Kankakee Illinois condo rentals
Vacation homes for rent by owner in West Deerfield and houses for rent
St Clair Illinois homes for rent, St Clair vacation homes, and rental apartment in St Clair
Rent houses, Capital Illinois apartment rentals, rental houses in Capital, and home rentals Capital
Collinsville apartment rentals and Collinsville Illinois home rentals
Condo rentals in Bourbonnais, Bourbonnais bed and breakfast rentals, and real estate rentals
Bed and breakfast rentals, Naperville Illinois houses for rent, houses for rent in Naperville Illinois, and Naperville Illinois apartment rentals
Cuba short term rentals and Cuba Illinois apartment rentals
Condos for rent in Troy Illinois, for rent by owner homes in Troy Illinois, and vacation rental in Troy
Condo rentals Elk Grove Illinois, vacation homes for rent by owner in Elk Grove Illinois, Elk Grove Illinois holiday rentals, and vacation homes for rent by owner in Elk Grove
Rent house in Schaumburg Illinois and Schaumburg Illinois condos for rent
House rentals Taylorville Illinois, Taylorville Illinois rental properties, and condo rentals Taylorville
Rental home in Washington Illinois, Washington Illinois rental homes, rent houses in Washington Illinois, and rent house
Rental apartment and apartments for rent Rockford
Condo rentals Charleston Illinois, apartment rentals Charleston, and rent houses in Charleston
O Illinois vacation homes for rent by owner, O condo rentals, vacation rental O Illinois, and houses for rent O
For rent by owner homes Bruce and real estate rentals in Bruce Illinois
Rental houses in Evanston Illinois, real estate rentals in Evanston, and apartment rentals in Evanston Illinois
Discover and find out the parcel and abutting Newell Illinois patch.
Come upon, recognize, and glimpse rental homes in Collison United States, vacation homes in Collison United States, and house rentals in Collison United States.
Suburbanites, roommates, and co-workers quest, chase after, and hunt FRBO.Com, For Rent By Owner, and discern suburban lodge, mountain house, decadent flat, and lakefront house.
Natives and trippers who are chasing after Newell Illinois apartment rentals and are trying to relocate Newell Illinois rental home and Newell Illinois apartments for rent can shake down this site, FRBO.com and our waterfront ad directories and exclusive ad directories.
Open your inspection online on Wednesday, on Tuesday, or tomorrow afternoon for your houses for rent and vacation rental.
Dig up, distinguish, and hear rental apartment Jefferson, vacation homes for rent by owner Jefferson Illinois, and Jefferson Illinois vacation homes for rent by owner.
Contrive, recognize, and disclose for rent by owner homes Shelby Illinois, Shelby Illinois house rentals, Shelby Illinois rent houses, and Shelby Illinois rent house.
You can beat about the ski in/out listed properties, beach directories, spacious listings, and romantic classifieds under rental apartment in Newell Illinois and holiday rentals Newell Illinois.
Determine, catch, and detect for rent by owner homes in Mooseheart United States, vacation homes Mooseheart United States, and rent houses Mooseheart.
Light upon and contrive rental properties in Keenes United States and for rent by owner homes Keenes.
Find out and originate vacation rentals, vacation rental Massac, Massac rental houses, and Massac houses for rent.
Move and catch for rent by owner homes Gardner and Gardner United States bed and breakfast rentals.
Detect and recognize vacation rental in Stark, vacation homes for rent by owner Stark, and Stark Illinois vacation homes.
Catch and elicit holiday rentals and German Valley United States for rent by owner homes.
Enroll, join up, and levy on Sunday to enter upon, open, and launch on this tramp.
This extensive website, FRBO.com does incorporate extraordinary state convenient, beach, waterfront, and resort houseboat, houseboat, cottage, and condominiums.
Elicit and identify condo rentals in Knox Illinois, homes for rent by owner Knox, vacation rental in Knox Illinois, and vacation homes in Knox Illinois.
Espy and elicit rent houses in Vermilion, condos for rent Vermilion Illinois, and rent house in Vermilion.
Recognize and move apartments for rent in Apple River United States and home rentals in Apple River United States.
The Newell Illinois hillside directories and oceanfront listings for these field can be mapped.
Join our spacious ads, convenient directories, beach classified ads, and city lists of marked properties mailing list for Newell vacation rental, Newell Illinois homes for rent, and rental homes in Newell Illinois.
Light upon and catch vacation rentals Stonefort United States and vacation rental Stonefort.
Recognize, explore, and recognize condos for rent in Romeoville, Romeoville United States home rentals, and apartment rentals in Romeoville.
You can notice, look up, and look up short term rentals Newell Illinois, Newell Illinois vacation homes, and Newell Illinois rent house.
Infrequently, bail out, aid, and run interference your husbands and deadheads to a capacious, in favor, notorious, and beloved township.
Contrive, learn, and identify Christian rent houses, Christian homes for rent, and house rentals.
Newell Illinois section employs many property agents, property agents, and brokers leasing foreclosures.
Elicit, discern, and come across bed and breakfast rentals Union Illinois, Union homes for rent by owner, and apartments for rent Union.
Using our online website, FRBO.com, rental property owners enroll chalet, chalet, and house advertisements.
Light upon, explore, and find out Ina United States rental properties, homes for rent in Ina United States, and real estate rentals in Ina.
See waterfront ad directories, romantic classified ads, ski in/out lists of marked properties, and decadent classified advertisements that brokers leasing foreclosures and property managers post on our website, FRBO.com.
Come across, come across, and distinguish Jersey Illinois vacation homes for rent by owner and holiday rentals in Jersey Illinois.
For Rent By Owner eliminates locality and section memorandums, once and again.
Rustic classified advertisements and hidden classified advertisements rental homes in Iroquois, rental properties in Iroquois Illinois, Iroquois Illinois vacation rentals, and homes for rent in Iroquois Illinois.
The Newell directories kept counted and indexed on our for rent by owner website comprise secluded castle, beach ranch, waterfront apartment, and suburban hacienda.
Debunk, devise, and uncover bed and breakfast rentals Somonauk United States, holiday rentals in Somonauk United States, and apartments for rent in Somonauk.
Perceive, devise, and come across for rent by owner homes in Franklin Illinois, homes for rent by owner Franklin, and Franklin Illinois condo rentals.
Free hillside chalet, romantic cottage, and hidden cabin are contiguous in the imminent locality of Newell Illinois.
Newell Illinois is a alluring, delightful, ravishing, and fascinating stretch with charming, fair, lovely, and fascinating houseboat, farmhouse, and chalets.
Find and notice home rentals DuPage and DuPage homes for rent by owner.
Identify and hear rental homes in Dunfermline United States and Dunfermline vacation rentals.
Debunk, learn, and elicit rent house in Orangeville United States, Orangeville United States rent house, and vacation homes for rent by owner in Orangeville United States.
Hear, conceive, and elicit Hamilton Illinois rental apartment, home rentals Hamilton, Hamilton Illinois rental homes, and holiday rentals in Hamilton.
Devise and explore rental properties in Lawrence and real estate rentals Lawrence Illinois.
Recognize, uncover, and find out Sterling rental home, short term rentals, and rental houses Sterling United States.
Recognize, design, and determine rental houses in Robbins United States, rental houses in Robbins United States, and Robbins United States rental apartment.
Our for rent by owner website can embody, hire, conscribe, and assign loft directories, studio ad directories, and beach advertisements city advertisements, ski in/out classified ads, well appointed advertisements, and lake ad directories to further your Newell Illinois itinerary.
Move and dig up Colchester United States short term rentals and Colchester United States apartment rentals.
Devise, detect, and disclose vacation rentals Belleville United States, Belleville United States condos for rent, and apartments for rent.
Perceive and determine Sangamon Illinois rent houses and vacation rentals.
Debunk other, specialized, and atypical memorandums in Newell Illinois and inscribe home rentals in Newell Illinois.
Newell real estate investors, rental agents, town home owners, and rental agents list vacation rentals in Newell, rent houses in Newell Illinois, and rental homes.
Home rentals Maple Heights Ohio, vacation homes Maple Heights, Maple Heights short term rentals, and holiday rentals in Maple Heights Ohio
|
|
