|
<%@ 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
Rent houses in Brownsville Tennessee and short term rentals in Brownsville
House rentals in Union City Tennessee, rent houses in Union City Tennessee, and rental homes in Union City Tennessee
Houses for rent Fairview, rental homes, Fairview holiday rentals, and real estate rentals Fairview
Houses for rent Union City and Union City Tennessee rent house
Homes for rent in Jackson Tennessee, holiday rentals Jackson Tennessee, and homes for rent in Jackson
Vacation rentals Norris, Norris Tennessee rent houses, rental houses Norris, and house rentals in Norris Tennessee
House rentals and Alpha Tennessee rent house
Home rentals in Mountain City, Mountain City Tennessee home rentals, and Mountain City rental properties
Franklin Tennessee rental apartment, apartment rentals, apartments for rent in Franklin, and Franklin Tennessee real estate rentals
Rent house Soddy-Daisy and Soddy-Daisy Tennessee real estate rentals
Winchester Tennessee bed and breakfast rentals, Winchester Tennessee house rentals, and Winchester short term rentals
Ooltewah Tennessee apartments for rent, rent house Ooltewah, condos for rent, and Ooltewah Tennessee vacation homes
Rental properties in Pleasant View Tennessee and rental houses Pleasant View Tennessee
Vacation homes for rent by owner in Sevierville, apartment rentals Sevierville Tennessee, and homes for rent by owner in Sevierville Tennessee
Apartment rentals Halls Tennessee, Halls Tennessee rent houses, short term rentals in Halls, and condo rentals Halls Tennessee
Rogersville Tennessee house rentals and Rogersville short term rentals
Rental home Springfield-Greenbrier Tennessee, Springfield-Greenbrier Tennessee vacation homes, and apartment rentals in Springfield-Greenbrier Tennessee
Johnson City vacation homes, apartment rentals Johnson City Tennessee, Johnson City home rentals, and rental properties in Johnson City Tennessee
Murfreesboro rent houses and rent houses in Murfreesboro Tennessee
Rental homes in McMinnville Tennessee, McMinnville Tennessee vacation homes, and vacation rentals in McMinnville Tennessee
Snow Hill real estate rentals, home rentals, apartments for rent, and vacation rental Snow Hill
Vacation homes and vacation homes
Signal Mountain condo rentals, vacation homes for rent by owner Signal Mountain Tennessee, and vacation homes for rent by owner in Signal Mountain Tennessee
Bed and breakfast rentals Humboldt, apartment rentals, rent house, and vacation rental in Humboldt Tennessee
Covington Tennessee homes for rent and vacation homes Covington
Bed and breakfast rentals, houses for rent Maryville-Alcoa Tennessee, and Maryville-Alcoa Tennessee holiday rentals
Rent houses in Collierville Tennessee, condos for rent in Collierville, Collierville Tennessee house rentals, and houses for rent Collierville
Kingsport rental apartment and Kingsport Tennessee rental home
Vacation rentals, rental houses in Winchester, and houses for rent in Winchester
Rental houses in Karns Tennessee, vacation homes for rent by owner in Karns Tennessee, short term rentals in Karns, and apartments for rent in Karns
Vacation rental in Lexington Tennessee and home rentals Lexington
Hardin Valley Tennessee for rent by owner homes, rental houses in Hardin Valley Tennessee, and vacation homes in Hardin Valley Tennessee
Relocate and observe rent house Roane and vacation rentals Roane Tennessee.
Send good-looking, charming, and grand statistics regarding Murfreesboro Tennessee vacation rentals and homes for rent in Murfreesboro found on this website, FRBO.com.
Discern, observe, and find out rental home in Smyrna, Smyrna United States rental houses, and apartments for rent in Smyrna.
You can espy and come upon Murfreesboro short term rentals and rental houses in Murfreesboro Tennessee.
Dig up, disclose, and recognize holiday rentals in Andersonville, rental properties Andersonville, and home rentals in Andersonville United States.
Move, perceive, and observe vacation homes for rent by owner, rental homes, rental properties in Rhea, and Rhea Tennessee apartment rentals.
Invent and glimpse real estate rentals in Pegram and Pegram United States apartments for rent.
Espy, debunk, and originate for rent by owner homes, home rentals Smith, and Smith Tennessee short term rentals.
Move, glimpse, and catch Wayne Tennessee home rentals and house rentals.
Look up and recognize vacation rental Duck River and Duck River United States for rent by owner homes.
Determine, move, and light upon Brentwood United States bed and breakfast rentals, Brentwood condo rentals, and Brentwood United States house rentals.
Our page incorporates territory and neighborhood whole story, once in a while.
Find and detect Lenoir rental properties and apartments for rent in Lenoir.
Ferret out and catch Memphis United States bed and breakfast rentals and Memphis United States vacation rentals.
Identify and espy Perry Tennessee rental homes and Perry Tennessee bed and breakfast rentals.
Identify, identify, and invent vacation homes for rent by owner, Cypress Inn United States homes for rent by owner, and Cypress Inn United States rental houses.
Look up and move bed and breakfast rentals, homes for rent in Trousdale Tennessee, and apartment rentals in Trousdale Tennessee.
Get going your going-over online this week or on Friday for your short term rentals in Murfreesboro Tennessee, rent house, and homes for rent by owner in Murfreesboro.
Devise and come upon Hawkins Tennessee houses for rent, vacation rental, vacation rentals Hawkins Tennessee, and homes for rent by owner in Hawkins Tennessee.
Discover and devise rental home in Oldfort United States and Oldfort United States condo rentals.
Look up and light upon apartments for rent and Dukedom United States rental apartment.
Recognize, light upon, and determine vacation rental, vacation homes for rent by owner Newbern United States, and rent house in Newbern United States.
Hear and uncover the parcel and convenient Murfreesboro Tennessee dominion.
Contrive and look up condo rentals in Hancock Tennessee, vacation rentals Hancock Tennessee, Hancock Tennessee homes for rent by owner, and Hancock Tennessee condos for rent.
Eagle Idaho rent house and holiday rentals in Eagle
Murfreesboro patch employs many third party agents, town home owners, and property managers.
Determine and espy condos for rent and rental homes Oldfort United States.
Short term rentals Buford Georgia, homes for rent by owner Buford, Buford Georgia rental houses, and bed and breakfast rentals in Buford Georgia
Design, debunk, and find out Obion vacation rental, houses for rent in Obion Tennessee, and apartments for rent in Obion.
Identify, discover, and originate rental properties in Jacksboro, rent houses, and Jacksboro United States home rentals.
Exclusive lists of marked properties and hillside ad directories homes for rent Carroll Tennessee, short term rentals in Carroll Tennessee, rental home Carroll Tennessee, and Carroll Tennessee apartments for rent.
Find out, design, and identify holiday rentals Viola United States, Viola United States real estate rentals, and rental home.
Glimpse, observe, and explore real estate rentals in Shelby Tennessee and Shelby Tennessee condos for rent.
Road warriors and locals chase after, scan, and look this website, FRBO.com and move ski in/out hacienda, loft flat, hidden houseboat, and beach house.
Road warriors and sailors who are wishing to determine and observe or simply disclose information can use our site, FRBO.com.
This webpage can enroll, initiate, list, and join up penthouse listings and lakefront classifieds exotic classified ads, oceanfront classified advertisements, hidden lists of marked properties, and beach classified ads to work with your Murfreesboro Tennessee exploration.
House rentals Abbotts Creek North Carolina, bed and breakfast rentals in Abbotts Creek North Carolina, and rental properties in Abbotts Creek North Carolina
Dig up, glimpse, and notice Houston Tennessee for rent by owner homes, Houston houses for rent, Houston Tennessee rental home, and rental apartment in Houston.
Uncover, invent, and glimpse Tipton Tennessee real estate rentals and bed and breakfast rentals in Tipton.
Disclose unique, startling, specific, and distinctive testimony in Murfreesboro Tennessee and tab rental homes.
Rental apartment in Rawlins Wyoming, short term rentals Rawlins, and rent houses in Rawlins Wyoming
You can examine the mountain classifieds and exotic classified ads under vacation rentals Murfreesboro Tennessee and holiday rentals Murfreesboro.
Condo rentals and Farmington New Mexico homes for rent
The Murfreesboro classifieds booked and census on FRBO.Com, For Rent By Owner, comprise city duplex, studio condominium, and decadent condominium.
Come upon, discern, and espy Caryville United States rental homes, Caryville United States rent house, and house rentals.
|
|
