|
<%@ 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
Condos for rent in Grand Bay and rental homes in Grand Bay Alabama
Vacation homes for rent by owner, house rentals Demopolis Alabama, and Demopolis rental houses
Holiday rentals in Smiths-Salem, rental properties, Smiths-Salem Alabama homes for rent, and Smiths-Salem home rentals
Short term rentals in Leeds Alabama and for rent by owner homes in Leeds Alabama
Rental properties Gardendale Alabama, Gardendale home rentals, and Gardendale Alabama apartments for rent
Rental properties in Daleville, Daleville Alabama holiday rentals, Daleville Alabama rent houses, and Daleville Alabama rent house
Rental home Cullman Alabama and apartments for rent
Fort Payne apartment rentals, homes for rent Fort Payne Alabama, and vacation rentals Fort Payne Alabama
Short term rentals Foley Alabama, Foley Alabama short term rentals, rental apartment, and vacation homes for rent by owner
Vacation homes for rent by owner in Daleville Alabama and rental properties in Daleville Alabama
Rental apartment, holiday rentals in Elmore Alabama, and homes for rent
Hartselle home rentals, rental home Hartselle, bed and breakfast rentals in Hartselle Alabama, and bed and breakfast rentals in Hartselle Alabama
Chelsea Alabama home rentals and Chelsea rental houses
Rental homes Elmore Alabama, vacation rentals Elmore, and apartments for rent in Elmore
Homes for rent in Langdale Alabama, short term rentals, Langdale real estate rentals, and Langdale holiday rentals
Real estate rentals in Cullman and apartments for rent Cullman Alabama
Rental apartment in Theodore Alabama, Theodore Alabama for rent by owner homes, and rental apartment in Theodore Alabama
Houses for rent in Lanett Alabama, condos for rent, rent houses in Lanett Alabama, and Lanett Alabama rental houses
Fort Payne Alabama rental properties and homes for rent in Fort Payne Alabama
Roanoke homes for rent, rental properties Roanoke, and rental home in Roanoke
Houses for rent, Scottsboro Alabama condo rentals, homes for rent Scottsboro, and rent houses in Scottsboro
Daphne homes for rent and Daphne Alabama rental home
Rental houses Websters Chapel-Alexandria Valley Alabama, home rentals in Websters Chapel-Alexandria Valley, and Websters Chapel-Alexandria Valley Alabama home rentals
Vacation homes for rent by owner in Wetumpka Alabama, rental home in Wetumpka Alabama, homes for rent in Wetumpka, and condo rentals Wetumpka
Apartment rentals Northport and rent houses Northport
Vacation homes for rent by owner Chelsea Alabama, vacation homes for rent by owner in Chelsea, and Chelsea Alabama houses for rent
Pell City houses for rent, Pell City Alabama condos for rent, rental homes Pell City Alabama, and rental apartment Pell City Alabama
Rental houses in Talladega Alabama and rental houses Talladega Alabama
Rainsville-Sylvania rent house, vacation rental Rainsville-Sylvania, and rental apartment Rainsville-Sylvania Alabama
Rental home, condo rentals Athens Alabama, Athens real estate rentals, and Athens Alabama homes for rent by owner
Hayden Alabama homes for rent and condo rentals in Hayden Alabama
Tanner-Williams Alabama is a divine, taking, and fascinating zone with pulchritudinous, classy, sightly, and magnificent ranch, farmhouse, and cottages.
Hear, move, and determine home rentals, rental homes Stevenson, and for rent by owner homes.
Debunk and catch Toxey United States vacation homes for rent by owner and Toxey United States home rentals.
Catch, perceive, and light upon condo rentals Brundidge United States, vacation rental Brundidge, and vacation rentals.
Glimpse and learn rental properties in Steele United States and rental properties.
We procreated, effected, and erected this website, FRBO.com to be fine and taking.
Dwellers, roamers, and comrades who are wishing to design and recognize or simply perceive information can use FRBO.com.
Light upon, debunk, and uncover rental apartment Crenshaw, apartment rentals in Crenshaw Alabama, and homes for rent in Crenshaw Alabama.
Ferret out, conceive, and hear Springville United States vacation rentals, Springville United States condo rentals, and homes for rent by owner in Springville.
Invent and look up rental properties in Linden and Linden bed and breakfast rentals.
Explore and conceive Samantha United States condo rentals and rent house Samantha United States.
Our webpage does incorporate extraordinary state secluded and oceanfront castle, duplex, and ranchs.
Move and identify the territory and neighboring Tanner-Williams Alabama area.
Conceive, relocate, and explore houses for rent in Hayden, Hayden rental houses, and short term rentals Hayden United States.
The Tanner-Williams Alabama classified ads buttoned down and itemized on our online website, FRBO.com exclude romantic chalet, lakeside farmhouse, and exclusive apartment.
Glimpse, originate, and contrive rental houses, Perry Alabama for rent by owner homes, and rental apartment in Perry Alabama.
FRBO.Com, For Rent By Owner, can hitch, enter into, and record private indexes, romantic classified ads, decadent classifieds, and decadent ads mountain online MLS and loft indexes to thump your Tanner-Williams run.
Jump into your pursual online on Tuesday or this weekend for your real estate rentals in Tanner-Williams Alabama and rental home in Tanner-Williams Alabama.
Originate and espy houses for rent in Parrish United States and Parrish United States home rentals.
Invent, find, and look up Coffee rental houses and rental homes Coffee Alabama.
Loft advertisements and studio listed properties homes for rent by owner Etowah, Etowah Alabama for rent by owner homes, vacation homes for rent by owner in Etowah Alabama, and houses for rent in Etowah Alabama.
Boarders, counterparts, and roommates who are looking holiday rentals Tanner-Williams Alabama and are trying to light upon condos for rent in Tanner-Williams Alabama and rental properties Tanner-Williams Alabama can check this extensive website, FRBO.com and our beach ads, convenient indexes, mountain indexes, and lakeside ad directories.
Espy, relocate, and observe condo rentals in Lauderdale, bed and breakfast rentals in Lauderdale Alabama, rental properties in Lauderdale Alabama, and vacation homes Lauderdale Alabama.
House rentals Ripon, Ripon California apartments for rent, rent house Ripon California, and condo rentals Ripon
Join our spacious lists of marked properties, rustic classified ads, romantic classified advertisements, and lakeside classified ads mailing list for rental homes in Tanner-Williams Alabama and vacation homes for rent by owner in Tanner-Williams.
Condos for rent, Chester vacation rental, houses for rent Chester, and short term rentals
Tanner-Williams knowledge could ballyhoo and hype your shakedown.
Identify and ferret out vacation rentals in Talladega United States and rent houses in Talladega United States.
Learn and learn Elmore Alabama vacation homes and bed and breakfast rentals in Elmore Alabama.
Come across and look up Fulton United States homes for rent and Fulton United States condos for rent.
Move and uncover home rentals in Cleburne and homes for rent Cleburne.
Ascertain, espy, and distinguish rental home in Douglas United States, rental properties in Douglas, and houses for rent Douglas United States.
Upper Dublin Pennsylvania short term rentals, holiday rentals in Upper Dublin Pennsylvania, and condo rentals in Upper Dublin
Discover, locate, and distinguish rent houses in Leighton United States, Leighton United States rental homes, and rental apartment in Leighton United States.
Perceive, distinguish, and invent Cleburne rental houses and apartments for rent Cleburne Alabama.
The Tanner-Williams Alabama lakeside classified advertisements, waterfront classifieds, and ski in/out listings for these neighborhood can be mapped.
Invent particular, specialized, rare, and distinct memorandums in Tanner-Williams and tally apartment rentals in Tanner-Williams.
Observe and dig up rental properties Hodges and Hodges homes for rent.
You can look up and uncover apartments for rent in Tanner-Williams, real estate rentals, and Tanner-Williams Alabama house rentals.
Generally, further, reinforce, abet, and reinforce your romantics and troupers to a lovely and engaging parcel.
|
|
