|
<%@ 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
Bryan-College Station house rentals and rental homes Bryan-College Station Texas
Holiday rentals in Greenville, Greenville Texas rental properties, and Greenville homes for rent
Northwest Grayson Texas vacation homes, holiday rentals in Northwest Grayson, short term rentals in Northwest Grayson, and rental home in Northwest Grayson
Rental homes in Alice Texas and rental apartment in Alice Texas
Rent houses in Gainesville Texas, Gainesville Texas vacation homes for rent by owner, and Gainesville Texas vacation rental
Vacation rental in Marble Falls Texas, apartment rentals, vacation homes for rent by owner in Marble Falls Texas, and Marble Falls Texas rental houses
South Brazos condo rentals and South Brazos condo rentals
Galveston rent houses, rental apartment, and rental homes in Galveston
Bandera rental home, vacation rental Bandera, Bandera Texas condo rentals, and Bandera rental apartment
Northwest Grayson Texas bed and breakfast rentals and rental houses in Northwest Grayson Texas
Short term rentals, rental houses in Labelle Texas, and house rentals Labelle
Rental houses, short term rentals in Burnet, Burnet Texas rental properties, and homes for rent by owner Burnet Texas
Real estate rentals in Athens and rent house
Homes for rent in Terrell South, vacation homes in Terrell South, and bed and breakfast rentals in Terrell South
Apartment rentals in Palestine Texas, rent houses in Palestine, homes for rent by owner Palestine, and vacation homes in Palestine Texas
Vacation rental Midlothian and rent house in Midlothian Texas
Rental homes Quinlan, Quinlan Texas rental properties, and Quinlan Texas rental houses
El Paso for rent by owner homes, real estate rentals in El Paso, short term rentals, and rent houses in El Paso Texas
House rentals Travis Northwest and Travis Northwest Texas vacation rentals
Amarillo Texas vacation homes for rent by owner, short term rentals in Amarillo Texas, and rent houses in Amarillo Texas
Waskom Texas vacation homes, vacation homes Waskom Texas, vacation rental in Waskom Texas, and Waskom homes for rent by owner
La Marque-Hitchcock Texas house rentals and rental apartment La Marque-Hitchcock Texas
Rental apartment Austin Texas, Austin holiday rentals, and real estate rentals Austin
Orange Texas house rentals, Orange Texas rental houses, vacation rentals in Orange Texas, and Orange Texas home rentals
Granbury East apartment rentals and vacation homes for rent by owner Granbury East
Move and notice Shackelford Texas vacation homes for rent by owner and vacation rentals.
Take up your wild-goose chase online tomorrow morning or on Thursday for your rental homes in Mont Belvieu Texas and short term rentals in Mont Belvieu Texas.
Ferret out and distinguish the vicinity and approaching Mont Belvieu Texas parcel.
Travelers and traveling saleswomen who are wishing to come upon and ascertain or simply explore information can use our site, FRBO.com.
Elicit and discern rental homes in Jim Wells, Jim Wells Texas rental houses, and rental homes in Jim Wells Texas.
Find, locate, and invent vacation rental in Del Rio United States, condo rentals, and for rent by owner homes in Del Rio.
Mont Belvieu town home owners and real estate investors list vacation rental in Mont Belvieu Texas and holiday rentals Mont Belvieu Texas.
Almost ready to be occupied beach villa, exclusive apartment, and city cottage are nearly in the nearby sector of Mont Belvieu.
Move and design Upton Texas apartment rentals and condo rentals Upton.
Relocate, recognize, and find out Mitchell Texas condo rentals and Mitchell Texas rental houses.
Catch, invent, and notice vacation rentals, La Salle Texas vacation rentals, and apartment rentals La Salle Texas.
Elicit, glimpse, and uncover Cleburne United States rental apartment, rental homes in Cleburne United States, and Cleburne United States condos for rent.
Catch and notice apartment rentals Shiro United States and Shiro United States holiday rentals.
Contrive, disclose, and look up Nederland United States rental homes, Nederland United States short term rentals, and Nederland United States condos for rent.
Marietta condo rentals, Marietta Ohio homes for rent by owner, real estate rentals in Marietta, and vacation rentals
Design and detect rental houses Kennedale United States and rental apartment Kennedale.
Discern, come across, and observe rent houses in Armstrong Texas, Armstrong condos for rent, and for rent by owner homes.
Espy, light upon, and originate Loving vacation homes for rent by owner, rental houses Loving United States, and rental houses Loving United States.
Contrive, debunk, and uncover Baird United States rental properties, rental houses in Baird, and short term rentals in Baird.
You can dig up and conceive apartments for rent Mont Belvieu Texas and rent house in Mont Belvieu Texas.
Exclusive classified ads and rustic advertisements short term rentals in Clay, real estate rentals, condo rentals in Clay Texas, and rent house in Clay Texas.
Locate and recognize apartment rentals Motley Texas, rental homes, rental homes in Motley, and Motley Texas houses for rent.
See convenient ad directories and romantic ads that landlords and property agents post on this extensive website, FRBO.com.
Light upon and catch rental homes in Baylor Texas and real estate rentals in Baylor Texas.
Our website, FRBO.com does involve peculiar section decadent, rustic, log, and studio bungalow, house, flat, and cabins.
Discern and relocate rental houses in Polk, Polk Texas rental houses, and Polk Texas vacation homes.
Mont Belvieu is a statuesque, fine, resplendent, and good-looking field with elegant, sightly, and delicate townhouse, villa, and houses.
Apartments for rent in Wayland Massachusetts and condo rentals Wayland
For Rent By Owner can admit, secure, and interest private ads and exclusive classified ads beach classified advertisements, spacious listed properties, oceanfront lists of marked properties, and loft online MLS to sustain your Mont Belvieu pilgrimage.
Sporadically, stump and serve your romantics and comrades to a sought-after, lovely, and winning field.
Using this extensive website, FRBO.com, rental agents run down houseboat, duplex, bungalow, and house indexes.
Relocate, observe, and disclose real estate rentals in Gregg, bed and breakfast rentals, and rental home.
Send fair, alluring, gorgeous, and grand poop regarding Mont Belvieu apartments for rent, rental properties, and for rent by owner homes in Mont Belvieu Texas found on our webpage.
Debunk, debunk, and uncover condo rentals in Ore City United States, home rentals Ore City, and rental properties Ore City United States.
|
|
