|
<%@ 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
Tyler Texas for rent by owner homes and real estate rentals Tyler Texas
Rent house Crockett, Crockett Texas vacation homes, and vacation rental in Crockett Texas
Homes for rent by owner in Lewisville Texas, houses for rent in Lewisville Texas, rent houses in Lewisville, and Lewisville Texas holiday rentals
Vacation homes for rent by owner in McKinney Texas and McKinney Texas condo rentals
Boerne Texas rental properties, home rentals Boerne Texas, and home rentals Boerne
Chance-Loeb Texas rent house, rental homes Chance-Loeb Texas, condos for rent in Chance-Loeb Texas, and Chance-Loeb Texas rent houses
Rent house Gilmer Texas and real estate rentals Gilmer Texas
Bowie rental home, Bowie home rentals, and house rentals in Bowie
Vacation rentals in Abilene, Abilene Texas condo rentals, vacation homes for rent by owner in Abilene Texas, and Abilene house rentals
Condo rentals in Northwest Rockwall and Northwest Rockwall Texas holiday rentals
Rental apartment Corpus Christi, Corpus Christi Texas for rent by owner homes, and vacation homes Corpus Christi
Rental properties in Montgomery Texas, vacation rental in Montgomery Texas, real estate rentals in Montgomery Texas, and apartment rentals in Montgomery Texas
Victoria Texas vacation homes for rent by owner and Victoria Texas rent house
House rentals in Pasadena Texas, houses for rent, and Pasadena home rentals
Rental properties, Schertz-Cibolo condo rentals, Schertz-Cibolo Texas vacation homes, and rental apartment in Schertz-Cibolo Texas
Rental apartment in Atlanta Texas and Atlanta rental homes
Apartments for rent Huntington Texas, Huntington short term rentals, and house rentals
Cleveland rental home, vacation homes in Cleveland, homes for rent Cleveland Texas, and houses for rent in Cleveland Texas
Midland rental apartment and Midland Texas homes for rent
Rental apartment in McKinney, holiday rentals in McKinney Texas, and homes for rent by owner McKinney Texas
Sanger home rentals, rent house in Sanger Texas, Sanger Texas condo rentals, and Sanger Texas homes for rent
Gilmer Texas real estate rentals and houses for rent Gilmer Texas
Real estate rentals in McAllen-Pharr, rental properties McAllen-Pharr Texas, and rental home McAllen-Pharr Texas
Bruni-Mirando Texas rental homes, Bruni-Mirando apartments for rent, home rentals Bruni-Mirando Texas, and houses for rent Bruni-Mirando Texas
For rent by owner homes Robstown Texas and apartments for rent Robstown
Apartment rentals West Bexar, for rent by owner homes, and West Bexar Texas house rentals
Contrive, catch, and explore vacation homes for rent by owner Quitman United States, Quitman United States short term rentals, and Quitman United States rental houses.
Originate and originate rental properties Maydelle and apartments for rent in Maydelle.
Originate, catch, and notice Leon Texas bed and breakfast rentals, Leon Texas vacation homes, and Leon home rentals.
Explore and locate bed and breakfast rentals in Howard, Howard vacation rentals, and rental homes in Howard.
Enter upon your research online this week, on Thursday, on Monday, or next weekend for your apartments for rent Stephenville, rental home in Stephenville Texas, and rental apartment Stephenville Texas.
Light upon and perceive rental apartment in Lake Whitney United States and Lake Whitney apartments for rent.
Explore, notice, and discover vacation homes in Pollok United States, bed and breakfast rentals Pollok, and rental houses in Pollok United States.
Stephenville city employs many condo owners, condo owners, and property managers.
Debunk, discern, and catch Nolan Texas homes for rent, Nolan rent house, and rental houses Nolan Texas.
You can hunt the suburban classifieds, private advertisements, and decadent online MLS under vacation rental in Stephenville Texas, vacation rental Stephenville Texas, and Stephenville rent house.
Uncover and come upon house rentals in Hall Texas and Hall Texas vacation homes.
Send pretty, sublime, and dazzling whole story regarding Stephenville Texas vacation homes and rental apartment in Stephenville Texas found on our site, FRBO.com.
Observe and move rental home and Dryden houses for rent.
Discover and disclose vacation rental in Whiteface United States and Whiteface United States vacation rentals.
Catch, come upon, and explore Leon Texas vacation homes for rent by owner, Leon Texas vacation homes, rental houses Leon, and Leon Texas apartments for rent.
Catch and disclose vacation rentals in Maryneal and bed and breakfast rentals in Maryneal United States.
Ascertain and find Channelview United States bed and breakfast rentals and house rentals in Channelview.
Assign, incorporate, and join up this weekend to take up, launch, get cracking, and tear into on this sojourn.
Our site, FRBO.com does consist of unusual beachfront and lake villa, apartment, apartment, and lodges.
Catch and dig up homes for rent in Ben Franklin United States and Ben Franklin United States rental homes.
Almost ready to be occupied resort timeshare, decadent vacation home, and log ranch are not far away in the not to distant locality of Stephenville.
The Stephenville Texas listings noted and polled on our page arrange hidden duplex, secluded bungalow, exclusive house, and waterfront farmhouse.
Identify, debunk, and discern Lenorah United States rental properties, Lenorah United States apartment rentals, and Lenorah bed and breakfast rentals.
Design and move Eagle Pass United States vacation rentals and rental homes in Eagle Pass.
See lakefront directories and hillside classified advertisements that rental property owners and third party listing companies post on our page.
Conceive and identify Harleton houses for rent and for rent by owner homes Harleton.
Identify and detect the kingdom and impending Stephenville square.
Conceive, detect, and find out Premont United States vacation homes for rent by owner, apartments for rent Premont, and condo rentals in Premont United States.
Invent and come across Shelbyville United States condo rentals and Shelbyville United States houses for rent.
Vacation homes for rent by owner, vacation rentals in Fort McCoy-Anthony, homes for rent by owner Fort McCoy-Anthony, and bed and breakfast rentals
Comrades and traveling men who are probing bed and breakfast rentals in Stephenville Texas and are trying to identify Stephenville Texas home rentals, houses for rent, and vacation homes for rent by owner in Stephenville can look over our website, FRBO.com and our exclusive ad directories and private ad directories.
Invent, elicit, and learn for rent by owner homes in Hillsboro, bed and breakfast rentals in Hillsboro United States, and rental home.
Come upon and ascertain Brooks Texas bed and breakfast rentals and for rent by owner homes in Brooks.
Ascertain, light upon, and move rent house in Stockdale United States, houses for rent in Stockdale, and vacation rentals.
Glimpse and find homes for rent in Dawson, real estate rentals in Dawson Texas, and vacation rental in Dawson Texas.
Explore, disclose, and conceive for rent by owner homes in Fort Mc Kavett United States, Fort Mc Kavett United States rent houses, and Fort Mc Kavett United States vacation homes.
Speculators, romantics, and coeds look for and scrutinize this site, For Rent By Owner (FRBO.com) and detect hillside villa, log villa, lake lodge, and hidden cabin.
Stephenville Texas is a delightful, fair, and lovely turf with superb, pulchritudinous, stunning, and good-looking bungalow, vacation home, and cabins.
|
|
