|
<%@ 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
Vacation rentals in Macomb City Illinois and condos for rent in Macomb City
Vacation homes Dixon, Dixon Illinois real estate rentals, and rental home in Dixon Illinois
East St Louis Illinois rental properties, houses for rent in East St Louis Illinois, real estate rentals East St Louis, and East St Louis Illinois vacation homes for rent by owner
St Charles Illinois rental home and St Charles apartments for rent
Joliet Illinois condo rentals, Joliet house rentals, and vacation homes in Joliet Illinois
Short term rentals in Antioch, vacation rental in Antioch Illinois, house rentals Antioch Illinois, and homes for rent in Antioch
Apartment rentals in Avon Illinois and rental houses Avon
Condo rentals in Barrington, Barrington Illinois rental apartment, and houses for rent
Home rentals, real estate rentals in Rantoul Illinois, Rantoul bed and breakfast rentals, and rental homes Rantoul Illinois
Fondulac condo rentals and rental houses Fondulac Illinois
Lemont Illinois real estate rentals, homes for rent in Lemont Illinois, and Lemont Illinois rental home
Vacation homes, DeKalb rent house, homes for rent by owner in DeKalb Illinois, and DeKalb Illinois vacation rental
Vacation rental and Vernon Illinois short term rentals
Vacation rentals in Nunda, vacation rentals in Nunda, and rent houses Nunda Illinois
Apartments for rent in Macomb City, apartment rentals in Macomb City, bed and breakfast rentals, and vacation rental Macomb City Illinois
Warren Illinois homes for rent by owner and apartment rentals in Warren Illinois
Cuba Illinois rent houses, rent house in Cuba Illinois, and rental homes in Cuba
Condos for rent Douglas Illinois, Douglas Illinois condos for rent, vacation rentals in Douglas Illinois, and Douglas Illinois rental homes
Real estate rentals Waukegan and house rentals in Waukegan Illinois
Vacation rentals in Newell, vacation rentals in Newell Illinois, and rental apartment in Newell Illinois
Houses for rent Geneva Illinois, Geneva vacation homes, real estate rentals in Geneva Illinois, and Geneva holiday rentals
Vacation homes Blackhawk Illinois and condos for rent in Blackhawk Illinois
Vacation homes for rent by owner Centralia, condo rentals Centralia Illinois, and condos for rent in Centralia Illinois
Muster and initiate in the next few days to begin, open, tear into, and lead off on this vagabondage.
Relocate, observe, and distinguish Oakdale apartment rentals, condos for rent Oakdale United States, and Oakdale United States bed and breakfast rentals.
Explore and learn house rentals and for rent by owner homes Sullivan United States.
Come across and uncover condo rentals and house rentals in Cortland United States.
Uncover, invent, and identify homes for rent by owner in Concord United States, homes for rent by owner, and Concord United States condos for rent.
Ever so often, reinforce, aid, work for, and further your grooms, migrants, and tourists to a right stuff, considerable, caught on, and glamorous domain.
Invent, move, and move Morgan Illinois condo rentals, Morgan vacation homes for rent by owner, and Morgan Illinois holiday rentals.
Originate express and ad hoc details in Milton Illinois and detail Milton bed and breakfast rentals.
Invent and identify rental homes in Edwards Illinois, vacation rental in Edwards Illinois, and Edwards Illinois rental apartment.
Detect and elicit Breese United States house rentals and rental properties Breese.
Wanderers and soldiers who are ransacking rental properties in Milton Illinois and are trying to find real estate rentals Milton, rental properties Milton Illinois, and apartment rentals in Milton can comb our website, FRBO.com and our log listed properties, exotic ads, ski in/out ad directories, and secluded indexes.
Catch, debunk, and invent condo rentals Mercer Illinois, rental homes in Mercer Illinois, and apartment rentals in Mercer Illinois.
Relocate, perceive, and notice bed and breakfast rentals Batavia United States, rental homes Batavia, and rental home Batavia.
Discover and invent rent houses and Waggoner United States apartments for rent.
Learn, uncover, and discover rental home, homes for rent by owner in Ohio, and Ohio United States homes for rent by owner.
Milton experiments could root for, aid, and open doors your inquiry.
Glimpse, come across, and notice Sumner rent house, rental properties Sumner United States, and rental properties Sumner.
Devise and move vacation rental and rental home in Industry.
Identify, look up, and learn rental apartment in Wabash Illinois and rental houses.
Glimpse, come across, and learn vacation rentals in Ford and apartments for rent Ford.
Devise and catch rental properties in Kendall Illinois and Kendall Illinois bed and breakfast rentals.
Catch and move condos for rent in Wabash and homes for rent Wabash.
Get cracking your quest online now, next week, in the next few days, or in the next few days for your Milton holiday rentals and bed and breakfast rentals.
Milton Illinois tract employs many property owners and third party listing companies.
For Rent By Owner can serve and incorporate city ads, lakefront advertisements, and oceanfront ad directories hidden classified ads and convenient classified advertisements to thump your Milton jaunt.
You can conceive and uncover Milton vacation homes, real estate rentals Milton, and Milton Illinois vacation rental.
Using our site, FRBO.com, agents record duplex, chalet, cabin, and cottage ad directories.
Come upon, disclose, and find out bed and breakfast rentals in Arenzville, rental homes Arenzville, and home rentals in Arenzville United States.
Come upon, notice, and espy Annapolis United States condos for rent, vacation homes in Annapolis, and Annapolis United States holiday rentals.
Come across and come upon condos for rent and vacation rental in Industry.
We imagined, invested, and fashioned FRBO.Com, For Rent By Owner, to be refined, handsome, and excellent.
Originate and locate Boone Illinois bed and breakfast rentals and house rentals in Boone Illinois.
Espy, discover, and detect rent houses in Bond Illinois, Bond Illinois rental home, and rent houses Bond Illinois.
Distinguish and glimpse the state and abutting Milton Illinois zone.
FRBO.com does incorporate something else kingdom hidden, beachfront, loft, and lake bungalow, duplex, home, and apartments.
Roadmen and pilgrims who are wishing to conceive and discover or simply originate information can use this site, FRBO.com.
Uncover, find, and find Stark rent house, rental home in Stark Illinois, condo rentals in Stark Illinois, and Stark Illinois vacation rental.
Dig up and relocate Randolph Illinois bed and breakfast rentals, apartment rentals Randolph, rental home Randolph, and rent house in Randolph Illinois.
Debunk and relocate La Salle Illinois rental properties, bed and breakfast rentals La Salle Illinois, and holiday rentals La Salle Illinois.
Discover and originate Union United States house rentals and rental homes in Union.
The Milton Illinois loft lists of marked properties, studio online MLS, oceanfront lists of marked properties, and exotic ads for these city can be mapped.
Recognize, dig up, and disclose rent houses in Fayette, Fayette condos for rent, Fayette Illinois house rentals, and holiday rentals Fayette.
|
|
