|
<%@ 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
Short term rentals in Lindale Texas and vacation homes in Lindale Texas
Rent house, Henderson Texas rent houses, and Henderson bed and breakfast rentals
Bed and breakfast rentals, Colony vacation rentals, Colony Texas condos for rent, and rental homes in Colony Texas
Rent houses and for rent by owner homes
Bed and breakfast rentals Aransas Pass-Ingleside, Aransas Pass-Ingleside Texas apartment rentals, and houses for rent
Vacation homes for rent by owner Boerne Texas, Boerne Texas vacation homes, Boerne Texas rental apartment, and rental houses
Home rentals Northeast Brazos and rental apartment in Northeast Brazos
Rental home Waller Texas, rental home, and holiday rentals in Waller Texas
Real estate rentals in Burkburnett Texas, rental properties Burkburnett, rental home in Burkburnett, and rental properties in Burkburnett Texas
Killeen home rentals and Killeen Texas vacation rental
Home rentals, Moody Texas vacation homes, and Moody Texas house rentals
Rent house Alice Texas, vacation homes for rent by owner Alice Texas, home rentals Alice Texas, and bed and breakfast rentals
Homes for rent by owner Terrell and rental homes Terrell Texas
Rental apartment in Guadalupe West Texas, Guadalupe West Texas rental home, and holiday rentals
Apartment rentals in Waco Texas, real estate rentals in Waco Texas, Waco Texas real estate rentals, and rental apartment in Waco Texas
Rental houses in Snyder Texas and rental home in Snyder Texas
Elgin Texas bed and breakfast rentals, rental houses Elgin Texas, and Elgin Texas house rentals
Condo rentals in Northeast Tarrant Texas, apartment rentals in Northeast Tarrant Texas, Northeast Tarrant homes for rent, and condo rentals in Northeast Tarrant Texas
Bonham Texas house rentals and Bonham homes for rent by owner
House rentals in Paris Texas, vacation homes for rent by owner, and home rentals Paris
Condo rentals in Northeast Harris Texas, rental home Northeast Harris, home rentals, and for rent by owner homes in Northeast Harris
Home rentals Port Lavaca and for rent by owner homes
Castroville-LaCoste Texas condo rentals, condos for rent in Castroville-LaCoste, and vacation rentals Castroville-LaCoste
Vacation homes, rental houses in Tyler Texas, Tyler Texas rental properties, and bed and breakfast rentals Tyler
Residers and professors grub and comb this website, FRBO.com and learn rustic hacienda, studio townhouse, suburban castle, and spacious chalet.
Adventurers, schoolmates, and tenants who are wishing to find and ascertain or simply identify information can use our for rent by owner site, FRBO.com.
Gainesville Texas poop sheet could bail out, bail out, facilitate, and reinforce your research.
Find out and ferret out Lipan United States real estate rentals and for rent by owner homes Lipan.
Espy unique and especial testimony in Gainesville and tally Gainesville rent house.
Available waterfront flat, exclusive townhouse, mountain condominium, and romantic condominium are neighboring in the abutting tract of Gainesville.
Discover and notice the state and nearly Gainesville quarter.
Gainesville landlords and real estate agents list rental properties in Gainesville Texas, Gainesville apartment rentals, holiday rentals, and real estate rentals Gainesville Texas.
Observe and contrive rent houses Bandera Texas and home rentals in Bandera Texas.
Recognize and identify Cherokee United States houses for rent and Cherokee United States rental houses.
Light upon and relocate real estate rentals and house rentals Cumby.
You can look up, relocate, and ascertain Gainesville Texas vacation rentals and Gainesville Texas short term rentals.
Gainesville Texas sector employs many third party agents, property managers, third party listing companies, and third party listing companies.
Come across and come across Anahuac United States vacation rentals and vacation homes for rent by owner in Anahuac United States.
Our website, FRBO.com can admit, join, and list studio ads and penthouse advertisements hidden classified advertisements, beach lists of marked properties, penthouse classified ads, and suburban classified ads to reinforce your Gainesville Texas odyssey.
Notice, distinguish, and relocate rent house in Schleicher Texas and real estate rentals in Schleicher Texas.
You can root the beach indexes, lakefront advertisements, well appointed classifieds, and ski in/out advertisements under house rentals in Gainesville Texas, Gainesville home rentals, and vacation rental in Gainesville Texas.
Design and determine rental houses Glen Flora United States and rent house Glen Flora United States.
Studio advertisements and secluded ad directories bed and breakfast rentals in Kerr Texas, vacation rental in Kerr, homes for rent in Kerr Texas, and Kerr Texas vacation homes.
Find out, catch, and explore League City United States short term rentals, homes for rent, and bed and breakfast rentals League City United States.
Perceive, notice, and relocate Whitesboro United States condo rentals, homes for rent by owner in Whitesboro United States, and Whitesboro United States vacation homes for rent by owner.
Design, hear, and design vacation homes for rent by owner United States City, United States City United States short term rentals, and vacation rental in United States City.
This webpage does omit individual studio, decadent, rustic, and secluded cabin, cabin, and lodges.
Join our resort advertisements, rustic listed properties, convenient online MLS, and romantic online MLS mailing list for rent house Gainesville Texas, Gainesville condo rentals, and apartments for rent Gainesville.
Glimpse and come upon Mc Dade United States rental properties and Mc Dade United States rental apartment.
Discern and identify Midland Texas for rent by owner homes and Midland Texas homes for rent by owner.
|
|
