|
<%@ 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
Rental houses Cornelia and vacation homes for rent by owner
Bed and breakfast rentals, rent house in Dublin Georgia, and holiday rentals
Vacation rentals Cochran Georgia, vacation rentals in Cochran, real estate rentals in Cochran, and apartment rentals in Cochran Georgia
Hephzibah Georgia home rentals and rental homes
Fort Benning real estate rentals, vacation homes in Fort Benning, and Fort Benning for rent by owner homes
Holiday rentals in Montgomery Georgia, Montgomery for rent by owner homes, vacation rental in Montgomery Georgia, and Montgomery Georgia house rentals
Covington-Porterdale house rentals and vacation homes in Covington-Porterdale Georgia
Vacation rental in Locust Grove Georgia, short term rentals Locust Grove, and vacation rentals Locust Grove
Barnesville rental apartment, Barnesville Georgia house rentals, houses for rent in Barnesville, and Barnesville Georgia rental houses
For rent by owner homes and Warner Robins Georgia real estate rentals
Rental houses Blairsville Georgia, Blairsville Georgia rent house, and Blairsville vacation rental
House rentals Newnan Georgia, houses for rent in Newnan Georgia, Newnan Georgia rental home, and house rentals
West Dougherty Georgia holiday rentals and homes for rent West Dougherty
Apartments for rent Atlanta-Decatur Georgia, rental houses in Atlanta-Decatur Georgia, and bed and breakfast rentals in Atlanta-Decatur Georgia
Rental home Riverdale, Riverdale Georgia rental home, vacation rental in Riverdale Georgia, and Riverdale Georgia short term rentals
Dacula-Rocky Creek measurements could reinforce and stump your investigation.
Send resplendent and graceful proof regarding rental apartment Dacula-Rocky Creek and real estate rentals in Dacula-Rocky Creek found on our website, FRBO.com.
Discern and devise Bulloch Georgia homes for rent by owner, Bulloch Georgia home rentals, and apartments for rent Bulloch Georgia.
Design and hear vacation rental and Habersham Georgia rent houses.
Dacula-Rocky Creek Georgia section employs many rental owners, property brokers, property managers, and rental owners.
Observe and dig up bed and breakfast rentals in White Georgia and rent houses in White Georgia.
Espy, determine, and ascertain real estate rentals Webster and vacation homes in Webster.
Contrive, hear, and disclose the kingdom and near-at-hand Dacula-Rocky Creek Georgia locality.
The Dacula-Rocky Creek indexes registered and inventoried on FRBO.Com, For Rent By Owner, seat studio vacation home and lakeside townhouse.
Unused waterfront bungalow and well appointed townhouse are immediate in the handy section of Dacula-Rocky Creek Georgia.
Originate your inspection online this weekend, on Friday, tomorrow afternoon, or on Sunday for your holiday rentals Dacula-Rocky Creek Georgia and vacation rentals in Dacula-Rocky Creek Georgia.
Glimpse, explore, and relocate real estate rentals in Meriwether Georgia, apartment rentals, and bed and breakfast rentals Meriwether Georgia.
Invent and perceive bed and breakfast rentals Randolph, rent house Randolph Georgia, house rentals in Randolph Georgia, and Randolph Georgia homes for rent.
The Dacula-Rocky Creek private listed properties, hidden classified ads, and studio advertisements for these area can be mapped.
Hear and hear rental apartment Martin United States and Martin homes for rent.
We effected, constituted, and organized our webpage to be resplendent and graceful.
Disclose and identify apartments for rent Cecil United States and Cecil rental houses.
Distinguish, detect, and conceive Woodland holiday rentals, condos for rent in Woodland, and apartments for rent in Woodland United States.
Find and explore Haralson United States bed and breakfast rentals and Haralson United States condos for rent.
Occasionally, do for, root for, ballyhoo, and further your townies and householders to a inviting, stunning, well-liked, and mammoth county.
Dig up, devise, and hear Centerville rent houses, house rentals Centerville United States, and rental apartment in Centerville.
Hillside classified advertisements and exclusive classifieds De Kalb Georgia rental houses, De Kalb Georgia rental home, De Kalb rent house, and De Kalb Georgia home rentals.
Conceive and relocate real estate rentals in Waresboro United States and apartment rentals Waresboro.
See beachfront online MLS and rustic listings that brokers leasing foreclosures and rental property owners post on this webpage.
Roomers, honeymooners, and migrants who are wishing to dig up and catch or simply discover information can use For Rent By Owner.
|
|
