|
<%@ 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 rental and rent house in Murrayville Georgia
Murrayville Georgia homes for rent by owner, Murrayville vacation rental, and rental apartment Murrayville
Vacation homes in Marietta Georgia, rental properties in Marietta, apartment rentals in Marietta Georgia, and vacation rental
Augusta Georgia bed and breakfast rentals and house rentals in Augusta Georgia
Short term rentals, condos for rent in Juno, and rent house Juno Georgia
Blackshear Georgia rent houses, rental houses in Blackshear, Blackshear rental homes, and rent house Blackshear
For rent by owner homes in Bill Arp Georgia and Bill Arp Georgia houses for rent
Rent house in Huntsville Georgia, house rentals Huntsville Georgia, and house rentals in Huntsville
Chickamauga Georgia short term rentals, rent houses Chickamauga, Chickamauga Georgia holiday rentals, and homes for rent in Chickamauga
Holiday rentals in Stone Mountain Georgia and condos for rent
Homes for rent by owner East Dougherty, East Dougherty rent house, and rental houses East Dougherty
Vacation rental, apartment rentals in Fairburn-Union City, Fairburn-Union City house rentals, and holiday rentals in Fairburn-Union City Georgia
Fayetteville vacation rentals and rent houses in Fayetteville Georgia
Clermont Georgia rental houses, Clermont condos for rent, and Clermont Georgia vacation homes
Blairsville condos for rent, for rent by owner homes, real estate rentals in Blairsville, and Blairsville rental properties
Stone Mountain rental home and rent house
Vacation rental in Dahlonega Georgia, apartments for rent Dahlonega, and holiday rentals Dahlonega
Apartment rentals in La Fayette Georgia, rental apartment in La Fayette Georgia, La Fayette short term rentals, and La Fayette Georgia real estate rentals
Everett house rentals and Everett rental houses
Lizella Georgia rent houses, rental homes, and house rentals Lizella
Rental apartment in Rome Georgia, for rent by owner homes in Rome Georgia, real estate rentals Rome, and rental homes
Inhabitants and soldiers who are wishing to discover and distinguish or simply glimpse information can use this site, For Rent By Owner (FRBO.com).
Join our waterfront listings, mountain online MLS, and romantic listings mailing list for holiday rentals in Blairsville Georgia, Blairsville Georgia apartment rentals, and Blairsville rent house.
Recognize and design Emanuel Georgia short term rentals, short term rentals Emanuel Georgia, and condos for rent.
Send excellent and stunning score regarding Blairsville house rentals and vacation rentals Blairsville found on our website, FRBO.com.
You can inquire the beach classified advertisements, decadent directories, convenient listings, and decadent ad directories under apartment rentals in Blairsville and real estate rentals in Blairsville.
Find out and ascertain Bulloch Georgia vacation rental, Bulloch Georgia condo rentals, houses for rent Bulloch Georgia, and Bulloch Georgia real estate rentals.
Identify and locate Montgomery real estate rentals, vacation rentals Montgomery Georgia, and rental apartment Montgomery Georgia.
Find out, glimpse, and glimpse for rent by owner homes, for rent by owner homes, rental home in Bartow Georgia, and short term rentals in Bartow Georgia.
Using this site, FRBO.com, land owners bill house, ranch, farmhouse, and condominium lists of marked properties.
Originate and identify vacation rentals in Vienna United States and short term rentals in Vienna.
Join, sign on, and list on Tuesday to lead off and tear into on this outing.
FRBO.Com, For Rent By Owner, encloses area, domain, and city abstracts, generally.
This website, FRBO.com can list, register, levy, and volunteer exotic directories and rustic lists of marked properties exotic lists of marked properties, penthouse online MLS, penthouse listed properties, and resort classified advertisements to cooperate your Blairsville Georgia tramp.
Conceive and distinguish Marietta United States vacation rental and apartment rentals in Marietta.
Ferret out, elicit, and relocate Oglethorpe Georgia apartment rentals and holiday rentals in Oglethorpe Georgia.
Notice and find Bronwood United States rental home and Bronwood United States holiday rentals.
Uncover, look up, and elicit Johnson Georgia condos for rent, Johnson Georgia apartments for rent, and condo rentals Johnson.
Hidden directories and exotic listed properties apartment rentals in Oglethorpe Georgia, Oglethorpe short term rentals, houses for rent, and homes for rent by owner Oglethorpe Georgia.
Our website, FRBO.com does omit unusual principality private, oceanfront, and beachfront ranch, home, cabin, and duplexs.
Devise, identify, and find out vacation homes for rent by owner, Lincoln Georgia rental homes, rental houses Lincoln, and Lincoln apartment rentals.
Identify and design home rentals in Liberty Georgia and homes for rent by owner Liberty.
Design and light upon Walthourville United States real estate rentals and homes for rent Walthourville United States.
The Blairsville mountain classified ads, rustic ads, ski in/out lists of marked properties, and hillside listings for these turf can be mapped.
Come across, come upon, and disclose Telfair houses for rent and rental houses.
Design, find, and conceive rental apartment, rent houses Pendergrass United States, and Pendergrass United States houses for rent.
Elicit, learn, and come across Ideal vacation homes, rent house in Ideal United States, and Ideal United States vacation rental.
Nearly ready exotic hacienda, exclusive house, ski in/out apartment, and hidden chalet are impending in the nearest domain of Blairsville.
Light upon and originate holiday rentals in Cobb Georgia, Cobb Georgia rental houses, condo rentals Cobb Georgia, and bed and breakfast rentals Cobb Georgia.
See private ad directories, exotic online MLS, beach listed properties, and oceanfront classified ads that agents and property owners post on our website, FRBO.com.
Elicit, uncover, and conceive rent houses, Morven United States for rent by owner homes, and vacation homes in Morven United States.
Light upon and move vacation homes in Byromville and vacation homes.
Relocate, observe, and hear the tract and immediate Blairsville Georgia parcel.
Blairsville agents, rental property owners, and real estate brokers list rent house in Blairsville Georgia, rental houses in Blairsville Georgia, Blairsville Georgia rental properties, and homes for rent Blairsville Georgia.
Conceive, uncover, and uncover vacation homes for rent by owner Mineral Bluff United States, rent house in Mineral Bluff United States, and rent houses in Mineral Bluff.
|
|
