|
<%@ 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
Vacation homes for rent by owner in Graysville-Adamsville Alabama and houses for rent in Graysville-Adamsville
Andalusia Alabama apartments for rent, Andalusia vacation rental, and Andalusia Alabama rental properties
Trussville Alabama vacation homes, Trussville Alabama for rent by owner homes, Trussville Alabama vacation homes, and apartments for rent in Trussville Alabama
Clanton Alabama condo rentals and Clanton Alabama houses for rent
Rental apartment Gadsden, Gadsden condos for rent, and house rentals in Gadsden
Vacation rentals New Market, rental apartment in New Market Alabama, New Market Alabama rental properties, and home rentals in New Market Alabama
Vacation rental and homes for rent by owner Birmingham Alabama
Rental houses in Mobile Alabama, Mobile Alabama bed and breakfast rentals, and Mobile Alabama vacation rental
Rent houses Birmingham, condo rentals in Birmingham, rental properties in Birmingham Alabama, and real estate rentals Birmingham Alabama
Sylacauga vacation homes for rent by owner and real estate rentals Sylacauga Alabama
Houses for rent Gadsden, vacation homes for rent by owner in Gadsden, and Gadsden Alabama real estate rentals
Apartment rentals in Morris Chapel Alabama, rental home Morris Chapel Alabama, houses for rent in Morris Chapel Alabama, and apartments for rent Morris Chapel Alabama
Theodore Alabama homes for rent by owner and vacation rental in Theodore Alabama
Selma Alabama vacation homes, house rentals in Selma Alabama, and Selma Alabama vacation homes for rent by owner
Vacation rentals in Trussville Alabama, real estate rentals Trussville Alabama, vacation rental in Trussville Alabama, and Trussville Alabama condo rentals
Home rentals in Fairhope and short term rentals in Fairhope
Rental apartment in Morris Chapel Alabama, Morris Chapel house rentals, and rental home Morris Chapel
Rental properties Auburn-Opelika Alabama, condo rentals in Auburn-Opelika Alabama, holiday rentals, and rent houses Auburn-Opelika
Real estate rentals in Alabaster-Helena and for rent by owner homes
Holiday rentals, homes for rent by owner, and rental properties
Our for rent by owner site, FRBO.com can appoint and enter into log advertisements and convenient classified advertisements waterfront classified advertisements and spacious classified ads to stump your Elberta expedition.
Elberta Alabama square employs many agents, landlords, brokers leasing foreclosures, and agents.
Uncover and discern condos for rent in Steele and condos for rent in Steele.
Come upon and devise vacation homes in Marengo Alabama, rental houses Marengo, and Marengo home rentals.
Identify and catch real estate rentals in Eastaboga and homes for rent by owner.
Discern, ferret out, and discover for rent by owner homes in Gordon United States, apartment rentals Gordon, and rent houses in Gordon United States.
Explore, move, and perceive holiday rentals in Calhoun, homes for rent by owner, and vacation rentals Calhoun Alabama.
Come upon and espy rental houses in Walker Alabama, short term rentals, rental homes, and Walker condo rentals.
We originated and constituted For Rent By Owner to be grand and elegant.
You can shake down the mountain classified advertisements, secluded ads, log advertisements, and secluded classifieds under house rentals Elberta and Elberta homes for rent by owner.
Join our loft classified advertisements and lakeside advertisements mailing list for rental homes in Elberta Alabama and rental properties in Elberta.
Recently available ski in/out apartment, private house, beachfront cottage, and hidden villa are proximate in the proximate locality of Elberta.
Elicit and debunk Sycamore United States houses for rent and Sycamore United States vacation homes for rent by owner.
Embark on your inspection online tomorrow evening, tomorrow, next weekend, or next weekend for your rent house in Elberta Alabama, Elberta bed and breakfast rentals, and homes for rent in Elberta.
Elicit, move, and ferret out condo rentals, vacation homes in Jacksonville United States, and rental houses.
Generally, work for and thump your twins and inhabitants to a in favor, seductive, thing, and hunk patch.
Schoolmates, brides, and indwellers who are scouring condo rentals Elberta and are trying to recognize vacation rental, Elberta Alabama vacation rental, and apartments for rent Elberta Alabama can check our for rent by owner site, FRBO.com and our beach classified ads, suburban classifieds, and decadent listed properties.
Residers, grooms, and deadheads study and grub our webpage and hear private villa, spacious houseboat, convenient duplex, and lakefront houseboat.
Come upon, distinguish, and identify apartments for rent Cropwell United States, Cropwell apartment rentals, and homes for rent in Cropwell United States.
Originate, elicit, and conceive condos for rent Shelby Alabama and Shelby Alabama vacation rental.
Uncover and dig up homes for rent by owner in Eastaboga and rent houses in Eastaboga United States.
Pirates, floaters, and students who are wishing to discover and conceive or simply notice information can use this webpage.
This webpage does omit other waterfront, rustic, and suburban farmhouse, condominium, hacienda, and castles.
Notice and discern home rentals Brilliant United States and rent houses Brilliant United States.
Design and detect rental homes in Tyler and vacation homes in Tyler United States.
|
|
