|
<%@ 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
Bed and breakfast rentals in Bremen and Bremen Georgia vacation homes for rent by owner
Powder Springs Georgia rent houses, rent house Powder Springs, and Powder Springs rent house
Rental properties in Lithia Springs-Douglasville, bed and breakfast rentals in Lithia Springs-Douglasville, bed and breakfast rentals, and Lithia Springs-Douglasville condo rentals
Vacation homes Thomaston Georgia and rental properties in Thomaston Georgia
Jersey Georgia rent house, rent house in Jersey Georgia, and Jersey vacation homes
Rental home in Emerson, apartments for rent Emerson, vacation homes for rent by owner Emerson, and homes for rent by owner in Emerson Georgia
Vacation homes for rent by owner in St Marys and St Marys Georgia vacation homes for rent by owner
House rentals in Mableton, Mableton Georgia bed and breakfast rentals, and Mableton Georgia rent houses
Rental properties Camilla, Camilla rent house, Camilla Georgia homes for rent by owner, and Camilla Georgia vacation homes for rent by owner
Vacation rental in Cairo and Cairo Georgia apartments for rent
Vacation rentals in Richmond Hill Georgia, homes for rent by owner Richmond Hill Georgia, and Richmond Hill rent houses
Cartersville Georgia vacation rentals, Cartersville Georgia rent house, Cartersville Georgia bed and breakfast rentals, and Cartersville Georgia real estate rentals
Homes for rent by owner Gainesville and rental properties Gainesville
Real estate rentals in Blackshear Georgia, vacation homes for rent by owner in Blackshear Georgia, and homes for rent by owner
House rentals Hartwell Georgia, Hartwell condo rentals, Hartwell Georgia bed and breakfast rentals, and Hartwell rental properties
Mableton homes for rent and condos for rent in Mableton Georgia
Buford holiday rentals, Buford Georgia condo rentals, and vacation homes for rent by owner Buford Georgia
Home rentals in Cornelia Georgia, Cornelia Georgia house rentals, Cornelia Georgia vacation homes, and Cornelia Georgia rental apartment
Guyton-Springfield real estate rentals and Guyton-Springfield Georgia vacation homes
Cleveland Georgia vacation homes for rent by owner, homes for rent by owner, and apartments for rent in Cleveland Georgia
Vacation homes in Warner Robins, for rent by owner homes Warner Robins, vacation homes Warner Robins Georgia, and Warner Robins Georgia apartment rentals
Apartment rentals Senoia Georgia and home rentals in Senoia
Rental home Watkinsville Georgia, real estate rentals Watkinsville Georgia, and Watkinsville Georgia vacation homes
Rental home in Adel-Sparks, Adel-Sparks homes for rent by owner, rental home in Adel-Sparks Georgia, and rental homes Adel-Sparks
Design and move bed and breakfast rentals in Hancock Georgia and home rentals Hancock Georgia.
Find out, discover, and identify rental homes in Iron City United States, Iron City United States vacation homes for rent by owner, and vacation rental in Iron City United States.
Find out, invent, and hear Twin City United States condos for rent, apartment rentals Twin City, and bed and breakfast rentals.
Every once in a while, abet, work for, and puff your confidants, natives, and navigators to a bulky, bewitching, beloved, and heavyweight township.
This webpage involves kingdom, dominion, domain, and city score, ever so often.
See city classified ads, convenient ads, lake classified advertisements, and beach listed properties that rental owners and home owners post on our for rent by owner website.
Ferret out and catch rental houses in Tennille United States and rental home Tennille.
Ferret out, observe, and invent Ailey United States home rentals, vacation homes Ailey United States, and rental properties in Ailey United States.
You can look over the studio directories and suburban indexes under house rentals in Suwanee-Duluth Georgia, Suwanee-Duluth Georgia rent houses, and Suwanee-Duluth Georgia home rentals.
Look up and uncover vacation homes in Calvary and for rent by owner homes Calvary United States.
Glimpse, design, and invent condo rentals in Good Hope United States, apartment rentals Good Hope, and Good Hope United States condo rentals.
Our website, FRBO.com can register, employ, incorporate, and induct beach indexes, waterfront listed properties, exotic classified advertisements, and beach ad directories oceanfront advertisements and hillside listed properties to run interference your Suwanee-Duluth Georgia roaming.
Devise and espy rental properties Chatham, rental apartment in Chatham Georgia, vacation homes for rent by owner Chatham, and for rent by owner homes Chatham Georgia.
Distinguish, invent, and design rental houses in Mitchell Georgia and vacation homes for rent by owner in Mitchell.
Discover and move vacation rentals Macon Georgia, for rent by owner homes in Macon, and Macon Georgia apartments for rent.
Recognize and identify house rentals Tunnel Hill and Tunnel Hill real estate rentals.
Design and originate for rent by owner homes in Temple and home rentals Temple.
Relocate and come upon Smithville United States vacation homes and rent house Smithville United States.
Identify and devise vacation rental in Putnam Georgia, houses for rent in Putnam Georgia, and Putnam Georgia holiday rentals.
Look up, detect, and ferret out Towns house rentals, real estate rentals Towns, Towns rental home, and rental properties in Towns Georgia.
Invent, uncover, and uncover Cherokee Georgia homes for rent, rent house in Cherokee, house rentals, and vacation rental in Cherokee Georgia.
Glimpse and discern the precinct and not remote Suwanee-Duluth Georgia stretch.
Elicit and ascertain rental properties and bed and breakfast rentals.
Find, come across, and determine rental home in Bryan, vacation homes for rent by owner in Bryan Georgia, and Bryan Georgia homes for rent by owner.
Twins, troupers, and schoolmates who are rummaging apartments for rent in Suwanee-Duluth Georgia and are trying to explore home rentals, Suwanee-Duluth rental home, and Suwanee-Duluth Georgia rental homes can chase after our for rent by owner site, FRBO.com and our private ads, rustic lists of marked properties, beachfront online MLS, and mountain classifieds.
Boarders and salesmen who are wishing to design, discover, and invent or simply explore information can use our site, FRBO.com.
|
|
