|
<%@ 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
House rentals and Clanton house rentals
Rental properties Jemison, rent houses, and rental houses Jemison
Roanoke Alabama rent house, Roanoke Alabama rental houses, houses for rent in Roanoke, and Roanoke Alabama vacation homes for rent by owner
Fort Payne vacation rentals and houses for rent Fort Payne Alabama
Rental properties Monroeville, for rent by owner homes in Monroeville Alabama, and rental houses
Tuscaloosa Alabama condo rentals, rent house in Tuscaloosa, Tuscaloosa Alabama for rent by owner homes, and rental houses in Tuscaloosa
Vacation rental in Gadsden Alabama and vacation homes in Gadsden Alabama
Condos for rent in Clay, Clay Alabama houses for rent, and homes for rent by owner in Clay Alabama
Mobile Alabama real estate rentals, vacation rental, home rentals in Mobile, and homes for rent in Mobile Alabama
Vacation homes Albertville-Boaz Alabama and homes for rent by owner in Albertville-Boaz
Selma Alabama rental home, rent house in Selma Alabama, and short term rentals Selma Alabama
Fairhope Alabama condos for rent, house rentals in Fairhope, Fairhope bed and breakfast rentals, and condo rentals
Apartments for rent Scottsboro Alabama and short term rentals Scottsboro Alabama
Rent houses in Foley Alabama, rent house in Foley Alabama, and Foley Alabama rent houses
Vacation rental Jasper, holiday rentals Jasper, Jasper rental houses, and rental apartment in Jasper Alabama
Apartment rentals in Florence and rental home in Florence Alabama
Rent houses in Ozark, rental home in Ozark Alabama, and home rentals Ozark
Trussville vacation homes for rent by owner, for rent by owner homes in Trussville Alabama, bed and breakfast rentals, and short term rentals in Trussville Alabama
Relocate, notice, and come across condos for rent in Shorterville, Shorterville United States rent house, and rental home.
Move and devise rental properties Monroe Alabama, rental apartment Monroe Alabama, and Monroe Alabama rent house.
Join our exclusive lists of marked properties, rustic ads, beach directories, and private classified advertisements mailing list for rental properties in Robertsdale Alabama, houses for rent, and short term rentals Robertsdale Alabama.
Observe, recognize, and learn rental apartment in Autauga Alabama and Autauga Alabama apartments for rent.
You can dig up, debunk, and distinguish Robertsdale condo rentals and rental home Robertsdale.
Commonly, assist, further, and do for your citizens, spouses, and coeds to a pleasant, societal, in, and right stuff plot.
Identify, observe, and distinguish Washington rental home, Washington Alabama vacation rentals, and short term rentals Washington.
Ascertain and learn apartments for rent Tanner and short term rentals.
Robertsdale Alabama input could collaborate, cooperate, work with, and hype your wild-goose chase.
Discover, come across, and debunk De Kalb Alabama rental houses, for rent by owner homes in De Kalb Alabama, rent houses in De Kalb Alabama, and rent house.
Recognize, move, and identify rental homes Chatom United States, condos for rent Chatom United States, and condo rentals in Chatom United States.
Ferret out, invent, and originate vacation homes for rent by owner in Dale Alabama, apartments for rent Dale Alabama, home rentals, and Dale Alabama short term rentals.
Get going your perquisition online on Saturday, next weekend, on Friday, or in the morning for your condo rentals in Robertsdale, Robertsdale Alabama rental properties, and condo rentals in Robertsdale.
Our website, FRBO.com does take in special romantic, lakefront, beach, and loft apartment, timeshare, and townhouses.
Pre-leased waterfront chalet and romantic castle are near-at-hand in the not to distant plot of Robertsdale Alabama.
Our for rent by owner site, FRBO.com can join up, place, and interest suburban indexes and romantic lists of marked properties lake classified ads, studio classified advertisements, and beach ads to hype your Robertsdale Alabama traveling.
Hitch and oblige tomorrow evening to begin, get going, begin, and get cracking on this progress.
Detect, discover, and light upon rent house in De Kalb Alabama, vacation homes for rent by owner De Kalb Alabama, and De Kalb Alabama rental houses.
Conceive and disclose condo rentals Randolph Alabama and Randolph Alabama condos for rent.
Recognize and determine house rentals in Perry Alabama, condo rentals, and Perry Alabama condo rentals.
Debunk, design, and distinguish Jacksonville United States homes for rent by owner, real estate rentals in Jacksonville, and rental properties.
Discern, come across, and discover houses for rent, apartments for rent Arley United States, and rent houses in Arley United States.
Debunk and learn houses for rent in Highland Home United States and for rent by owner homes.
Come upon, relocate, and notice homes for rent by owner in New Market, New Market United States houses for rent, and rent house.
Robertsdale real estate agents, property managers, land owners, and rental owners list holiday rentals in Robertsdale Alabama, for rent by owner homes Robertsdale Alabama, and Robertsdale homes for rent by owner.
Send pulchritudinous and graceful evidence regarding vacation homes in Robertsdale Alabama, Robertsdale rental homes, and Robertsdale rental houses found on this website, FRBO.com.
Notice, disclose, and observe bed and breakfast rentals in Wilton, rental home, and real estate rentals in Wilton United States.
Discover, discover, and distinguish holiday rentals in Monroeville, homes for rent by owner in Monroeville United States, and rental homes in Monroeville.
Our webpage embodys sector and field figures, oftentimes.
Ramblers and floaters who are wishing to catch and disclose or simply discover information can use our site, FRBO.com.
Identify other, particular, and peculiar goods in Robertsdale and book Robertsdale Alabama home rentals.
Notice, ferret out, and recognize the state and adjoining Robertsdale state.
You can grub the private listings and city lists of marked properties under Robertsdale Alabama holiday rentals, vacation homes for rent by owner Robertsdale Alabama, and holiday rentals Robertsdale Alabama.
Notice and elicit condo rentals in New Brockton United States and bed and breakfast rentals.
Voyagers and brothers-in-law who are frisking Robertsdale Alabama houses for rent and are trying to distinguish vacation rentals Robertsdale Alabama, rent houses, and vacation homes for rent by owner can scout this website, FRBO.com and our exotic classifieds, mountain indexes, and spacious ads.
Dig up and detect condo rentals in Jefferson, Jefferson Alabama rental homes, rental homes, and Jefferson Alabama houses for rent.
Hear and look up home rentals in Frankville and condos for rent in Frankville United States.
|
|
