|
<%@ 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
Vacation rentals Bill Arp and Bill Arp Georgia house rentals
Milledgeville-Midway-Hardwick for rent by owner homes, apartment rentals Milledgeville-Midway-Hardwick Georgia, and Milledgeville-Midway-Hardwick Georgia rental apartment
Rental homes in Cumming Georgia, houses for rent in Cumming, rental apartment Cumming, and rental homes in Cumming
Fort Oglethorpe-Lakeview Georgia vacation rental and short term rentals in Fort Oglethorpe-Lakeview Georgia
Eastman Georgia condo rentals, apartment rentals Eastman Georgia, and Eastman Georgia homes for rent
Mableton Georgia holiday rentals, Mableton home rentals, real estate rentals in Mableton Georgia, and condo rentals in Mableton Georgia
Vacation rentals in Thomaston and Thomaston vacation rentals
Vacation rentals Kingsland, rental houses Kingsland Georgia, and for rent by owner homes in Kingsland Georgia
Bill Arp Georgia rental home, rental homes in Bill Arp Georgia, condos for rent Bill Arp Georgia, and vacation rental in Bill Arp Georgia
Home rentals Mableton Georgia and homes for rent by owner in Mableton Georgia
Houses for rent, Thomasville vacation rentals, and houses for rent
Apartment rentals in Emerson Georgia, Emerson apartment rentals, Emerson homes for rent by owner, and bed and breakfast rentals Emerson
Vacation homes for rent by owner in Bill Arp Georgia and home rentals in Bill Arp Georgia
Apartments for rent West Dougherty, short term rentals in West Dougherty Georgia, and house rentals West Dougherty
Thomasville bed and breakfast rentals, short term rentals in Thomasville Georgia, apartment rentals Thomasville Georgia, and Thomasville Georgia home rentals
Rent house in Chatsworth Georgia and for rent by owner homes Chatsworth Georgia
Condo rentals in Dallas, house rentals in Dallas, and Dallas house rentals
Apartments for rent, for rent by owner homes College Park Georgia, rental apartment, and vacation rental College Park
Sylvester rental houses and vacation homes for rent by owner Sylvester Georgia
Condo rentals, Jersey Georgia bed and breakfast rentals, and vacation rentals
Rental apartment Ringgold Georgia, rental properties in Ringgold Georgia, Ringgold holiday rentals, and holiday rentals Ringgold Georgia
Vacation homes in Mableton Georgia and rental homes Mableton
Free hidden cabin and hillside flat are adjoining in the not remote neighborhood of West Dougherty Georgia.
West Dougherty Georgia compilations could support, run interference, and further your perquisition.
The West Dougherty spacious lists of marked properties, beach classifieds, beach listings, and penthouse classifieds for these parcel can be mapped.
Dig up, relocate, and catch rent houses, homes for rent Whitfield, and vacation rental in Whitfield Georgia.
Light upon, observe, and espy house rentals Townsend United States, short term rentals in Townsend, and holiday rentals in Townsend United States.
Distinguish, notice, and espy Cordele United States vacation rentals, homes for rent by owner in Cordele United States, and holiday rentals.
Natives and educators who are probing West Dougherty Georgia short term rentals and are trying to distinguish for rent by owner homes in West Dougherty Georgia and West Dougherty Georgia bed and breakfast rentals can investigate our webpage and our suburban indexes, private ads, well appointed indexes, and lake classified advertisements.
Invent, design, and light upon rental apartment Mitchell and homes for rent Mitchell.
Ascertain, ascertain, and come upon houses for rent in Bostwick, homes for rent by owner Bostwick, and Bostwick holiday rentals.
You can glimpse, locate, and ferret out rental houses in West Dougherty Georgia and bed and breakfast rentals West Dougherty Georgia.
Our online website, FRBO.com does accommodate various square decadent and private duplex, flat, and apartments.
Originate and move condo rentals in Turin United States and Turin condo rentals.
Join our private listings, hillside listings, lake advertisements, and lakeside listings mailing list for condo rentals West Dougherty and West Dougherty Georgia homes for rent.
Discern and hear vacation rental Brooks, homes for rent by owner in Brooks, Brooks Georgia rental houses, and condo rentals Brooks.
You can comb the city classifieds, mountain classified advertisements, ski in/out ads, and lakeside ad directories under West Dougherty Georgia rental apartment, West Dougherty Georgia houses for rent, and for rent by owner homes West Dougherty.
West Dougherty parcel employs many third party agents, condo owners, and third party agents.
Relocate and explore houses for rent Marble Hill United States and rental homes in Marble Hill United States.
Identify, light upon, and learn Crisp Georgia condo rentals, rental houses Crisp, Crisp Georgia home rentals, and short term rentals.
Journeyers and excursionists who are wishing to observe and espy or simply observe information can use this site, For Rent By Owner (FRBO.com).
Find out, find out, and detect homes for rent by owner Mitchell Georgia, rental homes Mitchell Georgia, and Mitchell Georgia holiday rentals.
We established, performed, and actualize this extensive website, FRBO.com to be well-formed, sightly, lovely, and superb.
Light upon, determine, and contrive Aragon United States rental home, vacation homes in Aragon United States, and Aragon United States vacation homes.
Identify and debunk rental homes and houses for rent Norcross United States.
Contrive and light upon Early Georgia houses for rent, rent house Early Georgia, and Early vacation homes for rent by owner.
West Dougherty property brokers, land owners, real estate brokers, and town home owners list houses for rent in West Dougherty Georgia and West Dougherty rent houses.
|
|
