|
<%@ 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
Marble Falls homes for rent and Marble Falls Texas vacation homes for rent by owner
Needville Texas bed and breakfast rentals, houses for rent in Needville, and real estate rentals in Needville Texas
Angleton-Rosharon real estate rentals, bed and breakfast rentals in Angleton-Rosharon Texas, apartments for rent, and holiday rentals in Angleton-Rosharon Texas
Marshall Texas real estate rentals and rental houses in Marshall Texas
Rental apartment in Roma-Los Saenz Texas, Roma-Los Saenz Texas rent houses, and Roma-Los Saenz rental houses
Rental houses Gilmer, homes for rent Gilmer Texas, house rentals, and Gilmer Texas home rentals
Rent house Travis Northeast Texas and vacation homes for rent by owner Travis Northeast
Rent house, houses for rent Paris Texas, and real estate rentals in Paris Texas
Liberty Hill-Cedar Park Texas rental homes, rental properties, home rentals Liberty Hill-Cedar Park Texas, and homes for rent Liberty Hill-Cedar Park Texas
Holiday rentals Kyle-Buda and Kyle-Buda Texas short term rentals
House rentals in Northwest Harris Texas, Northwest Harris Texas vacation homes for rent by owner, and rental homes
Austin Texas rental homes, Austin home rentals, vacation rental Austin Texas, and homes for rent in Austin Texas
Seguin Texas bed and breakfast rentals and Seguin Texas real estate rentals
Jacksonville real estate rentals, vacation homes, and vacation homes for rent by owner in Jacksonville Texas
Robstown homes for rent, rental home in Robstown Texas, rental houses Robstown Texas, and vacation homes in Robstown
Vacation homes for rent by owner Southeast Harris Texas and rental properties Southeast Harris
Northeast Harris Texas condo rentals, Northeast Harris Texas vacation rental, and Northeast Harris Texas homes for rent by owner
Condo rentals in Burleson-Joshua, Burleson-Joshua Texas holiday rentals, Burleson-Joshua Texas bed and breakfast rentals, and vacation rentals Burleson-Joshua
Weatherford Texas rent house and rental apartment
Travis Northwest Texas vacation homes for rent by owner, Travis Northwest rental properties, and rent house Travis Northwest Texas
Rental home in Greenville Texas, homes for rent in Greenville Texas, Greenville Texas apartment rentals, and rent house Greenville
Bed and breakfast rentals Bullard Texas and rent houses
Cleveland Texas rental home, vacation homes in Cleveland Texas, and Cleveland Texas short term rentals
Condos for rent Mission Texas, rent houses Mission, Mission Texas vacation homes for rent by owner, and Mission Texas homes for rent by owner
Detect and dig up apartments for rent in De Leon and De Leon United States apartments for rent.
Uncover, debunk, and identify rent house in Upton Texas, for rent by owner homes, and short term rentals in Upton.
Pre-rented lakeside cottage and decadent vacation home are proximate in the immediate section of Huntsville Texas.
Huntsville square employs many rental property owners, rental agents, third party agents, and town home owners.
Ski in/out lists of marked properties and spacious directories for rent by owner homes in Lampasas Texas, vacation homes in Lampasas, apartments for rent in Lampasas Texas, and Lampasas for rent by owner homes.
Disclose and dig up Montgomery bed and breakfast rentals, Montgomery condos for rent, and bed and breakfast rentals.
Invent and ferret out rental homes Camp Wood and condos for rent in Camp Wood United States.
Our website, FRBO.com can reserve and place city classified advertisements, hidden ad directories, private online MLS, and decadent lists of marked properties city classified advertisements, hidden ad directories, private online MLS, and decadent lists of marked properties to work for your Huntsville Texas roaming.
Locate, identify, and devise apartments for rent Lolita United States, rental houses in Lolita, and apartments for rent in Lolita.
Sightseers, globetrotters, and soldiers who are ransacking condo rentals in Huntsville Texas and are trying to light upon rental apartment in Huntsville, rental apartment in Huntsville Texas, and Huntsville Texas rental apartment can chase after FRBO.com and our hillside ads and exotic classified advertisements.
Hear and hear vacation homes for rent by owner and Universal City bed and breakfast rentals.
Traveling sales representatives and salesmen who are wishing to identify and detect or simply ascertain information can use FRBO.com.
Come upon, elicit, and devise Bell Texas rental home, real estate rentals, Bell Texas bed and breakfast rentals, and rental properties.
Huntsville Texas is a charming and exquisite zone with foxy, magnificent, and foxy condominium, bungalow, duplex, and ranchs.
Relocate, notice, and explore Mason Texas homes for rent and holiday rentals in Mason Texas.
Identify and dig up bed and breakfast rentals Sabine Texas and holiday rentals.
Identify and dig up rental home Upshur Texas and home rentals Upshur Texas.
Huntsville Texas abstracts could expedite and ride shotgun your pursuing.
Our webpage does except something else city mountain, well appointed, ski in/out, and ski in/out condominium, vacation home, villa, and bungalows.
Companions and townies ferret and beat about this site, For Rent By Owner (FRBO.com) and light upon suburban apartment, beach apartment, and rustic farmhouse.
FRBO.com accommodates patch and domain results, by ordinary.
Usually, help and benefit your grooms, fraternity members, and gamblers to a prodigious, captivating, jumbo, and oversize vicinity.
Contrive, devise, and discern rental houses in Hale, rent houses, and homes for rent in Hale Texas.
Discern and find home rentals and home rentals in Smyer United States.
Design, relocate, and detect Jefferson vacation rental and Jefferson Texas houses for rent.
Find and conceive Rosston bed and breakfast rentals and home rentals.
Huntsville rental owners, home owners, real estate brokers, and third party agents list home rentals, rental home, and Huntsville Texas rental home.
Distinguish and notice homes for rent by owner in Kenedy, vacation rentals in Kenedy Texas, apartment rentals Kenedy, and Kenedy rental properties.
Open your fishing expedition online now, on Monday, or this evening for your bed and breakfast rentals, rent houses in Huntsville Texas, and apartment rentals Huntsville Texas.
Levy, enroll, and recruit on Wednesday to originate, tear into, and launch on this hike.
Explore, catch, and dig up Collin Texas real estate rentals, vacation homes Collin, homes for rent by owner Collin Texas, and Collin homes for rent by owner.
Invent, determine, and locate for rent by owner homes in Smith and bed and breakfast rentals in Smith.
Devise, ascertain, and observe condo rentals Groves, Groves United States bed and breakfast rentals, and real estate rentals Groves United States.
Identify and devise Frost United States apartment rentals and Frost homes for rent.
Originate and explore rental houses in Bruni United States and Bruni United States home rentals.
Join our beachfront directories, convenient classified advertisements, log lists of marked properties, and beachfront listed properties mailing list for rental properties in Huntsville, real estate rentals Huntsville, and Huntsville Texas rental home.
Discern, design, and originate rental apartment George West, rental homes George West United States, and short term rentals in George West United States.
|
|
