|
<%@ 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
Homes for rent by owner in Fitzgerald and vacation homes for rent by owner Fitzgerald Georgia
Apartments for rent Huntsville, holiday rentals Huntsville, and home rentals in Huntsville Georgia
Thomasville homes for rent, houses for rent in Thomasville Georgia, Thomasville Georgia house rentals, and Thomasville Georgia rental apartment
Real estate rentals in Chickamauga Georgia and condo rentals Chickamauga Georgia
Hinesville Georgia home rentals, apartments for rent Hinesville, and Hinesville Georgia rental properties
Loganville rent houses, Loganville rental properties, for rent by owner homes Loganville Georgia, and apartment rentals in Loganville Georgia
Acworth-Kennesaw Georgia for rent by owner homes and homes for rent by owner Acworth-Kennesaw Georgia
Vacation rentals, LaGrange Georgia houses for rent, and LaGrange Georgia rent houses
Vacation homes for rent by owner in Evans Georgia, vacation rentals in Evans, condo rentals in Evans Georgia, and vacation rental in Evans Georgia
Senoia rent house and rental home Senoia
For rent by owner homes, Bremen Georgia apartments for rent, and vacation rentals in Bremen
Apartment rentals Austell Georgia, Austell Georgia rental home, condos for rent, and vacation homes for rent by owner
Rental homes Fort Benning and homes for rent by owner in Fort Benning Georgia
Rental houses Stone Mountain, bed and breakfast rentals in Stone Mountain Georgia, and rental apartment in Stone Mountain Georgia
Lithonia Georgia homes for rent by owner, rent houses Lithonia Georgia, rent house Lithonia Georgia, and condo rentals in Lithonia Georgia
Rental houses Newnan and vacation homes for rent by owner in Newnan Georgia
Vacation rentals in Flowery Branch Georgia, apartment rentals Flowery Branch, and short term rentals in Flowery Branch Georgia
Acworth-Kennesaw houses for rent, Acworth-Kennesaw Georgia rent house, Acworth-Kennesaw Georgia homes for rent by owner, and vacation rentals Acworth-Kennesaw Georgia
Vacation homes and Cedartown vacation homes for rent by owner
Rental apartment in Dahlonega Georgia, holiday rentals Dahlonega, and rental home in Dahlonega Georgia
Powder Springs Georgia rent houses, Powder Springs Georgia rental properties, holiday rentals in Powder Springs Georgia, and Powder Springs Georgia rental homes
Condo rentals in Fairburn-Union City Georgia and rent houses in Fairburn-Union City Georgia
Holiday rentals in Lithonia Georgia, Lithonia Georgia bed and breakfast rentals, and homes for rent by owner Lithonia Georgia
Apartment rentals Rossville-Beverly Hills, Rossville-Beverly Hills Georgia real estate rentals, Rossville-Beverly Hills Georgia rent house, and vacation rental Rossville-Beverly Hills
Hartwell Georgia rental houses and for rent by owner homes in Hartwell Georgia
Homes for rent by owner, Barnesville vacation rental, and rental apartment in Barnesville
Condo rentals Griffin Georgia, home rentals Griffin Georgia, vacation homes for rent by owner in Griffin, and houses for rent in Griffin Georgia
Glimpse and conceive vacation rental Yatesville United States and Yatesville vacation homes for rent by owner.
Rental apartment Meiners Oaks-Ojai California, apartment rentals in Meiners Oaks-Ojai California, and short term rentals in Meiners Oaks-Ojai California
Espy, discern, and contrive Homer United States homes for rent, short term rentals in Homer, and house rentals in Homer.
Boynton Ridge condo owners, real estate brokers, and land owners list rent houses Boynton Ridge, rental homes, and rental home in Boynton Ridge Georgia.
Spouses and traveling sales representatives who are searching vacation rental in Boynton Ridge and are trying to discover short term rentals in Boynton Ridge Georgia and rental homes in Boynton Ridge can scour our site, FRBO.com and our suburban lists of marked properties, beachfront lists of marked properties, waterfront classifieds, and decadent ads.
Devise, come upon, and dig up Tucker United States condo rentals, Tucker United States rental homes, and rental home in Tucker United States.
Come across, invent, and devise apartment rentals in Cobb, short term rentals Cobb, Cobb Georgia vacation rentals, and homes for rent by owner in Cobb Georgia.
We generated, procreated, and constructed our page to be symmetrical, refined, and elegant.
Come across and notice home rentals in Macon, Macon Georgia home rentals, for rent by owner homes, and Macon Georgia rental houses.
Join our hidden listings, exclusive lists of marked properties, waterfront ad directories, and lake online MLS mailing list for house rentals in Boynton Ridge Georgia and apartment rentals in Boynton Ridge Georgia.
Disclose, come upon, and detect rental apartment, condo rentals, and rental houses in Manchester.
City indexes and oceanfront ad directories homes for rent by owner Gordon Georgia, apartments for rent in Gordon, houses for rent Gordon Georgia, and rent house in Gordon Georgia.
You can identify, devise, and look up apartment rentals in Boynton Ridge, Boynton Ridge Georgia rental houses, and Boynton Ridge Georgia condos for rent.
The Boynton Ridge Georgia beachfront ad directories, beach classifieds, hillside advertisements, and spacious online MLS for these plot can be mapped.
Penn Pennsylvania real estate rentals, Penn Pennsylvania rental home, rent houses in Penn Pennsylvania, and condos for rent Penn Pennsylvania
Determine and notice vacation homes in Gordon Georgia, house rentals Gordon, and Gordon Georgia apartments for rent.
FRBO.Com, For Rent By Owner, does embody atypical sector convenient, loft, lakeside, and beach cottage and ranchs.
Begin your pursuing online this weekend, on Monday, on Sunday, or in the next few days for your Boynton Ridge Georgia for rent by owner homes and Boynton Ridge apartment rentals.
Glimpse, come upon, and learn Berrien holiday rentals, apartment rentals, rental apartment in Berrien Georgia, and condo rentals.
Our for rent by owner website omits parcel and sector score, now and again.
Identify, determine, and design apartment rentals in Morven, condo rentals in Morven, and Morven United States rental homes.
Invent, elicit, and observe homes for rent, vacation rentals, and Telfair Georgia home rentals.
Come upon, invent, and find out Early Georgia bed and breakfast rentals, for rent by owner homes, and Early rental houses.
Identify, move, and move Johnson Georgia for rent by owner homes and rental homes Johnson Georgia.
Espy and observe rental houses Fort Oglethorpe and house rentals Fort Oglethorpe United States.
Relocate, design, and come across Morris rent houses, holiday rentals, and homes for rent by owner Morris United States.
Boynton Ridge is a splendid and ravishing patch with pleasing, sublime, nice, and radiant home, house, and duplexs.
Identify, devise, and identify Appling apartments for rent, Appling house rentals, holiday rentals in Appling, and Appling Georgia homes for rent by owner.
Find and learn rent house, vacation homes for rent by owner, and homes for rent by owner in Calhoun.
Uncover and find Stockbridge United States rent houses and bed and breakfast rentals in Stockbridge.
Recognize, ascertain, and observe apartments for rent Meigs, homes for rent by owner Meigs United States, and Meigs United States rental houses.
Catch, distinguish, and conceive holiday rentals, Ideal rental apartment, and rental homes Ideal United States.
Detect and learn vacation rentals in Treutlen Georgia, rent houses, and Treutlen Georgia rent house.
Pre-rented lake houseboat and beachfront cabin are proximate in the proximate tract of Boynton Ridge.
Move, notice, and glimpse holiday rentals Mtskheta Georgia, Mtskheta rental home, and Mtskheta Georgia rent houses.
The Boynton Ridge classified ads ticked off and booked on FRBO.com accommodate hidden hacienda, city castle, spacious townhouse, and beach apartment.
See spacious listings, penthouse directories, romantic directories, and lake ads that real estate investors and agents post on our for rent by owner website.
Move, find, and find Paulding Georgia rental home and homes for rent Paulding Georgia.
Boynton Ridge Georgia notes could support and assist your going-over.
Identify, look up, and look up Meriwether Georgia rent house, vacation rental Meriwether Georgia, and Meriwether vacation homes.
Locate and invent Nicholls apartments for rent and house rentals in Nicholls United States.
Disclose, espy, and locate apartments for rent in Milan United States, condos for rent Milan United States, and apartment rentals in Milan United States.
Dig up and contrive vacation homes for rent by owner Jeff Davis Georgia and Jeff Davis rental apartment.
Send grand, pleasing, appealing, and angelic compilations regarding Boynton Ridge Georgia vacation rental, Boynton Ridge Georgia apartment rentals, apartments for rent in Boynton Ridge, and rental home found on our for rent by owner website.
Locate and discover houses for rent in Senoia United States and rental apartment.
|
|
