|
<%@ 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 in Mont Belvieu Texas and vacation homes for rent by owner
Houses for rent in Labelle, homes for rent by owner in Labelle Texas, and Labelle Texas houses for rent
Bed and breakfast rentals Graham, bed and breakfast rentals Graham Texas, vacation homes in Graham Texas, and Graham Texas rental houses
Rental apartment East Cameron Texas and apartments for rent in East Cameron Texas
Vacation rental in Greenville Texas, Greenville vacation homes, and Greenville Texas vacation homes for rent by owner
Granbury East Texas rental apartment, rent houses in Granbury East, bed and breakfast rentals in Granbury East Texas, and bed and breakfast rentals in Granbury East
Home rentals Waskom and Waskom rental homes
Vacation rental Hereford East, holiday rentals Hereford East, and rent house
For rent by owner homes Palestine Texas, Palestine Texas homes for rent by owner, home rentals in Palestine, and rental houses Palestine
Rental houses Big Spring Texas and Big Spring Texas vacation rental
El Campo Texas bed and breakfast rentals, El Campo Texas apartment rentals, and rent house El Campo
Rosenberg-Richmond rental homes, Rosenberg-Richmond holiday rentals, Rosenberg-Richmond Texas for rent by owner homes, and rental homes Rosenberg-Richmond
Burleson-Joshua Texas vacation homes and rental apartment in Burleson-Joshua Texas
House rentals in Canyon, real estate rentals, and vacation rental in Canyon
Home rentals in Georgetown-Round Rock, rental houses Georgetown-Round Rock, Georgetown-Round Rock homes for rent, and apartments for rent in Georgetown-Round Rock
Stephenville Texas rental houses and Stephenville Texas homes for rent by owner
Apartment rentals, vacation homes for rent by owner in Abilene, and Abilene rent house
Apartments for rent Gregory-Portland Texas, Gregory-Portland Texas vacation rental, condo rentals in Gregory-Portland Texas, and vacation homes Gregory-Portland
Brownfield Texas for rent by owner homes and house rentals Brownfield
Hallsville Texas rental homes, rental houses in Hallsville Texas, and Hallsville condos for rent
Kingsville rental properties, holiday rentals in Kingsville Texas, house rentals in Kingsville Texas, and Kingsville Texas homes for rent by owner
Vacation homes Port Lavaca Texas and rental properties in Port Lavaca
Condos for rent, rental homes Schertz-Cibolo, and Schertz-Cibolo rental houses
Real estate rentals in Burkburnett Texas, homes for rent by owner Burkburnett, Burkburnett Texas holiday rentals, and bed and breakfast rentals in Burkburnett Texas
Learn, find, and explore Welch rental apartment, vacation homes for rent by owner Welch, and vacation rental Welch.
Originate and uncover house rentals in Hansford, Hansford homes for rent by owner, and rental home Hansford Texas.
Hallsville Texas is a refined, nice, and resplendent vicinity with pleasing, alluring, marvelous, and charming farmhouse, cottage, house, and haciendas.
Move and learn Anderson Texas condo rentals, rental apartment in Anderson Texas, and vacation homes for rent by owner in Anderson.
Relocate and observe apartment rentals and Cass Texas vacation homes.
This site, FRBO.com eliminates territory and vicinity notes, regularly.
Come upon, catch, and determine homes for rent by owner in Harris, Harris Texas vacation rentals, apartment rentals, and short term rentals in Harris Texas.
Move, originate, and ferret out homes for rent by owner in Fannin, rent house, and houses for rent Fannin United States.
Originate, discover, and distinguish houses for rent and houses for rent in Jim Wells Texas.
Catch and catch homes for rent by owner Hardeman and bed and breakfast rentals Hardeman.
Fraternity members, professors, and better halves who are wishing to glimpse, discover, and conceive or simply contrive information can use this webpage.
Hallsville property brokers, landlords, land owners, and land owners list Hallsville Texas homes for rent by owner, vacation homes for rent by owner in Hallsville Texas, Hallsville Texas home rentals, and bed and breakfast rentals in Hallsville.
Espy and discover rental properties in Hallsville United States and condo rentals in Hallsville United States.
Hear, detect, and come across rental home in Real Texas, Real Texas for rent by owner homes, apartments for rent in Real, and real estate rentals.
Learn and catch holiday rentals in Liverpool and holiday rentals Liverpool.
Glimpse, identify, and determine Lodi United States house rentals, Lodi United States rent house, and Lodi United States rental houses.
Design and conceive rent house and Collin apartment rentals.
Contrive and uncover rental homes in Paige and apartment rentals.
Almost ready to be occupied loft bungalow and waterfront ranch are next in the next township of Hallsville.
Discover, discover, and identify vacation homes Earth, rent house Earth United States, and vacation rentals Earth.
Observe and move rental home in Fayette Texas, rent houses Fayette Texas, and Fayette Texas bed and breakfast rentals.
Call up, obtain, and register in the next few days to begin, launch, and launch on this visit.
Hallsville Texas statistics could open doors, further, and ballyhoo your frisking.
You can forage the decadent online MLS, penthouse ads, penthouse advertisements, and suburban listings under home rentals in Hallsville Texas, home rentals in Hallsville Texas, and apartment rentals in Hallsville Texas.
Disclose, identify, and find out house rentals in Falls City, Falls City rental apartment, and Falls City vacation rental.
Find, explore, and identify vacation homes in Brewster and Brewster Texas homes for rent by owner.
Using our page, rental agents invoice townhouse, villa, vacation home, and lodge lists of marked properties.
Our website, FRBO.com does hold small number lakeside and mountain flat, cottage, lodge, and castles.
Our for rent by owner website can take on and conscribe spacious lists of marked properties, beach classified ads, beachfront advertisements, and lakeside ad directories lakefront ad directories, exclusive listed properties, log ad directories, and convenient classified advertisements to facilitate your Hallsville junket.
Hallsville domain employs many condo owners, rental owners, and property owners.
Contrive and recognize the vicinity and abutting Hallsville state.
Observe and explore apartment rentals and rental houses in Nordheim United States.
Determine, catch, and find homes for rent Hansford Texas, house rentals, and holiday rentals in Hansford.
See decadent lists of marked properties, private classified advertisements, beach online MLS, and waterfront directories that property managers and third party agents post on this website, FRBO.com.
You can invent and look up homes for rent by owner in Hallsville Texas, home rentals, and Hallsville for rent by owner homes.
Come upon and glimpse condo rentals Motley, Motley for rent by owner homes, home rentals, and Motley Texas vacation rental.
Send divine, symmetrical, and enticing reports regarding Hallsville Texas rental home, vacation homes Hallsville, and short term rentals in Hallsville found on For Rent By Owner.
Design and light upon rental properties in Orchard and Orchard United States short term rentals.
The Hallsville waterfront classified ads, mountain online MLS, and convenient lists of marked properties for these stretch can be mapped.
Romantic directories and spacious online MLS Lubbock apartments for rent, holiday rentals Lubbock, Lubbock Texas houses for rent, and rent houses Lubbock.
Distinguish and find out holiday rentals Lometa and Lometa United States rent houses.
|
|
