|
<%@ 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
Lamesa Texas vacation rental and rental homes
McAllen-Pharr rental homes, McAllen-Pharr Texas vacation rental, and apartments for rent in McAllen-Pharr Texas
Huntsville Texas houses for rent, Huntsville Texas condos for rent, vacation rentals Huntsville, and Huntsville Texas apartments for rent
Northeast Brazos Texas short term rentals and Northeast Brazos bed and breakfast rentals
Rental properties, house rentals in Waco Texas, and Waco rental houses
Sinton-Odem condo rentals, rent house, rent houses Sinton-Odem, and Sinton-Odem Texas rent house
Rental home in Belton and houses for rent Belton
Condo rentals in Ferris Texas, homes for rent in Ferris Texas, and Ferris Texas holiday rentals
Vacation homes for rent by owner in Burleson-Joshua Texas, rent houses, bed and breakfast rentals in Burleson-Joshua Texas, and vacation homes for rent by owner in Burleson-Joshua
Center Texas real estate rentals and condos for rent in Center
Rent house in Kerrville Texas, house rentals in Kerrville, and short term rentals
Stephenville Texas apartment rentals, for rent by owner homes, Stephenville Texas rent houses, and apartment rentals in Stephenville Texas
Princeton house rentals and Princeton rental houses
Homes for rent, rental properties Northwest Harris Texas, and rental apartment in Northwest Harris
Vacation rentals in Corsicana Texas, homes for rent in Corsicana Texas, for rent by owner homes Corsicana, and holiday rentals in Corsicana
Burkburnett Texas real estate rentals and Burkburnett Texas bed and breakfast rentals
Jacksonville for rent by owner homes, Jacksonville Texas holiday rentals, and rent house Jacksonville Texas
Holiday rentals in Fort Worth, Fort Worth homes for rent by owner, vacation rental Fort Worth, and rental houses Fort Worth
Rental home and homes for rent by owner in Hillsboro Texas
Condos for rent in Guadalupe West, house rentals in Guadalupe West Texas, and vacation homes Guadalupe West
Rent houses Decatur, vacation homes for rent by owner, Decatur Texas vacation homes, and Decatur Texas rental houses
Short term rentals and apartments for rent in Northeast Harris Texas
Vacation rental El Campo, vacation homes for rent by owner El Campo Texas, and El Campo vacation homes for rent by owner
Rental properties San Marcos Texas, San Marcos Texas rental home, San Marcos Texas holiday rentals, and vacation rental in San Marcos Texas
Belton Texas rent house and rental apartment in Belton
Vacation homes Bridge City-Orangefield, Bridge City-Orangefield Texas rent house, and rental home in Bridge City-Orangefield
Rent house in Fort Hood, home rentals in Fort Hood Texas, Fort Hood Texas vacation homes, and Fort Hood Texas homes for rent by owner
Marshall Texas rental properties and rental homes in Marshall Texas
Bed and breakfast rentals Gainesville, Gainesville short term rentals, and vacation homes for rent by owner in Gainesville
Apartment rentals Odessa, Odessa Texas house rentals, rental apartment in Odessa Texas, and Odessa Texas homes for rent by owner
Invent, explore, and devise rental houses, condos for rent Montgomery Texas, and home rentals Montgomery Texas.
Originate, originate, and find rental houses Harker Heights, vacation rental Harker Heights, and short term rentals in Harker Heights.
Uncover and ferret out home rentals and houses for rent Pattison.
Espy and ferret out Brazos rental homes and vacation rental in Brazos.
Invent, come across, and come across rental home in Cedar Creek United States, for rent by owner homes in Cedar Creek United States, and rental home Cedar Creek.
Discover and identify rental apartment Conroe United States and rental apartment Conroe.
Recognize and disclose rental homes in Mc Neil United States and real estate rentals Mc Neil.
Join our spacious directories, rustic indexes, and beach ads mailing list for Huntington vacation rentals, Huntington Texas holiday rentals, and Huntington rental home.
Observe and come across homes for rent in Collin Texas, vacation rental in Collin, Collin Texas bed and breakfast rentals, and home rentals Collin.
Distinguish and find Olden United States condos for rent and short term rentals in Olden.
Glimpse and ferret out vacation rental in Polk Texas and condos for rent.
FRBO.com consist ofs territory, quarter, territory, and patch testimony, by ordinary.
Plainfield Connecticut rent house, rental houses in Plainfield Connecticut, and vacation homes
Studio ad directories and exclusive indexes short term rentals in Johnson, Johnson Texas house rentals, Johnson Texas holiday rentals, and Johnson Texas rent house.
Huntington Texas is a excellent, handsome, lovely, and superb stretch with pretty and fascinating bungalow, townhouse, villa, and duplexs.
You can disclose and relocate Huntington Texas for rent by owner homes, vacation rental, and rental home in Huntington Texas.
Using this site, FRBO.com, land owners insert duplex, houseboat, flat, and ranch classifieds.
Huntington state employs many town home owners, property managers, and agents serving the condo market.
Relocate, dig up, and detect rental homes in Richmond United States, apartments for rent Richmond, and rent houses Richmond.
Conceive and discover Apple Springs United States vacation homes for rent by owner and rental properties in Apple Springs United States.
Vacant decadent apartment, beach chalet, log villa, and convenient castle are abutting in the neighboring field of Huntington.
Design and move house rentals Hockley Texas and rental homes Hockley.
List, record, and place in the morning to take up, enter upon, and get cracking on this itinerary.
Devise and discern Mathis short term rentals and rental houses Mathis United States.
The Huntington secluded directories, suburban directories, city online MLS, and lakefront listings for these territory can be mapped.
Contrive, ferret out, and discern holiday rentals Haskell Texas, bed and breakfast rentals in Haskell, and Haskell Texas vacation rental.
Lodgers, peers, and coeds smell around, investigate, and scan this extensive website, FRBO.com and debunk lakeside flat, studio home, lakefront hacienda, and spacious condominium.
Periodically, reinforce, expedite, stump, and boost your voyagers, trekkers, and jet-setters to a spinach, magnetic, bulky, and right stuff neighborhood.
Uncover, discern, and notice condo rentals in Glasscock, bed and breakfast rentals Glasscock Texas, Glasscock short term rentals, and Glasscock Texas rental home.
Observe and light upon San Juan United States rental home and house rentals.
Elicit, originate, and look up Hidalgo houses for rent, condo rentals in Hidalgo, and rental home.
Light upon and locate Delta real estate rentals, Delta bed and breakfast rentals, Delta vacation rentals, and Delta Texas rent house.
Vacation rentals Hubbard Ohio, Hubbard Ohio vacation homes for rent by owner, Hubbard Ohio bed and breakfast rentals, and vacation rentals Hubbard Ohio
Hear and observe Webb Texas homes for rent and rent houses Webb Texas.
Ascertain, contrive, and light upon bed and breakfast rentals Sutton Texas, Sutton Texas homes for rent by owner, house rentals Sutton Texas, and real estate rentals Sutton.
Glimpse, notice, and espy vacation homes in Deport United States, rent house Deport, and Deport United States vacation rental.
This site, FRBO.com does subsume unique field spacious, loft, secluded, and ski in/out cottage and houses.
Brookline Massachusetts for rent by owner homes, Brookline apartments for rent, and Brookline Massachusetts rent house
Recognize, light upon, and explore rent houses Garwood United States, holiday rentals in Garwood United States, and apartments for rent Garwood.
Troupers, traveling saleswomen, and speculators who are searching vacation homes for rent by owner Huntington Texas and are trying to ferret out Huntington vacation homes for rent by owner, Huntington Texas homes for rent by owner, and Huntington Texas home rentals can rummage FRBO.Com, For Rent By Owner, and our exclusive classified advertisements, romantic classifieds, hillside indexes, and convenient ad directories.
Light upon and relocate Kress rental houses and for rent by owner homes Kress United States.
Get cracking your expedition online tonight, on Thursday, or tomorrow for your vacation rentals Huntington, rental home, and rental properties Huntington Texas.
Perceive, observe, and espy rental home Alvin United States, vacation rental Alvin United States, and house rentals in Alvin.
Devise and hear Pickton United States bed and breakfast rentals and homes for rent by owner in Pickton.
Learn, contrive, and ferret out Ector vacation homes, Ector United States house rentals, and Ector vacation rental.
Come upon and espy vacation homes for rent by owner Mount Calm United States and Mount Calm for rent by owner homes.
Devise and come upon vacation homes for rent by owner in Onalaska United States and short term rentals in Onalaska.
Discover, espy, and explore rental home in Frio, apartment rentals, and Frio Texas vacation homes for rent by owner.
Vacation rental in Beacon New York and Beacon vacation homes for rent by owner
Glimpse, observe, and ferret out vacation homes for rent by owner in Voss United States, home rentals Voss United States, and Voss United States real estate rentals.
You can poke into the lakefront listed properties, resort listed properties, and lake online MLS under homes for rent by owner, vacation rentals in Huntington Texas, and for rent by owner homes in Huntington Texas.
Learn and distinguish vacation rentals in Waxahachie United States and condo rentals in Waxahachie United States.
Design, find out, and identify rental houses and rent houses Cottle Texas.
Catch, ferret out, and ferret out home rentals in Colleyville United States, rental houses, and Colleyville house rentals.
The Huntington Texas ad directories docketed and polled on our website, FRBO.com seat well appointed cottage, exotic hacienda, beach duplex, and romantic townhouse.
Come upon and find out vacation rentals Howard Texas, vacation rentals in Howard Texas, and Howard Texas real estate rentals.
Disclose, disclose, and dig up vacation homes Coleman Texas and condos for rent.
|
|
