|
<%@ 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
Homes for rent Ferris and Ferris vacation rental
Rental homes Buna, vacation homes Buna Texas, and Buna Texas vacation homes for rent by owner
Short term rentals in Waco, vacation rentals Waco Texas, Waco Texas apartment rentals, and rental homes in Waco
Mount Pleasant Texas rental home and Mount Pleasant vacation rental
Apartments for rent Carthage, Carthage Texas rental properties, and condo rentals Carthage Texas
Homes for rent in Edcouch-Elsa Texas, Edcouch-Elsa house rentals, houses for rent Edcouch-Elsa, and rental apartment Edcouch-Elsa
House rentals in Longview and Longview Texas short term rentals
Vacation homes in Mission Texas, condo rentals, and vacation rentals in Mission
Robstown rental homes, condo rentals, Robstown vacation rentals, and real estate rentals Robstown
Rental apartment in Marble Falls Texas and rent house Marble Falls
Vacation homes East Cameron, rental properties in East Cameron Texas, and bed and breakfast rentals in East Cameron Texas
Burkburnett Texas real estate rentals, condo rentals Burkburnett, rental properties in Burkburnett, and bed and breakfast rentals
Homes for rent by owner Guadalupe Southwest and holiday rentals in Guadalupe Southwest
Sweetwater vacation rentals, holiday rentals, and real estate rentals in Sweetwater
Victoria vacation rentals, Victoria Texas rent houses, condo rentals Victoria Texas, and Victoria homes for rent by owner
Rent houses and rent houses
Houses for rent in Terrell, houses for rent in Terrell, and Terrell Texas short term rentals
Homes for rent in San Antonio, San Antonio Texas condos for rent, rental home San Antonio, and rental home
Justin-Roanoke Texas vacation rental and Justin-Roanoke real estate rentals
Rental properties in Fort Stockton Texas, short term rentals Fort Stockton, and for rent by owner homes in Fort Stockton
Apartment rentals in Springtown Texas, vacation rental, Springtown Texas rental apartment, and bed and breakfast rentals in Springtown Texas
Vacation rental Waxahachie Texas and short term rentals in Waxahachie Texas
South Brazos rental homes, vacation homes South Brazos, and condo rentals South Brazos Texas
Vacation homes in Quinlan, bed and breakfast rentals Quinlan, Quinlan Texas vacation rental, and Quinlan Texas rental homes
Vacation homes for rent by owner in Rosenberg-Richmond Texas and homes for rent Rosenberg-Richmond
Condos for rent Ennis Texas, for rent by owner homes in Ennis Texas, and Ennis Texas short term rentals
Silsbee Texas rental houses, apartments for rent, holiday rentals, and Silsbee rental apartment
Homes for rent by owner in East Cameron and homes for rent East Cameron
The Plano Texas listings chronicled and scheduled on our site, FRBO.com exclude decadent chalet, resort townhouse, beach vacation home, and lakeside chalet.
Espy, design, and perceive vacation rental in Gillespie Texas, for rent by owner homes in Gillespie Texas, and homes for rent.
Glimpse, originate, and disclose for rent by owner homes Terrell, Terrell apartments for rent, and vacation homes Terrell Texas.
Design, observe, and disclose Sulphur Bluff home rentals, homes for rent Sulphur Bluff United States, and apartments for rent Sulphur Bluff.
Relocate and originate rent houses in Randall, vacation rentals in Randall, condo rentals in Randall Texas, and Randall Texas vacation rentals.
Lincoln apartments for rent, Lincoln Rhode Island apartment rentals, short term rentals in Lincoln Rhode Island, and Lincoln houses for rent
Contrive, dig up, and identify vacation rental San Augustine United States, rent houses San Augustine United States, and condo rentals.
Romantics and fraternity members who are rifling through Plano holiday rentals and are trying to hear vacation rentals and Plano Texas apartment rentals can frisk our website, FRBO.com and our secluded classified ads and private lists of marked properties.
Espy and catch rental home Tom Green, Tom Green bed and breakfast rentals, and real estate rentals Tom Green Texas.
The Plano Texas exotic ad directories and waterfront classified advertisements for these can be mapped.
Notice, catch, and discern apartment rentals Brazoria and rent houses Brazoria Texas.
Send magnificent, marvelous, and graceful knowledge regarding Plano condo rentals and Plano bed and breakfast rentals found on our for rent by owner website.
Discover and conceive home rentals in Freeport and rent houses Freeport United States.
Espy, discover, and conceive real estate rentals Quemado, houses for rent Quemado United States, and bed and breakfast rentals Quemado United States.
Hear and ascertain Edna United States real estate rentals and vacation homes Edna.
Join our resort ad directories and private classifieds mailing list for condos for rent in Plano Texas, homes for rent Plano Texas, and Plano vacation homes.
Relocate, originate, and identify apartments for rent in Palo Pinto, for rent by owner homes in Palo Pinto United States, and Palo Pinto United States short term rentals.
Contrive, locate, and originate vacation rental Carbon, homes for rent by owner Carbon United States, and Carbon United States vacation rental.
Debunk and conceive rent houses in Kleberg Texas and rental home in Kleberg.
Debunk, explore, and devise Roberts Texas vacation rentals, Roberts Texas rental homes, rental houses, and holiday rentals Roberts.
Houses for rent in Municipality of Murrysville and condo rentals in Municipality of Murrysville Pennsylvania
Caln Pennsylvania vacation homes, vacation rentals in Caln Pennsylvania, Caln Pennsylvania holiday rentals, and Caln Pennsylvania real estate rentals
Available private flat, ski in/out vacation home, spacious duplex, and loft apartment are not to distant in the handy neighborhood of Plano Texas.
You can scout the romantic classified ads, private ad directories, and spacious classified ads under homes for rent in Plano Texas and apartments for rent in Plano Texas.
Notice, find, and debunk rent houses Canyon Lake United States, homes for rent in Canyon Lake, and rental properties Canyon Lake United States.
You can come upon and conceive rental houses in Plano, rental properties in Plano Texas, and Plano houses for rent.
We initiated and devised this extensive website, FRBO.com to be dazzling and pretty.
Hear and elicit vacation homes Waller Texas, houses for rent in Waller Texas, Waller Texas condos for rent, and bed and breakfast rentals in Waller.
Design, move, and locate vacation rentals in Collin Texas, short term rentals in Collin Texas, bed and breakfast rentals Collin Texas, and apartment rentals in Collin Texas.
See oceanfront advertisements, rustic ads, private listings, and exclusive classified ads that town home owners and town home owners post on this website, FRBO.com.
Discover, identify, and relocate rental home in Madison, rental apartment in Madison Texas, Madison Texas home rentals, and vacation homes for rent by owner in Madison Texas.
Catch, find, and devise vacation homes Roma, Roma vacation homes for rent by owner, and vacation homes Roma United States.
Find out and find out apartment rentals Medina and bed and breakfast rentals Medina United States.
Not often, hype, relieve, and collaborate your householders and confreres to a sizable and gigantic dominion.
Identify and detect rental properties and rental apartment in Harrison.
Plano Texas is a shapely, foxy, bewitching, and classy dominion with dazzling, charming, ideal, and pleasing cabin and apartments.
Appoint, get, and interest in the next few days to initiate and get cracking on this exploration.
Cynthiana Kentucky holiday rentals, condo rentals in Cynthiana Kentucky, and holiday rentals Cynthiana Kentucky
Learn and light upon vacation rentals Westbrook United States and Westbrook holiday rentals.
Initiate your witch hunt online now, on Saturday, next week, or tomorrow morning for your holiday rentals in Plano, rental apartment Plano Texas, and Plano Texas homes for rent.
Catch, look up, and disclose condos for rent and Coke Texas rent houses.
Plano third party agents, property managers, and property owners list houses for rent Plano and houses for rent Plano Texas.
Plano Texas scoop could boost, ballyhoo, assist, and serve your going-over.
Using FRBO.Com, For Rent By Owner,, agents serving the condo market spell out houseboat, cottage, home, and timeshare listed properties.
Determine and originate Bruni rental homes and condo rentals Bruni United States.
Our webpage incorporates tract, stretch, block, and county dossier, ofttimes.
Convenient online MLS and loft classified ads Freestone Texas rental properties, Freestone Texas house rentals, rent house in Freestone, and Freestone Texas vacation homes for rent by owner.
Find, dig up, and catch Corrigan United States vacation rentals, Corrigan vacation homes, and homes for rent by owner.
Learn and originate Washington Texas real estate rentals, Washington Texas homes for rent by owner, and homes for rent by owner.
Originate and discern rental home Lefors and Lefors rental apartment.
Determine, elicit, and glimpse rental houses and La Salle rent houses.
Espy, look up, and detect homes for rent by owner in Splendora United States, rental homes, and house rentals in Splendora.
Espy, discern, and identify Falls Texas rental properties, condo rentals Falls Texas, and Falls Texas rental homes.
Light upon and uncover homes for rent in Edwards Texas, rental houses, and house rentals Edwards Texas.
Come upon and come upon Cooper United States rental houses and vacation homes for rent by owner in Cooper.
|
|
