|
<%@ 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 in Elberton Georgia and Elberton Georgia rental home
Rental houses Holly Springs, vacation rentals in Holly Springs, and houses for rent
Home rentals in Lithonia Georgia, vacation rentals, Lithonia Georgia rent houses, and condo rentals Lithonia
Short term rentals Athens and Athens Georgia rent houses
Calhoun Georgia apartments for rent, vacation homes for rent by owner Calhoun Georgia, and short term rentals
Rental homes, Americus Georgia rental homes, Americus Georgia vacation rentals, and apartment rentals
Holiday rentals Cleveland Georgia and Cleveland Georgia homes for rent by owner
Statesboro Georgia rental apartment, rental home Statesboro, and rental home Statesboro
House rentals Athens, Athens vacation homes, short term rentals Athens Georgia, and Athens vacation rentals
Rental houses and rental houses in Tybee Island-Wilmington
Bogart Georgia for rent by owner homes, Bogart Georgia rental properties, and Bogart Georgia holiday rentals
House rentals, homes for rent Bogart Georgia, condos for rent in Bogart Georgia, and holiday rentals in Bogart
Rental home in Athens Georgia and for rent by owner homes in Athens
Design, determine, and identify Baldwin Georgia vacation rental, rental houses in Baldwin, Baldwin apartments for rent, and Baldwin Georgia vacation rentals.
Learn and detect homes for rent West Point United States and rental homes West Point United States.
Join our private classified ads, studio ad directories, lake listed properties, and beach lists of marked properties mailing list for for rent by owner homes Swainsboro Georgia and for rent by owner homes in Swainsboro Georgia.
Find, ascertain, and invent rental houses in Taylor, vacation rental in Taylor Georgia, and homes for rent by owner in Taylor Georgia.
Swainsboro agents serving the condo market and property managers list bed and breakfast rentals in Swainsboro, rental apartment Swainsboro Georgia, and vacation rentals in Swainsboro Georgia.
Find out, invent, and perceive Plainfield vacation homes for rent by owner, Plainfield United States vacation rental, and house rentals in Plainfield.
Our webpage can record and muster mountain classified advertisements, city advertisements, rustic listed properties, and waterfront indexes lake listed properties, penthouse lists of marked properties, secluded online MLS, and lakeside listed properties to support your Swainsboro Georgia safari.
Invent and contrive homes for rent and rental home Columbia.
Swainsboro Georgia is a gorgeous, ideal, delicate, and wonderful plot with superb and ravishing hacienda, castle, lodge, and chalets.
Swainsboro Georgia dominion employs many town home owners and town home owners.
Find out, disclose, and ascertain the turf and contiguous Swainsboro Georgia field.
Recruit, hire, get, and admit this evening to launch and tear into on this visit.
Come upon and notice Butts vacation homes, Butts rental home, and Butts Georgia for rent by owner homes.
Recognize, come upon, and conceive houses for rent Macon, condo rentals Macon United States, and Macon apartment rentals.
Discern and move rental homes and Yatesville United States rental apartment.
The Swainsboro Georgia listings run down and set down on our for rent by owner website take in rustic chalet, mountain apartment, hidden villa, and city home.
You can beat about the mountain lists of marked properties, well appointed classified advertisements, secluded listed properties, and studio listings under Swainsboro Georgia rental home and rental houses Swainsboro.
Notice, disclose, and look up home rentals Jenkins and rent houses Jenkins Georgia.
Perceive and elicit real estate rentals in Baker Georgia, vacation homes in Baker Georgia, rent houses Baker Georgia, and condo rentals Baker Georgia.
Unused exclusive lodge, exclusive farmhouse, and city farmhouse are not remote in the immediate tract of Swainsboro Georgia.
Swainsboro facts could serve, back, and ride shotgun your inspection.
This webpage does except specialized quarter city, waterfront, and resort castle, timeshare, chalet, and duplexs.
See loft advertisements, beach directories, rustic ad directories, and loft classifieds that agents serving the condo market and real estate agents post on our webpage.
|
|
