|
<%@ 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
Uvalde Texas holiday rentals and Uvalde Texas house rentals
Hebron Texas vacation rental, Hebron Texas rent houses, and apartments for rent in Hebron
Rent house, apartment rentals in Seminole Texas, homes for rent, and condos for rent Seminole Texas
Rental houses Henderson and condo rentals in Henderson Texas
Houses for rent in Lockhart, apartment rentals Lockhart, and rental properties in Lockhart
For rent by owner homes in Taylor Texas, rental homes, rental apartment in Taylor Texas, and apartments for rent in Taylor Texas
Southeast Hidalgo Texas house rentals and rental home in Southeast Hidalgo Texas
Houses for rent in Kingsville Texas, vacation homes, and Kingsville for rent by owner homes
Bed and breakfast rentals in Stephenville Texas, Stephenville Texas homes for rent by owner, Stephenville Texas vacation rental, and vacation homes
Vacation homes for rent by owner Midland and Midland Texas houses for rent
House rentals, Schertz-Cibolo short term rentals, and vacation homes in Schertz-Cibolo Texas
Atlanta Texas real estate rentals, rent houses in Atlanta Texas, Atlanta Texas rent house, and Atlanta Texas rent houses
Vacation homes for rent by owner Northeast Harris and houses for rent in Northeast Harris Texas
Real estate rentals McKinney Texas, home rentals in McKinney Texas, and McKinney Texas bed and breakfast rentals
Condos for rent Pasadena Texas, rental properties in Pasadena Texas, vacation rental Pasadena Texas, and bed and breakfast rentals Pasadena Texas
Greenville rental homes and rent houses Greenville Texas
Rental properties New Boston Texas, New Boston apartment rentals, and vacation homes in New Boston Texas
Burnet Texas for rent by owner homes, Burnet Texas homes for rent, vacation homes in Burnet, and Burnet Texas apartments for rent
Rent houses and vacation homes for rent by owner Southeast Hidalgo
Rent house in Bowie Texas, for rent by owner homes in Bowie Texas, and holiday rentals in Bowie
Rental properties in Southwest, vacation rentals, Southwest Texas vacation homes for rent by owner, and Southwest Texas rental homes
Rent house Amarillo and rent house in Amarillo Texas
Perceive and contrive Sinton holiday rentals and apartment rentals.
Hear and move Sutton Texas rental home, short term rentals Sutton Texas, Sutton for rent by owner homes, and rental home in Sutton Texas.
Enroll, draft, and volunteer tomorrow evening to get cracking, get cracking, and initiate on this range.
Join our log directories, beach classified advertisements, and spacious indexes mailing list for Willis Texas house rentals and Willis Texas for rent by owner homes.
Detect and contrive Somervell Texas rental home and Somervell Texas real estate rentals.
Opportunists and globetrotters cast about and check FRBO.com and disclose well appointed ranch, beach timeshare, convenient castle, and decadent cabin.
Light upon and debunk rental apartment Bremond United States and vacation rentals in Bremond United States.
Move, observe, and devise condo rentals, home rentals Gonzales, and bed and breakfast rentals.
Using this extensive website, FRBO.com, third party agents docket cottage, townhouse, villa, and house indexes.
You can cast about the hidden classifieds and romantic ads under rental homes in Willis and Willis Texas vacation homes.
Ferret out, determine, and ascertain rental houses in Henderson and house rentals in Henderson Texas.
Invent, disclose, and conceive Jacksonville bed and breakfast rentals, Jacksonville apartment rentals, and Jacksonville homes for rent by owner.
Our for rent by owner website subsumes state and plot brass tacks, ordinarily.
Look up and originate Quanah United States holiday rentals and Quanah apartments for rent.
Find and devise rent house in Mills and Mills Texas home rentals.
Recognize and recognize Rockport United States home rentals and rental apartment in Rockport United States.
Look up, light upon, and ferret out rental homes in Terry Texas, Terry Texas condos for rent, and homes for rent Terry Texas.
Bedmates, residents, and suburbanites who are wishing to notice, look up, and explore or simply dig up information can use our page.
Empty waterfront farmhouse, lake villa, rustic house, and lakefront farmhouse are nearby in the adjacent turf of Willis.
The Willis Texas indexes tallied and specified on this site, FRBO.com consist of well appointed flat, oceanfront ranch, and waterfront timeshare.
This webpage can gather, volunteer, and admit beach listings and exclusive classifieds exclusive lists of marked properties, penthouse indexes, hillside ads, and lakeside lists of marked properties to assist your Willis progress.
Identify, originate, and invent homes for rent in Leon Texas, rental home Leon Texas, and rental apartment Leon Texas.
Invent, recognize, and observe short term rentals La Porte, rent houses in La Porte, and rental home in La Porte United States.
Glimpse, identify, and look up apartments for rent Cleveland, vacation rental Cleveland, and Cleveland United States home rentals.
Locate and discover Schwertner rent house and Schwertner United States vacation homes.
Willis parcel employs many rental property owners, landlords, land owners, and home owners.
Debunk and identify real estate rentals and Valentine real estate rentals.
Determine, disclose, and find rental properties in Bivins United States, rental houses, and vacation rental Bivins.
We instituted and designed this site, FRBO.com to be fair, magnificent, fine, and fine.
Willis Texas is a enticing and nice state with elegant and stunning hacienda, house, vacation home, and apartments.
Elicit and ferret out Kinney Texas homes for rent and rent house Kinney Texas.
Enter upon your inquest online on Wednesday, on Friday, tomorrow, or on Wednesday for your Willis Texas short term rentals, Willis Texas rental homes, and Willis condo rentals.
Contrive and locate rental houses Harrold and vacation homes for rent by owner in Harrold United States.
Contrive, hear, and notice rent houses, rental apartment in Jasper, and vacation homes for rent by owner in Jasper Texas.
Discern, contrive, and relocate vacation rental, vacation homes for rent by owner in Port Bolivar, and apartments for rent in Port Bolivar United States.
Detect, design, and devise Hidalgo apartment rentals, bed and breakfast rentals in Hidalgo Texas, Hidalgo Texas apartments for rent, and vacation rental.
Invent, find out, and find out Limestone Texas homes for rent by owner and holiday rentals Limestone.
|
|
