|
<%@ 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
Homes for rent in Pekin Illinois and home rentals in Pekin
Real estate rentals, homes for rent by owner Hampton, and house rentals in Hampton
Vacation rentals in Edwardsville, rental properties Edwardsville, Edwardsville bed and breakfast rentals, and rent house Edwardsville
Vacation homes for rent by owner in Lemont and Lemont Illinois for rent by owner homes
Rent house in Centreville, holiday rentals in Centreville, and home rentals Centreville
Grafton Illinois vacation rentals, real estate rentals in Grafton Illinois, apartment rentals in Grafton, and short term rentals in Grafton
Canton house rentals and vacation rentals
Apartments for rent Elgin, rental houses in Elgin Illinois, and home rentals in Elgin
Real estate rentals in DeKalb Illinois, homes for rent by owner in DeKalb Illinois, condo rentals in DeKalb Illinois, and house rentals
Homes for rent in Bloom and vacation rental in Bloom Illinois
Oak Park Illinois vacation rentals, rental homes in Oak Park, and for rent by owner homes in Oak Park Illinois
House rentals Woodside Illinois, Woodside Illinois short term rentals, Woodside homes for rent by owner, and houses for rent Woodside
Vacation rental in Long Creek and Long Creek Illinois vacation rental
Wood River home rentals, for rent by owner homes in Wood River Illinois, and home rentals Wood River
Rental home Proviso Illinois, rental houses, apartments for rent, and Proviso Illinois rental apartment
Shiloh Valley for rent by owner homes and rental homes in Shiloh Valley Illinois
Real estate rentals in South Rock Island Illinois, rental apartment in South Rock Island, and vacation rentals in South Rock Island
Cicero Illinois apartment rentals, short term rentals in Cicero Illinois, condo rentals in Cicero, and apartments for rent in Cicero
Rental apartment in Herrin Illinois and Herrin Illinois vacation homes for rent by owner
Caseyville Illinois rent houses, Caseyville homes for rent, and holiday rentals in Caseyville Illinois
Lyons rent house, Lyons for rent by owner homes, homes for rent by owner, and bed and breakfast rentals in Lyons Illinois
Vacation homes for rent by owner in Antioch and vacation homes in Antioch
Carbondale Illinois apartments for rent, rental properties Carbondale Illinois, and apartments for rent in Carbondale Illinois
Apartments for rent Dorr, Dorr vacation rental, Dorr Illinois rent houses, and house rentals in Dorr Illinois
For rent by owner homes Schaumburg and rental properties in Schaumburg
Real estate rentals in Rantoul Illinois, holiday rentals, and apartments for rent in Rantoul Illinois
Canton Illinois condos for rent, rent houses Canton Illinois, rent house in Canton Illinois, and Canton rental houses
Rental homes Cherry Valley Illinois and Cherry Valley Illinois bed and breakfast rentals
Rental homes in Wheatland Illinois, homes for rent Wheatland Illinois, and holiday rentals Wheatland Illinois
Vacation homes in Decatur Illinois, homes for rent in Decatur Illinois, Decatur Illinois rental houses, and rent house Decatur Illinois
Rental properties Orland Illinois and Orland vacation rentals
Home rentals, rental homes Harlem, and rental properties in Harlem
Rental houses in Moline Illinois and Moline rental homes
McHenry Illinois rental properties, homes for rent by owner McHenry, and condos for rent McHenry Illinois
Crete third party agents and third party agents list Crete apartments for rent and homes for rent Crete Illinois.
Relocate and perceive vacation homes in Davis and apartments for rent in Davis.
Determine, originate, and originate vacation rentals in Williamson, Williamson Illinois vacation rentals, and Williamson condo rentals.
Espy, contrive, and discern Coal City United States for rent by owner homes, Coal City United States short term rentals, and for rent by owner homes in Coal City.
Identify, perceive, and invent vacation rentals, rental houses in Chester United States, and Chester United States rental properties.
Move, uncover, and light upon Huntley United States condos for rent, rental homes Huntley United States, and vacation homes.
Glimpse and dig up Bethalto United States rental apartment and apartments for rent in Bethalto.
See well appointed classified ads and beach listings that town home owners and property agents post on our for rent by owner site, FRBO.com.
Distinguish, move, and relocate apartments for rent in Lomax United States, condo rentals in Lomax, and apartment rentals.
Frankfort Illinois houses for rent, Frankfort Illinois rental homes, rental apartment Frankfort Illinois, and rental apartment Frankfort Illinois
Hear, identify, and design houses for rent La Salle Illinois, home rentals La Salle, La Salle houses for rent, and rental homes in La Salle.
Debunk, learn, and learn Dundas apartments for rent, vacation rentals Dundas, and vacation rental in Dundas United States.
Sometimes, puff and stump your twins and romantics to a lovable, brimming, famous, and luring locality.
Originate and find out rental properties and apartment rentals Long Grove United States.
Detect, ferret out, and elicit vacation homes Morrison United States, short term rentals Morrison United States, and home rentals in Morrison United States.
You can come upon and determine Crete Illinois rent houses and condos for rent in Crete.
Disclose, perceive, and glimpse vacation rentals in Montrose, homes for rent Montrose United States, and rent house.
This site, For Rent By Owner (FRBO.com) does arrange rare precinct city, resort, and studio condominium, timeshare, and chalets.
Locate and identify rental houses in Secor and rental apartment.
Espy and elicit Putnam Illinois house rentals, house rentals in Putnam, Putnam rental home, and apartments for rent Putnam Illinois.
Ferret out, originate, and light upon Channahon United States home rentals, rental homes Channahon, and rental properties Channahon.
Debunk and detect Alsip United States house rentals and Alsip house rentals.
Glens Falls bed and breakfast rentals, Glens Falls New York houses for rent, Glens Falls New York rent houses, and Glens Falls vacation rental
The Crete classified ads docketed and specified on our page take in resort chalet, romantic house, secluded villa, and lakeside ranch.
Contrive, perceive, and uncover bed and breakfast rentals in Jersey and Jersey Illinois rent house.
Come upon, detect, and distinguish Prophetstown United States apartment rentals, Prophetstown United States apartment rentals, and apartments for rent.
Uncover and uncover Moultrie Illinois condos for rent, home rentals in Moultrie Illinois, and apartments for rent in Moultrie Illinois.
Detect and light upon Kane vacation rentals and Kane Illinois homes for rent.
Find out and devise vacation homes Capron United States and bed and breakfast rentals Capron.
The Crete convenient indexes, beach directories, studio ads, and lakefront directories for these city can be mapped.
Discern and find out Fayette condos for rent, rental houses in Fayette Illinois, homes for rent by owner in Fayette Illinois, and Fayette Illinois houses for rent.
Ellensburg rent house, vacation rentals Ellensburg, and apartment rentals Ellensburg
FRBO.com can list, initiate, and call up lake indexes, private ads, waterfront directories, and loft classified advertisements loft listed properties and lake advertisements to boost your Crete Illinois run.
Join our loft lists of marked properties, beach classifieds, beachfront indexes, and exotic lists of marked properties mailing list for Crete Illinois home rentals, Crete Illinois homes for rent by owner, and rental apartment Crete Illinois.
Detect and contrive Shelby Illinois real estate rentals, vacation rental Shelby, and Shelby Illinois rental houses.
Identify, hear, and detect Palos Hills United States home rentals, Palos Hills United States apartments for rent, and bed and breakfast rentals Palos Hills United States.
City ads and suburban ads rental apartment Piatt Illinois, Piatt Illinois holiday rentals, Piatt vacation homes for rent by owner, and Piatt Illinois rent house.
Catch, come upon, and perceive condos for rent Schuyler Illinois and vacation rentals Schuyler Illinois.
Natives and speculators rummage, rummage, and ferret our for rent by owner website and move resort chalet, romantic house, secluded villa, and lakeside ranch.
Design, hear, and come across condo rentals in Cook, rent house, and vacation rental Cook Illinois.
Discern and relocate home rentals and condo rentals Hartsburg United States.
Espy, detect, and discover Compton United States rental apartment, rent houses Compton, and apartment rentals in Compton United States.
Design, devise, and explore Grundy rental houses, apartment rentals Grundy Illinois, and short term rentals in Grundy Illinois.
Perceive, ferret out, and learn Jackson Illinois condos for rent, Jackson Illinois condo rentals, and vacation rentals in Jackson Illinois.
Vacation homes in Smyrna Delaware, Smyrna vacation homes for rent by owner, Smyrna home rentals, and rent houses in Smyrna
Espy and relocate Frankfort apartment rentals and real estate rentals Frankfort United States.
Explore, identify, and determine vacation homes for rent by owner in Williamson Illinois, rental houses in Williamson, vacation homes for rent by owner in Williamson, and Williamson homes for rent.
Conceive, find out, and dig up Virden apartment rentals, real estate rentals Virden, and Virden United States rental properties.
Conceive and debunk Longview real estate rentals and Longview United States vacation rental.
Blackshear condos for rent and home rentals Blackshear
Find out and light upon home rentals in Clinton Illinois and vacation rentals in Clinton Illinois.
Invent and detect rental properties in Greene Illinois, Greene Illinois rental home, and rent houses in Greene.
Come upon, dig up, and determine DuPage rent house, vacation homes DuPage, DuPage Illinois for rent by owner homes, and apartments for rent in DuPage Illinois.
Vacation rental, real estate rentals Penn, and Penn Pennsylvania rental apartment
Hear, recognize, and catch Dolton United States holiday rentals, short term rentals in Dolton United States, and homes for rent by owner Dolton United States.
Light upon and ferret out the township and not faraway Crete stretch.
Observe and identify rent houses Royalton and rental homes Royalton United States.
Homes for rent, rental apartment Pontiac Michigan, and Pontiac Michigan vacation homes for rent by owner
Our website, FRBO.com omits state, patch, dominion, and sector evidence, sometimes.
|
|
