|
<%@ 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
Houses for rent and rental properties in Sylacauga Alabama
Real estate rentals in Bay Minette, homes for rent, and rent houses Bay Minette Alabama
Rent houses, vacation homes for rent by owner Hazel Green Alabama, Hazel Green Alabama real estate rentals, and rental apartment in Hazel Green Alabama
Vacation homes for rent by owner in Guntersville and Guntersville Alabama short term rentals
Houses for rent Decatur, short term rentals in Decatur, and Decatur Alabama short term rentals
Decatur apartments for rent, Decatur Alabama short term rentals, rental houses Decatur, and for rent by owner homes in Decatur Alabama
Birmingham Alabama homes for rent and rental properties
House rentals in Monroeville, Monroeville Alabama condo rentals, and condo rentals in Monroeville Alabama
Vacation homes for rent by owner in Decatur, rental homes Decatur, apartment rentals in Decatur Alabama, and homes for rent by owner Decatur Alabama
Chelsea rent houses and vacation homes for rent by owner Chelsea Alabama
Chelsea apartments for rent, Chelsea apartment rentals, and Chelsea Alabama home rentals
Rental home, Semmes Alabama rental home, condos for rent in Semmes Alabama, and homes for rent Semmes
Vacation homes for rent by owner Greenville Alabama and condo rentals in Greenville Alabama
Bay Minette Alabama apartment rentals, rent house Bay Minette Alabama, and house rentals in Bay Minette Alabama
Homes for rent in Selma Alabama, rent houses, vacation rentals in Selma Alabama, and Selma short term rentals
Rent house in Jacksonville Alabama and Jacksonville Alabama homes for rent by owner
Rental properties in Brewton, apartment rentals in Brewton Alabama, and Brewton Alabama home rentals
Mobile Alabama rent houses, Mobile real estate rentals, vacation rentals, and Mobile Alabama condo rentals
Rental houses Hamilton Alabama and Hamilton Alabama condos for rent
Graysville-Adamsville Alabama house rentals, homes for rent Graysville-Adamsville, and bed and breakfast rentals in Graysville-Adamsville Alabama
Bed and breakfast rentals in Lanett Alabama, Lanett Alabama apartment rentals, rental apartment in Lanett Alabama, and Lanett vacation homes for rent by owner
Vacation rentals in Jasper Alabama and rental apartment Jasper Alabama
Home rentals in Springville Alabama, vacation homes for rent by owner in Springville Alabama, and Springville Alabama apartment rentals
Discover and ferret out Henry Alabama condos for rent, Henry apartment rentals, and rental homes.
Open your quest online next week, tonight, or this week for your short term rentals and bed and breakfast rentals in Elmore Alabama.
Discover and dig up Geneva Alabama houses for rent and vacation homes in Geneva Alabama.
You can inquire the loft classified ads, exotic classified ads, decadent indexes, and studio listed properties under Elmore Alabama apartments for rent, real estate rentals Elmore, and homes for rent by owner.
Uncover and invent Choctaw Alabama vacation homes for rent by owner, apartments for rent in Choctaw, and Choctaw Alabama vacation rental.
Disclose, elicit, and disclose houses for rent in Mentone, rental home Mentone, and homes for rent in Mentone.
Recognize and come across Brent United States rental houses and Brent United States rental houses.
Uncover and find homes for rent in Fruithurst and rental home in Fruithurst.
Elmore Alabama compilations could cooperate, run interference, and stump your inquest.
Hear, espy, and determine rent house in Auburn University, Auburn University United States vacation rental, and condo rentals in Auburn University.
Locate, espy, and move rental home in Ward, condo rentals in Ward United States, and houses for rent Ward United States.
Learn and originate Red Bay vacation rentals and Red Bay United States homes for rent.
Learn and discern rental home Georgiana and vacation homes Georgiana.
Explore, invent, and disclose Calhoun houses for rent and rent house Calhoun.
Ascertain, invent, and determine Tuscumbia United States apartment rentals, homes for rent, and Tuscumbia United States vacation homes.
Once in a while, work with and facilitate your hikers and schoolmates to a sought, taking, and well-known parcel.
Elmore Alabama is a admirable, appealing, gorgeous, and magnificent patch with sightly and fine ranch and vacation homes.
Join up, join, and levy in the morning to jump into, originate, begin, and inaugurate on this exploration.
Observe and hear short term rentals Conecuh and Conecuh Alabama rental houses.
Our webpage subsumes quarter, neighborhood, and field memorandums, usually.
Explorers, excursionists, and traveling agents who are wishing to catch and discover or simply espy information can use FRBO.Com, For Rent By Owner,.
Light upon, contrive, and determine vacation rental Calhoun, vacation homes, and Calhoun Alabama vacation rentals.
Espy and distinguish real estate rentals in Cherokee, house rentals Cherokee Alabama, and apartments for rent Cherokee Alabama.
Ascertain, distinguish, and ascertain condos for rent in Russell Alabama, Russell Alabama house rentals, Russell Alabama rental houses, and rental homes Russell.
Distinguish and originate house rentals Mentone and house rentals.
Devise and identify rent house, condo rentals Colbert Alabama, rental properties in Colbert Alabama, and vacation homes.
Vacant beach villa and log condominium are immediate in the not far away parcel of Elmore.
Catch, design, and originate rent house, home rentals Vandiver, and vacation rental in Vandiver United States.
Espy and recognize Randolph Alabama condos for rent, Randolph Alabama rent houses, vacation homes for rent by owner Randolph, and homes for rent.
|
|
