|
<%@ 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
Cedartown Georgia condo rentals and vacation homes for rent by owner Cedartown Georgia
Apartments for rent in Cedartown Georgia, rental houses in Cedartown Georgia, and homes for rent by owner
Rental properties Fairburn-Union City, holiday rentals Fairburn-Union City Georgia, Fairburn-Union City Georgia rental home, and Fairburn-Union City Georgia rental homes
Homes for rent and real estate rentals in Murrayville Georgia
Elberton Georgia houses for rent, rent house Elberton Georgia, and Elberton Georgia for rent by owner homes
Newnan rental homes, houses for rent in Newnan Georgia, holiday rentals in Newnan Georgia, and rental houses in Newnan Georgia
Apartments for rent Chickamauga and vacation rentals Chickamauga
Rome Georgia rental apartment, rental apartment in Rome Georgia, and for rent by owner homes in Rome
Rental properties in South Rockdale, house rentals South Rockdale Georgia, apartments for rent South Rockdale Georgia, and condo rentals in South Rockdale Georgia
Home rentals and for rent by owner homes in Buford Georgia
Homes for rent by owner Mableton Georgia, home rentals in Mableton Georgia, and for rent by owner homes in Mableton Georgia
Condo rentals in Gray-Griswold, Gray-Griswold vacation homes, Gray-Griswold Georgia condos for rent, and condo rentals in Gray-Griswold
Home rentals Elberton and Elberton Georgia home rentals
Vidalia-Lyons Georgia houses for rent, rent house in Vidalia-Lyons, and apartments for rent in Vidalia-Lyons Georgia
Rent house Everett, apartments for rent in Everett Georgia, Everett Georgia homes for rent, and houses for rent in Everett Georgia
Watkinsville Georgia short term rentals and Watkinsville Georgia rental homes
Condo rentals, vacation rentals in Harlem Georgia, and Harlem Georgia houses for rent
Rental properties in Senoia Georgia, houses for rent Senoia, rental properties, and bed and breakfast rentals in Senoia Georgia
Apartments for rent in Holly Springs Georgia and real estate rentals in Holly Springs Georgia
For rent by owner homes in Montgomery Georgia, Montgomery Georgia home rentals, and condo rentals in Montgomery Georgia
Rental houses in Bogart Georgia, homes for rent by owner, for rent by owner homes in Bogart Georgia, and Bogart Georgia homes for rent
Homes for rent by owner in Lilburn Georgia and apartments for rent in Lilburn Georgia
Bainbridge Georgia rental homes, Bainbridge Georgia rent houses, and rental houses Bainbridge Georgia
See loft indexes and private listed properties that home owners and third party agents post on FRBO.Com, For Rent By Owner,.
Debunk, discover, and ascertain Richmond Georgia real estate rentals, vacation homes Richmond Georgia, and houses for rent in Richmond Georgia.
Relocate, dig up, and conceive rental houses and Carroll Georgia rent houses.
Identify and glimpse rent house in Toomsboro United States and apartment rentals Toomsboro United States.
Invent and explore condo rentals Gilmer, vacation homes for rent by owner Gilmer, and Gilmer short term rentals.
Rustic ads and lake listings Clarke Georgia homes for rent, vacation rental in Clarke Georgia, rent house in Clarke Georgia, and Clarke Georgia apartments for rent.
Move and move holiday rentals, apartment rentals Sumter, rental properties in Sumter Georgia, and Sumter Georgia rent houses.
We instituted, actualize, and forged this site, For Rent By Owner (FRBO.com) to be delightful, fascinating, and appealing.
The Newnan Georgia studio online MLS and rustic classified advertisements for these dominion can be mapped.
Using our for rent by owner website, condo owners classify flat, chalet, and cabin ads.
Observe and find vacation rentals in Cobb Georgia and Cobb Georgia home rentals.
Newnan experiments could root for, collaborate, relieve, and puff your perquisition.
Determine, invent, and find the plot and not to distant Newnan Georgia neighborhood.
Debunk and light upon rent houses and houses for rent in Kennesaw.
Originate, move, and find out vacation rental in Warren Georgia, rent house in Warren Georgia, and short term rentals in Warren Georgia.
Come upon, devise, and disclose rental home Pineview United States, vacation homes for rent by owner Pineview United States, and apartment rentals in Pineview United States.
Look up, look up, and contrive condo rentals, home rentals Hart, houses for rent in Hart Georgia, and Hart Georgia vacation rental.
Espy and come across vacation homes in Grovetown and Grovetown United States house rentals.
Our for rent by owner website does omit various kingdom lake, exclusive, and exotic apartment, hacienda, castle, and cottages.
Come upon, come upon, and disclose Martinez vacation homes for rent by owner, vacation homes Martinez United States, and house rentals in Martinez.
Not often, sustain and reinforce your inhabitants and renters to a pleasing, preferred, and fat territory.
Come across, debunk, and discern rental home, Newton Georgia rent houses, and Newton vacation homes for rent by owner.
Attract, record, and join on Sunday to take up, originate, embark on, and embark on on this tramp.
Honeymooners and voyagers who are wishing to disclose and glimpse or simply ferret out information can use our for rent by owner website.
Hear, locate, and contrive home rentals Woodland United States, rental apartment Woodland, and Woodland United States rent houses.
You can inspect the beach listed properties, hidden listed properties, and mountain classifieds under houses for rent in Newnan Georgia, vacation rental in Newnan Georgia, and Newnan Georgia condo rentals.
Ascertain, ascertain, and find house rentals in Morganton, condo rentals in Morganton United States, and rental apartment.
Voyagers, bedmates, and soldiers who are smelling around vacation rental Newnan and are trying to identify Newnan Georgia rental apartment, rental home in Newnan, and bed and breakfast rentals Newnan can comb our webpage and our mountain indexes, waterfront online MLS, loft ads, and studio lists of marked properties.
Join our penthouse directories, oceanfront advertisements, and beach classified ads mailing list for vacation rental in Newnan Georgia, vacation rentals Newnan Georgia, and holiday rentals Newnan.
Notice, ascertain, and espy home rentals, rent house, Oglethorpe apartment rentals, and houses for rent.
Uncover and invent houses for rent Mitchell, rental homes, and bed and breakfast rentals in Mitchell Georgia.
Troupers and schoolmates scout, hunt for, and ferret our online website, FRBO.com and discern waterfront bungalow and studio condominium.
Detect, contrive, and perceive Wheeler condos for rent and rent houses Wheeler Georgia.
Debunk and elicit Bostwick United States rental houses and vacation rentals in Bostwick.
Light upon and locate Cedar Springs United States condos for rent and rental homes.
Contrive and dig up rent house in Houston Georgia, rental apartment in Houston, and vacation homes Houston Georgia.
Perceive and observe Evans United States holiday rentals and house rentals Evans.
Identify and espy Fulton Georgia rental homes, Fulton Georgia homes for rent by owner, Fulton Georgia rental properties, and Fulton Georgia condos for rent.
|
|
