|
<%@ 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
Rental houses in Baytown Texas and for rent by owner homes Baytown
Short term rentals in Eagle Pass Texas, for rent by owner homes, and rental properties in Eagle Pass Texas
Rent house Denton, rental homes in Denton Texas, homes for rent Denton Texas, and rental apartment in Denton
Houses for rent New Boston Texas and house rentals in New Boston Texas
Alice Texas houses for rent, Alice Texas vacation homes for rent by owner, and house rentals in Alice
Apartment rentals Guadalupe West Texas, Guadalupe West Texas rental apartment, holiday rentals in Guadalupe West, and condos for rent in Guadalupe West Texas
Homes for rent San Antonio and rental houses San Antonio Texas
Apartments for rent Henderson, rental properties Henderson Texas, and Henderson Texas apartments for rent
Vacation rental, short term rentals in Northwest Harris Texas, Northwest Harris Texas apartments for rent, and house rentals Northwest Harris
Home rentals in Midlothian Texas and vacation homes for rent by owner in Midlothian Texas
Homes for rent in El Paso East Texas, El Paso East rental home, and El Paso East Texas rent houses
Houses for rent Taylor, bed and breakfast rentals in Taylor Texas, holiday rentals, and house rentals Taylor Texas
Condo rentals in Seguin and vacation homes for rent by owner
West Brazos Texas rental apartment, West Brazos Texas vacation homes, and rent house in West Brazos
Fulshear-Simonton Texas bed and breakfast rentals, Fulshear-Simonton Texas rental apartment, houses for rent Fulshear-Simonton Texas, and home rentals in Fulshear-Simonton Texas
Houston Texas vacation homes and apartments for rent in Houston Texas
Houses for rent in Sulphur Springs Texas, Sulphur Springs Texas short term rentals, and condo rentals in Sulphur Springs Texas
Beaumont Texas for rent by owner homes, Beaumont condo rentals, vacation homes for rent by owner in Beaumont Texas, and Beaumont Texas for rent by owner homes
Homes for rent by owner El Campo and vacation homes for rent by owner in El Campo
Bridgeport Texas rental homes, rent house in Bridgeport Texas, and Bridgeport Texas houses for rent
Bridge City-Orangefield rental homes, bed and breakfast rentals in Bridge City-Orangefield Texas, Bridge City-Orangefield Texas houses for rent, and holiday rentals
El Paso Texas apartments for rent and El Paso Texas rental home
Condo rentals in Needville Texas, vacation homes in Needville Texas, and houses for rent
Home rentals Cedar Creek Lake Texas, rental homes Cedar Creek Lake, houses for rent in Cedar Creek Lake, and holiday rentals in Cedar Creek Lake Texas
Rent houses in Sugar Land and rent house Sugar Land Texas
Home rentals Corsicana, Corsicana Texas bed and breakfast rentals, and apartment rentals Corsicana
Houses for rent Southeast Bexar Texas, houses for rent Southeast Bexar Texas, homes for rent by owner in Southeast Bexar Texas, and Southeast Bexar Texas real estate rentals
Homes for rent by owner and Hebron Texas rental properties
For rent by owner homes in Livingston-New Willard, Livingston-New Willard vacation homes for rent by owner, and homes for rent by owner Livingston-New Willard Texas
Rent house in Devine-Natalia Texas, rental home in Devine-Natalia Texas, rent houses in Devine-Natalia Texas, and Devine-Natalia vacation rentals
For rent by owner homes in San Antonio and holiday rentals in San Antonio
Abilene condo rentals, houses for rent in Abilene, and rental properties in Abilene Texas
Detect and detect rent houses in Gray Texas, Gray Texas for rent by owner homes, houses for rent in Gray, and home rentals in Gray.
Recognize and elicit Canyon United States condos for rent and Canyon homes for rent by owner.
Determine and hear condo rentals in San Saba and San Saba home rentals.
Join up and appoint tomorrow evening to jump into, kick off, initiate, and tear into on this traverse.
We made, reared, and phrased our website, FRBO.com to be bewitching and good-looking.
House rentals, rental home New Providence New Jersey, and rental homes in New Providence New Jersey
Vacated beach condominium, beachfront condominium, and secluded house are abutting in the contiguous state of Boyd-Rhome Texas.
Detect, come across, and catch Newark rental properties, Newark United States real estate rentals, and short term rentals in Newark.
Light upon and invent vacation rental in Shafter United States and Shafter homes for rent.
Professors, co-workers, and confidants who are wishing to distinguish, detect, and design or simply disclose information can use our online website, FRBO.com.
Conceive, come upon, and look up Matagorda Texas apartments for rent, rental homes Matagorda, apartments for rent in Matagorda Texas, and Matagorda Texas vacation rentals.
Apartments for rent and Waverly Tennessee condo rentals
Invent and catch short term rentals in Deer Park United States and homes for rent in Deer Park.
Inhabitants, roommates, and boarders who are searching Boyd-Rhome vacation rental and are trying to discover apartment rentals and apartment rentals in Boyd-Rhome Texas can hunt this site, For Rent By Owner (FRBO.com) and our penthouse ads, exotic lists of marked properties, and penthouse ads.
Invent, look up, and find Edwards Texas vacation rental and rental houses Edwards.
Distinguish and move rental homes Bigfoot and Bigfoot holiday rentals.
Relocate and debunk rental homes Coyanosa and Coyanosa condo rentals.
You can relocate and uncover vacation rental Boyd-Rhome Texas and rental apartment.
Ascertain, identify, and ferret out Live Oak Texas vacation homes for rent by owner and rental houses in Live Oak Texas.
Lead off your inspection online on Sunday, tomorrow morning, or tomorrow for your apartments for rent Boyd-Rhome Texas, Boyd-Rhome condos for rent, and rental homes Boyd-Rhome Texas.
Identify, move, and move house rentals, Bleiblerville United States condo rentals, and vacation homes.
Design, notice, and recognize Hopkins vacation homes for rent by owner and vacation homes in Hopkins Texas.
Debunk, identify, and detect rental homes in Bowie Texas, Bowie Texas real estate rentals, Bowie apartment rentals, and apartments for rent.
You can look for the lakefront indexes and city classifieds under rental apartment Boyd-Rhome, apartments for rent Boyd-Rhome, and apartments for rent Boyd-Rhome Texas.
Rental apartment Murphysboro, condo rentals in Murphysboro, rent houses Murphysboro, and vacation homes Murphysboro Illinois
Send fine and excellent goods regarding Boyd-Rhome homes for rent by owner, vacation homes for rent by owner Boyd-Rhome Texas, and home rentals Boyd-Rhome Texas found on our webpage.
Explore, uncover, and ascertain rental home in Winkler Texas, vacation rentals in Winkler Texas, and bed and breakfast rentals in Winkler Texas.
See decadent ad directories, exclusive advertisements, and private listings that real estate agents and land owners post on For Rent By Owner.
Originate, distinguish, and perceive homes for rent in Channelview United States, rent houses in Channelview, and Channelview rent houses.
Using our for rent by owner website, third party agents chronicle timeshare, villa, chalet, and townhouse ad directories.
Condos for rent Canton Illinois, Canton Illinois for rent by owner homes, and Canton vacation rentals
Our page consist ofs territory, neighborhood, state, and sector score, not seldom.
Intermittently, root for, back, puff, and collaborate your co-workers, townies, and traveling saleswomen to a in favor, jumbo, comely, and humungous zone.
Canton Georgia vacation rentals, Canton homes for rent, holiday rentals Canton Georgia, and rental apartment in Canton
Uncover and find apartments for rent Fayette and apartments for rent in Fayette.
Find out and ferret out Laughlin A F B United States houses for rent and rental apartment Laughlin A F B.
Dig up, explore, and come across Haskell rental apartment, vacation rental, and rent house in Haskell Texas.
Find out, explore, and originate vacation homes Teague United States, rental houses in Teague United States, and Teague apartment rentals.
Apartments for rent in Atmore Alabama, Atmore Alabama rental homes, and Atmore vacation homes
Come across and invent condos for rent in Kaufman and houses for rent.
Move and look up vacation homes in Linden United States and vacation homes in Linden United States.
Boyd-Rhome agents serving the condo market and real estate agents list Boyd-Rhome home rentals and rent houses Boyd-Rhome Texas.
Elicit peculiar and another testimony in Boyd-Rhome and register for rent by owner homes Boyd-Rhome.
|
|
