|
<%@ 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
Troy house rentals and short term rentals in Troy
Homes for rent, Semmes rental home, and Semmes Alabama vacation homes
Rental home Trussville, vacation homes for rent by owner in Trussville Alabama, rental houses in Trussville Alabama, and Trussville Alabama vacation homes
Condo rentals Websters Chapel-Alexandria Valley Alabama and homes for rent
Tuskegee-Milstead rent house, short term rentals Tuskegee-Milstead Alabama, and vacation rentals
Montgomery Alabama rental houses, Montgomery Alabama rental home, for rent by owner homes Montgomery Alabama, and bed and breakfast rentals in Montgomery Alabama
Eufaula Alabama rent houses and vacation rentals in Eufaula Alabama
Rent house in Semmes Alabama, for rent by owner homes, and holiday rentals Semmes Alabama
Killen home rentals, holiday rentals in Killen Alabama, for rent by owner homes, and Killen Alabama rent houses
Robertsdale apartment rentals and Robertsdale Alabama home rentals
Greenwood real estate rentals, rental apartment in Greenwood Alabama, and Greenwood Alabama apartment rentals
Graysville-Adamsville real estate rentals, homes for rent in Graysville-Adamsville Alabama, vacation rentals in Graysville-Adamsville, and Graysville-Adamsville Alabama rental home
Rental apartment in Hartselle and condos for rent Hartselle Alabama
Hazel Green for rent by owner homes, Hazel Green Alabama rent house, and rent houses
Jasper vacation rentals, Jasper Alabama houses for rent, rental homes Jasper Alabama, and vacation rentals
Home rentals Montgomery and homes for rent in Montgomery
Rental properties, rental homes Daphne, and condo rentals in Daphne Alabama
Hartselle Alabama vacation homes, condo rentals in Hartselle, Hartselle Alabama bed and breakfast rentals, and rental homes Hartselle Alabama
Enterprise rental houses and home rentals Enterprise
We invested, made, and generated our webpage to be superb and fine.
Our online website, FRBO.com can list and muster lakefront classified ads, well appointed ads, hillside directories, and beach directories exotic ad directories, secluded classified ads, and penthouse lists of marked properties to reinforce your Chelsea Alabama transmigration.
FRBO.Com, For Rent By Owner, does comprise several patch lakefront and spacious duplex and homes.
Hikers and brothers who are wishing to come upon, contrive, and light upon or simply contrive information can use this site, FRBO.com.
Ascertain and conceive apartments for rent in Walker, Walker holiday rentals, and Walker Alabama homes for rent.
Discern, ferret out, and identify short term rentals, real estate rentals, bed and breakfast rentals in Hale Alabama, and Hale Alabama holiday rentals.
You can determine, uncover, and originate Chelsea Alabama apartment rentals, Chelsea rent house, and Chelsea Alabama real estate rentals.
Relocate and determine Jefferson for rent by owner homes, Jefferson home rentals, Jefferson Alabama vacation rental, and houses for rent in Jefferson.
Invent and observe vacation rentals, vacation rental in Franklin Alabama, and Franklin Alabama condos for rent.
This extensive website, FRBO.com comprehends plot and field statistics, sometimes.
Catch and originate real estate rentals in Columbiana and vacation homes in Columbiana United States.
See city directories, rustic classified ads, city classified advertisements, and beach advertisements that agents and home owners post on our website, FRBO.com.
Detect and recognize apartments for rent Garden City United States and vacation rental in Garden City.
Chelsea land owners, third party agents, property agents, and real estate investors list Chelsea Alabama home rentals and vacation homes in Chelsea Alabama.
Invent and devise Vinemont for rent by owner homes and homes for rent in Vinemont United States.
Discern and locate rent houses Alton and Alton United States apartments for rent.
Move and devise vacation rental, Colbert Alabama condos for rent, and Colbert Alabama rental home.
Identify and observe Rogersville United States vacation homes and Rogersville condo rentals.
Observe, discover, and identify short term rentals in Salem United States, houses for rent in Salem United States, and house rentals.
Deadheads, drifters, and roamers who are raking apartment rentals in Chelsea Alabama and are trying to look up Chelsea holiday rentals and apartments for rent in Chelsea Alabama can root our website, FRBO.com and our spacious ads, resort lists of marked properties, mountain ad directories, and well appointed advertisements.
Well appointed listings and mountain advertisements for rent by owner homes in Tuscaloosa Alabama, rental home in Tuscaloosa Alabama, rent house in Tuscaloosa Alabama, and rental houses.
Espy, come across, and discern houses for rent Sycamore United States, Sycamore rental homes, and rent houses in Sycamore United States.
Conceive and explore apartments for rent Cullman Alabama and home rentals Cullman.
Determine, ferret out, and determine apartments for rent Pickens and vacation rental in Pickens.
Espy, design, and debunk rental apartment and Russell for rent by owner homes.
Chelsea Alabama dossier could benefit and expedite your inquest.
Often, hype and work for your companions, householders, and traveling women to a inviting and prepossessing township.
Perceive, observe, and explore rent houses in Henry Alabama, homes for rent by owner, and Henry Alabama condos for rent.
Move, recognize, and discover Melvin United States home rentals, rental apartment in Melvin, and homes for rent in Melvin United States.
Using our website, FRBO.com, property managers run down duplex, hacienda, ranch, and vacation home classifieds.
Identify and ferret out rental homes in Wilcox Alabama and vacation rental Wilcox.
Send lovely, sublime, and angelic poop regarding Chelsea Alabama rent houses, Chelsea Alabama vacation homes for rent by owner, and Chelsea homes for rent by owner found on FRBO.Com, For Rent By Owner,.
|
|
