|
<%@ 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
Houses for rent Fort Hood Texas and bed and breakfast rentals Fort Hood Texas
Vacation homes in Cleveland Texas, bed and breakfast rentals in Cleveland Texas, and Cleveland condos for rent
Apartment rentals, vacation homes in Hereford East Texas, rent house, and vacation homes for rent by owner in Hereford East
Rental apartment Eagle Pass Texas and house rentals in Eagle Pass Texas
Atlanta home rentals, short term rentals Atlanta, and rent houses Atlanta
Vacation homes for rent by owner, Jasper homes for rent by owner, Jasper Texas apartment rentals, and condos for rent Jasper Texas
Vacation rentals in Angleton-Rosharon Texas and Angleton-Rosharon Texas homes for rent
Holiday rentals, home rentals Gainesville, and bed and breakfast rentals Gainesville Texas
Apartments for rent, Gainesville Texas vacation homes for rent by owner, real estate rentals in Gainesville, and homes for rent by owner Gainesville Texas
Houses for rent in Southwest and apartment rentals in Southwest Texas
Greenville bed and breakfast rentals, Greenville house rentals, and Greenville Texas apartments for rent
Baytown Texas homes for rent, Baytown condo rentals, rental apartment Baytown, and Baytown Texas rental homes
Brownfield Texas rental home and Brownfield houses for rent
Huntsville rent house, home rentals in Huntsville Texas, and condo rentals
House rentals in Mineral Wells Texas, Mineral Wells Texas rental home, Mineral Wells Texas condos for rent, and vacation homes for rent by owner Mineral Wells Texas
Paris Texas vacation rentals and Paris Texas condo rentals
Rental homes in Silsbee Texas, Silsbee bed and breakfast rentals, and vacation rentals
Hondo Texas home rentals, condo rentals in Hondo Texas, Hondo bed and breakfast rentals, and homes for rent in Hondo Texas
Bed and breakfast rentals Abilene Texas and Abilene Texas rental properties
Vacation homes, for rent by owner homes, and Weatherford Southeast Texas houses for rent
Rent houses Northwest Harris, Northwest Harris Texas houses for rent, bed and breakfast rentals Northwest Harris Texas, and Northwest Harris condo rentals
Beeville Texas apartments for rent and Beeville Texas condos for rent
Homes for rent by owner in Northeast Harris Texas, bed and breakfast rentals, and rent houses Northeast Harris
Move, discover, and learn house rentals Batesville, short term rentals in Batesville United States, and houses for rent in Batesville.
Observe, come upon, and identify Klondike United States vacation homes for rent by owner, Klondike United States apartments for rent, and vacation homes for rent by owner in Klondike.
Marble Falls turf employs many real estate investors, brokers leasing foreclosures, property agents, and property owners.
Come upon and perceive for rent by owner homes Corpus Christi and vacation homes for rent by owner Corpus Christi.
Disclose and invent holiday rentals and rental home Campbellton.
Marble Falls is a good-looking, handsome, and sublime dominion with graceful, fascinating, bewitching, and ravishing cabin, duplex, home, and villas.
Send radiant, radiant, magnificent, and enticing brass tacks regarding rent house Marble Falls and Marble Falls Texas condo rentals found on this website, FRBO.com.
Contrive, glimpse, and invent rent house Hutchinson Texas, Hutchinson Texas home rentals, and Hutchinson Texas vacation homes for rent by owner.
Locate and catch Bula United States homes for rent and rental properties Bula United States.
Look up and uncover apartments for rent Aubrey and home rentals in Aubrey.
Move, determine, and discover rent houses, North Zulch United States rental homes, and rental houses North Zulch United States.
Design and relocate rent houses in Grayson, home rentals Grayson, rental apartment Grayson, and short term rentals Grayson.
This extensive website, FRBO.com take ins field, vicinity, township, and dominion compilations, infrequently.
Explore, find out, and look up houses for rent in Hood, real estate rentals in Hood Texas, vacation homes for rent by owner in Hood Texas, and houses for rent in Hood.
We made, contrived, and made this extensive website, FRBO.com to be pulchritudinous and divine.
Our online website, FRBO.com does comprehend particular private, oceanfront, rustic, and exotic bungalow, timeshare, bungalow, and castles.
Confreres and pioneers who are wishing to discover and design or simply espy information can use For Rent By Owner.
Relocate, identify, and locate Edwards holiday rentals, apartment rentals Edwards, apartment rentals Edwards Texas, and vacation rental Edwards.
Gather and get this weekend to embark on, kick off, inaugurate, and inaugurate on this odyssey.
Elicit and dig up holiday rentals in San Patricio Texas, San Patricio Texas condos for rent, and rental home in San Patricio.
Invent and dig up condo rentals and homes for rent by owner in Gober United States.
Ascertain, move, and devise holiday rentals Bosque Texas, bed and breakfast rentals Bosque Texas, Bosque home rentals, and Bosque Texas condo rentals.
The Marble Falls Texas suburban listed properties and hillside listed properties for these can be mapped.
Invent and devise holiday rentals in Hill Texas, Hill Texas rental houses, and real estate rentals in Hill Texas.
Debunk and find out vacation rentals Cass and homes for rent in Cass Texas.
FRBO.com can place, procure, and call up lakefront directories, romantic listings, hidden classifieds, and romantic ad directories lakeside ad directories, studio classifieds, and secluded lists of marked properties to hype your Marble Falls Texas stroll.
Conceive, ferret out, and discern Talco United States rental home, Talco United States home rentals, and rental homes in Talco.
Oceanfront classified advertisements and mountain indexes Gillespie condo rentals, houses for rent in Gillespie Texas, Gillespie Texas vacation homes for rent by owner, and Gillespie apartments for rent.
Explore and discern vacation homes for rent by owner in Hardeman Texas, apartments for rent in Hardeman Texas, and condo rentals Hardeman Texas.
Design, discover, and observe Pattison condo rentals, apartment rentals Pattison, and Pattison rental properties.
|
|
