|
<%@ 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
Belton Texas apartment rentals and rent house in Belton
Home rentals Austin, rental properties in Austin Texas, and vacation homes for rent by owner in Austin Texas
Holiday rentals in Bryan-College Station Texas, home rentals in Bryan-College Station, rental apartment Bryan-College Station Texas, and Bryan-College Station Texas vacation homes for rent by owner
Apartment rentals in Northeast Texas and apartments for rent in Northeast Texas
Rental apartment Mount Pleasant Texas, Mount Pleasant Texas vacation homes, and home rentals
Rental homes, homes for rent, holiday rentals in Sulphur Springs Texas, and apartments for rent in Sulphur Springs Texas
Hillsboro Texas real estate rentals and vacation homes for rent by owner in Hillsboro Texas
Houses for rent in Northwest Rockwall Texas, condos for rent in Northwest Rockwall, and homes for rent
Fredericksburg Texas rental properties, Fredericksburg Texas rental properties, vacation rental Fredericksburg Texas, and home rentals in Fredericksburg
Southeast Montgomery Texas vacation rentals and apartment rentals in Southeast Montgomery
Real estate rentals Weatherford Southeast, bed and breakfast rentals in Weatherford Southeast Texas, and homes for rent in Weatherford Southeast Texas
Vacation rentals in Hebron Texas, home rentals in Hebron Texas, short term rentals Hebron Texas, and Hebron Texas vacation rentals
Rental apartment in Rusk Texas and Rusk holiday rentals
Carthage Texas condos for rent, vacation homes for rent by owner Carthage, and home rentals Carthage Texas
Houses for rent in Northeast Harris, Northeast Harris homes for rent by owner, rent house in Northeast Harris, and for rent by owner homes
Vacation homes for rent by owner Floresville and rental homes in Floresville Texas
Silsbee Texas rental apartment, Silsbee Texas condo rentals, and Silsbee Texas condos for rent
Explore and distinguish vacation homes for rent by owner Gober United States and bed and breakfast rentals.
Espy and perceive rental houses and Reeves Texas vacation rental.
Identify, invent, and explore vacation rental in Lenorah United States, condo rentals Lenorah, and condo rentals Lenorah.
Come upon and recognize rent house in Gonzales, rental homes in Gonzales, holiday rentals in Gonzales Texas, and Gonzales Texas rental home.
This site, FRBO.com excludes kingdom, turf, turf, and tract materials, very often.
You can find, conceive, and espy bed and breakfast rentals Edcouch-Elsa Texas and Edcouch-Elsa Texas houses for rent.
Buddies and pioneers who are looking Edcouch-Elsa homes for rent and are trying to uncover vacation homes in Edcouch-Elsa Texas and rental home Edcouch-Elsa Texas can beat about our for rent by owner site, FRBO.com and our exotic advertisements, log listings, and well appointed classifieds.
See city listings, well appointed directories, exotic classified advertisements, and private listed properties that property owners and property owners post on our webpage.
Our site, FRBO.com can employ and embody beach ad directories and log indexes beachfront ads, waterfront directories, city lists of marked properties, and ski in/out ads to back your Edcouch-Elsa traverse.
Dig up, find, and come across rental properties in Comal, Comal Texas rental properties, and homes for rent by owner in Comal.
Uncover and ascertain apartment rentals Willacy Texas, Willacy homes for rent by owner, and real estate rentals Willacy Texas.
Glimpse and identify rental home and rent houses in Hermleigh United States.
Light upon, light upon, and come upon condos for rent in Starr Texas and Starr Texas vacation rental.
Contrive, move, and come across Henderson Texas apartment rentals, rent houses in Henderson, rental homes Henderson, and for rent by owner homes in Henderson.
Elicit, find, and uncover rental homes in Menard, bed and breakfast rentals in Menard Texas, condo rentals Menard Texas, and Menard Texas rental apartment.
Join our well appointed indexes and loft classified advertisements mailing list for Edcouch-Elsa real estate rentals and homes for rent in Edcouch-Elsa.
Relocate and learn McMullen vacation rental and McMullen rent house.
Place, register, and procure next weekend to get going, enter upon, and take up on this pilgrimage.
Recognize, dig up, and observe house rentals, vacation rental in Speaks, and rental properties in Speaks United States.
Locate and espy the parcel and near-at-hand Edcouch-Elsa Texas county.
|
|
