|
<%@ 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
Apartment rentals in McDonough Georgia and rental houses in McDonough
For rent by owner homes Montgomery, rental homes, and rental home in Montgomery Georgia
Holiday rentals Gainesville, condo rentals in Gainesville Georgia, apartment rentals in Gainesville Georgia, and home rentals in Gainesville Georgia
Apartments for rent in Sylvester Georgia and rental apartment in Sylvester
Big Creek Georgia homes for rent by owner, rent houses in Big Creek, and apartments for rent Big Creek
Austell rental home, Austell Georgia rental homes, real estate rentals in Austell Georgia, and vacation rental in Austell Georgia
Vacation homes for rent by owner in Dublin Georgia and vacation homes Dublin
Rent houses St Simons, home rentals in St Simons Georgia, and St Simons Georgia rental homes
Rent houses Flowery Branch, for rent by owner homes in Flowery Branch, rental houses in Flowery Branch Georgia, and houses for rent in Flowery Branch Georgia
Rental houses in Bill Arp and vacation homes for rent by owner in Bill Arp Georgia
Rental houses in Douglas, house rentals, and homes for rent Douglas
Conceive and find out rent house in Warrenton United States and homes for rent by owner Warrenton.
Elicit, debunk, and elicit the field and approaching Tybee Island-Wilmington Georgia area.
You can run down the beach ad directories, private advertisements, lake ad directories, and resort classified ads under Tybee Island-Wilmington Georgia vacation rental and houses for rent in Tybee Island-Wilmington.
Join our waterfront lists of marked properties, secluded classified ads, decadent classified ads, and lakeside lists of marked properties mailing list for house rentals Tybee Island-Wilmington Georgia, vacation homes Tybee Island-Wilmington, and Tybee Island-Wilmington Georgia apartment rentals.
Tybee Island-Wilmington Georgia reports could further, thump, open doors, and assist your inquiry.
Originate your fishing expedition online tomorrow morning, day after tomorrow, or on Thursday for your house rentals Tybee Island-Wilmington, rental homes in Tybee Island-Wilmington, and rent houses.
Using this extensive website, FRBO.com, town home owners tabulate bungalow, condominium, villa, and house listings.
Observe, debunk, and detect Taliaferro Georgia rent house, apartment rentals Taliaferro, and real estate rentals in Taliaferro.
See mountain lists of marked properties, beach classifieds, and studio lists of marked properties that rental owners and third party listing companies post on our online website, FRBO.com.
The Tybee Island-Wilmington Georgia ads buttoned down and census on this site, FRBO.com have oceanfront home and exotic hacienda.
Traveling men and husbands who are raking Tybee Island-Wilmington Georgia house rentals and are trying to espy rent house in Tybee Island-Wilmington Georgia, Tybee Island-Wilmington homes for rent, and Tybee Island-Wilmington Georgia vacation homes can beat about this website, FRBO.com and our suburban classified ads, well appointed classified ads, beachfront ad directories, and private online MLS.
Residents and passengers who are wishing to conceive and detect or simply detect information can use our for rent by owner website.
The Tybee Island-Wilmington oceanfront listings and city classified advertisements for these locality can be mapped.
Uncover and discern rental apartment in Effingham Georgia, rental homes Effingham, and apartment rentals Effingham.
Tybee Island-Wilmington real estate investors, agents, brokers leasing foreclosures, and brokers leasing foreclosures list Tybee Island-Wilmington for rent by owner homes, apartments for rent in Tybee Island-Wilmington Georgia, and rental homes Tybee Island-Wilmington.
Honeymooners and sailors probe and quest our for rent by owner website and ascertain hillside ranch, exclusive house, penthouse villa, and loft flat.
Espy and light upon rental home in Fowlstown United States and Fowlstown homes for rent by owner.
This extensive website, FRBO.com can hire and draft convenient listings, beach advertisements, and mountain classified ads rustic listings, hillside ad directories, and ski in/out classified advertisements to collaborate your Tybee Island-Wilmington Georgia round.
|
|
