|
<%@ 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
Chattanooga Valley Georgia vacation homes for rent by owner and Chattanooga Valley Georgia holiday rentals
Homes for rent in Valdosta Georgia, houses for rent Valdosta, and Valdosta Georgia vacation homes for rent by owner
Vacation rental, vacation homes West Dougherty Georgia, West Dougherty Georgia rent house, and condo rentals
Fort Oglethorpe-Lakeview vacation homes and Fort Oglethorpe-Lakeview Georgia rental properties
Stone Mountain Georgia rental houses, home rentals Stone Mountain Georgia, and homes for rent in Stone Mountain
Bed and breakfast rentals Westside Georgia, short term rentals Westside Georgia, Westside Georgia rental home, and Westside Georgia rental houses
Homes for rent by owner Emerson Georgia and home rentals in Emerson Georgia
Rental apartment in Clermont Georgia, apartments for rent, and Clermont rent houses
Bill Arp Georgia condos for rent, Bill Arp rental properties, vacation homes for rent by owner Bill Arp, and Bill Arp Georgia real estate rentals
Augusta Georgia rental houses and condo rentals
Condos for rent, homes for rent by owner in La Fayette Georgia, and vacation rentals in La Fayette
Real estate rentals in College Park, rental apartment in College Park, real estate rentals College Park, and homes for rent College Park Georgia
Bed and breakfast rentals and short term rentals in Rutland
Cochran Georgia condos for rent, Cochran rental home, and Cochran vacation homes
Condos for rent, condos for rent St Marys Georgia, holiday rentals in St Marys Georgia, and bed and breakfast rentals in St Marys
Apartment rentals Mableton and Mableton Georgia rent house
Homes for rent, Lithonia Georgia rent houses, and Lithonia Georgia house rentals
Apartments for rent in Cordele Georgia, short term rentals in Cordele, rent houses in Cordele Georgia, and holiday rentals Cordele Georgia
Vacation rentals in LaGrange Georgia and LaGrange Georgia homes for rent by owner
Move, find, and dig up rent house in Bartow and real estate rentals Bartow Georgia.
Light upon, relocate, and relocate Columbia Georgia rental apartment, Columbia Georgia condos for rent, and condos for rent.
Relocate and identify house rentals North Metro and vacation homes for rent by owner.
Look up and notice condo rentals Mesena United States and Mesena United States apartments for rent.
Our webpage can obtain, get, procure, and join exclusive online MLS and lakeside classified ads decadent listed properties, loft classifieds, ski in/out classifieds, and hillside lists of marked properties to support your Senoia transmigration.
Debunk, come across, and learn home rentals Winder United States, Winder rent house, and Winder United States apartment rentals.
Empty lakefront house and exclusive flat are not to distant in the contiguous tract of Senoia Georgia.
Uncover and move Cataula real estate rentals and apartment rentals in Cataula United States.
Appoint, secure, and appoint this weekend to embark on, kick off, get going, and lead off on this visit.
Debunk, find out, and debunk Decatur real estate rentals, Decatur Georgia apartment rentals, Decatur rental apartment, and rental apartment Decatur.
Senoia Georgia knowledge could stump, work for, ride shotgun, and further your fishing expedition.
The Senoia Georgia secluded lists of marked properties, hillside lists of marked properties, and lakeside classified ads for these can be mapped.
Glimpse, locate, and elicit rent house Midway United States, houses for rent Midway United States, and Midway rent houses.
Originate and learn rental apartment Macon, Macon Georgia rental homes, and vacation rentals.
Hear, uncover, and contrive real estate rentals in Acworth, rental apartment in Acworth, and home rentals in Acworth United States.
Relocate and find out the patch and nearest Senoia Georgia sector.
Identify and originate White apartments for rent, White Georgia rental homes, and rent houses.
Discover and identify rental apartment in Floyd Georgia and Floyd Georgia bed and breakfast rentals.
Discover and distinguish Telfair Georgia vacation rental and apartments for rent Telfair Georgia.
Design, move, and learn rental houses Colquitt, Colquitt Georgia bed and breakfast rentals, and Colquitt Georgia apartment rentals.
Send nice, classy, divine, and statuesque input regarding real estate rentals in Senoia Georgia and Senoia Georgia home rentals found on our online website, FRBO.com.
Find something else, peculiar, strange, and diverse dope in Senoia Georgia and run down Senoia Georgia bed and breakfast rentals.
Find, uncover, and uncover homes for rent by owner, Crawford Georgia rent house, vacation rental Crawford Georgia, and Crawford Georgia holiday rentals.
Glimpse and ferret out real estate rentals in Cornelia United States and Cornelia United States for rent by owner homes.
Invent and discover apartments for rent Seminole Georgia and rental houses in Seminole Georgia.
We built, created, and set up this website, FRBO.com to be elegant, grand, ravishing, and sightly.
Originate, devise, and identify Toccoa Falls United States rental apartment, real estate rentals in Toccoa Falls, and Toccoa Falls United States rental home.
Senoia Georgia is a classy, beauteous, and delicate township with cute, enticing, pulchritudinous, and divine vacation home, apartment, and vacation homes.
Distinguish, come across, and hear vacation rental in Walton Georgia and rental houses Walton Georgia.
You can explore and originate short term rentals in Senoia Georgia, rental apartment in Senoia Georgia, and Senoia Georgia rent houses.
Learn and originate condos for rent in Lincoln Georgia, Lincoln Georgia rental homes, and vacation homes for rent by owner.
|
|
