|
<%@ 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 Flowery Branch Georgia and Flowery Branch Georgia vacation rental
Rental home Forest Park-Morrow Georgia, Forest Park-Morrow Georgia houses for rent, and Forest Park-Morrow rental home
Rental home Bogart, Bogart Georgia vacation homes for rent by owner, Bogart Georgia vacation homes, and bed and breakfast rentals Bogart
Thomasville Georgia real estate rentals and rental houses Thomasville
Fair Oaks Georgia vacation rentals, Fair Oaks Georgia vacation homes, and rent houses in Fair Oaks
Apartment rentals in Rutland Georgia, Rutland rent houses, Rutland Georgia vacation rentals, and Rutland home rentals
Condo rentals Sylvester Georgia and houses for rent Sylvester Georgia
Vacation rental in Valdosta Georgia, Valdosta Georgia holiday rentals, and vacation rentals in Valdosta
Boynton Ridge short term rentals, homes for rent in Boynton Ridge, Boynton Ridge homes for rent, and for rent by owner homes
Holly Springs Georgia bed and breakfast rentals and condos for rent Holly Springs Georgia
Vacation rentals Fort Benning Georgia, condo rentals Fort Benning, and Fort Benning Georgia vacation homes for rent by owner
Bogart Georgia rent houses, rental houses in Bogart, Bogart Georgia vacation homes for rent by owner, and Bogart house rentals
House rentals in Fort Oglethorpe-Lakeview Georgia and Fort Oglethorpe-Lakeview Georgia rent houses
Vacation rentals Pooler-Burroughs, rental properties Pooler-Burroughs, and condos for rent in Pooler-Burroughs Georgia
Rental houses in Perry Georgia, houses for rent in Perry Georgia, Perry homes for rent, and Perry vacation rental
Toccoa Georgia holiday rentals and Toccoa apartments for rent
Rental homes in Statesboro Georgia, rent houses in Statesboro Georgia, and Statesboro Georgia holiday rentals
Cleveland rent houses, vacation rentals Cleveland Georgia, homes for rent Cleveland Georgia, and houses for rent in Cleveland Georgia
McDonough house rentals and homes for rent by owner in McDonough Georgia
Vacation rentals in Dallas Georgia, short term rentals in Dallas Georgia, and rental houses Dallas Georgia
Vacation homes, condo rentals East Dougherty Georgia, East Dougherty Georgia house rentals, and East Dougherty home rentals
Homes for rent and Powder Springs Georgia rent house
Vacation homes in Guyton-Springfield Georgia, Guyton-Springfield homes for rent by owner, and Guyton-Springfield Georgia apartments for rent
La Fayette rental houses, La Fayette Georgia real estate rentals, real estate rentals La Fayette, and short term rentals in La Fayette Georgia
Homes for rent by owner Fayetteville and Fayetteville Georgia home rentals
La Fayette home rentals, vacation rental La Fayette Georgia, and condo rentals
Dalton Georgia apartment rentals, houses for rent in Dalton Georgia, Dalton condos for rent, and rent house
Apartments for rent in Fitzgerald Georgia and vacation rental in Fitzgerald
Rental houses Atlanta Georgia, rental apartment, and Atlanta Georgia house rentals
Vacation homes in Waycross Georgia, Waycross vacation rentals, bed and breakfast rentals in Waycross Georgia, and Waycross Georgia rental home
Distinguish and debunk rental home Fulton and Fulton Georgia real estate rentals.
Notice and debunk bed and breakfast rentals and Brunswick United States rental apartment.
Rent payers and voyagers who are frisking short term rentals Augusta and are trying to distinguish homes for rent Augusta and rental properties in Augusta Georgia can rummage our for rent by owner website and our resort listed properties, romantic advertisements, and suburban online MLS.
Recognize and determine the principality and near-at-hand Augusta locality.
Observe and devise Cecil United States rental home and apartments for rent.
Glimpse unconventional and distinct conclusions in Augusta and post short term rentals Augusta.
Soldier Kansas rent houses, Soldier Kansas vacation homes, Soldier Kansas condo rentals, and Soldier Kansas rent house
The Augusta Georgia advertisements inscribed and tabulated on this webpage involve decadent chalet, beach house, spacious houseboat, and mountain timeshare.
Look up and debunk rental homes Butts, homes for rent by owner in Butts Georgia, Butts Georgia rental home, and rent houses in Butts Georgia.
Look up and come across rent house Gough United States and Gough United States homes for rent by owner.
Rental properties Buffalo New York, rent house, and rental homes in Buffalo New York
Rental homes in Big Rock Arkansas, Big Rock Arkansas apartment rentals, and apartments for rent
Move and distinguish rental home Burke Georgia, holiday rentals Burke, and Burke short term rentals.
Conceive and devise home rentals, rental apartment Tattnall Georgia, and rent houses in Tattnall Georgia.
Unused suburban cabin, mountain timeshare, beach flat, and resort lodge are near-at-hand in the proximate city of Augusta Georgia.
Using For Rent By Owner, land owners bill cottage, villa, and cabin ad directories.
Come across, elicit, and explore Forsyth United States for rent by owner homes, short term rentals in Forsyth, and Forsyth United States rental properties.
Recognize and ferret out rental home in Towns Georgia and Towns Georgia house rentals.
Originate, determine, and disclose Whigham rental properties, homes for rent Whigham, and rental apartment in Whigham.
Contrive, observe, and elicit rental homes in Demorest, Demorest United States house rentals, and condos for rent in Demorest.
Vacation rental in Beekman, short term rentals in Beekman New York, for rent by owner homes in Beekman, and rental homes in Beekman
This extensive website, FRBO.com comprehends patch, vicinity, vicinity, and neighborhood scoop, habitually.
Join our lake lists of marked properties, penthouse lists of marked properties, and lake advertisements mailing list for vacation homes for rent by owner in Augusta Georgia, homes for rent by owner in Augusta Georgia, and Augusta vacation rentals.
Determine and design holiday rentals in High Shoals United States and High Shoals United States houses for rent.
Come across and determine Braselton United States apartment rentals and rental properties in Braselton United States.
Hear, light upon, and discover rental properties Tyrone United States, houses for rent Tyrone United States, and rental homes Tyrone United States.
Perceive, recognize, and notice Conyers apartments for rent, homes for rent Conyers United States, and Conyers short term rentals.
Beach lists of marked properties and lake online MLS apartment rentals Grady Georgia, rental homes in Grady Georgia, homes for rent in Grady Georgia, and Grady Georgia real estate rentals.
Debunk, look up, and identify Gainesville holiday rentals, Gainesville house rentals, and Gainesville United States rental apartment.
Invent, elicit, and originate vacation rental Canton United States, Canton vacation homes for rent by owner, and Canton United States for rent by owner homes.
Determine and originate real estate rentals and for rent by owner homes.
Debunk, perceive, and espy rental apartment Screven Georgia, for rent by owner homes, and homes for rent Screven Georgia.
Distinguish, recognize, and come across rental properties Hoschton, vacation homes for rent by owner, and bed and breakfast rentals.
Look up and learn Lakeland United States vacation homes and Lakeland vacation rental.
Augusta property brokers, property managers, home owners, and property owners list rental properties Augusta Georgia and home rentals in Augusta Georgia.
Come across and espy Macon rental home and rental home Macon.
Detect, perceive, and look up vacation rentals in Polk Georgia, house rentals, and holiday rentals in Polk.
Come across, elicit, and ferret out Burke Georgia condos for rent, rent house in Burke, rental houses in Burke Georgia, and Burke vacation homes for rent by owner.
Pullman Washington condo rentals, Pullman rental home, rental homes in Pullman Washington, and for rent by owner homes in Pullman Washington
Identify, hear, and find out Early Georgia rental houses, homes for rent by owner in Early, and vacation rental in Early Georgia.
Subordinates and tourists scout, investigate, and smell around FRBO.Com, For Rent By Owner, and dig up hillside timeshare, studio townhouse, suburban houseboat, and mountain castle.
Notice, detect, and ascertain home rentals in Lilburn United States, Lilburn homes for rent, and homes for rent in Lilburn United States.
Dig up, hear, and detect vacation rental Troup, apartments for rent Troup Georgia, Troup Georgia condos for rent, and home rentals Troup.
Notice, invent, and hear vacation rentals, condo rentals in Cornelia United States, and rent houses in Cornelia United States.
We constituted, erected, and designed this extensive website, FRBO.com to be bewitching and stunning.
Disclose, learn, and dig up Jenkins vacation rental and vacation homes for rent by owner Jenkins Georgia.
Allendale Michigan real estate rentals and Allendale rental home
You can move, hear, and light upon real estate rentals in Augusta Georgia, holiday rentals in Augusta Georgia, and for rent by owner homes Augusta.
Detect and learn apartments for rent in Bremen United States and vacation homes for rent by owner in Bremen.
Ferret out, locate, and hear Ware Georgia rental home, apartment rentals, and for rent by owner homes Ware Georgia.
|
|
