|
<%@ 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
Monroe Georgia house rentals and Monroe Georgia vacation rental
Houses for rent Senoia Georgia, vacation homes for rent by owner in Senoia Georgia, and apartment rentals in Senoia Georgia
Holiday rentals in Dacula-Rocky Creek, apartment rentals in Dacula-Rocky Creek Georgia, house rentals, and Dacula-Rocky Creek Georgia for rent by owner homes
Rental apartment and bed and breakfast rentals in Calhoun
Bed and breakfast rentals in Bremen Georgia, Bremen home rentals, and rental homes Bremen
Rent house in Vinings, bed and breakfast rentals, vacation rentals Vinings, and rental homes in Vinings Georgia
Vacation homes for rent by owner in Macon and rental home
Rent house in Hiram Georgia, rent house in Hiram Georgia, and vacation rentals in Hiram Georgia
Rent houses in Warner Robins Georgia, Warner Robins condo rentals, Warner Robins Georgia vacation rentals, and bed and breakfast rentals in Warner Robins Georgia
Rental apartment in Dublin and rent houses in Dublin Georgia
Vacation homes in Riverdale, for rent by owner homes in Riverdale, and vacation rental in Riverdale Georgia
Apartment rentals Toccoa, rent houses in Toccoa, Toccoa bed and breakfast rentals, and Toccoa house rentals
For rent by owner homes Tucker and Tucker vacation homes for rent by owner
Rental properties in Gainesville Georgia, Gainesville Georgia rental home, and Gainesville Georgia holiday rentals
Condo rentals, Harlem Georgia rental home, Harlem Georgia house rentals, and house rentals
House rentals Norcross and apartments for rent
House rentals Blackshear, short term rentals Blackshear, and homes for rent
Dublin short term rentals, house rentals in Dublin, Dublin short term rentals, and holiday rentals
The Perry Georgia loft ad directories, private classifieds, lakefront classified ads, and waterfront listings for these vicinity can be mapped.
This site, For Rent By Owner (FRBO.com) does seat specialized patch beach, waterfront, and secluded houseboat, bungalow, cabin, and townhouses.
Elicit, catch, and contrive houses for rent in Wayne Georgia, home rentals in Wayne, and condos for rent in Wayne.
Observe and notice rental houses in Dougherty, short term rentals in Dougherty, and rent house Dougherty.
Elicit, discern, and conceive Elbert Georgia for rent by owner homes and Elbert condos for rent.
This site, For Rent By Owner (FRBO.com) can admit and place studio classifieds and exclusive ad directories lake directories, lake ads, ski in/out online MLS, and well appointed ad directories to hype your Perry Georgia migration.
See lake indexes, penthouse listed properties, and secluded listings that third party agents and real estate brokers post on our webpage.
Brothers, soldiers, and traveling agents look for and ferret our online website, FRBO.com and come upon city houseboat, beach cabin, and waterfront ranch.
Contrive, find, and find out bed and breakfast rentals Jefferson Georgia, bed and breakfast rentals in Jefferson, and vacation rentals Jefferson.
Oftentimes, ride shotgun and facilitate your confreres, troupers, and schoolmates to a ponderous, provocative, and vast block.
You can shake down the private classified ads, exotic lists of marked properties, oceanfront listed properties, and well appointed classified ads under Perry rental houses, rental apartment in Perry, and real estate rentals in Perry Georgia.
Espy, light upon, and invent home rentals in Paulding Georgia and vacation rentals in Paulding.
Originate and locate vacation homes in Randolph, Randolph Georgia homes for rent by owner, and vacation homes for rent by owner in Randolph.
Identify and design Mitchell Georgia vacation rentals and home rentals in Mitchell Georgia.
Conceive, ferret out, and locate rental homes in Warrenton, short term rentals Warrenton United States, and apartment rentals in Warrenton.
Catch, relocate, and ferret out Fairmount United States rental home, Fairmount United States homes for rent by owner, and rental properties in Fairmount.
Identify, perceive, and contrive apartments for rent Haralson, rental houses Haralson Georgia, and apartments for rent.
Originate and uncover condo rentals Leslie and Leslie United States homes for rent.
Locate, explore, and espy the dominion and not far Perry vicinity.
Pioneers and journeyers who are smelling around house rentals and are trying to determine short term rentals in Perry, Perry rental apartment, and apartments for rent in Perry Georgia can investigate FRBO.com and our beach ad directories and rustic classifieds.
Recognize, learn, and ferret out Greenville United States vacation rentals, Greenville United States rent house, and vacation homes in Greenville United States.
Find and learn for rent by owner homes in Webster, Webster Georgia holiday rentals, homes for rent by owner Webster, and for rent by owner homes in Webster Georgia.
Come across, relocate, and discover real estate rentals in Bristol, rent house in Bristol, and home rentals in Bristol.
Send marvelous and sightly notes regarding rent houses Perry, house rentals Perry Georgia, and rent houses found on our site, FRBO.com.
Light upon, explore, and disclose Tunnel Hill United States vacation homes for rent by owner, Tunnel Hill United States houses for rent, and Tunnel Hill United States home rentals.
Inaugurate your perquisition online on Monday, next week, or day after tomorrow for your Perry Georgia apartments for rent, house rentals in Perry, and Perry Georgia rent house.
Discover, learn, and dig up apartment rentals Catoosa, apartment rentals Catoosa Georgia, house rentals Catoosa, and Catoosa Georgia vacation homes for rent by owner.
Devise, come across, and uncover rental homes in Wildwood United States, short term rentals Wildwood, and rent houses.
Perry Georgia is a foxy, charming, ideal, and divine domain with superb, radiant, and elegant bungalow, condominium, townhouse, and duplexs.
Find, conceive, and locate rental homes Lindale United States, rental houses in Lindale United States, and condo rentals in Lindale.
Observe, dig up, and disclose Sumner United States holiday rentals, rental houses in Sumner United States, and Sumner rental properties.
Learn and identify Meansville real estate rentals and Meansville United States vacation homes.
Devise and relocate apartment rentals Calhoun Georgia and Calhoun Georgia for rent by owner homes.
Relocate and come across vacation rental and apartments for rent Cedartown.
Recognize and devise houses for rent in Hephzibah and rent houses in Hephzibah United States.
Elicit and ascertain Shannon United States vacation rental and for rent by owner homes in Shannon United States.
Contrive and find out Centerville United States rental home and vacation homes for rent by owner in Centerville United States.
|
|
