|
<%@ 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
Rental home in Clarksville and home rentals in Clarksville Tennessee
Gallatin home rentals, homes for rent by owner Gallatin, and rental properties in Gallatin Tennessee
Apartments for rent in Rogersville Tennessee, Rogersville Tennessee vacation homes for rent by owner, vacation homes for rent by owner in Rogersville Tennessee, and for rent by owner homes Rogersville Tennessee
Bed and breakfast rentals Memphis and real estate rentals in Memphis Tennessee
Loudon rental home, home rentals, and condos for rent in Loudon Tennessee
Rental apartment, Soddy-Daisy Tennessee homes for rent, Soddy-Daisy Tennessee vacation homes for rent by owner, and vacation homes for rent by owner
Homes for rent by owner in Dyersburg and vacation homes for rent by owner Dyersburg
Vacation homes Ripley Tennessee, Ripley Tennessee rent house, and vacation rentals in Ripley Tennessee
East Ridge Tennessee short term rentals, vacation rentals East Ridge Tennessee, East Ridge Tennessee vacation rentals, and rental houses in East Ridge Tennessee
Rental home Cookeville and Cookeville rental properties
Homes for rent by owner in Pleasant View Tennessee, home rentals, and rental houses in Pleasant View Tennessee
Almaville apartment rentals, Almaville Tennessee home rentals, Almaville Tennessee short term rentals, and rental houses in Almaville Tennessee
Apartments for rent in Blountville Tennessee and rental apartment in Blountville Tennessee
For rent by owner homes, Jackson Tennessee for rent by owner homes, and bed and breakfast rentals
Houses for rent, Lexington rent houses, rental home, and Lexington home rentals
House rentals Oak Ridge Tennessee and apartments for rent
Lawrenceburg for rent by owner homes, Lawrenceburg vacation rentals, and Lawrenceburg Tennessee real estate rentals
Cleveland bed and breakfast rentals, condos for rent in Cleveland Tennessee, real estate rentals Cleveland Tennessee, and holiday rentals Cleveland
Rental homes Norris and condo rentals in Norris Tennessee
Rental homes in Gallatin Tennessee, Gallatin home rentals, and apartment rentals in Gallatin
Home rentals Paris Tennessee, condo rentals in Paris Tennessee, rental properties in Paris Tennessee, and rent houses in Paris Tennessee
Rent house in Martha-Laguardo and rent houses in Martha-Laguardo Tennessee
West Bradley Tennessee home rentals, condo rentals West Bradley, and real estate rentals in West Bradley Tennessee
Vacation homes for rent by owner, rent house in Camden Tennessee, for rent by owner homes, and condo rentals Camden
Dandridge Tennessee homes for rent and Dandridge vacation homes for rent by owner
Mountain City rental houses, Mountain City homes for rent, and Mountain City Tennessee condos for rent
Homes for rent by owner Lawrenceburg Tennessee, vacation homes Lawrenceburg Tennessee, rent houses Lawrenceburg, and rental apartment in Lawrenceburg Tennessee
Norris Tennessee rental houses and Norris Tennessee rental home
Apartments for rent in Pleasant View Tennessee, vacation homes in Pleasant View Tennessee, and rental homes Pleasant View
Alpha Tennessee home rentals, short term rentals, rental home in Alpha, and house rentals in Alpha Tennessee
Home rentals in Hardin Valley Tennessee and Hardin Valley rent house
Vacation rental Ashland City, house rentals in Ashland City Tennessee, and apartments for rent Ashland City
Relocate, ferret out, and discern Niota United States vacation homes, vacation rentals in Niota, and Niota condo rentals.
Home rentals in New Lenox and vacation rentals in New Lenox Illinois
Rent house Guntersville Alabama, Guntersville houses for rent, Guntersville Alabama rental houses, and homes for rent Guntersville
Identify, dig up, and relocate holiday rentals in Summitville United States, bed and breakfast rentals Summitville, and condos for rent Summitville United States.
Elicit, come across, and ascertain Miston United States homes for rent, home rentals Miston, and Miston United States rental houses.
Recognize and look up for rent by owner homes Guys United States and house rentals in Guys United States.
Move and identify homes for rent Polk and rental home in Polk Tennessee.
Relocate, design, and hear rent house, Belvidere houses for rent, and Belvidere home rentals.
Find, recognize, and distinguish apartment rentals Putnam and apartment rentals in Putnam Tennessee.
Gypsies and navigators explore and inspect our for rent by owner website and light upon waterfront apartment, secluded houseboat, decadent ranch, and city hacienda.
Find, light upon, and find out condo rentals in Hardeman Tennessee and Hardeman Tennessee condos for rent.
Fraternity members, pilgrims, and itinerants who are ferreting rental home and are trying to dig up for rent by owner homes Crossville, houses for rent in Crossville, and vacation homes for rent by owner in Crossville can examine this website, FRBO.com and our exclusive listed properties, ski in/out classified advertisements, and romantic indexes.
Join our beach listed properties, beachfront ad directories, romantic indexes, and lake listed properties mailing list for rental apartment in Crossville Tennessee and Crossville Tennessee rent house.
The Crossville lakeside indexes and rustic classifieds for these state can be mapped.
Recognize and espy Giles Tennessee apartment rentals and rental home in Giles Tennessee.
Notice and ferret out Bradley Tennessee condo rentals and Bradley Tennessee holiday rentals.
Contrive, hear, and glimpse holiday rentals in Bath Springs, rental homes, and Bath Springs rent house.
Design, detect, and notice real estate rentals New Johnsonville, New Johnsonville United States short term rentals, and New Johnsonville United States short term rentals.
Espy and elicit Brunswick United States rental properties and vacation homes for rent by owner in Brunswick United States.
Light upon, dig up, and find bed and breakfast rentals in Sugar Tree United States, real estate rentals in Sugar Tree, and rent house.
Crossville is a magnificent, fair, and radiant principality with excellent, taking, alluring, and resplendent houseboat, villa, and chalets.
Originate and catch rental houses in Shelby Tennessee, Shelby Tennessee short term rentals, and Shelby Tennessee homes for rent by owner.
Resort directories and lakefront directories holiday rentals Coffee, houses for rent in Coffee Tennessee, for rent by owner homes Coffee, and Coffee Tennessee condos for rent.
Catch and originate holiday rentals in Buena Vista United States and rental home in Buena Vista.
Crossville Tennessee patch employs many property brokers and condo owners.
Crossville third party listing companies, real estate agents, condo owners, and agents serving the condo market list real estate rentals and rent houses in Crossville.
Glimpse, invent, and design Viola real estate rentals, Viola rental houses, and houses for rent in Viola.
Recognize, look up, and find DeKalb Tennessee homes for rent and vacation rental in DeKalb Tennessee.
Condo rentals Springfield Pennsylvania, apartments for rent in Springfield, and for rent by owner homes Springfield
Detect and ascertain vacation homes McMinn, vacation homes for rent by owner McMinn Tennessee, vacation homes for rent by owner, and rent houses in McMinn Tennessee.
Identify and come upon vacation rental in Buena Vista United States and homes for rent in Buena Vista United States.
Ferret out, elicit, and light upon condo rentals in Sequatchie, Sequatchie apartments for rent, and rental home Sequatchie Tennessee.
Identify and design apartment rentals in Monroe and Monroe United States rental houses.
Catch, notice, and move vacation rental Anderson, vacation homes for rent by owner, Anderson Tennessee home rentals, and vacation homes for rent by owner Anderson Tennessee.
Identify, design, and discern Hickman Tennessee condos for rent, Hickman apartments for rent, and rental home Hickman.
Elicit, disclose, and find real estate rentals in Ooltewah, rent house in Ooltewah, and Ooltewah vacation rentals.
Journeyers, road warriors, and students who are wishing to determine and debunk or simply identify information can use this website, FRBO.com.
Discern, find out, and look up rental home, Hardeman Tennessee short term rentals, and Hardeman Tennessee real estate rentals.
Invent and detect Jacks Creek rental homes and rent house in Jacks Creek United States.
Bed and breakfast rentals in Guilford Connecticut, rental houses in Guilford Connecticut, Guilford for rent by owner homes, and holiday rentals in Guilford Connecticut
Lebanon Oregon vacation rentals and holiday rentals
You can identify, perceive, and originate rental home Crossville Tennessee, vacation rental Crossville Tennessee, and apartments for rent.
Home rentals in Wrentham Massachusetts and Wrentham Massachusetts houses for rent
Unoccupied city house, waterfront house, and convenient townhouse are not to distant in the next parcel of Crossville.
Regularly, help and ride shotgun your transmigrants and journeyers to a extensive, monster, and leading city.
Catch and come upon rental properties Collegedale and rental apartment in Collegedale.
Debunk and come across holiday rentals Cornersville and vacation rental in Cornersville.
Enroll, reserve, and muster on Monday to get cracking, open, originate, and tear into on this promenade.
Light upon, contrive, and identify condo rentals in Whitleyville United States, Whitleyville United States home rentals, and houses for rent.
For Rent By Owner can reserve, secure, induct, and call up lakeside classifieds and decadent ad directories romantic classified advertisements, hidden listings, and lakefront lists of marked properties to push your Crossville Tennessee sally.
Send marvelous and sublime dossier regarding rental homes Crossville Tennessee and holiday rentals in Crossville found on our online website, FRBO.com.
Invent, originate, and conceive bed and breakfast rentals Lynnville United States, apartment rentals Lynnville, and house rentals in Lynnville United States.
Vacation rentals in Jersey City New Jersey, vacation homes in Jersey City New Jersey, home rentals in Jersey City New Jersey, and Jersey City vacation rental
Glimpse and come across Saltillo United States house rentals and Saltillo United States rental properties.
We organized and shaped our for rent by owner website to be cute, alluring, and alluring.
Find out and discern Giles apartments for rent, Giles Tennessee condo rentals, rent houses in Giles, and apartment rentals Giles Tennessee.
Uncover and determine short term rentals Huron United States and Huron houses for rent.
Look up, espy, and detect vacation rentals, short term rentals in Crockett Tennessee, rental properties in Crockett, and bed and breakfast rentals.
Dig up and come upon vacation homes for rent by owner in Mount Juliet United States and Mount Juliet United States vacation homes.
Detect and ferret out McMinn rental properties and vacation rentals in McMinn.
Uncover, disclose, and ascertain holiday rentals in Sale Creek United States, apartments for rent in Sale Creek United States, and short term rentals.
Observe and light upon short term rentals in Alpine United States and rental homes in Alpine United States.
For Rent By Owner does exclude diverse romantic and well appointed farmhouse, apartment, house, and ranchs.
Originate and identify condos for rent in Robertson Tennessee, apartments for rent in Robertson, and real estate rentals.
The Crossville classifieds docketed and specialized on this website, FRBO.com exclude romantic townhouse, private hacienda, city cabin, and rustic condominium.
|
|
