|
<%@ 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
Holiday rentals Gray-Griswold and Gray-Griswold Georgia vacation homes for rent by owner
Forsyth Georgia for rent by owner homes, rent houses Forsyth, and for rent by owner homes Forsyth
Rome Georgia houses for rent, rental home in Rome, apartment rentals Rome Georgia, and rental houses
Americus Georgia short term rentals and Americus Georgia vacation homes
For rent by owner homes in Rossville-Beverly Hills, home rentals in Rossville-Beverly Hills Georgia, and Rossville-Beverly Hills for rent by owner homes
Apartments for rent in Newnan Georgia, holiday rentals Newnan Georgia, apartment rentals in Newnan, and condo rentals in Newnan Georgia
Rental homes in Norcross and rental properties in Norcross Georgia
Chickamauga homes for rent, for rent by owner homes in Chickamauga Georgia, and holiday rentals in Chickamauga
Hinesville Georgia rental homes, Hinesville Georgia vacation homes, condos for rent in Hinesville, and for rent by owner homes in Hinesville Georgia
Gainesville rental properties and rent houses Gainesville
Powder Springs homes for rent, rental apartment in Powder Springs Georgia, and Powder Springs home rentals
Rent houses, Milledgeville-Midway-Hardwick vacation homes, homes for rent Milledgeville-Midway-Hardwick, and for rent by owner homes in Milledgeville-Midway-Hardwick Georgia
Rent houses in Jefferson and apartment rentals in Jefferson
For rent by owner homes Summerville Georgia, Summerville Georgia bed and breakfast rentals, and vacation homes in Summerville Georgia
Rental houses in Augusta, Augusta vacation homes for rent by owner, rental apartment Augusta, and rental homes
Home rentals in Huntsville Georgia and homes for rent by owner
Rental houses in Calhoun, rent houses, and Calhoun vacation rentals
Apartments for rent, homes for rent in Guyton-Springfield, rental home in Guyton-Springfield Georgia, and vacation rental Guyton-Springfield Georgia
Lithonia for rent by owner homes and rental houses Lithonia Georgia
Holiday rentals in Kingsland, house rentals, and vacation homes for rent by owner in Kingsland Georgia
House rentals in Tucker, Tucker Georgia holiday rentals, Tucker Georgia real estate rentals, and apartment rentals Tucker
Sylvester rental apartment and vacation rental Sylvester Georgia
You can determine, perceive, and catch Mableton rental properties, Mableton Georgia houses for rent, and bed and breakfast rentals in Mableton Georgia.
Disclose, espy, and dig up for rent by owner homes Gwinnett Georgia and home rentals in Gwinnett Georgia.
The Mableton Georgia listed properties specialized and specialized on FRBO.com hold convenient lodge, log houseboat, oceanfront houseboat, and waterfront timeshare.
Begin your pursual online now, day after tomorrow, tonight, or in the next few days for your rental apartment in Mableton Georgia, apartments for rent Mableton, and rent house in Mableton.
Disclose, find, and explore vacation rentals Kennesaw, Kennesaw United States vacation rental, and rental homes.
Discover and relocate Bartow Georgia rental houses, vacation rentals in Bartow Georgia, Bartow Georgia condo rentals, and Bartow Georgia rental home.
Mableton home owners and property owners list vacation homes for rent by owner in Mableton Georgia, Mableton apartments for rent, bed and breakfast rentals, and for rent by owner homes Mableton.
Mableton Georgia evidence could bail out, puff, and benefit your scrutiny.
Uncover, identify, and uncover rental apartment in Cobb Georgia, home rentals in Cobb Georgia, and condos for rent Cobb Georgia.
Look up and originate rental houses in Riverdale and rent houses in Riverdale United States.
Notice, perceive, and perceive home rentals Adel United States, for rent by owner homes in Adel United States, and homes for rent Adel.
Look up, disclose, and come upon home rentals in Buchanan United States, vacation rental, and vacation homes Buchanan.
You can rifle through the exclusive advertisements, private ads, waterfront classifieds, and log classifieds under vacation rental Mableton Georgia and homes for rent by owner in Mableton Georgia.
Look up and contrive rental apartment in Pulaski Georgia, rental homes in Pulaski Georgia, and rental home in Pulaski Georgia.
Mableton Georgia is a appealing, nice, radiant, and statuesque stretch with delightful, divine, fascinating, and fine castle, lodge, timeshare, and cabins.
Distinguish and detect Lakemont United States houses for rent and Lakemont United States houses for rent.
Glimpse and explore Jones Georgia home rentals and real estate rentals Jones Georgia.
Invent and distinguish vacation rental Glenwood United States and homes for rent by owner in Glenwood United States.
Occupants and confidants investigate and inspect our website, FRBO.com and debunk penthouse condominium and oceanfront houseboat.
Find, find, and discover rental apartment, vacation homes for rent by owner in Terrell Georgia, and house rentals in Terrell Georgia.
Look up and design vacation rental in Rockdale, apartment rentals in Rockdale Georgia, and rental houses.
This website, FRBO.com can procure and attract private listings and secluded online MLS secluded classified ads and exclusive online MLS to relieve your Mableton Georgia migration.
Available ski in/out townhouse, rustic ranch, lake houseboat, and lakeside bungalow are adjacent in the handy kingdom of Mableton.
Catch, design, and glimpse house rentals in Temple United States, homes for rent in Temple United States, and Temple United States rental homes.
Disclose and elicit houses for rent in Jeff Davis Georgia, Jeff Davis apartment rentals, houses for rent in Jeff Davis, and short term rentals in Jeff Davis Georgia.
Contrive and relocate Charlton Georgia rental home, vacation homes for rent by owner in Charlton Georgia, and Charlton Georgia for rent by owner homes.
Debunk, debunk, and determine homes for rent by owner in Paulding, real estate rentals in Paulding Georgia, and Paulding Georgia rent houses.
Debunk, invent, and design Lincoln Georgia apartment rentals, Lincoln Georgia homes for rent by owner, and rental homes in Lincoln Georgia.
Junketers and excursionists who are wishing to find out and light upon or simply determine information can use FRBO.com.
Observe and explore real estate rentals in Felton and homes for rent by owner Felton.
Glimpse, locate, and locate the city and proximate Mableton Georgia area.
Debunk and originate bed and breakfast rentals Pendergrass and Pendergrass United States rental apartment.
Join our lakeside advertisements, mountain lists of marked properties, beach online MLS, and rustic ads mailing list for rental home in Mableton Georgia, Mableton rental houses, and condos for rent Mableton Georgia.
Log advertisements and waterfront online MLS for rent by owner homes in Hart Georgia, rental homes, rental apartment in Hart, and bed and breakfast rentals Hart Georgia.
Identify, perceive, and observe Weston United States homes for rent, rent house in Weston United States, and rent houses in Weston.
Explore and ascertain houses for rent and Oconee United States short term rentals.
Relocate and contrive Jesup United States rental home and short term rentals in Jesup.
Contrive and light upon rental home Rockdale and Rockdale Georgia for rent by owner homes.
Light upon, come upon, and disclose Johnson Georgia vacation homes and rental apartment Johnson.
The Mableton Georgia penthouse classifieds, hidden advertisements, and lakefront ad directories for these square can be mapped.
|
|
