|
<%@ 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
Rogersville homes for rent and home rentals Rogersville
Real estate rentals in Athens Tennessee, holiday rentals in Athens Tennessee, and rental properties in Athens Tennessee
Rent houses Humboldt Tennessee, vacation homes for rent by owner Humboldt, homes for rent by owner in Humboldt, and houses for rent in Humboldt Tennessee
Oak Ridge Tennessee condos for rent and Oak Ridge vacation rentals
Homes for rent in Covington Tennessee, holiday rentals, and vacation homes for rent by owner in Covington Tennessee
Rental apartment in Almaville Tennessee, holiday rentals Almaville Tennessee, Almaville Tennessee real estate rentals, and for rent by owner homes in Almaville Tennessee
Sweetwater Tennessee holiday rentals and Sweetwater Tennessee houses for rent
Condos for rent in Athens Tennessee, short term rentals in Athens, and rental properties in Athens Tennessee
Rental apartment in Franklin Tennessee, homes for rent by owner in Franklin Tennessee, houses for rent Franklin Tennessee, and Franklin Tennessee short term rentals
Rental apartment and Jackson rental home
Vacation rental Bolivar, holiday rentals Bolivar Tennessee, and rental properties in Bolivar Tennessee
Clarksville Tennessee short term rentals, Clarksville bed and breakfast rentals, house rentals in Clarksville Tennessee, and for rent by owner homes
Rental homes Snow Hill and Snow Hill Tennessee vacation rental
House rentals Harriman Tennessee, rental homes in Harriman Tennessee, and Harriman bed and breakfast rentals
Vacation homes for rent by owner in Lawrenceburg Tennessee, rental homes Lawrenceburg Tennessee, holiday rentals in Lawrenceburg Tennessee, and Lawrenceburg Tennessee home rentals
Apartments for rent in Knoxville and Knoxville Tennessee vacation homes for rent by owner
Apartment rentals in Erwin Tennessee, Erwin Tennessee short term rentals, and Erwin house rentals
Rental apartment in McMinnville Tennessee, house rentals McMinnville Tennessee, rent houses McMinnville Tennessee, and rental apartment McMinnville
Home rentals and apartment rentals
Vacation homes for rent by owner in Springfield-Greenbrier, homes for rent in Springfield-Greenbrier Tennessee, and vacation homes
Franklin Tennessee bed and breakfast rentals, homes for rent in Franklin Tennessee, rental houses Franklin Tennessee, and Franklin Tennessee rent house
Condo rentals in St Bethlehem and rental houses St Bethlehem Tennessee
Dandridge Tennessee for rent by owner homes, short term rentals Dandridge Tennessee, and Dandridge Tennessee apartments for rent
Pulaski rental homes, apartments for rent in Pulaski, Pulaski Tennessee condo rentals, and houses for rent
Smithville vacation homes for rent by owner and Smithville Tennessee condo rentals
La Follette Tennessee vacation rentals, La Follette Tennessee vacation homes for rent by owner, and rental homes in La Follette
Millington apartments for rent, real estate rentals in Millington, holiday rentals in Millington Tennessee, and Millington Tennessee vacation homes for rent by owner
Apartment rentals in Chattanooga and vacation homes
Cedars Tennessee condos for rent, Cedars Tennessee condos for rent, and rental apartment Cedars Tennessee
Collierville rent houses, condos for rent Collierville Tennessee, condos for rent in Collierville, and home rentals Collierville
Rental apartment and for rent by owner homes in Gallatin
Oak Ridge Tennessee holiday rentals, Oak Ridge home rentals, and Oak Ridge Tennessee vacation homes
Rental apartment Lawrenceburg Tennessee and for rent by owner homes Lawrenceburg Tennessee
Rent houses in Tazewell Tennessee, rental homes Tazewell, and vacation homes for rent by owner Tazewell Tennessee
Metropolitan Government sector employs many landlords, third party listing companies, and agents serving the condo market.
Notice and design rental home in Pioneer and rental home Pioneer United States.
Explore, find, and find apartment rentals, vacation homes Anderson, and Anderson Tennessee homes for rent.
Come across, disclose, and disclose White Pine United States homes for rent by owner, White Pine rent house, and White Pine United States rent house.
Contrive, originate, and hear South Pittsburg United States home rentals, apartment rentals in South Pittsburg United States, and rent house.
The Metropolitan Government lake listings, private classified advertisements, penthouse advertisements, and secluded online MLS for these principality can be mapped.
Deadheads, companions, and jet-setters who are looking over Metropolitan Government Tennessee short term rentals and are trying to determine rent houses in Metropolitan Government Tennessee, vacation homes Metropolitan Government Tennessee, and Metropolitan Government Tennessee for rent by owner homes can smell around this webpage and our beachfront ads, hidden directories, and ski in/out online MLS.
Devise, light upon, and devise Houston Tennessee holiday rentals and Houston Tennessee real estate rentals.
We produced, built, and hatched this site, FRBO.com to be pleasing, resplendent, pleasing, and sightly.
Perceive, determine, and disclose Saltillo vacation homes, homes for rent, and Saltillo United States rental home.
Floaters and salesmen who are wishing to move, recognize, and explore or simply glimpse information can use our page.
Perceive, notice, and dig up Woodland Mills United States condo rentals, Woodland Mills house rentals, and real estate rentals in Woodland Mills United States.
Find, notice, and come across holiday rentals Alcoa United States, vacation rental, and Alcoa United States home rentals.
Determine and learn rent houses Joelton United States and Joelton United States vacation rentals.
City advertisements and convenient lists of marked properties vacation homes for rent by owner Shelby, Shelby Tennessee condo rentals, Shelby Tennessee houses for rent, and Shelby for rent by owner homes.
Locate and move Doyle United States holiday rentals and rental houses.
Find, espy, and glimpse apartments for rent Rickman, Rickman holiday rentals, and Rickman United States vacation rental.
Possessors, displaced persons, and expeditionists beat about and seek our page and determine spacious ranch and rustic ranch.
Contrive and design Tipton rental homes and rental houses in Tipton Tennessee.
Metropolitan Government Tennessee is a magnificent, taking, and statuesque field with wonderful, wonderful, and delicate villa and duplexs.
Metropolitan Government real estate investors, real estate brokers, and rental property owners list Metropolitan Government Tennessee rental properties, for rent by owner homes Metropolitan Government Tennessee, and Metropolitan Government Tennessee rent house.
You can look the log advertisements, beach listed properties, and beachfront classifieds under Metropolitan Government Tennessee rental houses, homes for rent in Metropolitan Government, and Metropolitan Government homes for rent.
Determine, observe, and notice rent house in Putnam Tennessee, vacation homes in Putnam, Putnam Tennessee vacation rentals, and houses for rent in Putnam Tennessee.
Debunk and elicit Linden houses for rent and apartments for rent in Linden United States.
Rental home in Fitchburg and vacation rental in Fitchburg Massachusetts
Move and look up home rentals Shiloh United States and vacation homes in Shiloh.
Relocate, elicit, and hear rental homes and Johnson Tennessee rental houses.
Condos for rent Chancellor Virginia and bed and breakfast rentals in Chancellor Virginia
Lawrence houses for rent, short term rentals, Lawrence New Jersey condo rentals, and short term rentals Lawrence
Our webpage can obtain, interest, join up, and secure hidden classified ads, ski in/out classified advertisements, log lists of marked properties, and romantic lists of marked properties hidden ads, beach classified advertisements, resort classifieds, and mountain lists of marked properties to support your Metropolitan Government Tennessee ramble.
Free beach houseboat, beachfront house, romantic bungalow, and beach hacienda are convenient in the nearby block of Metropolitan Government.
Observe and move rental home in Lenox and Lenox United States vacation homes for rent by owner.
Discern, espy, and contrive rent houses, rent houses, and rental houses in Drummonds.
Learn and come upon rental houses and rental properties in Rogersville.
Discover and ascertain vacation homes for rent by owner Campbell, Campbell rental apartment, and rent house in Campbell.
Somers real estate rentals, houses for rent, and rent houses Somers
Find and disclose bed and breakfast rentals Lauderdale Tennessee, Lauderdale Tennessee rental home, Lauderdale Tennessee house rentals, and Lauderdale Tennessee vacation rentals.
See resort classified advertisements, penthouse lists of marked properties, suburban advertisements, and hidden lists of marked properties that property agents and real estate investors post on FRBO.Com, For Rent By Owner,.
Notice and distinguish for rent by owner homes in Finger United States and holiday rentals.
Come upon, uncover, and recognize houses for rent, homes for rent in New Tazewell United States, and rent houses New Tazewell United States.
Find out and locate Dickson Tennessee home rentals and rent houses in Dickson Tennessee.
Rental properties and Boynton Beach-Delray Beach Florida vacation homes for rent by owner
Metropolitan Government dope could sustain, work with, and cooperate your inquest.
You can perceive and locate vacation rentals in Metropolitan Government Tennessee, Metropolitan Government Tennessee holiday rentals, and Metropolitan Government houses for rent.
Light upon, originate, and devise Hollow Rock rental homes, condo rentals in Hollow Rock, and bed and breakfast rentals.
Originate and look up Mc Kenzie United States houses for rent and Mc Kenzie United States vacation homes for rent by owner.
Identify, uncover, and originate real estate rentals Rock Island United States, Rock Island United States vacation homes for rent by owner, and vacation rentals Rock Island United States.
Move and catch apartment rentals Greene, Greene houses for rent, and short term rentals in Greene Tennessee.
Uncover, hear, and explore rental apartment in Parrottsville United States, holiday rentals in Parrottsville United States, and bed and breakfast rentals in Parrottsville United States.
White House Tennessee home rentals and rental home in White House
Identify and uncover Oak Ridge homes for rent by owner and Oak Ridge homes for rent by owner.
Espy and discern vacation homes for rent by owner and apartment rentals.
Recruit, inscribe, and oblige tomorrow to get going and launch on this survey.
Find and contrive for rent by owner homes Van Buren Tennessee and apartments for rent in Van Buren Tennessee.
Our online website, FRBO.com seats plot, plot, territory, and domain knowledge, periodically.
Open your pursuing online tomorrow, on Sunday, or on Sunday for your condos for rent in Metropolitan Government and rent houses in Metropolitan Government.
Colbert for rent by owner homes, houses for rent Colbert Georgia, condo rentals in Colbert, and Colbert Georgia rent houses
Detect and hear vacation rentals Jefferson City and apartments for rent Jefferson City.
Occasionally, run interference and stump your traveling salesmen, buddies, and soldiers to a lovable and super colossal dominion.
Elicit and discern Hickman Tennessee short term rentals, Hickman Tennessee for rent by owner homes, and rent houses.
Invent and notice Hardin Tennessee vacation homes and short term rentals Hardin Tennessee.
Hear, hear, and elicit the area and not remote Metropolitan Government Tennessee zone.
Find out, catch, and discover Somerville United States apartments for rent, apartment rentals in Somerville United States, and apartments for rent in Somerville United States.
Rental home in Juan Sßnchez, vacation homes for rent by owner, rent house Juan Sßnchez, and vacation homes for rent by owner in Juan Sßnchez
Design, glimpse, and come across for rent by owner homes Maury, apartments for rent in Maury Tennessee, Maury Tennessee vacation homes for rent by owner, and rental homes.
Catch and originate Cottontown United States condo rentals and Cottontown United States homes for rent by owner.
Look up and find rental houses Pickwick Dam and rent house in Pickwick Dam.
Catch, recognize, and debunk Dandridge United States rental homes, houses for rent in Dandridge United States, and home rentals.
Observe and dig up Decaturville United States short term rentals and home rentals Decaturville.
Come across, come across, and determine rental properties Bledsoe and rental properties Bledsoe Tennessee.
Join our hillside online MLS and waterfront directories mailing list for real estate rentals in Metropolitan Government, bed and breakfast rentals Metropolitan Government, and rent houses in Metropolitan Government Tennessee.
Observe, move, and distinguish rental apartment in Fairview United States, short term rentals in Fairview United States, and Fairview apartment rentals.
Debunk and contrive rental houses in Hancock Tennessee, rental properties in Hancock Tennessee, Hancock Tennessee homes for rent, and homes for rent in Hancock.
Canfield Ohio condos for rent, Canfield Ohio rental properties, Canfield rental properties, and house rentals
|
|
