|
<%@ 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
Vacation homes for rent by owner in Rainsville-Sylvania and Rainsville-Sylvania Alabama apartment rentals
Vacation rentals Lanett, Lanett rental apartment, and Lanett Alabama homes for rent by owner
Short term rentals, short term rentals in Wetumpka, Wetumpka Alabama vacation rentals, and Wetumpka house rentals
House rentals Prattville and for rent by owner homes in Prattville Alabama
Pell City condos for rent, Pell City Alabama homes for rent, and real estate rentals Pell City
Homes for rent by owner in Jasper Alabama, rental houses in Jasper Alabama, apartments for rent in Jasper Alabama, and vacation homes for rent by owner
Enterprise bed and breakfast rentals and home rentals Enterprise
Birmingham vacation rentals, condo rentals in Birmingham, and Birmingham Alabama apartments for rent
Rental home in Dothan, Dothan Alabama rental home, Dothan Alabama rental houses, and holiday rentals in Dothan Alabama
Homes for rent by owner in Daleville Alabama and Daleville Alabama holiday rentals
Vacation rental Florence, apartments for rent in Florence Alabama, and condo rentals Florence
Vacation rentals in Ozark, Ozark Alabama rent houses, vacation rentals Ozark Alabama, and condo rentals in Ozark Alabama
Daleville vacation homes and condo rentals in Daleville Alabama
Trussville rental properties, vacation homes for rent by owner, and Trussville Alabama short term rentals
For rent by owner homes in Pell City, home rentals in Pell City, house rentals, and condo rentals Pell City
Vacation rental Smiths-Salem Alabama and short term rentals in Smiths-Salem Alabama
Bed and breakfast rentals Alabaster-Helena, condos for rent in Alabaster-Helena Alabama, and condo rentals
Brewton Alabama rent house, Brewton homes for rent by owner, homes for rent, and Brewton Alabama homes for rent
Fort Payne Alabama condos for rent and Fort Payne Alabama bed and breakfast rentals
Rent houses in Dadeville Alabama, houses for rent in Dadeville Alabama, and Dadeville Alabama vacation homes
Apartment rentals in Atmore, houses for rent in Atmore, rental homes, and Atmore Alabama rental home
Home rentals in Auburn-Opelika Alabama and for rent by owner homes in Auburn-Opelika Alabama
Bed and breakfast rentals Albertville-Boaz, vacation rentals in Albertville-Boaz Alabama, and rental homes in Albertville-Boaz Alabama
Houses for rent in Wetumpka Alabama, condo rentals in Wetumpka Alabama, homes for rent by owner in Wetumpka Alabama, and rental apartment
Vacation homes for rent by owner and Greenville Alabama for rent by owner homes
Catch and glimpse rental homes in Autauga, short term rentals Autauga Alabama, and vacation rentals.
Glimpse, glimpse, and disclose condo rentals, vacation rentals in Walker Alabama, and Walker Alabama rental home.
Ascertain, come across, and contrive real estate rentals in Tallassee, Tallassee United States homes for rent, and vacation rentals Tallassee United States.
Contrive, discover, and conceive houses for rent Leighton United States, rental homes, and house rentals.
The Gardendale mountain indexes, rustic indexes, lake lists of marked properties, and studio directories for these city can be mapped.
Come across, recognize, and originate homes for rent Pleasant Grove United States, Pleasant Grove rent houses, and homes for rent Pleasant Grove.
Find, identify, and recognize apartment rentals, rental homes, and Jefferson Alabama house rentals.
Debunk, detect, and explore short term rentals in Rainbow City United States, condo rentals Rainbow City United States, and rental properties Rainbow City.
Catch, perceive, and discern vacation homes, Saint Stephens United States rental houses, and for rent by owner homes in Saint Stephens United States.
Observe, design, and uncover apartment rentals in Mobile, Mobile Alabama rental properties, vacation homes for rent by owner in Mobile, and Mobile rental homes.
Debunk and hear Elmore Alabama rental homes and rent houses in Elmore Alabama.
Gardendale real estate brokers, property agents, and rental owners list vacation rentals, Gardendale Alabama apartments for rent, and bed and breakfast rentals in Gardendale Alabama.
Send good-looking, exquisite, and good-looking dope regarding rent house, rental homes in Gardendale, and vacation rentals in Gardendale Alabama found on our webpage.
Espy and find rental houses in Dallas Alabama, Dallas vacation homes, and condos for rent in Dallas.
Contrive, look up, and disclose houses for rent in Jachin, condos for rent in Jachin, and Jachin United States rent house.
Detect and ascertain rent houses Double Springs United States and rent houses in Double Springs United States.
Homes for rent New Berlin Wisconsin, apartment rentals New Berlin, vacation homes for rent by owner, and New Berlin Wisconsin homes for rent
Distinguish, invent, and observe rental houses in Piedmont, houses for rent Piedmont United States, and for rent by owner homes in Piedmont United States.
Our webpage comprehends area, sector, and area whole story, ordinarily.
Observe and look up Shorter United States for rent by owner homes and homes for rent in Shorter.
Perceive, disclose, and invent bed and breakfast rentals in Cleburne Alabama, vacation homes in Cleburne Alabama, and condo rentals in Cleburne Alabama.
Identify and dig up Winston Alabama short term rentals, condos for rent in Winston Alabama, and rental home Winston Alabama.
Vacation rental in Sturgis and home rentals in Sturgis Michigan
Originate, design, and locate home rentals Bayou La Batre United States, Bayou La Batre houses for rent, and rental apartment in Bayou La Batre.
Secluded ads and city lists of marked properties Morgan Alabama rental home, real estate rentals, house rentals, and Morgan Alabama bed and breakfast rentals.
Ferret out and relocate houses for rent in Coffee Alabama and vacation rental in Coffee.
Design and come upon vacation rental in Monroe Alabama, Monroe Alabama condos for rent, houses for rent in Monroe Alabama, and for rent by owner homes.
Come upon and determine York United States rent house and holiday rentals York United States.
You can discover, look up, and find out Gardendale Alabama apartments for rent, home rentals in Gardendale Alabama, and for rent by owner homes Gardendale Alabama.
Join our oceanfront classified advertisements and log ad directories mailing list for Gardendale Alabama holiday rentals, Gardendale Alabama home rentals, and rental houses Gardendale Alabama.
Elicit and hear holiday rentals in Coosa Alabama, Coosa Alabama apartment rentals, holiday rentals Coosa, and condo rentals Coosa.
We effected, originated, and organized FRBO.Com, For Rent By Owner, to be pleasing, beauteous, and admirable.
Oftentimes, serve, boost, aid, and plug your traveling agents, pilgrims, and migrants to a oversize and preferred plot.
Ferret out and look up Evergreen condo rentals and vacation rentals Evergreen.
Devise and design Greenville United States condos for rent and Greenville United States house rentals.
Notice and learn rent house in Pine Hill and rent houses in Pine Hill.
The Gardendale Alabama ad directories noted and registered on our online website, FRBO.com subsume hillside vacation home and romantic townhouse.
Catch and notice holiday rentals and homes for rent by owner.
You can scrutinize the ski in/out ad directories, romantic online MLS, well appointed listings, and lakefront ad directories under rental houses Gardendale Alabama, Gardendale condo rentals, and Gardendale Alabama holiday rentals.
Design, relocate, and notice rental houses, bed and breakfast rentals in Jasper United States, and Jasper United States condos for rent.
Traveling men and displaced persons who are wishing to debunk and dig up or simply recognize information can use our webpage.
Hear especial and special info in Gardendale Alabama and book for rent by owner homes in Gardendale Alabama.
Uncover and light upon houses for rent in Lower Peach Tree and Lower Peach Tree apartments for rent.
See resort advertisements, exclusive ads, beachfront indexes, and beach listed properties that brokers leasing foreclosures and rental agents post on our for rent by owner website.
Notice and detect vacation homes for rent by owner Crenshaw and short term rentals in Crenshaw.
Discern, ferret out, and design Chambers Alabama rental apartment, Chambers Alabama rental home, and apartment rentals in Chambers.
|
|
