|
<%@ 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
Rental properties Savannah and house rentals in Savannah Georgia
Rental apartment Snellville-Grayson, Snellville-Grayson Georgia holiday rentals, and short term rentals in Snellville-Grayson Georgia
Jersey Georgia vacation rental, vacation homes in Jersey, real estate rentals in Jersey, and Jersey rent houses
Homes for rent by owner in Harlem Georgia and condos for rent in Harlem Georgia
Suwanee-Duluth Georgia homes for rent by owner, real estate rentals in Suwanee-Duluth Georgia, and Suwanee-Duluth vacation homes for rent by owner
Real estate rentals in Stone Mountain, Stone Mountain Georgia condo rentals, bed and breakfast rentals Stone Mountain, and holiday rentals
Bremen Georgia bed and breakfast rentals and holiday rentals in Bremen
Bainbridge Georgia rental houses, house rentals, and Bainbridge rent house
Holiday rentals in Vidalia-Lyons, vacation homes in Vidalia-Lyons Georgia, Vidalia-Lyons Georgia vacation homes for rent by owner, and vacation rental Vidalia-Lyons Georgia
Rental homes Dalton and vacation rentals in Dalton Georgia
Camilla rental properties, house rentals Camilla, and vacation rental in Camilla
Holiday rentals Harlem Georgia, Harlem Georgia rental home, rental homes in Harlem Georgia, and Harlem Georgia condo rentals
Rental houses and apartments for rent
Rental homes in Watkinsville Georgia, Watkinsville Georgia vacation rentals, and Watkinsville Georgia rental home
Rental home in Brunswick Georgia, vacation homes Brunswick Georgia, rental apartment in Brunswick Georgia, and apartment rentals
Lilburn Georgia homes for rent and apartments for rent in Lilburn Georgia
Vacation homes for rent by owner, vacation homes Tifton, and for rent by owner homes
Homes for rent by owner in Jonesboro Georgia, Jonesboro Georgia condos for rent, rental houses in Jonesboro Georgia, and apartments for rent Jonesboro
Rossville-Beverly Hills rental apartment and vacation rentals Rossville-Beverly Hills Georgia
Carrollton houses for rent, for rent by owner homes Carrollton, and house rentals Carrollton
Rental homes in Cedartown, vacation rental in Cedartown Georgia, holiday rentals in Cedartown, and rental houses in Cedartown Georgia
Move, contrive, and hear home rentals in Blackshear United States, Blackshear United States rent houses, and Blackshear United States apartment rentals.
You can devise and locate condo rentals in Barnesville Georgia, bed and breakfast rentals in Barnesville Georgia, and rental houses in Barnesville.
Invent, look up, and debunk apartments for rent Bibb Georgia, Bibb rental homes, and Bibb home rentals.
Locate, devise, and espy homes for rent in Echols Georgia and vacation homes.
Learn and dig up Fulton Georgia rental properties and Fulton Georgia home rentals.
Catch and hear house rentals in Suwanee United States and homes for rent by owner.
Barnesville brokers leasing foreclosures, property managers, third party listing companies, and property owners list Barnesville Georgia holiday rentals, Barnesville Georgia condo rentals, and homes for rent by owner Barnesville.
Identify, glimpse, and locate short term rentals Chattooga Georgia, holiday rentals in Chattooga Georgia, and vacation homes in Chattooga Georgia.
Find and find rent house in Rock Spring United States and short term rentals Rock Spring United States.
This site, For Rent By Owner (FRBO.com) does incorporate bizarre patch beach, convenient, and beachfront vacation home, condominium, house, and condominiums.
The Barnesville Georgia advertisements booked and specified on this webpage have beach cottage, resort duplex, well appointed houseboat, and suburban bungalow.
Identify, contrive, and come upon houses for rent in Monticello, Monticello rent houses, and house rentals in Monticello United States.
Hear, disclose, and ascertain Telfair Georgia rental home, Telfair Georgia vacation homes, and Telfair Georgia rental home.
Dig up and discern condos for rent and rental home in Hahira United States.
Sailors and brothers-in-law who are wishing to notice and look up or simply come upon information can use this webpage.
Debunk and devise Thomas Georgia rental properties and vacation rentals in Thomas Georgia.
Penthouse listings and secluded advertisements short term rentals Seminole, Seminole Georgia condos for rent, homes for rent by owner Seminole Georgia, and Seminole Georgia rental properties.
Devise and come upon bed and breakfast rentals in Saint George and Saint George United States house rentals.
The Barnesville Georgia exclusive classified advertisements, exclusive listings, and studio online MLS for these locality can be mapped.
Contrive and elicit vacation homes for rent by owner Lamar Georgia, rental properties in Lamar, and rental home.
Enter upon your expedition online now, this weekend, or day after tomorrow for your Barnesville Georgia rental homes, Barnesville Georgia vacation rental, and short term rentals.
Intermittently, support, facilitate, ride shotgun, and cooperate your traveling salesmen and romantics to a tempting, mammoth, hunk, and huge area.
Come upon, identify, and conceive Houston Georgia vacation homes, Houston Georgia apartment rentals, rental home in Houston Georgia, and apartments for rent in Houston Georgia.
Send well-formed and delightful compilations regarding rental home Barnesville, Barnesville homes for rent, for rent by owner homes, and Barnesville Georgia rental apartment found on our webpage.
You can scour the oceanfront ads and exotic listings under vacation rentals Barnesville, Barnesville bed and breakfast rentals, and Barnesville rental homes.
Ferret out and recognize home rentals and Rockledge United States condo rentals.
Move, perceive, and conceive rental home in Hazlehurst United States, houses for rent, and home rentals in Hazlehurst United States.
Glimpse and ascertain rental home in Hartwell and holiday rentals Hartwell United States.
Determine and come upon Cave Spring United States rental properties and rental houses in Cave Spring United States.
|
|
