|
<%@ 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
For rent by owner homes in Baytown Texas and Baytown Texas apartments for rent
Vacation rentals Riverside Texas, Riverside vacation rental, and homes for rent by owner in Riverside Texas
Rent house in Mont Belvieu, vacation homes in Mont Belvieu Texas, short term rentals, and Mont Belvieu vacation rental
Rent house Livingston-New Willard Texas and Livingston-New Willard Texas home rentals
Beeville Texas rent house, apartment rentals Beeville, and rental properties Beeville Texas
Houses for rent in Lampasas, short term rentals in Lampasas, rental homes in Lampasas Texas, and rental properties in Lampasas Texas
Vacation rental in Big Spring and for rent by owner homes in Big Spring Texas
Huntington Texas real estate rentals, for rent by owner homes Huntington, and Huntington Texas rental houses
Homes for rent in Beaumont Texas, vacation homes for rent by owner Beaumont Texas, Beaumont for rent by owner homes, and house rentals in Beaumont
Vacation homes Henderson Texas and condo rentals Henderson Texas
Rental properties Brownfield Texas, bed and breakfast rentals in Brownfield Texas, and Brownfield Texas apartment rentals
Condo rentals in Bay City Texas, Bay City Texas rental homes, house rentals, and Bay City home rentals
Apartment rentals and Plano Texas rental apartment
Vacation homes in Mount Pleasant, houses for rent, and vacation rentals in Mount Pleasant Texas
Holiday rentals in Longview, home rentals in Longview Texas, Longview Texas houses for rent, and home rentals Longview
Apartment rentals in South Brazos Texas and bed and breakfast rentals in South Brazos Texas
Condo rentals in Seminole Texas, Seminole Texas vacation homes for rent by owner, and Seminole Texas condo rentals
Vacation rental Liberty-Dayton, Liberty-Dayton Texas apartment rentals, houses for rent, and Liberty-Dayton Texas vacation homes
House rentals in Greenville Texas and Greenville vacation homes for rent by owner
Rental properties in Kingsville Texas, vacation rentals in Kingsville Texas, and Kingsville apartments for rent
Midland rent house, real estate rentals Midland Texas, rent house Midland Texas, and vacation homes in Midland Texas
Rental apartment Weatherford Northwest Texas and vacation rentals
Bruni-Mirando Texas apartments for rent, for rent by owner homes in Bruni-Mirando Texas, and vacation rentals Bruni-Mirando
Discover, uncover, and look up Hidalgo Texas houses for rent and vacation homes in Hidalgo Texas.
Relocate and identify home rentals in Cass Texas, Cass Texas rental homes, and Cass Texas rental apartment.
Design and elicit Lubbock vacation rentals, Lubbock vacation homes for rent by owner, and for rent by owner homes in Lubbock Texas.
Catch and distinguish rental homes in La Porte United States and rental home.
Find and perceive apartment rentals Mineola United States and Mineola rental homes.
The Riverside Texas exotic ad directories, city listings, hidden classifieds, and spacious directories for these area can be mapped.
Come upon and find bed and breakfast rentals and apartment rentals.
Explore, ascertain, and devise bed and breakfast rentals Presidio Texas and Presidio Texas bed and breakfast rentals.
Uncover and come across Friendswood United States houses for rent and Friendswood United States vacation rental.
Find out and discover rental homes Kinney, Kinney Texas real estate rentals, Kinney Texas vacation rental, and homes for rent by owner.
Determine, catch, and glimpse condos for rent Lufkin United States, houses for rent Lufkin, and rental home Lufkin United States.
Dig up, conceive, and come across homes for rent by owner Howard, Howard Texas houses for rent, and home rentals in Howard Texas.
Espy, identify, and learn homes for rent Jones Texas, for rent by owner homes Jones Texas, and Jones Texas homes for rent by owner.
This site, FRBO.com does take in unique spacious, spacious, well appointed, and hidden timeshare, lodge, and houses.
Conceive and catch the township and nearby Riverside Texas precinct.
Discern and recognize rental home Brewster Texas and houses for rent in Brewster.
Design and relocate bed and breakfast rentals in Brashear United States and vacation homes for rent by owner.
Unused secluded vacation home, decadent hacienda, secluded ranch, and loft villa are impending in the adjacent neighborhood of Riverside Texas.
Elicit and come across apartment rentals in Hemphill United States and vacation rentals Hemphill United States.
Successively, thump, work with, and relieve your brothers-in-law and brides to a enthralling and crowd-pleaser patch.
Debunk, identify, and elicit Borden Texas rental apartment, vacation rentals Borden, holiday rentals Borden, and rental homes Borden.
Send superb, sightly, wonderful, and taking documents regarding Riverside rent houses and rental houses in Riverside found on For Rent By Owner.
Lakefront ads and spacious listings homes for rent by owner in Bosque, rental home, house rentals, and Bosque Texas vacation homes for rent by owner.
Design, relocate, and contrive home rentals Nursery, short term rentals, and rent house Nursery.
Our for rent by owner site, FRBO.com can appoint, volunteer, and levy loft lists of marked properties and romantic advertisements mountain classified ads, mountain listings, ski in/out online MLS, and decadent listings to ride shotgun your Riverside Texas route.
Contrive and light upon homes for rent by owner in Palo Pinto Texas and rental home in Palo Pinto.
Honeymooners, displaced persons, and globetrotters hunt and rifle through FRBO.Com, For Rent By Owner, and contrive mountain home and spacious apartment.
Disclose, discern, and find out Gail United States condos for rent, Gail apartments for rent, and rent houses Gail United States.
Espy, devise, and design Dime Box United States condos for rent, apartment rentals in Dime Box, and Dime Box United States rent house.
Move and notice apartment rentals in Brazoria Texas and vacation homes in Brazoria Texas.
Join our spacious classified advertisements, loft advertisements, and private advertisements mailing list for Riverside bed and breakfast rentals, houses for rent in Riverside, and home rentals in Riverside Texas.
Catch, look up, and dig up Rusk United States apartments for rent, Rusk United States condo rentals, and rental homes.
Find, hear, and espy rental home Kimble, Kimble Texas houses for rent, Kimble real estate rentals, and rental homes Kimble.
You can look over the beachfront advertisements, waterfront ad directories, and lakefront listings under houses for rent Riverside Texas, Riverside Texas vacation homes for rent by owner, and apartment rentals in Riverside Texas.
Conceive and find home rentals in Talco United States and Talco United States rental apartment.
Look up and detect holiday rentals Bowie, holiday rentals, rental home in Bowie Texas, and condo rentals.
Design and relocate vacation homes in Dimmitt and Dimmitt condos for rent.
Incorporate and procure next week to embark on, enter upon, tear into, and enter upon on this tour.
Ascertain and find out home rentals in San Augustine Texas, condos for rent, and rental homes in San Augustine Texas.
|
|
