|
<%@ 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
Vacation homes for rent by owner and vacation homes for rent by owner Shepherd-Evergreen
Rent houses, Sanger bed and breakfast rentals, and rental home
Houses for rent in Stephenville Texas, Stephenville Texas rental homes, Stephenville Texas rental houses, and home rentals
Orange Texas homes for rent and apartment rentals in Orange
Apartments for rent in Northwest Grayson, homes for rent in Northwest Grayson Texas, and real estate rentals in Northwest Grayson Texas
Condo rentals in Bryan-College Station Texas, Bryan-College Station condos for rent, rental houses, and Bryan-College Station Texas houses for rent
Willis Texas vacation homes and Willis Texas apartments for rent
Real estate rentals, vacation rentals Goldsmith-Penwell Texas, and vacation homes for rent by owner in Goldsmith-Penwell Texas
Vacation rentals in Dripping Springs-Wimberley Texas, rental home, Dripping Springs-Wimberley Texas rent house, and Dripping Springs-Wimberley vacation homes for rent by owner
Rent house in Arlington Texas and rental home in Arlington Texas
Rental homes in Zapata, real estate rentals, and condo rentals in Zapata Texas
Oftentimes, plug, serve, and boost your roommates and indwellers to a oversize and fat dominion.
Secluded ads and romantic indexes holiday rentals, home rentals San Jacinto, condo rentals San Jacinto Texas, and rental home San Jacinto Texas.
Send superb, elegant, and ideal dope regarding rent houses in Kingsville Texas, Kingsville Texas houses for rent, Kingsville Texas home rentals, and rental apartment Kingsville Texas found on our page.
Light upon and identify condos for rent Zavala Texas, homes for rent by owner, and bed and breakfast rentals in Zavala Texas.
Learn, move, and discover Willis United States condo rentals, condo rentals Willis, and vacation rental Willis United States.
Relocate, hear, and invent Red Oak rental home, rental homes Red Oak United States, and rental homes Red Oak United States.
Ferret out and ferret out homes for rent Leonard and home rentals in Leonard United States.
Uncover and locate real estate rentals in Zapata Texas and apartments for rent in Zapata Texas.
Relocate and invent houses for rent, Eastland real estate rentals, rental home, and vacation homes in Eastland.
We planned and started our for rent by owner site, FRBO.com to be fair and enticing.
Kingsville is a grand and refined state with splendid, marvelous, stunning, and comely cabin and townhouses.
Find and come upon apartments for rent Valley View United States and rental apartment Valley View United States.
Identify other and startling measurements in Kingsville and manifest vacation homes in Kingsville Texas.
The Kingsville Texas lists of marked properties census and placed on FRBO.com embrace oceanfront chalet, lakefront bungalow, rustic castle, and lake house.
Come upon and look up vacation homes for rent by owner and Price United States homes for rent by owner.
Light upon, observe, and identify vacation homes in Hamilton, apartment rentals in Hamilton Texas, and apartment rentals in Hamilton.
Glimpse and identify rental properties in Mitchell Texas and rental houses Mitchell.
Locate, conceive, and come upon Lytle homes for rent by owner, vacation homes in Lytle, and Lytle United States homes for rent.
Discern, distinguish, and invent rent houses in Clay Texas, homes for rent Clay, and condos for rent in Clay.
|
|
