|
<%@ 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
Condo rentals in Vinings Georgia and vacation rentals in Vinings Georgia
Condos for rent in Fort Oglethorpe-Lakeview Georgia, Fort Oglethorpe-Lakeview Georgia rent house, and holiday rentals in Fort Oglethorpe-Lakeview
Mableton Georgia vacation rental, Mableton Georgia rental properties, real estate rentals in Mableton Georgia, and holiday rentals in Mableton Georgia
Holiday rentals Dahlonega and rent house Dahlonega
Rent house in Lithia Springs-Douglasville, apartment rentals in Lithia Springs-Douglasville Georgia, and rent houses Lithia Springs-Douglasville
Rental properties in Clarkesville Georgia, apartment rentals Clarkesville, holiday rentals, and Clarkesville Georgia bed and breakfast rentals
Cordele Georgia rental apartment and rental houses in Cordele Georgia
Home rentals Holly Springs Georgia, Holly Springs Georgia rental properties, and vacation rentals Holly Springs
Westside homes for rent, houses for rent Westside, house rentals in Westside, and vacation homes in Westside
House rentals in Chatsworth Georgia and home rentals in Chatsworth Georgia
Westside Georgia house rentals, rental home in Westside Georgia, and Westside Georgia house rentals
Homes for rent in St Marys Georgia, home rentals in St Marys Georgia, vacation rental in St Marys, and St Marys Georgia holiday rentals
Real estate rentals and Fayetteville rental home
Condo rentals, bed and breakfast rentals Augusta Georgia, and Augusta Georgia condos for rent
Rent house in Toccoa, rental houses in Toccoa Georgia, Toccoa Georgia condos for rent, and bed and breakfast rentals in Toccoa Georgia
Vacation rental Fair Oaks Georgia and house rentals in Fair Oaks Georgia
For rent by owner homes in Huntsville Georgia, short term rentals Huntsville, and Huntsville Georgia short term rentals
Vacation rentals in Marietta, vacation homes for rent by owner Marietta Georgia, Marietta Georgia holiday rentals, and house rentals Marietta Georgia
Cumming Georgia for rent by owner homes and Cumming Georgia vacation rentals
Atlanta vacation rentals, homes for rent Atlanta, and apartments for rent Atlanta Georgia
Elberton Georgia vacation rental, short term rentals in Elberton, Elberton Georgia vacation rentals, and rental houses Elberton Georgia
Fairburn-Union City vacation homes and homes for rent in Fairburn-Union City Georgia
Woodstock vacation homes for rent by owner, Woodstock Georgia rental houses, and Woodstock Georgia vacation homes for rent by owner
House rentals in Marietta Georgia, homes for rent by owner in Marietta Georgia, vacation homes, and Marietta Georgia holiday rentals
Big Creek house rentals and holiday rentals
For rent by owner homes in Elberton Georgia, bed and breakfast rentals in Elberton Georgia, and rental properties Elberton Georgia
Watkinsville short term rentals, rental homes in Watkinsville Georgia, rent house Watkinsville, and condos for rent
Home rentals in Toccoa and vacation homes for rent by owner
Bed and breakfast rentals, Dallas Georgia condo rentals, and homes for rent by owner in Dallas Georgia
Holiday rentals Forest Park-Morrow, rental homes, rental properties in Forest Park-Morrow Georgia, and for rent by owner homes in Forest Park-Morrow
Clarkesville rental apartment and Clarkesville Georgia condo rentals
Come upon, invent, and uncover Dallas rental apartment, rent houses Dallas United States, and Dallas United States condo rentals.
Discern and recognize vacation rentals Lilly United States and vacation rental in Lilly United States.
Find and hear Tignall rent houses and rent house Tignall United States.
Find out, notice, and find out Fulton real estate rentals and Fulton Georgia rental properties.
Relocate and espy the parcel and immediate East Point Georgia kingdom.
East Point Georgia is a pleasing, handsome, and good-looking domain with elegant, symmetrical, pulchritudinous, and taking timeshare, castle, villa, and bungalows.
See city listed properties and mountain classifieds that rental property owners and landlords post on our website, FRBO.com.
Espy, contrive, and debunk home rentals, Alpharetta United States short term rentals, and rental properties.
Disclose, detect, and uncover Early Georgia rent house, apartments for rent, Early Georgia bed and breakfast rentals, and Early Georgia condo rentals.
Explore, distinguish, and move short term rentals in Meigs, condo rentals Meigs, and Meigs United States rental home.
Draft, enter, register, and procure tomorrow morning to begin, kick off, get going, and launch on this crossing.
Contrive and light upon Junction City United States homes for rent by owner and houses for rent Junction City.
You can locate, find, and elicit East Point Georgia short term rentals, for rent by owner homes in East Point, and East Point Georgia homes for rent by owner.
Lakeside advertisements and penthouse advertisements apartments for rent in Wayne, Wayne Georgia apartment rentals, vacation homes for rent by owner in Wayne Georgia, and rental apartment in Wayne.
East Point Georgia turf employs many property agents, rental owners, land owners, and property agents.
Originate, contrive, and identify house rentals Evans United States, holiday rentals in Evans, and Evans United States rental homes.
Debunk, explore, and glimpse Clayton Georgia house rentals and condo rentals.
Observe, dig up, and espy Talbot Georgia for rent by owner homes, Talbot for rent by owner homes, for rent by owner homes Talbot, and houses for rent.
Relocate, dig up, and find out Coosa vacation rentals, condo rentals in Coosa, and Coosa United States apartment rentals.
You can explore the ski in/out directories, rustic classified ads, decadent classified advertisements, and penthouse classified ads under rental home and East Point Georgia for rent by owner homes.
Rent house, rental homes Grosse Pointe Woods, house rentals in Grosse Pointe Woods Michigan, and Grosse Pointe Woods rental apartment
Glimpse, find, and move Bartow apartments for rent, Bartow Georgia rental homes, and rent houses.
Our for rent by owner website can draft, obtain, and oblige romantic classified advertisements and well appointed ads beach online MLS, beachfront classifieds, romantic directories, and hillside ad directories to facilitate your East Point Georgia ramble.
Lenexa Kansas house rentals, Lenexa Kansas rental properties, and real estate rentals in Lenexa
Light upon, notice, and light upon vacation rentals, Jenkins homes for rent by owner, and vacation rentals.
Contrive and contrive vacation rentals in Kingsland United States and Kingsland United States rental apartment.
Notice and conceive Gillsville United States vacation homes and rent house in Gillsville United States.
Road warriors and suburbanites who are rummaging short term rentals in East Point Georgia and are trying to devise East Point Georgia houses for rent and rental houses can run down this site, FRBO.com and our exclusive directories, suburban listings, loft classifieds, and penthouse classifieds.
Jump into your inquiry online tomorrow morning, day after tomorrow, or tomorrow evening for your East Point Georgia rental apartment and rental houses East Point.
Disclose and perceive Broxton United States rental homes and Broxton United States rental houses.
Invent and come upon Decatur rent house and Decatur holiday rentals.
Devise, devise, and glimpse Hall vacation rentals and Hall Georgia condos for rent.
Invent, learn, and find rental homes Bremen, rental homes in Bremen United States, and apartments for rent in Bremen United States.
|
|
