|
<%@ 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" %>
|
Texas Rental Links
Holiday rentals in Montgomery and house rentals in Montgomery Texas
Vacation homes for rent by owner in Montalba-Tennessee Colony Texas, holiday rentals in Montalba-Tennessee Colony Texas, and house rentals Montalba-Tennessee Colony
Rental apartment in Lockhart, rental homes Lockhart, homes for rent by owner Lockhart, and rental homes Lockhart
Rental apartment and Forney Texas vacation homes
Vacation homes for rent by owner in Paris Texas, home rentals in Paris Texas, and homes for rent by owner in Paris Texas
Apartments for rent in Levelland Texas, vacation homes for rent by owner Levelland, Levelland homes for rent, and home rentals Levelland Texas
Rental houses Willis Texas and Willis Texas rental apartment
Rent house in Mexia Texas, real estate rentals in Mexia Texas, and condos for rent
Burkburnett rental houses, Burkburnett Texas real estate rentals, Burkburnett homes for rent by owner, and holiday rentals Burkburnett Texas
Rental home and houses for rent Graham Texas
Real estate rentals, real estate rentals, and Zapata Texas rent houses
San Antonio Texas rental homes, rental homes in San Antonio, house rentals San Antonio, and real estate rentals San Antonio
Henderson rental home and real estate rentals Henderson Texas
Gilmer Texas rental properties, real estate rentals in Gilmer, and rental home in Gilmer Texas
Northwest Rockwall Texas rent house, Northwest Rockwall Texas bed and breakfast rentals, Northwest Rockwall Texas condo rentals, and vacation homes in Northwest Rockwall
Vacation rental Waller and Waller Texas vacation homes
Bed and breakfast rentals in Waxahachie, vacation homes, and Waxahachie Texas real estate rentals
Rental homes Zapata Texas, apartments for rent in Zapata, Zapata Texas rental homes, and houses for rent in Zapata Texas
Rent houses Levelland and rent house in Levelland Texas
Northeast Tarrant house rentals, condo rentals in Northeast Tarrant Texas, and Northeast Tarrant Texas rent house
Rental homes in Sweetwater Texas, rental properties, Sweetwater Texas rent houses, and Sweetwater Texas apartment rentals
Homes for rent Devine-Natalia Texas and vacation rental Devine-Natalia
Rent house in Amarillo Texas, rent houses Amarillo, and rent house Amarillo
Home rentals in Bastrop, Bastrop rental houses, Bastrop Texas home rentals, and rental houses Bastrop Texas
Home rentals in Brownsville Texas and rental houses Brownsville Texas
Disclose and glimpse short term rentals, Zavala vacation homes, and Zavala Texas apartments for rent.
Recognize, devise, and look up Whitesboro United States homes for rent by owner, Whitesboro vacation homes for rent by owner, and short term rentals Whitesboro.
Disclose, explore, and observe Zavala Texas homes for rent, rent houses in Zavala Texas, rental properties in Zavala Texas, and rental properties in Zavala Texas.
House rentals in Lake Tahoe California, Lake Tahoe California rental properties, house rentals in Lake Tahoe California, and Lake Tahoe California rental homes
Devise and find real estate rentals in Lenorah and vacation homes for rent by owner in Lenorah.
Using this site, FRBO.com, home owners button down ranch and condominium ads.
Apartment rentals Belleview and Belleview Florida rental houses
Discover, relocate, and come upon vacation homes in Hale Texas, rental properties Hale, and vacation rental in Hale.
You can hunt the romantic online MLS, private ad directories, and beachfront directories under apartments for rent and Kerrville Texas condos for rent.
Discover, come across, and move rent house in Franklin United States, vacation rentals in Franklin, and Franklin United States apartments for rent.
Determine and discern rental apartment in Zapata Texas and vacation rental in Zapata Texas.
Ferret out and glimpse Kaufman vacation homes and real estate rentals in Kaufman Texas.
We made and occasioned For Rent By Owner to be appealing and handsome.
Ferret out and observe home rentals in Doucette United States and real estate rentals Doucette United States.
Invent, come upon, and hear apartments for rent in Ross United States, condo rentals in Ross United States, and Ross United States short term rentals.
Find, identify, and catch short term rentals Mills Texas, homes for rent by owner Mills Texas, and Mills rental houses.
Send admirable and handsome poop sheet regarding vacation homes in Kerrville Texas, short term rentals, and rental homes Kerrville found on this site, FRBO.com.
Contrive and ferret out vacation rental and home rentals.
Our for rent by owner website can appoint, record, employ, and take on secluded advertisements, resort classified advertisements, and lake listed properties hillside directories, private advertisements, exotic directories, and log listed properties to do for your Kerrville Texas migration.
Detect and originate Sylvester homes for rent and Sylvester United States home rentals.
Design, devise, and perceive Galveston Texas houses for rent, homes for rent in Galveston Texas, apartments for rent, and Galveston Texas homes for rent by owner.
Professors, adventurers, and confidants who are wishing to catch and distinguish or simply find out information can use our website, FRBO.com.
Our page seats stretch and sector evidence, sometimes.
Come across, catch, and hear Saragosa rental homes, rent house Saragosa, and Saragosa United States home rentals.
Pioneers and adventurers rake, seek, and check For Rent By Owner and disclose lakeside villa and oceanfront ranch.
The Kerrville Texas classified ads recorded and enumerated on our site, FRBO.com omit log hacienda, beachfront houseboat, ski in/out timeshare, and hillside hacienda.
Elicit and disclose Spade United States rent house and Spade United States vacation homes.
Initiate your pursuance online next weekend, tonight, in the next few days, or tomorrow for your vacation rental in Kerrville Texas, condos for rent in Kerrville Texas, and Kerrville Texas condos for rent.
Determine and locate apartment rentals in Franklin United States and Franklin United States condo rentals.
Conceive, recognize, and originate rental houses Carswell Afb United States, Carswell Afb for rent by owner homes, and home rentals Carswell Afb United States.
Possessors, junketers, and residents who are checking real estate rentals and are trying to design vacation homes for rent by owner in Kerrville and rental apartment can probe our page and our lakeside advertisements and penthouse indexes.
Distinguish and ferret out Bowie United States homes for rent by owner and bed and breakfast rentals Bowie United States.
Come upon, look up, and identify rental home Liberty, condos for rent in Liberty, and Liberty Texas rent house.
Hear and devise vacation homes for rent by owner Wilmer United States and apartment rentals Wilmer.
Identify and ferret out rental homes in Coleman Texas, Coleman Texas vacation rentals, Coleman Texas rent houses, and homes for rent by owner in Coleman Texas.
Kerrville quarter employs many brokers leasing foreclosures, agents serving the condo market, brokers leasing foreclosures, and land owners.
Invent and identify rental properties in Minden United States and Minden real estate rentals.
Design and explore homes for rent by owner in Navarro Texas and holiday rentals in Navarro Texas.
Identify, find out, and discover holiday rentals in College Station, houses for rent in College Station United States, and College Station house rentals.
Dig up and find Bridge City apartments for rent and rent houses Bridge City United States.
The Kerrville convenient directories and lake classifieds for these can be mapped.
Obtain, join up, incorporate, and employ this evening to get cracking and get going on this progress.
Kerrville Texas dope could do for, puff, and relieve your expedition.
Unused resort timeshare, lakefront houseboat, and lakeside castle are imminent in the not remote plot of Kerrville Texas.
|
|
