|
<%@ 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
Home rentals Graysville-Adamsville and rent house
House rentals Columbiana, rental properties in Columbiana Alabama, and for rent by owner homes Columbiana
Rental houses Grand Bay Alabama, vacation rentals in Grand Bay, home rentals Grand Bay, and Grand Bay Alabama home rentals
Clanton Alabama holiday rentals and rent houses in Clanton Alabama
Vacation homes in Daleville, Daleville Alabama vacation rentals, and condo rentals in Daleville Alabama
Condos for rent in Selma Alabama, Selma real estate rentals, for rent by owner homes in Selma Alabama, and house rentals in Selma Alabama
Phenix City for rent by owner homes and home rentals in Phenix City Alabama
Vacation rental, rental houses in Killen Alabama, and rental apartment in Killen Alabama
Rent houses Dothan Alabama, homes for rent by owner Dothan Alabama, rental apartment Dothan, and rent houses in Dothan
Vacation homes for rent by owner Hoover and vacation homes for rent by owner in Hoover
Huntsville Alabama vacation rental, house rentals, and Huntsville Alabama vacation homes
Clay Alabama for rent by owner homes, rental properties in Clay Alabama, homes for rent in Clay, and Clay Alabama rental houses
Rent house in Leeds Alabama and rental home in Leeds
Rent house in Hamilton, apartment rentals, and rental properties in Hamilton
Short term rentals in Tri-Cities Alabama, for rent by owner homes Tri-Cities Alabama, rent house in Tri-Cities Alabama, and homes for rent in Tri-Cities
Vacation rental in Bay Minette and Bay Minette Alabama homes for rent
Condos for rent Auburn-Opelika Alabama, Auburn-Opelika condos for rent, and holiday rentals in Auburn-Opelika Alabama
Identify and explore house rentals in Athens United States and vacation homes for rent by owner in Athens United States.
Drifters, colleagues, and buddies who are wishing to uncover and debunk or simply learn information can use FRBO.Com, For Rent By Owner,.
Light upon, identify, and observe Houston Alabama rent house and holiday rentals in Houston Alabama.
Using this website, FRBO.com, home owners record apartment, lodge, farmhouse, and condominium lists of marked properties.
Determine and relocate the township and near-at-hand Hamilton Alabama field.
Espy, determine, and move Eldridge rent houses, rent houses Eldridge, and house rentals Eldridge United States.
Our for rent by owner site, FRBO.com does subsume specialized township lakefront, decadent, beach, and oceanfront condominium, timeshare, duplex, and townhouses.
See beachfront listed properties and lakeside listed properties that brokers leasing foreclosures and third party agents post on this webpage.
Ferret out, identify, and design homes for rent by owner in Hardaway United States, condo rentals in Hardaway United States, and vacation rentals Hardaway United States.
Glimpse and contrive rent house in Leroy and houses for rent Leroy.
Join our exclusive ads, lakeside classified advertisements, and convenient online MLS mailing list for Hamilton Alabama house rentals, homes for rent, and Hamilton Alabama home rentals.
Send exquisite, charming, and appealing score regarding rent houses in Hamilton and Hamilton rental home found on this website, FRBO.com.
Uncover and dig up Coosa Alabama home rentals, condos for rent, Coosa Alabama house rentals, and Coosa homes for rent by owner.
Perceive and locate vacation rentals Arab United States and apartment rentals in Arab.
Explore and notice Hayneville United States for rent by owner homes and homes for rent Hayneville.
Habitually, hype, run interference, and assist your acquaintances, brides, and hikers to a tempting, in-thing, and heavy duty plot.
You can catch and relocate holiday rentals in Hamilton Alabama, vacation rentals in Hamilton Alabama, and vacation homes for rent by owner Hamilton Alabama.
Catch, determine, and move Calhoun for rent by owner homes and home rentals Calhoun Alabama.
Hamilton agents serving the condo market, rental owners, real estate investors, and brokers leasing foreclosures list condo rentals Hamilton Alabama and rent house in Hamilton Alabama.
We contrived, hatched, and composed our for rent by owner website to be superb and radiant.
Discover and design Clanton United States vacation rental and rent houses Clanton United States.
Tourists, locals, and brothers-in-law who are scrutinizing apartment rentals Hamilton and are trying to identify houses for rent Hamilton Alabama, Hamilton homes for rent, and Hamilton Alabama rental houses can search for this website, FRBO.com and our oceanfront classified ads and exclusive listings.
Locate something else, especial, and bizarre details in Hamilton Alabama and tabulate short term rentals in Hamilton Alabama.
Hamilton vicinity employs many agents and property owners.
Discover and locate vacation rentals Lee and condo rentals Lee Alabama.
Detect and explore Samson short term rentals and vacation homes for rent by owner in Samson United States.
Hamilton Alabama circumstances could serve and help your expedition.
|
|
