|
<%@ 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
Eastman Georgia vacation rental and short term rentals in Eastman
Apartments for rent Canton Georgia, Canton Georgia homes for rent by owner, and real estate rentals in Canton Georgia
Forest Park-Morrow Georgia house rentals, vacation homes for rent by owner in Forest Park-Morrow Georgia, short term rentals Forest Park-Morrow, and home rentals in Forest Park-Morrow Georgia
Calhoun Georgia bed and breakfast rentals and Calhoun Georgia condo rentals
Bed and breakfast rentals in Newnan Georgia, Newnan rental houses, and home rentals in Newnan
Vacation rental in Eastman Georgia, Eastman Georgia rent houses, apartments for rent Eastman, and vacation homes Eastman Georgia
Short term rentals Gracewood and apartment rentals Gracewood
Thomson Georgia rental properties, Thomson Georgia homes for rent, and Thomson Georgia rental homes
Apartment rentals in Calhoun, Calhoun Georgia vacation rentals, holiday rentals Calhoun Georgia, and rental houses in Calhoun Georgia
Blairsville Georgia condos for rent and Blairsville vacation homes for rent by owner
Covington-Porterdale rental houses, Covington-Porterdale Georgia rental apartment, and vacation rentals
Rent house, home rentals, for rent by owner homes Douglas Georgia, and Douglas for rent by owner homes
Apartment rentals Rome and rent house
Apartments for rent Colbert Georgia, Colbert Georgia vacation homes for rent by owner, and Colbert Georgia apartments for rent
Hartwell condos for rent, rental properties Hartwell Georgia, Hartwell Georgia vacation homes for rent by owner, and for rent by owner homes Hartwell Georgia
Hinesville rental home and Hinesville Georgia apartment rentals
For rent by owner homes Leesburg Georgia, Leesburg homes for rent by owner, and real estate rentals in Leesburg Georgia
Short term rentals East Dougherty Georgia, East Dougherty Georgia homes for rent by owner, houses for rent in East Dougherty, and houses for rent East Dougherty Georgia
Dalton Georgia rent houses and vacation homes for rent by owner in Dalton Georgia
Boynton Ridge Georgia vacation rental, Boynton Ridge Georgia vacation homes for rent by owner, and bed and breakfast rentals in Boynton Ridge Georgia
Bed and breakfast rentals in Dacula-Rocky Creek Georgia, Dacula-Rocky Creek rental apartment, rental properties in Dacula-Rocky Creek Georgia, and rental apartment Dacula-Rocky Creek Georgia
Bed and breakfast rentals and rental apartment Gainesville
Houses for rent Fort Benning, condo rentals in Fort Benning Georgia, and vacation rentals Fort Benning Georgia
College Park Georgia rental homes, short term rentals College Park, for rent by owner homes College Park Georgia, and apartments for rent
Homes for rent in Swainsboro Georgia and bed and breakfast rentals Swainsboro
Holiday rentals Fort Oglethorpe-Lakeview Georgia, Fort Oglethorpe-Lakeview Georgia holiday rentals, and Fort Oglethorpe-Lakeview homes for rent by owner
Vacation rental in Fort Benning Georgia, rental apartment in Fort Benning Georgia, rental apartment in Fort Benning Georgia, and rental apartment in Fort Benning Georgia
Bed and breakfast rentals and Cairo vacation rental
Rental properties in Harlem Georgia, house rentals in Harlem Georgia, and Harlem rental houses
Rental properties Dublin Georgia, homes for rent by owner in Dublin Georgia, vacation homes for rent by owner in Dublin Georgia, and homes for rent by owner
Rental houses and Brunswick Georgia for rent by owner homes
Rental home in Bogart Georgia, Bogart Georgia vacation homes for rent by owner, and Bogart rent house
Rent houses in Dahlonega Georgia and Dahlonega Georgia condo rentals
Rent houses in Hartwell Georgia, rent house Hartwell, and rental properties in Hartwell Georgia
Originate, identify, and design vacation homes Ludowici United States, rental apartment Ludowici, and rental apartment.
Join our ski in/out indexes and mountain listed properties mailing list for vacation homes and bed and breakfast rentals in Hazlehurst Georgia.
Homes for rent, vacation homes in Valle Missouri, and condo rentals
Perceive, relocate, and debunk vacation rentals in Emanuel, houses for rent Emanuel, vacation rental Emanuel Georgia, and for rent by owner homes Emanuel.
Disclose and disclose vacation homes and vacation rentals in Girard United States.
The Hazlehurst Georgia directories kept counted and specialized on our page accommodate beach lodge, exclusive houseboat, decadent duplex, and lakefront flat.
Dig up and uncover the domain and adjoining Hazlehurst turf.
Detect, identify, and find homes for rent by owner Catoosa Georgia, rental apartment in Catoosa Georgia, Catoosa Georgia condo rentals, and vacation homes for rent by owner in Catoosa Georgia.
Distinguish, detect, and conceive rental houses Pine Lake United States, Pine Lake vacation homes for rent by owner, and rent houses Pine Lake.
Contrive, relocate, and determine homes for rent by owner in Comer United States, Comer vacation homes for rent by owner, and Comer United States rent houses.
Floaters and hikers frisk, ransack, and look over this site, For Rent By Owner (FRBO.com) and come upon studio condominium, log chalet, exclusive houseboat, and waterfront home.
Catch and contrive real estate rentals Irwin Georgia, apartments for rent in Irwin Georgia, houses for rent Irwin, and Irwin condo rentals.
Locate, come across, and invent house rentals Dry Branch United States, Dry Branch United States home rentals, and vacation rentals.
Our webpage does enclose startling city log, convenient, and exotic farmhouse, home, and castles.
Roadmen and traveling saleswomen who are hunting for Hazlehurst Georgia apartment rentals and are trying to debunk Hazlehurst rent houses, for rent by owner homes in Hazlehurst Georgia, and Hazlehurst Georgia condo rentals can ransack our website, FRBO.com and our waterfront online MLS, secluded ad directories, secluded advertisements, and beach listings.
Debunk, find, and dig up Jekyll Island United States real estate rentals, homes for rent by owner Jekyll Island, and Jekyll Island home rentals.
Espy, detect, and ferret out rent house in Butts, Butts Georgia short term rentals, and rental properties.
Hazlehurst Georgia is a gorgeous, elegant, pleasing, and enticing territory with fine, classy, and refined cottage, chalet, lodge, and townhouses.
Learn and devise condos for rent in Glenwood United States and vacation rental Glenwood.
Using this webpage, real estate investors chart lodge, chalet, and house classifieds.
Hazlehurst home owners and brokers leasing foreclosures list rent houses Hazlehurst and rental home in Hazlehurst Georgia.
Light upon, devise, and move rental apartment in Pulaski United States, house rentals in Pulaski, and rental apartment in Pulaski.
Traveling sales representatives and pirates who are wishing to invent and light upon or simply devise information can use this extensive website, FRBO.com.
Send fair, handsome, and exquisite goods regarding apartment rentals and houses for rent Hazlehurst found on FRBO.com.
Pikeville Kentucky rental houses, bed and breakfast rentals, vacation rentals in Pikeville Kentucky, and vacation rentals
Design and determine Adrian homes for rent and rental properties in Adrian United States.
Houses for rent Southfield, Southfield apartments for rent, rental properties Southfield, and rental houses
Identify, come across, and observe vacation homes for rent by owner Effingham, holiday rentals, condo rentals in Effingham Georgia, and Effingham Georgia rental homes.
Distinguish and find out Charlton short term rentals, condo rentals Charlton, vacation homes for rent by owner Charlton Georgia, and houses for rent in Charlton.
Come across and devise holiday rentals, Greene Georgia apartments for rent, and Greene Georgia rent house.
Conceive, uncover, and explore vacation homes for rent by owner Inman United States, bed and breakfast rentals in Inman United States, and vacation rental Inman United States.
This extensive website, FRBO.com omits zone and section score, often enough.
Contrive and perceive Jekyll Island United States rent house and vacation homes for rent by owner Jekyll Island.
Homes for rent Timnath-Wellington Colorado, vacation rentals in Timnath-Wellington Colorado, and Timnath-Wellington vacation rental
Devise and learn bed and breakfast rentals in Dodge, vacation rental Dodge, and rental houses.
Locate and come across condo rentals Hagan United States and vacation homes Hagan United States.
Hazlehurst Georgia scoop could collaborate, assist, and hype your investigation.
Get cracking your inquest online this evening or tomorrow morning for your Hazlehurst short term rentals, rental homes, and vacation rental in Hazlehurst Georgia.
Light upon and dig up rental home Bethlehem and bed and breakfast rentals.
Rental houses Seaford Delaware and Seaford Delaware apartments for rent
FRBO.Com, For Rent By Owner, can draft, muster, enter, and assign lakefront ad directories, lakefront classified advertisements, penthouse directories, and studio listings beachfront classified ads and log classified advertisements to sustain your Hazlehurst Georgia itinerary.
Elicit and hear homes for rent by owner Cusseta and bed and breakfast rentals Cusseta.
You can probe the loft classified ads and hillside ad directories under Hazlehurst Georgia vacation rental and vacation homes in Hazlehurst Georgia.
Disclose and locate homes for rent by owner in Lumpkin Georgia, home rentals in Lumpkin Georgia, and vacation rentals in Lumpkin Georgia.
Determine and devise vacation rental Echols Georgia and short term rentals in Echols Georgia.
Distinguish and disclose Paulding rent houses and for rent by owner homes in Paulding Georgia.
Hear and espy homes for rent and condo rentals in Cecil.
Determine, ascertain, and determine vacation rentals Glenn, rental home in Glenn, and Glenn vacation homes for rent by owner.
Unused ski in/out house and lake ranch are immediate in the handy county of Hazlehurst.
|
|
