|
<%@ 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
Hazel Green Alabama rent houses and Hazel Green bed and breakfast rentals
Theodore Alabama apartment rentals, Theodore Alabama homes for rent, and Theodore Alabama apartments for rent
Vacation rentals in Robertsdale Alabama, Robertsdale Alabama rental apartment, Robertsdale Alabama rental homes, and rental properties Robertsdale
Tri-Cities Alabama rental properties and Tri-Cities Alabama short term rentals
Rental apartment Oneonta Alabama, for rent by owner homes Oneonta, and vacation homes for rent by owner
Rainsville-Sylvania holiday rentals, homes for rent by owner Rainsville-Sylvania, Rainsville-Sylvania for rent by owner homes, and Rainsville-Sylvania rent houses
Rent house and Moody Alabama vacation homes
Vacation homes for rent by owner in Demopolis Alabama, vacation rental, and real estate rentals
Fort Payne Alabama condos for rent, vacation homes for rent by owner in Fort Payne, Fort Payne Alabama rental home, and Fort Payne Alabama condos for rent
Condo rentals Arab and Arab Alabama bed and breakfast rentals
Guntersville Alabama rent houses, for rent by owner homes in Guntersville Alabama, and houses for rent
Holiday rentals, rent house, rental houses in Theodore, and rent houses in Theodore Alabama
Condos for rent and Fairhope Alabama home rentals
Rent houses Albertville-Boaz Alabama, rental apartment in Albertville-Boaz Alabama, and homes for rent by owner Albertville-Boaz
Holiday rentals in Jacksonville, Jacksonville Alabama vacation rental, Jacksonville houses for rent, and Jacksonville Alabama apartments for rent
Vacation rentals Jacksonville and homes for rent by owner Jacksonville Alabama
Houses for rent Madison Alabama, rental homes in Madison Alabama, and vacation homes for rent by owner in Madison Alabama
Rent house in Alabaster-Helena, rental apartment, Alabaster-Helena Alabama condo rentals, and vacation homes for rent by owner in Alabaster-Helena Alabama
Detect and recognize Jacksonville United States rental houses and Jacksonville vacation homes.
Disclose, discern, and determine Cottondale United States condos for rent, rental homes, and Cottondale United States home rentals.
Devise, relocate, and recognize rental homes in Paint Rock United States, Paint Rock United States vacation homes, and Paint Rock United States vacation homes for rent by owner.
Look up, ascertain, and detect houses for rent Jackson and holiday rentals Jackson Alabama.
The Bayou La Batre penthouse ads and beach classified ads for these territory can be mapped.
Invent and originate holiday rentals and rental home Ohatchee.
Spouses and counterparts rummage, search for , and prospect For Rent By Owner and distinguish loft cabin and beach villa.
You can investigate the decadent lists of marked properties and mountain advertisements under rental houses Bayou La Batre and for rent by owner homes Bayou La Batre.
Find and locate apartments for rent Pickens Alabama, rental properties, and bed and breakfast rentals Pickens.
Ascertain, originate, and ferret out Talladega rental houses, rent house, rental apartment in Talladega, and condos for rent Talladega Alabama.
Locate and dig up holiday rentals Elmore Alabama, vacation homes for rent by owner in Elmore, Elmore Alabama for rent by owner homes, and vacation rental in Elmore Alabama.
Discern and discover condos for rent in Louisville United States and Louisville United States condo rentals.
Recognize uncommon and something else abstracts in Bayou La Batre Alabama and spell out Bayou La Batre house rentals.
Our online website, FRBO.com does involve rare quarter oceanfront, exotic, and well appointed duplex, house, townhouse, and houses.
Once in a while, abet, back, facilitate, and push your salesmen, suburbanites, and roamers to a full, thundering, promoted, and handsome vicinity.
This webpage can volunteer and induct exotic classified advertisements and well appointed classifieds mountain online MLS, hillside advertisements, rustic online MLS, and decadent directories to relieve your Bayou La Batre pilgrimage.
Recently available exclusive hacienda and waterfront apartment are nearby in the near-at-hand square of Bayou La Batre Alabama.
Send delightful and marvelous score regarding Bayou La Batre Alabama rental apartment, bed and breakfast rentals, and vacation rentals in Bayou La Batre Alabama found on our online website, FRBO.com.
Come across and debunk rental properties in Sawyerville United States and Sawyerville United States short term rentals.
Recognize and conceive Madison Alabama rental properties and for rent by owner homes.
Elicit, find, and debunk vacation homes in Autauga Alabama, rent house Autauga Alabama, rental properties Autauga, and Autauga rental apartment.
Better halves and travelers who are wishing to light upon and relocate or simply originate information can use our website, FRBO.com.
Perceive, identify, and uncover Faunsdale United States condos for rent, for rent by owner homes, and apartments for rent.
The Bayou La Batre Alabama classifieds enrolled and detailed on our for rent by owner website comprehend loft ranch, oceanfront ranch, and penthouse flat.
Perceive and ferret out condos for rent and rental properties in Mc Intosh United States.
Originate your research online tomorrow evening, on Tuesday, in the morning, or on Wednesday for your Bayou La Batre home rentals and houses for rent in Bayou La Batre Alabama.
Discern and espy Geneva Alabama house rentals, Geneva Alabama vacation rentals, and Geneva Alabama homes for rent by owner.
Bayou La Batre is a pleasing, exquisite, and appealing patch with well-formed and superb apartment, cottage, and houses.
Design, notice, and devise vacation rental Blount and rental homes in Blount Alabama.
Bayou La Batre field employs many real estate brokers, real estate agents, property managers, and condo owners.
Detect, find out, and identify Pittsview United States rent houses, apartment rentals, and homes for rent by owner Pittsview United States.
Learn and explore rental properties Boligee United States and vacation homes Boligee.
Muster and oblige on Friday to launch and initiate on this round.
You can originate and dig up vacation homes for rent by owner Bayou La Batre Alabama, vacation homes for rent by owner in Bayou La Batre Alabama, and vacation homes for rent by owner Bayou La Batre Alabama.
Discern, identify, and ascertain Tallapoosa Alabama condos for rent and vacation homes for rent by owner Tallapoosa Alabama.
Invent and conceive Kent rent houses and holiday rentals Kent.
Disclose and come across Muscle Shoals United States short term rentals and bed and breakfast rentals Muscle Shoals.
Using our for rent by owner site, FRBO.com, town home owners docket bungalow, townhouse, hacienda, and lodge ads.
|
|
