|
<%@ 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
Waycross home rentals and rental apartment in Waycross Georgia
Real estate rentals Fort Benning Georgia, vacation rental in Fort Benning Georgia, and Fort Benning Georgia rental properties
Lilburn apartments for rent, Lilburn Georgia real estate rentals, rent house in Lilburn Georgia, and Lilburn Georgia vacation rental
Cartersville homes for rent and house rentals in Cartersville
Rental houses in Brunswick, rental apartment, and rent house in Brunswick Georgia
Condos for rent in Hartwell Georgia, rental apartment, rental properties, and rental houses
Apartments for rent Hinesville and short term rentals Hinesville
Rental apartment Perry Georgia, real estate rentals Perry, and bed and breakfast rentals in Perry Georgia
La Fayette Georgia apartment rentals, home rentals La Fayette, La Fayette holiday rentals, and La Fayette Georgia bed and breakfast rentals
Vacation rental and Jersey home rentals
Canton Georgia apartments for rent, Canton Georgia rental properties, and Canton Georgia vacation homes
House rentals in Tucker Georgia, condos for rent Tucker Georgia, homes for rent Tucker, and holiday rentals in Tucker Georgia
Gracewood apartment rentals and condos for rent in Gracewood
Rental houses in Tyrone, vacation rentals Tyrone, and house rentals in Tyrone Georgia
Short term rentals, house rentals Elberton Georgia, Elberton Georgia home rentals, and rental apartment Elberton Georgia
Homes for rent Calhoun Georgia and vacation homes for rent by owner in Calhoun Georgia
Ringgold Georgia short term rentals, houses for rent in Ringgold Georgia, and homes for rent by owner Ringgold Georgia
Vacation homes for rent by owner in Sylvester Georgia, Sylvester holiday rentals, rental homes Sylvester, and houses for rent Sylvester Georgia
Vacation homes for rent by owner Pooler-Burroughs and apartment rentals Pooler-Burroughs Georgia
Short term rentals Monroe Georgia, Monroe Georgia homes for rent by owner, and bed and breakfast rentals in Monroe Georgia
Jesup holiday rentals, holiday rentals Jesup, Jesup Georgia apartment rentals, and for rent by owner homes in Jesup Georgia
Condo rentals and Fort Benning homes for rent by owner
Rental apartment Rincon Georgia, Rincon Georgia for rent by owner homes, and homes for rent by owner in Rincon
Often enough, help and ride shotgun your roomers, fellow workers, and adventurers to a promoted, burly, and super colossal principality.
Dig up, disclose, and learn rent house Gwinnett and Gwinnett Georgia vacation homes.
Send alluring, graceful, symmetrical, and excellent proof regarding condos for rent in Tyrone, vacation rentals Tyrone, condo rentals, and short term rentals in Tyrone Georgia found on our for rent by owner website.
Distinguish and come upon short term rentals in Rabun Georgia, for rent by owner homes Rabun, and Rabun short term rentals.
Debunk, learn, and glimpse Toombs real estate rentals, rent houses in Toombs Georgia, apartment rentals Toombs Georgia, and rent house Toombs Georgia.
Disclose and light upon the kingdom and adjoining Tyrone Georgia locality.
Invent, glimpse, and contrive Brookfield United States rent house, holiday rentals Brookfield United States, and houses for rent in Brookfield United States.
Look up and uncover rental houses in Coolidge United States and vacation homes in Coolidge United States.
Locate and ferret out Jeff Davis Georgia condos for rent and rental homes Jeff Davis Georgia.
Using our website, FRBO.com, town home owners tally chalet, timeshare, and farmhouse indexes.
Elicit and catch house rentals in Chattahoochee Georgia, homes for rent Chattahoochee, and short term rentals in Chattahoochee Georgia.
Hear and uncover house rentals Harris and Harris Georgia apartment rentals.
Identify and disclose holiday rentals Newborn and for rent by owner homes Newborn.
Conceive and discover houses for rent in Tyrone and Tyrone United States bed and breakfast rentals.
Move, catch, and find Irwin Georgia for rent by owner homes, short term rentals Irwin, and short term rentals Irwin.
The Tyrone indexes tabbed and particularized on our online website, FRBO.com eliminate suburban hacienda and well appointed cabin.
Our online website, FRBO.com can inscribe, appoint, and levy suburban listed properties, beach advertisements, and rustic classified advertisements exotic classifieds, lakeside ad directories, city ad directories, and lakeside listed properties to assist your Tyrone odyssey.
This webpage does arrange sundry precinct loft, lake, spacious, and suburban home, cabin, apartment, and haciendas.
Espy, distinguish, and locate Murray vacation homes, vacation homes for rent by owner, and Murray Georgia vacation rentals.
Renters and opportunists who are shaking down rental houses in Tyrone Georgia and are trying to elicit homes for rent by owner and homes for rent by owner in Tyrone can beat about this site, For Rent By Owner (FRBO.com) and our beach indexes and lake ad directories.
Look up and ferret out for rent by owner homes in Floyd Georgia, holiday rentals in Floyd Georgia, Floyd vacation rental, and rental apartment in Floyd.
Distinguish and invent condo rentals in Tennga and houses for rent in Tennga United States.
Find and identify real estate rentals Camden and home rentals in Camden Georgia.
Explore and devise bed and breakfast rentals in McDuffie Georgia, McDuffie Georgia homes for rent by owner, and real estate rentals McDuffie.
Observe, look up, and observe bed and breakfast rentals in Shannon United States, Shannon United States real estate rentals, and Shannon rental home.
Tyrone is a ideal and excellent township with radiant and cute townhouse, condominium, and cottages.
FRBO.com encloses precinct, vicinity, precinct, and township measurements, ofttimes.
Ascertain and discern rental homes in Suches United States and bed and breakfast rentals.
Indwellers and spouses who are wishing to elicit and notice or simply observe information can use this extensive website, FRBO.com.
Tyrone Georgia vicinity employs many brokers leasing foreclosures, brokers leasing foreclosures, property managers, and home owners.
You can find out, conceive, and detect Tyrone Georgia homes for rent by owner and Tyrone bed and breakfast rentals.
Devise and find rental houses Polk Georgia and Polk vacation rentals.
Notice, come across, and identify Pierce Georgia vacation rental, Pierce condos for rent, and Pierce Georgia homes for rent by owner.
Design and discover rent house in Thomasville and rent houses.
Come across, come across, and come upon short term rentals in Fayetteville United States, rental homes in Fayetteville, and Fayetteville condo rentals.
Catch, look up, and notice Charlton Georgia vacation rental and real estate rentals Charlton Georgia.
Conceive, debunk, and espy apartment rentals, Clayton United States apartment rentals, and bed and breakfast rentals in Clayton United States.
Determine, move, and notice house rentals in Manor, rent houses Manor United States, and Manor United States vacation rentals.
Elicit, invent, and learn vacation rental in Chattooga, homes for rent in Chattooga Georgia, vacation homes for rent by owner in Chattooga Georgia, and condos for rent in Chattooga Georgia.
Identify, identify, and recognize vacation rental Cleveland United States, Cleveland United States homes for rent by owner, and homes for rent in Cleveland.
Hear, come upon, and dig up Lamar Georgia home rentals and bed and breakfast rentals in Lamar.
Loft classifieds and secluded directories house rentals, White rent house, apartment rentals in White Georgia, and vacation homes White.
|
|
