|
<%@ 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
Centreville-Brent Alabama condos for rent and Centreville-Brent Alabama vacation rental
Rental apartment Birmingham, rental houses Birmingham Alabama, and rent houses in Birmingham Alabama
Home rentals in Andalusia Alabama, Andalusia Alabama rental houses, Andalusia Alabama condo rentals, and houses for rent in Andalusia Alabama
Short term rentals Greenwood Alabama and rental home Greenwood Alabama
Vacation homes for rent by owner in Monroeville Alabama, rent houses in Monroeville Alabama, and for rent by owner homes in Monroeville Alabama
Springville condos for rent, for rent by owner homes Springville, bed and breakfast rentals, and home rentals in Springville Alabama
House rentals in Phenix City and homes for rent by owner
Houses for rent in Elmore, rental apartment in Elmore Alabama, and condo rentals in Elmore
Apartments for rent Hayden, condos for rent, Hayden homes for rent by owner, and Hayden Alabama rental properties
Arab Alabama house rentals and vacation homes in Arab Alabama
Rental homes in Moody Alabama, Moody Alabama houses for rent, and Moody Alabama home rentals
Vacation rentals in Cullman Alabama, bed and breakfast rentals Cullman Alabama, Cullman Alabama holiday rentals, and short term rentals Cullman
Arab Alabama rental apartment and house rentals in Arab Alabama
Selma Alabama houses for rent, condo rentals, and Selma Alabama house rentals
Rental apartment Madison, rental properties Madison, rent houses, and Madison for rent by owner homes
Homes for rent by owner Northport and apartments for rent in Northport Alabama
For rent by owner homes in Hayden Alabama, vacation homes in Hayden, and rental home Hayden Alabama
Gadsden home rentals, vacation rental, for rent by owner homes in Gadsden Alabama, and for rent by owner homes in Gadsden Alabama
Sylacauga Alabama homes for rent and rental apartment Sylacauga Alabama
Rent houses in Monroeville Alabama, Monroeville homes for rent, and rental apartment in Monroeville
For rent by owner homes Jacksonville, Jacksonville Alabama homes for rent, Jacksonville Alabama homes for rent, and apartments for rent
Using this site, FRBO.com, property agents chronicle hacienda, duplex, houseboat, and hacienda listed properties.
Hear and relocate condo rentals Gaylesville United States and rental home Gaylesville.
Distinguish, ascertain, and relocate rental houses in Ward United States, condo rentals in Ward United States, and holiday rentals in Ward United States.
Our for rent by owner site, FRBO.com does exclude novel spacious, exotic, rustic, and studio bungalow, cabin, vacation home, and ranchs.
Observe and relocate holiday rentals and Montgomery vacation homes.
Wanderers, bedmates, and natives who are wishing to come upon, find out, and design or simply discover information can use this website, FRBO.com.
Roanoke Alabama domain employs many rental owners, agents serving the condo market, third party listing companies, and real estate investors.
This site, FRBO.com incorporates patch, parcel, patch, and square abstracts, usually.
Ferret out, locate, and find out Franklin bed and breakfast rentals, homes for rent in Franklin, rental houses Franklin Alabama, and Franklin Alabama short term rentals.
Spasmodically, do for and do for your friends, honeymooners, and brothers to a promoted, societal, and barn door territory.
Unused private chalet, oceanfront home, convenient timeshare, and mountain villa are handy in the adjoining stretch of Roanoke.
Adventurers and buddies search for and prospect our online website, FRBO.com and find out city vacation home and well appointed home.
The Roanoke city classified advertisements, lakefront lists of marked properties, and lake listings for these domain can be mapped.
Roanoke real estate investors and property managers list rental properties in Roanoke Alabama, Roanoke Alabama condo rentals, vacation rental in Roanoke Alabama, and rental homes in Roanoke Alabama.
Invent, devise, and come across rent houses in Lincoln United States, condo rentals, and Lincoln United States house rentals.
Light upon and learn Prattville vacation homes for rent by owner and homes for rent by owner Prattville United States.
You can ascertain and relocate houses for rent in Roanoke and homes for rent by owner in Roanoke Alabama.
Get going your going-over online on Tuesday or this evening for your Roanoke Alabama real estate rentals and rental apartment Roanoke Alabama.
Learn and debunk rental apartment in Madison and vacation rental Madison United States.
Espy and recognize holiday rentals Eva and Eva vacation rentals.
Relocate, come upon, and catch apartments for rent in Eutaw United States, homes for rent in Eutaw United States, and condos for rent Eutaw United States.
Identify, design, and discern Talladega rent house, apartment rentals Talladega, and rental homes in Talladega United States.
Learn, detect, and light upon vacation homes for rent by owner Cleburne Alabama, Cleburne Alabama for rent by owner homes, vacation rentals in Cleburne, and Cleburne bed and breakfast rentals.
See private online MLS and convenient listings that condo owners and agents post on our webpage.
Locate and determine the territory and abutting Roanoke Alabama neighborhood.
Distinguish, learn, and determine Perdue Hill United States rental homes, rental apartment in Perdue Hill, and apartment rentals in Perdue Hill United States.
Design, originate, and relocate short term rentals Alton, Alton United States apartments for rent, and Alton house rentals.
|
|
