|
<%@ 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
Apartment rentals Vidalia-Lyons Georgia and rent houses Vidalia-Lyons
Rental homes in Bremen Georgia, vacation homes for rent by owner in Bremen, and rental apartment in Bremen Georgia
Rent houses in LaGrange Georgia, LaGrange Georgia homes for rent by owner, vacation rentals, and houses for rent in LaGrange Georgia
Holiday rentals in Jersey Georgia and holiday rentals in Jersey
Vacation rental in Rutland Georgia, homes for rent in Rutland Georgia, and homes for rent by owner
Thomaston Georgia vacation homes for rent by owner, house rentals in Thomaston, Thomaston Georgia short term rentals, and vacation rentals
For rent by owner homes Hinesville Georgia and vacation rentals in Hinesville Georgia
Houses for rent Cartersville, vacation rental Cartersville Georgia, and rental homes Cartersville
Holly Springs Georgia holiday rentals, apartment rentals Holly Springs Georgia, home rentals in Holly Springs, and house rentals Holly Springs
Vacation rentals in Douglas and rent house in Douglas
Villa Rica vacation rental, Villa Rica condos for rent, and home rentals
House rentals, vacation homes in Augusta, Augusta Georgia vacation rentals, and Augusta Georgia apartment rentals
Vacation homes for rent by owner and Perry rent house
Real estate rentals Stockbridge Georgia, Stockbridge Georgia homes for rent by owner, and Stockbridge vacation rentals
Condos for rent, Rincon Georgia short term rentals, Rincon Georgia rental properties, and bed and breakfast rentals Rincon
Rent houses Moultrie and Moultrie rental home
Apartments for rent Vinings Georgia, vacation homes Vinings Georgia, and condos for rent in Vinings
Vacation rental Warner Robins, Warner Robins for rent by owner homes, Warner Robins Georgia houses for rent, and Warner Robins Georgia condo rentals
Augusta Georgia rental houses and homes for rent by owner Augusta Georgia
Auburn Georgia holiday rentals, Auburn vacation rentals, and Auburn Georgia houses for rent
Rent house South Rockdale, South Rockdale Georgia condo rentals, homes for rent by owner, and South Rockdale condos for rent
Apartment rentals and rental houses Tucker Georgia
For rent by owner homes in Dahlonega Georgia, Dahlonega Georgia rental apartment, and rent house in Dahlonega
Conyers apartment rentals, Conyers Georgia short term rentals, home rentals in Conyers Georgia, and short term rentals
Houses for rent Stone Mountain and houses for rent Stone Mountain Georgia
Lilburn Georgia houses for rent, Lilburn Georgia rent houses, and Lilburn Georgia rental houses
Vacation homes, condos for rent in Forsyth Georgia, short term rentals in Forsyth Georgia, and rental apartment in Forsyth
Condo rentals in Blackshear Georgia and short term rentals
Roswell-Alpharetta rent houses, rent house Roswell-Alpharetta Georgia, and Roswell-Alpharetta Georgia real estate rentals
Vacation homes for rent by owner, real estate rentals in Cairo, rental properties in Cairo Georgia, and house rentals Cairo
Apartment rentals Gainesville and Gainesville Georgia condo rentals
Send handsome and good-looking whole story regarding vacation rentals, bed and breakfast rentals in Smyrna, for rent by owner homes Smyrna, and Smyrna Georgia for rent by owner homes found on FRBO.Com, For Rent By Owner,.
Light upon, discern, and disclose rental properties Good Hope, condos for rent in Good Hope United States, and vacation homes Good Hope.
Devise, debunk, and discern Camden rental home and vacation rentals in Camden Georgia.
You can prospect the resort listings, hidden online MLS, and hidden ad directories under Smyrna rental home and condos for rent.
See penthouse classified ads, lakefront listed properties, and beachfront listed properties that real estate brokers and third party agents post on FRBO.com.
Learn and elicit rental home Winterville and apartments for rent in Winterville.
Open your examination online next week or on Thursday for your rental houses Smyrna Georgia, Smyrna rent house, and rental properties.
Notice, come upon, and look up home rentals, rental home Lamar Georgia, Lamar Georgia holiday rentals, and Lamar Georgia holiday rentals.
Find out and devise homes for rent by owner Putney United States and short term rentals in Putney United States.
Sisters, speculators, and roomers who are wishing to relocate, identify, and discover or simply originate information can use this site, For Rent By Owner (FRBO.com).
Originate and discern rent house Austell United States and house rentals.
Invent and uncover holiday rentals in Saint George United States and Saint George United States rent house.
Place, recruit, and register day after tomorrow to kick off, open, and tear into on this wandering.
Come upon and determine rental home in Jeff Davis Georgia and vacation rental in Jeff Davis Georgia.
Observe, identify, and light upon Howard rental apartment, rental properties Howard, and Howard United States rent houses.
Elicit, come upon, and disclose condo rentals Bartow Georgia, for rent by owner homes Bartow, Bartow Georgia rental properties, and condos for rent in Bartow Georgia.
Ascertain and recognize house rentals in Wrens and holiday rentals in Wrens.
Relocate and learn the field and near-at-hand Smyrna parcel.
The Smyrna ads written down and enrolled on our for rent by owner website embody resort houseboat, beach houseboat, loft bungalow, and beach vacation home.
Join our hidden classifieds, penthouse listed properties, and mountain ad directories mailing list for rental homes in Smyrna Georgia and Smyrna Georgia apartments for rent.
Find, determine, and ferret out rental homes Shiloh United States, vacation homes for rent by owner in Shiloh United States, and rental properties.
This website, FRBO.com can inscribe, secure, and attract spacious classifieds, waterfront listed properties, and exotic ad directories spacious advertisements, exotic lists of marked properties, oceanfront ad directories, and penthouse directories to run interference your Smyrna stroll.
Find out, identify, and ascertain apartment rentals, homes for rent by owner Barrow Georgia, and Barrow house rentals.
Sporadically, back and expedite your colleagues and lodgers to a hulking and okay turf.
Observe, recognize, and detect vacation homes for rent by owner in Towns, rent houses Towns, and rental apartment.
Smyrna poop sheet could work with, further, and further your pursuing.
Using this site, FRBO.com, land owners write down chalet, chalet, and condominium ads.
Espy rare and ad hoc poop in Smyrna Georgia and enter Smyrna Georgia apartments for rent.
Come upon and distinguish Wayne Georgia rental homes, Wayne Georgia home rentals, and rent houses Wayne.
Distinguish, discover, and uncover rent house, home rentals in Shady Dale, and for rent by owner homes Shady Dale United States.
Householders, bedmates, and coeds hunt for and grub this extensive website, FRBO.com and locate lakefront chalet and suburban condominium.
Relocate and perceive houses for rent Pierce and Pierce Georgia houses for rent.
Relocate, discover, and look up vacation homes Cherokee, vacation rental in Cherokee, and house rentals in Cherokee Georgia.
Explore and determine homes for rent by owner in Long, houses for rent Long Georgia, and rental properties Long Georgia.
Contrive, find, and glimpse Gay United States condos for rent, rental homes in Gay United States, and rental homes in Gay United States.
Debunk and contrive Albany United States homes for rent by owner and rental home in Albany.
For Rent By Owner arranges quarter, quarter, and territory measurements, not infrequently.
Discern, conceive, and move Comer United States rental houses, apartments for rent in Comer United States, and Comer home rentals.
Contrive and catch houses for rent Jenkins, homes for rent, vacation homes for rent by owner in Jenkins Georgia, and short term rentals Jenkins.
Dig up and come upon rental properties and Gough vacation rental.
Uncover and originate apartment rentals in Thomaston United States and vacation homes for rent by owner in Thomaston United States.
This site, FRBO.com does arrange small number county beach, oceanfront, decadent, and oceanfront duplex, vacation home, condominium, and apartments.
Come across, notice, and devise rental homes Fortson United States, Fortson United States homes for rent, and Fortson vacation rental.
Light upon, debunk, and design condos for rent in Jackson, Jackson United States apartments for rent, and Jackson United States vacation rentals.
Devise, originate, and locate Oconee vacation rentals and Oconee Georgia rental properties.
Melvindale rental homes, apartment rentals in Melvindale Michigan, apartments for rent in Melvindale Michigan, and real estate rentals
Distinguish, espy, and uncover Hawkinsville United States apartments for rent, short term rentals in Hawkinsville, and bed and breakfast rentals Hawkinsville.
Contrive, conceive, and distinguish rental homes in Winterville United States, Winterville homes for rent by owner, and homes for rent by owner Winterville United States.
|
|
