Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '45324625' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.471078' ,`Longitude` = '-95.510416' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724572.00' ,`Status` = 'Active' ,`StreetName` = 'Camille Park' ,`StreetNumber` = '1918' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3509' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 45324625 - Built by Toll Brothers, Inc. - Ready Now! ~ The popular 1.5 story Turner plan is filled with amazing features. The covered entry leads into a dramatic foyer with two-story ceiling. Glass doors and sloped ceiling in the office give an elegant yet private feel and is large enough for two work spaces. Your guests will appreciate the bedroom suite with full bath and walk-in closet just off the great room. Enjoy entertaining on movie night in the media room or relaxing in the upstairs flex/game room. The great room features 12-foot ceilings and is open to a desirable kitchen with large island, an abundance of cabinets, butler\'s pantry and walk-in pantry. The casual dining area is conveniently located off the kitchen with views to the backyard. A secluded and relaxing primary bedroom includes a tray ceiling and en-suite with a luxurious freestanding tub, ultra shower and spacious walk-in closet. Located in acclaimed Fort Bend ISD.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 3 Blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9511' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Sienna - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344189' WHERE `Matrix_Unique_ID` = '199716300' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '41662212' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150899' ,`Longitude` = '-95.584323' ,`PhotoCount` = '26' ,`PostalCode` = '77354' ,`RoomCount` = '11' ,`ListPrice` = '921861.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8538' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 41662212 - Built by Toll Brothers, Inc. - December completion! ~ Located on a corner home site with no rear neighbors, the Adalyn Italian Villa boasts a clean stucco finish that makes an impressive statement. This beautiful two-story home features soaring ceilings, private study, and formal dining room with views to the curved staircase. Open the multi-slide doors in the great room and expand your entertaining and living space to the covered porch. Additional highlights are a first-floor guest suite with full bath. The primary suite offers a tray ceiling and resort-style bath and spacious closet. Host game and movie nights in the flex/game space or media room. Outdoor toys will be covered in the huge 4-car tandem garage. This is the epitome of luxury living in a resort-style community!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 9 Blk 3' ,`LotDesciption` = 'Corner,Other' ,`LotSize` = '11718' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344189' WHERE `Matrix_Unique_ID` = '200571208' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:12:16.243' ,`MLSNumber` = '65197503' ,`ListAgentFullName` = 'Mary Pendleton-Brown' ,`ListOfficeName` = 'White Ivy Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.922819' ,`Longitude` = '-95.255828' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '182000.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Shore' ,`StreetNumber` = '378' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake Livingston Views from this spacious 3/2 home which sits on two lots in the sought-after neighborhood of Harbor Point where residents enjoy community amenities: Manned Gate Access; Boat ramp, putt-putt golf, pool; 2 parks and a brand new clubhouse. Enjoy the Lakeview from the front Sunroom, with ramp access .This home boasts several attractive features other than the Fantastic Water views. It has a formal foyer; family room with gas fireplace; formal dining room; spacious Kitchen/dining combo w/ breakfast area; Large utility room w/ office space, walk-in pantry; Sunroom; 3 storage sheds (2 on concrete slabs); back porch w/ storage space; Water feature; possible butterfly garden; lots of shade trees. Enjoy a cup of Joe w/sunrise or a glass of wine w/ sunsets on the custom deck with a view of the lake! With a little TLC this will make a great forever home or a perfect Weekend Lake Getaway! This one won\'t last!' ,`Acres` = '0.389' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric,Propane,Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOR POINT SECTION E, LOT 128' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '16547' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '203' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Harbor Point Sec E' ,`TaxAmount` = '1084' ,`TaxRate` = '1.6133' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665344189' WHERE `Matrix_Unique_ID` = '202155694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '27972860' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472116' ,`Longitude` = '-95.510829' ,`PhotoCount` = '16' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '699061.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10515' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 27972860 - Built by Toll Brothers, Inc. - Ready Now! ~ The Watson High Plains plan is a single-story plan with room to grow. The stucco and stone exterior provides curb appeal and welcomes you home. The covered entry opens to the foyer with tray ceiling. Two spacious secondary bedrooms and shared hall bath are split from the activity of the main living space. A secluded office with double-door entry provides an excellent remote working space. The gourmet kitchen features a casual dining room, and large center island with view to the great room. A breathtaking sloped ceiling in the great room extends onto the covered patio that can be accessed by 15-foot sliding glass doors that expand entertaining space to outdoor living space. Host game night in the game room just off the main living area. Guest will appreciate the bedroom suite with full bath. The primary bedroom offers privacy and includes an expanded shower and oversized walk-in closet. Dreams can come true!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 10 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9483' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna Select' ,`TaxAmount` = '' ,`TaxRate` = '3.72' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344189' WHERE `Matrix_Unique_ID` = '202874347' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '76432475' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.468092' ,`Longitude` = '-95.525340' ,`PhotoCount` = '17' ,`PostalCode` = '77459' ,`RoomCount` = '9' ,`ListPrice` = '549672.00' ,`Status` = 'Active' ,`StreetName` = 'Rustling Creek' ,`StreetNumber` = '1715' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2504' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76432475 - Built by Toll Brothers, Inc. - Ready Now! ~ The Waller Mission boast curb appeal with the stylish stucco exterior with shutters and covered entry. The impressive two-story foyer with tray ceiling flows into the secluded office with double doors. A spacious great room offers a multi-slide door that opens to an expanded back patio. The grand and private back yard has plenty of room for a future pool and outdoor recreational activities. The gourmet kitchen features a casual dining room, walk-in pantry and island that overlooks the great room. The first-floor primary bedroom includes dramatic sloped ceilings and ensuite bath with dual vanities, free standing tub with separate shower and walk-in closet with convenient access to the utility room. Additional highlights are three spacious bedrooms, one with private bath, shared hall bath and a loft overlooking the great room!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Blk 2' ,`LotDesciption` = 'Greenbelt,Other,Subdivision Lot' ,`LotSize` = '8693' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna - Villa Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344189' WHERE `Matrix_Unique_ID` = '202961781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '60947278' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.472147' ,`Longitude` = '-95.510670' ,`PhotoCount` = '27' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '724855.00' ,`Status` = 'Active' ,`StreetName` = 'Harvest Oak' ,`StreetNumber` = '10519' ,`StreetSuffix` = 'Court' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 60947278 - Built by Toll Brothers, Inc. - Ready Now! ~ The stunning Langdon Transitional is a two-story home that offers a spacious open concept. This home features a spacious guest bedroom on the main floor and a luxurious primary bedroom with sloped ceiling and en-suite with dual sinks, freestanding tub, and roomy walk-in closet. A generous office space makes for a great place for remote work or study. The generous cabinet and counter top space in the kitchen, is what makes this home perfect for any sized party. Atop the curved staircase, you will enjoy a large game/flex room and private media room with two secondary bedrooms and full bath. Filled with craftsmanship and quality you expect, with the luxury and premium finishes you deserve!!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'lot 11 blk 1' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '9244' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEONETTI ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Sienna - Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344189' WHERE `Matrix_Unique_ID` = '202968197' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '39102668' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.099473' ,`Longitude` = '-95.347974' ,`PhotoCount` = '26' ,`PostalCode` = '77386' ,`RoomCount` = '10' ,`ListPrice` = '799786.00' ,`Status` = 'Active' ,`StreetName` = 'Woodley' ,`StreetNumber` = '28261' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 39102668 - Built by Toll Brothers, Inc. - Ready Now! ~ LIMITED AVAILABILITY! The Quinton plan opens to a welcoming foyer with tray ceiling and a clear view of an expansive great room. Multi-slide doors lead to a generous covered patio with cathedral ceiling perfect for entertaining. Adjacent to an inviting front covered porch is a formal dining area that has pass through access to a well-appointed kitchen with a large center island. The primary bedroom is enhanced with a majestic cathedral ceiling, enormous walk-in closet with ultra shower and large soaking tub and dual-sink vanities. This home includes generous secondary bedrooms, two with Jack and Jill bath and one with full hall bath access. Additional highlights include a game room, versatile study off the great room and a useful resource center off the kitchen. Luxury and craftsmanship all in a single-story home.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Blk 1' ,`LotDesciption` = 'Cul-De-Sac,Other,Subdivision Lot' ,`LotSize` = '11030' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Woodson\'s Reserve' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344190' WHERE `Matrix_Unique_ID` = '203319030' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '31786152' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.150508' ,`Longitude` = '-95.585401' ,`PhotoCount` = '22' ,`PostalCode` = '77354' ,`RoomCount` = '12' ,`ListPrice` = '1039979.00' ,`Status` = 'Active' ,`StreetName` = 'Tynan Ridge' ,`StreetNumber` = '8522' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5165' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 31786152 - Built by Toll Brothers, Inc. - January completion! ~ The Venetian Calais plan offers luxurious style and design. The impressive exterior featuring a porte cochere with motor court, 3-car split garage, and covered front porch and patio, makes for great curb appeal. The foyer provides elegance with it\'s curved staircase, two-story ceilings, and views into the formal dining room. A private office and bedroom suite off the foyer provide convenience of remote working and solitude for guests. Entertaining is easy in the open concept kitchen and great room. The primary suite includes a tray ceiling, and luxurious bath with freestanding tub, large vanity with double sinks, separate shower and huge walk-in closet. Upstairs, you will find a spacious flex-game room and media room, along with three generous bedrooms with full baths!!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S740205 - NORTHGROVE 05, BLOCK 3, LOT 5' ,`LotDesciption` = 'Other,Subdivision Lot' ,`LotSize` = '12850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'NorthGrove' ,`TaxAmount` = '' ,`TaxRate` = '3.21' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344190' WHERE `Matrix_Unique_ID` = '205387513' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '32167895' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979811' ,`Longitude` = '-95.746001' ,`PhotoCount` = '20' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '734522.00' ,`Status` = 'Active' ,`StreetName` = 'Via Santa Caterina' ,`StreetNumber` = '20719' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 32167895 - Built by Toll Brothers, Inc. - Ready Now! ~ New Plan! The Indio Transitional plan offers single-level living at it\'s finest. A split plan with two generous secondary bedrooms and hall bath at the front of the home. A private office with dramatic sloped ceiling and double door entry is perfect for remote work. A sizable guest suite with full bath and walk-in closet is ideal for overnight guests or multi-generational living. Entertaining is easy in the private media room with easy access to the butler\'s pantry for snacks. An open concept great room is overlooked by a chef inspired kitchen and casual dining space. Expand your living space outdoors by opening the multi-slide doors from the great room onto the expanded covered patio. End the day soaking in the freestanding tub in the primary bath!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 38 Blk 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9417' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Other Style' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344190' WHERE `Matrix_Unique_ID` = '206621752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '95066896' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.978895' ,`Longitude` = '-95.746621' ,`PhotoCount` = '24' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '749462.00' ,`Status` = 'Active' ,`StreetName` = 'Via Del Obispo' ,`StreetNumber` = '20719' ,`StreetSuffix` = 'Circle' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 95066896 - Built by Toll Brothers, Inc. - Ready Now! ~ Now open! Our popular Belmore High Plains plan offers single-story living with room for everyone. This amazing home features 4 spacious bedrooms, private media room and additional flex space that could be used for a home office, gym, playroom and beyond. The open concept kitchen comes complete with center island, stainless steel appliances and walk-in pantry. The great room boasts a 17-foot sloped ceiling with electric fireplace and 12-foot multi-slide door the opens to the covered patio, expanding entertaining space. A relaxing primary bedroom includes a spacious walk-in closet and en-suite with freestanding tub, separate shower, double sinks and linen closet. This impressive house is ready for you to call it home.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 20 Blk 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9254' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'AULT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SALYARDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Dunham Pointe' ,`TaxAmount` = '' ,`TaxRate` = '3.47' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344190' WHERE `Matrix_Unique_ID` = '206622040' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '28376592' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.957611' ,`Longitude` = '-95.199689' ,`PhotoCount` = '12' ,`PostalCode` = '77346' ,`RoomCount` = '9' ,`ListPrice` = '599188.00' ,`Status` = 'Active' ,`StreetName` = 'Agogo Woods' ,`StreetNumber` = '16606' ,`StreetSuffix` = 'Way' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 28376592 - Built by Toll Brothers, Inc. - Ready Now! ~ Our Loralai Manor plan offers an abundance of space and function for long-term living. This home is situated on a homesite that backs to easement meaning no rear neighbors. Expand your living space to the outdoors by opening the 12-foot multi-slide doors to the expanded covered patio. The great room features a gas log fireplace for cool evenings. A relaxing primary bedroom with dramatic sloped ceiling and en-suite with dual sinks, soaking tub, large walk-in shower and walk-in closet, is the perfect end to your day. Located in a gated community with resident exclusive amenities, this home has it all.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Toll Brothers, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 1 GROVES SEC 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9020' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '383' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GROVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Groves-Select Collection' ,`TaxAmount` = '' ,`TaxRate` = '3.73' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344190' WHERE `Matrix_Unique_ID` = '206628881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '76306361' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.644255' ,`Longitude` = '-95.027607' ,`PhotoCount` = '30' ,`PostalCode` = '77571' ,`RoomCount` = '10' ,`ListPrice` = '379487.00' ,`Status` = 'Active' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '167' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 76306361 - Built by HistoryMaker Homes - Ready Now! ~ This 5 bedroom, 3 full bathroom, two-story home boasts 9\' ceilings throughout the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42-inch white cabinetry with crown molding, ceramic tile backsplash, granite countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom located on first floor and bathroom with dual sink vanity and oversized shower with separate soaking tub. This home comes with full sod, full irrigation, and covered back patio!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 3 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344190' WHERE `Matrix_Unique_ID` = '206646612' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:00.433' ,`MLSNumber` = '7308402' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.645607' ,`Longitude` = '-95.027909' ,`PhotoCount` = '50' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '370706.00' ,`Status` = 'Active' ,`StreetName` = 'Majestic' ,`StreetNumber` = '158' ,`StreetSuffix` = 'Shores' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 7308402 - Built by HistoryMaker Homes - Ready Now! ~ Enjoy all 2400+ square feet of this 4 bed, 2.5 bath, 3 car garage home built on cul-de-sac lot. This home’s 9’ ceilings throughout the first floor adds to the open feel of this floor plan. You’ll love spending time in the kitchen, where you’ll find 42” cabinets with crown molding, quartz countertops, a large island, and stainless steel appliances. When you’re not enjoying the kitchen or the primary suite’s separate shower and tub and double vanity with second sink, take advantage of this home’s second floor game room and create the relaxation space you’ve always wanted. The covered back patio offers another spot that’s perfect for entertaining and enjoying your spacious backyard!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6053' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344191' WHERE `Matrix_Unique_ID` = '206916780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:51:27.797' ,`MLSNumber` = '77331631' ,`ListAgentFullName` = 'Rusty Shannon' ,`ListOfficeName` = 'Patti Shannon Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.506432' ,`Longitude` = '-95.177706' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '12' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Butler' ,`StreetNumber` = '2004' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3559' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pilots! Your opportunity to purchase a 2 story, metal roofed home & hangar that has never flooded, w/ a Beautiful pool & hot tub, on the Gorgeous Aviation Polly Ranch Estates runway. Close to dining & shopping - close to Houston & a very Active flying Community. This 1981 built home sits on .5510 acres with a 2500 sq ft, well lighted, Aircraft Hangar complete with a 45 ft x 14 high Bi-Fold Wilson Hangar Door, an automatic RV roll up door at 10Wx12H, a full bath & air conditioned pilot lounge, & concrete ramp with multiple tie downs. The Airport Identifier is 7XS0 & has a well maintained 2,700 ft asphalt, lighted 11/29 runway. This home has all of the traditional features from its era like a Formal Living & Formal Dining. A separate Family room with a gas log fireplace for comfort. Large primary bedroom & bath are down while the other 3 bedrooms are up. Huge Gameroom with half bath above the garage. Relax on the rear patio while the grand children swim. #SearchTexasAirparks' ,`Acres` = '0.551' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 151 PAGE 11 LOT 116 POLLY RANCH ESTATES REPLAT' ,`LotDesciption` = 'Airpark,Subdivision Lot' ,`LotSize` = '24000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Polly Ranch Estates Rep' ,`TaxAmount` = '10448' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344191' WHERE `Matrix_Unique_ID` = '207751795' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:26:58.913' ,`MLSNumber` = '84062092' ,`ListAgentFullName` = 'Sonia Tersigne' ,`ListOfficeName` = 'Greenwood King Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.695002' ,`Longitude` = '-95.422170' ,`PhotoCount` = '48' ,`PostalCode` = '77025' ,`RoomCount` = '13' ,`ListPrice` = '915000.00' ,`Status` = 'Active' ,`StreetName` = 'Serenity' ,`StreetNumber` = '8011' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely custom built home located in a small enclave of 8 lots on a cul de sac. Beautiful entry with spacious private study(or bedroom), engineered hardwood floors. Large living area is wired for surround sound and wall mounted TV, stone fireplace, views out to the back covered porch and pool sized yard. The kitchen has beautiful offset tile floors, granite counters, island with 2nd sink, custom cabinets, stainless steel appliances, gas range, double ovens and is open up to the large dining room with tray ceiling and crown moldings with access to covered porch. 3 beds, 2 baths up with a large landing for exercise area or additional TV area or study. Large primary bedroom & bath with separate soaking tub, separate shower 2 closets and large terrace. Extra storage on garage level, plumbed for sauna and water softner. Close proximity to the Medical Center, Rice Village, Rice University, The Rice School and shopping and restaurants. Gated community underway. All per seller' ,`Acres` = '0.1545' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 BRAESWOOD ESTATES AMEND' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6729' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Built Up,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Braeswood Estates' ,`TaxAmount` = '15169' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344191' WHERE `Matrix_Unique_ID` = '207841473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:12:38.333' ,`MLSNumber` = '56183100' ,`ListAgentFullName` = 'Ann Singleton' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.783196' ,`Longitude` = '-95.372804' ,`PhotoCount` = '31' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '998000.00' ,`Status` = 'Active' ,`StreetName` = 'Vieux Carre' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3065' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully appointed single family home in gated community of Woodland Heights zoned to Travis Elementary with numerous recent updates. New roof (2021); ELEVATOR; new paint throughout; new Italian porcelain tile throughout first floor; new sea grass rug in primary bedroom and third floor secondary bedroom; new shower in primary bath; new 3rd floor HVAC and duct work; hardwood floors refinished; mini split in garage with new wood treatment on garage door; new whole house dehumidifier; gourmet kitchen with Wolf & SubZero appliances; first floor bedroom has Murphy bed and patio doors leading to private back yard with fountain; fantastic location across the street from Woodland park and tennis courts.' ,`Acres` = '0.0775' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Heat Pump,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 WOODLAND PARK PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodland Park Place' ,`TaxAmount` = '13625' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344191' WHERE `Matrix_Unique_ID` = '210007337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:22:51.020' ,`MLSNumber` = '89647766' ,`ListAgentFullName` = 'Aura Pou' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748663' ,`Longitude` = '-95.638254' ,`PhotoCount` = '35' ,`PostalCode` = '77077' ,`RoomCount` = '10' ,`ListPrice` = '1157000.00' ,`Status` = 'Active' ,`StreetName` = 'Flower Garden' ,`StreetNumber` = '1919' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous traditional home located in pristine gated community of Lakes of Parkway. This coveted community has 24 hr manned controlled access for your privacy and security and is zoned to top rated schools. Enjoy the resort style amenities and expansive lakes throughout. Across from one of these beautiful lakes you’ll find this immaculately kept home nestled on it’s gorgeous curved driveway. Immediately, you’ll fall in love with the upgraded real wood garage door to your three car garage. Inside, you’ll love the hardwood floors, large office, two downstairs bedrooms, each with en suite bathrooms and personal access to the backyard oasis. Notice the living room pool view and imagine yourself enjoying your heated pool year round! The kitchen is a dream with two pantries, extra cabinets, and ample cooking space. Upstairs, you’ll find expansive bedrooms and the very generous game room & family retreat. Let’s not forget the tiled balcony from which you’ll enjoy your evenings!' ,`Acres` = '0.2009' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 LAKES OF PARKWAY SEC 19 AMEND NO 1' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Photos/No Videos,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean,Traditional' ,`Subdivision` = 'Lakes of Parkway Sec 19 Amd' ,`TaxAmount` = '17906' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344191' WHERE `Matrix_Unique_ID` = '211136328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:33:15.637' ,`MLSNumber` = '47258441' ,`ListAgentFullName` = 'Frosy Trapezountios-Graf' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = 'Liana Sierra' ,`SellingOfficeName` = 'W & G Realty, LLC' ,`Latitude` = '29.608630' ,`Longitude` = '-95.628638' ,`PhotoCount` = '45' ,`PostalCode` = '77478' ,`RoomCount` = '6' ,`ListPrice` = '747000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Enclave' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Terrace' ,`City` = 'Sugar Land' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury Mediterranean Home with a PRIVATE POOL and entertainer\'s backyard in the Prestigious GATED COMMUNITY of Enclave at Lake Pointe. From the moment you enter the double doors, you will fall in love with the meticulously upgraded and bright OPEN FLOOR PLAN. Step on these gorgeous high-end engineering WOOD FLOORING, high ceilings, custom shutters, and a stone fireplace. Your inner chef will be inspired in the spacious kitchen offering HIGH-END GE MONOGRAM SS appliances, including a 4-burner gas cooktop with pot filler & griller, built-in refrigerator, and upgraded granite counters. The picturesque backyard is an entertainer\'s paradise where you can create lifetime memories while enjoying the sparkling custom pool and spa. The first floor has a full bathroom and a Study with built-in and a closet that can also serve as a 5th bedroom. The location provides access to top-rated schools, shopping, freeways, and more. Primary room on 2nd floor. One bedroom down being used as a study.' ,`Acres` = '0.1434' ,`Area` = '29' ,`BuilderName` = 'ZK HOMES' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'THE ENCLAVE AT LAKE POINTE, BLOCK 4, LOT 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HIGHLANDS ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Mediterranean' ,`Subdivision` = 'The Enclave At Lake Pointe' ,`TaxAmount` = '13270' ,`TaxRate` = '2.3084' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344191' WHERE `Matrix_Unique_ID` = '211150551' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:40:35.270' ,`MLSNumber` = '78915344' ,`ListAgentFullName` = 'Brian Covault' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771136' ,`Longitude` = '-95.757403' ,`PhotoCount` = '23' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '317000.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron Parkway' ,`StreetNumber` = '22215' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'REDUCED! This house is updated from top to bottom. The remodeled kitchen boasts luxurious quartz counter tops with subway tile and freshly painted cabinets. Both bathrooms have been remodeled with custom tile work and brand-new vanities. Fresh paint throughout the house on the walls, ceilings, and trim. Enjoy new tile floors in the foyer, kitchen, and bathrooms, premium laminate flooring in the living areas as well as the primary bedroom plus new carpet in the secondary bedrooms. The laundry room is inside, in addition to ample storage space. Relax on your covered patio and enjoy outdoor activities in your oversized backyard. Recent HVAC replacement, roof covering replaced in 2015, vinyl siding for low maintenance, and double pane windows for High Energy efficiency. Zoned to highly acclaimed Katy ISD and close to tons of dining and shopping. Don\'t miss this one, and schedule your showing today!' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CIMARRON SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cimarron' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344192' WHERE `Matrix_Unique_ID` = '211448348' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:02:26.977' ,`MLSNumber` = '4583676' ,`ListAgentFullName` = 'Linda Treadway' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.605841' ,`Longitude` = '-95.302430' ,`PhotoCount` = '30' ,`PostalCode` = '77048' ,`RoomCount` = '14' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Cortenridge' ,`StreetNumber` = '6819' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Double-paned windows, brick & cement-board siding, a dual-zoned a/c, newer roof, and solar panels make this home the ultimate in energy efficiency! Panels will be paid off and can be transferred to you at closing! This large 2-story home has 4 bedrooms, 3 baths, a huge kitchen, office, a stunning game room, living, dining, and indoor utility room. Flooring, lighting, cabinets, knobs, and faucets have been updated throughout the house. Refrigerator, washer, and dryer are included. Located close to the Medical Center, shopping, parks and entertainment. Price was just dropped so now this home is energy efficient AND affordable!!!' ,`Acres` = '0.1136' ,`Area` = '3' ,`BuilderName` = 'GreenEco Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 SOUTHRIDGE CROSSING SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '319' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MITCHELL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southridge Xing Sec 5' ,`TaxAmount` = '7601' ,`TaxRate` = '3.0707' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1665344192' WHERE `Matrix_Unique_ID` = '211493679' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:00:55.017' ,`MLSNumber` = '20405618' ,`ListAgentFullName` = 'Anissa Wilson' ,`ListOfficeName` = 'The Professional Landlords' ,`SellingAgentFullName` = 'Anissa Wilson' ,`SellingOfficeName` = 'The Professional Landlords' ,`Latitude` = '29.657460' ,`Longitude` = '-95.490196' ,`PhotoCount` = '20' ,`PostalCode` = '77035' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bellfort' ,`StreetNumber` = '5810' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely 3bed/2bath home has been renovated and did not flood! Attractive wood flooring and carpet in the bedrooms. It features a large den, updated kitchen with granite counters, backsplash, and electric cooktop. The primary bedroom is spacious and separate from the secondary bedrooms. Other features in this home include archways, accented wall borders, crown molding, and updated light fixtures! This home has a nice sized backyard and is in close proximity to many coveted private schools, HBU, 90, Beltway 8, 59, 610, and is 10 minutes away from the Galleria and Medical Center!' ,`Acres` = '0.2298' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'E 54 FT OF LT 6 & W 23 FT OF LT 7 BLK 179 PARKWEST SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '10010' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '365' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwest Sec 02' ,`TaxAmount` = '6216' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344192' WHERE `Matrix_Unique_ID` = '211663412' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:04:29.967' ,`MLSNumber` = '60533868' ,`ListAgentFullName` = 'Tamintris Robinson' ,`ListOfficeName` = 'Adams Homes Realty, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.436301' ,`Longitude` = '-95.435668' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '4' ,`ListPrice` = '343900.00' ,`Status` = 'Active' ,`StreetName` = 'Whitney Reach' ,`StreetNumber` = '10135' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sierra Vista Community 4 bedroom - 2 bath - 2 car garage, fenced back yard. Tile in all wet areas - Sod in front and back yard along with landscaping. All Applicance are Frigidaire Stainless steel. Tile backsplash \r\nTaxes on CAD are currently for LOT value only!\r\n\r\nHome is move in ready!' ,`Acres` = '0.227' ,`Area` = '5' ,`BuilderName` = 'Adams Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SIERRA VISTA SEC 5 (A0288 HT&BRR) BLK 2 LOT 3' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '9888' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sierra Vista' ,`TaxAmount` = '1690' ,`TaxRate` = '3.606' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344192' WHERE `Matrix_Unique_ID` = '211814925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:22:00.507' ,`MLSNumber` = '75522561' ,`ListAgentFullName` = 'Lourdes Jones' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.076165' ,`Longitude` = '-95.261404' ,`PhotoCount` = '24' ,`PostalCode` = '77365' ,`RoomCount` = '6' ,`ListPrice` = '299700.00' ,`Status` = 'Active' ,`StreetName` = 'Langworth' ,`StreetNumber` = '20840' ,`StreetSuffix` = 'Place' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this stunning KB build in a great location. This 2020 home is in immaculate condition is waiting for your personal touches. Hosting is easy with this open floorplan - Downstairs boasts plenty of open space with a large family room and main living area. The kitchen with upgraded granite countertops, is perfectly placed for everyday use and gatherings. All bedrooms upstairs offers efficient use of space and an additional level of privacy. An additional flex space upstairs can be your home office, play area, or home theatre. Easy access to Hwy 59 and very close to restaurants, shops, entertainment and the IAH airport.' ,`Acres` = '0.1291' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood NW/Oakhurst' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S273107 - BROOKWOOD FOREST 07, BLOCK 3, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '770' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'BROOKWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookwood Forest 07' ,`TaxAmount` = '8716' ,`TaxRate` = '3.6131' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344192' WHERE `Matrix_Unique_ID` = '211997330' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:23:12.310' ,`MLSNumber` = '75275145' ,`ListAgentFullName` = 'Narmeen Hussein' ,`ListOfficeName` = 'AVOREC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018631' ,`Longitude` = '-95.783360' ,`PhotoCount` = '42' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Albany Brook' ,`StreetNumber` = '31122' ,`StreetSuffix` = 'Lane' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2011' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 1.5 story like-new home was built in 2021 and has 3 bedrooms, 2.5 bathrooms. All bedrooms are downstairs with a large bonus room and powder room upstairs, offering plenty of room that can be used for kids to play or as an additional flex space for a game room or media room. The beautiful kitchen is adorned with granite countertops a large granite kitchen island, and a matte stainless steel appliance package (microwave, stove, and refrigerator that is staying with the house). Builder upgrades include upgraded carpet, jacuzzi tub in the primary bathroom, sound system in kitchen, surround sound system and subwoofer upstairs, covered back patio with sound system, pre-wiring for exterior cameras, alarm sensors on windows, and an extra tall custom front door. This home has it all and would make for the perfect place to entertain family and friends.' ,`Acres` = '0.1168' ,`Area` = '35' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 3 DELLROSE SEC 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5089' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Dellrose' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344193' WHERE `Matrix_Unique_ID` = '212234643' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:49:12.513' ,`MLSNumber` = '39412240' ,`ListAgentFullName` = 'Helga Lozano' ,`ListOfficeName` = 'RE/MAX Cinco Ranch' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802436' ,`Longitude` = '-95.353177' ,`PhotoCount` = '23' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Evelyn' ,`StreetNumber` = '1508' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to own a home inside of the 610 Loop in the rapidly developing North Houston area, between I-45 & I-69. With easy access to projects like Hardy Yards & East River, this brand new home, comes with luxurious, yet modern features that you will enjoy from day one! A covered front porch welcomes you into the open floor plan with lots of natural light! The island kitchen, opening to family & dining rooms, has top of the line Calacatta quartz, under cabinet lighting & stainless steel appliances. Dining room with windows to the front of the home and a large family room with windows overseeing the backyard. Powder room on the first floor for your guests convenience. Upstairs, the master bedroom with walk-in closet & fantastic bathroom with dual sinks, large shower and beautiful soaking tub! Two secondary bedrooms, hallway bathroom with dual sinks and laundry area are also upstairs. Backyard is a blank canvas waiting for you to get creative! Washer, dryer and refrigerator incl.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Yellow Foot LLC' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 YELLOW MOON ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3125' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOOSCAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Yellow Moon Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344193' WHERE `Matrix_Unique_ID` = '212447425' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:34:22.127' ,`MLSNumber` = '44293765' ,`ListAgentFullName` = 'Victoria Fernandez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.327195' ,`Longitude` = '-94.942263' ,`PhotoCount` = '31' ,`PostalCode` = '77563' ,`RoomCount` = '11' ,`ListPrice` = '398000.00' ,`Status` = 'Active' ,`StreetName` = 'Barracuda' ,`StreetNumber` = '196' ,`StreetSuffix` = 'Street' ,`City` = 'Bayou Vista' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1847' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy and relax yourself at home, front canal residence. Just renovated beautiful house with new appliances, bonus washer and dryer. New cabinets throughout the house, quartz counters. Upper-level laminated flooring and 2 carpeted bedrooms, 2 full bathrooms. Lower-level tile flooring and 2 additional bedrooms and 1 full bathroom. Plenty of storage space inside and outside. Minutes away from Galveston and shops.\r\nRooms dimensions are approximate.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bayou Vista' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 7 PAGE 7 LOT 196 NEW BAYOU VISTA ADDN 2' ,`LotDesciption` = 'Water View' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'New Bayou Vista 2' ,`TaxAmount` = '5257' ,`TaxRate` = '2.635' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344193' WHERE `Matrix_Unique_ID` = '212706960' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:45:38.560' ,`MLSNumber` = '73576992' ,`ListAgentFullName` = 'Vicky Turnbow' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = 'Azalea Marquez' ,`SellingOfficeName` = 'Texas Premier Realty' ,`Latitude` = '29.929621' ,`Longitude` = '-95.401989' ,`PhotoCount` = '31' ,`PostalCode` = '77060' ,`RoomCount` = '4' ,`ListPrice` = '211000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Sulky Trail' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home features 3 bedrooms 2 bathroom with a den. You will have plenty of space in the living room and you will enjoy the open kitchen concept in this house. The breakfast area is right off the kitchen and leads you to the exterior backyard and covered patio. You will also have extra storage space in your utility shed. All bedroom have great closet space as well as extra closets in the hall. Call to schedule an appointment today.' ,`Acres` = '0.1969' ,`Area` = '34' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 9 IMPERIAL VALLEY SEC 4 R/P' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '8576' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '165' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'ALDINE HIGH SCHOOL' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Valley Sec 04 R/P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344193' WHERE `Matrix_Unique_ID` = '212733677' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:12:28.727' ,`MLSNumber` = '76471293' ,`ListAgentFullName` = 'Brenna Abels' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Diandra Cerda' ,`SellingOfficeName` = 'Sky Real Estate Professionals' ,`Latitude` = '29.989465' ,`Longitude` = '-95.636404' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '10' ,`ListPrice` = '495000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Daubern' ,`StreetNumber` = '14703' ,`StreetSuffix` = 'Court' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedroom, 3/1 bath, 3 car garage David Weekley brick home in the desirable Longwood subdivision. Situated at the end of a cul de sac and shaded by mature trees, this home offers a thoughtfully laid out open floor plan with high ceilings for even more spacial appeal. Updated kitchen w/quartz countertops, SS appliances, island w/cooktop, and large walk in pantry. Additionally, this home offers a large study w/ French doors. The spacious master suite is the perfect owner\'s retreat. Upstairs you will find three additional bedrooms, two remodeled baths, and a large, functional flex/gameroom. Gorgeous views of your backyard oasis from the living room and kitchen. Outside enjoy the sparkling pool/spa with newly resurfaced PebbleTec, color changing lights, new plumbing, equipment, and pool decking. The backyard also offers plenty of room for play and entertaining. Many additional updates. Enjoy all the amenities Longwood has to offer. NO FLOODING!' ,`Acres` = '0.2039' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 LONGWOOD VILLAGE SEC 9' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '8884' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1070' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HAMILTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Longwood Village Sec 09' ,`TaxAmount` = '9252' ,`TaxRate` = '2.4837' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344193' WHERE `Matrix_Unique_ID` = '212752328' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:39:42.683' ,`MLSNumber` = '7862058' ,`ListAgentFullName` = 'Sarah Llanes' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.037343' ,`Longitude` = '-95.420956' ,`PhotoCount` = '22' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodridge' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Crossing' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2272' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 108 Woodridge Crossing in the highly desirable Woodshore Subdivision. A lovely neighborhood with great sidewalks for those evening strolls. This beautiful, fully brick home features 3 bedrooms, 2 bathrooms and a large study with all the upgrades. Enjoy cool mornings with your coffee on the covered back porch with custom roll down shades on each side. Ensuite bath not only has soaker tub but includes a separate walk-in super shower with built in bench. Beautiful double recessed ceiling in the dining room adds elegance to the already 12 ft ceilings throughout the home. Main living area is wired for sound and custom sound system stays. Carpet in main living areas replaced in August 2022. Third car garage bay is a great upgrade to the home providing extra room for storage & leaving a full size garage for all your parking needs. You won\'t want to miss this high quality home!' ,`Acres` = '0.1724' ,`Area` = '5' ,`BuilderName` = 'Castlerock Community' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 2 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'POLK ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore Sec 2 A0066 J E Gro' ,`TaxAmount` = '8470' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344194' WHERE `Matrix_Unique_ID` = '212843359' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:29:16.837' ,`MLSNumber` = '15361305' ,`ListAgentFullName` = 'Ashwin Kewalramani' ,`ListOfficeName` = 'New Age' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.802355' ,`Longitude` = '-95.370388' ,`PhotoCount` = '15' ,`PostalCode` = '77009' ,`RoomCount` = '7' ,`ListPrice` = '409990.00' ,`Status` = 'Active' ,`StreetName` = 'Fisk' ,`StreetNumber` = '4708' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1907' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in Ready - Only 2 Units Left!! Just East of the Heights lies Northside Estates. These modern farmhouses are far from average. Each home has gorgeous finishes including designer tiles, countertops, and hardwood floors throughout. Every part of the floorplan has been thoughtfully designed. The first floor living offers an oversized dry bar along with a perfect work/desk space. The kitchen is a great space for entertaining and is complimented by a large walk in pantry. Making your way up to the the second floor, you are greeted by the primary suite which offers a spa like bathroom including a soaking tub. Both secondary bedrooms are large and share a jack and jill style bathroom. Hardwood floors are included - $5,000 value! All ceiling fans included - $1,000 value! 0% Down programs are available.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Deacon' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 FISK ESTATES IN SHARMAN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '2750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Fisk Estates in Sharman' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344194' WHERE `Matrix_Unique_ID` = '212846490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:40:54.993' ,`MLSNumber` = '74606928' ,`ListAgentFullName` = 'Angelica Teachout' ,`ListOfficeName` = 'Boulevard Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745155' ,`Longitude` = '-95.852550' ,`PhotoCount` = '33' ,`PostalCode` = '77494' ,`RoomCount` = '9' ,`ListPrice` = '529700.00' ,`Status` = 'Active' ,`StreetName` = 'Ember Pass' ,`StreetNumber` = '2730' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 2-story single family home, located in the highly sought-after Cinco Ranch Northwest subdivision! This home showcases 4 beds/3.5 baths, a study, and game room. Upon entry, you are greeted with a dramatic two-story foyer that flows into a spacious light-filled living room with soaring ceilings up to 20ft high, windows galore, fireplace, and floor plan that opens to the kitchen and dining room. Kitchen features a large island, granite countertops, and walk-in pantry. Primary bedroom retreat boasts a tray ceiling, crown molding, plantation shutters, and an ensuite bath with spa tub & separate standing shower. Large game room overlooks family area and additional flex space! Prime location and conveniently located near shopping, restaurants with easy access to I-10. Perfect house for entertaining equipped with covered patio.' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'Trendmaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cinco Ranch Northwest Sec 12, BLOCK 1, Lot 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6673' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'JENKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Other Style,Traditional' ,`Subdivision` = 'Cinco Ranch Northwest' ,`TaxAmount` = '11354' ,`TaxRate` = '2.75' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344194' WHERE `Matrix_Unique_ID` = '212851590' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:55:33.160' ,`MLSNumber` = '87840787' ,`ListAgentFullName` = 'Robin Hines' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.654776' ,`Longitude` = '-95.931839' ,`PhotoCount` = '49' ,`PostalCode` = '77441' ,`RoomCount` = '13' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Westerdale' ,`StreetNumber` = '3707' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '3' ,`BedsTotal` = '3' ,`SqFtTotal` = '4079' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to one of the most breathtaking homes in coveted Weston Lakes! Over 4000 square feet, and situated on over an acre of beautiful landscaping, this is the home you\'ve been waiting for! Custom formals, elegant kitchen, spacious den, bedrooms with a Hollywood bath and a generous flex room grace the first floor. Upstairs is the alluring master bedroom, luxury bath and a theatre or game room for you to enjoy. The balcony off the master bedroom is waiting for your morning coffee or tea. Opulent living in gated Weston Lakes, Welcome Home!' ,`Acres` = '1.094' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERWOOD FOREST AT WESTON LAKES SEC 1, BLOCK 6, LOT 18, ACR' ,`LotDesciption` = 'In Golf Course Community' ,`LotSize` = '47655' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Riverwood Forest At Weston Lakes Sec 1' ,`TaxAmount` = '9614' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344194' WHERE `Matrix_Unique_ID` = '212952574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:52:52.240' ,`MLSNumber` = '80229337' ,`ListAgentFullName` = 'Margie Poole' ,`ListOfficeName` = 'Poole Realty Group' ,`SellingAgentFullName` = 'Samantha Sloan' ,`SellingOfficeName` = 'The Texas Living Real Estate G' ,`Latitude` = '30.051852' ,`Longitude` = '-94.892270' ,`PhotoCount` = '15' ,`PostalCode` = '77535' ,`RoomCount` = '5' ,`ListPrice` = '129000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Rosewood' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Street' ,`City` = 'Dayton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unpack And Move-Into This Darling Two Bedroom One Bath Home With A Fully Fenced Backyard, Storage Shed And A Covered Back Patio! This Home Has Recently Been Painted In A Neutral Color Scheme And Has New Laminate Flooring Throughout. Other Interior Features Include Updated Bathroom, Eat-In Kitchen And Spacious Bedrooms. This Home Has Pex Plumbing, Windows That Have All Been Replaced, Hardi Board Exterior, Updated Exterior Electric Meter And A New Roof Installed In 2019. This Home Is Close To Schools, Shopping, Churches And Restaurants!' ,`Acres` = '0.1056' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Dayton' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'FRIEDMAN-BLK 6, LOT PT 12 (N/92\'), ACRES .1056' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '74 - Dayton' ,`SchoolElementary` = 'RICHTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAYTON HIGH SCHOOL' ,`SchoolMiddle` = 'WOODROW WILSON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Friedman-Blk 6' ,`TaxAmount` = '1591' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344194' WHERE `Matrix_Unique_ID` = '213025286' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:46:36.420' ,`MLSNumber` = '34960117' ,`ListAgentFullName` = 'Kathryn Nelson' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.219838' ,`Longitude` = '-95.515856' ,`PhotoCount` = '20' ,`PostalCode` = '77382' ,`RoomCount` = '10' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = 'York Gate' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Court' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a POOL and play area in the same big back yard? The recently resurfaced pool sits on a huge (10,317 sf), wooded, corner lot of an “eyebrow” culdesac off of a culdesac street * numerous replacements include: roof in 2014 w/upgraded underlayment; in 2017: rear fencing (6’6”) and new gates, water heater and downstairs 16 SEER a/c & furnace; in 2019: steel back door and laminate flooring downstairs & on the stairs; in 2021: upstairs 16 SEER a/c & furnace, dishwasher, wall oven, and garage door springs; and in 2022, pool resurface * new microwave on order & will be installed week of 10/10/22 * home has 4 bedrooms (w/primary down) and gameroom up * owners just finished installing LED recessed can lights and other handyman projects *' ,`Acres` = '0.2368' ,`Area` = '15' ,`BuilderName` = 'Ryland' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 19, BLOCK 2, LOT 19' ,`LotDesciption` = 'Corner,Cul-De-Sac,Wooded' ,`LotSize` = '10317' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 19' ,`TaxAmount` = '7249' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344194' WHERE `Matrix_Unique_ID` = '213207350' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:47:06.627' ,`MLSNumber` = '20773563' ,`ListAgentFullName` = 'Rizwan Adenwalla' ,`ListOfficeName` = 'Welcome Home Residential, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.668091' ,`Longitude` = '-95.596048' ,`PhotoCount` = '21' ,`PostalCode` = '77099' ,`RoomCount` = '5' ,`ListPrice` = '189500.00' ,`Status` = 'Active' ,`StreetName` = 'Creekhurst' ,`StreetNumber` = '12135' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1675' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice three bedroom starter home or investment property, Has a covered patio and nice size backyard. Needs some TLC, selling as is. Very close to Hwy 59 and beltway 8.' ,`Acres` = '0.1729' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 7 HUNTINGTON VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7533' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'HOLUB MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Huntington Village Sec 01' ,`TaxAmount` = '3817' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344195' WHERE `Matrix_Unique_ID` = '213212754' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213220040','1665344195','213220040','2022-10-08T22:04:23.413','77919401','Manoj Mehta','eXp Realty, LLC','','','30.052900','-95.381707','28','77373','6','325000.00','Active','Barberry Creek','23406','Trail','Spring','3','0','4','2090','Single-Family','Lightly lived in 4 bedroom home close to Hardy Tollway and i45 for an easy commute. The main living has vinyl laminate and carpeted floors, light paint, and LED lighting throughout. Kitchen with stainless steel appliances included, a spacious walk-in pantry, and an island with a double sink. First-floor primary bedroom with an en-suite bath and walk-in closet. Guest suite with full bath also on the first floor. Second floor with central game room, two secondary bedrooms, and a full bath. Fully fenced backyard and covered patio perfect for kids, pets, family, and friends. Two-car garage. This home is a great location close to all many major highways to commute anywhere in the Houston area. Minutes from shopping and retail. Don\'t miss out on the opportunity to live in this fabulous home!','0.132','12','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','','','','Spring East','Central Gas','1','LT 14 BLK 4 BRECKENRIDGE WEST SEC 6','Subdivision Lot','5750','Appraisal District','','475','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','GLORIA MARSHALL ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Appointment Required,Lockbox Back,Supra Keybox','Appraisal District','2','Traditional','Breckenridge West Sec 6','573','3.0268','Water District','2022','Builder'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:39:30.940' ,`MLSNumber` = '12705242' ,`ListAgentFullName` = 'Christy Broussard' ,`ListOfficeName` = 'Crystal Beach Club Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.442054' ,`Longitude` = '-94.656568' ,`PhotoCount` = '21' ,`PostalCode` = '77650' ,`RoomCount` = '3' ,`ListPrice` = '505000.00' ,`Status` = 'Active' ,`StreetName` = 'Buell' ,`StreetNumber` = '889' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1290' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful beach home comes entirely furnished. Newly renovated, featuring three bedrooms and two full baths this home has 1300 sq ft. Nice, open kitchen and living area. Tile flooring throughout. Large deck to enjoy the breeze. Located on a beach access road and just a short golf cart ride away. This home will make a great rental investment or a lovely family vacation getaway.' ,`Acres` = '0.0918' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 3 CLOON SUB #1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cloon Sub 1' ,`TaxAmount` = '4593' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344195' WHERE `Matrix_Unique_ID` = '213291189' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:33:47.600' ,`MLSNumber` = '22985150' ,`ListAgentFullName` = 'Brenda Quiroga' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209969' ,`Longitude` = '-95.533083' ,`PhotoCount` = '24' ,`PostalCode` = '77382' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Auburn Path' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Drive' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic one story home located on a private street less than 1 mile from Alden Bridge Shopping Center. Great open floor plan with high ceilings and an abundance of windows offering plenty of natural light. Formal dining currently used as a study/office. Kitchen and breakfast area open to family room making this home ideal for entertaining. Atrium off breakfast area is perfect for plants lovers. Large family room has built in bookshelves, tv/audio component cabinet, flush mount ceiling surround sound speakers and gas log fireplace. Tile flooring throughout and carpet in bedrooms only. Large primary bedroom has vaulted ceiling, over sized windows and walk in closet. Primary bathroom has another walk in closet, double vanities plus separate tub & shower. Ceiling fans in all bedrooms. Updates include indoor/outdoor paint in 2020. Roof replaced in 2014, AC replaced in 2015 & new water heater in 2017. Full sprinkler system. Walk/bike to shopping center, Lakeside Park & Buckalew Elementary.' ,`Acres` = '0.132' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL ALDEN BR 47, BLOCK 1, LOT 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BUCKALEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Alden Br 47' ,`TaxAmount` = '5420' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344195' WHERE `Matrix_Unique_ID` = '213331076' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T23:15:28.507' ,`MLSNumber` = '60280779' ,`ListAgentFullName` = 'Sheryle Campbell' ,`ListOfficeName` = 'Energy Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708392' ,`Longitude` = '-95.406608' ,`PhotoCount` = '43' ,`PostalCode` = '77030' ,`RoomCount` = '10' ,`ListPrice` = '1997000.00' ,`Status` = 'Active' ,`StreetName` = 'McClendon' ,`StreetNumber` = '2031' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5119' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MODERN LUXURY at it\'s finest can be found in this Custom New Construction in the established Southgate community. Walking distance to the Medical Center and Rice University, this fabulous entertaining home offers over 5100 sf of living space with a bright OPEN FLOOR PLAN accented by 11 foot ceilings and MODERN FINISHES constructed with an impressive attention to detail. Quality construction starts with the PIER & BEAM foundation elevated 4 feet above ground & a gorgeous stone exterior with black framed double pane windows. The stunning exterior offers just a glimpse of the luxurious detailing found inside, including the wide plank wood floors that flow continuously throughout the downstairs & upstairs. A gourmet island kitchen boasts QUARTZ COUNTERS and top-of-the-line Dacor appliances, including a built-in refrigerator. This two-story home is elevator capable with 4 bedrooms and 4 ensuite bathrooms upstairs. An expansive covered patio with outdoor kitchen and room for pool.' ,`Acres` = '0.1446' ,`Area` = '17' ,`BuilderName` = 'NRR COnstruction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 3 BLK 6 SOUTHGATE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Southgate' ,`TaxAmount` = '12628' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344195' WHERE `Matrix_Unique_ID` = '213378663' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T22:30:49.823' ,`MLSNumber` = '45701318' ,`ListAgentFullName` = 'Mehmet Yasar' ,`ListOfficeName` = 'Texas Real Estate Services LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059242' ,`Longitude` = '-95.403793' ,`PhotoCount` = '23' ,`PostalCode` = '77373' ,`RoomCount` = '3' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Raindrop Poppy' ,`StreetNumber` = '24434' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home with spacious 3 bedrooms 2.5 bath, plus dining area house! Living room is big enough to entertain whole family with open concept kitchen! Two car garage with epoxy floor! There are no back neighbors as this home backs into a green belt, cul-de-sac home .The master bedroom is spacious enough to fit king size beds as well as the closet. It is close to major highways such as Hardy toll, 99 and I-45! Close Old Spring Town, The Woodlands mall and many restaurants!' ,`Acres` = '0.1528' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 1 PARK SPRING SEC 7' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6657' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'PARK SPRING' ,`TaxAmount` = '5638' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344195' WHERE `Matrix_Unique_ID` = '213397689' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213450618','1665344196','213450618','2022-10-08T23:11:10.153','22368855','Nancy Quintanilla','Galere Realty','','','30.014737','-95.318345','35','77338','12','265000.00','Active','Maple Fox','7002','Drive','Humble','2','0','4','1778','Single-Family','Great Home with 2 Living Areas, Formal Dining, Open design flow from the Kitchen to Breakfast area, and Family Room. Many renovations completed in the past couple of years. The kitchen has Granite Counters. The backyard is perfect for entertaining and is designed to be low maintenance. Home Appliances to stay This property is conveniently located to IAH, Woodlands, and Downtown. This is home is a must-see!!!','0.1584','12','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Humble Area West','Central Gas','1','LT 13 BLK 3 FOXWOOD SEC 2','Cul-De-Sac','6900','Appraisal District','','400','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','1 - Aldine','CYPRESSWOOD ELEMENTARY SCHOOL (ALDINE)','NIMITZ HIGH SCHOOL (ALDINE)','JONES MIDDLE SCHOOL (ALDINE)','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Foxwood','4511','2.7734','Water District','1977','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213458648','1665344196','213458648','2022-10-08T22:38:55.197','93000466','Darrell Page','Purple Shirt Realty','','','29.548979','-95.489372','27','77545','7','325000.00','Active','Alcove Foster','2414','Court','Fresno','2','0','3','2053','Single-Family','Charming and spacious one-story home with fantastic functional layout. Neutral colors and wood look floors in the main areas, tile in the wet areas and carpet in the bedrooms. Book a tour with your real estate agent today and feel right at home! Conveniently located with easy access to Fort Bend Toll Road, FM 521 and Highway 6. This location gives you the amenities of Sugarland and Pearland with its central location. This beautiful open concept home includes a formal dining room, large family room, breakfast nook, 3 bedrooms and a study with glass double-doors. Upgraded quartz countertop in kitchen area. This one is a winner just waiting for you to come add your own touches and make it your own.','0.1292','38','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Missouri City Area','Central Gas','1','WINFIELD LAKES SEC 16, BLOCK 1, LOT 24','Cul-De-Sac,Subdivision Lot','5626','Appraisal District','','500','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','19 - Fort Bend','PARKS ELEMENTARY SCHOOL (FORT BEND)','HIGHTOWER HIGH SCHOOL','LAKE OLYMPIA MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','1','Contemporary/Modern','Winfield Lakes Sec 16','5815','3.0229','Public Sewer,Public Water','2008','Appraisal District'); --> New record created successfully