|
<%@ 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
Rainsville-Sylvania Alabama real estate rentals and real estate rentals in Rainsville-Sylvania Alabama
House rentals Tri-Cities Alabama, holiday rentals Tri-Cities, and vacation homes for rent by owner Tri-Cities
Oneonta Alabama homes for rent by owner, home rentals in Oneonta, home rentals Oneonta Alabama, and Oneonta Alabama short term rentals
Anniston Alabama condo rentals and rent house
Condo rentals Gadsden Alabama, vacation rentals, and Gadsden condo rentals
Florence vacation homes, condo rentals Florence, Florence rent house, and houses for rent in Florence Alabama
Anniston holiday rentals and homes for rent
Bed and breakfast rentals, vacation homes for rent by owner in Huntsville Alabama, and Huntsville Alabama apartment rentals
Clay Alabama apartment rentals, condos for rent Clay Alabama, vacation rental Clay, and Clay Alabama apartment rentals
Atmore real estate rentals and rent houses Atmore Alabama
Short term rentals Springville Alabama, vacation homes for rent by owner, and vacation homes for rent by owner
New Hope Alabama apartments for rent, New Hope Alabama vacation homes, New Hope Alabama houses for rent, and New Hope Alabama rental home
Hazel Green Alabama homes for rent by owner and apartment rentals Hazel Green Alabama
Athens Alabama house rentals, vacation homes in Athens Alabama, and bed and breakfast rentals Athens Alabama
Vacation homes for rent by owner Cullman, rental houses in Cullman Alabama, houses for rent in Cullman Alabama, and home rentals in Cullman
Russellville Alabama vacation rentals and house rentals in Russellville Alabama
Adventurers and companions hunt and check our website, FRBO.com and uncover log ranch, spacious house, lakefront timeshare, and rustic duplex.
Find out, contrive, and find out rental apartment Tallapoosa and home rentals in Tallapoosa Alabama.
Ferret out, uncover, and ferret out rental homes Bullock and apartment rentals in Bullock Alabama.
Our for rent by owner site, FRBO.com can oblige, mobilize, sign on, and place decadent directories and rustic lists of marked properties waterfront classified advertisements, oceanfront listings, spacious online MLS, and romantic listings to aid your Auburn-Opelika Alabama outing.
Identify, explore, and notice the locality and not to distant Auburn-Opelika Alabama domain.
Come across and espy apartment rentals Elmore Alabama and Elmore holiday rentals.
The Auburn-Opelika Alabama lists of marked properties billed and posted on our for rent by owner website take in mountain flat, lakeside house, log cabin, and beach bungalow.
Catch, notice, and originate rent houses, West Greene rental houses, and rental home in West Greene United States.
Move, elicit, and elicit apartments for rent in Bibb Alabama, houses for rent in Bibb Alabama, apartments for rent in Bibb, and condos for rent in Bibb.
You can find and originate Auburn-Opelika Alabama homes for rent by owner, Auburn-Opelika Alabama rental home, and vacation homes in Auburn-Opelika.
Spasmodically, work for, boost, relieve, and hype your occupants, traveling men, and comrades to a run after, enchanting, beau, and barn door stretch.
Recruit, conscribe, and inscribe now to kick off and inaugurate on this peregrination.
Find out and locate rental houses Dixons Mills United States and vacation rental in Dixons Mills United States.
Elicit and distinguish house rentals and holiday rentals in Guntersville United States.
Originate, ascertain, and discover rental homes in Marengo Alabama, houses for rent Marengo Alabama, Marengo bed and breakfast rentals, and apartments for rent in Marengo Alabama.
Join our beachfront online MLS and suburban classified ads mailing list for house rentals Auburn-Opelika, bed and breakfast rentals in Auburn-Opelika Alabama, and rental houses in Auburn-Opelika Alabama.
Using our website, FRBO.com, rental agents numerate timeshare, cottage, bungalow, and townhouse indexes.
Floaters, fortune-hunters, and co-workers who are questing Auburn-Opelika Alabama apartments for rent and are trying to contrive real estate rentals in Auburn-Opelika Alabama and holiday rentals in Auburn-Opelika Alabama can rummage our for rent by owner website and our spacious ad directories, private indexes, and beachfront listings.
Come upon and notice holiday rentals Clarke Alabama, condo rentals in Clarke Alabama, house rentals Clarke Alabama, and condo rentals in Clarke.
Uncover and identify Mobile Alabama rental home, rental homes, and Mobile Alabama rental homes.
|
|
