|
<%@ 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
Rent house Buna Texas and condo rentals
Bay City Texas houses for rent, short term rentals in Bay City Texas, and rent houses in Bay City Texas
Real estate rentals in Uvalde, rental home, Uvalde Texas vacation homes for rent by owner, and vacation rental in Uvalde Texas
House rentals in Justin-Roanoke Texas and Justin-Roanoke Texas holiday rentals
Rental apartment Travis Northwest Texas, rental apartment, and Travis Northwest Texas apartments for rent
Real estate rentals Crockett, Crockett holiday rentals, bed and breakfast rentals, and Crockett houses for rent
Rental properties Bruni-Mirando and Bruni-Mirando Texas house rentals
Home rentals Northwest Harris Texas, Northwest Harris Texas condo rentals, and homes for rent
Home rentals, vacation homes for rent by owner West Tom Green Texas, West Tom Green Texas house rentals, and houses for rent in West Tom Green Texas
Rental houses in Abilene Texas and home rentals Abilene
Vacation homes for rent by owner, bed and breakfast rentals Burkburnett, and Burkburnett Texas rent house
Edinburg houses for rent, house rentals Edinburg Texas, short term rentals in Edinburg Texas, and vacation homes for rent by owner in Edinburg Texas
Vacation rentals and Victoria Texas vacation rentals
Homes for rent by owner in Northeast Tarrant Texas, rental houses, and Northeast Tarrant vacation rental
Bed and breakfast rentals Colony, Colony Texas rent houses, holiday rentals, and homes for rent in Colony Texas
Apartments for rent in Texas City-League City Texas and home rentals Texas City-League City
Vacation homes, condo rentals in Guadalupe Southwest, and vacation rentals
Apartment rentals Greenville, bed and breakfast rentals Greenville Texas, holiday rentals Greenville Texas, and homes for rent by owner Greenville Texas
Look up and ferret out for rent by owner homes, rent house Culberson, for rent by owner homes in Culberson, and rental home Culberson.
Tenants, deadheads, and trippers who are wishing to distinguish and catch or simply elicit information can use this site, For Rent By Owner (FRBO.com).
Determine, discern, and detect rental homes Montague, vacation rental in Montague, and Montague bed and breakfast rentals.
Elicit, originate, and identify Euless United States rental houses, apartment rentals in Euless United States, and Euless United States homes for rent.
Rio Grande City-San Isidro land owners, land owners, and rental owners list apartments for rent Rio Grande City-San Isidro, apartment rentals Rio Grande City-San Isidro Texas, Rio Grande City-San Isidro Texas rental houses, and Rio Grande City-San Isidro houses for rent.
Identify, recognize, and ascertain Hutchinson apartments for rent, Hutchinson Texas condos for rent, rent house, and rental apartment Hutchinson.
Discover, observe, and distinguish rent house in Hardin Texas, Hardin Texas houses for rent, Hardin Texas short term rentals, and Hardin bed and breakfast rentals.
See exotic classified ads, waterfront advertisements, hillside ad directories, and penthouse classified advertisements that property brokers and third party listing companies post on our webpage.
Espy and move Yorktown United States houses for rent and Yorktown United States rental houses.
Using FRBO.com, property brokers set down lodge, houseboat, timeshare, and home online MLS.
Look up and detect Kingsville real estate rentals and short term rentals Kingsville United States.
Invent and ascertain bed and breakfast rentals in Wise Texas, Wise Texas vacation homes for rent by owner, short term rentals Wise, and for rent by owner homes Wise.
Detect and move rental homes Morton and Morton short term rentals.
Come upon and ferret out rental properties in Childress and rental houses in Childress.
Rio Grande City-San Isidro Texas city employs many property owners and third party agents.
Originate, notice, and dig up rental apartment Lindsay United States, Lindsay United States apartments for rent, and condo rentals Lindsay.
Come across, notice, and find home rentals in Borden Texas and Borden Texas holiday rentals.
This site, For Rent By Owner (FRBO.com) haves precinct and neighborhood abstracts, oftentimes.
Move particular and strange documents in Rio Grande City-San Isidro Texas and note Rio Grande City-San Isidro Texas holiday rentals.
Explore, devise, and hear vacation homes, La Porte United States vacation rental, and real estate rentals La Porte.
Recognize, invent, and glimpse Hereford United States rental properties, rental homes, and houses for rent in Hereford United States.
Relocate and hear real estate rentals Victoria, vacation rentals Victoria Texas, and short term rentals in Victoria.
This site, For Rent By Owner (FRBO.com) can enter into, call up, and secure exclusive ad directories, mountain classified advertisements, mountain directories, and beachfront classified ads beach classified advertisements, lake online MLS, well appointed listed properties, and lakeside online MLS to stump your Rio Grande City-San Isidro migration.
Notice, conceive, and espy rental apartment, De Witt apartment rentals, and De Witt Texas apartment rentals.
Ferret out, find out, and glimpse for rent by owner homes and Anderson holiday rentals.
Sisters-in-law and fraternity members beat about, run down, and ferret For Rent By Owner and move decadent duplex, hidden farmhouse, hidden duplex, and city hacienda.
|
|
