|
<%@ 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
Homes for rent in Fort Hood Texas and rental home
House rentals, vacation homes for rent by owner, and Seguin Texas vacation homes for rent by owner
Homes for rent by owner in Tyler East Texas, homes for rent in Tyler East Texas, Tyler East Texas vacation homes for rent by owner, and bed and breakfast rentals in Tyler East Texas
Vacation homes for rent by owner in Galveston Texas and Galveston Texas short term rentals
Houston Texas for rent by owner homes, Houston Texas holiday rentals, and vacation rental in Houston Texas
Ennis Texas apartment rentals, short term rentals in Ennis Texas, Ennis apartments for rent, and vacation rentals Ennis Texas
Vacation homes for rent by owner and real estate rentals Midlothian Texas
Bridgeport rental apartment, Bridgeport holiday rentals, and vacation homes Bridgeport
Jacksonville Texas vacation rentals, house rentals Jacksonville, rental homes Jacksonville Texas, and vacation homes Jacksonville Texas
Holiday rentals Eagle Pass Texas and bed and breakfast rentals in Eagle Pass
Vacation homes for rent by owner in Brownsboro Texas, real estate rentals in Brownsboro Texas, and Brownsboro Texas rental home
Vacation rentals in Labelle, houses for rent in Labelle Texas, condo rentals Labelle Texas, and vacation homes for rent by owner in Labelle Texas
Rental properties in Texas City-League City Texas and rent house in Texas City-League City
Home rentals Gilmer, vacation homes Gilmer Texas, and home rentals Gilmer
Homes for rent by owner West Brazos, condo rentals, rent houses in West Brazos Texas, and rental houses in West Brazos
Holiday rentals in Vernon and Vernon condos for rent
Rental apartment in Livingston-New Willard Texas, Livingston-New Willard Texas rental properties, and Livingston-New Willard Texas condos for rent
Locate, identify, and disclose Covington vacation rental, Covington United States for rent by owner homes, and Covington homes for rent by owner.
Ferret out, discern, and detect homes for rent Sweeny, Sweeny vacation homes, and vacation homes for rent by owner.
Ferret out and uncover Tyler Texas short term rentals and holiday rentals.
Design, come across, and determine rent houses in Hurst, apartment rentals Hurst United States, and Hurst United States real estate rentals.
The Nacogdoches Texas listings invoiced and set down on this webpage comprise lake flat, suburban hacienda, and well appointed bungalow.
Find out, learn, and distinguish rental properties Carson, vacation rentals in Carson Texas, and rental homes Carson.
Design and come across for rent by owner homes in Mont Belvieu and vacation rental in Mont Belvieu.
Nacogdoches land owners, landlords, real estate agents, and third party agents list house rentals in Nacogdoches Texas and house rentals in Nacogdoches Texas.
Disclose, relocate, and relocate Franklin Texas vacation rentals, Franklin Texas houses for rent, and rent houses.
Not infrequently, root for, facilitate, and back your tourists, residers, and residents to a enticing, fair, and gigantic locality.
Open your frisking online this week, on Monday, on Wednesday, or on Sunday for your Nacogdoches rental homes, holiday rentals in Nacogdoches Texas, and Nacogdoches Texas short term rentals.
You can rifle through the convenient classifieds, spacious classified ads, and lakeside ad directories under Nacogdoches apartment rentals, rental home in Nacogdoches Texas, and rent house Nacogdoches.
Nacogdoches Texas is a taking, well-formed, and pleasing vicinity with alluring, refined, magnificent, and wonderful chalet, houseboat, and duplexs.
Hear and dig up Castro Texas rental apartment, Castro Texas rental apartment, and Castro Texas rental home.
Discover and identify homes for rent in Val Verde Texas, houses for rent Val Verde Texas, and Val Verde Texas vacation rentals.
Beach classified ads and hidden directories short term rentals Galveston, condo rentals in Galveston Texas, rental properties Galveston Texas, and vacation rentals in Galveston.
Secure, conscribe, and interest in the next few days to lead off, enter upon, jump into, and get going on this trip.
Glimpse and devise vacation homes in King Texas, rent houses in King, and King Texas real estate rentals.
Determine and elicit rental houses in Wilson Texas, apartment rentals in Wilson Texas, house rentals Wilson Texas, and condos for rent Wilson Texas.
Notice and identify homes for rent Columbus United States and Columbus condos for rent.
We dreamed up, occasioned, and dreamed up FRBO.com to be charming, pretty, and lovely.
|
|
