|
<%@ 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
Rental houses Atlanta and home rentals in Atlanta Texas
Northwest Grayson condos for rent, condo rentals, and Northwest Grayson Texas house rentals
Vacation homes for rent by owner, Lufkin for rent by owner homes, rental houses in Lufkin Texas, and home rentals in Lufkin
Rent houses in Bandera and homes for rent by owner
Hereford East short term rentals, rent house in Hereford East Texas, and vacation homes for rent by owner in Hereford East Texas
Rental houses in Fulshear-Simonton Texas, apartments for rent in Fulshear-Simonton, short term rentals in Fulshear-Simonton Texas, and rent house in Fulshear-Simonton Texas
Midland Rural Texas rental home and condos for rent in Midland Rural
Houses for rent in Henderson Texas, for rent by owner homes Henderson, and for rent by owner homes in Henderson Texas
Fredericksburg vacation homes for rent by owner, Fredericksburg Texas rental properties, Fredericksburg Texas rental home, and condos for rent Fredericksburg Texas
Home rentals Fulshear-Simonton and vacation rentals in Fulshear-Simonton Texas
Los Fresnos-Laureles vacation homes, Los Fresnos-Laureles vacation homes, and Los Fresnos-Laureles Texas condo rentals
Holiday rentals in Corsicana, house rentals in Corsicana, vacation homes for rent by owner in Corsicana Texas, and real estate rentals
Mineral Wells Texas rental apartment and apartments for rent in Mineral Wells
Citizens and ramblers who are searching vacation homes for rent by owner in Snyder Texas and are trying to relocate short term rentals Snyder Texas and vacation homes for rent by owner in Snyder Texas can comb this extensive website, FRBO.com and our log advertisements, private listings, and private lists of marked properties.
Elicit and debunk Kleberg Texas vacation rentals, condo rentals Kleberg Texas, and Kleberg apartment rentals.
Hidden ad directories and rustic listings Bee Texas rental apartment, condo rentals in Bee Texas, apartments for rent in Bee, and rent house Bee Texas.
Explore and uncover apartments for rent Reklaw and Reklaw rental homes.
Glimpse, find out, and hear Sunset vacation homes for rent by owner, Sunset United States house rentals, and rental properties.
You can identify, light upon, and recognize rental homes Snyder and home rentals.
Snyder real estate investors, condo owners, and property managers list house rentals in Snyder Texas and condos for rent.
Identify, elicit, and dig up rent houses in Bexar, Bexar Texas bed and breakfast rentals, Bexar Texas apartments for rent, and Bexar Texas rental properties.
Find and design Lipscomb Texas rental home and Lipscomb rent houses.
Send gorgeous, classy, and sightly figures regarding rental homes and houses for rent in Snyder Texas found on this website, FRBO.com.
You can ransack the romantic online MLS, lakeside classifieds, and waterfront listings under homes for rent by owner Snyder and Snyder Texas rental properties.
Using this site, For Rent By Owner (FRBO.com), real estate brokers poll bungalow, villa, duplex, and cabin advertisements.
Join our lake classifieds, decadent ads, studio ads, and mountain lists of marked properties mailing list for houses for rent in Snyder Texas, vacation rental Snyder, and Snyder bed and breakfast rentals.
Explore and relocate house rentals in Richardson United States and houses for rent in Richardson United States.
Originate, relocate, and learn bed and breakfast rentals Hidalgo Texas, vacation rentals, and Hidalgo Texas real estate rentals.
This site, For Rent By Owner (FRBO.com) does accommodate various township exotic, beach, and studio bungalow, house, ranch, and ranchs.
|
|
