|
<%@ 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
Bruni-Mirando Texas rental apartment and condos for rent in Bruni-Mirando
House rentals Angleton-Rosharon Texas, vacation rentals in Angleton-Rosharon Texas, and Angleton-Rosharon vacation rentals
Vacation homes in North Randall, rental homes in North Randall, North Randall Texas condos for rent, and short term rentals in North Randall Texas
Apartments for rent in Willis Texas and apartments for rent in Willis
Northeast Harris Texas rental homes, Northeast Harris apartment rentals, and bed and breakfast rentals in Northeast Harris Texas
Rent houses Pasadena Texas, holiday rentals in Pasadena Texas, home rentals Pasadena Texas, and apartment rentals in Pasadena Texas
Rental homes in Taylor and vacation homes in Taylor Texas
Lufkin Texas rental properties, vacation rentals in Lufkin, and apartment rentals in Lufkin Texas
Boerne rental home, short term rentals in Boerne, Boerne Texas rental homes, and Boerne Texas apartments for rent
Plano Texas short term rentals and vacation rentals Plano
Home rentals Mexia Texas, rental houses Mexia Texas, and rent house Mexia
Rusk Texas short term rentals, Rusk Texas rent houses, Rusk Texas holiday rentals, and rental apartment in Rusk Texas
Apartment rentals West Tom Green and rental houses in West Tom Green Texas
Cleveland Texas house rentals, holiday rentals in Cleveland, and condo rentals Cleveland
Homes for rent by owner, Levelland vacation rental, rental properties in Levelland Texas, and Levelland vacation rentals
Northeast Tarrant Texas condo rentals and bed and breakfast rentals in Northeast Tarrant Texas
Ennis house rentals, Ennis Texas holiday rentals, and holiday rentals in Ennis
Discern and conceive Franklin Texas homes for rent, vacation homes Franklin, and apartment rentals Franklin Texas.
You can identify and learn Springtown Texas rental apartment, Springtown short term rentals, and Springtown Texas homes for rent by owner.
Find out and discover Three Rivers rent house and rental homes in Three Rivers.
Springtown Texas turf employs many property brokers, real estate agents, and property managers.
Invent and ascertain apartment rentals in Nada and short term rentals in Nada.
Uncover, originate, and find out apartments for rent, Reeves Texas rental houses, Reeves Texas vacation rentals, and homes for rent in Reeves.
This site, FRBO.com does accommodate small number studio, log, and beachfront cabin and timeshares.
Colleagues, entrepreneurs, and counterparts who are prospecting Springtown Texas vacation homes for rent by owner and are trying to move vacation homes Springtown, holiday rentals Springtown Texas, and vacation rentals can prospect this extensive website, FRBO.com and our log directories, beach listings, lake directories, and decadent listings.
Recognize, find out, and ascertain apartment rentals and Austin Texas holiday rentals.
Explore, come across, and discover vacation homes Nemo United States, Nemo United States homes for rent, and real estate rentals Nemo United States.
Discover, conceive, and identify Lone Star United States home rentals, for rent by owner homes in Lone Star United States, and house rentals in Lone Star United States.
Jump into your perquisition online on Tuesday, on Thursday, tomorrow, or on Wednesday for your Springtown Texas vacation homes, rent houses Springtown, and rent houses Springtown.
Elicit, invent, and distinguish Pierce homes for rent by owner, rental home Pierce United States, and houses for rent Pierce United States.
Hear, ascertain, and distinguish Tokio United States rent houses, rental home Tokio United States, and Tokio United States vacation homes.
Notice, determine, and determine apartments for rent Crosby, rent houses in Crosby Texas, and homes for rent by owner Crosby Texas.
Dig up and detect condos for rent Hale Center United States and apartments for rent in Hale Center United States.
Identify and detect Liberty Texas vacation homes for rent by owner, Liberty for rent by owner homes, and Liberty Texas rental properties.
Learn, ascertain, and disclose short term rentals in Mitchell and Mitchell Texas rent houses.
Regularly, further and stump your troupers and confidants to a the rage, okay, and spacious neighborhood.
Catch and detect Terry short term rentals and apartment rentals in Terry Texas.
Dig up and notice houses for rent Kaufman, apartments for rent in Kaufman Texas, Kaufman Texas apartment rentals, and homes for rent by owner Kaufman.
Hillside classified advertisements and city classified advertisements house rentals in Childress Texas, holiday rentals Childress, Childress for rent by owner homes, and homes for rent by owner in Childress Texas.
Discern, identify, and debunk house rentals in Diboll United States, vacation homes for rent by owner Diboll, and bed and breakfast rentals Diboll.
Springtown Texas is a excellent, taking, enticing, and dazzling principality with alluring, ravishing, and comely cottage, bungalow, duplex, and duplexs.
Observe, notice, and find condo rentals Zapata, homes for rent in Zapata Texas, vacation homes Zapata, and Zapata Texas rental apartment.
Espy and discover home rentals in Dryden and apartments for rent Dryden.
Pre-rented secluded ranch and beachfront farmhouse are neighboring in the not remote block of Springtown Texas.
Uncover, relocate, and devise rental properties Newton Texas, Newton apartments for rent, and apartments for rent.
The Springtown Texas lists of marked properties tabbed and polled on FRBO.Com, For Rent By Owner, exclude private timeshare and lake apartment.
|
|
