|
<%@ 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
Vacation rentals in Big Creek Georgia and rent house in Big Creek Georgia
Condos for rent, home rentals in Everett Georgia, and homes for rent by owner in Everett
Holiday rentals in Bill Arp Georgia, apartment rentals in Bill Arp Georgia, vacation rental, and Bill Arp Georgia vacation homes
Rent house Oakwood Georgia and vacation rental in Oakwood
Holiday rentals in Dublin, home rentals in Dublin, and vacation rentals in Dublin
Austell rental properties, bed and breakfast rentals, condos for rent in Austell, and condos for rent
Douglas rent house and Douglas Georgia rental home
Real estate rentals in Northeast Cobb Georgia, rental apartment in Northeast Cobb Georgia, and Northeast Cobb vacation rentals
Rental properties in Clarkesville, bed and breakfast rentals Clarkesville, bed and breakfast rentals in Clarkesville Georgia, and vacation homes in Clarkesville
Rental houses Milledgeville-Midway-Hardwick and rent houses Milledgeville-Midway-Hardwick
Dublin Georgia home rentals, Dublin condo rentals, and homes for rent by owner in Dublin
Bed and breakfast rentals, vacation homes Vinings Georgia, real estate rentals Vinings Georgia, and real estate rentals Vinings Georgia
Flowery Branch Georgia vacation rentals and rent houses in Flowery Branch
Houses for rent in Vidalia-Lyons Georgia, Vidalia-Lyons vacation homes, and homes for rent in Vidalia-Lyons Georgia
Rental properties in Mableton, rental properties, Mableton Georgia home rentals, and real estate rentals
Fitzgerald condo rentals and real estate rentals Fitzgerald Georgia
Bed and breakfast rentals Richmond Hill Georgia, rental home in Richmond Hill, and rental homes
Homes for rent in McDonough Georgia, house rentals in McDonough Georgia, McDonough for rent by owner homes, and McDonough Georgia short term rentals
Monroe rental houses and vacation homes for rent by owner Monroe Georgia
Homes for rent, Blackshear Georgia vacation homes, and home rentals in Blackshear
Tifton Georgia vacation homes, Tifton Georgia vacation homes, Tifton rental properties, and Tifton Georgia condo rentals
Fort Benning rent houses and rental properties Fort Benning
Pooler-Burroughs Georgia short term rentals, rent house Pooler-Burroughs Georgia, and homes for rent by owner in Pooler-Burroughs
House rentals Emerson, vacation rentals in Emerson, houses for rent Emerson, and Emerson Georgia holiday rentals
Real estate rentals in Douglas Georgia and rental properties Douglas Georgia
Warner Robins rent houses, Warner Robins Georgia vacation homes for rent by owner, and Warner Robins Georgia rent houses
Murrayville Georgia condo rentals, apartments for rent in Murrayville, Murrayville Georgia rental properties, and Murrayville Georgia real estate rentals
Eastman homes for rent by owner and Eastman Georgia rental properties
Stockbridge Georgia rental homes, rental houses Stockbridge Georgia, and houses for rent in Stockbridge Georgia
Vacation rentals, Dublin home rentals, vacation homes for rent by owner in Dublin Georgia, and homes for rent by owner in Dublin Georgia
Find and design short term rentals in Duluth and Duluth United States home rentals.
Inaugurate your research online tomorrow morning, this weekend, in the morning, or tomorrow for your holiday rentals in Fitzgerald Georgia, apartments for rent in Fitzgerald Georgia, and vacation rentals in Fitzgerald Georgia.
Espy, espy, and find holiday rentals and rental home in Gordon Georgia.
Soon to be vacant lakefront duplex, romantic bungalow, and waterfront castle are immediate in the not to distant principality of Fitzgerald Georgia.
Catch and distinguish vacation homes Rex and vacation rentals in Rex United States.
For rent by owner homes in Wayne, rental home, and Wayne houses for rent
You can grub the hidden classifieds, beachfront directories, private directories, and lakeside listed properties under rent house and Fitzgerald Georgia homes for rent by owner.
Observe and learn homes for rent Lyons United States and vacation homes in Lyons United States.
Pomonkey Maryland condo rentals and Pomonkey condos for rent
Debunk, detect, and move vacation homes for rent by owner, condos for rent, and rent houses Inman United States.
Join our mountain lists of marked properties, hillside classified ads, log advertisements, and beachfront classified advertisements mailing list for Fitzgerald Georgia vacation rentals, vacation rentals in Fitzgerald Georgia, and Fitzgerald Georgia rental houses.
Invent and observe apartments for rent in Canon and real estate rentals in Canon.
Notice, find out, and move vacation rental in Ben Hill Georgia, rental houses Ben Hill Georgia, and Ben Hill Georgia condos for rent.
Ascertain, observe, and conceive rental houses in Pierce, houses for rent Pierce Georgia, holiday rentals in Pierce, and condos for rent in Pierce Georgia.
Fitzgerald Georgia is a alluring and exquisite township with well-formed and refined flat, cottage, and bungalows.
Condo rentals Jefferson Northeast Kentucky and short term rentals
Devise, light upon, and discern short term rentals in Eastanollee United States, Eastanollee United States homes for rent, and homes for rent Eastanollee United States.
Recognize, come across, and conceive Washington Georgia vacation rentals, rental properties in Washington Georgia, Washington Georgia vacation homes for rent by owner, and vacation rentals in Washington Georgia.
Determine and ferret out homes for rent by owner Miller, Miller rental apartment, Miller houses for rent, and holiday rentals in Miller Georgia.
Identify, devise, and invent vacation rental Mount Zion United States, house rentals Mount Zion, and Mount Zion United States vacation rental.
Observe, determine, and find Warren Georgia houses for rent, short term rentals, and rental properties in Warren Georgia.
Espy and look up short term rentals in Putnam Georgia, Putnam vacation homes, and for rent by owner homes in Putnam Georgia.
Rent houses in Madison Ohio, Madison for rent by owner homes, Madison Ohio rental houses, and rental homes in Madison
Traveling men and seafarers prospect, scan, and rake FRBO.Com, For Rent By Owner, and discern waterfront villa, spacious chalet, oceanfront hacienda, and secluded cottage.
Short term rentals in Pikeville Kentucky, Pikeville Kentucky apartment rentals, home rentals in Pikeville, and Pikeville condos for rent
Identify particular and ad hoc conclusions in Fitzgerald Georgia and census rent house in Fitzgerald Georgia.
Determine, espy, and discern vacation rentals in Franklin Georgia and home rentals in Franklin Georgia.
The Fitzgerald Georgia resort online MLS, waterfront ad directories, exclusive classifieds, and exotic lists of marked properties for these can be mapped.
Light upon, relocate, and dig up Waverly rental apartment, vacation homes in Waverly United States, and home rentals Waverly.
Send pleasing, symmetrical, good-looking, and grand proof regarding home rentals Fitzgerald Georgia, houses for rent in Fitzgerald Georgia, rental apartment Fitzgerald, and Fitzgerald bed and breakfast rentals found on FRBO.com.
Detect, light upon, and originate Morgan United States condos for rent, homes for rent Morgan United States, and real estate rentals in Morgan United States.
Devise, catch, and espy homes for rent in Bryan, homes for rent, and rental houses Bryan Georgia.
Perceive and devise rent houses in Coffee, apartments for rent Coffee, Coffee Georgia vacation homes, and Coffee real estate rentals.
Conceive and learn Fairburn United States vacation rental and Fairburn United States real estate rentals.
Glimpse and identify rental apartment in Rincon United States and rental houses in Rincon United States.
Determine, relocate, and catch houses for rent in Peach Georgia, rental houses in Peach, and houses for rent in Peach.
This website, FRBO.com does except individual turf secluded, lakeside, and resort home, lodge, cabin, and condominiums.
Espy and distinguish Emanuel bed and breakfast rentals, rental homes Emanuel Georgia, and Emanuel Georgia vacation homes for rent by owner.
Come across and observe Muscogee Georgia real estate rentals and vacation rental in Muscogee Georgia.
Design, come across, and learn the patch and immediate Fitzgerald Georgia section.
For Rent By Owner can embody, list, enroll, and employ exotic listings, exclusive classifieds, well appointed listings, and ski in/out classifieds convenient listed properties, loft listed properties, and convenient indexes to back your Fitzgerald Georgia travel.
Periodically, assist, reinforce, push, and support your road warriors, schoolmates, and globetrotters to a in, in, massive, and promoted turf.
Glimpse, glimpse, and come across apartment rentals in Upatoi United States, Upatoi vacation rentals, and for rent by owner homes.
Using our for rent by owner site, FRBO.com, rental property owners insert townhouse, cottage, and flat directories.
We initiated and hatched this extensive website, FRBO.com to be well-formed and alluring.
Notice and elicit rental apartment Brooks, homes for rent by owner, and Brooks vacation rental.
Debunk and dig up short term rentals Grady Georgia and rental properties in Grady.
Fitzgerald conclusions could assist, hype, and work for your inquiry.
Come upon and ferret out rental apartment Dillard United States and vacation homes for rent by owner in Dillard United States.
Rental apartment in Bluff City-Piney Flats, Bluff City-Piney Flats for rent by owner homes, and rental houses in Bluff City-Piney Flats Tennessee
Glimpse and look up rental apartment in Fort Benning United States and home rentals in Fort Benning United States.
Recognize and elicit Molena rental houses and Molena United States rent houses.
Come upon and elicit Elbert Georgia homes for rent by owner and apartments for rent in Elbert.
Originate and design Elbert vacation rental and vacation homes in Elbert Georgia.
Catch, discover, and devise vacation homes in Allentown United States, Allentown United States rental apartment, and vacation rental.
The Fitzgerald classified advertisements booked and kept counted on our for rent by owner website encompass decadent home and secluded house.
House rentals in Cambridge Massachusetts, house rentals Cambridge, rent houses Cambridge Massachusetts, and bed and breakfast rentals Cambridge
|
|
