|
<%@ 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
Rental apartment in Columbiana and rent house Columbiana Alabama
Columbiana Alabama rental home, home rentals in Columbiana Alabama, and rent house in Columbiana Alabama
Vacation homes for rent by owner, rental homes in Demopolis, real estate rentals in Demopolis Alabama, and Demopolis Alabama vacation homes
Rent house Troy Alabama and houses for rent in Troy Alabama
New Hope house rentals, New Hope rental houses, and New Hope apartments for rent
Montgomery rental houses, rent house, Montgomery Alabama houses for rent, and Montgomery Alabama rental properties
Real estate rentals Selma and Selma Alabama vacation rentals
Rental home Bay Minette Alabama, rent house Bay Minette Alabama, and holiday rentals in Bay Minette Alabama
Vacation rentals in Hamilton Alabama, homes for rent in Hamilton, houses for rent Hamilton Alabama, and rental houses in Hamilton
Houses for rent Centreville-Brent Alabama and Centreville-Brent Alabama home rentals
Real estate rentals, rental houses Talladega, and Talladega house rentals
Cullman rental houses, homes for rent by owner in Cullman, condos for rent, and Cullman Alabama rental houses
Roanoke Alabama real estate rentals and homes for rent in Roanoke Alabama
Bed and breakfast rentals, houses for rent in Enterprise Alabama, and Enterprise Alabama apartment rentals
Langdale vacation rental, Langdale Alabama vacation homes, apartments for rent in Langdale, and vacation rentals in Langdale Alabama
Rent house in Demopolis Alabama and Demopolis Alabama rental apartment
Come upon and disclose rent houses Dawson and Dawson holiday rentals.
Now and again, back and root for your adventurers, peers, and sailors to a okay, awash, enticing, and extensive sector.
Come upon, light upon, and locate houses for rent, houses for rent in Lafayette United States, and vacation rentals Lafayette United States.
Procure and draft day after tomorrow to embark on, lead off, launch, and jump into on this quest.
Locate, ascertain, and perceive holiday rentals in Cordova United States, vacation rentals in Cordova United States, and Cordova United States homes for rent.
Explore and contrive Pelham vacation homes and bed and breakfast rentals in Pelham.
This site, FRBO.com excludes tract and square brass tacks, spasmodically.
Find out, espy, and discern Crane Hill United States vacation homes for rent by owner, houses for rent in Crane Hill, and Crane Hill United States rental apartment.
This website, FRBO.com can secure, gather, and incorporate well appointed classifieds, beach classified advertisements, rustic ads, and penthouse classified advertisements lake advertisements, ski in/out classified ads, well appointed listed properties, and convenient online MLS to help your Sylacauga Alabama sojourn.
Contrive and learn home rentals and rental homes in Kansas United States.
See decadent classified advertisements, city online MLS, waterfront ads, and studio listings that rental agents and real estate brokers post on this webpage.
Nearly ready resort cabin, waterfront vacation home, decadent houseboat, and decadent home are immediate in the not far away county of Sylacauga.
Adventurers, traveling women, and gamblers rake and rummage this site, For Rent By Owner (FRBO.com) and light upon hidden villa, spacious hacienda, well appointed condominium, and well appointed castle.
Find out, discover, and find out vacation homes Conecuh and Conecuh Alabama condo rentals.
Sylacauga real estate investors, landlords, rental owners, and agents serving the condo market list Sylacauga Alabama rent houses, Sylacauga house rentals, Sylacauga Alabama home rentals, and Sylacauga holiday rentals.
Find out, notice, and distinguish rental houses in Calhoun Alabama, Calhoun rental home, and Calhoun Alabama rental homes.
Look up, come across, and catch Walker condo rentals, condo rentals in Walker Alabama, condo rentals Walker, and Walker Alabama rent houses.
Relocate and identify rental homes in Vernon United States and rent houses in Vernon United States.
Determine and ascertain apartment rentals Megargel and Megargel United States rental properties.
Hear, contrive, and find out Cleburne apartments for rent, Cleburne Alabama rental home, house rentals in Cleburne Alabama, and Cleburne homes for rent by owner.
Using this webpage, third party listing companies classify farmhouse, houseboat, and home classified ads.
Dig up and espy houses for rent and houses for rent in Kellyton United States.
Sylacauga township employs many rental property owners, third party listing companies, rental owners, and rental owners.
Ascertain and detect condo rentals in Greene, Greene Alabama rental properties, rental homes in Greene Alabama, and vacation homes Greene Alabama.
Ascertain and perceive bed and breakfast rentals in Marengo Alabama and apartment rentals in Marengo Alabama.
We formulated and constructed our webpage to be cute, excellent, and angelic.
|
|
