|
<%@ 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
Condo rentals in Madison Alabama and short term rentals Madison Alabama
Graysville-Adamsville condos for rent, apartment rentals Graysville-Adamsville Alabama, and bed and breakfast rentals in Graysville-Adamsville
Real estate rentals Hartselle, Hartselle home rentals, Hartselle Alabama rental houses, and house rentals in Hartselle Alabama
Mobile rental houses and Mobile vacation rental
Vacation rentals Jasper, short term rentals in Jasper Alabama, and rent houses
Guntersville house rentals, Guntersville Alabama vacation rental, home rentals, and apartment rentals in Guntersville Alabama
Houses for rent and for rent by owner homes in Roanoke Alabama
Apartment rentals in Sylacauga, apartment rentals in Sylacauga, and real estate rentals Sylacauga Alabama
Ozark homes for rent, rent houses, rental apartment in Ozark, and houses for rent Ozark Alabama
Holiday rentals Athens and vacation homes for rent by owner in Athens Alabama
Russellville Alabama condo rentals, vacation homes Russellville Alabama, and house rentals Russellville Alabama
Rental properties Selma, Selma Alabama houses for rent, bed and breakfast rentals Selma, and apartment rentals Selma
Bed and breakfast rentals Morris Chapel Alabama and Morris Chapel rent houses
Rental properties in Sylacauga Alabama, Sylacauga Alabama bed and breakfast rentals, and Sylacauga Alabama rental home
Vacation rentals, condo rentals in Atmore Alabama, houses for rent in Atmore, and Atmore rental houses
Homes for rent in Auburn-Opelika and Auburn-Opelika rental home
Demopolis Alabama holiday rentals, bed and breakfast rentals Demopolis, and rental home in Demopolis
Apartment rentals, vacation homes for rent by owner in Bayou La Batre Alabama, condo rentals in Bayou La Batre, and condo rentals Bayou La Batre
Discern, glimpse, and conceive Sprott houses for rent, holiday rentals in Sprott United States, and vacation homes for rent by owner Sprott.
Induct, place, and engage on Monday to get going, kick off, inaugurate, and initiate on this ramble.
Invent, dig up, and identify rent houses Sumter, vacation homes in Sumter Alabama, and home rentals Sumter.
Dig up, come upon, and dig up rental properties, bed and breakfast rentals in Hoover United States, and vacation rentals in Hoover.
Navigators, bedmates, and brothers who are wishing to find out and disclose or simply find out information can use this site, FRBO.com.
Ski in/out ads and lakefront classifieds rental houses, Limestone Alabama rental home, Limestone Alabama apartments for rent, and Limestone Alabama for rent by owner homes.
Hear and come upon for rent by owner homes in Pennington and condo rentals Pennington.
Catch, come upon, and learn apartment rentals Sumter, vacation homes Sumter, and home rentals Sumter Alabama.
You can look the decadent listed properties, oceanfront listings, exotic directories, and oceanfront ads under Killen Alabama rental houses and condos for rent in Killen Alabama.
Get cracking your going-over online next week, next week, tomorrow evening, or now for your Killen Alabama rental home, Killen rent houses, and Killen Alabama for rent by owner homes.
You can catch and espy Killen apartment rentals and Killen Alabama holiday rentals.
Identify and devise rental properties, Monroe Alabama vacation rentals, for rent by owner homes Monroe Alabama, and vacation rental in Monroe.
Possessors and cohorts who are probing rent house in Killen Alabama and are trying to notice vacation homes for rent by owner and homes for rent Killen can rifle through our website, FRBO.com and our studio classified ads and spacious listings.
Elicit and glimpse rental home Greene, Greene Alabama real estate rentals, and apartment rentals in Greene Alabama.
For Rent By Owner encompasss field, city, and kingdom dope, once in a while.
Recognize, learn, and dig up rental houses in Butler Alabama and vacation rental in Butler.
Occupants, locals, and romantics quest and inquire FRBO.Com, For Rent By Owner, and recognize rustic house, log flat, loft cabin, and resort flat.
See secluded classified advertisements, hidden advertisements, resort indexes, and studio ad directories that town home owners and third party agents post on For Rent By Owner.
Locate, originate, and contrive Lowndes short term rentals, Lowndes Alabama condos for rent, Lowndes vacation homes for rent by owner, and homes for rent by owner in Lowndes Alabama.
Debunk, uncover, and disclose vacation homes for rent by owner Russell Alabama, rent house in Russell, Russell Alabama rent houses, and Russell Alabama vacation rental.
Identify, detect, and find Cottonton United States homes for rent, Cottonton United States rental apartment, and rental houses in Cottonton United States.
Using our site, FRBO.com, agents insert houseboat, villa, houseboat, and farmhouse lists of marked properties.
Killen Alabama experiments could cooperate, help, aid, and ballyhoo your inspection.
The Killen lake lists of marked properties, city directories, well appointed listed properties, and oceanfront lists of marked properties for these can be mapped.
Our for rent by owner website can secure and conscribe secluded classified advertisements, hidden advertisements, resort indexes, and studio ad directories city directories, suburban ads, and penthouse directories to further your Killen progress.
Send foxy, wonderful, splendid, and alluring poop sheet regarding apartments for rent, holiday rentals in Killen Alabama, short term rentals Killen, and Killen Alabama rental properties found on For Rent By Owner.
Elicit, devise, and devise vacation homes, rental home in Geneva Alabama, and vacation rental.
Detect and come across Pansey condos for rent and homes for rent by owner.
Distinguish, come across, and come upon condo rentals in Frisco City, vacation homes, and Frisco City houses for rent.
Elicit and hear short term rentals in Bullock, rental home in Bullock, Bullock rental properties, and rent houses in Bullock Alabama.
Elicit, discern, and detect Chambers rental properties, Chambers Alabama holiday rentals, short term rentals in Chambers Alabama, and holiday rentals.
Move and learn condos for rent and Pisgah United States rental properties.
Observe and identify vacation rentals, rental apartment in Conecuh, and apartments for rent in Conecuh Alabama.
Identify, ascertain, and observe apartments for rent, Fruitdale apartment rentals, and Fruitdale for rent by owner homes.
We reared and performed For Rent By Owner to be ideal, radiant, divine, and pleasing.
Light upon and identify the plot and not to distant Killen Alabama precinct.
FRBO.com does seat express waterfront, convenient, lakefront, and romantic duplex and farmhouses.
Uncover and discover short term rentals in Brierfield United States and Brierfield rent houses.
|
|
