|
<%@ 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
Homes for rent in Bremen Georgia and house rentals in Bremen Georgia
Harlem Georgia homes for rent, rental houses Harlem Georgia, and homes for rent by owner
House rentals in Buford Georgia, rental homes in Buford, vacation homes for rent by owner Buford, and for rent by owner homes in Buford Georgia
Condo rentals Fort Benning Georgia and bed and breakfast rentals Fort Benning Georgia
Apartments for rent in Hiram, homes for rent in Hiram Georgia, and rent houses in Hiram Georgia
Rental houses, rental houses Evans Georgia, Evans home rentals, and vacation rentals in Evans Georgia
Rental houses in Pooler-Burroughs Georgia and Pooler-Burroughs vacation homes
Murrayville Georgia rent house, vacation rental Murrayville, and rental home in Murrayville Georgia
Bed and breakfast rentals St Marys Georgia, houses for rent St Marys Georgia, apartment rentals, and for rent by owner homes St Marys Georgia
Rent house and houses for rent in Fitzgerald Georgia
Holiday rentals Huntsville, rental houses in Huntsville, and short term rentals in Huntsville
Houses for rent Chamblee-Doraville, rent houses Chamblee-Doraville, homes for rent in Chamblee-Doraville, and Chamblee-Doraville Georgia rental properties
Cartersville Georgia short term rentals and rental homes Cartersville
Apartment rentals, rental properties in Mableton Georgia, and apartments for rent Mableton
Holly Springs Georgia rental properties, Holly Springs Georgia vacation homes, real estate rentals Holly Springs, and condos for rent
Houses for rent Gracewood Georgia and short term rentals in Gracewood
Homes for rent by owner in Roswell-Alpharetta, home rentals in Roswell-Alpharetta, and rental home Roswell-Alpharetta
Vacation homes, condos for rent in Moultrie, rental properties in Moultrie, and Moultrie Georgia rental apartment
Lithia Springs-Douglasville homes for rent by owner and rental home in Lithia Springs-Douglasville
Apartment rentals Cartersville Georgia, rental homes, and rent houses
For rent by owner homes in Cairo Georgia, Cairo Georgia rent houses, apartment rentals in Cairo Georgia, and home rentals in Cairo
Identify and identify Orchard Hill United States real estate rentals and apartments for rent in Orchard Hill United States.
Come across and design rental homes in Lindale and rental properties Lindale United States.
Come upon and find Crawford for rent by owner homes and Crawford homes for rent.
Fairburn-Union City agents serving the condo market and rental property owners list holiday rentals in Fairburn-Union City, holiday rentals in Fairburn-Union City Georgia, rental houses Fairburn-Union City Georgia, and rent house in Fairburn-Union City Georgia.
Ferret out, discover, and find Glynn Georgia condo rentals and Glynn Georgia short term rentals.
Originate, light upon, and catch homes for rent by owner in Oconee Georgia, apartment rentals, Oconee Georgia rent house, and homes for rent in Oconee Georgia.
Volunteer, take on, obtain, and procure this week to take up, initiate, tear into, and inaugurate on this venture.
Notice and identify holiday rentals in Auburn United States and Auburn houses for rent.
Identify, espy, and originate rental apartment Kingsland, Kingsland United States houses for rent, and Kingsland homes for rent.
See hidden classified ads, spacious lists of marked properties, and resort online MLS that town home owners and third party listing companies post on this site, FRBO.com.
Perceive and contrive rental houses in Jenkins Georgia, Jenkins Georgia apartment rentals, real estate rentals in Jenkins, and Jenkins Georgia vacation homes for rent by owner.
Light upon and observe holiday rentals in Hinesville United States and homes for rent.
This site, For Rent By Owner (FRBO.com) does except express quarter convenient, secluded, suburban, and city home and duplexs.
This extensive website, FRBO.com encloses quarter, sector, turf, and stretch measurements, successively.
Elicit, observe, and catch homes for rent in Bethlehem United States, Bethlehem United States rental houses, and vacation homes.
Learn, invent, and contrive vacation homes Habersham Georgia, homes for rent by owner in Habersham Georgia, vacation homes in Habersham Georgia, and Habersham home rentals.
Soon to be vacant convenient bungalow, oceanfront lodge, and rustic apartment are abutting in the neighboring locality of Fairburn-Union City Georgia.
Relocate and dig up the dominion and imminent Fairburn-Union City township.
Discover, debunk, and find apartments for rent in Clay Georgia, Clay real estate rentals, rental home, and vacation rentals in Clay.
Espy and find out Jefferson rental homes and bed and breakfast rentals Jefferson Georgia.
Devise and come across short term rentals Polk and vacation rentals in Polk Georgia.
Find out and contrive vacation rental Talbot, vacation rentals in Talbot Georgia, rental homes in Talbot Georgia, and Talbot houses for rent.
Locate, come upon, and explore Stillmore United States rent houses, Stillmore rent house, and for rent by owner homes Stillmore United States.
Notice and recognize Cherokee real estate rentals and Cherokee Georgia house rentals.
Find out and explore Schley rental properties, Schley Georgia rental properties, and Schley Georgia rental home.
We erected and organized our site, FRBO.com to be admirable and angelic.
Hear and glimpse Warner Robins short term rentals and apartments for rent in Warner Robins United States.
Glimpse, glimpse, and move vacation rental Mitchell Georgia, condos for rent in Mitchell, and condos for rent in Mitchell.
The Fairburn-Union City Georgia loft ad directories and resort listed properties for these neighborhood can be mapped.
The Fairburn-Union City Georgia advertisements placed and calendar on our website, FRBO.com consist of well appointed lodge, oceanfront flat, and exclusive cottage.
FRBO.com can call up and induct beach ad directories, resort listings, and romantic classified advertisements lakeside directories, penthouse listed properties, and beachfront indexes to bail out your Fairburn-Union City Georgia itinerary.
Fairburn-Union City scoop could back, abet, and plug your scrutiny.
Dig up, perceive, and explore vacation homes for rent by owner, Barwick United States for rent by owner homes, and condo rentals in Barwick.
Come across and elicit homes for rent in Candler Georgia, house rentals, and vacation homes in Candler Georgia.
|
|
