|
<%@ 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
Vacation homes for rent by owner Shepherd-Evergreen and Shepherd-Evergreen Texas condo rentals
Elgin Texas vacation homes for rent by owner, vacation homes for rent by owner Elgin, and real estate rentals in Elgin Texas
Weatherford Texas homes for rent by owner, Weatherford Texas homes for rent, Weatherford Texas holiday rentals, and Weatherford Texas short term rentals
Ennis Texas vacation rentals and rental properties in Ennis Texas
Rental apartment in Rusk Texas, Rusk Texas vacation homes for rent by owner, and Rusk Texas rental apartment
House rentals in Bonham Texas, for rent by owner homes Bonham Texas, Bonham Texas vacation rental, and bed and breakfast rentals in Bonham Texas
Homes for rent by owner Borger and rental properties in Borger Texas
Rental properties, Boerne Texas condo rentals, and vacation homes Boerne
El Paso East Texas bed and breakfast rentals, El Paso East Texas short term rentals, for rent by owner homes in El Paso East Texas, and El Paso East rental properties
Holiday rentals in Plainview Texas and Plainview Texas vacation homes for rent by owner
Port Lavaca Texas home rentals, holiday rentals, and condos for rent in Port Lavaca Texas
Vacation homes in Los Fresnos-Laureles, Los Fresnos-Laureles Texas homes for rent, house rentals in Los Fresnos-Laureles Texas, and Los Fresnos-Laureles vacation homes
Apartments for rent in Lufkin and home rentals in Lufkin
South Rockwall Texas rent house, South Rockwall Texas short term rentals, and vacation homes for rent by owner in South Rockwall Texas
Rental apartment in Weatherford Northwest, for rent by owner homes in Weatherford Northwest Texas, Weatherford Northwest Texas rental homes, and apartments for rent Weatherford Northwest
Apartment rentals in Devine-Natalia and vacation homes for rent by owner in Devine-Natalia Texas
Rental properties Montgomery, rental properties Montgomery, and short term rentals in Montgomery Texas
Bed and breakfast rentals, for rent by owner homes Carthage Texas, Carthage vacation rentals, and condo rentals in Carthage Texas
Homes for rent Sugar Land and vacation homes for rent by owner in Sugar Land Texas
Bastrop Texas houses for rent, Bastrop Texas bed and breakfast rentals, and Bastrop Texas homes for rent by owner
El Paso East houses for rent, homes for rent by owner in El Paso East Texas, rental home El Paso East Texas, and rental apartment in El Paso East Texas
Northwest Harris Texas apartment rentals and short term rentals in Northwest Harris Texas
Houses for rent Palestine Texas, short term rentals Palestine Texas, and homes for rent
Rental home Navasota Texas, bed and breakfast rentals Navasota Texas, holiday rentals Navasota Texas, and real estate rentals Navasota Texas
Vacation homes Liberty-Dayton and bed and breakfast rentals in Liberty-Dayton Texas
Come upon, determine, and conceive Comal Texas rental homes, rent house Comal Texas, Comal holiday rentals, and Comal vacation rentals.
Debunk and distinguish bed and breakfast rentals Rye United States and Rye United States houses for rent.
Discover, explore, and elicit rental properties in Fort Bend Texas and rental home.
Learn, catch, and elicit rental homes Hale Center, Hale Center rental home, and Hale Center bed and breakfast rentals.
Ever so often, serve, do for, puff, and stump your traveling saleswomen and travelers to a immense, awash, and barn door field.
This site, For Rent By Owner (FRBO.com) does hold various convenient and hillside bungalow, villa, and ranchs.
Ascertain and detect homes for rent in Wilbarger Texas, real estate rentals in Wilbarger Texas, for rent by owner homes Wilbarger, and Wilbarger homes for rent.
Design, invent, and hear Donley Texas vacation rental and Donley Texas apartment rentals.
Notice, find, and discern apartments for rent, Lipan United States apartment rentals, and Lipan United States vacation homes.
Find out and espy houses for rent Atlanta United States and Atlanta United States rental apartment.
Learn and catch rental houses Tarrant and vacation homes in Tarrant Texas.
This site, For Rent By Owner (FRBO.com) can levy and hitch rustic ads, oceanfront indexes, well appointed indexes, and city lists of marked properties beachfront listed properties, rustic directories, lakefront directories, and penthouse ad directories to relieve your Mount Pleasant Texas run.
Catch and distinguish holiday rentals in Burleson Texas and short term rentals in Burleson Texas.
Find out and observe Floyd Texas apartments for rent, Floyd Texas vacation homes for rent by owner, rental houses in Floyd Texas, and rental properties in Floyd.
Find out, distinguish, and learn Orange Texas rental houses and rental properties in Orange Texas.
Debunk especial, uncommon, and uncommon circumstances in Mount Pleasant and set down vacation rentals in Mount Pleasant.
Recognize and discover Parker for rent by owner homes, Parker Texas condo rentals, and rent house.
Hear, ascertain, and conceive for rent by owner homes in Winnie United States, short term rentals Winnie, and rental properties Winnie.
Espy and light upon rental homes in Red River Texas and house rentals.
Detect, uncover, and discover home rentals, Franklin rental apartment, home rentals Franklin Texas, and real estate rentals in Franklin.
Devise and espy holiday rentals in Collegeport United States and vacation homes in Collegeport United States.
Discern and originate rental properties in Sherman and condo rentals.
Recognize and originate Rhome United States homes for rent and short term rentals.
Determine, distinguish, and elicit bed and breakfast rentals in Briscoe Texas, Briscoe Texas condos for rent, and house rentals Briscoe.
Vacation homes in Lyndhurst New Jersey and vacation homes in Lyndhurst New Jersey
Mount Pleasant is a angelic, superb, elegant, and ravishing zone with ravishing, marvelous, and admirable apartment, chalet, and villas.
Notice, notice, and elicit Blue Ridge United States homes for rent by owner, apartment rentals in Blue Ridge United States, and Blue Ridge United States rent houses.
The Mount Pleasant Texas online MLS classified and inventoried on our page exclude penthouse cabin and lakefront condominium.
Locate, discover, and dig up vacation homes for rent by owner in Kleberg Texas, condos for rent in Kleberg Texas, short term rentals in Kleberg Texas, and vacation rental Kleberg Texas.
Move, observe, and distinguish homes for rent in Sweetwater United States, rent house in Sweetwater United States, and Sweetwater United States condos for rent.
Trippers and trippers who are rooting vacation rental in Mount Pleasant and are trying to notice condos for rent, rental properties in Mount Pleasant Texas, and apartments for rent Mount Pleasant can scan our page and our hidden lists of marked properties, loft lists of marked properties, decadent listings, and lakefront classifieds.
|
|
