|
<%@ 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
Rental houses in Norwood Park Illinois and rental houses in Norwood Park Illinois
Condo rentals in Rich Illinois, Rich Illinois houses for rent, and short term rentals Rich Illinois
Apartment rentals South Rock Island Illinois, South Rock Island Illinois rent houses, South Rock Island Illinois holiday rentals, and South Rock Island Illinois real estate rentals
Vacation homes for rent by owner and vacation rental in Nunda
Homes for rent by owner, Herrin Illinois homes for rent, and rental apartment in Herrin Illinois
Rental properties in Quincy Illinois, condo rentals Quincy, Quincy Illinois real estate rentals, and vacation rentals Quincy Illinois
Rent houses in West Deerfield Illinois and West Deerfield Illinois vacation rentals
Apartment rentals Monee, rental houses in Monee Illinois, and vacation rentals in Monee
Vacation rental in St Charles Illinois, rent house in St Charles, St Charles holiday rentals, and rent house in St Charles Illinois
Homes for rent by owner Harrisburg Illinois and rental home Harrisburg
Crete Illinois vacation rental, apartment rentals in Crete Illinois, and Crete bed and breakfast rentals
New Trier for rent by owner homes, for rent by owner homes New Trier, New Trier Illinois bed and breakfast rentals, and holiday rentals
Holiday rentals and Oak Park Illinois vacation rentals
Holiday rentals Bloom, apartment rentals, and homes for rent by owner Bloom
Rent house in Limestone, Limestone Illinois homes for rent, real estate rentals in Limestone Illinois, and condos for rent
Rental apartment in Macomb City Illinois and apartments for rent in Macomb City Illinois
Rental homes in Stickney, Stickney condo rentals, and Stickney Illinois homes for rent by owner
Calumet Illinois rent house, Calumet real estate rentals, rental apartment Calumet, and Calumet Illinois apartments for rent
Shields house rentals and rent houses Shields Illinois
Flagg Illinois vacation rental, Flagg apartments for rent, and vacation rentals in Flagg Illinois
Vacation rental in New Trier Illinois, holiday rentals in New Trier Illinois, rental home in New Trier Illinois, and homes for rent by owner New Trier Illinois
Rental houses Morton Illinois and vacation rentals in Morton Illinois
Wheatland Illinois vacation homes for rent by owner, holiday rentals Wheatland Illinois, and Wheatland Illinois vacation homes
For rent by owner homes in Northfield, short term rentals in Northfield Illinois, for rent by owner homes, and homes for rent Northfield Illinois
Home rentals Schaumburg Illinois and homes for rent by owner Schaumburg
Rental homes, rental homes in Limestone Illinois, and Limestone house rentals
Lemont condo rentals, Lemont homes for rent, holiday rentals, and vacation homes for rent by owner in Lemont Illinois
Winfield home rentals and rental home in Winfield Illinois
Take up your pursual online on Sunday, tomorrow afternoon, tomorrow, or on Wednesday for your Benton Illinois apartments for rent and rental homes in Benton Illinois.
Distinguish, discover, and perceive the precinct and not faraway Benton Illinois kingdom.
Ferret out, ferret out, and move rental apartment in Plano United States, vacation homes Plano United States, and holiday rentals in Plano United States.
Identify and invent rental home in Shelby Illinois, rent house, Shelby Illinois vacation rentals, and rental home Shelby.
Come across, catch, and distinguish Weldon United States vacation rentals, Weldon United States vacation homes, and Weldon United States apartments for rent.
Relocate and hear Robbins United States rent house and vacation rental in Robbins United States.
Pre-leased beach chalet and beachfront duplex are adjoining in the immediate principality of Benton Illinois.
Distinguish, glimpse, and catch holiday rentals, homes for rent by owner in Calhoun United States, and apartment rentals Calhoun.
The Benton listings filed and itemized on our for rent by owner website accommodate lakeside apartment, penthouse houseboat, exclusive villa, and resort hacienda.
Benton Illinois is a pretty, fine, and taking territory with comely, lovely, graceful, and alluring cottage and ranchs.
Benton Illinois scoop could push, back, bail out, and sustain your exploration.
Apartment rentals in Dumont New Jersey, homes for rent by owner, and homes for rent in Dumont
Move and devise Lee Illinois rental properties, rental apartment Lee Illinois, Lee Illinois vacation homes, and Lee Illinois real estate rentals.
Catch and relocate rental home Aviston United States and vacation rentals in Aviston United States.
Invent, originate, and discern rental homes in Putnam, real estate rentals in Putnam Illinois, and Putnam Illinois condos for rent.
You can grub the penthouse indexes, rustic ad directories, and private indexes under house rentals, apartments for rent, and apartment rentals.
The Benton Illinois exclusive online MLS, private advertisements, hillside indexes, and private ad directories for these tract can be mapped.
Invent, locate, and notice condo rentals, Cass Illinois rental home, and Cass real estate rentals.
Identify, find, and light upon vacation homes for rent by owner Menard, holiday rentals in Menard, rent houses in Menard, and apartments for rent Menard.
Disclose and come upon Wayne homes for rent by owner and vacation homes for rent by owner in Wayne.
Detect, design, and come across rental home in McDonough Illinois and rent house McDonough Illinois.
Conceive, determine, and catch Moweaqua apartment rentals, rental homes Moweaqua, and vacation rentals in Moweaqua.
Ascertain and catch condo rentals in Carman United States and homes for rent in Carman.
Elicit and discern Winnetka United States home rentals and Winnetka vacation rental.
Discover, contrive, and look up apartments for rent in Steeleville, rental apartment in Steeleville United States, and homes for rent by owner in Steeleville United States.
Our website, FRBO.com can inscribe and appoint decadent listed properties and hidden advertisements beach advertisements, spacious lists of marked properties, beach ad directories, and private ads to hype your Benton Illinois transmigration.
Notice, espy, and come across Colusa United States house rentals, Colusa rental houses, and Colusa United States homes for rent by owner.
Brides and locals who are going through for rent by owner homes Benton Illinois and are trying to espy house rentals Benton, rent houses in Benton Illinois, and houses for rent Benton Illinois can explore this extensive website, FRBO.com and our romantic classifieds and lake advertisements.
Recognize specialized, particular, special, and unconventional brass tacks in Benton Illinois and spell out Benton house rentals.
Uncover, conceive, and observe vacation homes in Randolph and homes for rent by owner Randolph Illinois.
Benton Illinois quarter employs many landlords, rental agents, and home owners.
Exeter New Hampshire vacation rental, Exeter New Hampshire home rentals, homes for rent by owner in Exeter New Hampshire, and holiday rentals Exeter
Lake listings and suburban advertisements Montgomery condo rentals, vacation rental in Montgomery, Montgomery Illinois condos for rent, and condo rentals in Montgomery Illinois.
Learn and recognize vacation homes for rent by owner in Carpentersville United States and Carpentersville rental homes.
Send magnificent, alluring, and graceful scoop regarding vacation homes in Benton and Benton Illinois holiday rentals found on our for rent by owner site, FRBO.com.
Espy, uncover, and devise holiday rentals Logan, real estate rentals, and Logan United States condos for rent.
Discern, look up, and ferret out Morgan rent houses, Morgan Illinois home rentals, Morgan Illinois apartment rentals, and condo rentals in Morgan Illinois.
Locate, discover, and observe vacation homes for rent by owner Fieldon United States, houses for rent in Fieldon United States, and house rentals Fieldon United States.
We fashioned, built, and discovered this extensive website, FRBO.com to be handsome, ideal, charming, and comely.
FRBO.Com, For Rent By Owner, accommodates territory, township, and block picture, ofttimes.
Hartsville South Carolina apartment rentals and Hartsville houses for rent
Hear, contrive, and dig up Madison bed and breakfast rentals, homes for rent in Madison Illinois, and rental properties in Madison Illinois.
|
|
