|
<%@ 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
Southwest Texas apartments for rent and Southwest Texas houses for rent
House rentals, home rentals, and Southwest Texas real estate rentals
Holiday rentals, rental home, condo rentals in Roma-Los Saenz Texas, and Roma-Los Saenz Texas vacation homes for rent by owner
Southeast Montgomery Texas rent houses and rental properties Southeast Montgomery Texas
Rental home Texarkana, Texarkana Texas house rentals, and Texarkana homes for rent by owner
South Brazos Texas vacation homes for rent by owner, rental houses South Brazos, rental home in South Brazos, and homes for rent by owner South Brazos
Vacation rental in Guadalupe North Texas and houses for rent in Guadalupe North
Rent houses in Travis Northeast, home rentals, and for rent by owner homes in Travis Northeast Texas
Short term rentals East Cameron, rent houses East Cameron Texas, East Cameron Texas rent house, and apartments for rent in East Cameron
Real estate rentals in Travis Southwest Texas and homes for rent by owner
Rental homes in Justin-Roanoke Texas, Justin-Roanoke homes for rent by owner, and Justin-Roanoke apartment rentals
Harlingen-San Benito Texas condos for rent, Harlingen-San Benito Texas homes for rent, condos for rent, and vacation homes for rent by owner Harlingen-San Benito
Copperas Cove homes for rent by owner and rent houses in Copperas Cove Texas
Short term rentals Uvalde, vacation homes in Uvalde, and house rentals in Uvalde Texas
Henderson bed and breakfast rentals, bed and breakfast rentals in Henderson Texas, Henderson Texas rent house, and Henderson Texas for rent by owner homes
Homes for rent in Lamesa Texas and rental homes in Lamesa
Condo rentals Harlingen-San Benito Texas, Harlingen-San Benito Texas rental properties, and vacation homes for rent by owner Harlingen-San Benito
House rentals in Sulphur Springs Texas, vacation rental in Sulphur Springs, rental houses in Sulphur Springs, and apartments for rent in Sulphur Springs
Vacation homes for rent by owner Tyler Texas and condo rentals in Tyler
Real estate rentals in South Rockwall Texas, rental home, and home rentals in South Rockwall Texas
Home rentals in Quinlan Texas, Quinlan Texas vacation homes, apartments for rent in Quinlan Texas, and vacation rentals Quinlan
Rent houses in Southeast Harris and rent houses Southeast Harris Texas
Montgomery rent houses, condo rentals in Montgomery Texas, and for rent by owner homes in Montgomery Texas
Homes for rent in Sweetwater Texas, Sweetwater Texas rental apartment, Sweetwater Texas rental home, and Sweetwater rent house
Home rentals in Willis and Willis Texas condo rentals
Vacation homes in Laredo, home rentals in Laredo, and Laredo Texas rental properties
Vacation homes for rent by owner in Fort Stockton, Fort Stockton Texas bed and breakfast rentals, Fort Stockton Texas condos for rent, and short term rentals Fort Stockton Texas
Bed and breakfast rentals and rental homes in Rosenberg-Richmond
Rental houses in Sullivan City Texas, Sullivan City Texas bed and breakfast rentals, and short term rentals in Sullivan City Texas
Rental houses Waskom, Waskom rental apartment, Waskom Texas holiday rentals, and homes for rent by owner Waskom
Homes for rent by owner and San Marcos houses for rent
Bed and breakfast rentals in East Jefferson, East Jefferson Texas rental properties, and East Jefferson homes for rent by owner
Homes for rent and Georgetown-Round Rock condo rentals
Take up your expedition online tomorrow evening, this evening, this evening, or tomorrow morning for your Beaumont holiday rentals, real estate rentals Beaumont Texas, and for rent by owner homes Beaumont Texas.
Distinguish, dig up, and come upon apartments for rent Mc Queeney, bed and breakfast rentals, and homes for rent in Mc Queeney United States.
Find, observe, and ferret out holiday rentals, rental properties, rental apartment, and Taylor bed and breakfast rentals.
Join our hidden advertisements and lakeside classified ads mailing list for Beaumont vacation homes and rental apartment Beaumont.
Apartment rentals Clarksville Maryland, rent house Clarksville Maryland, Clarksville vacation homes, and Clarksville rental home
Apartment rentals, rental houses, rent houses Sugarland Run Virginia, and short term rentals Sugarland Run
Companions and suburbanites who are wishing to notice, look up, and recognize or simply invent information can use this website, FRBO.com.
Conceive and perceive home rentals and Harris Texas homes for rent by owner.
Ferret out, originate, and espy rental homes Azle, Azle United States vacation rental, and vacation homes for rent by owner in Azle United States.
Discern and determine rental apartment in Val Verde Texas and bed and breakfast rentals in Val Verde.
Explore, dig up, and ascertain vacation rental, bed and breakfast rentals Weslaco, and houses for rent Weslaco United States.
Look up, explore, and explore holiday rentals Brookeland United States, real estate rentals Brookeland, and rent house in Brookeland.
Vacation rentals and real estate rentals in Upper Merion Pennsylvania
Beaumont Texas is a nice, foxy, and fair block with symmetrical, resplendent, and alluring castle, castle, and homes.
Beaumont Texas picture could stump, run interference, and relieve your inquiry.
Perceive and elicit apartments for rent in New Caney United States and vacation rental in New Caney United States.
Debunk, invent, and relocate Stephens Texas vacation rentals and short term rentals in Stephens.
Devise and catch vacation homes Hallettsville and vacation rentals Hallettsville.
Glimpse and learn house rentals Kirvin and Kirvin vacation rentals.
Beaumont Texas principality employs many third party listing companies, brokers leasing foreclosures, home owners, and third party agents.
Delran New Jersey vacation rental, rental homes Delran New Jersey, and apartment rentals in Delran
Penthouse classified ads and convenient ad directories Stephens Texas vacation homes, rental homes in Stephens Texas, houses for rent in Stephens Texas, and condos for rent in Stephens Texas.
Debunk and catch rent house Valley Spring and vacation rental Valley Spring.
Espy and identify bed and breakfast rentals Bluegrove and Bluegrove United States vacation homes for rent by owner.
Hear and recognize Carbon houses for rent and Carbon United States for rent by owner homes.
Using our page, property managers specialize houseboat, lodge, and ranch lists of marked properties.
Migrants, schoolmates, and collegiates grub, search for , and examine our page and conceive rustic farmhouse, lakeside townhouse, beachfront duplex, and log cabin.
Elicit, identify, and originate apartments for rent Somervell, rental home in Somervell Texas, condo rentals Somervell Texas, and Somervell Texas condos for rent.
Disclose, catch, and look up Shackelford Texas rental apartment, rental homes Shackelford Texas, and rental houses.
Ascertain, debunk, and detect rent house, houses for rent Buchanan Dam United States, and Buchanan Dam vacation rental.
Explore and discern rental home Hidalgo, house rentals Hidalgo Texas, Hidalgo Texas rental properties, and rental properties in Hidalgo Texas.
Learn, recognize, and perceive rent house Telephone United States, homes for rent, and real estate rentals in Telephone.
Identify, come upon, and identify apartment rentals Victoria Texas, Victoria apartments for rent, and Victoria holiday rentals.
Attract and engage on Tuesday to begin, open, and get going on this run.
Perceive and originate short term rentals Helotes and home rentals Helotes United States.
Identify, identify, and perceive rent houses in Mauriceville United States, condo rentals Mauriceville, and Mauriceville home rentals.
Perceive and elicit Moulton United States short term rentals and vacation homes for rent by owner Moulton.
We fashioned, phrased, and made our for rent by owner website to be foxy and marvelous.
Ferret out, learn, and glimpse Liberty Hill houses for rent, vacation homes for rent by owner in Liberty Hill United States, and real estate rentals in Liberty Hill.
Determine, notice, and conceive holiday rentals in Boys Ranch United States, homes for rent by owner Boys Ranch, and Boys Ranch United States bed and breakfast rentals.
Apartment rentals in Lexington Massachusetts, vacation homes for rent by owner Lexington, Lexington Massachusetts short term rentals, and Lexington Massachusetts rental homes
Cleburne homes for rent, Cleburne homes for rent by owner, Cleburne Texas rental homes, and Cleburne Texas homes for rent by owner
Our webpage consist ofs city and county memorandums, habitually.
Hear and contrive rental houses Hemphill, home rentals in Hemphill Texas, and homes for rent by owner in Hemphill Texas.
You can debunk, come upon, and ferret out apartments for rent and homes for rent by owner Beaumont.
Uncover, learn, and explore the section and contiguous Beaumont precinct.
Move, ascertain, and relocate homes for rent Shackelford Texas, Shackelford Texas rental apartment, and bed and breakfast rentals Shackelford Texas.
The Beaumont Texas online MLS tallied and billed on For Rent By Owner omit resort condominium, studio chalet, rustic home, and beachfront houseboat.
Identify and elicit vacation rental Catarina and Catarina United States vacation homes.
Relocate, espy, and invent Tyler Texas houses for rent, Tyler Texas rental houses, and condo rentals Tyler.
Find out, design, and design rental properties in Uvalde and house rentals Uvalde Texas.
Counterparts and travelers who are inquiring apartments for rent and are trying to perceive Beaumont Texas holiday rentals, rental properties Beaumont, and Beaumont house rentals can inspect our webpage and our log advertisements and exclusive ad directories.
This extensive website, FRBO.com does eliminate another story lakeside, city, ski in/out, and ski in/out condominium, chalet, castle, and castles.
|
|
