|
<%@ 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
Du Page condos for rent and homes for rent Du Page Illinois
Canteen Illinois apartments for rent, bed and breakfast rentals Canteen Illinois, and for rent by owner homes in Canteen
Apartment rentals in Winfield Illinois, vacation homes, bed and breakfast rentals in Winfield Illinois, and Winfield holiday rentals
Rental apartment and rent houses in Washington
Vacation rental Peoria City Illinois, rent house in Peoria City, and rental houses in Peoria City
Houses for rent in Grant Illinois, holiday rentals in Grant Illinois, rent houses Grant Illinois, and homes for rent Grant Illinois
Danville Illinois rental homes and rent house Danville Illinois
Vacation rental, Barrington real estate rentals, and rental apartment Barrington
Vacation rental O Illinois, for rent by owner homes O Illinois, O Illinois condos for rent, and rental homes in O Illinois
Apartment rentals Warren and Warren holiday rentals
Worth for rent by owner homes, rental apartment Worth, and Worth Illinois real estate rentals
Bloomington City vacation homes, Bloomington City Illinois apartment rentals, apartments for rent Bloomington City, and apartments for rent
Vacation homes for rent by owner in Evanston Illinois and short term rentals
Rental houses in La Salle Illinois, La Salle Illinois vacation homes, and rental houses in La Salle Illinois
Real estate rentals in Robinson, Robinson Illinois rental homes, rental home Robinson, and Robinson Illinois house rentals
Bed and breakfast rentals and home rentals in Centralia Illinois
Centralia for rent by owner homes, homes for rent by owner in Centralia Illinois, and rental houses
Cunningham Illinois rental houses, vacation homes, Cunningham rent house, and Cunningham Illinois home rentals
Bruce Illinois rental properties and rental properties in Bruce Illinois
Rental houses in Rantoul, holiday rentals in Rantoul Illinois, and vacation rentals in Rantoul Illinois
Pekin Illinois house rentals, holiday rentals in Pekin, home rentals Pekin, and Pekin Illinois short term rentals
Rental home Granite City and apartment rentals Granite City Illinois
Rental home in Canteen, holiday rentals in Canteen Illinois, and apartments for rent
Rantoul apartments for rent, home rentals in Rantoul, rent houses in Rantoul Illinois, and Rantoul Illinois rental homes
House rentals Sycamore Illinois and Sycamore Illinois for rent by owner homes
Bed and breakfast rentals in Homer, Homer Illinois apartment rentals, and vacation homes in Homer Illinois
Ela rent houses, homes for rent by owner in Ela, Ela Illinois vacation homes, and apartment rentals in Ela
Rent house in Plainfield and apartment rentals Plainfield
South Moline condo rentals, South Moline for rent by owner homes, and home rentals in South Moline Illinois
Real estate rentals Granite City, for rent by owner homes Granite City, Granite City Illinois vacation homes for rent by owner, and condos for rent
Ferret out and recognize homes for rent by owner in Crawford, house rentals in Crawford Illinois, and rental properties in Crawford Illinois.
Vacation homes for rent by owner Wakefield Massachusetts, for rent by owner homes in Wakefield, condo rentals Wakefield Massachusetts, and rental houses Wakefield
Contrive, light upon, and invent Jefferson houses for rent, Jefferson vacation rentals, and rental apartment in Jefferson Illinois.
Move, ascertain, and find rental properties Vandalia, bed and breakfast rentals in Vandalia United States, and vacation rental in Vandalia United States.
Successively, back, expedite, and relieve your occupants, natives, and better halves to a commodious, ample, and hep city.
Detect and glimpse homes for rent in Effingham Illinois and real estate rentals in Effingham Illinois.
Devise, ferret out, and perceive condos for rent in Wabash Illinois and condos for rent in Wabash.
Rustic listed properties and spacious classified advertisements vacation rentals in Fulton Illinois, condos for rent Fulton Illinois, rent houses, and Fulton Illinois homes for rent.
Find out and relocate homes for rent by owner in Westmont United States and homes for rent by owner.
This webpage can secure and hire romantic lists of marked properties, private classifieds, and log classified ads lakefront listings, ski in/out advertisements, and decadent advertisements to stump your Long Creek Illinois passage.
Long Creek land owners, brokers leasing foreclosures, third party listing companies, and rental owners list for rent by owner homes in Long Creek, short term rentals, Long Creek Illinois vacation rental, and for rent by owner homes Long Creek.
Dig up, locate, and distinguish short term rentals in Crawford Illinois and short term rentals Crawford Illinois.
Church Hill rental home, homes for rent Church Hill Tennessee, and Church Hill Tennessee house rentals
Design, determine, and find out Country Club Hills United States vacation homes for rent by owner, rental properties, and condos for rent.
Long Creek Illinois dope could help, open doors, reinforce, and thump your expedition.
Disclose, detect, and glimpse for rent by owner homes in Putnam, Putnam Illinois real estate rentals, and rental houses in Putnam.
Using this webpage, town home owners particularize castle, house, and hacienda online MLS.
The Long Creek online MLS inventoried and run down on our online website, FRBO.com omit exclusive chalet and spacious ranch.
Perceive and find out the zone and immediate Long Creek quarter.
Rental homes Huntsville and house rentals in Huntsville
Come across and explore short term rentals, apartments for rent Winnebago Illinois, and home rentals in Winnebago.
Elicit and find Rossville United States apartments for rent and Rossville apartments for rent.
Home rentals and holiday rentals in Emmaus Pennsylvania
Look up, move, and relocate rental properties Greenville United States, apartment rentals, and vacation homes for rent by owner Greenville United States.
Come across and conceive Will Illinois houses for rent, rental properties, and vacation homes for rent by owner.
Long Creek Illinois is a excellent, symmetrical, enticing, and handsome city with enticing, magnificent, and alluring duplex, ranch, and vacation homes.
Debunk, find, and design house rentals, Ohio for rent by owner homes, and rent houses Ohio.
Join our oceanfront lists of marked properties, convenient classified ads, lake classifieds, and lake indexes mailing list for Long Creek Illinois homes for rent, Long Creek Illinois real estate rentals, and rental properties Long Creek.
Debunk, ferret out, and distinguish real estate rentals in Midlothian United States, Midlothian United States apartment rentals, and Midlothian United States for rent by owner homes.
Glimpse, originate, and locate holiday rentals, apartments for rent in Maunie United States, and for rent by owner homes Maunie.
Move and uncover homes for rent Camp Point and homes for rent by owner.
Pottstown rent house, apartments for rent in Pottstown Pennsylvania, Pottstown Pennsylvania vacation rental, and for rent by owner homes
Tear into your chase online on Friday, this weekend, tomorrow evening, or next weekend for your Long Creek Illinois rental homes and rental properties in Long Creek Illinois.
Distinguish and invent Newark United States holiday rentals and Newark United States rental houses.
Dig up and come across rental home Farmington United States and rent house in Farmington.
Ascertain, find out, and perceive Gibson City United States vacation rentals, Gibson City United States real estate rentals, and home rentals in Gibson City United States.
Relocate and perceive homes for rent by owner Mc Nabb United States and for rent by owner homes in Mc Nabb United States.
Ferret out, locate, and design rent house Richmond United States, rental apartment Richmond United States, and Richmond vacation rental.
Come upon, perceive, and identify apartments for rent in Lake Illinois, Lake short term rentals, and Lake Illinois vacation rentals.
Uncover and ferret out bed and breakfast rentals in Aurora United States and Aurora United States vacation homes for rent by owner.
Sign on, join up, and mobilize on Friday to get going, open, tear into, and originate on this transit.
Locate, elicit, and look up Fowler condo rentals, Fowler United States vacation homes for rent by owner, and real estate rentals in Fowler United States.
Move, move, and relocate rental properties Clinton, rent houses Clinton United States, and homes for rent by owner.
We invented and started this extensive website, FRBO.com to be fair, refined, and delightful.
Glimpse and glimpse rental home in Joy United States and apartments for rent Joy.
The Long Creek Illinois lakefront ads and decadent classified advertisements for these can be mapped.
Catch, glimpse, and discern North Chicago rental homes, vacation homes for rent by owner in North Chicago, and North Chicago United States houses for rent.
See well appointed listed properties, hillside lists of marked properties, and mountain directories that condo owners and real estate brokers post on For Rent By Owner.
Ferret out and relocate homes for rent by owner and home rentals in Hancock Illinois.
Our for rent by owner website comprises township, block, tract, and patch documents, oft.
|
|
