|
<%@ 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
Homes for rent by owner in Eastman and houses for rent
Big Creek Georgia bed and breakfast rentals, Big Creek Georgia real estate rentals, and Big Creek Georgia vacation rentals
Houses for rent in Everett Georgia, home rentals in Everett Georgia, apartment rentals Everett, and Everett vacation rentals
Milledgeville-Midway-Hardwick Georgia short term rentals and houses for rent in Milledgeville-Midway-Hardwick Georgia
Short term rentals in Dallas, Dallas homes for rent, and rental apartment in Dallas
Westside Georgia bed and breakfast rentals, Westside condos for rent, house rentals in Westside Georgia, and homes for rent by owner in Westside Georgia
Forsyth Georgia house rentals and house rentals in Forsyth Georgia
Homes for rent by owner, rental houses Richmond Hill, and condos for rent in Richmond Hill
Houses for rent Athens Georgia, Athens vacation homes, Athens Georgia real estate rentals, and Athens Georgia condo rentals
Rental apartment LaGrange Georgia and houses for rent
Apartment rentals Everett Georgia, homes for rent Everett, and Everett rent house
Locate, observe, and devise apartment rentals Enigma, homes for rent by owner Enigma, and Enigma United States vacation rental.
Discover, disclose, and detect Brantley rental properties and homes for rent by owner Brantley.
Conceive and debunk Ellabell rental properties and vacation rental in Ellabell United States.
Uncover and uncover the vicinity and adjacent Flowery Branch quarter.
You can shake down the beach advertisements and lakefront ad directories under Flowery Branch Georgia condo rentals and holiday rentals in Flowery Branch.
This webpage does have original locality oceanfront, decadent, and secluded castle, hacienda, cabin, and farmhouses.
Jump into your research online in the next few days, on Sunday, this week, or on Monday for your houses for rent Flowery Branch and Flowery Branch houses for rent.
Catch, come across, and elicit vacation rentals Woodbine United States, Woodbine rental home, and rent houses in Woodbine United States.
Devise, glimpse, and locate rental properties Morgan, vacation rentals in Morgan Georgia, rent house Morgan Georgia, and apartments for rent in Morgan Georgia.
Contrive and ascertain Early Georgia rent house and home rentals.
Our for rent by owner site, FRBO.com omits county, locality, and dominion reports, every once in a while.
We started and authored our webpage to be beauteous, pulchritudinous, pretty, and handsome.
Detect and come across vacation rentals Greene Georgia and Greene Georgia bed and breakfast rentals.
Hear, glimpse, and recognize Duluth United States holiday rentals, homes for rent Duluth, and holiday rentals in Duluth United States.
Find out and debunk rental home in Franklin Georgia, vacation homes for rent by owner in Franklin, and homes for rent by owner Franklin Georgia.
You can dig up and find out short term rentals in Flowery Branch Georgia, rental homes in Flowery Branch Georgia, and bed and breakfast rentals Flowery Branch Georgia.
Flowery Branch property brokers, property owners, and condo owners list homes for rent by owner in Flowery Branch Georgia, home rentals in Flowery Branch Georgia, and Flowery Branch Georgia apartment rentals.
Periodically, benefit and run interference your dwellers and venturers to a hip, handsome, jumbo, and now patch.
|
|
