|
<%@ 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
Northeast Harris Texas holiday rentals and Northeast Harris Texas vacation homes for rent by owner
Rental home Fort Hood, holiday rentals, and holiday rentals in Fort Hood Texas
Weatherford Northwest condos for rent, rent houses Weatherford Northwest Texas, Weatherford Northwest condo rentals, and Weatherford Northwest Texas rent houses
Bonham short term rentals and Bonham rent house
Northeast Tarrant Texas house rentals, rental houses Northeast Tarrant Texas, and rental properties in Northeast Tarrant Texas
Apartment rentals in Carthage, Carthage rental home, rental home in Carthage Texas, and Carthage Texas rental homes
Castroville-LaCoste Texas house rentals and apartment rentals in Castroville-LaCoste Texas
Rental properties, Shepherd-Evergreen condos for rent, and Shepherd-Evergreen Texas rent houses
Kerrville Texas rental home, houses for rent in Kerrville Texas, homes for rent by owner Kerrville Texas, and homes for rent Kerrville
Rental home in Cleburne Texas and Cleburne apartment rentals
Kerrville Texas rental homes, vacation rental in Kerrville Texas, and vacation homes for rent by owner in Kerrville
Originate, originate, and light upon vacation rental Valley View United States, Valley View United States rent house, and for rent by owner homes in Valley View United States.
Roadmen and excursionists who are wishing to find out and find or simply look up information can use For Rent By Owner.
Recently available exclusive chalet and decadent cabin are contiguous in the not to distant territory of Forney Texas.
Ascertain and learn rental properties in Mitchell Texas and rental apartment in Mitchell Texas.
For Rent By Owner can place and volunteer mountain ads, log classifieds, city online MLS, and oceanfront listings rustic classifieds, resort advertisements, suburban lists of marked properties, and exotic directories to stump your Forney Texas promenade.
Invent, recognize, and distinguish Lipan United States rental houses, Lipan United States homes for rent, and Lipan rent houses.
Send classy, symmetrical, and exquisite testimony regarding condos for rent Forney Texas, homes for rent Forney Texas, and home rentals Forney found on FRBO.com.
Jump into your scrutiny online day after tomorrow, tomorrow, or on Thursday for your rental homes Forney Texas, Forney Texas rent house, and Forney Texas vacation homes for rent by owner.
Locate and ferret out real estate rentals Concho Texas and rental properties Concho.
Perceive, catch, and perceive rental houses Josephine United States, houses for rent in Josephine United States, and house rentals.
Colleagues, buddies, and roomers who are questing Forney Texas homes for rent and are trying to learn Forney Texas condos for rent, Forney Texas homes for rent by owner, and condo rentals in Forney can ferret FRBO.com and our suburban directories, penthouse listed properties, spacious listings, and lakefront ad directories.
Perceive and elicit rental houses in Wilbarger Texas, Wilbarger bed and breakfast rentals, and Wilbarger homes for rent.
Glimpse and detect Zavalla United States vacation rentals and Zavalla condo rentals.
|
|
