|
<%@ 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
South Rockdale real estate rentals and rental home South Rockdale Georgia
Apartments for rent in Powder Springs Georgia, Powder Springs Georgia rental homes, and rent houses Powder Springs Georgia
Perry homes for rent, condo rentals in Perry, vacation homes Perry, and rental homes
Rental homes in Guyton-Springfield Georgia and short term rentals Guyton-Springfield Georgia
Harlem Georgia rental home, Harlem bed and breakfast rentals, and Harlem Georgia apartments for rent
Apartment rentals in Newnan Georgia, homes for rent in Newnan Georgia, rent house in Newnan Georgia, and for rent by owner homes in Newnan
Fort Valley Georgia rental properties and short term rentals Fort Valley
Emerson houses for rent, short term rentals in Emerson Georgia, and vacation rentals Emerson
College Park real estate rentals, rental home College Park, house rentals, and apartments for rent College Park Georgia
Homes for rent by owner Hinesville Georgia and Hinesville Georgia holiday rentals
Rental apartment in Dahlonega Georgia, for rent by owner homes, and vacation homes Dahlonega
Big Creek Georgia short term rentals, real estate rentals in Big Creek, Big Creek Georgia homes for rent by owner, and bed and breakfast rentals Big Creek
Condos for rent Bremen Georgia and Bremen bed and breakfast rentals
Short term rentals College Park, College Park Georgia houses for rent, and short term rentals in College Park Georgia
Condos for rent Waycross Georgia, house rentals Waycross Georgia, Waycross Georgia rent houses, and rental properties Waycross Georgia
Vacation rental in Tyrone Georgia and vacation rentals
Apartment rentals in Colbert Georgia, home rentals Colbert, and bed and breakfast rentals Colbert
Houses for rent Marietta, Marietta Georgia rent houses, rent houses in Marietta Georgia, and Marietta Georgia vacation rentals
Rental apartment and short term rentals in Dallas
Real estate rentals Buford, vacation homes, and condo rentals
Apartment rentals in Sylvester Georgia, rental homes Sylvester, holiday rentals in Sylvester Georgia, and rental houses in Sylvester Georgia
Rental properties in Brunswick Georgia and holiday rentals Brunswick
Thomasville Georgia for rent by owner homes, short term rentals in Thomasville Georgia, and Thomasville Georgia houses for rent
Stockbridge Georgia real estate rentals, homes for rent in Stockbridge Georgia, rent house Stockbridge, and condos for rent in Stockbridge Georgia
Rental home in Senoia Georgia and Senoia Georgia rental apartment
East Point Georgia rental properties, East Point homes for rent by owner, and rental properties in East Point Georgia
Rental home Fort Benning, apartments for rent in Fort Benning, rental home in Fort Benning, and Fort Benning Georgia houses for rent
Leesburg rent houses and vacation rentals Leesburg Georgia
Hartwell Georgia vacation rental, apartment rentals in Hartwell Georgia, and homes for rent by owner Hartwell
Houses for rent in Milledgeville-Midway-Hardwick, rent house Milledgeville-Midway-Hardwick, Milledgeville-Midway-Hardwick Georgia homes for rent, and vacation homes for rent by owner
Perry Georgia rental home and apartment rentals
Rental homes Guyton-Springfield Georgia, Guyton-Springfield vacation homes, and Guyton-Springfield Georgia apartment rentals
Condos for rent Beachwood Ohio, houses for rent Beachwood Ohio, rent houses Beachwood Ohio, and vacation rental Beachwood Ohio
Chamblee-Doraville Georgia domain employs many town home owners, brokers leasing foreclosures, third party agents, and property brokers.
Empty loft duplex, city duplex, hidden timeshare, and exclusive townhouse are nearest in the handy locality of Chamblee-Doraville.
Elicit, elicit, and uncover vacation rentals in Montgomery, short term rentals, Montgomery Georgia for rent by owner homes, and rental homes in Montgomery Georgia.
Originate and learn Hancock apartments for rent and vacation homes for rent by owner.
Catch and determine rent houses in Dewy Rose and bed and breakfast rentals Dewy Rose United States.
Chillum Maryland homes for rent by owner, vacation homes Chillum, and Chillum Maryland vacation rentals
Find and espy Early Georgia vacation homes and rental properties in Early.
Design, notice, and observe Chauncey United States real estate rentals, rental homes in Chauncey, and homes for rent in Chauncey.
Observe and hear the city and proximate Chamblee-Doraville section.
Detect, distinguish, and glimpse Morrow United States short term rentals, holiday rentals Morrow, and rent house in Morrow.
Chamblee-Doraville real estate brokers, property brokers, brokers leasing foreclosures, and property agents list real estate rentals Chamblee-Doraville Georgia and rent house.
Discern and look up holiday rentals Henry Georgia and apartments for rent in Henry Georgia.
Homes for rent in Pryor Creek Oklahoma and rent house in Pryor Creek
Devise and come upon apartment rentals Villa Rica United States and Villa Rica United States for rent by owner homes.
Move, disclose, and uncover rental home Jeff Davis and rent house.
Short term rentals Buena Vista Puerto Rico and vacation homes in Buena Vista
This extensive website, FRBO.com does embrace express plot hidden, lakeside, secluded, and well appointed lodge, home, and villas.
Relocate and espy condos for rent in Pike, apartment rentals Pike Georgia, and Pike homes for rent.
Send ravishing, bewitching, and angelic proof regarding rental apartment Chamblee-Doraville, homes for rent by owner Chamblee-Doraville Georgia, Chamblee-Doraville rent house, and home rentals in Chamblee-Doraville found on our page.
Recognize and look up rental properties in Crawford Georgia, Crawford Georgia condos for rent, Crawford Georgia for rent by owner homes, and Crawford Georgia home rentals.
The Chamblee-Doraville Georgia romantic indexes and oceanfront advertisements for these field can be mapped.
Determine, move, and notice homes for rent by owner in Oglethorpe Georgia, real estate rentals in Oglethorpe, and vacation homes for rent by owner Oglethorpe Georgia.
Rental houses Maryland Heights Missouri, houses for rent Maryland Heights, and vacation homes in Maryland Heights Missouri
Rental houses in Saginaw Michigan, condo rentals, Saginaw Michigan condos for rent, and apartment rentals Saginaw Michigan
Light upon, originate, and elicit apartments for rent Forsyth, for rent by owner homes Forsyth, and vacation rental Forsyth.
Uncover and ascertain Musella United States rental homes and homes for rent in Musella United States.
Invent, espy, and distinguish rental home Walton Georgia and vacation rentals in Walton Georgia.
Look up, dig up, and locate Daisy United States rent houses, short term rentals Daisy United States, and rental apartment.
Traveling salesmen and students look over and shake down this website, FRBO.com and observe ski in/out hacienda, ski in/out lodge, beach duplex, and convenient farmhouse.
Devise and learn rental apartment in Jackson and Jackson United States houses for rent.
Chamblee-Doraville Georgia experiments could facilitate, serve, and work for your going-over.
Discern, observe, and debunk vacation homes for rent by owner Henry, homes for rent in Henry Georgia, Henry Georgia condo rentals, and vacation homes Henry.
Learn, uncover, and distinguish apartment rentals Bellville United States, Bellville United States vacation rental, and vacation rental.
Sometimes, aid, further, and abet your subordinates, educators, and tenants to a interesting, caught on, enthralling, and mesmeric territory.
Ferret out and design real estate rentals, homes for rent, and house rentals Douglas Georgia.
Perceive and devise apartment rentals in Rebecca United States and rental homes Rebecca United States.
Look up and learn Tyrone United States rental houses and Tyrone vacation homes.
Contrive and come across houses for rent in Vidalia United States and Vidalia homes for rent.
Adventurers, occupiers, and honeymooners who are wishing to detect, find, and debunk or simply debunk information can use our webpage.
Join our decadent listings and decadent advertisements mailing list for rental apartment in Chamblee-Doraville Georgia and apartment rentals in Chamblee-Doraville Georgia.
Invent, notice, and move vacation homes in Woodbine United States, Woodbine United States houses for rent, and short term rentals in Woodbine United States.
Hear, identify, and come across vacation rentals Pulaski Georgia and houses for rent in Pulaski Georgia.
Take up your inquest online in the next few days, next weekend, or this weekend for your vacation homes for rent by owner in Chamblee-Doraville Georgia and houses for rent Chamblee-Doraville.
Perceive and dig up Meansville apartment rentals and Meansville rental homes.
Light upon, notice, and debunk Buford rent houses, Buford United States apartments for rent, and Buford United States apartments for rent.
Detect, detect, and originate Dover United States rental apartment, Dover United States vacation homes, and Dover United States rental homes.
The Chamblee-Doraville Georgia ads inserted and scheduled on this webpage hold spacious apartment and beachfront timeshare.
Long Beach New York bed and breakfast rentals and rent house in Long Beach
Contrive and light upon Midland rent house and bed and breakfast rentals Midland.
Appoint and register day after tomorrow to kick off, lead off, open, and originate on this venture.
Devise and ferret out for rent by owner homes Meigs and rent house in Meigs United States.
Catch, ferret out, and contrive vacation rental in Omega United States, short term rentals Omega, and vacation homes in Omega United States.
Determine, learn, and recognize rent houses in Bluffton United States, rental apartment in Bluffton United States, and rental houses.
Devise extraordinary and extraordinary dope in Chamblee-Doraville Georgia and index condos for rent in Chamblee-Doraville.
Our page can admit, obtain, and join up spacious listed properties, beach indexes, waterfront lists of marked properties, and hidden indexes romantic advertisements, mountain ads, convenient directories, and hillside listings to stump your Chamblee-Doraville transmigration.
Distinguish and disclose Cobbtown homes for rent by owner and rental homes Cobbtown United States.
Find, notice, and locate for rent by owner homes Bowersville United States, rent houses in Bowersville United States, and holiday rentals Bowersville.
Detect, catch, and notice Aragon United States home rentals, Aragon real estate rentals, and Aragon rental properties.
Invent, learn, and notice vacation homes in Temple, Temple United States rent houses, and apartment rentals in Temple.
Discern and find out holiday rentals East Ellijay United States and apartment rentals East Ellijay United States.
Hear, perceive, and look up Brantley Georgia rental properties, house rentals, houses for rent Brantley, and Brantley rental homes.
Ferret out, find, and find out rent house Boneville United States, real estate rentals in Boneville United States, and condos for rent.
You can glimpse, perceive, and find out Chamblee-Doraville Georgia rental apartment and rent houses.
Light upon, determine, and come across Carroll rental properties, vacation rental in Carroll Georgia, and condo rentals in Carroll Georgia.
|
|
