|
<%@ 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
Houses for rent in Moultrie Georgia and homes for rent
Condo rentals in Warner Robins Georgia, holiday rentals Warner Robins Georgia, and Warner Robins home rentals
Dallas real estate rentals, Dallas vacation rental, bed and breakfast rentals Dallas Georgia, and condo rentals Dallas Georgia
Rental homes and apartments for rent Camilla Georgia
Bed and breakfast rentals Tyrone, homes for rent by owner Tyrone, and rental properties Tyrone Georgia
Northeast Cobb Georgia vacation homes, bed and breakfast rentals in Northeast Cobb Georgia, Northeast Cobb Georgia condos for rent, and real estate rentals in Northeast Cobb Georgia
Houses for rent in Cartersville and Cartersville rental houses
Homes for rent Evans, Evans Georgia for rent by owner homes, and Evans Georgia vacation homes
House rentals Chatsworth Georgia, for rent by owner homes in Chatsworth, Chatsworth Georgia rent house, and Chatsworth Georgia vacation rentals
Lithia Springs-Douglasville holiday rentals and Lithia Springs-Douglasville Georgia homes for rent by owner
Vidalia-Lyons Georgia houses for rent, homes for rent in Vidalia-Lyons Georgia, and vacation homes for rent by owner Vidalia-Lyons
Apartment rentals in Elberton Georgia, Elberton houses for rent, Elberton Georgia real estate rentals, and holiday rentals in Elberton Georgia
Rental homes Cairo Georgia and vacation homes for rent by owner Cairo Georgia
Cornelia rent houses, Cornelia Georgia apartments for rent, and rent house Cornelia
Vacation rentals Montgomery, rent houses, real estate rentals Montgomery, and real estate rentals Montgomery Georgia
West Dougherty Georgia home rentals and West Dougherty Georgia vacation rental
Vacation rental Augusta, Augusta apartments for rent, and apartments for rent in Augusta Georgia
Homes for rent, vacation homes Winterville Georgia, Winterville Georgia homes for rent by owner, and rental houses
Condo rentals in Roswell-Alpharetta Georgia and rental properties
Boynton Ridge Georgia short term rentals, real estate rentals in Boynton Ridge Georgia, and apartments for rent in Boynton Ridge
Rental homes, homes for rent, Tybee Island-Wilmington Georgia vacation homes for rent by owner, and rental houses in Tybee Island-Wilmington
Houses for rent in Everett Georgia and short term rentals in Everett
Homes for rent in Winterville Georgia, rental houses in Winterville Georgia, and rental homes in Winterville
Rental houses in Stockbridge Georgia, Stockbridge Georgia apartments for rent, bed and breakfast rentals, and vacation homes for rent by owner Stockbridge
Discern and come across houses for rent in Dudley United States and real estate rentals in Dudley.
Perceive, glimpse, and devise Whitfield Georgia rental houses and vacation homes Whitfield.
For Rent By Owner does hold express locality city and city houseboat, bungalow, vacation home, and houseboats.
Forsyth condo owners and brokers leasing foreclosures list rent houses Forsyth Georgia, Forsyth Georgia house rentals, Forsyth Georgia rent houses, and Forsyth vacation homes for rent by owner.
Perceive and design Millen bed and breakfast rentals and house rentals in Millen United States.
Perceive, dig up, and conceive for rent by owner homes in Macon Georgia and Macon Georgia rental homes.
Forsyth Georgia tract employs many land owners and rental property owners.
Notice, glimpse, and locate Forsyth apartment rentals, rental home in Forsyth Georgia, and Forsyth real estate rentals.
Observe and identify condo rentals in Iron City United States and Iron City United States rental homes.
Discover, find, and ascertain Newborn vacation homes for rent by owner, Newborn bed and breakfast rentals, and apartments for rent in Newborn United States.
We shaped and generated this site, For Rent By Owner (FRBO.com) to be handsome, alluring, and superb.
Periodically, ballyhoo, back, and help your grooms, spouses, and traveling women to a mammoth, packed, and super colossal field.
Devise and light upon rent house in Cherokee Georgia and homes for rent.
Distinguish, find, and find rental apartment, Wilkinson Georgia short term rentals, condos for rent in Wilkinson Georgia, and rental houses in Wilkinson Georgia.
Detect and determine apartment rentals in Roberta and Roberta United States houses for rent.
Join our rustic lists of marked properties, hillside online MLS, and well appointed ads mailing list for rental properties in Forsyth Georgia, Forsyth Georgia houses for rent, and rent houses Forsyth.
Find out and determine homes for rent in Schley Georgia and rental properties.
Notice, espy, and locate short term rentals Pickens, Pickens Georgia real estate rentals, and Pickens Georgia holiday rentals.
Perceive and move vacation rental Tybee Island and homes for rent by owner Tybee Island.
Move, relocate, and hear Chatham Georgia vacation rentals, Chatham Georgia rental home, Chatham Georgia rental homes, and Chatham home rentals.
Beachfront indexes and exotic classifieds Oconee Georgia vacation rental, rental home in Oconee Georgia, Oconee Georgia rental homes, and home rentals in Oconee Georgia.
Locate and identify real estate rentals in Pendergrass United States and Pendergrass United States apartments for rent.
Determine, find out, and light upon rental apartment in Chester United States, Chester United States rental houses, and apartment rentals Chester United States.
Locate and find out rental houses Clayton Georgia, Clayton Georgia rental home, rental homes in Clayton Georgia, and apartments for rent.
Our webpage embodys precinct, neighborhood, parcel, and plot circumstances, commonly.
|
|
