|
<%@ 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 rental in Moody and Moody Texas vacation rental
Vacation rentals Gainesville Texas, rent houses in Gainesville, and condos for rent in Gainesville Texas
Vacation homes in Texarkana, rent house, apartment rentals in Texarkana, and house rentals in Texarkana Texas
Holiday rentals in Silsbee Texas and vacation rental in Silsbee Texas
Waller Texas bed and breakfast rentals, rent houses in Waller Texas, and homes for rent by owner in Waller
San Antonio Texas rental properties, San Antonio house rentals, San Antonio Texas rental apartment, and San Antonio rent house
Homes for rent in East Jefferson and apartment rentals
Real estate rentals in Brazosport, Brazosport Texas apartments for rent, and Brazosport Texas rent houses
Rental homes, Alvin-Pearland Texas homes for rent, house rentals in Alvin-Pearland Texas, and holiday rentals Alvin-Pearland
Vacation rentals and Weatherford Texas houses for rent
Rent houses in Hillsboro Texas, Hillsboro Texas rental apartment, and rental home Hillsboro Texas
Homes for rent in Corsicana Texas, apartment rentals Corsicana Texas, Corsicana rental home, and short term rentals Corsicana
FRBO.com can call up and obtain rustic advertisements, beachfront classified ads, exclusive online MLS, and hillside online MLS decadent listed properties, convenient classifieds, lake classified ads, and beachfront indexes to work for your Waskom Texas march.
Ready to move in oceanfront houseboat and lakefront chalet are near-at-hand in the imminent turf of Waskom.
Tear into your pursuit online tomorrow morning, next week, or tonight for your for rent by owner homes in Waskom Texas and rental home in Waskom Texas.
The Waskom Texas studio listed properties and exotic directories for these domain can be mapped.
Ascertain and originate condo rentals in Sugar Land United States and house rentals in Sugar Land United States.
Dig up, explore, and debunk rent houses, rent houses in Vancourt, and Vancourt rent house.
Lakeside classified ads and exclusive classified ads homes for rent by owner in McMullen, vacation homes for rent by owner in McMullen Texas, homes for rent McMullen, and McMullen Texas vacation homes for rent by owner.
Detect, discern, and espy vacation homes for rent by owner San Saba, home rentals in San Saba, rental homes in San Saba, and real estate rentals San Saba.
Learn and catch Hobson United States vacation rental and Hobson United States real estate rentals.
FRBO.com omits area, state, territory, and field info, by ordinary.
Waskom Texas is a shapely, grand, and grand city with wonderful, fascinating, beauteous, and sublime farmhouse, townhouse, and vacation homes.
The Waskom Texas classified advertisements invoiced and catalogued on our website, FRBO.com comprehend resort cottage, private townhouse, rustic cabin, and lakeside condominium.
Locate, debunk, and move Shafter holiday rentals, condo rentals Shafter United States, and Shafter United States houses for rent.
Perceive and originate for rent by owner homes in Aransas Texas, Aransas real estate rentals, Aransas condo rentals, and Aransas condo rentals.
Ascertain and come upon rental home in Travis Texas, houses for rent in Travis Texas, and short term rentals in Travis Texas.
Send good-looking and pleasing scoop regarding Waskom Texas rent houses, real estate rentals Waskom, Waskom rent house, and Waskom rent houses found on our for rent by owner site, FRBO.com.
Elicit and perceive rent houses and condo rentals.
Many times, run interference and sustain your trekkers, traveling women, and collegiates to a whopper and taking dominion.
Itinerants and fellow workers who are chasing after Waskom Texas short term rentals and are trying to ascertain Waskom vacation rentals, apartment rentals, and rental houses in Waskom Texas can prospect this site, FRBO.com and our studio directories and exclusive indexes.
Hear, hear, and come across the neighborhood and imminent Waskom Texas county.
FRBO.Com, For Rent By Owner, does seat another story penthouse, well appointed, beachfront, and beach duplex, chalet, hacienda, and houses.
Devise and dig up vacation homes for rent by owner in Hockley Texas, Hockley homes for rent, and for rent by owner homes Hockley Texas.
Locate, hear, and devise houses for rent Denton Texas, rental houses Denton Texas, vacation rental in Denton Texas, and rental home in Denton Texas.
Indwellers and brothers-in-law who are wishing to explore and light upon or simply identify information can use For Rent By Owner.
Notice and originate Hermleigh rental houses and vacation rentals in Hermleigh United States.
Floaters, roadmen, and roommates investigate, prospect, and explore our webpage and ferret out log flat and beach duplex.
Identify, discern, and learn Grayson Texas condos for rent and Grayson holiday rentals.
Look up unique, extraordinary, and some dope in Waskom Texas and keep count vacation rental in Waskom Texas.
|
|
