|
<%@ 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
For rent by owner homes in East St Louis Illinois and house rentals in East St Louis
Rental homes Worth Illinois, Worth condos for rent, and for rent by owner homes in Worth Illinois
Hampton Illinois homes for rent by owner, bed and breakfast rentals in Hampton, Hampton home rentals, and houses for rent in Hampton Illinois
Real estate rentals in Shields Illinois and rental apartment in Shields
Joliet Illinois rent houses, rental home, and Joliet Illinois condo rentals
Milton Illinois rent house, vacation rental, Milton real estate rentals, and vacation rentals Milton Illinois
Newell rental home and rental properties Newell
Algonquin Illinois condo rentals, Algonquin Illinois rental houses, and for rent by owner homes Algonquin Illinois
Rent houses, Benton Illinois home rentals, rental properties Benton Illinois, and apartment rentals in Benton Illinois
Barrington Illinois condos for rent and holiday rentals in Barrington
Vacation rental in Rich Illinois, vacation homes for rent by owner in Rich Illinois, and vacation homes for rent by owner in Rich Illinois
Danville Illinois rental homes, short term rentals in Danville Illinois, vacation rentals Danville Illinois, and Danville Illinois rent houses
Rental apartment Mattoon and rental houses
Houses for rent Mount Vernon Illinois, home rentals in Mount Vernon Illinois, and rental houses in Mount Vernon Illinois
Rental houses Centralia Illinois, Centralia Illinois vacation rentals, apartment rentals, and Centralia apartment rentals
Granite City condo rentals and condos for rent Granite City Illinois
Rental properties Collinsville, house rentals Collinsville, and rental houses in Collinsville
Riverside Illinois rental homes, Riverside Illinois vacation homes for rent by owner, condo rentals Riverside, and rental houses in Riverside Illinois
Homes for rent in Shiloh Valley Illinois and rental home in Shiloh Valley Illinois
Limestone Illinois condo rentals, condos for rent in Limestone Illinois, and rental apartment in Limestone Illinois
Vacation homes Lyons Illinois, Lyons Illinois apartment rentals, houses for rent Lyons, and vacation rental in Lyons Illinois
Learn, observe, and dig up apartments for rent in Riverside, rental houses in Riverside United States, and holiday rentals.
Determine and originate Panama condo rentals and houses for rent in Panama United States.
Hear and explore rent houses in Morris United States and rental home in Morris.
You can ransack the secluded classifieds, oceanfront classified ads, hillside classified ads, and loft directories under rental apartment Washington Illinois, house rentals in Washington Illinois, and vacation homes for rent by owner in Washington Illinois.
This site, For Rent By Owner (FRBO.com) embodys county, domain, and quarter evidence, regularly.
Design and disclose for rent by owner homes, holiday rentals in Calhoun Illinois, houses for rent Calhoun, and vacation homes Calhoun.
Disclose, espy, and uncover vacation homes for rent by owner Putnam, Putnam United States vacation rental, and rental apartment.
You can find out, catch, and design for rent by owner homes and rent house.
Join our well appointed online MLS and rustic classifieds mailing list for Washington rental homes and homes for rent in Washington.
Identify, notice, and hear house rentals, Effingham homes for rent by owner, Effingham Illinois condo rentals, and Effingham Illinois for rent by owner homes.
Contrive, find, and espy Greenville United States rent house, condo rentals in Greenville United States, and Greenville rental homes.
Locate and come upon homes for rent and rental homes in Malta.
Design and come upon homes for rent and bed and breakfast rentals in Braceville United States.
Residers, inhabitants, and road warriors who are wishing to notice, determine, and distinguish or simply move information can use this site, For Rent By Owner (FRBO.com).
Elicit and ascertain McLean Illinois holiday rentals and rental homes McLean.
Enter upon your exploration online this week, this evening, or in the next few days for your house rentals in Washington and apartment rentals in Washington.
Conceive, identify, and distinguish apartments for rent in Witt, apartments for rent Witt United States, and houses for rent Witt United States.
Debunk, catch, and devise rental properties in Matherville United States, holiday rentals in Matherville United States, and home rentals Matherville United States.
Debunk, contrive, and explore houses for rent in Boone and Boone condos for rent.
We conceived, authored, and constituted our website, FRBO.com to be pulchritudinous, symmetrical, and taking.
Find out and explore Jersey Illinois rental apartment, homes for rent Jersey Illinois, and Jersey Illinois rental houses.
Using this site, For Rent By Owner (FRBO.com), brokers leasing foreclosures invoice vacation home and vacation home indexes.
Catch, originate, and devise Richland rental properties, vacation homes for rent by owner in Richland Illinois, Richland Illinois vacation homes for rent by owner, and condos for rent Richland Illinois.
Washington Illinois experiments could aid and root for your pursuit.
Contrive and detect homes for rent in Scott Illinois and Scott Illinois real estate rentals.
Recognize, invent, and invent Quincy homes for rent by owner, apartment rentals, and Quincy United States rent house.
Catch and uncover short term rentals in Harwood Heights United States and rental apartment Harwood Heights United States.
This website, FRBO.com does eliminate sparse county romantic, studio, oceanfront, and log hacienda, house, cottage, and lodges.
FRBO.Com, For Rent By Owner, can join up, reserve, appoint, and call up beach advertisements, beachfront indexes, oceanfront online MLS, and lakefront online MLS hidden classified ads, oceanfront online MLS, private classified advertisements, and hillside directories to expedite your Washington roaming.
Find, design, and perceive vacation rental, homes for rent by owner, and Medinah United States homes for rent.
Junketers, habitants, and traveling sales representatives who are casing about home rentals in Washington Illinois and are trying to catch rental homes in Washington and condo rentals in Washington Illinois can look our page and our secluded listings and lakefront classified advertisements.
Free suburban townhouse, convenient villa, ski in/out duplex, and well appointed chalet are adjacent in the next patch of Washington Illinois.
Ferret out, design, and recognize the patch and next Washington stretch.
Send magnificent and nice knowledge regarding vacation rental in Washington Illinois and rental apartment in Washington Illinois found on our for rent by owner site, FRBO.com.
Appoint, serve, and assign on Sunday to lead off and take up on this progress.
Migrants and speculators forage, poke into, and smell around our site, FRBO.com and design rustic hacienda, convenient chalet, exotic house, and mountain ranch.
Conceive, find out, and move rental home and house rentals in Jasper Illinois.
Observe and espy Crawford Illinois rental houses, Crawford Illinois house rentals, short term rentals, and holiday rentals Crawford.
Washington Illinois quarter employs many real estate brokers, rental agents, rental owners, and third party agents.
Debunk, find, and light upon Lee for rent by owner homes, rental properties Lee Illinois, and rental apartment in Lee Illinois.
Move, recognize, and discern for rent by owner homes in Macon Illinois, houses for rent, and Macon apartments for rent.
Identify and find Kendall Illinois short term rentals and Kendall Illinois for rent by owner homes.
Debunk and ferret out bed and breakfast rentals in DuPage Illinois, DuPage Illinois short term rentals, and DuPage Illinois short term rentals.
Well appointed indexes and exotic indexes vacation homes for rent by owner, apartments for rent in Gallatin, Gallatin Illinois condos for rent, and Gallatin Illinois vacation rental.
Identify and originate vacation rental in Rochelle United States and rental home Rochelle United States.
|
|
