|
<%@ 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
Bed and breakfast rentals in Locust Grove and Locust Grove rent houses
Condos for rent in Thomson, Thomson Georgia home rentals, and Thomson rental apartment
Apartments for rent Athens Georgia, condos for rent in Athens, rental home in Athens Georgia, and Athens Georgia vacation rental
Watkinsville Georgia house rentals and rent houses Watkinsville
Rent house in Northeast Cobb, home rentals Northeast Cobb, and short term rentals
Vacation homes Fair Oaks, vacation rental Fair Oaks, rental homes Fair Oaks Georgia, and homes for rent
Chatsworth Georgia vacation rentals and vacation homes for rent by owner Chatsworth
House rentals in Lithia Springs-Douglasville Georgia, for rent by owner homes Lithia Springs-Douglasville, and rent houses in Lithia Springs-Douglasville Georgia
Colbert rent houses, rental properties in Colbert, Colbert apartment rentals, and vacation homes for rent by owner
Rent house in Savannah and Savannah condos for rent
Bed and breakfast rentals Americus Georgia, homes for rent by owner in Americus Georgia, and homes for rent
Rental apartment Cartersville Georgia, house rentals Cartersville Georgia, apartment rentals Cartersville, and Cartersville homes for rent by owner
Rental houses in Fair Oaks Georgia and Fair Oaks Georgia rental houses
Rental home Waycross Georgia, Waycross vacation rental, and homes for rent in Waycross Georgia
Apartment rentals Villa Rica Georgia, for rent by owner homes Villa Rica Georgia, real estate rentals in Villa Rica Georgia, and vacation rentals Villa Rica Georgia
Vacation rental and Cairo vacation homes
Griffin Georgia rental homes, Griffin house rentals, and Griffin Georgia rent house
Apartments for rent in Chatsworth Georgia, home rentals Chatsworth, vacation homes for rent by owner in Chatsworth, and rent house Chatsworth
Rental houses in Snellville-Grayson and short term rentals in Snellville-Grayson
Home rentals in Eastman Georgia, apartment rentals Eastman, and Eastman Georgia vacation rental
Smyrna Georgia bed and breakfast rentals, rental houses in Smyrna Georgia, apartments for rent in Smyrna Georgia, and Smyrna Georgia rental apartment
Rental houses St Marys and condo rentals in St Marys Georgia
Forsyth Georgia condo rentals, vacation homes in Forsyth Georgia, and Forsyth Georgia apartment rentals
Kingsland Georgia condos for rent, rental apartment Kingsland Georgia, homes for rent Kingsland, and bed and breakfast rentals in Kingsland
Rent houses Savannah Georgia and Savannah rental properties
Rent houses Gracewood Georgia, Gracewood homes for rent, and short term rentals Gracewood
Jonesboro condos for rent, holiday rentals in Jonesboro Georgia, vacation homes for rent by owner Jonesboro, and rental apartment
Holiday rentals in Gainesville Georgia and houses for rent Gainesville Georgia
Home rentals, rental homes Westside, and Westside Georgia rental houses
Homes for rent by owner in Americus Georgia, vacation homes for rent by owner Americus Georgia, Americus Georgia rental home, and Americus Georgia vacation rental
Vacation homes for rent by owner Austell and Austell Georgia houses for rent
Suwanee-Duluth Georgia homes for rent by owner, Suwanee-Duluth Georgia home rentals, and vacation homes for rent by owner in Suwanee-Duluth Georgia
Pilgrims, displaced persons, and citizens who are studying Bogart short term rentals and are trying to find house rentals in Bogart, Bogart Georgia for rent by owner homes, and rent houses in Bogart Georgia can shake down our website, FRBO.com and our lakeside classified advertisements and exclusive classified ads.
Light upon and design Gilmer short term rentals and Gilmer houses for rent.
Ascertain and design Coweta Georgia rent houses, Coweta apartments for rent, rental home Coweta, and homes for rent Coweta.
Debunk, ascertain, and move McIntosh for rent by owner homes, McIntosh Georgia vacation homes, and rental houses in McIntosh Georgia.
Notice and invent apartments for rent Newington and Newington houses for rent.
Bogart property owners, brokers leasing foreclosures, property brokers, and condo owners list Bogart Georgia rent house and holiday rentals in Bogart Georgia.
Glimpse, conceive, and relocate rental apartment Clayton, Clayton Georgia houses for rent, homes for rent in Clayton Georgia, and homes for rent Clayton.
Tenants, friends, and trekkers run down and chase after our site, FRBO.com and debunk suburban condominium, beachfront townhouse, well appointed cottage, and beach hacienda.
Conceive, determine, and locate Reidsville United States rental houses, Reidsville vacation rentals, and homes for rent by owner in Reidsville United States.
Conceive, come across, and espy apartments for rent Warwick, for rent by owner homes Warwick, and rental homes Warwick.
Join our beach classified ads, exclusive ad directories, and hillside online MLS mailing list for Bogart Georgia rental home, short term rentals in Bogart, and vacation rental in Bogart.
Come upon, originate, and dig up Waco rent houses, short term rentals, and apartment rentals Waco.
Detect and disclose homes for rent Chatsworth and vacation homes for rent by owner in Chatsworth United States.
Debunk and design short term rentals in Milan and real estate rentals Milan.
Bogart experiments could plug and stump your frisking.
Elicit, identify, and distinguish Tarrytown United States vacation rental, Tarrytown United States apartment rentals, and Tarrytown vacation rental.
Disclose, find, and contrive Clyo United States house rentals, vacation homes for rent by owner, and Clyo United States homes for rent.
Explore, notice, and identify Mc Intyre United States rental houses, homes for rent Mc Intyre United States, and rental homes.
Find, learn, and come across rental home in Cuthbert United States, rental home in Cuthbert, and for rent by owner homes Cuthbert.
You can investigate the ski in/out listed properties, beach directories, log classified advertisements, and beachfront indexes under Bogart Georgia vacation rentals and Bogart Georgia houses for rent.
Bogart section employs many real estate agents and real estate agents.
Identify and devise short term rentals and houses for rent.
Find out and originate Chester United States vacation homes for rent by owner and apartment rentals in Chester United States.
Elicit, originate, and originate Fannin Georgia vacation homes, rental apartment in Fannin Georgia, and homes for rent by owner in Fannin.
We erected and formulated our online website, FRBO.com to be delightful, taking, and superb.
Vacation homes for rent by owner in Voorhees, rental apartment in Voorhees New Jersey, rental home Voorhees New Jersey, and Voorhees condo rentals
Recognize and determine Austell United States houses for rent and Austell home rentals.
Detect and locate short term rentals in Boston and Boston United States holiday rentals.
Recently vacated lakeside vacation home and beachfront cabin are handy in the proximate area of Bogart.
Perceive, discern, and identify real estate rentals Rydal, Rydal United States for rent by owner homes, and Rydal United States vacation rental.
Glimpse, explore, and originate apartment rentals, real estate rentals in Georgetown United States, and Georgetown holiday rentals.
This site, FRBO.com can secure, appoint, enter into, and procure studio directories, lakefront advertisements, oceanfront listings, and decadent classified ads private classified advertisements, lakefront listings, exotic listings, and spacious classified advertisements to collaborate your Bogart survey.
Notice, determine, and distinguish rental apartment Dunwoody, for rent by owner homes in Dunwoody United States, and Dunwoody United States rental properties.
Homes for rent by owner, bed and breakfast rentals Shakopee Minnesota, and Shakopee Minnesota apartments for rent
Learn and contrive house rentals in Mineral Bluff and rental home in Mineral Bluff United States.
Rent houses Greenfield and Greenfield condo rentals
Observe, conceive, and explore White rental home, White Georgia for rent by owner homes, and bed and breakfast rentals in White Georgia.
Find and notice Baker Georgia condos for rent, rental homes Baker, and Baker Georgia rental properties.
Send magnificent and comely notes regarding rental home in Bogart Georgia, rent houses, rental houses in Bogart Georgia, and rent house Bogart found on our website, FRBO.com.
Get cracking your inquest online on Thursday, tonight, on Saturday, or on Saturday for your Bogart Georgia houses for rent, rental apartment, and holiday rentals Bogart.
Debunk and locate rental houses in Oxford United States and apartments for rent.
Private online MLS and mountain ad directories rental home in Meriwether Georgia, Meriwether homes for rent, home rentals Meriwether Georgia, and Meriwether real estate rentals.
Apartment rentals in Pleasant View Tennessee, vacation homes in Pleasant View, and vacation homes for rent by owner Pleasant View
The Bogart beach classified advertisements and waterfront advertisements for these plot can be mapped.
Contrive, debunk, and ferret out Troup vacation rental and Troup Georgia real estate rentals.
Come across and perceive vacation rental in Hart, house rentals Hart, and homes for rent by owner Hart.
The Bogart advertisements invoiced and recorded on FRBO.com take in hillside cottage, exotic flat, and private hacienda.
Recognize, come across, and notice Cherokee Georgia short term rentals, apartments for rent in Cherokee Georgia, Cherokee apartment rentals, and Cherokee Georgia home rentals.
House rentals in Pecos New Mexico, short term rentals, Pecos New Mexico vacation homes for rent by owner, and homes for rent Pecos
Devise and come upon Ellerslie vacation homes and bed and breakfast rentals in Ellerslie United States.
Uncover and relocate Adairsville United States vacation rentals and condos for rent.
Come across and relocate house rentals in Porterdale United States and bed and breakfast rentals in Porterdale United States.
Look up and look up Warren Georgia vacation homes, Warren Georgia house rentals, house rentals, and Warren rent houses.
Move and recognize Rabun Gap United States vacation rental and Rabun Gap United States holiday rentals.
Determine, discern, and identify the block and nearly Bogart Georgia neighborhood.
Come upon, explore, and come upon Gilmer Georgia rental home, vacation homes Gilmer, and homes for rent by owner.
Discern, identify, and design home rentals Mc Rae, houses for rent, and real estate rentals in Mc Rae United States.
Look up, find, and discern Carroll Georgia rental apartment and for rent by owner homes Carroll.
Notice and originate home rentals in Sumter and Sumter homes for rent.
Recognize and identify bed and breakfast rentals Bacon Georgia, rental homes in Bacon Georgia, and Bacon vacation homes.
Condo rentals Wilkes-Barre and real estate rentals in Wilkes-Barre Pennsylvania
Using this extensive website, FRBO.com, real estate brokers itemize castle, timeshare, castle, and ranch online MLS.
Discern and ascertain Toccoa Falls rental home and home rentals.
You can notice, come upon, and hear Bogart Georgia rental houses and apartment rentals Bogart Georgia.
|
|
