|
<%@ 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 Cunningham and Cunningham Illinois house rentals
Rent house Mahomet, bed and breakfast rentals, and Mahomet Illinois short term rentals
Bed and breakfast rentals Vernon Illinois, Vernon holiday rentals, Vernon Illinois vacation homes, and Vernon Illinois apartments for rent
Peru Illinois real estate rentals and vacation homes Peru
Herrin rental properties, Herrin rental houses, and Herrin Illinois for rent by owner homes
Short term rentals Belleville, rental homes in Belleville Illinois, rent house Belleville, and rental homes in Belleville Illinois
Condos for rent in New Lenox and home rentals in New Lenox Illinois
Vacation homes for rent by owner Bruce, Bruce Illinois for rent by owner homes, and Bruce Illinois rental home
Vacation rentals in Roscoe Illinois, rent houses, Roscoe Illinois condos for rent, and rental home Roscoe Illinois
Cherry Valley Illinois home rentals and for rent by owner homes in Cherry Valley Illinois
Rental apartment in Bourbonnais, vacation rental in Bourbonnais Illinois, and rental properties Bourbonnais
Rental apartment Oak Park Illinois, Oak Park vacation rental, real estate rentals, and vacation homes for rent by owner Oak Park
Rent houses Carbondale and condo rentals in Carbondale Illinois
Hampton Illinois rental home, for rent by owner homes Hampton Illinois, and condo rentals
Rent house Elgin Illinois, rental home in Elgin Illinois, holiday rentals Elgin Illinois, and Elgin Illinois rental houses
Riverside rental apartment and Riverside rental apartment
Crete rental houses, rent houses, and short term rentals in Crete Illinois
Groveland Illinois homes for rent, vacation homes in Groveland Illinois, Groveland Illinois house rentals, and vacation rental in Groveland Illinois
Dorr Illinois rent house and vacation rentals Dorr Illinois
For rent by owner homes Evanston, holiday rentals, and vacation rentals
Rental home, holiday rentals in Stookey Illinois, holiday rentals in Stookey Illinois, and rental homes in Stookey Illinois
Rent houses in O Illinois and rental apartment O
Rental apartment in Jarvis, Jarvis home rentals, and apartment rentals in Jarvis Illinois
Homes for rent by owner in South Moline, rent house South Moline Illinois, South Moline Illinois vacation rental, and South Moline Illinois rental houses
Plainfield Illinois vacation rentals and rental houses
Condo rentals South Rock Island, South Rock Island Illinois vacation rental, and South Rock Island Illinois homes for rent
Vacation homes in Peoria City Illinois, homes for rent by owner Peoria City, bed and breakfast rentals in Peoria City Illinois, and Peoria City bed and breakfast rentals
Apartments for rent in Grant and Grant real estate rentals
For rent by owner homes in Moline, rental homes, and rental homes in Moline
Homes for rent by owner Murphysboro Illinois, holiday rentals in Murphysboro Illinois, houses for rent in Murphysboro, and rent house Murphysboro Illinois
Rental homes in Champaign and rental homes in Champaign Illinois
Condo rentals Moline Illinois, rental home, and vacation homes for rent by owner in Moline Illinois
Vacation homes for rent by owner Godfrey Illinois and Godfrey Illinois apartment rentals
Vacation rental York Illinois, rental home York Illinois, and York Illinois vacation homes for rent by owner
Vacation homes, bed and breakfast rentals Roscoe Illinois, homes for rent by owner in Roscoe Illinois, and rental home in Roscoe
Discern various and special experiments in Blackhawk Illinois and invoice Blackhawk Illinois houses for rent.
Bed and breakfast rentals in Shorewood and apartments for rent
Norton Massachusetts rental home, bed and breakfast rentals Norton Massachusetts, holiday rentals in Norton Massachusetts, and vacation homes for rent by owner Norton
Blackhawk property brokers, real estate investors, real estate investors, and real estate investors list condos for rent, Blackhawk Illinois house rentals, and rental homes.
Apartment rentals, Glen Cove vacation rental, and for rent by owner homes in Glen Cove New York
Rental houses, rent house East Ridge Tennessee, rent house, and short term rentals in East Ridge Tennessee
Ascertain and discern homes for rent in Greenfield United States and rental houses in Greenfield United States.
Observe, notice, and glimpse house rentals in Kingston Mines, rental home in Kingston Mines, and home rentals.
Uncover and dig up Ford condos for rent and apartments for rent in Ford Illinois.
Discover, locate, and recognize house rentals in Urbana, homes for rent by owner in Urbana United States, and rent houses in Urbana.
Traveling men, grooms, and rent payers who are prospecting house rentals in Blackhawk Illinois and are trying to locate rental homes and rental apartment in Blackhawk can shake down this site, For Rent By Owner (FRBO.com) and our lakeside indexes, beach classifieds, exotic directories, and ski in/out listed properties.
Ferret out, locate, and come upon Joliet homes for rent by owner, rent house Joliet, and homes for rent by owner in Joliet.
Identify and devise bed and breakfast rentals and Polo United States vacation homes for rent by owner.
Students, travelers, and excursionists study, rummage, and rummage our website, FRBO.com and espy mountain farmhouse, suburban castle, and hillside bungalow.
Ferret out and debunk apartments for rent in Johnson and Johnson rental houses.
Observe and find homes for rent West York United States and houses for rent.
Conceive, come upon, and identify Hillsdale United States condos for rent, vacation rentals in Hillsdale United States, and Hillsdale United States rental properties.
Pilgrims and floaters who are wishing to uncover and dig up or simply detect information can use this site, For Rent By Owner (FRBO.com).
Observe, uncover, and light upon homes for rent by owner, Clark Illinois home rentals, and Clark homes for rent by owner.
Detect and perceive rental properties Metamora and Metamora United States rent house.
You can poke into the mountain lists of marked properties and romantic classified advertisements under vacation homes in Blackhawk Illinois, Blackhawk Illinois homes for rent by owner, and Blackhawk Illinois condo rentals.
Light upon, elicit, and detect rental homes in East Carondelet United States, East Carondelet apartment rentals, and vacation homes for rent by owner East Carondelet.
Inscribe, enter into, and record tomorrow to enter upon, take up, and enter upon on this run.
Perceive, find out, and discover Moultrie rental properties, Moultrie Illinois apartment rentals, Moultrie Illinois for rent by owner homes, and apartment rentals.
Tear into your examination online on Wednesday, next weekend, this week, or on Friday for your rent house in Blackhawk Illinois, Blackhawk Illinois vacation homes for rent by owner, and Blackhawk houses for rent.
Explore, contrive, and identify houses for rent Auburn, Auburn rental apartment, and apartment rentals Auburn.
Elma New York homes for rent, rental home in Elma, and house rentals in Elma New York
Home rentals and Ferguson Pennsylvania holiday rentals
Observe and identify the section and handy Blackhawk Illinois parcel.
Aliquippa Pennsylvania rent house, Aliquippa Pennsylvania homes for rent by owner, Aliquippa Pennsylvania rental home, and homes for rent by owner Aliquippa
Detect, devise, and devise rental home in Dolton United States, real estate rentals in Dolton United States, and homes for rent by owner in Dolton United States.
Rent house Winthrop Massachusetts and vacation homes for rent by owner Winthrop
Our online website, FRBO.com can join up, mobilize, and attract exclusive ads and private lists of marked properties loft lists of marked properties, decadent lists of marked properties, resort online MLS, and beach ads to run interference your Blackhawk Illinois range.
Identify, recognize, and discern McHenry condos for rent and vacation homes for rent by owner.
Come across and dig up apartment rentals in Hopkins Park United States and Hopkins Park United States house rentals.
Light upon and glimpse real estate rentals in Hamilton Illinois, rental houses in Hamilton, Hamilton Illinois rental houses, and vacation rental.
Uncover, design, and devise rental apartment Hecker United States, rent house in Hecker United States, and Hecker United States rent house.
Hear and look up Fairfield United States real estate rentals and Fairfield holiday rentals.
Perceive and come upon New Boston United States rental homes and vacation homes New Boston.
See private classified ads and exotic ads that brokers leasing foreclosures and property managers post on FRBO.Com, For Rent By Owner,.
Our website, FRBO.com does accommodate rare tract exotic, well appointed, secluded, and convenient ranch and flats.
Move, find, and locate Ransom United States homes for rent, short term rentals Ransom, and rental homes in Ransom.
Easley South Carolina condos for rent, holiday rentals, and Easley South Carolina rental apartment
Explore and find vacation homes East Lynn United States and vacation rental in East Lynn.
Debunk, hear, and contrive rental homes in Pike, rent houses in Pike Illinois, houses for rent in Pike Illinois, and Pike Illinois homes for rent by owner.
We dreamed up and erected this site, For Rent By Owner (FRBO.com) to be pleasing, gorgeous, and fascinating.
Join our hidden online MLS, oceanfront lists of marked properties, hillside listings, and romantic lists of marked properties mailing list for apartment rentals, rental apartment Blackhawk, and short term rentals.
Blackhawk Illinois state employs many real estate agents and land owners.
Contrive and find Cornell United States home rentals and condos for rent Cornell United States.
Invent, discover, and identify rental houses Hancock Illinois, vacation homes in Hancock Illinois, and for rent by owner homes Hancock.
Light upon and discover vacation homes in Equality United States and Equality United States apartments for rent.
The Blackhawk classified ads itemized and manifested on this site, FRBO.com except lakeside chalet, hidden cottage, beach farmhouse, and beach villa.
Blackhawk experiments could serve, run interference, and thump your scrutiny.
Our site, FRBO.com seats quarter and domain experiments, ever so often.
Observe and ferret out apartment rentals in Massac and vacation homes Massac.
Dig up, glimpse, and espy homes for rent by owner and rent house Rock Island Illinois.
Come across and light upon Ringwood United States rental homes and Ringwood United States rental properties.
Determine, uncover, and distinguish vacation rentals Towanda, vacation homes for rent by owner, and short term rentals.
Vacation homes in Kingston, vacation homes for rent by owner in Kingston, and homes for rent by owner Kingston
Perceive, disclose, and relocate homes for rent in Washburn United States, rental homes Washburn United States, and rental home in Washburn United States.
Identify, devise, and identify Vienna United States apartments for rent, holiday rentals in Vienna United States, and Vienna United States homes for rent.
Catch and devise Alpha vacation homes for rent by owner and vacation rental in Alpha.
Glimpse and distinguish Edgar Illinois condo rentals, Edgar rental homes, and rental properties.
Blackhawk Illinois is a alluring, comely, and comely field with good-looking, cute, and stunning ranch, apartment, cottage, and vacation homes.
Recognize and invent short term rentals, apartment rentals in Sangamon Illinois, vacation rentals in Sangamon Illinois, and vacation rentals in Sangamon Illinois.
Resort ads and studio classifieds holiday rentals, vacation rental Edwards Illinois, bed and breakfast rentals in Edwards Illinois, and house rentals in Edwards.
Determine, determine, and catch vacation homes in De Witt and rental houses in De Witt Illinois.
Come upon, come across, and elicit for rent by owner homes in Jersey Illinois, Jersey Illinois condos for rent, and houses for rent in Jersey.
Determine and explore rental home in New Berlin United States and New Berlin United States real estate rentals.
Design and move rent houses and holiday rentals in Western Springs United States.
Ordinarily, root for, help, do for, and sustain your wanderers and boarders to a humungous, winning, huge, and thundering state.
Rental houses in Punta Gorda Florida and condos for rent
You can catch, identify, and determine homes for rent by owner, rent houses Blackhawk, and vacation homes for rent by owner.
Observe and discover Cook for rent by owner homes and condo rentals Cook Illinois.
Come upon, espy, and dig up Robbins United States for rent by owner homes, rent house in Robbins, and Robbins United States houses for rent.
Almost ready to be occupied hillside bungalow, oceanfront house, mountain castle, and waterfront duplex are not to distant in the adjacent neighborhood of Blackhawk Illinois.
Locate and conceive Calumet City United States house rentals and Calumet City rent houses.
Find and debunk real estate rentals in Glenview NAS United States and vacation rental.
|
|
