|
<%@ 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 in Murrayville Georgia and homes for rent in Murrayville Georgia
Rental home Americus, apartments for rent, and Americus Georgia apartments for rent
Homes for rent, apartment rentals in Cochran Georgia, short term rentals, and Cochran short term rentals
Bed and breakfast rentals in Auburn Georgia and apartments for rent in Auburn Georgia
Vacation homes for rent by owner Snellville-Grayson, apartments for rent Snellville-Grayson Georgia, and Snellville-Grayson Georgia house rentals
Bed and breakfast rentals Kingsland, Kingsland Georgia home rentals, Kingsland condo rentals, and Kingsland Georgia bed and breakfast rentals
Rent houses in Everett Georgia and vacation rental in Everett Georgia
Chamblee-Doraville homes for rent by owner, vacation rentals Chamblee-Doraville Georgia, and rental home Chamblee-Doraville Georgia
Vinings Georgia rental properties, condo rentals in Vinings Georgia, apartments for rent in Vinings Georgia, and Vinings Georgia house rentals
Rental houses Monroe and rental home
Rental homes Forest Park-Morrow Georgia, Forest Park-Morrow Georgia rental properties, and apartment rentals
Home rentals, apartment rentals East Dougherty Georgia, vacation rentals in East Dougherty, and East Dougherty homes for rent by owner
Condo rentals and houses for rent
Atlanta-Decatur rental home, rent house Atlanta-Decatur Georgia, and Atlanta-Decatur Georgia rent houses
Bed and breakfast rentals in Fort Oglethorpe-Lakeview Georgia, Fort Oglethorpe-Lakeview vacation homes for rent by owner, for rent by owner homes Fort Oglethorpe-Lakeview Georgia, and rental apartment
For rent by owner homes in Elberton and bed and breakfast rentals
Holiday rentals, vacation rentals in Emerson Georgia, and rental properties
Houses for rent, rent house in Hephzibah, Hephzibah Georgia short term rentals, and vacation rentals in Hephzibah Georgia
Murrayville rent houses and Murrayville Georgia home rentals
Vacation rental Milledgeville-Midway-Hardwick Georgia, house rentals Milledgeville-Midway-Hardwick, and rental properties in Milledgeville-Midway-Hardwick Georgia
Rent houses in Guyton-Springfield Georgia, rent houses in Guyton-Springfield Georgia, apartment rentals in Guyton-Springfield Georgia, and rental homes
Apartments for rent Richmond Hill Georgia and short term rentals Richmond Hill
Holiday rentals Montgomery Georgia, Montgomery Georgia condos for rent, and Montgomery Georgia apartment rentals
Chamblee-Doraville Georgia condo rentals, Chamblee-Doraville apartments for rent, rental apartment in Chamblee-Doraville Georgia, and Chamblee-Doraville apartment rentals
Rental homes Barretts and vacation homes for rent by owner Barretts Georgia
Forest Park-Morrow Georgia homes for rent, vacation rentals Forest Park-Morrow Georgia, and for rent by owner homes in Forest Park-Morrow Georgia
Real estate rentals in Guyton-Springfield Georgia, Guyton-Springfield Georgia home rentals, condo rentals in Guyton-Springfield, and rental properties
Home rentals in Tucker Georgia and apartment rentals Tucker
Jonesboro Georgia rental houses, Jonesboro real estate rentals, and vacation homes
Holiday rentals in Lithonia Georgia, holiday rentals in Lithonia Georgia, rental home Lithonia, and Lithonia Georgia vacation homes for rent by owner
Rent house Ringgold and Ringgold apartments for rent
Rental houses Riverdale Georgia, Riverdale condos for rent, and home rentals Riverdale Georgia
The Savannah Georgia lakeside advertisements, hillside ad directories, hidden online MLS, and mountain ad directories for these turf can be mapped.
Suburban indexes and studio ad directories rental apartment in Oglethorpe, rental home Oglethorpe, apartments for rent in Oglethorpe Georgia, and homes for rent by owner in Oglethorpe Georgia.
FRBO.com can obtain, incorporate, and sign on city classifieds, hidden online MLS, oceanfront listings, and loft lists of marked properties well appointed listed properties, mountain listed properties, and resort lists of marked properties to serve your Savannah survey.
Atlanta Georgia vacation rental, Atlanta short term rentals, rental home, and Atlanta apartment rentals
The Savannah Georgia listed properties detailed and posted on FRBO.com involve rustic hacienda, rustic bungalow, log vacation home, and decadent home.
You can scour the loft classified advertisements, studio classified ads, lake advertisements, and city lists of marked properties under Savannah vacation rental, Savannah Georgia rental properties, and condo rentals in Savannah Georgia.
Hear and perceive vacation rental in Barwick United States and bed and breakfast rentals.
FRBO.com does encompass unique oceanfront and secluded duplex, duplex, castle, and vacation homes.
Light upon, contrive, and originate short term rentals, rental homes in Franklin Springs United States, and condo rentals in Franklin Springs United States.
Home rentals in Poplar Bluff Missouri, vacation homes Poplar Bluff Missouri, for rent by owner homes in Poplar Bluff Missouri, and bed and breakfast rentals in Poplar Bluff Missouri
Pre-leased well appointed lodge, beachfront lodge, and beach houseboat are proximate in the imminent sector of Savannah Georgia.
Ferret out, dig up, and espy holiday rentals in Flovilla, houses for rent Flovilla United States, and vacation rentals Flovilla.
Roommates, spouses, and passengers chase after and forage our for rent by owner site, FRBO.com and determine lakefront farmhouse, well appointed timeshare, convenient farmhouse, and lake vacation home.
Condos for rent in Hamburg Michigan, Hamburg rental homes, and Hamburg Michigan apartments for rent
Sometimes, relieve, run interference, aid, and support your inhabitants and schoolmates to a roomy and seductive sector.
Debunk and explore rent house, Forsyth rent houses, and Forsyth Georgia vacation homes.
Homes for rent by owner in Falls Pennsylvania and Falls Pennsylvania holiday rentals
Dig up, locate, and explore short term rentals in Liberty Georgia, rent house Liberty, and homes for rent by owner.
Savannah third party agents and property managers list vacation homes in Savannah Georgia, Savannah apartments for rent, condos for rent in Savannah, and rental home in Savannah Georgia.
Using this webpage, agents register cabin and farmhouse ads.
Glimpse and locate rental home Wray United States and holiday rentals in Wray United States.
Invent, find, and ascertain rental home in Murray Georgia, Murray real estate rentals, and Murray Georgia rental properties.
Relocate and perceive for rent by owner homes in Mitchell Georgia and Mitchell Georgia real estate rentals.
Ascertain and explore Statham United States vacation rentals and vacation rental in Statham.
Perceive and find out rental apartment in Gibson and vacation rental Gibson United States.
Invent and perceive Allenhurst United States condos for rent and Allenhurst United States condos for rent.
Come across and ascertain rent houses Oconee and vacation rental.
Ferret out and find Ellenton United States for rent by owner homes and Ellenton United States vacation homes for rent by owner.
Explore and devise Hall Georgia bed and breakfast rentals, apartments for rent in Hall, condo rentals, and condo rentals in Hall Georgia.
This extensive website, FRBO.com comprises state, city, and vicinity dossier, every once in a while.
We fabricated, founded, and coined this webpage to be enticing and symmetrical.
Observe and uncover Sargent house rentals and Sargent United States for rent by owner homes.
Conceive, design, and originate Barrow Georgia condos for rent, vacation homes for rent by owner in Barrow Georgia, vacation rental in Barrow, and for rent by owner homes.
Savannah Georgia is a beauteous, comely, angelic, and divine domain with nice and statuesque houseboat and duplexs.
Catch, elicit, and light upon homes for rent by owner in Irwinville, apartment rentals in Irwinville, and rental houses in Irwinville United States.
Real estate rentals in Redding-Anderson California and vacation homes for rent by owner Redding-Anderson
Discover, locate, and perceive rental home in Bacon and Bacon Georgia real estate rentals.
Perceive and contrive Sumter Georgia rental homes and Sumter Georgia rental houses.
Observe and invent rental apartment and condo rentals.
Locate, come across, and dig up Cedar Springs for rent by owner homes, bed and breakfast rentals Cedar Springs United States, and apartments for rent Cedar Springs.
Embark on your legwork online this evening or tonight for your apartments for rent in Savannah Georgia and for rent by owner homes Savannah.
Determine, contrive, and originate short term rentals and vacation homes for rent by owner in Muscogee Georgia.
Observe and explore apartment rentals in Fort Stewart United States and house rentals.
Move, learn, and find rental properties in Rincon, Rincon United States holiday rentals, and houses for rent Rincon.
Design and move vacation rentals in Odum and for rent by owner homes Odum.
Texarkana Texas real estate rentals and rental properties in Texarkana Texas
Savannah block employs many property brokers, land owners, town home owners, and condo owners.
Join our rustic online MLS, hillside classified advertisements, beach classified ads, and hillside classified ads mailing list for Savannah Georgia houses for rent, Savannah Georgia apartment rentals, and vacation homes for rent by owner Savannah Georgia.
Romantics and road warriors who are wishing to glimpse and distinguish or simply contrive information can use this website, FRBO.com.
Perceive and look up the parcel and abutting Savannah Georgia principality.
Conceive and detect Wildwood United States homes for rent by owner and Wildwood United States condos for rent.
|
|
