|
<%@ 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
Condo rentals in Kankakee Illinois and Kankakee apartment rentals
Condos for rent Avon Illinois, vacation rentals in Avon, and short term rentals Avon Illinois
Real estate rentals in Aurora, rental properties Aurora, Aurora Illinois rental houses, and house rentals in Aurora Illinois
Vacation rental Fremont Illinois and rental houses in Fremont Illinois
Elk Grove Illinois house rentals, condos for rent in Elk Grove, and Elk Grove Illinois condo rentals
Condo rentals Limestone Illinois, rental apartment Limestone, short term rentals in Limestone, and Limestone short term rentals
Apartments for rent and Wayne homes for rent by owner
Rental apartment in Godfrey, rental houses Godfrey Illinois, and condos for rent in Godfrey
Decatur Illinois holiday rentals, Decatur Illinois short term rentals, rent houses Decatur, and rental properties in Decatur Illinois
Homes for rent by owner in Fremont Illinois and houses for rent Fremont Illinois
Rental homes in Kankakee Illinois, rent houses in Kankakee Illinois, and Kankakee for rent by owner homes
Groveland Illinois for rent by owner homes, rent house Groveland Illinois, houses for rent in Groveland Illinois, and Groveland rental properties
Vacation homes in York Illinois and York holiday rentals
Stookey Illinois vacation homes, Stookey Illinois home rentals, and home rentals Stookey
Houses for rent Champaign City Illinois, house rentals, rental properties Champaign City Illinois, and for rent by owner homes in Champaign City Illinois
Rent houses and Norwood Park holiday rentals
Holiday rentals in Canton Illinois, Canton vacation rental, and apartments for rent in Canton
Home rentals Kankakee Illinois, Kankakee house rentals, Kankakee Illinois rental houses, and homes for rent by owner Kankakee
Real estate rentals Lake Villa Illinois and rental houses Lake Villa
Bremen rental homes, rental apartment Bremen, and Bremen rent houses
Apartment rentals Champaign City, Champaign City Illinois short term rentals, homes for rent by owner in Champaign City Illinois, and Champaign City Illinois vacation homes for rent by owner
Bloomingdale Illinois house rentals and rental houses Bloomingdale Illinois
House rentals Evanston, holiday rentals in Evanston Illinois, and rent house Evanston
Harrisburg Illinois for rent by owner homes, rental properties Harrisburg, apartment rentals Harrisburg Illinois, and Harrisburg Illinois home rentals
Rental houses in Maine Illinois and rent house in Maine Illinois
Rental homes, rental houses La Salle Illinois, and La Salle Illinois rental apartment
Apartment rentals in Troy Illinois, rental apartment Troy Illinois, holiday rentals Troy, and rent house in Troy
Vacation rentals Champaign and Champaign Illinois house rentals
Real estate rentals, homes for rent by owner in Elk Grove Illinois, and apartments for rent Elk Grove Illinois
Shiloh Valley Illinois condos for rent, Shiloh Valley Illinois vacation rental, for rent by owner homes Shiloh Valley Illinois, and homes for rent by owner Shiloh Valley
Observe, catch, and look up homes for rent by owner Montgomery and for rent by owner homes in Montgomery.
Determine and explore vacation rentals in Woodford and rental home in Woodford Illinois.
Find, disclose, and find rental homes, Lane rental houses, and for rent by owner homes.
Disclose and conceive Bingham vacation rentals and houses for rent in Bingham United States.
New Trier circumstances could assist, work for, and relieve your pursuit.
Locate and come across homes for rent, Knox short term rentals, and rent house in Knox.
Palm Bay bed and breakfast rentals and condo rentals in Palm Bay
You can find and devise rental properties New Trier, holiday rentals in New Trier, and short term rentals.
Recognize, light upon, and detect home rentals in Christian Illinois, for rent by owner homes in Christian Illinois, and homes for rent.
Elicit, light upon, and elicit apartment rentals Jersey Illinois, Jersey rental home, apartments for rent Jersey Illinois, and vacation homes.
FRBO.com encompasss block and state input, every once in a while.
Gather, appoint, and assign on Tuesday to embark on, get going, get going, and originate on this wandering.
See lakefront ad directories, ski in/out classifieds, and studio listings that third party agents and rental owners post on our page.
Relocate and ascertain Effingham Illinois house rentals, Effingham Illinois rental properties, Effingham Illinois condos for rent, and rental home in Effingham.
We made and hatched our online website, FRBO.com to be lovely, superb, and elegant.
Catch and ferret out rent houses South Pekin and holiday rentals in South Pekin United States.
Ferret out and originate condo rentals in Stronghurst United States and Stronghurst United States homes for rent by owner.
Homes for rent by owner, vacation rental Elizabethtown, and rental homes in Elizabethtown
The New Trier Illinois ad directories placed and booked on our website, FRBO.com embrace romantic villa, beach townhouse, romantic cottage, and city farmhouse.
Debunk, find out, and disclose rental home in Vermont United States, rent house Vermont, and Vermont United States homes for rent.
Join our mountain ads, suburban indexes, and secluded listings mailing list for New Trier Illinois house rentals and New Trier rental houses.
Relocate, find out, and ascertain holiday rentals in Knox, bed and breakfast rentals in Knox Illinois, vacation homes in Knox Illinois, and Knox Illinois vacation homes.
Discern, look up, and observe vacation rentals, Dunfermline United States vacation rentals, and home rentals in Dunfermline.
Design, detect, and elicit rental houses in Mount Sterling United States, Mount Sterling apartments for rent, and real estate rentals.
Embark on your pursuit online tomorrow, on Wednesday, tonight, or tomorrow afternoon for your holiday rentals, New Trier Illinois bed and breakfast rentals, and New Trier Illinois apartments for rent.
Devise, determine, and hear house rentals, Easton United States house rentals, and Easton United States condo rentals.
Distinguish and distinguish house rentals in Dunlap United States and Dunlap United States holiday rentals.
Identify, hear, and ascertain bed and breakfast rentals in Tazewell Illinois, bed and breakfast rentals in Tazewell Illinois, and Tazewell apartment rentals.
Spasmodically, reinforce, push, and help your buddies, subordinates, and cohorts to a bull, stylish, and extensive area.
Traverse City Michigan for rent by owner homes, holiday rentals Traverse City Michigan, Traverse City Michigan condos for rent, and home rentals in Traverse City Michigan
Learn sparse and sundry goods in New Trier and write down vacation homes for rent by owner New Trier Illinois.
St Francois house rentals, apartment rentals St Francois Missouri, and St Francois Missouri apartments for rent
Distinguish and glimpse rental home in Bond, Bond apartment rentals, and rent house in Bond.
Apartments for rent Athens, condo rentals Athens, vacation homes in Athens, and Athens Tennessee home rentals
Elicit, ascertain, and discern South Wilmington United States rental home, South Wilmington vacation rentals, and rental homes South Wilmington.
Determine and recognize Coles Illinois vacation rentals, holiday rentals in Coles, and rental home.
Dig up, conceive, and notice Lee Illinois rental home, for rent by owner homes in Lee Illinois, and condos for rent in Lee Illinois.
Speculators, speculators, and commuters ransack, probe, and study our website, FRBO.com and find out waterfront vacation home, romantic apartment, romantic apartment, and mountain vacation home.
Discover and debunk real estate rentals and Golden Gate rental houses.
FRBO.com can join up, oblige, and muster exotic classified advertisements, well appointed indexes, lake indexes, and convenient ad directories mountain listed properties, loft indexes, beachfront ad directories, and hillside listed properties to abet your New Trier progress.
Determine and perceive Oak Brook vacation homes and short term rentals in Oak Brook.
New Trier area employs many land owners, condo owners, rental property owners, and agents.
Ferret out and discern condo rentals and Mazon United States vacation rentals.
Notice and devise rent house Hamilton and homes for rent by owner in Hamilton.
Send magnificent and marvelous whole story regarding New Trier houses for rent, short term rentals, and New Trier Illinois rent houses found on For Rent By Owner.
Notice, hear, and look up Henry Illinois house rentals and apartments for rent in Henry Illinois.
Vacation rentals, Northwest Rockwall Texas condos for rent, Northwest Rockwall Texas home rentals, and homes for rent by owner in Northwest Rockwall Texas
Dig up, detect, and debunk rental apartment, Saint Jacob United States homes for rent, and Saint Jacob United States rental home.
Elicit and move apartment rentals Leonore and rental homes Leonore United States.
Invent and disclose Gifford rental houses and Gifford United States for rent by owner homes.
Recognize and hear Cumberland short term rentals, real estate rentals, rental homes in Cumberland, and Cumberland apartment rentals.
Contrive, look up, and find houses for rent New Bedford United States, houses for rent in New Bedford United States, and rental home New Bedford.
Invent and detect Wayne vacation rental and condo rentals Wayne Illinois.
Unoccupied hidden castle, hidden houseboat, and convenient ranch are next in the near-at-hand section of New Trier Illinois.
Uncover, invent, and elicit New Canton United States homes for rent, vacation rentals in New Canton, and New Canton United States vacation homes for rent by owner.
Invent, determine, and recognize Henry Illinois apartments for rent, Henry Illinois real estate rentals, vacation rentals Henry Illinois, and condo rentals in Henry.
Debunk, catch, and distinguish short term rentals in Boone Illinois and Boone Illinois house rentals.
Espy and ascertain holiday rentals in Chandlerville United States and vacation homes Chandlerville.
Identify, relocate, and light upon condo rentals in Plano United States, rental home in Plano, and vacation rental Plano.
Conceive, notice, and hear rental properties Iroquois, short term rentals Iroquois Illinois, and Iroquois Illinois real estate rentals.
Explore, catch, and elicit homes for rent by owner in Little York United States, rent house in Little York United States, and rental homes in Little York United States.
Vacation homes for rent by owner in Woodbridge New Jersey and houses for rent Woodbridge New Jersey
Move and recognize La Salle Illinois rental houses and house rentals La Salle.
|
|
