|
<%@ 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" %>
|
Georgia Rental Links
Apartments for rent Blackshear Georgia and condo rentals in Blackshear Georgia
Condo rentals in McDonough Georgia, McDonough Georgia rent houses, and McDonough Georgia rental home
House rentals Westside Georgia, bed and breakfast rentals Westside Georgia, Westside Georgia holiday rentals, and Westside rental houses
Sylvester rent houses and Sylvester Georgia home rentals
West Dougherty Georgia house rentals, West Dougherty Georgia houses for rent, and vacation homes
Rental homes in LaGrange Georgia, rent houses in LaGrange Georgia, LaGrange Georgia rental home, and rent houses LaGrange
Vacation homes for rent by owner and La Fayette Georgia condo rentals
For rent by owner homes in Bogart Georgia, Bogart Georgia real estate rentals, and apartments for rent
Bogart Georgia vacation rental, apartment rentals, Bogart Georgia vacation homes, and for rent by owner homes Bogart Georgia
Short term rentals in Griffin Georgia and vacation homes for rent by owner in Griffin Georgia
Vacation homes for rent by owner in Dacula-Rocky Creek Georgia, condos for rent in Dacula-Rocky Creek Georgia, and Dacula-Rocky Creek Georgia vacation homes for rent by owner
Short term rentals Dublin Georgia, Dublin Georgia rent houses, rental home in Dublin Georgia, and house rentals in Dublin
Real estate rentals in Big Creek Georgia and apartment rentals in Big Creek Georgia
Perceive and distinguish Dougherty Georgia vacation rentals, vacation homes for rent by owner Dougherty, and rental home in Dougherty Georgia.
Studio listings and private listings Bryan Georgia vacation homes for rent by owner, rent houses Bryan Georgia, Bryan homes for rent by owner, and houses for rent Bryan.
Send gorgeous, wonderful, and radiant compilations regarding rental home Blackshear and apartments for rent Blackshear found on our for rent by owner site, FRBO.com.
Come across, move, and espy homes for rent in Heard and Heard Georgia rent houses.
Distinguish and disclose Brantley Georgia rent houses and houses for rent Brantley Georgia.
Find out, hear, and distinguish Garfield United States real estate rentals, Garfield United States for rent by owner homes, and Garfield United States homes for rent by owner.
Detect, light upon, and invent real estate rentals in Elbert, real estate rentals, holiday rentals in Elbert Georgia, and Elbert Georgia holiday rentals.
Blackshear brokers leasing foreclosures, real estate agents, property brokers, and third party listing companies list apartment rentals Blackshear Georgia, Blackshear for rent by owner homes, homes for rent by owner, and house rentals.
Recognize and explore condos for rent and condos for rent in White.
Adventurers, troupers, and friends who are wishing to recognize, elicit, and originate or simply find information can use this webpage.
The Blackshear classified advertisements written down and enrolled on our for rent by owner website have decadent bungalow and mountain cottage.
This webpage can call up and hitch private ad directories and suburban indexes spacious directories and lake listings to support your Blackshear Georgia drive.
Hear, light upon, and perceive rent houses in Surrency United States, rental home in Surrency, and apartment rentals in Surrency.
Relocate and find out Wrightsville vacation rental and condos for rent in Wrightsville.
Learn, locate, and contrive the area and impending Blackshear principality.
Elicit, discern, and contrive houses for rent in Warrenton United States, vacation homes for rent by owner, and apartment rentals Warrenton.
Tear into your investigation online day after tomorrow, this evening, or tomorrow morning for your for rent by owner homes Blackshear and Blackshear rental properties.
Vacant exotic apartment and exotic farmhouse are adjoining in the nearby domain of Blackshear Georgia.
Contrive and discern rent house and houses for rent in Mershon United States.
|
|
