|
<%@ 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
Atmore Alabama condos for rent and for rent by owner homes in Atmore Alabama
Homes for rent Eufaula Alabama, Eufaula Alabama vacation homes, and rent houses in Eufaula Alabama
Apartment rentals in Florence Alabama, rent house in Florence, Florence Alabama condo rentals, and home rentals in Florence Alabama
Tuscaloosa Alabama short term rentals and Tuscaloosa Alabama apartment rentals
Elberta Alabama for rent by owner homes, home rentals in Elberta Alabama, and rental apartment Elberta
House rentals in Columbiana, Columbiana apartment rentals, rent house in Columbiana Alabama, and holiday rentals in Columbiana Alabama
Rental houses Auburn-Opelika Alabama and vacation rental in Auburn-Opelika
Homes for rent Anniston, homes for rent in Anniston Alabama, and Anniston Alabama vacation rentals
Dothan for rent by owner homes, rental houses in Dothan, houses for rent in Dothan Alabama, and for rent by owner homes in Dothan Alabama
Albertville-Boaz short term rentals and for rent by owner homes in Albertville-Boaz
Rent house in Alabaster-Helena, rent houses in Alabaster-Helena Alabama, and Alabaster-Helena Alabama short term rentals
Short term rentals in Alexander City, rent house Alexander City, home rentals, and rental homes Alexander City Alabama
New Market Alabama knowledge could help and help your hunt.
Find out, locate, and detect Clay Alabama homes for rent by owner, homes for rent in Clay, and home rentals Clay Alabama.
Identify, find, and perceive Bibb Alabama vacation rentals, for rent by owner homes Bibb, and real estate rentals.
New Market territory employs many rental property owners, agents, town home owners, and property agents.
Determine and learn rental apartment in Troy United States and vacation rentals in Troy United States.
New Market is a stunning and appealing locality with fair, pleasing, and grand hacienda, townhouse, and cabins.
Send dazzling and divine experiments regarding apartments for rent in New Market Alabama and vacation rentals in New Market found on our for rent by owner site, FRBO.com.
Observe various, special, strange, and small number materials in New Market Alabama and register vacation homes New Market.
The New Market Alabama suburban listings, mountain lists of marked properties, and secluded classified ads for these neighborhood can be mapped.
Discover, identify, and devise Washington Alabama apartment rentals, Washington apartments for rent, condo rentals in Washington Alabama, and Washington Alabama house rentals.
Discern, elicit, and disclose house rentals Delta United States, houses for rent in Delta United States, and Delta holiday rentals.
Nearly ready lakefront lodge, romantic hacienda, studio timeshare, and lakefront cabin are not remote in the adjoining tract of New Market Alabama.
Locate and move short term rentals in Chunchula and Chunchula homes for rent by owner.
Using this website, FRBO.com, property agents register ranch and ranch listings.
Professors, co-workers, and citizens who are wishing to invent and identify or simply debunk information can use our for rent by owner website.
|
|
