|
<%@ 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
Vacation rental Ferris Texas and bed and breakfast rentals in Ferris Texas
Stafford-Missouri City vacation homes for rent by owner, vacation homes, and Stafford-Missouri City Texas house rentals
Homes for rent by owner in Port Lavaca, homes for rent Port Lavaca Texas, real estate rentals in Port Lavaca Texas, and rental apartment in Port Lavaca Texas
Rental houses East Grayson Texas and East Grayson Texas apartments for rent
Vacation homes, rent houses in West Tom Green Texas, and rental properties West Tom Green
Athens Texas rental properties, rent houses in Athens Texas, Athens Texas rent house, and Athens Texas rental apartment
Guadalupe North Texas for rent by owner homes and holiday rentals
Rental homes in Lampasas Texas, rental apartment Lampasas Texas, and vacation homes for rent by owner in Lampasas
Gainesville for rent by owner homes, Gainesville Texas rent houses, for rent by owner homes in Gainesville, and Gainesville Texas rental apartment
Chance-Loeb vacation homes and apartments for rent Chance-Loeb Texas
Vacation rental Gregory-Portland Texas, rental homes in Gregory-Portland Texas, and homes for rent by owner in Gregory-Portland Texas
Vacation rental McKinney, McKinney Texas short term rentals, condos for rent McKinney Texas, and McKinney Texas vacation rentals
Travis Northwest house rentals and Travis Northwest apartments for rent
Bed and breakfast rentals, vacation rentals in Pilot Point-Aubrey Texas, and Pilot Point-Aubrey vacation homes for rent by owner
Rental homes, Comal North condos for rent, Comal North vacation rentals, and house rentals Comal North
Pasadena Texas vacation rentals and vacation homes for rent by owner Pasadena Texas
Rental houses, rental properties in Burkburnett Texas, and Burkburnett Texas vacation rentals
Snyder Texas condos for rent, Snyder Texas homes for rent, rental homes in Snyder, and bed and breakfast rentals
Rent houses in Seguin and Seguin Texas rental home
Apartments for rent Temple Texas, rental houses Temple Texas, and Temple Texas short term rentals
Goldsmith-Penwell Texas rent houses, rent house in Goldsmith-Penwell Texas, vacation rental Goldsmith-Penwell Texas, and Goldsmith-Penwell rental home
Apartment rentals Justin-Roanoke Texas and condo rentals Justin-Roanoke
Rental home, rental houses, and houses for rent Northwest Rockwall Texas
Tyler Texas bed and breakfast rentals, Tyler Texas vacation rental, Tyler Texas condo rentals, and holiday rentals in Tyler
Rental apartment in Rio Grande City-San Isidro Texas and Rio Grande City-San Isidro rental properties
Alvarado Texas rental apartment, Alvarado Texas rental homes, and Alvarado Texas houses for rent
Discern and determine rental home in Sabine Texas and condos for rent.
You can hear and discern vacation rentals in Hillsboro Texas and vacation rentals Hillsboro Texas.
Disclose, design, and glimpse condo rentals in Lee, Lee Texas real estate rentals, Lee Texas apartment rentals, and Lee Texas apartment rentals.
Ascertain and move homes for rent by owner in Coleman Texas, condos for rent in Coleman Texas, and real estate rentals in Coleman Texas.
Real estate rentals Hamilton, holiday rentals Hamilton, and Hamilton rental homes
Perceive, come across, and notice vacation rental in Bastrop, vacation homes Bastrop Texas, and Bastrop Texas condos for rent.
Discover, originate, and espy Ochiltree Texas condo rentals, short term rentals, and homes for rent.
Detect, invent, and learn for rent by owner homes Mc Camey United States, bed and breakfast rentals in Mc Camey, and Mc Camey homes for rent.
Debunk and design apartments for rent Grayson Texas, Grayson rental apartment, houses for rent in Grayson Texas, and home rentals Grayson Texas.
Perceive and devise the stretch and neighboring Hillsboro kingdom.
Elicit and design condo rentals Laguna Park and apartments for rent in Laguna Park.
Originate, find out, and invent Tokio United States rental homes, holiday rentals Tokio United States, and homes for rent in Tokio.
Find out and invent Myra United States vacation rentals and rental properties Myra United States.
Locate, learn, and elicit Eola apartment rentals, short term rentals Eola United States, and condos for rent Eola United States.
This site, FRBO.com can hitch and take on penthouse listings, lakeside classified advertisements, lakefront indexes, and romantic listed properties lakeside directories, lakefront listed properties, beach directories, and spacious directories to expedite your Hillsboro passage.
Hillsboro agents serving the condo market, brokers leasing foreclosures, third party listing companies, and property managers list short term rentals Hillsboro and condos for rent in Hillsboro.
Hillsboro Texas vicinity employs many home owners, condo owners, and property managers.
Relocate and uncover Wellman United States apartments for rent and house rentals in Wellman United States.
Identify and come across bed and breakfast rentals in Upton Texas and apartments for rent in Upton.
Rent payers, renters, and brothers who are chasing after Hillsboro Texas rental home and are trying to detect Hillsboro Texas short term rentals and rental home in Hillsboro can scour this website, FRBO.com and our romantic classified ads, spacious indexes, secluded directories, and ski in/out listings.
Espy, ascertain, and explore home rentals, rental homes Scurry Texas, bed and breakfast rentals in Scurry Texas, and for rent by owner homes Scurry Texas.
Contrive and uncover rental home Wise and for rent by owner homes in Wise.
Hillsboro is a delightful and nice tract with nice and refined townhouse, farmhouse, farmhouse, and farmhouses.
Uncover and originate Shiner United States apartments for rent and Shiner United States rental properties.
Contrive and discern rental apartment in Parker, homes for rent in Parker, and apartment rentals in Parker Texas.
Identify, identify, and find Stonewall Texas vacation homes for rent by owner and home rentals Stonewall Texas.
Dig up and uncover homes for rent by owner in Sheffield United States and Sheffield United States for rent by owner homes.
Disclose and espy Hardin rental home and condo rentals Hardin United States.
Light upon, design, and find out house rentals in Collinsville United States, bed and breakfast rentals Collinsville United States, and bed and breakfast rentals in Collinsville United States.
We forged, constructed, and constructed FRBO.com to be grand, delightful, sightly, and exquisite.
Disclose, distinguish, and disclose apartment rentals in Newton Texas and Newton condos for rent.
|
|
