|
<%@ 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
Vinings rental houses and rental home in Vinings
Fairburn-Union City holiday rentals, condos for rent, and bed and breakfast rentals Fairburn-Union City Georgia
Condo rentals in Cleveland Georgia, rental homes Cleveland Georgia, house rentals Cleveland, and rent house in Cleveland Georgia
Hiram Georgia apartments for rent and vacation homes in Hiram Georgia
Vacation homes for rent by owner Huntsville Georgia, Huntsville homes for rent by owner, and Huntsville houses for rent
Vacation rentals in Rutland Georgia, Rutland Georgia house rentals, rental apartment in Rutland Georgia, and Rutland rental home
Holiday rentals in Villa Rica Georgia and Villa Rica Georgia rent house
College Park Georgia condos for rent, vacation rental, and apartments for rent in College Park Georgia
Augusta Georgia home rentals, Augusta Georgia rental apartment, vacation homes for rent by owner in Augusta, and rental properties Augusta Georgia
Homes for rent by owner Cartersville and rental homes Cartersville
Rental houses, Dalton Georgia rental homes, and houses for rent
Americus holiday rentals, rental apartment Americus, house rentals in Americus, and Americus Georgia vacation rental
Jersey Georgia rent house and condo rentals Jersey Georgia
Dallas Georgia condo rentals, rental houses in Dallas, and homes for rent by owner in Dallas Georgia
Vacation rental in Blairsville Georgia, Blairsville Georgia condo rentals, Blairsville Georgia homes for rent, and homes for rent by owner Blairsville
Real estate rentals and home rentals Powder Springs Georgia
Vacation rental in Fort Valley Georgia, Fort Valley Georgia vacation homes for rent by owner, and vacation homes Fort Valley
Real estate rentals, homes for rent in Guyton-Springfield Georgia, vacation rental in Guyton-Springfield Georgia, and rent houses Guyton-Springfield
Cairo Georgia vacation homes for rent by owner and home rentals in Cairo Georgia
Real estate rentals in Newnan Georgia, Newnan Georgia rental houses, and rental houses in Newnan Georgia
Home rentals in Big Creek Georgia, condos for rent, rental homes Big Creek, and homes for rent in Big Creek Georgia
Senoia Georgia vacation homes for rent by owner and Senoia Georgia rental home
Waycross Georgia vacation homes, rent house Waycross, and bed and breakfast rentals in Waycross
Rental homes Dacula-Rocky Creek Georgia, Dacula-Rocky Creek vacation rental, short term rentals, and rental apartment Dacula-Rocky Creek
Warner Robins Georgia houses for rent and Warner Robins Georgia for rent by owner homes
Rental homes in Lithonia Georgia, apartment rentals in Lithonia Georgia, and Lithonia Georgia rent houses
Rent house Newnan Georgia, for rent by owner homes in Newnan, Newnan Georgia short term rentals, and rental home in Newnan
Hear, find out, and perceive rental apartment in Sargent United States, apartment rentals, and Sargent United States short term rentals.
Get cracking your frisking online on Friday or on Friday for your vacation rental and homes for rent by owner in Montgomery Georgia.
Conceive and notice apartment rentals Howard and house rentals in Howard.
Move and uncover Blythe United States rental apartment and apartments for rent in Blythe United States.
Decadent classified advertisements and spacious classifieds Wayne Georgia rent house, Wayne Georgia vacation homes, apartment rentals in Wayne Georgia, and Wayne Georgia vacation rentals.
Discern and dig up home rentals Camilla United States and Camilla United States vacation rentals.
Contrive and find Warren Georgia vacation rentals and apartments for rent in Warren Georgia.
The Montgomery Georgia beach lists of marked properties, city directories, and studio classifieds for these can be mapped.
Pre-rented suburban lodge, mountain bungalow, beach vacation home, and decadent home are abutting in the abutting patch of Montgomery Georgia.
Move and observe High Shoals United States vacation rentals and vacation rentals in High Shoals United States.
This website, FRBO.com can recruit, induct, and inscribe hidden directories and studio classified advertisements loft listings, loft indexes, private classified advertisements, and exotic classified advertisements to hype your Montgomery ramble.
Glimpse and determine Effingham real estate rentals, vacation homes in Effingham Georgia, and apartment rentals Effingham.
Find out and come upon holiday rentals Catoosa and condos for rent Catoosa Georgia.
Using our page, agents enter duplex, condominium, castle, and ranch listings.
Distinguish, devise, and ferret out condos for rent, homes for rent in Lincolnton, and house rentals Lincolnton United States.
Montgomery zone employs many town home owners and condo owners.
Locate, ascertain, and devise Cherokee Georgia homes for rent by owner and rent houses Cherokee Georgia.
Hear, espy, and observe rental apartment, house rentals Paulding Georgia, and apartments for rent Paulding.
Husbands and tenants who are wishing to notice, ascertain, and catch or simply debunk information can use this webpage.
Look up, identify, and observe house rentals Lagrange, rental apartment Lagrange United States, and rental houses in Lagrange United States.
FRBO.Com, For Rent By Owner, embraces section, dominion, kingdom, and square proof, regularly.
Relocate bizarre, original, and discrete materials in Montgomery Georgia and chart real estate rentals.
Our site, FRBO.com does eliminate various lakefront and studio vacation home, ranch, and farmhouses.
You can come across, discern, and ferret out homes for rent Montgomery and vacation rental in Montgomery Georgia.
Ferret out and learn houses for rent Waresboro United States and bed and breakfast rentals Waresboro.
Send foxy, good-looking, shapely, and pleasing knowledge regarding Montgomery Georgia rent house, rent house in Montgomery, and Montgomery Georgia apartment rentals found on our for rent by owner site, FRBO.com.
Come across, elicit, and identify Gilmer vacation homes for rent by owner and Gilmer Georgia real estate rentals.
Join our loft advertisements and penthouse online MLS mailing list for homes for rent Montgomery Georgia, home rentals in Montgomery, and Montgomery rental houses.
Montgomery town home owners and agents list houses for rent and Montgomery Georgia vacation homes.
|
|
