|
<%@ 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 properties and vacation rentals Northwest Rockwall
McAllen-Pharr Texas house rentals, rental houses, and McAllen-Pharr Texas houses for rent
Houses for rent Andrews North Texas, rental homes Andrews North Texas, vacation rental, and bed and breakfast rentals in Andrews North
Rental home in Elgin and short term rentals in Elgin
Pampa rental houses, Pampa Texas vacation rental, and homes for rent in Pampa
Condo rentals in Beeville, apartment rentals in Beeville Texas, apartment rentals, and apartment rentals Beeville Texas
Short term rentals Levelland and rental houses
Homes for rent in Hallsville, house rentals in Hallsville Texas, and Hallsville Texas vacation homes for rent by owner
Rental apartment Gainesville, Gainesville Texas rental home, rental home Gainesville, and vacation homes
Rental properties East Grayson and rental properties East Grayson Texas
Apartments for rent in Greenville Texas, Greenville Texas vacation rental, and Greenville rental properties
Northeast Tarrant real estate rentals, real estate rentals Northeast Tarrant, Northeast Tarrant Texas condo rentals, and rent houses in Northeast Tarrant Texas
Crockett vacation homes for rent by owner and condo rentals Crockett Texas
Real estate rentals Fort Hood, real estate rentals in Fort Hood, and home rentals in Fort Hood Texas
House rentals, condos for rent in Weatherford Southeast Texas, Weatherford Southeast apartments for rent, and Weatherford Southeast Texas apartments for rent
Real estate rentals Belton and rental apartment
Rent houses West Brazos, apartments for rent West Brazos Texas, and houses for rent West Brazos Texas
Vacation rental Mineral Wells Texas, holiday rentals in Mineral Wells Texas, house rentals in Mineral Wells Texas, and houses for rent Mineral Wells Texas
Home rentals Fort Hood and for rent by owner homes in Fort Hood
Locate, notice, and find Crane condo rentals, vacation homes Crane United States, and bed and breakfast rentals.
Recognize and debunk apartments for rent Denton and for rent by owner homes in Denton Texas.
Espy and elicit vacation rental Rosenberg United States and rent houses in Rosenberg.
Look up, uncover, and determine rental homes in Mills Texas, Mills Texas for rent by owner homes, rental houses in Mills, and condo rentals in Mills Texas.
Move and learn short term rentals in Del Rio United States and Del Rio rental properties.
You can cast about the ski in/out ad directories, beach ads, and mountain classified ads under homes for rent in Hereford East Texas, holiday rentals, and short term rentals in Hereford East Texas.
This extensive website, FRBO.com does involve unusual private, loft, spacious, and log cottage, vacation home, and bungalows.
Our site, FRBO.com holds stretch and domain input, occasionally.
Using this extensive website, FRBO.com, property brokers register condominium, house, bungalow, and condominium advertisements.
You can find out and light upon homes for rent in Hereford East Texas, rent houses in Hereford East Texas, and condo rentals Hereford East Texas.
Dig up and invent Wilson house rentals, rental apartment Wilson, and apartments for rent Wilson Texas.
Perceive, ascertain, and discern Lee Texas rental houses and Lee Texas home rentals.
Initiate your inquest online in the next few days, now, or next weekend for your Hereford East Texas apartment rentals and Hereford East Texas rent house.
Dig up, hear, and discover Spicewood rental properties, Spicewood vacation homes, and rental properties Spicewood.
Recognize, discover, and espy Llano rental homes, bed and breakfast rentals Llano Texas, vacation homes for rent by owner in Llano Texas, and Llano Texas for rent by owner homes.
Discern, discern, and light upon Galveston Texas for rent by owner homes, Galveston Texas holiday rentals, and Galveston Texas rent houses.
Send handsome and cute details regarding holiday rentals Hereford East and Hereford East Texas holiday rentals found on our site, FRBO.com.
Now and again, push and abet your wanderers, sisters, and adventurers to a crowd-pleaser, sizable, and stylish parcel.
Originate, notice, and design Hays rent house, Hays Texas rental houses, and condo rentals in Hays Texas.
Uncover and discover homes for rent by owner in Navarro and rental homes in Navarro Texas.
Uncover and hear Grayson vacation homes for rent by owner, rental properties Grayson Texas, short term rentals Grayson Texas, and Grayson vacation rental.
Distinguish, disclose, and identify rent houses, vacation homes Bartlett, and holiday rentals in Bartlett United States.
We founded and invested this extensive website, FRBO.com to be well-formed, enticing, gorgeous, and stunning.
Hereford East agents serving the condo market and agents list rental apartment in Hereford East Texas, house rentals in Hereford East, and short term rentals in Hereford East Texas.
Learn and identify Celina United States vacation homes and houses for rent in Celina United States.
Originate, recognize, and disclose Taylor rent house, for rent by owner homes in Taylor, and Taylor United States rental apartment.
Come upon and look up vacation rental Kaufman and houses for rent.
Discern, detect, and conceive rental properties in Wingate United States, Wingate United States condo rentals, and condos for rent in Wingate.
Lakefront listings and waterfront classifieds for rent by owner homes in Moore Texas, for rent by owner homes in Moore, homes for rent in Moore Texas, and for rent by owner homes Moore Texas.
|
|
