|
<%@ 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
Apartment rentals in Athens Georgia and houses for rent in Athens Georgia
Real estate rentals Lilburn, rent house in Lilburn, and Lilburn Georgia vacation rental
Bed and breakfast rentals in Blairsville Georgia, bed and breakfast rentals, rent house in Blairsville Georgia, and Blairsville homes for rent
Clermont holiday rentals and Clermont Georgia condos for rent
Condo rentals in Cedartown Georgia, Cedartown Georgia rent house, and apartments for rent in Cedartown Georgia
Real estate rentals, Thomaston Georgia vacation homes, homes for rent by owner in Thomaston Georgia, and vacation homes for rent by owner in Thomaston
For rent by owner homes in Cedartown Georgia and apartments for rent in Cedartown Georgia
Condo rentals in Carrollton Georgia, bed and breakfast rentals in Carrollton Georgia, and rent houses
Houses for rent in South Rockdale Georgia, South Rockdale vacation homes for rent by owner, homes for rent in South Rockdale Georgia, and South Rockdale Georgia houses for rent
For rent by owner homes in LaGrange Georgia and vacation rental LaGrange Georgia
Barnesville home rentals, rental home in Barnesville Georgia, and rent house in Barnesville
Rental homes Swainsboro Georgia, Swainsboro Georgia bed and breakfast rentals, houses for rent in Swainsboro Georgia, and Swainsboro Georgia vacation homes
Catch and recognize the parcel and approaching Loganville Georgia vicinity.
See resort directories, well appointed classified advertisements, exclusive ads, and city online MLS that town home owners and rental property owners post on our website, FRBO.com.
Conceive, come upon, and explore rental homes in Plains United States, vacation homes for rent by owner Plains, and Plains condos for rent.
List and employ tomorrow to originate and inaugurate on this expedition.
Ascertain, disclose, and discover condo rentals in Willacoochee United States, homes for rent, and Willacoochee United States for rent by owner homes.
The Loganville online MLS classified and set down on this site, For Rent By Owner (FRBO.com) enclose private cabin, romantic flat, and loft hacienda.
Debunk and elicit vacation homes and vacation rentals in Clarke Georgia.
Come across, light upon, and design Funston United States vacation homes, condos for rent in Funston, and holiday rentals Funston.
Design and find condos for rent in Senoia and Senoia rent houses.
The Loganville Georgia city lists of marked properties and well appointed online MLS for these can be mapped.
Loganville Georgia is a pretty and fascinating principality with delicate, pulchritudinous, pretty, and well-formed cabin, house, chalet, and houses.
Find out, determine, and come upon Cleveland United States condo rentals, vacation rental in Cleveland, and rental apartment in Cleveland United States.
Discern, identify, and discover Towns Georgia homes for rent, Towns apartment rentals, and holiday rentals.
Identify and discover Bibb houses for rent, Bibb Georgia vacation homes, and rent house Bibb Georgia.
Recognize, design, and find homes for rent in McIntosh and holiday rentals McIntosh.
|
|
