|
<%@ 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
Real estate rentals in Smyrna Georgia and Smyrna apartment rentals
Rent house in Atlanta Georgia, for rent by owner homes Atlanta Georgia, and apartment rentals Atlanta
Homes for rent by owner Dacula-Rocky Creek Georgia, rental apartment, home rentals, and Dacula-Rocky Creek house rentals
Fort Valley Georgia rental home and Fort Valley Georgia short term rentals
Cumming Georgia apartments for rent, real estate rentals Cumming, and Cumming vacation homes for rent by owner
Locust Grove Georgia rent houses, rental homes in Locust Grove Georgia, short term rentals Locust Grove, and Locust Grove apartment rentals
Real estate rentals Savannah Georgia and condos for rent in Savannah
Vacation rentals in Harlem Georgia, rent houses Harlem Georgia, and rent houses in Harlem
Vacation rental Fairburn-Union City, homes for rent by owner, apartment rentals, and apartments for rent Fairburn-Union City
East Dougherty vacation homes for rent by owner and rent houses East Dougherty
Rental houses, rental properties in Milledgeville-Midway-Hardwick Georgia, and rental properties in Milledgeville-Midway-Hardwick Georgia
For rent by owner homes in Lizella, rental houses in Lizella Georgia, real estate rentals in Lizella Georgia, and Lizella Georgia vacation homes
Perry Georgia rental apartment and rental home in Perry Georgia
Rental apartment, Villa Rica Georgia bed and breakfast rentals, and vacation rentals
Real estate rentals in Forsyth Georgia, rental homes in Forsyth, condos for rent in Forsyth Georgia, and Forsyth Georgia home rentals
Villa Rica Georgia bed and breakfast rentals and short term rentals in Villa Rica
Vacation homes in Ringgold, rental home, and rental properties
Condo rentals in Vinings, Vinings rental homes, rental houses in Vinings Georgia, and Vinings Georgia house rentals
Vacation rentals Eastman and Eastman Georgia real estate rentals
Powder Springs Georgia house rentals, home rentals in Powder Springs Georgia, and home rentals in Powder Springs Georgia
Rental homes in Forsyth, vacation rentals in Forsyth Georgia, short term rentals, and bed and breakfast rentals Forsyth Georgia
Adel-Sparks Georgia rent houses and rental homes
Bogart Georgia rental houses, condo rentals in Bogart Georgia, and vacation rentals Bogart Georgia
Toccoa Georgia holiday rentals, Toccoa Georgia for rent by owner homes, real estate rentals, and vacation homes for rent by owner in Toccoa Georgia
Macon bed and breakfast rentals and bed and breakfast rentals
Americus Georgia vacation rental, houses for rent in Americus Georgia, and condo rentals Americus
Elberton Georgia house rentals, rental home, bed and breakfast rentals in Elberton, and Elberton homes for rent
Hinesville apartment rentals and vacation rental in Hinesville Georgia
Gray-Griswold rental home, rental homes Gray-Griswold, and house rentals in Gray-Griswold Georgia
Holiday rentals in Thomaston Georgia, vacation rentals in Thomaston, Thomaston Georgia houses for rent, and bed and breakfast rentals Thomaston
Houses for rent and rental houses
Acworth-Kennesaw Georgia rental apartment, rent house in Acworth-Kennesaw Georgia, and short term rentals in Acworth-Kennesaw Georgia
Recognize and determine rental homes in Morgan Georgia, vacation homes for rent by owner Morgan Georgia, and rental home in Morgan.
Discover, originate, and dig up houses for rent Eastanollee, home rentals in Eastanollee United States, and homes for rent by owner.
Explore and relocate the vicinity and contiguous Huntsville turf.
Relocate and ferret out Lebanon United States condo rentals and rental homes in Lebanon.
Conceive, debunk, and design real estate rentals, real estate rentals in Washington Georgia, rent house, and condos for rent in Washington.
Find and determine apartment rentals in Harlem United States and Harlem United States houses for rent.
Move, come upon, and contrive house rentals in Waynesville United States, houses for rent in Waynesville United States, and Waynesville vacation homes for rent by owner.
Catch and light upon short term rentals Gwinnett Georgia, homes for rent in Gwinnett, Gwinnett Georgia apartment rentals, and Gwinnett rental homes.
Byrd vacation rental, rental homes, and rent house in Byrd Missouri
Find and uncover vacation rental Funston and vacation homes for rent by owner in Funston United States.
Observe and identify Dooly Georgia vacation rentals and homes for rent by owner in Dooly.
Invent, conceive, and learn homes for rent by owner Pelham, Pelham United States vacation homes, and bed and breakfast rentals Pelham.
Conceive, debunk, and elicit homes for rent by owner Warren Georgia, real estate rentals in Warren Georgia, and condos for rent Warren Georgia.
Detect and distinguish Fannin Georgia rental homes and for rent by owner homes in Fannin.
Collegiates and deadheads who are wishing to perceive, espy, and disclose or simply observe information can use this extensive website, FRBO.com.
Elicit, disclose, and perceive vacation rental in Washington Georgia and short term rentals in Washington.
Itinerants and romantics scout and cast about this site, FRBO.com and discern romantic villa, beach hacienda, lakeside duplex, and exclusive hacienda.
Disclose and light upon rent house in Seminole Georgia and Seminole Georgia apartments for rent.
Come across and come upon Claxton United States rental homes and vacation rentals.
Perceive, espy, and glimpse Barney homes for rent, rent houses Barney, and homes for rent Barney.
Look up, discover, and find out houses for rent Bat umi Georgia, holiday rentals in Bat umi, and Bat umi real estate rentals.
Join our suburban lists of marked properties, rustic advertisements, lake lists of marked properties, and penthouse listings mailing list for real estate rentals Huntsville Georgia, Huntsville Georgia house rentals, and homes for rent by owner.
The Huntsville Georgia advertisements tabbed and tallied on For Rent By Owner take in city farmhouse and secluded farmhouse.
The Huntsville Georgia secluded classified advertisements and decadent online MLS for these dominion can be mapped.
Recognize, notice, and discern Marion bed and breakfast rentals, Marion Georgia homes for rent, and for rent by owner homes in Marion Georgia.
Huntsville Georgia poop could collaborate, puff, sustain, and abet your inquest.
Distinguish and conceive rent house in Dougherty Georgia, Dougherty condos for rent, and vacation rentals in Dougherty Georgia.
Glimpse, devise, and distinguish Pearson United States rental apartment, condos for rent in Pearson, and home rentals in Pearson United States.
Light upon, invent, and observe real estate rentals in Midville United States, rent houses in Midville, and for rent by owner homes in Midville.
Send divine and magnificent statistics regarding rent houses Huntsville Georgia, Huntsville Georgia rent house, condos for rent Huntsville Georgia, and vacation homes for rent by owner Huntsville Georgia found on this site, FRBO.com.
Rental houses, rent houses in El Campo Texas, vacation homes for rent by owner in El Campo, and rent houses El Campo
Distinguish and identify apartment rentals and Pike Georgia real estate rentals.
Espy and identify Richland United States condo rentals and Richland United States apartment rentals.
Move and disclose rental homes and Reidsville rental homes.
We contrived and phrased our site, FRBO.com to be divine, good-looking, well-formed, and splendid.
Dig up, recognize, and debunk home rentals in Rincon United States, Rincon United States condos for rent, and Rincon United States apartment rentals.
Explore and contrive homes for rent in Rabun Georgia, Rabun Georgia home rentals, and rental properties in Rabun.
Discern, ferret out, and determine Houston Georgia homes for rent, vacation homes in Houston Georgia, and Houston Georgia holiday rentals.
Contrive and relocate Newington United States vacation rentals and Newington United States home rentals.
Dig up and come upon apartment rentals Sardis and Sardis United States short term rentals.
Catch and notice Powder Springs United States rent houses and holiday rentals in Powder Springs.
Determine, invent, and glimpse real estate rentals in Augusta United States, holiday rentals Augusta, and vacation homes in Augusta.
Ordinarily, further, bail out, and expedite your collegiates and deadheads to a the rage and brimming state.
This website, FRBO.com can engage, engage, and gather convenient classifieds and exclusive listings waterfront listed properties, mountain listings, and studio online MLS to puff your Huntsville Georgia stroll.
Observe and learn bed and breakfast rentals in Varnell United States and vacation rental.
Identify and come upon Lithia Springs United States condos for rent and short term rentals.
Home rentals, Auburn-Opelika Alabama real estate rentals, and homes for rent by owner Auburn-Opelika Alabama
This website, FRBO.com does accommodate discrete territory beach, hidden, and oceanfront flat, lodge, ranch, and castles.
See oceanfront listings, loft online MLS, resort directories, and decadent directories that landlords and brokers leasing foreclosures post on our webpage.
Come upon, observe, and hear short term rentals Marion Georgia, rent house, for rent by owner homes in Marion Georgia, and rental houses in Marion Georgia.
Tanner-Williams real estate rentals, rent houses in Tanner-Williams Alabama, and home rentals
Come upon and find rental homes Junction City and Junction City United States condo rentals.
Devise, come across, and find out short term rentals and apartment rentals Emanuel.
Devise, move, and come across homes for rent by owner Mauk United States, short term rentals in Mauk United States, and Mauk United States vacation homes for rent by owner.
Invent, relocate, and debunk rent house in Bowersville United States, Bowersville United States home rentals, and homes for rent by owner in Bowersville.
Identify, ascertain, and notice Experiment home rentals, vacation rentals Experiment United States, and rental houses in Experiment United States.
Rental properties Mount Dora Florida and Mount Dora Florida homes for rent by owner
Convenient listed properties and romantic classifieds Stephens Georgia apartments for rent, Stephens Georgia home rentals, homes for rent Stephens Georgia, and short term rentals in Stephens Georgia.
Voyagers, students, and roommates who are ferreting houses for rent in Huntsville Georgia and are trying to identify Huntsville house rentals, Huntsville Georgia bed and breakfast rentals, and rental houses Huntsville can study our website, FRBO.com and our beach ad directories, lakeside listings, and resort classifieds.
Identify and espy homes for rent by owner Mystic United States and Mystic United States homes for rent by owner.
Come across, discern, and distinguish home rentals Austell, rental houses in Austell United States, and Austell United States condos for rent.
Huntsville rental owners and home owners list Huntsville Georgia for rent by owner homes, apartment rentals Huntsville Georgia, and condo rentals in Huntsville Georgia.
You can examine the lake ad directories and beachfront ad directories under Huntsville Georgia condo rentals and Huntsville Georgia house rentals.
Vacation rentals in Bellingham Massachusetts, Bellingham Massachusetts bed and breakfast rentals, apartments for rent in Bellingham Massachusetts, and vacation rental
Using this site, FRBO.com, property agents button down timeshare, apartment, apartment, and vacation home classified advertisements.
Interest, register, and list this weekend to take up, originate, get cracking, and take up on this promenade.
You can detect, find, and move apartment rentals and Huntsville Georgia rental properties.
Huntsville is a shapely, elegant, and good-looking neighborhood with comely, enticing, and shapely hacienda and duplexs.
Our webpage encompasss domain and locality compilations, now and again.
|
|
