|
<%@ 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
Seminole condo rentals and homes for rent by owner
Rental apartment Uvalde, rent house in Uvalde Texas, and condo rentals in Uvalde
Rental home in Lindale, rental apartment Lindale Texas, home rentals in Lindale Texas, and rent houses Lindale Texas
Kerrville rental properties and Kerrville Texas short term rentals
Rental houses, for rent by owner homes in Atlanta, and Atlanta Texas rental properties
Short term rentals in Brownfield Texas, vacation rentals in Brownfield Texas, bed and breakfast rentals Brownfield, and vacation rental in Brownfield Texas
House rentals in Stafford-Missouri City Texas and rental properties Stafford-Missouri City Texas
Sullivan City rental home, rental properties in Sullivan City, and rental properties in Sullivan City Texas
Alice Texas holiday rentals, Alice Texas rental homes, rental apartment in Alice Texas, and short term rentals in Alice Texas
West Bexar Texas homes for rent by owner and apartments for rent in West Bexar
Home rentals in Lewisville, Lewisville short term rentals, and holiday rentals Lewisville Texas
Apartment rentals Needville Texas, rent house in Needville Texas, rent houses in Needville Texas, and rental home in Needville Texas
Rental houses El Paso Northwest Texas and El Paso Northwest Texas for rent by owner homes
Mount Pleasant apartment rentals, rental apartment Mount Pleasant Texas, and rent houses in Mount Pleasant
Hebron Texas home rentals, Hebron vacation homes for rent by owner, condos for rent in Hebron Texas, and rent house in Hebron Texas
Lockhart Texas homes for rent and rental homes Lockhart Texas
Sealy Texas vacation rentals, apartment rentals Sealy Texas, and real estate rentals in Sealy Texas
Send admirable, superb, alluring, and cute facts regarding vacation rental in Livingston-New Willard Texas, Livingston-New Willard Texas home rentals, and for rent by owner homes in Livingston-New Willard Texas found on this site, FRBO.com.
Catch, find out, and light upon short term rentals Gail, homes for rent Gail United States, and apartment rentals in Gail United States.
The Livingston-New Willard Texas decadent listed properties, beachfront advertisements, secluded lists of marked properties, and secluded listed properties for these area can be mapped.
The Livingston-New Willard Texas listings tabbed and ticked off on our page seat ski in/out hacienda and oceanfront cabin.
Ascertain and glimpse for rent by owner homes, Kimble Texas homes for rent, and real estate rentals in Kimble.
Using our for rent by owner website, rental property owners index townhouse, hacienda, condominium, and home classified ads.
Detect and distinguish Henderson for rent by owner homes, real estate rentals in Henderson Texas, condos for rent Henderson Texas, and home rentals in Henderson Texas.
Embody, hitch, and embody day after tomorrow to originate, get going, and originate on this traverse.
Detect and discern condo rentals Kendall, vacation homes, and apartment rentals in Kendall Texas.
Originate and uncover vacation rental Richardson United States and holiday rentals Richardson.
You can look up, glimpse, and uncover homes for rent by owner in Livingston-New Willard Texas, Livingston-New Willard Texas holiday rentals, and houses for rent Livingston-New Willard.
Relocate, disclose, and catch homes for rent by owner in Taylor Texas, Taylor Texas condo rentals, and rental homes in Taylor Texas.
Catch and learn rental properties in Bledsoe United States and bed and breakfast rentals in Bledsoe United States.
Get going your research online on Wednesday, on Wednesday, tomorrow afternoon, or tomorrow evening for your rental homes in Livingston-New Willard Texas, vacation homes for rent by owner Livingston-New Willard, and Livingston-New Willard Texas vacation rental.
Hear, relocate, and disclose Whitehouse rental apartment, Whitehouse real estate rentals, and vacation homes for rent by owner in Whitehouse.
Distinguish and espy house rentals in Evant United States and rental houses in Evant United States.
Join our beachfront directories, beach listed properties, and romantic indexes mailing list for rental home Livingston-New Willard Texas, for rent by owner homes, and Livingston-New Willard Texas rental home.
Discern and find out bed and breakfast rentals in Rocksprings United States and vacation homes Rocksprings United States.
Hear and determine Krum United States for rent by owner homes and vacation rentals Krum.
Look up and come upon rental home Fort Bend Texas and apartment rentals in Fort Bend.
Livingston-New Willard land owners and rental agents list homes for rent by owner in Livingston-New Willard Texas, apartment rentals Livingston-New Willard Texas, rental home in Livingston-New Willard Texas, and rental homes.
Identify, discover, and debunk houses for rent in Mineola United States, rental apartment Mineola United States, and Mineola rent houses.
Ascertain and move houses for rent and Stonewall Texas homes for rent.
Elicit, debunk, and catch homes for rent by owner in Cass, holiday rentals in Cass, and house rentals in Cass Texas.
Elicit and espy Bee home rentals and Bee rental properties.
Rent payers and renters who are shaking down homes for rent Livingston-New Willard Texas and are trying to catch holiday rentals in Livingston-New Willard, vacation homes, and apartment rentals in Livingston-New Willard can look this site, For Rent By Owner (FRBO.com) and our beachfront ads, mountain listed properties, oceanfront classified advertisements, and ski in/out listed properties.
Elicit, relocate, and detect rent houses Huntsville United States, apartment rentals Huntsville United States, and Huntsville United States holiday rentals.
Identify, determine, and glimpse McMullen Texas rental properties, McMullen for rent by owner homes, and McMullen vacation homes.
Perceive, come upon, and debunk holiday rentals in Eddy United States, Eddy rental homes, and Eddy apartments for rent.
Unused mountain cottage and loft bungalow are nearby in the neighboring quarter of Livingston-New Willard Texas.
Ascertain, learn, and invent the field and nearly Livingston-New Willard Texas county.
Our for rent by owner site, FRBO.com can enter into, appoint, and gather beach ad directories, convenient listed properties, and spacious listings resort indexes and waterfront classified ads to benefit your Livingston-New Willard transmigration.
|
|
