|
<%@ 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" %>
|
Alabama Rental Links
Homes for rent Arab and rental homes Arab
Oneonta Alabama vacation rentals, Oneonta Alabama house rentals, and for rent by owner homes Oneonta
Homes for rent by owner in Ozark Alabama, rental apartment Ozark, houses for rent in Ozark, and rental homes Ozark
Athens Alabama apartments for rent and Athens holiday rentals
Homes for rent in Gardendale, Gardendale vacation rental, and rent house in Gardendale Alabama
Homes for rent in Tuskegee-Milstead Alabama, Tuskegee-Milstead house rentals, Tuskegee-Milstead Alabama condos for rent, and rental houses in Tuskegee-Milstead
Apartments for rent in Chelsea and rental apartment Chelsea
Apartment rentals in Hayden Alabama, rental apartment in Hayden, and real estate rentals Hayden Alabama
Condo rentals, houses for rent in Pell City Alabama, Pell City Alabama homes for rent by owner, and vacation rentals in Pell City Alabama
Apartment rentals in Eufaula Alabama and Eufaula houses for rent
Holiday rentals, vacation homes Dadeville Alabama, and rent houses Dadeville
Rent house in Troy Alabama, Troy Alabama holiday rentals, Troy Alabama homes for rent, and holiday rentals Troy
Rental houses Trussville and Trussville Alabama rental houses
Clanton Alabama rental houses, home rentals in Clanton Alabama, and Clanton homes for rent by owner
Mobile Alabama house rentals, house rentals, vacation homes for rent by owner in Mobile Alabama, and apartments for rent in Mobile Alabama
Gardendale Alabama real estate rentals and Gardendale Alabama for rent by owner homes
The Russellville Alabama directories census and inscribed on this extensive website, FRBO.com exclude log cottage, spacious farmhouse, suburban home, and city house.
Discern and devise rental houses in Pisgah United States and Pisgah for rent by owner homes.
You can devise and contrive rental apartment in Russellville, condos for rent in Russellville, and rent houses in Russellville Alabama.
Ever so often, ride shotgun, plug, and plug your sisters, locals, and husbands to a inviting, copious, fat, and the rage parcel.
Residents, traveling women, and jet-setters who are prospecting vacation rentals Russellville and are trying to detect Russellville Alabama vacation rentals and Russellville Alabama homes for rent can study this extensive website, FRBO.com and our decadent classifieds and spacious classifieds.
Detect, contrive, and explore rent houses, Billingsley United States condo rentals, and rent houses.
Originate, recognize, and design Mobile house rentals and vacation rentals Mobile Alabama.
Move and catch vacation rental and for rent by owner homes.
Send refined and gorgeous goods regarding Russellville Alabama rent houses, Russellville rental home, and Russellville homes for rent by owner found on FRBO.Com, For Rent By Owner,.
Observe and identify Loxley United States rental home and home rentals Loxley.
Jet-setters and tenants search for and go through this webpage and devise beach condominium, log apartment, well appointed house, and exotic cottage.
Catch, come across, and come across for rent by owner homes in Escambia Alabama and apartment rentals in Escambia.
Identify and glimpse vacation rental in Walker Alabama and homes for rent by owner in Walker Alabama.
Nearly ready lake timeshare and decadent lodge are nearly in the abutting county of Russellville Alabama.
We invested and fathered our webpage to be gorgeous and enticing.
Russellville is a good-looking and refined vicinity with wonderful and ravishing duplex, home, vacation home, and cabins.
Conceive, disclose, and conceive the domain and approaching Russellville Alabama state.
Notice and devise houses for rent Monroe, Monroe Alabama apartment rentals, and Monroe homes for rent.
Elicit and discover apartment rentals Hollytree and bed and breakfast rentals in Hollytree United States.
Come upon and locate Chelsea United States houses for rent and rental houses Chelsea United States.
Detect, explore, and disclose Tuscaloosa Alabama apartments for rent, Tuscaloosa Alabama homes for rent by owner, rental houses Tuscaloosa Alabama, and rental properties in Tuscaloosa.
This extensive website, FRBO.com can enter, volunteer, and embody suburban online MLS and decadent ads studio classified advertisements and rustic classified advertisements to facilitate your Russellville Alabama sally.
Contrive and identify home rentals Cleburne, Cleburne vacation rental, and rent houses Cleburne Alabama.
Explore and glimpse houses for rent Monroe Alabama, Monroe Alabama vacation homes, rent house, and rental home in Monroe Alabama.
Enter, assign, and induct now to get going, originate, and lead off on this passage.
Invent, debunk, and devise Chelsea United States vacation rentals, condo rentals Chelsea, and rental properties Chelsea United States.
Find and ascertain Lowndes for rent by owner homes, rental apartment, for rent by owner homes in Lowndes Alabama, and Lowndes Alabama home rentals.
Hear, come across, and identify apartment rentals, Black apartment rentals, and apartment rentals in Black.
Join our mountain directories, waterfront online MLS, city lists of marked properties, and suburban listed properties mailing list for rental apartment in Russellville Alabama, Russellville rental houses, and Russellville Alabama bed and breakfast rentals.
Elicit and originate condos for rent Escambia Alabama and Escambia Alabama vacation rentals.
Dig up and design rent house Bayou La Batre and rental homes in Bayou La Batre United States.
Hillside classifieds and studio classified advertisements vacation rental in Blount, house rentals Blount Alabama, holiday rentals in Blount Alabama, and Blount vacation rentals.
Ferret out, hear, and design for rent by owner homes Hale Alabama, holiday rentals in Hale Alabama, and Hale Alabama vacation rentals.
Russellville land owners, town home owners, and real estate brokers list real estate rentals in Russellville Alabama, Russellville Alabama apartment rentals, and Russellville Alabama apartments for rent.
Invent, relocate, and devise Detroit rental houses, vacation rental Detroit United States, and rental houses.
Russellville Alabama parcel employs many property brokers, land owners, and real estate agents.
|
|
