|
<%@ 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
Rental homes Killeen and bed and breakfast rentals in Killeen Texas
Condos for rent, Cedar Creek-Red Rock Texas for rent by owner homes, and Cedar Creek-Red Rock Texas vacation homes for rent by owner
Stephenville Texas rent houses, home rentals Stephenville Texas, Stephenville vacation homes, and home rentals in Stephenville Texas
Apartment rentals in Borger and Borger Texas real estate rentals
Rent house in Pittsburg Texas, rental homes Pittsburg, and vacation rental in Pittsburg Texas
Holiday rentals in Alvin-Pearland Texas, Alvin-Pearland Texas apartments for rent, rental homes in Alvin-Pearland Texas, and apartments for rent in Alvin-Pearland Texas
Belton Texas house rentals and vacation rentals Belton
Vacation homes in Northeast Harris Texas, condo rentals in Northeast Harris, and vacation rentals Northeast Harris
Vacation rental in Southwest, Southwest rental apartment, rent house Southwest, and Southwest Texas real estate rentals
Real estate rentals in Athens Texas and vacation rental Athens Texas
Holiday rentals in Northwest Harris Texas, houses for rent Northwest Harris, and Northwest Harris Texas rent house
Corpus Christi vacation rentals, Corpus Christi Texas rental homes, house rentals in Corpus Christi Texas, and home rentals in Corpus Christi Texas
Hondo Texas vacation homes and rental homes
West Tom Green Texas real estate rentals, West Tom Green rental homes, and rental home in West Tom Green Texas
Gainesville Texas rental houses, vacation homes in Gainesville, vacation rental in Gainesville Texas, and Gainesville Texas condo rentals
Apartments for rent South Brazos Texas and South Brazos Texas condos for rent
Brownsville Texas vacation homes for rent by owner, apartments for rent in Brownsville Texas, and apartment rentals
Home rentals, condo rentals Temple Texas, condo rentals in Temple Texas, and real estate rentals
Northwest Rockwall Texas vacation rentals and rent house
Rent houses in Tyler East Texas, holiday rentals in Tyler East, and condos for rent
Home rentals in Corpus Christi West Texas, vacation homes Corpus Christi West Texas, house rentals in Corpus Christi West Texas, and rent house Corpus Christi West
Liberty-Dayton Texas apartments for rent and Liberty-Dayton Texas homes for rent
Rental houses Gainesville Texas, Gainesville Texas houses for rent, and Gainesville Texas homes for rent by owner
Sullivan City Texas homes for rent, vacation rentals Sullivan City, bed and breakfast rentals, and apartments for rent in Sullivan City Texas
Elicit, locate, and find out Manor United States apartment rentals, Manor United States vacation homes for rent by owner, and Manor United States homes for rent by owner.
Notice, locate, and learn the principality and contiguous Marshall Texas tract.
Find, ascertain, and light upon Van Zandt Texas rental home, houses for rent in Van Zandt, and short term rentals.
Recognize and hear Falls City United States condos for rent and homes for rent in Falls City United States.
Pioneers, wanderers, and better halves hunt for and shake down this site, FRBO.com and locate beach lodge, studio villa, and private chalet.
Identify, notice, and discern short term rentals Lueders United States, rental apartment Lueders, and homes for rent Lueders.
Locate and distinguish homes for rent Hood and rental home in Hood.
Loft advertisements and ski in/out online MLS rental properties in Jackson Texas, rent house Jackson, home rentals Jackson, and real estate rentals in Jackson Texas.
Hear and contrive rental homes in Chambers, Chambers Texas home rentals, and short term rentals.
The Marshall advertisements run down and tallied on FRBO.com incorporate waterfront cottage and city bungalow.
Perceive, perceive, and detect rental home Mills, Mills homes for rent by owner, and Mills Texas homes for rent.
Devise and originate Shamrock rental homes and Shamrock United States short term rentals.
Explore and contrive rent house Driftwood and rental home Driftwood.
Identify and conceive condo rentals, Sutton houses for rent, and short term rentals.
Elicit and relocate condos for rent in Stephens Texas, real estate rentals in Stephens Texas, Stephens bed and breakfast rentals, and rent houses Stephens.
Catch, distinguish, and elicit Coryell Texas vacation homes for rent by owner and Coryell Texas vacation homes.
Design, ascertain, and identify for rent by owner homes in Baylor Texas and Baylor Texas apartment rentals.
See penthouse classified advertisements, exclusive listed properties, convenient directories, and spacious classifieds that landlords and real estate agents post on For Rent By Owner.
Marshall Texas parcel employs many rental property owners, land owners, land owners, and condo owners.
This site, For Rent By Owner (FRBO.com) holds plot and tract results, by ordinary.
Locate, move, and elicit Girard United States condo rentals, apartment rentals in Girard United States, and Girard real estate rentals.
Successively, further, benefit, and sustain your schoolmates, inhabitants, and troupers to a mungo, crowd-pleaser, sought-after, and pleasing city.
Marshall condo owners, landlords, condo owners, and home owners list Marshall Texas rental apartment, rental properties in Marshall, and homes for rent in Marshall Texas.
|
|
