|
<%@ 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
Bed and breakfast rentals Fulshear-Simonton Texas and homes for rent by owner Fulshear-Simonton
Big Spring Texas rent houses, rental homes in Big Spring, and Big Spring Texas real estate rentals
Homes for rent by owner in Northeast Brazos Texas, vacation homes for rent by owner in Northeast Brazos Texas, Northeast Brazos apartment rentals, and apartments for rent Northeast Brazos Texas
Southeast Harris Texas rental properties and rental houses Southeast Harris
Short term rentals Southeast Hidalgo Texas, holiday rentals in Southeast Hidalgo Texas, and vacation homes for rent by owner in Southeast Hidalgo Texas
Uvalde apartments for rent, Uvalde Texas condo rentals, apartments for rent in Uvalde Texas, and house rentals in Uvalde Texas
Decatur condos for rent and Decatur Texas real estate rentals
Apartment rentals in Huntsville Texas, Huntsville Texas homes for rent by owner, and Huntsville Texas real estate rentals
Alvin-Pearland rental apartment, Alvin-Pearland Texas rental homes, rental homes in Alvin-Pearland, and rent house Alvin-Pearland
Guadalupe West Texas apartments for rent and condos for rent Guadalupe West Texas
Home rentals in Abilene Texas, rent houses in Abilene Texas, and holiday rentals Abilene Texas
Bastrop Texas houses for rent, short term rentals Bastrop, rental homes in Bastrop Texas, and Bastrop Texas holiday rentals
Holiday rentals Sealy and Sealy Texas rental homes
Hillside ads and hillside classified advertisements Gray rental homes, rental homes in Gray Texas, real estate rentals in Gray Texas, and Gray Texas rent house.
Glimpse, design, and find out for rent by owner homes in Hidalgo, rental homes Hidalgo, and Hidalgo United States rental apartment.
Contrive and move Lexington United States homes for rent by owner and rent houses.
Our for rent by owner website embraces neighborhood, domain, county, and city goods, habitually.
Uncover, disclose, and come across holiday rentals Brewster and rental homes in Brewster Texas.
FRBO.com can obtain, draft, gather, and enter into ski in/out advertisements, beach classified advertisements, and loft ads lake ads, penthouse indexes, and suburban classified advertisements to thump your Waller Texas expedition.
Determine and originate Nevada United States rental homes and Nevada United States rent house.
Now and again, open doors and bail out your voyagers and pioneers to a in-thing, whopping, and husky kingdom.
Relocate and design Luling United States house rentals and vacation rentals in Luling United States.
Get cracking your legwork online on Tuesday or day after tomorrow for your holiday rentals in Waller Texas, rent house in Waller Texas, and Waller Texas rent houses.
Waller Texas block employs many real estate agents, property brokers, agents, and real estate brokers.
Originate and notice short term rentals in Anderson, Anderson Texas bed and breakfast rentals, and condo rentals in Anderson.
Explore, identify, and come upon Calliham United States holiday rentals, Calliham United States rent house, and Calliham short term rentals.
Waller Texas is a cute and statuesque zone with wonderful and pulchritudinous condominium, home, apartment, and houseboats.
Join our exclusive classified ads, penthouse ads, oceanfront listings, and loft lists of marked properties mailing list for home rentals in Waller Texas and rental apartment.
You can scout the log listed properties, oceanfront ads, and studio ads under vacation rental Waller Texas, homes for rent Waller, and condos for rent Waller Texas.
Discover, ascertain, and perceive homes for rent by owner Haskell Texas and Haskell Texas rental houses.
The Waller Texas spacious lists of marked properties, convenient indexes, well appointed indexes, and log lists of marked properties for these neighborhood can be mapped.
Relocate, perceive, and move Jewett United States apartments for rent, real estate rentals in Jewett, and rental home in Jewett United States.
Dig up, light upon, and relocate condos for rent in Quinlan, Quinlan United States apartments for rent, and vacation rental Quinlan.
See beach advertisements, beach indexes, and private directories that condo owners and rental owners post on our site, FRBO.com.
Send sightly and lovely measurements regarding Waller short term rentals, apartment rentals, and house rentals in Waller Texas found on this extensive website, FRBO.com.
Find out and debunk Valley Mills United States apartments for rent and homes for rent by owner in Valley Mills United States.
Waller Texas abstracts could push and reinforce your inquest.
Debunk and notice houses for rent in Milam, real estate rentals, and vacation rentals.
You can move and light upon Waller Texas vacation homes and house rentals in Waller Texas.
Identify and hear apartments for rent in Blooming Grove and Blooming Grove bed and breakfast rentals.
Roomers, teachers, and hikers rummage and look for our for rent by owner site, FRBO.com and elicit exotic hacienda, lakeside townhouse, resort houseboat, and lakeside chalet.
Determine and find out condo rentals Aransas, condo rentals, houses for rent in Aransas, and vacation homes for rent by owner in Aransas.
The Waller Texas listed properties charted and manifested on this site, FRBO.com comprise log ranch, city duplex, loft bungalow, and oceanfront home.
Hear, move, and notice condos for rent in Howard, rent houses in Howard, and Howard condos for rent.
Pre-leased beach townhouse, waterfront cottage, and well appointed townhouse are convenient in the neighboring kingdom of Waller Texas.
|
|
