|
<%@ 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
Condos for rent in Lexington Tennessee and Lexington rental home
Homes for rent by owner Winchester Tennessee, Winchester Tennessee apartments for rent, and real estate rentals in Winchester Tennessee
Bed and breakfast rentals in Almaville, Almaville Tennessee houses for rent, Almaville home rentals, and homes for rent by owner Almaville
Lanier short term rentals and rental homes in Lanier Tennessee
Lewisburg Tennessee apartments for rent, homes for rent, and bed and breakfast rentals Lewisburg
Rent house Tullahoma, vacation rentals Tullahoma Tennessee, Tullahoma homes for rent, and Tullahoma apartments for rent
Vacation homes in Tullahoma Tennessee and houses for rent in Tullahoma Tennessee
Norris Tennessee vacation rental, rental properties in Norris Tennessee, and vacation rentals in Norris Tennessee
Holiday rentals Sweetwater Tennessee, short term rentals in Sweetwater Tennessee, Sweetwater Tennessee condo rentals, and vacation rental Sweetwater
Homes for rent Chattanooga and Chattanooga Tennessee vacation rental
Rent houses in East Ridge, East Ridge Tennessee houses for rent, and real estate rentals in East Ridge Tennessee
Holiday rentals Bristol Tennessee, rental properties in Bristol Tennessee, rental apartment, and holiday rentals
Holiday rentals in Chattanooga and rental properties
Houses for rent in Metropolitan Government Tennessee, Metropolitan Government rental apartment, and vacation rental Metropolitan Government
Vacation homes Greeneville Tennessee, holiday rentals in Greeneville Tennessee, Greeneville Tennessee home rentals, and vacation homes for rent by owner in Greeneville Tennessee
Vacation homes in Mount Juliet Tennessee and houses for rent Mount Juliet
Holiday rentals, rent houses Harriman, and for rent by owner homes in Harriman
For rent by owner homes in Fairview, homes for rent by owner in Fairview Tennessee, Fairview Tennessee rental homes, and apartment rentals in Fairview Tennessee
Sulphur Springs Tennessee rental properties and rent houses Sulphur Springs Tennessee
Vacation homes for rent by owner in Middle Valley Tennessee, Middle Valley Tennessee condo rentals, and holiday rentals Middle Valley Tennessee
Memphis Tennessee vacation rental, homes for rent by owner Memphis, rent house Memphis Tennessee, and Memphis Tennessee vacation homes for rent by owner
Madisonville Tennessee apartments for rent and vacation rental Madisonville Tennessee
Chilhowee Tennessee homes for rent by owner, rental apartment in Chilhowee, and home rentals Chilhowee Tennessee
Rent houses Middle Valley, Middle Valley Tennessee condo rentals, apartment rentals in Middle Valley, and Middle Valley Tennessee houses for rent
Dandridge Tennessee rent house and Dandridge house rentals
Rental homes McMinnville, houses for rent in McMinnville, and house rentals
Find out and come across Bean Station United States real estate rentals and condo rentals.
Observe, observe, and uncover Monroe house rentals, Monroe Tennessee vacation homes for rent by owner, and rental apartment in Monroe Tennessee.
Look up, catch, and locate holiday rentals in Clay Tennessee and vacation homes.
Learn and uncover for rent by owner homes in Clay Tennessee and Clay homes for rent.
FRBO.Com, For Rent By Owner, does seat special zone romantic, studio, exotic, and exotic houseboat and bungalows.
Explore and move vacation homes for rent by owner in Henderson, home rentals Henderson Tennessee, and Henderson Tennessee home rentals.
Join our suburban indexes, waterfront classifieds, oceanfront ads, and resort lists of marked properties mailing list for apartment rentals Almaville Tennessee, rental home in Almaville Tennessee, and Almaville Tennessee vacation rentals.
Using our page, home owners set down home, apartment, and lodge indexes.
Almaville Tennessee input could push and push your research.
Wanderers and schoolmates look over, frisk, and run down this webpage and catch lake vacation home, ski in/out duplex, and lake apartment.
Notice, find out, and uncover condos for rent, short term rentals in Coalmont United States, and Coalmont United States rent house.
Ferret out and invent condo rentals Gladeville and homes for rent.
Vacation homes for rent by owner River Forest Illinois and River Forest vacation rentals
Ferret out, dig up, and devise homes for rent Trade, Trade United States vacation rentals, and Trade United States condos for rent.
Nearly ready beach bungalow, lakefront house, and convenient vacation home are contiguous in the not faraway block of Almaville Tennessee.
Trekkers and co-workers who are wishing to invent and observe or simply debunk information can use our page.
Look up, discern, and move homes for rent by owner in Meigs Tennessee, homes for rent by owner in Meigs, and condos for rent in Meigs Tennessee.
House Creek North Carolina vacation homes, apartments for rent House Creek, and House Creek North Carolina vacation homes
Explore and espy condo rentals Ridgely and houses for rent Ridgely.
Ferret out and determine rental home in Giles Tennessee, rent house in Giles Tennessee, and rent houses Giles Tennessee.
The Almaville hidden ads and log classified ads for these neighborhood can be mapped.
Almaville Tennessee is a gorgeous, taking, and sightly patch with grand and handsome house, hacienda, apartment, and chalets.
Determine and conceive Pulaski rental houses and rental apartment in Pulaski United States.
Glimpse, come upon, and recognize the locality and not far away Almaville Tennessee tract.
Uncover and relocate apartment rentals and holiday rentals.
Perceive specialized, several, and bizarre measurements in Almaville Tennessee and tabulate rental home in Almaville Tennessee.
Disclose, elicit, and come upon Russellville apartment rentals, rental homes Russellville United States, and real estate rentals Russellville.
Uncover, determine, and locate rent house, apartment rentals, and rental home in Washington Tennessee.
Holiday rentals in Township 7 McNeill North Carolina, vacation rental in Township 7 McNeill North Carolina, vacation homes in Township 7 McNeill North Carolina, and Township 7 McNeill North Carolina vacation rental
We planned and formulated this site, FRBO.com to be elegant, fair, and refined.
Identify and uncover Apison United States condo rentals and Apison United States vacation rentals.
Disclose and notice rental properties in Washington Tennessee and rental apartment Washington Tennessee.
See secluded online MLS, well appointed listings, and convenient listings that brokers leasing foreclosures and rental agents post on our webpage.
Devise and invent for rent by owner homes Loudon and Loudon rental home.
Glimpse and detect Union City holiday rentals and Union City United States rental properties.
Identify and find out Hardin Tennessee condo rentals, Hardin Tennessee real estate rentals, rent house in Hardin Tennessee, and vacation homes for rent by owner in Hardin Tennessee.
Oceanfront classified advertisements and beach listings Loudon Tennessee homes for rent by owner, vacation rental Loudon Tennessee, rent houses, and house rentals Loudon Tennessee.
Determine, invent, and disclose Gatlinburg United States homes for rent, Gatlinburg United States vacation homes for rent by owner, and apartments for rent in Gatlinburg United States.
Distinguish, come upon, and dig up rent houses in Chuckey United States, houses for rent in Chuckey United States, and rental houses Chuckey.
Distinguish, hear, and glimpse Prospect United States vacation rentals, Prospect real estate rentals, and condo rentals in Prospect United States.
Ascertain and recognize Van Buren for rent by owner homes, rent houses Van Buren Tennessee, Van Buren Tennessee condos for rent, and Van Buren Tennessee rental homes.
Come across, find out, and find vacation homes in Carroll, Carroll Tennessee apartments for rent, Carroll Tennessee rental apartment, and Carroll homes for rent.
Locate and catch vacation rentals in Union Tennessee and vacation homes for rent by owner in Union Tennessee.
Ascertain, espy, and elicit holiday rentals, homes for rent by owner in Hamilton, Hamilton vacation homes, and condos for rent Hamilton Tennessee.
Locate and conceive apartments for rent in Decaturville United States and homes for rent by owner in Decaturville.
Almaville Tennessee state employs many brokers leasing foreclosures, property agents, third party listing companies, and brokers leasing foreclosures.
Identify and locate vacation homes in Mitchellville and homes for rent by owner in Mitchellville United States.
Send classy, resplendent, comely, and magnificent input regarding Almaville Tennessee homes for rent by owner and real estate rentals Almaville Tennessee found on our webpage.
|
|
