|
<%@ 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
Apartment rentals in Foley and vacation homes Foley
Bed and breakfast rentals in Bay Minette, Bay Minette Alabama condos for rent, and bed and breakfast rentals Bay Minette Alabama
Oneonta houses for rent, Oneonta Alabama rental apartment, Oneonta Alabama for rent by owner homes, and condo rentals in Oneonta Alabama
For rent by owner homes Graysville-Adamsville and vacation rental in Graysville-Adamsville Alabama
Home rentals in Ozark, Ozark rental homes, and Ozark Alabama rental home
Houses for rent Elberta Alabama, houses for rent Elberta, Elberta house rentals, and for rent by owner homes in Elberta Alabama
Homes for rent by owner in Auburn-Opelika Alabama and Auburn-Opelika Alabama rent house
Vacation homes for rent by owner in Centreville-Brent Alabama, rent house Centreville-Brent, and rental homes in Centreville-Brent
Andalusia condos for rent, rental apartment, vacation rentals Andalusia Alabama, and Andalusia Alabama for rent by owner homes
Real estate rentals in Foley and Foley Alabama real estate rentals
Rental apartment in Troy, bed and breakfast rentals Troy Alabama, and vacation rental
Home rentals in Fairhope, home rentals Fairhope, house rentals in Fairhope Alabama, and rental apartment in Fairhope
Apartments for rent and vacation homes for rent by owner
Houses for rent, Hoover Alabama homes for rent by owner, and homes for rent by owner Hoover
Apartments for rent, Moody Alabama condos for rent, rental apartment, and Moody Alabama apartment rentals
Homes for rent in Oneonta and Oneonta Alabama homes for rent
House rentals Clanton Alabama, rent houses, and house rentals
Apartment rentals Hayden, house rentals, home rentals Hayden Alabama, and Hayden Alabama rental homes
Floaters and grooms who are wishing to uncover and conceive or simply dig up information can use For Rent By Owner.
Using our online website, FRBO.com, condo owners register duplex, bungalow, vacation home, and bungalow listed properties.
Elicit, look up, and identify rent house in Houston Alabama, homes for rent in Houston, and Houston Alabama rental homes.
Conceive, dig up, and hear vacation rentals in Toney United States, rental properties Toney, and vacation rental Toney.
Hear, glimpse, and light upon Vinegar Bend bed and breakfast rentals, Vinegar Bend United States apartments for rent, and vacation rentals in Vinegar Bend United States.
We procreated and designed our website, FRBO.com to be good-looking, angelic, angelic, and dazzling.
Recognize, devise, and observe condo rentals Henry Alabama, vacation homes for rent by owner Henry, Henry rent house, and vacation homes for rent by owner in Henry Alabama.
Suburban classified advertisements and decadent classified ads rental homes De Kalb Alabama, for rent by owner homes De Kalb, De Kalb Alabama rental houses, and vacation homes for rent by owner in De Kalb Alabama.
Disclose and determine home rentals in Clarke Alabama, rent houses in Clarke Alabama, and Clarke rental houses.
Ferret out and light upon condos for rent Butler Alabama and Butler for rent by owner homes.
Ferret out and ascertain condo rentals Pike Alabama and rental homes in Pike Alabama.
Contrive, design, and notice Calhoun house rentals and homes for rent by owner in Calhoun Alabama.
Observe, move, and dig up condos for rent in Fayette, apartment rentals in Fayette Alabama, Fayette vacation homes, and vacation rentals in Fayette Alabama.
Dothan Alabama precinct employs many rental owners, property owners, rental agents, and rental agents.
Devise novel and novel circumstances in Dothan Alabama and classify Dothan Alabama rent houses.
Come across, observe, and discern condos for rent, apartments for rent in Auburn University, and rental home in Auburn University.
Dothan is a radiant and appealing section with resplendent and delightful cabin and villas.
Originate, glimpse, and dig up homes for rent by owner Pell City United States, vacation rentals in Pell City, and homes for rent.
Glimpse, design, and learn vacation rental in Chilton Alabama, rental homes, and short term rentals in Chilton Alabama.
Elicit and relocate Detroit houses for rent and Detroit house rentals.
This website, FRBO.com does arrange some parcel spacious and penthouse home and cabins.
|
|
