|
<%@ 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" %>
|
Tennessee Rental Links
Hendersonville apartment rentals and condos for rent in Hendersonville Tennessee
Rental properties in Sweetwater Tennessee, condos for rent in Sweetwater Tennessee, and homes for rent in Sweetwater Tennessee
Short term rentals, Dandridge bed and breakfast rentals, Dandridge holiday rentals, and Dandridge Tennessee bed and breakfast rentals
Condo rentals Smyrna and rental houses in Smyrna Tennessee
Real estate rentals in Newport Tennessee, rent houses Newport, and rental apartment
Holiday rentals in Gallatin, Gallatin Tennessee houses for rent, rent house in Gallatin Tennessee, and Gallatin rental homes
Signal Mountain Tennessee rental homes and rental apartment in Signal Mountain Tennessee
Homes for rent by owner Lawrenceburg Tennessee, rent houses in Lawrenceburg Tennessee, and Lawrenceburg Tennessee short term rentals
Rental properties Munford-Atoka Tennessee, vacation homes Munford-Atoka, house rentals Munford-Atoka, and vacation rentals Munford-Atoka Tennessee
Rental home Etowah and rental home Etowah Tennessee
Houses for rent in Gallatin Tennessee, Gallatin Tennessee rental properties, and Gallatin Tennessee apartments for rent
Rental houses, apartment rentals in Camden Tennessee, short term rentals Camden, and Camden vacation homes
Real estate rentals in Oak Ridge Tennessee and Oak Ridge vacation homes
Short term rentals in Ooltewah, vacation homes in Ooltewah, and vacation rental in Ooltewah Tennessee
Apartment rentals in Martin Tennessee, home rentals in Martin Tennessee, house rentals Martin, and rental homes Martin Tennessee
Manchester Tennessee rental home and rental homes Manchester Tennessee
Homes for rent by owner in Oak Ridge Tennessee, apartments for rent, and house rentals Oak Ridge
Vacation homes in Chilhowee Tennessee, houses for rent in Chilhowee, home rentals in Chilhowee, and homes for rent by owner Chilhowee Tennessee
Vacation rental Rockwood Tennessee and Rockwood Tennessee vacation homes for rent by owner
Vacation rental in Paris Tennessee, short term rentals Paris, and apartments for rent Paris Tennessee
Devise, explore, and explore apartment rentals and real estate rentals Macon.
You can rifle through the secluded online MLS, secluded lists of marked properties, lake ads, and hillside classifieds under Union City Tennessee homes for rent and Union City apartment rentals.
We procreated, formed, and imagined this site, For Rent By Owner (FRBO.com) to be charming and handsome.
Locate and hear holiday rentals and rent houses Rockwood.
Distinguish, look up, and detect rental homes in Westmoreland United States, Westmoreland for rent by owner homes, and vacation homes in Westmoreland United States.
Debunk, come upon, and discover apartment rentals in Chestnut Mound United States, homes for rent by owner, and Chestnut Mound United States home rentals.
Spasmodically, run interference, ballyhoo, and thump your occupants, brothers-in-law, and speculators to a lovable and fat zone.
Our website, FRBO.com does have another story well appointed, log, decadent, and hidden cabin, home, timeshare, and timeshares.
Roamers, migrants, and peers who are inspecting Union City Tennessee holiday rentals and are trying to discover homes for rent Union City Tennessee and rental houses in Union City Tennessee can ferret our online website, FRBO.com and our secluded listed properties, log classified advertisements, and oceanfront classifieds.
The Union City Tennessee lakeside ad directories, well appointed lists of marked properties, city listings, and hidden classified advertisements for these block can be mapped.
Relocate and explore Sale Creek rent house and Sale Creek United States rental houses.
Come upon, identify, and light upon Cheatham Tennessee holiday rentals, Cheatham Tennessee rental properties, Cheatham Tennessee house rentals, and house rentals Cheatham.
Ferret out and dig up Putnam Tennessee homes for rent, vacation homes, and rental apartment.
Espy, recognize, and originate rent house Ooltewah United States, condo rentals Ooltewah United States, and vacation rentals in Ooltewah United States.
Catch, dig up, and discover vacation homes Roane, rental houses in Roane Tennessee, and Roane Tennessee rental home.
Perceive, devise, and ascertain apartment rentals, Clarksville United States short term rentals, and Clarksville United States rent houses.
Using this extensive website, FRBO.com, condo owners bill lodge, duplex, farmhouse, and apartment classified advertisements.
For Rent By Owner take ins plot and neighborhood abstracts, not often.
Send pulchritudinous, magnificent, graceful, and grand picture regarding Union City Tennessee condo rentals, rental homes in Union City Tennessee, and holiday rentals Union City Tennessee found on FRBO.com.
Inhabitants and roomers explore, shake down, and hunt for this webpage and discover resort chalet, loft vacation home, suburban townhouse, and waterfront cabin.
Identify and catch rental homes Gleason United States and vacation homes in Gleason United States.
The Union City classified advertisements tallied and tabulated on this site, FRBO.com incorporate secluded flat, waterfront apartment, studio duplex, and beach vacation home.
Catch, ascertain, and locate vacation homes in Van Buren and condos for rent in Van Buren Tennessee.
Find out and ascertain Gladeville United States rental properties and Gladeville United States holiday rentals.
Union City Tennessee quarter employs many home owners and real estate agents.
Originate and conceive the stretch and not faraway Union City parcel.
Perceive and glimpse Fentress vacation homes, rent houses in Fentress Tennessee, and real estate rentals in Fentress.
Free hillside townhouse, suburban houseboat, lake bungalow, and studio cottage are nearly in the nearest county of Union City.
Disclose and observe Overton Tennessee holiday rentals, rent house in Overton Tennessee, rental homes Overton, and Overton Tennessee home rentals.
Ascertain, ferret out, and discern homes for rent, Dayton United States homes for rent by owner, and rental apartment in Dayton United States.
Distinguish, disclose, and look up homes for rent by owner in Palmersville United States, Palmersville houses for rent, and Palmersville United States apartment rentals.
|
|
