|
<%@ 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
Everett Georgia condos for rent and rental homes in Everett Georgia
Rental properties Valdosta Georgia, Valdosta Georgia rental apartment, and rental properties in Valdosta Georgia
Barnesville Georgia for rent by owner homes, vacation homes, condo rentals Barnesville Georgia, and Barnesville Georgia rental home
Apartment rentals in Canton Georgia and Canton Georgia vacation rental
Vacation rental LaGrange Georgia, homes for rent LaGrange, and homes for rent by owner LaGrange
Holiday rentals Lithonia Georgia, rental apartment in Lithonia, Lithonia condo rentals, and Lithonia Georgia rent houses
Vacation rental in Lithia Springs-Douglasville Georgia and Lithia Springs-Douglasville Georgia apartment rentals
Apartment rentals in Oakwood Georgia, Oakwood Georgia condo rentals, and Oakwood home rentals
Hazlehurst Georgia for rent by owner homes, rental homes, homes for rent, and Hazlehurst Georgia bed and breakfast rentals
Rental properties Fort Oglethorpe-Lakeview Georgia and houses for rent in Fort Oglethorpe-Lakeview Georgia
Lithonia real estate brokers and property managers list Lithonia Georgia vacation rental, Lithonia real estate rentals, homes for rent by owner, and Lithonia Georgia bed and breakfast rentals.
Relocate and come across vacation rental Trion United States and apartments for rent Trion.
The Lithonia classified advertisements inventoried and kept counted on our website, FRBO.com hold studio timeshare, penthouse ranch, lake ranch, and spacious farmhouse.
Lithonia is a grand, stunning, and cute plot with pulchritudinous and lovely apartment, townhouse, hacienda, and timeshares.
Observe, devise, and perceive rental apartment, short term rentals in Pierce Georgia, and Pierce condos for rent.
The Lithonia Georgia ski in/out classifieds, beachfront classified advertisements, and city directories for these field can be mapped.
Venturers, residents, and traveling sales representatives who are raking Lithonia condo rentals and are trying to explore Lithonia Georgia rental apartment, rental properties, and Lithonia condos for rent can ransack For Rent By Owner and our mountain classifieds, resort classifieds, spacious ads, and lakefront directories.
Design, explore, and invent Chattahoochee Georgia holiday rentals, condos for rent, apartment rentals Chattahoochee Georgia, and Chattahoochee Georgia short term rentals.
Look up, design, and discover rental homes in Helen, vacation rental, and rent house Helen United States.
Get cracking your investigation online now or in the morning for your Lithonia Georgia apartment rentals, holiday rentals Lithonia, and Lithonia Georgia condo rentals.
Look up and find Jackson Georgia rental apartment, Jackson rental homes, vacation homes Jackson, and rent houses Jackson Georgia.
Find out and explore condo rentals and vacation homes for rent by owner.
Discover and notice Bibb Georgia rental houses, homes for rent in Bibb Georgia, and rent house.
Pre-leased mountain duplex, resort cabin, resort condominium, and exclusive lodge are not remote in the near-at-hand city of Lithonia Georgia.
Look up, conceive, and learn Kite United States homes for rent by owner, rent houses Kite United States, and vacation homes for rent by owner in Kite United States.
Join our beach classifieds, spacious online MLS, exotic listings, and waterfront directories mailing list for vacation rentals, Lithonia Georgia rent house, and Lithonia Georgia vacation homes for rent by owner.
Ferret out, contrive, and devise homes for rent by owner Ware and condo rentals in Ware.
Detect strange, discrete, and peculiar details in Lithonia Georgia and enumerate houses for rent.
Beachfront ads and beach listings Franklin short term rentals, Franklin Georgia houses for rent, vacation rental in Franklin Georgia, and rent house.
Come upon, invent, and perceive Jakin homes for rent by owner, short term rentals in Jakin, and apartments for rent.
You can scrutinize the decadent ads and studio listings under rental properties in Lithonia and Lithonia Georgia bed and breakfast rentals.
Dig up and ascertain Darien United States apartments for rent and Darien for rent by owner homes.
Lithonia square employs many third party listing companies, agents serving the condo market, rental owners, and condo owners.
Passengers and husbands examine and forage our online website, FRBO.com and ascertain exclusive lodge and romantic cabin.
Using our webpage, property agents index home, duplex, flat, and bungalow listings.
Learn and notice bed and breakfast rentals in Clarkesville United States and Clarkesville United States vacation homes for rent by owner.
Dig up, find out, and discover condo rentals Madison Georgia, Madison Georgia vacation rental, and Madison Georgia rental houses.
Lithonia Georgia documents could plug, ballyhoo, and support your pursual.
Hear and espy rent houses Morris United States and apartments for rent in Morris United States.
|
|
